• 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…
  • Financial Reporter - equivalent SQL statement of FRAMTA("BALP")

    Hi, Does someone written and willing to share a SQL statement that is an equivalent of FRAMTA("BALP") from the Financial Reporter? I am trying to figure out how our GL Inventory account is calculated. I read one of the discussions to run trial balance…