Sage 300

Are ICPRIC and ICCPUR accessible via the Sage API? If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?

Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

Is there a way to look at AR detail data and "walk it back" to the original OE detail line? We have a reporting requirement that would need us to do this.

Hello there! I need to add new Orders Entry through code. Everything is working fine, but now I need to add some Misc Item to new Orders Entry. I can successfully create new Orders, but my Misc Item Extended Cost(EXTINVMISC) is always set at zero. I…

In previous version, we look in table SIAUD to see any changes the customer has made to Items. I notice this table is not in Sage 300 2014. Does anyone know why that is, and if they are now using different tables to log this information?

Only from one workstation getting this error message " Cannot access database (error=49153)". ERP Database setup is server not ODBC. All other machines are connecting without any issue. Only one system is giving this error. And this system has Sage Peachtree…