x Want to participate? Join the group to interact

  • How to calculate month-end inventory?

    Hi everyone, I'm new to sage 50 US. I know that sage 50 can only show the month-end inventory balance for the last 12 months. What if I need to go back further? Is there a way I can do it on the back-end using the database and pervasive sql to do…

  • Sage 50 Intelligence Reporting Create SUM expression using GROUP BY or PARTITION

    I created a Sage 50 Intelligence report and need to create a SUM expression that uses the GROUP BY or PARTITION to be able to create a SUM based on the data in another column. I also want the sum to be included on every row of the data. Does anyone have…

  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…

*Community Hub is the new name for Sage City