Sage 100

Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

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…

My client imports SO Invoices, and would like to calculate the quantity of one line based on the running total of the other lines, and then assign that quantity to the item line. Here's the scenario: 1. Accumulate the quantity of all the items that…

I have a file with Amazon orders, TSV, that can have multiple orders and multiple line items per order. Since the Amazon order number is 20 characters and Sage only allows up to 7 characters for its order number, I need to create my own order number and…