Sage 100

I have a vi job that is suppose to transfer inventory items from one warehouse to another along with their bin location. Scanco muti-bin is installed. The job is not able to distribute the line tiers of bin location. Has anyone had this issue with VI…

I am looking to update the item locations for a large number of SKUs, is it possible to update that information in bulk via an Excel upload or something similar? I don't want to have to open each SKU individually in Item Maintenance and update them if…

New to V/I. I've used it for basic functions, but I cannot figure out how to merge item codes within V/I. I have hundreds of items that we would like to delete by converting them to a single item code. What would I need to do within the job to make this…

"The AppliedPurchaseOrderNo is required" in VI import into PO Receipt of Goods

After a rocky start, PM v2022 is moving forward. Now the next challenge is importing work ticket transactions for material. Has anyone successfully done this? The only KB I found was 116044. It referred it to your reseller for assistance. Who are you…

We use the Gross Requirement Report frequently and would like to know if it's possible to import the product list and its quantity instead of manually enter hundred of item numbers each time. It's seems that the last ran list is stored in table BM_ComponentReportSelection…

Trying to create a VI job to create production entries. Have some items that sell only a few each, but when you add the group up it is 100 entries for 747 sales. Want to automate the production entry. Nothing is lot numbered or consumes lot numbered…

Where are the EZ import files located. Where can I find import examples?

Is it possible to import backordered PO's ? I see the qty backorder is a field to be able to import into in VI; however when I try to use it, it fails with a message "you cannot set backordered, invalid order status". This happens when I set the order…

Trying to import POs with different Units of Measure in the lines. Inventory item is set up with Purchase UOM TON and Sales UOM LB. For some reason, the imported PO has a quality error (when UOM is different from the Purchase UOM, it multiply the conversion…

Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…

I need to add several hundred product from our website into sage. I can export product codes from our website, and I'd prefer to format descriptions on one master excel sheet. Can you "mass add" products using VI? I'm a bit new to VI, so I wanted to ask…

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…

So we have around 1800 Items in inventory that are labeled KIT, when they should be Finished Goods. We are unable to move the majority of these records to their proper status because most have a Bill of Materials attached. What we are trying to determine…

I am trying to run a VI job that contains a record count at the end of the file being exported. However, I don't know if there is a way to do this within Visual Integrator (using Sage 100 v2018).

I am tasked with exporting certain fields from our Sage 100 v2018 AP_Vendor table to a third party. However the data needs to encompass all of our company codes. Is there a way to do that within VI?

I am using VI to Import an SO Invoice batch. The batch is automatically being created as an Invoice batch (batch type I). I need it to be a Shipping Batch (batch type S). I don't see anywhere where that can be assigned in the import job. Other than DFDM…

Hello all. I am attempting to use Visual Integrator to update my company's projected demands on the fly. I am attempting to import into the MP.SCHED table. The problem I'm running into is that the import fails on the CUST_NUMBER field if this is left…

I'm importing inventory issues. I want to default the "Enter exceeds on hand qty" to Yes. I think this is possible - just can't remember how to do it. Thanks

I would like to delete the 'Customer Price Schedule' for just 1 customer. Is there an easy way to do this without having to delete each item individually? I noticed another reply that mentioned something about script - which is foreign to me and another…

Hello All, Running: Sage 100 2017 V5.40 Here is the problem. Need to import inventory transactions however, getting this message on the import. (Already checked inventory is there and good) Please help, I have tired everything even SAGE without…

I would like to update all our customers to receive invoice via email pdf, what table should I use for import? Also is there a way for us to set all new customers to have the Paperless office PDF to have the email checked? Thanks.

Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials. Thanks Russ

I am trying to import our Web Sales orders with Credit Card Pre-Auth and getting this error. Anyone know what this error means?

I'm attempting to create a job in visual integrator to update info in a table column from a CSV file, but am running into the issue that the table does not appear in the table list when creating the new import job (the export job works without issue)…