Sage 100

Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…

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…

We have a lot of information in our header tab already and when we print our sales order the space is mostly allocated. We have a new UDF field that we need to create and I am trying to figure out a place to put this new information, was hoping in the…

Hi friends, We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. If the customer has any open invoices that are past…

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…

In general is there a maximum number of UDF's per table. And is there a maximum number of UDF's that can be added to a form? In particular, I am looking at adding 120 UDF's to the Sales Order Detail line - is that possible? It will be Sage 100 Premium…

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…

We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…

I have been using MAS90 and Sage 100 for many years. Now I am needing more custom reports, but I do not know that much about creating or modifying crystal reports. I am using Sage 100c Standard 2017 V5.40.1.0 and Cryatal v14.0.3.613 RTM. Where can I…

Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…

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…

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?

Hi All, I am trying to set the value of OrderDate while importing Sales order. Record imported successfully, but order date does not reflect in Sage100. It remains the same as previous order date. I don't know where I am wrong. Please help me. Do…

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

Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

While in a Sales Order line, selecting the Price Lookup option from drop down, produces the correct match for this item, this customer. Is it possible to capture that data and print it on the Sales Order form? I want to get all the columns for Quantity…

Was wondering if there was a way to add ShipVia to the selection (Select Field) when entering a range of sales orders in Picking Sheet Printing i have an order range, and some of the orders are say FedEx and some UPS. I would like to enter the Order…

Hi, using Sage 100 Standard ERP 2014 I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader the field i am having trouble with is OrderDate The date on the CSV file comes across…

we are currently using Sage Standard 2014 5.1 version. We are loading Sales Orders using an EDI Translation software and MAPADOC. The orders are loading into Sales Order by Customer #. We have one Customer due to different divisions/vendor#s sends…

Is there an easy way to have customer invoices carbon copied (or blind carbon copied) to the salesperson when we use Paperless Office to send them to the customer? It seems like the only way is to set them all up as an additional e-mail address in Paperless…

we use visual integrator to import sales orders. I have a customer that sends us a csv file and on that file we have header and detail information on each line. so i would see something like: PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty…

is it possible to have a pop up (memo or note) happen when you go into invoice entry and either create an invoice from a sales order or when you create an invoice on demand driven off of the customer number? what we are trying to do is create an alert…

A customer needs to bring in a sales order from a SQLdatabase in Sage 2013 using the BOI. The SQL server is separate from the MAS server, both in our data center environment. We believe permissions are OK. Our code is doing: PathHome = "\\machinename…

We use VI quite extensively and it works great. We use it to import many of our orders. After the VI jobs run, we open the sales order entry screen and enter the sales order number to do final editing and to print/email. Does anyone know how to add…

I'm trying to populate the UserCode into a UDF on the Sales Order Header.I have created UDF_USERCODE String (3) and on the Data Sources tab selected the Business Object: SO_SalesOrder_bus, Data Source: UserCreatedKey, Column: UserCode. UDF_USERCODE is…