GLSetup

PX.Objects.GL

31 of 31 fields

	Field Name	Type	Display Name	Foreign Key
	`AllocationNumberingID`Default Navigation	`nvarchar(10)`	Allocation Numbering Sequence	Numbering
Description:No description available
	`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:No description available
	`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".
	`ConsolidatedPosting`	`bit`	Generate Consolidated Batches	-
Description:No description available
	`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.
	`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:No description available
	`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".
	`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:No description available
	`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:No description available
	`TBImportNumberingID`Default Navigation	`nvarchar(10)`	Import Numbering Sequence	Numbering
Description:No description available
	`TrialBalanceSign`	`char(1)`	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"".
	`tstamp`	`timestamp`		-
Description:No description available
	`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:No description available