Sage 300

I'm looking to add statistical information to my reporting and I'm wondering if anyone has found a way to make that work. If there's not a direct way to add these types of accounts does anyone have any ideas for workarounds?

Hi all, I know this is a very specific question but I am using Sage 300 Intelligence and I have consolidated 3 entities into one report (all 3 listed under Database Consolidation List). Within this report I have built financial statements for all 3…

I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…

Anybody know any search report name or report ID feature in Sage Intelligence?

When I try to filter the GL Transaction Details report for certain accounts, not all of the accounts show up in the drop down list. For instance it only goes to account 7700, but I have hundreds of accounts after that. Can anyone help. I feel like…

The GL account description is not pulling into my newly created balance sheet report. When I put in the formula =GLAccountDescription300("SAMINC", $B10) into my cell, when I run the report the account description is not pulling in, I just see the formula…

I have developed a new Sage Intelligence report for a client and had to create a new container. How can I export/copy the container to my clients computer? Also, how do I copy the new report that is associated with the computer.

Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…

I have successfully added the territory field to my sales report is Sage Intelligence, but I cannot get the field to total correctly. If I put the field before the customer number it total, but only for each customer. If I place the field to the left…

I need to total my Sage Intelligence Report by the state of the ship-to address. What table(s) do I need to link to Sales Master 3-0 data container.