Sage 100

Hello, One of our customers inventory is showing up incorrectly and we need to temporarily put their orders on hold until we can go through them individually to ensure they are correct. However, I have been unable to get these new orders to be put on…

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…

Hello, I'm working on a project where I need to pass a parameter to and open a custom crystal report. I have done a lot of searching, and understand that it is possible, but I can't even open crystal let alone pass parameters. I keep receiving the…

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…

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…

Hello, I am trying to update the vendor email address with a concatenation of some UDF email addresses that we have. I have used this same code to update UDFs, but I guess this is the incorrect syntax to update non-UDFs, but I can't figure out how to…

Hello, I am scripting a button that, when clicked, opens up the sales order history lookup from the Invoice History Inquiry panel. I am trying to get this lookup to already have the sales order number entered that is shown on the current panel. For…