x Want to participate? Join the group to interact

  • Importing new serial numbers into Physical Count

    Using VI to import into physical count. On serialized items, if I import a new serial number (did not previously exist in the system), the "frozen" qoh (which should be 0) is incorrect. If I had 3 new serial numbers for the same part, each new line shows…

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

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

  • Error Message During Delete Process

    Hello, Everyone has been so helpful in the past, I thought I would ask about another issue I am having. While trying to delete some items through the "Delete and Change Items" Module I receive the following Error Message for each of the items…

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

  • Still Having VI Importing Issue

    Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…

  • 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