Skip to main content
Question

Account ending balance on each transaction line

  • July 30, 2026
  • 2 replies
  • 51 views

Forum|alt.badge.img

Hi, I’ve created a very simple GI to show account’s history out of GLTranR DAC. However, I am unable to pull the beginning and ending balance data. The goal is to show each GL Account ending balance per transaction line. Basically, like the below showing the Account ID, BegBal, Debit and Credit Amt and its ending balance on that day.

Attached is the GI I created. I am open to suggestions or if you could modify the GI to achieve this, that’d be great as I think many of users/consultants would want this. Thanks heaps! 😊

I’ve created a GI to show ending balance per period, but we do need the specific date rather than the period with no way to check at any other point in time. With a date filter we simply go back to the day we need to check.

2 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+7

Forum|alt.badge.img
  • Author
  • Varsity I
  • August 3, 2026

@mohammadnawaz51 Thanks, but I’ve already created a GL Balance by period, but the requirement is to show beginning balance, debit amount, credit amount and the ending balance for each transaction date just like how account details is designed.

The reason why this needs to be in a GI is that it needs to feed via Odata for integration purposes, so Account Details won’t work for it but we need the same data.