GI to show ending balance and Turnover amount

Hi ​@saravana409865 

Please use the fields as shown in the screenshot below. I have tested this and found the results to be correct for Account Details.

Best Regards,

NNT

Hi ​@saravana409865,

The difference you’re seeing is expected based on how the GI is currently built.

Your Generic Inquiry is based on PX.Objects.GL.GLHistory and is grouped only by Period. Because of that, Acumatica aggregates balances across all accounts, branches (and possibly subaccounts) for the same period. This causes the Ending Balance and Turnover amounts to differ from what you see on the Account Details screen, which calculates balances per Account + Branch (+ Subaccount) and for a specific period range.

How to fix it:

1. Adjust the grouping

   • Either remove grouping entirely, or group by all required keys:

     • Account (AccountID / AccountCD)

     • BranchID

     • FinPeriodID

     • SubID (if subaccounts are used)

2. Use the correct fields

   • For Ending Balance, use FinYtdBalance / CuryFinYtdBalance

   • For Turnover, use FinPtdDebit + FinPtdCredit (or debit/credit separately)

3. Recommended approach

   • Build the GI on GLHistoryByPeriod instead of GLHistory.
     This is much closer to how Account Details calculates balances and helps avoid mismatches.

Also note that Account Details applies additional runtime filters (From/To Period, Include Reclassified, Include Unposted, etc.), which a GI will not automatically replicate unless you explicitly design it that way.

Once grouping and fields are aligned, the GI results should match Account Details much more closely.

Hi , 

I tried both solution - 

Please find result below

GI result

Expected Result

As the Account summary not showing correct data.

Also when i add GLhistorybyPeriod, thereis no amount field to show

If you’re joining in the GLHistoryByPeriod table, you still need to keep the GLHistory table.  The GLHistoryByPeriod table fills in the gaps if you have account combinations that haven’t been used in certain periods.
 

For the sample below, here’s my results grid.  I don’t currently have any parameters or conditions on my inquiry.
 

Also, watch out for different ledgers, companies/branches/subaccount combinations.  Here in my screen I have transactions from 2 different branches, 2 different ledgers and 2 different subaccounts all on the same GL account in a single period (so 6 records total)

These records match what I see in the Account Details screen for the “Actual” ledger and match what I loaded in my budget ledger.

If I only group by Account and Period, I get somewhat “misleading” results, as I haven’t set up any filtering to include/exclude companies/branches or other ledgers (i.e. budget ledgers)