• User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • How to print Extended Description on Sales Orders?

    I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.
  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
  • Adding Last_Total_Unit_Cost of an item by warehouse to SO field

    Hello Everyone! I am looking for a quicker and easier way to ascertain the last total unit cost of an item in a specific warehouse. Our organization has multiple warehouses and sometimes landed freight charges vary for different items based on their…
  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…
  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
  • Write on Production table using script

    Are we able to write on the Production table from the Sales Order Entry UI? I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • Sales Order line udf is not populating in Sales Order Invoice lines

    I have created the same udf in sales order detail and SO invoice detail entities. Both same type - string - and same size (20). In the data source from SO invoice detail I have selected "copy from sales order and for data source I have selected SO_SalesOrderDetail…
  • Possible to add additional 'Order Status' type?

    Hello, We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'. Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…
  • Item Maintenance Tab Orders Count

    Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…
  • SO Line Script Not working

    Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…
  • Log who printed Picking Sheet

    I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…
  • Add a fixed percentage to sales order total

    I'd like to create an additional field in SO Totals that shows a fixed percentage of the sales order total and then, in a separate field, shows grand total (sum of order total + %). How can I achieve it?
  • Get time quote was converted to order

    Is there a way to know not only the date a quote was converted to and order but also the time? Using Sage 100 2016 Advanced
  • DPAS Priority Rating from SO to WO/PO/Invoicing - Mapping of UDF

    We need to track the DPAS (Defense Priorities and Allocations System) Ratings that are entered on Sales Orders and flow this information through to WO's that are generated from SO's, any PO's that are tied to SO's and onto any pack lists, invoice etc…
  • Sales Order Entry - Copy From SO - UDF Behaviour

    Hi, If I have UDFs in the SO Header and use the copy from SO feature in SO to create a new Sales Order, should the UDF values copy over as well? In the v2016 and v2017 installs I tested, these fields don't come over. But I think I read on here that…
  • Document item scanned when shipped

    During our shipping process we scan all inventory from the pick sheet into shipping data entry. I like to create a process that using a UDF will track that the item the was scanned into shipping data entry. Example: Item A quantity 2 Item A we scan…
  • Dependent UDFs

    Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…
  • Line Item Total in Sales Order Entry

    We're using MAS 200 4.4 (still). In any of the newer versions, does MAS display a running total of the items ordered in the SO Item Entry Panel? If there isn't one, any tips on how to create this using Custom Office? We get frequent orders where a customer…
  • I want to start using customizer and Custom Office to be able to email forms to multiple people within a company, where do I start?

    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…
  • Automatically Save Changes on Event Script

    Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…
  • UDF from PO Material Requisition Issue linked to Item Transaction detail UDF

    I want to link data in a detail line of PO Material Requisition Issue Entry through to IM_ItemTransactionHistory. But when I try to pull a data value into the IM_TransactionPosting table, none of the Business Object sources listed are from the PO Mat…
  • Trying to update Sales Order Header UDF from Invoice Entry getting error

    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…
  • Add CI_Item field to Item Maintenance

    I want to add field [Category4] from CI_Item to the Item Maintenance, but can not seem to find it in Custom Office User-Defined Field and table Maintenance. Can anybody help with that? Thanks.