• Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
  • Move Fields from Additional to Main Tab

    With 4k monitors and a lot more screen room we would like to move some information from the "additional" tab to the "main" tab in inventory and accounts receivable so we don't have to flip back and forth between tabs to see everything we need. I was working…
  • SO entry screen

    We just did the SAGE 2021 update and something all of our people are finding an issue with is In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…
  • Restrict access to standard report settings?

    Is there a way to restrict access to standard report settings while allowing employees access to custom settings? We recently upgraded to 2018 and use the Job Cost Module. The Job transaction detail report is something we use frequently but since we upgraded…
  • VB Script to compare and update the date values for 2 date fields

    Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…
  • How to use the same UDFs in PO ROG and IM Transaction Entry

    I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…
  • How to run bat file followed by VI job and Sage Tasks from a single command

    I need to run all the following in sequence 1 Run MS Access Macro - I have a bat file that does this nicely 2 Import data into 'Production Entry'- I have a VI Import job that works 3 Launch 'Production Register Update' panel - I see this can be…
  • Inventory Script for Sage 100 ERP 2015 Premium SQL

    Hi, I am trying to update a Script that worked in MAS 200 Version 4.5 (NON SQL). We've upgrade to Sage 100 ERP 2015 Premium (SQL) and now it does not work. Here is a copy of the script that worked when a button was clicked in Inventory Maintenance.…
  • BOM Header changes via BOI?

    Hello and thank you in advance for your help and advise. I am trying to create a program that uses the BOI to insert a RMA at the time of arrival. The issue I am running into is the BOM is set to "inactive" in Bill of Materials Maintenance. What…
  • UDF Descriptions Disappearing

    I have been noticing an odd issue over the past few months and I'm wondering if anyone else has seen it. Over the last 3 months or so I have had 28 UDF descriptions (that I have noticed) disappear from the panels they have been placed in. The fields are…