GLHistoryByPeriod

PX.Objects.GLRelease 2025.2

The DAC that is used to simplify selection and aggregation of proper GLHistory records on various inquiry and processing forms related to the general ledger functionality. 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 master financial period, so that inquiries and reports that produce information for a given master 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
	`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:No description available
	`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.
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`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.