Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question