[kingson513]

Hi All,

We want a report like a A/R Register, but want to group by the customer.

We have tried to move the customer field to the be the grouping field and save.

It saved successfully.

But the opening balance of each of the customer are the total of A/R balance.

This is not reasonable.

or is it i am using a wrong report to do such propose?

I am using the A/R Register to do customize.

Customer (Group)

Type Date No. Memo Date Due Amt Chrg / Amt Paid

How to get the report to be correct?

Kingson
This is a cached copy. Click here to see the original post.

[Kouji]

Hello Kingson,

I made some research on this and I found out that arbitrary hierarchies (like a per customer beginning balance) are not yet supported. Enhancement 246826 – General Ledger > Customize > add Entity Name (Grouped) and ticked the Group with Previous Columns option > results show the same beginning balance for each customer and overstated total balance per account has been filed to request this functionality.

I also tried using the Balance Sheet Detail report to no avail.

[Author]

Posts