Sage 100

I would like to automate some Visual Integrator Exports. However, I need to use the Select Tab to make sure each time the export runs the correct records are selected. I found the following formula helpful on the Sage Knowledgebase...and it works based…

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”

I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…

I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail…

It looks like the Chain utility only allows chaining multiple Import jobs OR multiple Export jobs. Is there a way to chain an Import job to an Export job or vice versa?

I have a vi Import job that does cash receipt entry. Occasionally the vi job fails. The result of the failure I believe is caused by a pop-up dialog that I am getting with the following message "The invoice balance was exceeded. Do you want to continue…

Hello, I've tried to create a VI Import job for BM_BillDetail. But, that table is not an option. I see BM_BillHeader is an option, so I've selected that. I've picked the following Data values... H.BillNo, H.Revision, L.LineKey, L.ComponentItemCode…

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…

Does anyone have experience with using the SAS Concur Expense Solutions and importing the data extract via VI to the accounts payable module? or can you tell me which VI table is used for import of invoice data to A/P? Thanks!

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…

Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but…

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.

When importing Sales Orders using VI, the Salesperson for a customer in customer maintenance is being changed. Customer SalesPerson before import is 01-HO03 and after importing an order for them it is being changed to 01-HO01. The Sales Order for the…

Hi, We're very new to Sage 100 and are currently in the middle of our data migration phase, moving over from another ERP system. In looking at importing our BOM's, we're running into two issues with the comment line data: We use a number of carriage…

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 am using Visual Integrator to export SalesOrderDetail.M4T out of sage in a csv format. The challenge i am facing is SalesORderDetail table has a column called as "CommentText" which contains a carriage returns in the data. I want to either get rid…

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…

Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…