• Add a Custom UDF for Inventory Price Change

    Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?
  • Permanently Enable Button on UI

    I have a button script located on a Cash Receipts Entry screen. Sage disables it by default until a customer number has been entered. The purpose of the button is to assist the user with locating the customer number, so this doesn't work for our use-case…
  • Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

    We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
  • Invoice Batching – Can't Set the Cost Account Key

    When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
  • 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…
  • Trying to add UDF for Last Updated (date for standard cost) for use in Price Updates

    We are working on an eCommerce site that is linked to our MAS90. I have an import job created that I use for internal price updates that uses the CI_Item table. I am wanting to add an Update Date field to the Import Job, but can't find that anywhere…
  • Customize Item memo

    Is there a way to customize Item memo so if certain customers order that item a pop up will show up on the sales order. Possible by customer number or country code. We have some items that can not be sold in certain countries.
  • How To track Lost Sales?

    Would someone be able to tell how I would go about setting up a way to track lost sales? We are using Sage 100 Advanced ERP, Version 5.00.1.0...