Product: Dynamics 365 Business Central

Article Link: http://help.truecommerce.com/en/articles/6887635-dynamics-business-central-365-error-lot-quantity-exceeded-the-quantity-of-item-xxxxx

Error: Lot quantity exceeded the quantity of item xxxxx

Issue: Whenever attempting to export out an inbound Warehouse Shipping Advice (945) from your Trading Partner you receive the following error: 'Lot quantity exceeded the quantity of item xxxxx'

Reason: The quantity attached to your Lots is greater than the total quantity of the Item.

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 more 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.

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 the lots exceed the amount of the Item you will receive errors.

Note: If you do not have all accounted for Lots - you may experience issues with the system thinking your quantity to invoice does not match quantity expected. You will want to submit a Support Ticket to have this corrected.

rev 1/12/2023