GLSetup

PX.Objects.GLScreensGL102000GL103000Release 2025.2

The preferences of the general ledger functionality. A user edits the records of this type on the General Ledger Preferences (GL102000) form.

Select a row for its description 32 of 32 fields

	Field Name	Type	Display Name	Foreign Key
	`AllocationNumberingID`Default Navigation	`nvarchar(10)`	Allocation Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used for allocations. See the GLAllocation DAC. Corresponds to the Numbering.NumberingID field.
	`AutoPostOption`	`bit`	Automatically Post on Release	-
Description:Determines whether the system must automatically post Batches once they are released. When this option is set to "true" there won't be any batches with status Unposted in the system.
	`AutoReleaseReclassBatch`	`bit`	Automatically Release Reclassification Batches	-
Description:No description available
	`AutoRevEntry`	`bit`	Create Negative Entries on Reversal	-
Description:Determines whether the system creates negative entries when reversing a Batch. If set to "true", the transactions of the reversing batch will retain the Debit/Credit amounts of the original transactions, but with opposite signs. If set to "false", the transactions of the reversing batch will retain the sign of the original amounts, but will have them on the opposite sides of Debit/Credit.
	`AutoRevOption`	`char(1)`	Generate Reversing Entries	-
Description:Determines when the system generates reversing batches. Possible values are: ""P"" - On Post and ""C"" - On Period Closing. Default value is On Post.
	`BatchNumberingID`Default Navigation	`nvarchar(10)`	Batch Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used for batches. Corresponds to the Numbering.NumberingID field.
	`COAOrder`	`smallint`	Chart of Accounts Order	-
Description:Determines the order of Accounts in the reports of the General Ledger module. Allowed values are: "0" - 1.Assets, 2.Liabilities, 3.Income and Expenses "1" - 1.Assets, 2.Liabilities, 3.Income, 4.Expenses "2" - 1.Income, 2. Expenses, 3. Assets, 4.Liabilities "3" - 1.Income and Expenses, 2. Assets, 3.Liabilities "128" - Custom order. If the last option is selected, the order of accounts is determined by the COAOrder field of the individual Accounts. Defaults to "0".
	`ConsolSegmentId`Default Navigation	`smallint`	Consolidation Segment Number	Segment
Description:The identifier of the Segment of the Subaccount segmented key, whose values denote the consolidation unit in the subaccounts of the parent company. Controls the selector on the GLConsolSetup.SegmentValue field. Corresponds to the Segment.SegmentID field.
	`ConsolidatedPosting`	`bit`	Generate Consolidated Batches	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`DefaultSubID`Default Navigation	`int`	Default Subaccount	Sub
Description:Identifier of the Subaccount to be used as the default one with Accounts, which have the NoSubDetail field set to "true". Corresponds to the Sub.SubID field.
	`DocBatchNumberingID`Default Navigation	`nvarchar(10)`	Document Batch Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used for batches of documents created on the Journal Vouchers (GL304000) form. See the GLDocBatch DAC. Corresponds to the Numbering.NumberingID field.
	`HoldEntry`	`bit`	Hold Batches on Entry	-
Description:Determines whether the system must set the Hold flag and Status On Hold when creating new batches. Defaults to "true".
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`PerRetainTran`	`smallint`	Keep Transactions for	-
Description:Determines the number of periods the system will keep the transactions in the database. Defaults to "99".
	`PostClosedPeriods`Obsolete	`bit`	Allow Posting to Closed Periods	-
Description:Determines whether the system allows to post transactions to closed Financial Periods. If set to "false", the system raises an error on attempts to enter or post transactions into a closed period. Defaults to "false".
	`Prediction`	`decimal`	Prediction	-
Description:No description available
	`RequireControlTotal`	`bit`	Validate Batch Control Totals on Entry	-
Description:Indicates whether the system must enforce validation of batch control totals on Journal Transactions (GL301000) form. When set to "true" the control total and debit/credit total of batches must match and user won't be able to save the batch until this condition is met. Otherwise, validation is performed only after clearing the Hold flag on the Batch. Defaults to "false".
	`RequireRefNbrForTaxEntry`	`bit`	Require Ref. Numbers for GL Documents with Taxes	-
Description:Indicates whether the Reference Number fields are required on Journal Transactions (GL301000) form in case of entering Gl transactions with taxes.
	`RestrictAccessToClosedPeriods`	`bit`	Restrict Access to Closed Periods	-
Description:No description available
	`RetEarnAccountID`Default Navigation	`int`	Retained Earnings Account	Account
Description:Identifier of the Retained Earnings Account. The account is updated by the amount accumulated on the YTD Net Income account during the financial year closing. Corresponds to the Account.AccountID field.
	`ReuseRefNbrsInVouchers`	`bit`	Reuse reference numbers in Journal Vouchers	-
Description:Determines whether the reference numbers for documents created on the Journal Vouchers (GL304000) form are reused in case the number was allocated for the document that was not persisted, or the document was deleted thus freeing the reference number. When set to "true", the system will pick up the free numbers from such documents when creating new entries on the mentioned form. (Note: this may lead to non-linear numbering.) Otherwise the form will always assign new numbers to the documents even if there are reusable ones. Defaults to "true".
	`ScheduleNumberingID`Default Navigation	`nvarchar(10)`	Schedule Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used for schedules. See the Schedule DAC. Corresponds to the Numbering.NumberingID field.
	`TBImportNumberingID`Default Navigation	`nvarchar(10)`	Import Numbering Sequence	Numbering
Description:The identifier of the Numbering Sequence used for imports of trial balances. See the GLTrialBalanceImportMap DAC. Corresponds to the Numbering.NumberingID field.
	`TrialBalanceSign`	`nvarchar`	Sign of the Trial Balance	-
Description:Determines whether the system should automatically change the sign of the trial balance when importing data. Also affects the way trial balance is displayed on reports and inquiries. Allowed values are: ""N"" - Normal - the system doesn't change the signs of balances of expense and income accounts on import. On reports and inquiries all the accounts are grouped by account type. ""R"" - Reversed - the system reverses the signs of balances of expense and income accounts on import. On reports and inquiries all the accounts except for the Year-to-Date Net Income account are listed. Defaults to ""N"".
	`VouchersHoldEntry`	`bit`	Hold Vouchers on Entry	-
Description:Determines whether the system must set the Hold flag and Status On Hold when creating new vouchers. Defaults to "true".
	`YtdNetIncAccountID`Default Navigation	`int`	YTD Net Income Account	Account
Description:Identifier of the Year-to-Date Net Income Account. The account tracks net income accumulated since the beginning of the financial year. It is updated by every transaction posted in the system. The account must not be changed after any journal transactions have been posted. Corresponds to the Account.AccountID field. Only Accounts of type Liability (""L"") can be specified as YTD Net Income account.
	`tstamp`	`timestamp`		-
Description:No description available