Sage 100

I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?

I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Can a VI job be setup to total a column on your source file? For example if importing cash receipts I have a column in my source file pointing to the Line Amount Posted and I want the job to sum up that column by customer and put the amount in the Header…

Hello! I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store. They were previously using MAS90 when we had first looked into it, but between that…

Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…