We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium on our test server we noticed an issue.
When creating invoices, one of the fields specified is the Customer Number field (CustomerNo$). We use the following line of code to set the CustomerNo field. (the CustomerNo displayed in Mas90 is "0000001").
ProvideXObject.InvokeMethod(this.Object, "nSetValue", CustomerNo$, 0000001);
We're getting the following error...
CI_NOF: 0000001 is not on file
I looked at the database and noticed the CustomerNo is "01" so I tried that value - same result. I noticed it has an ARDivisionNo of "00" so I tried "0001" - same result. I also tried these same values after adding AR Divisions. No difference.
Any idea why this is not working? I'm curious why this would work fine in Advanced but not in Premium.
Thanks for any help you can provide.