Good day all.
I want to write a small specific with an action on a field.
If Field A = 'condition' then Field B = Mandatory user input. Mandatory user input, users cannot move away from the field until they enter the data.
What is the command in…
Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it.
The…
Hi,
Was doing Patch creation (APATCH) to bring customization over.
Noticed these errors:
My temporary solution is to simply delete the linebreak character since if I do not do this it crashes the main screen function.
Is there a way to resolve…
Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…
$VERIF_MOD
Local Char ZPRODCOD(30)
Local Char ZPRODCODOLD(30)
Local Integer YESNO
YESNO =2
For i=0 To max([M:POH2]NBLIG -1)
For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i)
ZPRODCODOLD = [M:POH2]ZPRODCOD(i)
ZPRODCOD=[ITM]ZPRODCOD
if…
Can't determine what the problem is for the script message not displaying in SO Entry. Here is my script. Client is Premium version 2021
' -------------------------SCRIPT START ------------------------------------ If oSession.CompanyCode <> "ZZZ" and…
I am getting this error message on my bills "The field " " for Timekeeper cannot be blank". I understand that I need to change the Timekeeper Classification setting in the LEDES set up box, and in order to do that, I need to create a custom field. However…
I get an error whenever I try to set the Country Business object, either as a childhandle or asObject. I have no idea why this keeps getting an error 88.
'Title: UDF_Alt_Country_Code 'Desc: Autofill the UDF_Alt_Country_Code after selecting Country…
I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type. I defined a UDF for that checkbox, and put it in the Item Maintenance screen.
I would like the total to update whenever a user…
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…
We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…
Optional Field Value. Attempt to modify a different record than was retrieved.
Im getting this error while trying to enter new value for the optional field. Kindly help.
Thank you
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…
Hi,
Below is my script to Prompt user a warning that when user entering invoice data entry, it will check a udt for blanket PO is out of fund.
I've create User Define Table to keep track of a listed PO and Billed Amount. The script is reading invoice…
Hi, I am trying to write a script that zero's out a Sales Order UDF during Invoice Data Entry. This is what I have, but it is not zeroing in on the exact sales order in my lines and it doesn't seem to be writing back to the sales order, although I have…
Hello,
In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…
Hi
We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF.
I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…
I am having issues setting the Purchase Order lines with a GL Account code or key gathered from a SQL table. It doesn't matter what I try to pass, the system always defaults it to some obscure account code. All other fields I set work except for the GL…
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…
Hello,
I'm simply wanting to write the previous item code to a UDT when the line is changed in a sales order. For example, if the item code was abc123 and a user changed it to def456, I want to write abc123 to the UDT. However, each time I try to access…
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…
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…
Hello,
I am trying to write a simple tracking script that records the number of items within a specific product line a salesperson has purchased. I currently have this script as "Table: Post-Write", but even if I cancel my order in Sales Order Entry…
Hello,
I am working on a scripting solution that sets a hard cap on the number of free sample items a salesperson can receive. I currently have a UDT set up that tracks how many of each product line a sales person has, and am able to write to that table…
