Customer is encountering an error in CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX.
Solution: Perform CSV Import by following the steps and field mapping below:
Setup > Import/Export > Import CSV Records
Import Type = Transactions
Record Type = Cash Sale
Data handling: Update
Map the following fields:
Document Number = Cash Sale: Sale #
Amount = Cash Sale Items: Amount
Item = Cash Sale Items: Item
Quantity = Cash Sale Items: Quantity
Units = Cash Sale Items: Units
Issue Inventory Number = Cash Sale Items-Inventory Detail: Inventory Assignment Internal ID.
Issue Detail Quantity = Cash Sale Items-Inventory Detail: Quantity
Rename Import Name
Click Save and Run.
Note: Make sure that the Cash Sale Items-Inventory Issue Inventory Number is mapped correctly.