Product: Dynamics 365 Business Central
Error: You have insufficient quantity of Item xxxxx on inventory
Issue: When attempting to export out an inbound Warehouse Shipping Advice (945) from your Trading Partner -you receive the error: 'You have insufficient quantity of Item xxxxx on inventory'
Reason: Within Dynamics 365 Business Central the item being reported is being reported by Dynamics 365 Business Central as not having enough quantity to satisify the amount being sent on the Warehouse Shipping Advice.
Transaction Manager - Integration Activity
Solution - Check Quantity on Hand
You'll need to check the Item No. being referenced by the error message and confirm that the Quantity on Hand field within your Item Card is a positive value, and a value greater than what the Warehouse Shipping Advice is sending
Navigate: Items → (Item) → Inventory group
Review: Quantity on Hand
Dynamics Business Central 365 - Item Card
Solution - Check Location Code
If you believe your Quantity on Hand within Dynamics Business Central 365 to be more than enough for your Sales Order to take from in order to generate your Shipment - you might want to check to ensure that the Location Code being sent on your Warehouse Shipping Advice.
Ensure that not only is this the correct Location (as an incorrect location can result in pulling an incorrect available amount) but ensure that your Item Inventory has enough specifically for the Location being sent, not just the overall quantity. As the system will need to pull the amount for your specific Location.
Search: Items by Location
Check: Location Availability
Search - Items by Location
Dynamics 365 Business Central - Items by Location
Additional Assistance
While TrueCommerce can provide some general guidelines for you - TrueCommerce does not maintain your Inventory nor its availability. The TrueCommerce integration simply requests the Inventory based on the Item Code and the Location Code provided.
If an insufficient quantity error occurs - TrueCommerce is unable to do anything beyond just verifying the data being sent is correct according to the Warehouse Shipping Advice.
For additional troubleshooting please refer to your VAR to ensure proper quantity is available based on the provided information.
rev 1/12/2023