Sage 100

I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…

Hi Everyone, I am wondering if there is a script that can be written in Excel to look up an item number in SAGE and return the required date back to the excel sheet? Following the screenshots below I would like to have excel pull the next required date…

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…

Is there a way to select the field and sort direction (ascending/descending) for a list box such as Invoice History or Item Transactions? If a script is needed, what method/property should be used? How does Sage determine the default field and sort…

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 writing a script on the purchase order header which looks at each line in the purchase order and looks up for the Item code in the purchase order detail bus to get information from previous order for that item. I am using Set Browse Index EOF to…

Customer is running v2014 Advanced, PU4. I have a SO Detail pre-write script that needs to look up customer specific pricing directly (so CalculateItemPrice() is not an option), and when I do a GetValue on the DiscountMarkup1 column, it is rounding…