Sage 100

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…

We enter our orders in each qty, but would like to show a field with the calculation of case qty. I don't need this value stored, just would like to see it on the screen. I have added my UDF that contains the case qty to the lines tab. I don't see how…

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…

Client upgraded from 2016 to 2019.2. Had an Adv Setting DEFAULT set for FOB field on PO screen. No longer working after upgrade. I deleted the entry, closed, went back and created the entry again - still no go. FOB field remains blank when entering a…

Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

I've got a UDT that isn't displaying in the list under user-defined field and table maintenance. It used to display but has since disappeared. I wonder if anyone knows some tricks to refresh the menu system? The table I'm looking for is called SY So…

Sage 100 version 2017

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…

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 in version 2016, and want to customize the memo in both Sales Orders and Purchase Orders. I see an old post from 2010, but no further information on this or if it is even possible on today's versions.

Hello, Can anyone help me with example code on how to get a User Defined Field in another object? I'm used to using oSession and oLines to get the header values and details for AP_ManualCheckHeader and AP_ManualCheckDetail. But I'm trying to get one…

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…

Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

Subject line states what we would like to eliminate. This occurs on the Sales Order entry screen. We know the item cost is zero, but this pop-up occurs EVERY time. I am sure it is a simple solution.

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'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?

We were told that Sage 100c could customize an item inquiry for Sales staff: Here's what the sales department is asking for: They want to inquiry on a part number to find out which customers purchased that part and for how much. They problem is…

I need to be able to calculate a UDF Field. I want, for starters, to add two UDF fields together (numeric) and populate the third UDF field with that value in Item Maintenance. This is my first attempt at writing a VB Script. So any help would be appreciated…

I have a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000) Where do I place the "if" statement to get it to work? tmpAmt = 0 : tmpExchange = 0 retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

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

Good morning everyone. I am trying to create a UDF in Inventory Inquiry that will show me the warehouse code from my DSD Multi-Bin Table. Can anyone point me in the right direction to getting this done?

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…

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…

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…