Sage 100

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…

I would like to know how to add a custom field that is listed on our sales order entry screen to the Customer Maintenance/Customer Inquiry tab 6. Invoices screen as a column next to the Customer PO No. column. Is there an easy way to do this myself?

Hi all. We have Sage 100 2014. I created a "test" Accept button to display a message box to the end user when the sales order's total amount is less than the account's UDF_MINORDERFREIGHT. It works as it should, but now I want to add this code to the…

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…

AR Customer Maintenance has this great field on the Main Tab: ML_Warning that displays info about a customer's credit status. Our client wants to change the appearance of the field to make it stand out: increase the font size, change color of the text…

Is it possible to create a field (UDF) that replicates the salesperson lookup using business object fields for salesperson? I need to add this secondary salesperson lookup in AR_Customer and SO_Shiptoaddress. I was hoping against hope that I could do…

I am trying to place the <Telephone2> field in AR_CustomerContact on the SO_SalesOrder Header. I am placing it over the Fax Number Field as we don't use fax numbers much. I have created a UDF in SO_SalesOrder Header file to hold the value, and have placed…

I'm doing preliminary research on what kind of API we can use to integrate with Sage 100 ERP. I've discovered Sage_Certified_Solution_Requirements.pdf with several statements about automation: Automation: Certified applications must offer automated…

I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …

We are currently in the process of upgrading to 2017. I've created a customized Sales Order Entry screen for myself and have imported all screens from ###-### using the copy function from the customizer. However, custom UDF columns are not being correctly…

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…

I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…

The appearance of the tab stop definition buttons in customizer could be considered confusing. See the attached image of the difference between 2016 and 2015. The buttons appear backwards in 2016. The below example is from PO Header. I didn't check the…

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 have created 2 new tabs within Item Maintenance and would like to move a couple of the original Sage fields to them. When I go to place the field in my new tab it says it already exists on another panel and I would have to remove it in order to place…

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…

We continue to run into the issue where we have users access purchase order printing. Click select without any parameters (Paperless Office Output is set to Electronically Deliver) and then click Print. We end up with around 25 emails being sent before…

I am trying to add a custom panel onto the customer memo inquiry and maintenance screens so I can see both the create date and the auto display field (to quickly distinguish old notes from current notes). Currently in maintenance I only see the memo code…

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…

Hi all I created a UDF in the CI_ITEM table, i want to add that to the item_Maintenance panel, and item_inquiry panel. i have three UDF's called catagory1, catagory2, catagory3 . i tried to right click on the panel and selected customizer but nothing…

I currently have a udf that gets data from another udf in po and bm lot/serial distribution. I am looking for a new udf that I can update with an input box, where I don't have to do a transaction. Searching on here I have found scripts allowing people…

When we view items in Item Maintenance, we would also like to see the BOM's listed on the Header. We want to see exactly how we calculated the price directly on IM and not have to open another module, then revert back ti IM. We have a lot of items that…

I have a button script in SO entry which uses the new invoke lookup function. The lookup calls the customer's price schedule list then after selecting it Adds that item to the order. The script works fine as long as the line is not the first line. If…

Hey all, Is there a way to link the email address in the "Salesperson Maintenance" screen which is tied to a particular client to the client's "paperless Office Delivery Options In AR Invoice" (Possibly with a check box?..) Just as there is a check…