Default Accounts Usage

From ADempiere ERP Wiki
Jump to navigationJump to search

Contributed by:
Quality Systems & Solutions - QSS Ltda.
Carlos Ruiz

Also see Default accounts,Default accounts 360lts.

Prefixes in Default Columns[edit]

Most of default accounts are prefixed this way:

Prefix Table
B C_BankAccount_Acct
C C_BP_Customer_Acct
V C_BP_Vendor_Acct
CB C_CashBook_Acct
CH C_Charge_Acct
PJ C_Project_Acct
T C_Tax_Acct
P M_Product_Acct
W M_Warehouse_Acct

M_Product_Acct default accounts are inherited from M_Product_Category_Acct (but can be modified)

Some C_BP_Customer_Acct and C_BP_Vendor_Acct are inherited from C_BP_Group_Acct (but can be modified)


Usage[edit]

Window, Tab Table Column Used in
Not Available A_ASSET_ACCT A_ACCUMDEPRECIATION_ACCT Not Used
A_ASSET_ACCT A_ASSET_ACCT Not Used
A_ASSET_ACCT A_DEPRECIATION_ACCT Not Used
Not Available A_ASSET_GROUP_ACCT A_ACCUMDEPRECIATION_ACCT Not Used
A_ASSET_GROUP_ACCT A_ASSET_ACCT Not Used
A_ASSET_GROUP_ACCT A_DEPRECIATION_ACCT Not Used
Accounting Schema -> Defaults C_ACCTSCHEMA_DEFAULT B_ASSET_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_EXPENSE_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_INTERESTEXP_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_INTERESTREV_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_INTRANSIT_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_PAYMENTSELECT_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_REVALUATIONGAIN_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_REVALUATIONLOSS_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_SETTLEMENTGAIN_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_SETTLEMENTLOSS_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_UNALLOCATEDCASH_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT B_UNIDENTIFIED_ACCT Default Level 1 -> Bank
C_ACCTSCHEMA_DEFAULT C_PREPAYMENT_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT C_RECEIVABLE_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT C_RECEIVABLE_SERVICES_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT CB_ASSET_ACCT Default Level 1 -> CashBook
C_ACCTSCHEMA_DEFAULT CB_CASHTRANSFER_ACCT Default Level 1 -> CashBook
C_ACCTSCHEMA_DEFAULT CB_DIFFERENCES_ACCT Default Level 1 -> CashBook
C_ACCTSCHEMA_DEFAULT CB_EXPENSE_ACCT Default Level 1 -> CashBook
C_ACCTSCHEMA_DEFAULT CB_RECEIPT_ACCT Default Level 1 -> CashBook
C_ACCTSCHEMA_DEFAULT CH_EXPENSE_ACCT Default Level 1 -> Charge
C_ACCTSCHEMA_DEFAULT CH_REVENUE_ACCT Default Level 1 -> Charge
C_ACCTSCHEMA_DEFAULT E_EXPENSE_ACCT Default Level 1 -> BP_Employee
C_ACCTSCHEMA_DEFAULT E_PREPAYMENT_ACCT Default Level 1 -> BP_Employee
C_ACCTSCHEMA_DEFAULT NOTINVOICEDRECEIPTS_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT NOTINVOICEDRECEIVABLES_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT NOTINVOICEDREVENUE_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT P_ASSET_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_COGS_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_COSTADJUSTMENT_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_EXPENSE_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_INVENTORYCLEARING_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_INVOICEPRICEVARIANCE_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_PURCHASEPRICEVARIANCE_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_REVENUE_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_TRADEDISCOUNTGRANT_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_TRADEDISCOUNTREC_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT PAYDISCOUNT_EXP_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT PAYDISCOUNT_REV_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT PJ_ASSET_ACCT Default Level 1 -> Project
C_ACCTSCHEMA_DEFAULT PJ_WIP_ACCT Default Level 1 -> Project
C_ACCTSCHEMA_DEFAULT REALIZEDGAIN_ACCT Allocation
C_ACCTSCHEMA_DEFAULT REALIZEDLOSS_ACCT Allocation
C_ACCTSCHEMA_DEFAULT T_CREDIT_ACCT Default Level 1 -> Tax
C_ACCTSCHEMA_DEFAULT T_DUE_ACCT Default Level 1 -> Tax
C_ACCTSCHEMA_DEFAULT T_EXPENSE_ACCT Default Level 1 -> Tax
C_ACCTSCHEMA_DEFAULT T_LIABILITY_ACCT Default Level 1 -> Tax
C_ACCTSCHEMA_DEFAULT T_RECEIVABLES_ACCT Default Level 1 -> Tax
C_ACCTSCHEMA_DEFAULT UNEARNEDREVENUE_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT UNREALIZEDGAIN_ACCT Default Level 1 -> BP_Group
Invoice Not Realized Gain/Loss
C_ACCTSCHEMA_DEFAULT UNREALIZEDLOSS_ACCT Default Level 1 -> BP_Group
Invoice Not Realized Gain/Loss
C_ACCTSCHEMA_DEFAULT V_LIABILITY_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT V_LIABILITY_SERVICES_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT V_PREPAYMENT_ACCT Default Level 2 -> BP_Group
C_ACCTSCHEMA_DEFAULT W_DIFFERENCES_ACCT Default Level 1 -> Warehouse
C_ACCTSCHEMA_DEFAULT W_INVACTUALADJUST_ACCT Default Level 1 -> Warehouse
C_ACCTSCHEMA_DEFAULT W_INVENTORY_ACCT Default Level 1 -> Warehouse
C_ACCTSCHEMA_DEFAULT W_REVALUATION_ACCT Default Level 1 -> Warehouse
C_ACCTSCHEMA_DEFAULT WITHHOLDING_ACCT Default Level 1 -> Withholding
C_ACCTSCHEMA_DEFAULT WRITEOFF_ACCT Default Level 1 -> BP_Group
Accounting Schema -> General Ledger C_ACCTSCHEMA_GL COMMITMENTOFFSET_ACCT MatchInv

