FBDI Load for Inventory Adjustment- Enable Error Message for Wrong Quantity
Summary: Our client has raised an issue related to FBDI load for Inventory adjustment. User tried to load the quantity with comma and it ended up loading quantity into fusion with decimals. For example, the quantity loaded was 1,260 however inventory adjustment happened for 1.26. Client is raising a question that before loading the FBDI, user should see an error message if the quantity being loaded is different than the one present in the FBDI file. Please suggest if there is a solution for the user to verify the quantity being loaded into Fusion to avoid incorrect quantity load into Fusion.
After changing the cell format to General (which removes commas), the quantity gets loaded to Fusion. However, the requirement here is for a solution wherein user can get an error message if there is a discrepancy between the quantity being loaded through FBDI versus the quantity getting loaded. Or, please suggest any other option.