This page shows the list of database fields that are checked during the GL Account Delete
Software Version: 2023.05.31 and newer
Page Header
...
Toolbar Icons
...
Description
...
Column Filter Show/Hide
...
Excel
...
Favorites
...
Group By Show/Hide
...
Help
...
New
...
Quick Column Filter
...
Save
...
Saved Layouts
...
Fields
...
Description
...
Account
...
The unique identifier of the GL Account record. This defaults to blank but is required for all records, must be unique and must be <= 75 characters. If not assigned, the record is not saved. If assigned, the Account must contain the correct number of segments and each segment must be the correct length as specified in the GL Account Format page. This field is editable if integration is set to None, otherwise it is disabled after the initial Save.
Linked Database Field: ERPx_GLAccount.AccountNumber
...
Account Class
...
A single-select standard lookup to assign the Class the GL Account belongs to. This is only used for reporting and does not control any other behavior in NorthScope. This defaults to blank and is required. If not assigned, the message "Account Class is required." will be displayed on Save. This field is always editable. If either the 'Posting Type' field or the 'Category' field are updated, then the value in this field will be cleared.
Linked Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK
This lookup contains a list of all 'Active' Account Classes that match the selected 'Category'.
...
Account Description
...
The name associated with the GL Account. This is required for all records, does not need to be unique, and must be <= 75 characters. If not assigned, the message "Account Description is required." will be displayed on Save. This field is always editable.
Linked Database Field: ERPx_GLAccount.Description
...
Category
Identifies the Category associated with the GL Account. This is a single-select standard lookup that is required. This defaults as blank and is always editable. If the 'Posting Type' field is updated, then the value in this field will be cleared.
Linked Database Field: ERPx_GLAccountClass.GLAccountClassCategoryEN
...
Control Account Type
A single-select standard lookup to identify GL Accounts that balance to a subsidiary journal. The Control Account Type identifies which subsidiary the account balances to and some GL Account look-ups are limited to only accounts within a specified Control Account Type. This defaults to blank and is not required. This field is always editable.
...
Linked Database Field: ERPx_GLAccount.GLControlAccountTypeEN
This lookup contains all the values in the GLControlAcctType Enumeration Class.
...
Inactive
...
A Yes/No field used to identify if the GL Account is Inactive. If set to 'Yes' then the GL Account will not be included in look-ups for transactions or other master files. If set to 'No' then the record can be freely used. This value is always editable but users will not be able to inactivate a GL Account that has a current balance, the message "You cannot inactivate a GL Account with a balance." will be displayed on Save.
Linked Database Field: ERPx_GLAccount.IsInactive
...
Posting Type
...
A single-select standard lookup to select whether the Account belongs on the Balance Sheet or Income Statement. This defaults to 'Balance Sheet' and is required. This field is always
"The Posting Type of account XXXX-XX-XXX-XX cannot be changed because it was used in a previous year end closing entry. Year End entries can be reversed if you need to change the Posting Type."
"The Posting Type of account XXXX-XX-XXX-XX cannot be changed because it is a balance sheet account and has an ending balance in a closed year. Year End entries can be reversed if you need to change the Posting Type."
Balance Sheet Accounts roll over and Income Statement Accounts are closed to Retained Earnings when a Year-End is run.
Linked Database Field: ERPx_GLAccount.GLAccountPostingTypeEN
This lookup contains all the values in the GLAccountPostingType Enumeration Class.
...
Typical Balance
...
A single-select standard lookup to select whether the Account typically carries a Debit or Credit balance. This defaults to Debit, is always required, and is always editable.
Linked Database Field: ERPx_GLAccount.GLTypicalBalanceEN
This lookup contains all the values in the GLTypicalBalance Enumeration Class.
...
Use In AP
...
A Yes/No lookup to identify whether or not the 'GL Account' will be included in the Purchase Account lookup for AP Invoices and Credit Memo transactions. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for AP transactions and a value of "No" means that it will not.
This is also evaluated for imported records that come through the Inbound Integration tables.
Linked Database Field: ERPx_GLAccount.UseInAP
...
Use In GL
...
A Yes/No lookup to identify whether or not the 'GL Account' will be included in manual journal entry 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for journal entries and a value of "No" means that it will not.
This is also evaluated for imported records that come through the Inbound Integration tables.
Linked Database Field:ERPx_GLAccount.UseInGL
...
Use In IM
...
A Yes/No lookup to identify whether or not the 'GL Account' will be included in Inventory transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Inventory transaction line items and a value of "No" means that it will not.
Linked Database Field: ERPx_GLAccount.UseInIM
...
Use In SO
...
A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Sales transaction line items and a value of "No" means that it will not.
Linked Database Field: ERPx_GLAccount.UseInSO
...
Use In SP
A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Program 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account" look-ups for Sales Program transactions look-ups and a value of "No" means that it will not.
...
Table | Field |
|---|---|
ERPx_APDeliveryTicketItem | PurchaseAccountSK |
ERPx_APDeliveryTicketLine | PurchaseGLAccountSK |
ERPx_APDeliveryTicketLineProgram | CompanyExpenseAccountSK |
ERPx_APDeliveryTicketLineProgram | CRAccountSK |
ERPx_APDeliveryTicketLineProgram | DRAccountSK |
ERPx_APPoLine | AccountSK |
ERPx_APPProgram | CompanyExpenseAccountSK |
ERPx_APPProgram | CRAccountSK |
ERPx_APPProgram | DRAccountSK |
ERPx_APPProgramEntity | ExpenseAccountSK |
ERPx_APPProgramEntity | LiabilityAccountSK |
ERPx_APSettlementTransaction | AccruedToGLAccountSK |
ERPx_APSpecie | PurchaseAcctSK |
ERPx_APTransactionLine | AccountSK |
ERPx_APTransactionTax | AccountSK |
ERPx_APVendor | APGLAcctRef |
ERPx_APVendor | CashGLAcctRef |
ERPx_APVendor | DisctTakenGLAcctRef |
ERPx_APVendor | FinanceChargeGLAcctRef |
ERPx_APVendor | PurchGLAcctRef |
ERPx_APVendor | SAGLAcctRef |
ERPx_APVendor | WriteOffGLAcctRef |
ERPx_APVendorClass | APGLAcctRef |
ERPx_APVendorClass | CashGLAcctRef |
ERPx_APVendorClass | DistTakenGLAcctRef |
ERPx_APVendorClass | FinanceChargeGLAcctRef |
ERPx_APVendorClass | PurchGLAcctRef |
ERPx_APVendorClass | SAGLAcctRef |
ERPx_APVendorClass | WriteOffGLAcctRef |
ERPx_APVendorInterestCalculationLine | FinanceChargeGLAccountSK |
ERPx_ARCustomer | COGSActSK |
ERPx_ARCustomer | FinanceChgActSK |
ERPx_ARCustomer | GLARAccountSK |
ERPx_ARCustomer | InventoryActSK |
ERPx_ARCustomer | OverPmtWriteOffActSK |
ERPx_ARCustomer | SalesActSK |
ERPx_ARCustomer | SalesReturnActSK |
ERPx_ARCustomer | TermsDiscAvailActSK |
ERPx_ARCustomer | TermsDiscTakenActSK |
ERPx_ARCustomer | WriteOffActSK |
ERPx_ARCustomerClass | ARGLAcctRef |
ERPx_ARCustomerClass | COGSActSK |
ERPx_ARCustomerClass | FinanceChgActSK |
ERPx_ARCustomerClass | InventoryActSK |
ERPx_ARCustomerClass | OverPmtWriteOffActSK |
ERPx_ARCustomerClass | SalesActSK |
ERPx_ARCustomerClass | SalesReturnActSK |
ERPx_ARCustomerClass | TermsDiscAvailActSK |
ERPx_ARCustomerClass | TermsDiscTakenActSK |
ERPx_ARCustomerClass | WriteOffActSK |
ERPx_ARSettlementApplication | WriteoffAccountSK |
ERPx_ARTransactionLine | AccountSK |
ERPx_CPAccrual | CRAccountSK |
ERPx_CPAccrual | DRAccountSK |
ERPx_CPCharge | CRAccountSK |
ERPx_CPCharge | DRAccountSK |
ERPx_CPItem | PurchaseGLAccountSK |
ERPx_CPTicketItem | PurchaseGLAccountSK |
ERPx_DW_FNJournalLine | AccountSK |
ERPx_GLAccountPeriodSummary | AccountSK |
ERPx_GLJournalLine | GLAccountSK |
ERPx_GLJournalLineDetail | GLAccountSK |
ERPx_IMItem | BrokerageAccrualActSK |
ERPx_IMItem | BrokerageExpActSK |
ERPx_IMItem | BrokerageWriteOffActSK |
ERPx_IMItem | COGSActSK |
ERPx_IMItem | FreightAccrualCreditActSK |
ERPx_IMItem | FreightAccrualDebitActSK |
ERPx_IMItem | FreightRevenueActSK |
ERPx_IMItem | InventoryActSK |
ERPx_IMItem | InventoryProductionOffsetGLAccountSK |
ERPx_IMItem | InventoryValuationGainLossGLAccountSK |
ERPx_IMItem | InvOffsetActSK |
ERPx_IMItem | PurchaseClearingGLAccountSK |
ERPx_IMItem | PurchaseGLAccountSK |
ERPx_IMItem | PurchasePriceVarianceGLAccountSK |
ERPx_IMItem | SalesActSK |
ERPx_IMItem | SalesReturnsActSK |
ERPx_IMItem | TransferFrtAccrualGLAccountSK |
ERPx_IMItem | TransferFrtExpenseGLAccountSK |
ERPx_IMItemClass | BrokerageAccrualActSK |
ERPx_IMItemClass | BrokerageExpActSK |
ERPx_IMItemClass | BrokerageWriteOffActSK |
ERPx_IMItemClass | COGSActSK |
ERPx_IMItemClass | FreightAccrualCreditActSK |
ERPx_IMItemClass | FreightAccrualDebitActSK |
ERPx_IMItemClass | FreightRevenueActSK |
ERPx_IMItemClass | InventoryActSK |
ERPx_IMItemClass | InventoryProductionOffsetGLAccountSK |
ERPx_IMItemClass | InventoryValuationGainLossGLAccountSK |
ERPx_IMItemClass | InvOffsetActSK |
ERPx_IMItemClass | PurchaseClearingGLAccountSK |
ERPx_IMItemClass | PurchaseGLAccountSK |
ERPx_IMItemClass | PurchasePriceVarianceGLAccountSK |
ERPx_IMItemClass | SalesActSK |
ERPx_IMItemClass | SalesReturnsActSK |
ERPx_IMItemClass | TransferFrtAccrualGLAccountSK |
ERPx_IMItemClass | TransferFrtExpenseGLAccountSK |
ERPx_IMLotCostPostingLog | GLAccountSKCredit |
ERPx_IMLotCostPostingLog | GLAccountSKDebit |
ERPx_IMTransactionClass | FreightVarianceGLAccountSKForDeliveredFreight |
ERPx_IMTransactionClass | TransferFreightAccrualGLAccountSK |
ERPx_MFCheckbook | CashAccountSK |
ERPx_MFCheckbookDetail | AccountSK |
ERPx_MFSysPreferences | DefaultSettlementAccrualAcct |
ERPx_MFSysPreferences | InterestPaymentGLAccount |
ERPx_MFSysPreferences | InterestRevenueGLAccount |
ERPx_MFSysPreferences | RetainedEarningsGLAcct |
ERPx_MFTaxDetail | GLAccountSK |
ERPx_SOOrderTypeDocument | FreightVarianceGLAccountSKForDeliveredFreight |
ERPx_SOOrderTypeDocument | SalesFreightAccrualGLAccountSK |
ERPx_SOTransactionTax | AccountSK |
ERPx_SPProgramHeader | CRAccountSK |
ERPx_SPProgramHeader | DRAccountSK |
ERPx_SPProgramSettlementItem | AccruedCRAccountSK |
ERPx_SPProgramSettlementItem | AccruedDRAccountSK |
ERPx_SPProgramSettlementItem | SettleCRAccountSK |
ERPx_SPProgramSettlementItem | SettleDRAccountSK |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...