Order (PO)
Requisition

C_ACCTSCHEMA_GL CURRENCYBALANCING_ACCT General Fact
C_ACCTSCHEMA_GL INCOMESUMMARY_ACCT Not Used
C_ACCTSCHEMA_GL INTERCOMPANYDUEFROM_ACCT General Fact
C_ACCTSCHEMA_GL INTERCOMPANYDUETO_ACCT General Fact
C_ACCTSCHEMA_GL PPVOFFSET_ACCT MatchPO
C_ACCTSCHEMA_GL RETAINEDEARNING_ACCT Not Used
C_ACCTSCHEMA_GL SUSPENSEBALANCING_ACCT General Fact
C_ACCTSCHEMA_GL SUSPENSEERROR_ACCT Not Used
Bank -> Account -> Accounting C_BANKACCOUNT_ACCT B_ASSET_ACCT Bank
C_BANKACCOUNT_ACCT B_EXPENSE_ACCT Not Used
C_BANKACCOUNT_ACCT B_INTERESTEXP_ACCT Bank
C_BANKACCOUNT_ACCT B_INTERESTREV_ACCT Bank
C_BANKACCOUNT_ACCT B_INTRANSIT_ACCT Bank

Cash
Payment

C_BANKACCOUNT_ACCT B_PAYMENTSELECT_ACCT Allocation

Payment (PO)

C_BANKACCOUNT_ACCT B_REVALUATIONGAIN_ACCT Not Used
C_BANKACCOUNT_ACCT B_REVALUATIONLOSS_ACCT Not Used
C_BANKACCOUNT_ACCT B_SETTLEMENTGAIN_ACCT Not Used
C_BANKACCOUNT_ACCT B_SETTLEMENTLOSS_ACCT Not Used
C_BANKACCOUNT_ACCT B_UNALLOCATEDCASH_ACCT Allocation

Payment (SO)

C_BANKACCOUNT_ACCT B_UNIDENTIFIED_ACCT Not Used
Business Partner -> Customer -> Customer Accounting C_BP_CUSTOMER_ACCT C_PREPAYMENT_ACCT Allocation

Payment

C_BP_CUSTOMER_ACCT C_RECEIVABLE_ACCT Allocation

Invoice (SO)

C_BP_CUSTOMER_ACCT C_RECEIVABLE_SERVICES_ACCT Invoice (SO)
Business Partner -> Employee -> Employee Accounting C_BP_EMPLOYEE_ACCT E_EXPENSE_ACCT Not Used
C_BP_EMPLOYEE_ACCT E_PREPAYMENT_ACCT Not Used
Business Partner Group -> Accounting C_BP_GROUP_ACCT C_PREPAYMENT_ACCT Default Level 1 -> BP_Customer
C_BP_GROUP_ACCT C_RECEIVABLE_ACCT Default Level 1 -> BP_Customer
C_BP_GROUP_ACCT C_RECEIVABLE_SERVICES_ACCT Default Level 1 -> BP_Customer
C_BP_GROUP_ACCT NOTINVOICEDRECEIPTS_ACCT InOut

MatchInv

C_BP_GROUP_ACCT NOTINVOICEDRECEIVABLES_ACCT Not Used
C_BP_GROUP_ACCT NOTINVOICEDREVENUE_ACCT Not Used
C_BP_GROUP_ACCT PAYDISCOUNT_EXP_ACCT Allocation
C_BP_GROUP_ACCT PAYDISCOUNT_REV_ACCT Allocation
C_BP_GROUP_ACCT UNEARNEDREVENUE_ACCT Invoice (SO)
C_BP_GROUP_ACCT V_LIABILITY_ACCT Default Level 1 -> BP_Vendor
C_BP_GROUP_ACCT V_LIABILITY_SERVICES_ACCT Default Level 1 -> BP_Vendor
C_BP_GROUP_ACCT V_PREPAYMENT_ACCT Default Level 1 -> BP_Vendor
C_BP_GROUP_ACCT WRITEOFF_ACCT Allocation
Business Partner -> Vendor -> Vendor Accounting C_BP_VENDOR_ACCT V_LIABILITY_ACCT Allocation

