Hi @ketiller! For this issue you’ll need to join in the GLHistoryByPeriod table to get these balances:
https://help-2021r1.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=0706f316-2b71-6254-44dc-65544025f479
GLHistoryByPeriod
GLHistoryByPeriod is a projection based on the GLHistory and FinPeriod DACs join, which obtains the last period to which each GL entry has been posted (last period for which GLHistory record exists) that is less or equal to the specified period for each account-subaccount pair.
GLHistory is used as primary on BQL select but semantically the basic table is FinPeriod: the projection joins GHistory records with less or equal FinPeriodID to each FinPeriod record which generates a set of all previous (including current) existing periods with posted data for each financial period. Then the projection groups obtained sets by FinPeriod.FinPeriodID field and extracts maximum GHistory. FinPeriodID as last activity period for each group. See the calculation scheme on the following diagram.
)/wiki/Frames/GetFile.ashx?fileID=8b972d1d-1913-2a96-e55c-145e9f9005b7&cache=yes)
To obtain last activity period for the needed period, you should specify the needed period for GLHistoryByPeriod.FinPeriodID field; GLHistoryByPeriod.LastActivityPeriod will contain last existing period with data.
@BenjaminCrisman How would you join the tables GLHistoryByPeriod to GLTranR
Thank you,
KT
@ketiller I don’t know that it connects directly to GLTranR, you would need to link GLTranR to GLHistory and then GLHistory to GLHistoryByPeriod.
Did you already try this?
