Sage 100

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…

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

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…

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…

I have some UDFs in Sales Order Header that are setup to copy when using the Copy From. This does not work when using SO Entry from CRM. Is there something I'm missing, or some work around other than doing the orders from within Sage? (Which is not an…

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 would like to add bin/location to the inventory transaction screen to provide a one step solution for moving inventory from one warehouse to another. The fields are not available in customizer for me to add and I was wondering if anyone else has…

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…

Hi, We have a script on Invoice detail which sets the Extension Amount on the line, the current trigger for this script is "Column-Post Validate" on "ItemCode". But when we generate invoices using AR Repetitive Invoice Selection, the script doesn't…

Hi All, I was going through some old Sage Summit presentations and thought that these 2 sessions had a lot of great information that is still very useful. Enjoy! UsingBusinessObjectInterface_Begginer.pptx UsingBusinessObjectInterface_Advanced.pptx…

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…

Is there a way to customize Item memo so if certain customers order that item a pop up will show up on the sales order. Possible by customer number or country code. We have some items that can not be sold in certain countries.

I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…

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…

I have created a JobNumber UDF and added it to AR and AP invoice data entry line detail. Now I would like to create a User Defined Script for the actual Job Number entered during data entry to be written to the JobNumber UDF. In AR it comes from the header…

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…