Invoice (PO)

C_BP_VENDOR_ACCT V_LIABILITY_SERVICES_ACCT Invoice (PO)
C_BP_VENDOR_ACCT V_PREPAYMENT_ACCT Allocation

Payment

Cashbook -> Accounting C_CASHBOOK_ACCT CB_ASSET_ACCT Cash
C_CASHBOOK_ACCT CB_CASHTRANSFER_ACCT Allocation

Cash

C_CASHBOOK_ACCT CB_DIFFERENCES_ACCT Cash
C_CASHBOOK_ACCT CB_EXPENSE_ACCT Cash
C_CASHBOOK_ACCT CB_RECEIPT_ACCT Cash
Charge -> Accounting C_CHARGE_ACCT CH_EXPENSE_ACCT Bank

Cash
Inventory
Invoice
Payment

C_CHARGE_ACCT CH_REVENUE_ACCT Bank

Cash
Inventory
Invoice
Payment

Currency -> Accounting C_CURRENCY_ACCT REALIZEDGAIN_ACCT Not Used
C_CURRENCY_ACCT REALIZEDLOSS_ACCT Not Used
C_CURRENCY_ACCT UNREALIZEDGAIN_ACCT Not Used
C_CURRENCY_ACCT UNREALIZEDLOSS_ACCT Not Used
Not Available C_INTERORG_ACCT INTERCOMPANYDUEFROM_ACCT Not Used
C_INTERORG_ACCT INTERCOMPANYDUETO_ACCT Not Used
Project -> Accounting C_PROJECT_ACCT PJ_ASSET_ACCT ProjectIssue
C_PROJECT_ACCT PJ_WIP_ACCT ProjectIssue
Revenue Recognition -> Revenue Recognition Plan C_REVENUERECOGNITION_PLAN P_REVENUE_ACCT Created
C_REVENUERECOGNITION_PLAN UNEARNEDREVENUE_ACCT Created
Tax Rate -> Accounting C_TAX_ACCT T_CREDIT_ACCT Invoice (PO)
C_TAX_ACCT T_DUE_ACCT Invoice (SO)
C_TAX_ACCT T_EXPENSE_ACCT Invoice (PO)
C_TAX_ACCT T_LIABILITY_ACCT Not Used
C_TAX_ACCT T_RECEIVABLES_ACCT Not Used
Withholding -> Accounting C_WITHHOLDING_ACCT WITHHOLDING_ACCT Not Used
Product -> Accounting M_PRODUCT_ACCT P_ASSET_ACCT InOut

Inventory
Movement
Production
ProjectIssue

M_PRODUCT_ACCT P_COGS_ACCT InOut
M_PRODUCT_ACCT P_COSTADJUSTMENT_ACCT Invoice
M_PRODUCT_ACCT P_EXPENSE_ACCT InOut

Invoice (PO)
MatchInv
Order (PO)
ProjectIssue
Requisition

M_PRODUCT_ACCT P_INVENTORYCLEARING_ACCT Invoice (PO)

MatchInv

M_PRODUCT_ACCT P_INVOICEPRICEVARIANCE_ACCT MatchInv
M_PRODUCT_ACCT P_PURCHASEPRICEVARIANCE_ACCT MatchPO
M_PRODUCT_ACCT P_REVENUE_ACCT Invoice (SO)
M_PRODUCT_ACCT P_TRADEDISCOUNTGRANT_ACCT Invoice (SO)
M_PRODUCT_ACCT P_TRADEDISCOUNTREC_ACCT Invoice (PO)
Product Category -> Accounting M_PRODUCT_CATEGORY_ACCT P_ASSET_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_COGS_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_COSTADJUSTMENT_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_EXPENSE_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_INVENTORYCLEARING_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_INVOICEPRICEVARIANCE_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_PURCHASEPRICEVARIANCE_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_REVENUE_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_TRADEDISCOUNTGRANT_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_TRADEDISCOUNTREC_ACCT Default Level 1 -> Product
Warehouse & Locators -> Accounting M_WAREHOUSE_ACCT W_DIFFERENCES_ACCT Inventory
M_WAREHOUSE_ACCT W_INVACTUALADJUST_ACCT Not Used
M_WAREHOUSE_ACCT W_INVENTORY_ACCT Not Used
M_WAREHOUSE_ACCT W_REVALUATION_ACCT Not Used