Sage 100

I've been hearing from my reseller that MRP for Sage 100 Premium is just around the corner...but that's been since 2019. Manufacturing software needs MRP. We're stuck with Providex because of the MRP issue. I played around in IRP, but it's not a replacement…

How can I extract all related product data from Sage 100 into a single report, including product descriptions and attributes, supplier information, purchase order details, and inventory information, and download it as a .csv file in the easiest way possible…

Currently want to purge about twenty (20) years of employee time clock punches, any clue as to how this is done. Also, in doing so, does this effect any other aspect of employee records?

We have an user that is moving parts around on several bill of materials. He is consistently receiving this message. Often after the message is received the items behave oddly, such as not being able to delete or modify. When we try to delete or modify…

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…

Hoping someone can help. Couldn't find much online and the online resource file layout mentioned the code but no definition on what this code represents. Since upgrading to Sage 100 2022 I am seeing JI codes in inventory transaction history. Those codes…

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

Where can I get a cross reference table from the files/tables in V2019 to map to V2022 fields Thanks

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…

Hi Forum, Is there a function to Delete records from IM_ItemCost table ?. I cannot find anything to do that. Browse for examples and nothing comes up. Regards, Manuel Roman

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…

Has anyone copied the BM_Header and BM_Detail files from one company to another company? Just curious if there are reasons not to try this. We do not need any history, just the bill of materials master files.

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…

I tried reinstalling Sage 100 v 16.5. After installing I tried opening Sage commercial and Sage accounting. This message appears: unable to connect to PupilPath sql server [5] What is the problem?

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

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

Hello, We've recently started populating our Bin Location from within Reorder Maintenance in order to start utilizing the Physical Count Entry screen sorting by Bin Location. The locations do not seem to sync properly between the two panels though.…

An overdistribution tier is created when we un-issue an item from a work ticket in which the item was never originally issued and the item has an on hand quantity in inventory of zero. This scenario occurs when we create a "rework" work ticket to add…

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…

Is it possible in Data Agent Server 5.1 (Global Software) to send reports to multiple email address depending on their buyer code? Pretty sure no one uses this software anymore but maybe some has figured this out. I was thinking that a SQL expression…

Getting this error among all 3 companies when we try to access Customer Maintenance\Items. Also get this error from Item Maintenance\History\Customer Sales History. Have tried renaming links folder, *esc, rebuilding all AR and IM tables. Not sure where…

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…

Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry. We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…