• Error 11 Can anyone shed some light on how to correct?

    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…
  • VI Job import not working with inventory warehouse transfer transaction with Scanco muti-bin Enhancement - Does not distribute the lines to the appropriate Bin Location

    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…
  • Inventory Transaction History JI Code

    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…
  • Is it possible to update item locations in bulk?

    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…
  • How do I merge items using Visual Integrator?

    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

    "The AppliedPurchaseOrderNo is required" in VI import into PO Receipt of Goods
  • file table to cross reference V2019 files to V2022

    Where can I get a cross reference table from the files/tables in V2019 to map to V2022 fields Thanks
  • Importing Material transactions in v2022 (Sage version, not Scanco)

    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…
  • Need to delete bad records from IM_ItemCost table

    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
  • Import list of product to run the Gross Requirements Report

    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…
  • Copy Bill of Materials master files to a new company

    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.
  • VI Job

    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…
  • installation of sage 100 v 16.5 and conect to sqlserver

    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?
  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    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…
  • EZ import

    Where are the EZ import files located. Where can I find import examples?
  • Bin locations not properly syncing between Item Management and Physical Count Entry

    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.…
  • Overdistribution Tier Created When Un-issuing an Item

    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…
  • Import backorder PO's New Implementation

    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…
  • Data Agent emails

    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…
  • Error 65 Program IM_CommonHistoryUI.pvc Line 426

    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…
  • Import PO using Visual Integrator

    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…
  • SO Shipping Batch No. missing on Invoice

    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…
  • Has anyone ever "hard deleted" an AR_Salesperson record?

    We've gathered a collection of a few dozen salesperson records that essentially "dead" - meaning there are no open orders/invoices, there are no assigned customers or shipto records, no sales activity at all for years..... and they are starting to get…
  • Anyone with Sage 100 Experience?

    I am a contract web developer and currently have a painting company asking if I could create a web app that automatically pulls and manipulate data from their database. I went to a meeting with them and realized that they use a program called “sage 100…
  • INVENTORY VALUATION AND GL ACCOUNT DIFFERENCE

    My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,