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.
Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…
I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…
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'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…
I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…
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…
Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number. I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the…
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…
Hello all,
SAGE 100 Could Advanced 2020 (V6.20.1.0)
I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…
I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…
Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…
Older version Sage 100 4.5 (yay, I know)
Need to change the SalesSubjectToComm amount, created VI Import to AR_SalespersonCommission
Test run, all records pass.
Live run, all records fail with "Record is in Uneditable State".
No other users…
Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once…
I am trying to figure out how to create a VI job to be able to change all of the customers for a sales person to email Sales Order & S/O invoices. I've tried exporting AR_CustomerDocuments and AR_CustomerDocumentsContacts, but neither of those seem to…
I'm trying to import a journal entry. I've calculated the Debit Account number by combining other fields to make the complete account and that works.
Now I need to total all the debits to get the credit amount and then assign the credit account number…
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…
W/O-Legacy experts,
I need help! I have been trying to set up a VI job to import W/O material transactions. I followed the KB advice to create an export job, and look at the fields that are populated, I also double-checked that I am using the proper…
Hello,
I've created a VI job to import Sales Orders. All fields work perfectly with the exception of the Quantity and Price. The import log shows both fields as blank, even though the amounts are in the selected columns. I also tried setting the amounts…
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…
Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…
Good day;
Newbie here, any help is greatly appreciated. I created a VI job to export the previous day invoice no,, day, customer number, customer name. I am exporting this data from table "AR_InvoiceHistory Header". No management wants me to also…
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…
Hi, In importing through VI into IM_TransactionHeader (which also has L and LL), how do I use "Next" operation for EntryNo and apply the first EntryNo generated to all L and LL lines?? Or should I be using different Operation or can I simply not achieve…