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 am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…
Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
Account No.
Debit
Credit
Posting Comment
Journal Comment
6570-00
500.00
0.00
Test comment…
I am receiving an error message when clicking on any template in the task scheduler. Here is what happened.
How it happened:
Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script).
It has been…
We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI.
We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error.
For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…
Have the following source file (CSV)
2 questions:
1 - I want to import the Invoice No and append "-CM". Is this possible?
2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…
I have a CSV file with new employee pay rates for a couple hundred hourly employees. Is it possible/advisable to import the new rates with a visual integrator job, and have the change appear on the "Pay Rate Change Report".
Thanks!
I am working on importing into Work Ticket Header in Sage 100 version 2020 Premium working with Production Management. I am trying to create the same action that occurs in the user interface of Work Ticket Entry in Production Management. In the UI of…
On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…
I am work with VI to import AP invoices. One of the required Fields is the GL Account Key. I am looking for a way to look up the GL Account Key to be entered into the record for importing AP Invoices into Sage 100?
Hello all,
Need some help. Hoping someone else has seen this before. Trying to use a VI import on a table I haven't imported into before. Asked if my Job_Name was a new VI job. Hit Yes and... POOF. Pop up error.
Unable to instantiate BO_BillOfLadingMargin_bus…
The original statement we have is as follows - Temp001$=“458”
I want to include "459". How should the formula look?
Temp001$=“458, 459"
or
Temp001$=“458” or Temp001$=“459”
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…
I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016.
The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…
We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read.
What causes this to happen?
From looking at the summary…
First, I'm an IT guy, but have little Sage 100 knowledge.
We have created a new company in Sage. I need to move some inventory records from the old company to the new company. I have two CSV files. The first contains inventory records of items that…
We were looking to clean up and standardize our misc item codes across our MAS companies. Our support group said you can't delete them if they had been used in the past, but we could switch "UseInPO" to N to hide them.
I've built a VI job that seems…
I am currently new to VI and looking to see if there is a lookup function that would determine a value to be passed during the import based on a value found in the import file.
As an example, the import file that has been provided includes an account…
Hi,
Couldnt find anything in KB so thought i would post a question.
was looking to create an import that would maintain the Standard Price in Item Maintenance.
is there a way to create a VI Job to CI_ITEM? has anyone done this?
wanted to just…
