Product: Dynamics 365 Business Central
Article Link:
Error: The quantity to invoice does not match the quantity defined in item tracking.
Issue: Whenever attempting to export out an inbound Warehouse Shipping Advice (945) from your Trading Partner you receive the following error: 'The quantity to invoice does not match the quantity defined in item tracking.'
Reason: The quantity attached to your Lots is less than the total quantity of the Item.
Transaction Manager - Integration Activity
Solution - Confirm Lot vs Item Quantity
Whenever you receive a Warehouse Shipping Advice from your Warehouse/3PL you can often have Lot information attached to your Items as splitting the item up into separate lots helps distribute the quantity amount of the item being shipped.
Sometimes the Warehouse/3PL may send less quantity (combined across all lots) at the Lot level than what they marked for that individual item. You'll want to make sure the amounts match.
Transaction Manager - Item vs Lot Quantity
Solution - Confirm Data being Exported
Sometimes modifications to the Integration Layer for custom logic can interfere with the amounts being sent over - if you've had customizations done to your Warehouse Shipping Advice it's a good idea to grab a cloud log and to check the ExportTransactions() REQ xml to ensure that the Item is correctly passing all Lots with a proper quantity that sums up to the Item's qtyToShip node.
If your Lots do not equal to the same amount as your qtyToShip under the Item node the system will throw the above error
Related Articles
rev 1/12/2023