Sage 100

Hello, I am in the process of restructuring roles for our company. We just began testing, and one of the reported issues is that there are no VI jobs in the job select menu. All of the Visual Integrator permissions are selected for this role, so I am…

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 need to run all the following in sequence 1 Run MS Access Macro - I have a bat file that does this nicely 2 Import data into 'Production Entry'- I have a VI Import job that works 3 Launch 'Production Register Update' panel - I see this can be…

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…

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?

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…

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 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…

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.…

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…

In VI, I would like to use the CompanyCode field from the GL_Account table in the SkipRecord Value. In other words, when using the SkipRecord in VI, is it possible to put a table and field in the Value field of the SkipRecord? Any help would be appreciated…

Sage 100 Advanced 2013. Importing GL Accounts - Test import completed successfully with no bad records (except header). After reviewing log, clocked Accept to import records and received this error message. No File, no channel and no key. This error…