Sage 100

I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…

Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

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…

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…

The question is: can Paperless Office receive scanned in documents and attach them to / associate them with a Customer Maintenance record? ..Or any other way to associate files with a Sage Customer account? Thanks very much!!!

Hello: I have an issue where the client needs the ship weight and the freight to carry over to the Totals tab in Sales order data entry. It will not due to the line item setting in sales order options. I believe my options are to write a script to…

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

I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…

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…

I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…