Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order.
The only indicator they get is SO_SalesOrder_UI in a message box.
Here is the…
Hi All,
I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....".
On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write.
…
I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?
Hello,
I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query.
This needs to be run on the Client…
I am trying to write a script that will take numeric values that are currently stored in a string field and perform a mathematically expression on them.
For example:
Field 1 is 10 character String field
Field 2 is 10 character String field
I am…
I am trying to update a UDF in Purchase Order entry lines during a receipt of goods. The issue I am having is that the purchase order record is locked while a receipt of goods / invoice records exist referencing the purchase order. Here is the code I…