Product: Microsoft Dynamics 365 Business Central
Error: Error: Order xxx|Item xxx not found, or Line No. xxx not matched.
Issue: Whenever attempting to export out a Purchase Order Acknowledgement (855) or a Warehouse Shipping Advice (945) to Dynamics 365 Business Central you receive an error message indicating 'Order xxx|Item xxx not found, or Line No. xxx not matched.'
Reason: The Item Code being passed to Dynamics 365 Business Central does not match any item on the Sales Order being referenced within the system.
Solution - Update the Primary Item Field
If the Item Code being listed within your error message is not your Dynamics 365 Business Central item code - you will need to adjust the value being sent out on your transaction.
By default the system will attempt to export out the field assigned to your Primary Item Field as your main item code. You can adjust which field on the transaction is used for the Item Number within Transaction Manager.
Navigate: Trading Partners → (Trading Partner) → Preferences → Transactions
Select: Translations
Find: Your Transaction Type
Set: Primary Item Field
This dropdown should be set to the field within your Transaction that carries your Business Central item code.
Solution - Translate the Item Code
If your Trading Partner is not passing the Item Code on your received transaction - you can translate their Item Code utilizing the Item Catalog from your Trading' Partners code into Dynamics 365 Business Central's item code.
Navigate: Trading Partners → (Partner) → Translations → Item Catalog
Add: Item Translation with your Business Central Item Code
Add: Primary Item Field (2nd column) value being sent by Trading Partner
Solution - Correct Line Number
If the Item Code being passed is correct, but the Line Number being listed does not match the Item's Line Number within Dynamics 365 Business Central the system will not be able to match the proper line in order to modify it.
You will need to contact your Trading Partner to correct the line number and have them resend.
rev 8/27/2024