ArmGLHistoryByPeriod

PX.Objects.CSRelease 2025.2

The DAC used to simplify selection and aggregation of proper GLHistory records on various inquiry and processing screens of the General Ledger module. The main purpose of this DAC is to close the gaps in GL history records, which appear in case GL history records do not exist for every financial period defined in the system. To close these gaps, this projection DAC calculates the last activity period for every existing financial period, so that inquiries and reports that produce information for a given financial period can look at the latest available GLHistory record.

Select a row for its description 8 of 8 fields

	Field Name	Type	Display Name	Foreign Key
	`AccountClassID`	`nvarchar(20)`		-
Description:No description available
	`AccountID`Default Navigation	`int`	Account	Account
Description:Identifier of the Account associated with the history record. Corresponds to the Account.AccountID field.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:Identifier of the Branch, which the history record belongs. Corresponds to the Branch.BAccountID field.
	`FinPeriodID`	`string`	Financial Period	-
Description:Identifier of the Financial Period, for which the history data is given.
	`FinYear`Nonexistent in DB	`string`		-
Description:Financial year, to which history data belongs
	`LastActivityPeriod`	`string`	Last Activity Period	-
Description:Identifier of the Financial Period of the last activity on the Account and Subaccount associated with the history record, with regards to Ledger and Branch.
	`LedgerID`Default Navigation	`int`	Ledger	Ledger
Description:Identifier of the Ledger, which the history record belongs. Corresponds to the Ledger.LedgerID field.
	`SubID`Default Navigation	`int`	Subaccount	Sub
Description:Identifier of the Subaccount associated with the history record. Corresponds to the Sub.SubID field.