x Want to participate? Join the group to interact

  • Visual Integrator: records read not equal to records passed, but no records failed or were skipped

    We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read. What causes this to happen? From looking at the summary…

  • Vendor Number does not import when importing new vendors

    I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…

  • IM_PriceCode issues with Visual Integrator

    Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…

  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

  • Key File Rebuild and Optimize removes all records.

    Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…

  • VI Perform Logic for AP Invoice Duplicates - Sage100 Business Framework (v2014)

    Hello - I am looking for someone to be so kind as to post the syntax for Perform Logic to look for already posted duplicate A/P invoices during VI. I used perform logic in the past (non-framework) but do not know what the current syntax should be. …

  • VI import to IM_ItemCustomerHistoryByPeriod

    I have created a UDF in the IM_ItemCustomerHIstoryByPeriod table to store the item unit sales forecast. I want to import the forecast qty to this field, but any item that has never been sold to the customer does not have an existing record, so can't import…

  • Visual Integrator Issue

    After importing Excel database files through the "job Select" option, I run the TEST option and it is starting to "Ignore" all the imported files, which it has never done that before. Does anyone have an idea why this would happen and more importantly…

  • Deleting an open credit memo invoice using a VI import job

    I am using MAS 200 4.10. We are automating our RMA process, and currently are creating credit memos through a VI import job. That is working fine. Now I am expanding the function to include automating credits to customer credit cards. The problem here…

  • Import to Sales Order

    We are on 2013 version 5.00.3.0. We would like to be able to import sales order from an excel workbook. Is this possible? If so, can someone explain?

*Community Hub is the new name for Sage City