Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I'm on Sage 100 Standard 2020 (v6.20.1.0).
We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…
I'm wanting to get orders imported started with a J and have them increment for every new order that comes in.
I managed to get the J in there, but with using the "NEXT" order number.
Is there a way to have the vi job check for the last order, then…
Hello All,
I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
Hello!
I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.
It would be nice if i could filter a whole list of orders…
Hello,
I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns.
What im trying to do is have the ShipExpireDate be 5 business days added to the order…
I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…
Using Visual Integrator, how can i prevent the importing of a Sales Orrder, and make it update an old sales order instead, if the PO number of the currently importing Sales Order is the same as the PO number of an old sales order?
here is the line i'm testing my import on:
1,00,ROYAL,66ITM67161,1,,
col 1: H.SalesOrderNo 'Next'
col 2: H.ARDivisionNo
col 3: H. CustoemrNo
When I attempt to import, I'm getting this error:
However, when I manually enter a sales order,…
Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…
Recently was working on a large project to change the Standard Unit of Measure for thousands of SKUs in our company. The change necessitated that we change the thousands of open sales orders and purchase orders and work orders that were using these SKUs…
We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…
We use VI quite extensively and it works great. We use it to import many of our orders. After the VI jobs run, we open the sales order entry screen and enter the sales order number to do final editing and to print/email.
Does anyone know how to add…
hello, first post here...
I've managed to tinker with and setup vi jobs for vendors, product types, item master and other basic stuff so i'm a little familiar with vi.
Can someone please tell me what 2 tables i need to be importing for a Sales Order…