• Inventory Import by UPC code

    I am trying to figure the best way/best practice method of displaying one of our vendors inventory within our Sage system.  All the items are IIG matrix items and we receive the data with the quantities being tied to the UPC.  I have all the UPC codes already…

  • Adding a perform with two select statements in Sage 100 Visual Integrator

    Client running Sage 100 v2018.  Trying to export purchase order information based on two select criteria that is outside standard fields.  I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the export…

  • Can you install SSRS on the same server as Sage as it uses (I believe) Crystal Reports?

    We were needing to have Microsoft reporting services (SSRS) on the same server as Sage 100, but as sage uses the sql database, and has (I believe?) Crystal Reports built in, would there be any issue installing the SQL Server Reporting Services onto the…

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

  • Override Unit of Measure in Visual Integrator

    I'm doing an import job maintenance.

    Our PO has the field L.QuantityOrdered as 12 and L.UnitOfMeasure as "EA".

    In Sage, the Item has a Sales UOM of "CS6", which translates to 6.

    So when we import the order, the PO means 12 total…

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

  • Missing Work Ticket

    Missing Work Ticket:  Work Ticket shows on WIP Reconcilliation and Work Ticket Inquiry but cannot be found on Work Ticket Entry and PO's cannot be linked to it.  Where is it?

  • VI Import Vendor Number

    I am working on an import that is related to the following thread; https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/177980/how-to-run-visual-integrator-from-bat-file.

    When I go to test the PO_Header import I keep getting an…

  • Visual Integrator import into AP Manual Check Entry - Need to suppress invoices that do not already exist in AP_OpenInvoice

    Running Sage 100 v2018 and have a VI import that brings in records into AP Manual Check Entry.  The client wants to suppress any invoices that are not in AP_OpenInvoice and be able to review the Import Log to see those invoices that were skipped.  This…

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

  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

  • User unable to export to excel from Explore View because the excel icon is not visible.

    Other users with other roles can export.

    Role Maintenance:Library Master:Miscellaneous tasks:Business Insights Reporter Export doesnt show in role maintenance either. 

    Business Insights Report Import is enabled.

  • VI Conditional Expression for QuantityOrdered equaling QuantityInvoiced

    Running SAGE 100 v2018 and am exporting out of PO_PurchaseOrderDetail.  Trying to figure out the correct syntax for a conditional statement where a TEMP field will either populate "OPEN' or "CLSD" depending on if QuantityOredered = QuantityInvoiced.…

  • PickingSheetPrinted field didn't get updated after PickingSheet got printed

    There are several orders in our system, of which both the Sales Order Entry UI and table field of PickingSheetPrinted indicates that the picking sheet has not been printed. However, I do find the paper version of picking sheets of those orders in the folder…

  • Skip duplicate import record if invoice is in history

    Running Sage 100 v2018.  Created a VI import into AP_InvoiceHeader/Detail in order to populate invoices into AP Invoice Entry.  I have a Perform that checks to see if there are duplicates in the AP_InvoiceHistoryHeader table:

    --------------------------…

  • Forms/Reports/BIE blank after upgrade

    Had an upgrade from v2016 to v2021 Advanced. Migration/conversion went well with no errors. However forms, reports, bie within sage 100 doesn't display data and even trying to do a crystal report outside of sage doesn't display data. I could see…

  • Can't get accounts to populate properly

    Hello I have a 2018 Premium install of Sage 100 and I cannot get certain accounts to populate with balances in Sage Intelligence. The balance says zero but there is a balance in there for the period and year selected. It's selective. Some accounts do…

  • Sage 100 BOI Script to Create Inventory Transactions

    I'm writing a BOI script to create Inventory Adjustment Transactions.  I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script.  What I can't figure out is what the "refNo$" needs to be.…

  • vi job inventory alias

    Need to clean up inventory alias.

    My first attemp is adding another alias

    I need to replace the alias with the alias in the import file

    If I need to deete aliases first before I import, how do I delete without going into each alias?

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

  • VI Job error WO with Bill Revision

    I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…

  • Error when clicking Accept in Vendor Maintenance

    Sage 100 2021 PU2

    This happens even if no changes are made.