Skip to Content
Former Member
Jun 07, 2011 at 10:14 AM

Need help expanding a trail balance crystal report


Hi All,

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.