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 have a VI job that exports data from the AP_VendorRemit file to a pipe delimited file. The last field in a record has a pipe after it and then the carriage return. The people who we are exporting the data for told us they do not want the pipe after…
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…
I'm running into issues with creating an AR Cash Receipt Import using VI in version 5.1/2014. Does anyone happen to have a sample AR Cash Receipt VI job that they would be willing to share? Any help would be greatly appreciated. Thank you.
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…
Started working at a new company that manufactures equipment and they are wanting to implement Work Orders for their jobs. Due to the increase of data entry etc, they have me looking at importing Work Orders instead of manually creating them. We utilize…
I'm asking this question as a correlation to this other post (titled: "Is there a way to change employee numbers in a VI job based on SSN?"). We're running into an issue where Sage no longer deletes employees marked as "Terminated" during year end processing…
We have a significant number of seasonal employees that we have each year. It used to be that Sage would delete terminated employees during the year end process, but that is no longer the case because of this . We're getting ready to import the seasonal…
Hello!
I am trying to streamline our deposit process, but I am hitting a road block. I created the import profile to import Transaction Journal Entries, but when an inter-company GL comes up in the import it shows "L Record Invalid or Write Failed.…
How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type.
Tried checking / unchecking ASCII
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…
Is there a way that you can assign an Item number in the import based on a UDF in the CI_Item master?
Please do not kill the messenger. My thoughts are no, but then maybe I am not creative enough.
The import file has a value that is stored in the…
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…
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?
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…
