How to resolve web api message "Check code not defined in bank initialization file."

Question

Trying to create a new A/R Customer via the Sage 300 Web API. I'm getting a Status Code 409 "Conflict" with a message of "Check code not defined in bank initialization file." 
 What property on ARCustomer object do I need to set? There's no CheckCode property. 
 Or can this be defaulted in the Bank Services? If yes, where is it done in Sage 300 interface? 
 Thanks, Gary.

Accsys Consulting AU · Accepted Answer

Hi GaryF the way I solve these problems is to do a File -> Export to Excel for an existing customer, then place an underscore "_" at the beginning of the columns I think I don't need to disable them (Sage 300 ignores columns with mismatched names) until I have a working import with the minimum number of columns possible. I then use this import template as my gold standard for what I need to include in my JSON packet for the API, fiddling in Postman until I get the import right, then you can port that knowledge to your API call for the integration you're writing. The error message may or may not be accurate (see https://sageaom.kcsvar.com/AOM2022/ARCUS.xml - thanks Kerr Consulting) - if it is, it could be PAYMCODE (Payment Code) is invalid, could be CODECHECK (Check Language) ensuring in Bank Services the Bank has the matching Check Language set, it could be a bad payment code or bank code under the Customer Group trying to set a default value. So instead of fighting it out one field at a time, this is why I tend to export a customer, disable columns, then try importing it until I have created the most efficient import file that works. Wait I just had an idea that might save you time . In your Sage 300 Shared Data directory on your Sage 300 server, there will be a folder called ImportTemplates where Sage places factory import templates with the columns/fields you need for successful imports/inserts. Compare the columns and sample data in ARCustomer1.xlsx to what you've got in your json packet. If your config is too unique for this to help, revert back to exporting, refining, importing. Good luck!

Sage 300

How to resolve web api message "Check code not defined in bank initialization file."

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING