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 use VI to import invoices and have now run a duplicate batch but realized it is a duplicate before completing the process. The A/P Invoice Data Entry Batch is "available" but has not yet been processed. How can I delete this batch without processing…
Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
Morning,
I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)?
{SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…
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 am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…
We have a long time customer that has been running a batch file that launches a VI job. The first job chains to another and so on for several jobs. They are and have been Sage 100 premium, we just upgraded them to 2020. The batch file works and all the…
Hello everyone,
I received existing import job with defined perform logic
The import job contains Command "CREATE_ERRORLOG" on Failure.
Сan anyone tell me where I can find this error log?
Also, Is there a link where listed all available commands…
I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not.
What field can i add to distinguish between them?
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 need to know if there is a script or perform logic that can help my situation.
- I have a VI Import Job importing Invoices from Sales Orders
- The source file does NOT contain the Misc or Charge items from the SO
Can this be done without the…
Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?