• How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • GL report - opening balances

    Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not using…
  • Unable to print out the traditional & simplified Chinese text in the standard GL report

    I had an installation with English, Simplified Chinese and Traditional Chinese language in version 2012 with product update 6. MSSQL Databases collation used are 'Chinese_PRC_CI_AS' and 'Chinese _Taiwan Stroke_CI_AS'. Sage 300 login user with language…
  • Financial Reporter

    Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query. They are trying to insert ”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…