Product: Sage 100

Article Link: http://help.truecommerce.com/en/articles/7924865-sage-100-error-xxx-is-not-on-file-fieldname-shiptocode-value-xxx

Error: xxxis not on file. (FieldName: ShipToCode$ Value: xxx)

Issue: When attempting to export out a Purchase Order (850) from your Trading Partner within the inbox of Transaction Manager - you receive the error: 'xxx is not on file. (FieldName: ShipToCode$ Value: xxx)'

Reason: The value provided by your Trading Partner is not a valid Ship-To code for this particular customer within Sage 100

Navigate: Accounts Receivable → Customer Maintenance → Ship To Address

Add: New Ship-To Code

If the code that your Trading Partner has sent you does not match what you need to have within your Sage 100 system - you can use the Address List within Transaction Manager to translate the value automatically to your Sage 100 code.

Navigate: Trading Partners → (Partner Name) → Translations → Address List

Select: Add

Enter: EDI Code (Trading Partner)

Enter: Bus Sys Code (Sage 100)

rev 5/19/2023