Offset GL entries for postings in a GL account

(1) Share

Report

Posted on by CU13010319-0

579

I have quite a few postings toward a GL account, with offset entries on the balancing account from General journals. However I also have postings where the balancing account wasn't used, and where multi line journals are used for the same document no. I want to be able to see the offset entries to the account, whether debits or credits. So for example if Dr GL 123 for $1000, I'd like to see all the possible credits associated with the account, even if the balancing account wasn't used. I can find this in the find entries, but I would like a report that can show all the offset entries. Is there a report, even if Power BI, that can show this?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 102,229 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

As far as I know, the standard cannot do that.

However, you can first try the following functionality; if that does not meet your needs, you can use the G/L Register No. to link all the entries associated with this posting and analyze them using external reporting tools, such as Power BI.

More details: https://yzhums.com/4985/

Thanks

ZHU

Was this reply helpful? Yes No