Sage 100

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…

I want to perform a operation through VBScript , after that I want the cursor to be focused on a specific grid cell. How do I do That ?

Can anyone please explain why the total is getting rounded off in sales order section

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 UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…