x Want to participate? Join the group to interact

  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

  • Purge specific records from AR Invoice History-VI or SQL?

    Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…

  • querying summarized bill of materials

    For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

  • item price using boi in sage 100 /mass 90 /mass 200

    Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

  • How can I export any/all the email addresses in paperless office?

    I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

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

  • Identify the real cost of a FIFO item

    We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

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

*Community Hub is the new name for Sage City