I am writing a report to get the Sales amount from the G/L Entry table filtered by posting date, account no., grouped by Gen. Business Posting Group and totaled by Item Category. All fields are on the G/L entry table except Item Category. I have linked the G/L Entry table to the Value Entry table through the G/L - Item Ledger Relation table. However, the amounts are returning with no results. When I "hard key" the item category code in design mode, I get a balance but if I run it, everything returns as $0 and then returning to design mode, shows it as $0. I have tried it through the G/L entry table and through the Value entry table with no success. Any help would be appreciated.
Linked Filter based on NL Rows result