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'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…
A customer has asked for a way to update pricing on 1000's of SO, for some planned pricing updates they working on. My idea was to have a button script to loop through all SO, and all lines on each SO, triggering the Sage logic to calculate each line…
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 on the pre-totals event, that loops through any line items, and needs to get item related information for a given item. The problem I'm running into, is that in certain cases, the script runs, but the item information is returned as blank…
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 would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case:
sItemCode…
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…