Need help expanding a trail balance crystal report
I'm new to B1 (v8.8), but have been writing reports for years.
I just finished up a trail balance report.
Account / Currency / Debit / Credit / Balance (Debit - Credit)
I would like to add more detail to it.
I would like to group the report by the account, then by the customer, then by items (that make up the debit/credit totals for the account) I've tried using the inv1 table, but the totals where way off. Can this be done? If so, what tables/joins are needed..
Thank you for any help given.