Difference between revisions of "Default Accounts Usage"

From iDempiere en
(initial load)
 
m (Reverted edits by Xiaobai (talk) to last revision by Thomas Thießen)
 
(27 intermediate revisions by 7 users not shown)
Line 1: Line 1:
−
= Default Accounts Usage =
 
−
 
 
Contributed by:<br>
 
Contributed by:<br>
 
Quality Systems & Solutions - QSS Ltda.<br>
 
Quality Systems & Solutions - QSS Ltda.<br>
 
[[User:CarlosRuiz|Carlos Ruiz]]
 
[[User:CarlosRuiz|Carlos Ruiz]]
  
 +
== Prefixes in Default Columns ==
 +
 +
Most of default accounts are prefixed this way:
  
−
{| border="1"  
+
{| border="0"  
 
|-  
 
|-  
−
!width="150"| Window, Tab
+
! Prefix
−
!width="100"| Table  
+
! Table
−
!width="100"| Column
 
−
!width="100"| Used in
 
 
|-
 
|-
−
| Not Available || A_ASSET_ACCT || A_ACCUMDEPRECIATION_ACCT || Not Used
+
| B || C_BankAccount_Acct
 
|-
 
|-
−
| || A_ASSET_ACCT || A_ASSET_ACCT || Not Used
+
| C || C_BP_Customer_Acct
 
|-
 
|-
−
| || A_ASSET_ACCT || A_DEPRECIATION_ACCT || Not Used
+
| V || C_BP_Vendor_Acct
 
|-
 
|-
−
| Not Available || A_ASSET_GROUP_ACCT || A_ACCUMDEPRECIATION_ACCT || Not Used
+
| CH || C_Charge_Acct
 
|-
 
|-
−
| || A_ASSET_GROUP_ACCT || A_ASSET_ACCT || Not Used
+
| PJ || C_Project_Acct
 
|-
 
|-
−
| || A_ASSET_GROUP_ACCT || A_DEPRECIATION_ACCT || Not Used
+
| T || C_Tax_Acct
 
|-
 
|-
−
| Accounting Schema -> Defaults || C_ACCTSCHEMA_DEFAULT || B_ASSET_ACCT || Default Level 1
+
| P || M_Product_Acct
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || B_EXPENSE_ACCT || Default Level 1
+
| W || M_Warehouse_Acct
−
|-
+
|}
−
| || C_ACCTSCHEMA_DEFAULT || B_INTERESTEXP_ACCT || Default Level 1
+
 
−
|-
+
M_Product_Acct default accounts are inherited from M_Product_Category_Acct (but can be modified)
−
| || C_ACCTSCHEMA_DEFAULT || B_INTERESTREV_ACCT || Default Level 1
+
 
−
|-
+
C_BP_Customer_Acct and C_BP_Vendor_Acct are inherited from C_BP_Group_Acct (but can be modified)
−
| || C_ACCTSCHEMA_DEFAULT || B_INTRANSIT_ACCT || Default Level 1
+
 
−
|-
+
== Usage ==
−
| || C_ACCTSCHEMA_DEFAULT || B_PAYMENTSELECT_ACCT || Default Level 1
+
 
−
|-
+
{| border="1"
−
| || C_ACCTSCHEMA_DEFAULT || B_REVALUATIONGAIN_ACCT || Default Level 1
+
|-  
−
|-
+
!width="150"| Window, Tab
−
| || C_ACCTSCHEMA_DEFAULT || B_REVALUATIONLOSS_ACCT || Default Level 1
+
!width="100"| Table
−
|-
+
!width="100"| Column
−
| || C_ACCTSCHEMA_DEFAULT || B_SETTLEMENTGAIN_ACCT || Default Level 1
+
!width="100"| Used in
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || B_SETTLEMENTLOSS_ACCT || Default Level 1
+
| Accounting Schema -> Defaults || C_ACCTSCHEMA_DEFAULT || B_ASSET_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || B_UNALLOCATEDCASH_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || B_INTERESTEXP_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || B_UNIDENTIFIED_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || B_INTERESTREV_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || C_PREPAYMENT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || B_INTRANSIT_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || C_RECEIVABLE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || B_PAYMENTSELECT_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || C_RECEIVABLE_SERVICES_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || B_UNALLOCATEDCASH_ACCT || Default Level 1 -> Bank
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CB_ASSET_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || C_PREPAYMENT_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CB_CASHTRANSFER_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || C_RECEIVABLE_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CB_DIFFERENCES_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || C_RECEIVABLE_SERVICES_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CB_EXPENSE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CB_ASSET_ACCT || Default Level 1 -> CashBook
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CB_RECEIPT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CB_CASHTRANSFER_ACCT || Default Level 1 -> CashBook
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CH_EXPENSE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CB_DIFFERENCES_ACCT || Default Level 1 -> CashBook
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || CH_REVENUE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CB_EXPENSE_ACCT || Default Level 1 -> CashBook
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || E_EXPENSE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CB_RECEIPT_ACCT || Default Level 1 -> CashBook
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || E_PREPAYMENT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || CH_EXPENSE_ACCT || Default Level 1 -> Charge
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || NOTINVOICEDRECEIPTS_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || NOTINVOICEDRECEIPTS_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || NOTINVOICEDRECEIVABLES_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_ASSET_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || NOTINVOICEDREVENUE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_AVERAGECOSTVARIANCE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_ASSET_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_COGS_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_COGS_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_COSTADJUSTMENT_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_COSTADJUSTMENT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_EXPENSE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_EXPENSE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_INVENTORYCLEARING_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_INVENTORYCLEARING_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_RATEVARIANCE_ACCT || Production (Design Error)<br>Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_REVENUE_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_REVENUE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || P_TRADEDISCOUNTREC_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || P_TRADEDISCOUNTREC_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || PAYDISCOUNT_EXP_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || PAYDISCOUNT_EXP_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || PAYDISCOUNT_REV_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || PAYDISCOUNT_REV_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || PJ_ASSET_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || PJ_ASSET_ACCT || Default Level 1 -> Project
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || PJ_WIP_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || PJ_WIP_ACCT || Default Level 1 -> Project
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || REALIZEDGAIN_ACCT || Allocation
 
| || C_ACCTSCHEMA_DEFAULT || REALIZEDGAIN_ACCT || Allocation
Line 111: Line 110:
 
| || C_ACCTSCHEMA_DEFAULT || REALIZEDLOSS_ACCT || Allocation
 
| || C_ACCTSCHEMA_DEFAULT || REALIZEDLOSS_ACCT || Allocation
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || T_CREDIT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || T_CREDIT_ACCT || Default Level 1 -> Tax
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || T_DUE_ACCT || Default Level 1
 
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || T_EXPENSE_ACCT || Default Level 1
 
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || T_LIABILITY_ACCT || Default Level 1
 
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || T_RECEIVABLES_ACCT || Default Level 1
 
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || UNEARNEDREVENUE_ACCT || Default Level 1
 
−
|-
 
−
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDGAIN_ACCT || Default Level 1
 
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDLOSS_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || T_DUE_ACCT || Default Level 1 -> Tax
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || V_LIABILITY_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || T_EXPENSE_ACCT || Default Level 1 -> Tax
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || V_LIABILITY_SERVICES_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || UNEARNEDREVENUE_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || V_PREPAYMENT_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDGAIN_ACCT || Process Invoice Not Realized Gain/Loss
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || W_DIFFERENCES_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDLOSS_ACCT || Process Invoice Not Realized Gain/Loss
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || W_INVACTUALADJUST_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || V_LIABILITY_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || W_INVENTORY_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || V_LIABILITY_SERVICES_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || W_REVALUATION_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || V_PREPAYMENT_ACCT || Default Level 2 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || WITHHOLDING_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || W_DIFFERENCES_ACCT || Default Level 1 -> Warehouse
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || WRITEOFF_ACCT || Default Level 1
+
| || C_ACCTSCHEMA_DEFAULT || WRITEOFF_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
 
| Accounting Schema -> General Ledger || C_ACCTSCHEMA_GL || COMMITMENTOFFSET_ACCT || MatchInv<br>
 
| Accounting Schema -> General Ledger || C_ACCTSCHEMA_GL || COMMITMENTOFFSET_ACCT || MatchInv<br>
 
Order (PO)<br>
 
Order (PO)<br>
 
Requisition
 
Requisition
 +
|-
 +
| || C_ACCTSCHEMA_GL || COMMITMENTOFFSETSALES_ACCT || Order (SO)
 
|-
 
|-
 
| || C_ACCTSCHEMA_GL || CURRENCYBALANCING_ACCT || General Fact
 
| || C_ACCTSCHEMA_GL || CURRENCYBALANCING_ACCT || General Fact
−
|-
 
−
| || C_ACCTSCHEMA_GL || INCOMESUMMARY_ACCT || Not Used
 
 
|-
 
|-
 
| || C_ACCTSCHEMA_GL || INTERCOMPANYDUEFROM_ACCT || General Fact
 
| || C_ACCTSCHEMA_GL || INTERCOMPANYDUEFROM_ACCT || General Fact
Line 158: Line 145:
 
|-
 
|-
 
| || C_ACCTSCHEMA_GL || PPVOFFSET_ACCT || MatchPO
 
| || C_ACCTSCHEMA_GL || PPVOFFSET_ACCT || MatchPO
−
|-
 
−
| || C_ACCTSCHEMA_GL || RETAINEDEARNING_ACCT || Not Used
 
 
|-
 
|-
 
| || C_ACCTSCHEMA_GL || SUSPENSEBALANCING_ACCT || General Fact
 
| || C_ACCTSCHEMA_GL || SUSPENSEBALANCING_ACCT || General Fact
 
|-
 
|-
−
| || C_ACCTSCHEMA_GL || SUSPENSEERROR_ACCT || Not Used
+
| Business Partner Group -> Accounting || C_BP_GROUP_ACCT || C_PREPAYMENT_ACCT || Default Level 1 -> BP_Customer
 
|-
 
|-
−
| Bank -> Account -> Accounting || C_BANKACCOUNT_ACCT || B_ASSET_ACCT || Bank
+
| || C_BP_GROUP_ACCT || C_RECEIVABLE_ACCT || Default Level 1 -> BP_Customer
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_EXPENSE_ACCT || Not Used
+
| || C_BP_GROUP_ACCT || C_RECEIVABLE_SERVICES_ACCT || Default Level 1 -> BP_Customer
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_INTERESTEXP_ACCT || Bank
+
| || C_BP_GROUP_ACCT || NOTINVOICEDRECEIPTS_ACCT || InOut<br>
 +
MatchInv
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_INTERESTREV_ACCT || Bank
+
| || C_BP_GROUP_ACCT || PAYDISCOUNT_EXP_ACCT || Allocation
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_INTRANSIT_ACCT || Bank<br>
+
| || C_BP_GROUP_ACCT || PAYDISCOUNT_REV_ACCT || Allocation
−
Cash<br>
 
−
Payment
 
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_PAYMENTSELECT_ACCT || Allocation<br>
+
| || C_BP_GROUP_ACCT || UNEARNEDREVENUE_ACCT || Invoice (SO)
−
Payment (PO)
 
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_REVALUATIONGAIN_ACCT || Not Used
+
| || C_BP_GROUP_ACCT || V_LIABILITY_ACCT || Default Level 1 -> BP_Vendor
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_REVALUATIONLOSS_ACCT || Not Used
+
| || C_BP_GROUP_ACCT || V_LIABILITY_SERVICES_ACCT || Default Level 1 -> BP_Vendor
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_SETTLEMENTGAIN_ACCT || Not Used
+
| || C_BP_GROUP_ACCT || V_PREPAYMENT_ACCT || Default Level 1 -> BP_Vendor
 
|-
 
|-
−
| || C_BANKACCOUNT_ACCT || B_SETTLEMENTLOSS_ACCT || Not Used
+
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
−
|-
 
−
| || C_BANKACCOUNT_ACCT || B_UNALLOCATEDCASH_ACCT || Allocation<br>
 
−
Payment (SO)
 
−
|-
 
−
| || C_BANKACCOUNT_ACCT || B_UNIDENTIFIED_ACCT || Not Used
 
 
|-
 
|-
 
| Business Partner -> Customer -> Customer Accounting || C_BP_CUSTOMER_ACCT || C_PREPAYMENT_ACCT || Allocation<br>
 
| Business Partner -> Customer -> Customer Accounting || C_BP_CUSTOMER_ACCT || C_PREPAYMENT_ACCT || Allocation<br>
Line 199: Line 177:
 
Invoice (SO)
 
Invoice (SO)
 
|-
 
|-
−
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_SERVICES_ACCT || Invoice (SO)
+
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_SERVICES_ACCT || Invoice (SO) (Error unbalancing on Allocation)
−
|-
 
−
| 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 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || C_RECEIVABLE_ACCT || Default Level 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || C_RECEIVABLE_SERVICES_ACCT || Default Level 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || NOTINVOICEDRECEIPTS_ACCT || InOut<br>
 
−
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 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || V_LIABILITY_SERVICES_ACCT || Default Level 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || V_PREPAYMENT_ACCT || Default Level 2
 
−
|-
 
−
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
 
 
|-
 
|-
 
| Business Partner -> Vendor -> Vendor Accounting || C_BP_VENDOR_ACCT || V_LIABILITY_ACCT || Allocation<br>
 
| Business Partner -> Vendor -> Vendor Accounting || C_BP_VENDOR_ACCT || V_LIABILITY_ACCT || Allocation<br>
 
Invoice (PO)
 
Invoice (PO)
 
|-
 
|-
−
| || C_BP_VENDOR_ACCT || V_LIABILITY_SERVICES_ACCT || Invoice (PO)
+
| || C_BP_VENDOR_ACCT || V_LIABILITY_SERVICES_ACCT || Invoice (PO) (Error unbalancing on Allocation)
 
|-
 
|-
 
| || C_BP_VENDOR_ACCT || V_PREPAYMENT_ACCT || Allocation<br>
 
| || C_BP_VENDOR_ACCT || V_PREPAYMENT_ACCT || Allocation<br>
 
Payment
 
Payment
 
|-
 
|-
−
| Cashbook -> Accounting || C_CASHBOOK_ACCT || CB_ASSET_ACCT || Cash
+
| Product Category -> Accounting || M_PRODUCT_CATEGORY_ACCT || P_ASSET_ACCT || Default Level 1 -> Product
−
|-
 
−
| || C_CASHBOOK_ACCT || CB_CASHTRANSFER_ACCT || Allocation<br>
 
−
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<br>
 
−
Cash<br>
 
−
Inventory<br>
 
−
Invoice<br>
 
−
Payment
 
−
|-
 
−
| || C_CHARGE_ACCT || CH_REVENUE_ACCT || Bank<br>
 
−
Cash<br>
 
−
Inventory<br>
 
−
Invoice<br>
 
−
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
+
| || M_PRODUCT_CATEGORY_ACCT || P_AVERAGECOSTVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| Project -> Accounting || C_PROJECT_ACCT || PJ_ASSET_ACCT || ProjectIssue
+
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
+
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| Revenue Recognition -> Revenue Recognition Plan || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_EXPENSE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| Tax Rate -> Accounting || C_TAX_ACCT || T_CREDIT_ACCT || Invoice (PO)
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_TAX_ACCT || T_DUE_ACCT || Invoice (SO)
+
| || M_PRODUCT_CATEGORY_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_TAX_ACCT || T_EXPENSE_ACCT || Invoice (PO)
+
| || M_PRODUCT_CATEGORY_ACCT || P_RATEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_TAX_ACCT || T_LIABILITY_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_TAX_ACCT || T_RECEIVABLES_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| Withholding -> Accounting || C_WITHHOLDING_ACCT || WITHHOLDING_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 1 -> Product
 
|-
 
|-
 
| Product -> Accounting || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
 
| Product -> Accounting || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
Line 300: Line 216:
 
Production<br>
 
Production<br>
 
ProjectIssue
 
ProjectIssue
 +
|-
 +
| || M_PRODUCT_ACCT || P_AVERAGECOSTVARIANCE_ACCT || Not Used
 
|-
 
|-
 
| || M_PRODUCT_ACCT || P_COGS_ACCT || InOut
 
| || M_PRODUCT_ACCT || P_COGS_ACCT || InOut
Line 318: Line 236:
 
|-
 
|-
 
| || M_PRODUCT_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || MatchPO
 
| || M_PRODUCT_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || MatchPO
 +
|-
 +
| || M_PRODUCT_ACCT || P_RATEVARIANCE_ACCT || Not Used (Design Error)
 
|-
 
|-
 
| || M_PRODUCT_ACCT || P_REVENUE_ACCT || Invoice (SO)
 
| || M_PRODUCT_ACCT || P_REVENUE_ACCT || Invoice (SO)
 
|-
 
|-
−
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Not Used
+
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Invoice (SO)
 +
|-
 +
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Invoice (PO)
 
|-
 
|-
−
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Not Used
+
| Bank -> Account -> Accounting || C_BANKACCOUNT_ACCT || B_ASSET_ACCT || Bank
 
|-
 
|-
−
| Product Category -> Accounting || M_PRODUCT_CATEGORY_ACCT || P_ASSET_ACCT || Default Level 2
+
| || C_BANKACCOUNT_ACCT || B_INTERESTEXP_ACCT || Bank
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 2
+
| || C_BANKACCOUNT_ACCT || B_INTERESTREV_ACCT || Bank
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_ACCT || Default Level 2
+
| || C_BANKACCOUNT_ACCT || B_INTRANSIT_ACCT || Bank<br>
 +
Cash<br>
 +
Payment
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_EXPENSE_ACCT || Default Level 2
+
| || C_BANKACCOUNT_ACCT || B_PAYMENTSELECT_ACCT || Allocation<br>
 +
Payment (PO)
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 2
+
| || C_BANKACCOUNT_ACCT || B_UNALLOCATEDCASH_ACCT || Allocation<br>
 +
Payment (SO)
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 2
+
| Charge -> Accounting || C_CHARGE_ACCT || CH_EXPENSE_ACCT || Bank<br>
 +
Cash<br>
 +
Inventory<br>
 +
Invoice<br>
 +
Payment
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 2
+
| Project -> Accounting || C_PROJECT_ACCT || PJ_ASSET_ACCT || ProjectIssue
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 2
+
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 2
+
| Revenue Recognition -> Revenue Recognition Plan || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 2
+
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
 
|-
 
|-
−
| Warehouse & Locators & Accounting || M_WAREHOUSE_ACCT || W_DIFFERENCES_ACCT || Inventory
+
| Tax Rate -> Accounting || C_TAX_ACCT || T_CREDIT_ACCT || Invoice (PO)
 
|-
 
|-
−
| || M_WAREHOUSE_ACCT || W_INVACTUALADJUST_ACCT || Not Used
+
| || C_TAX_ACCT || T_DUE_ACCT || Invoice (SO)
 
|-
 
|-
−
| || M_WAREHOUSE_ACCT || W_INVENTORY_ACCT || Not Used
+
| || C_TAX_ACCT || T_EXPENSE_ACCT || Invoice (PO)
 
|-
 
|-
−
| || M_WAREHOUSE_ACCT || W_REVALUATION_ACCT || Not Used
+
| Warehouse & Locators -> Accounting || M_WAREHOUSE_ACCT || W_DIFFERENCES_ACCT || Inventory
 
|}
 
|}
 +
 +
== See also ==
 +
* [[IDempiere_Accounting|iDempiere Accounting]]
 +
* [[Accounting_Schema_(Window_ID-125)|Accounting Schema Window]]
 +
 +
[[Category: Accounting]]
 +
[[Category: Account]]
 +
[[Category: financial accounting]]
 +
[[Category: User Manual]]
 +
 +
[[en:Default Accounts Usage]]
 +
[[de:Basiskonten]]

Latest revision as of 14:43, 19 March 2016

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

Prefixes in Default Columns

Most of default accounts are prefixed this way:

Prefix Table
B C_BankAccount_Acct
C C_BP_Customer_Acct
V C_BP_Vendor_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)

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

Usage

Window, Tab Table Column Used in
Accounting Schema -> Defaults C_ACCTSCHEMA_DEFAULT B_ASSET_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_UNALLOCATEDCASH_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 NOTINVOICEDRECEIPTS_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT P_ASSET_ACCT Default Level 2 -> Product_Category
C_ACCTSCHEMA_DEFAULT P_AVERAGECOSTVARIANCE_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_RATEVARIANCE_ACCT Production (Design Error)
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 UNEARNEDREVENUE_ACCT Default Level 1 -> BP_Group
C_ACCTSCHEMA_DEFAULT UNREALIZEDGAIN_ACCT Process Invoice Not Realized Gain/Loss
C_ACCTSCHEMA_DEFAULT UNREALIZEDLOSS_ACCT Process 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 WRITEOFF_ACCT Default Level 1 -> BP_Group
Accounting Schema -> General Ledger C_ACCTSCHEMA_GL COMMITMENTOFFSET_ACCT MatchInv

Order (PO)
Requisition

C_ACCTSCHEMA_GL COMMITMENTOFFSETSALES_ACCT Order (SO)
C_ACCTSCHEMA_GL CURRENCYBALANCING_ACCT General Fact
C_ACCTSCHEMA_GL INTERCOMPANYDUEFROM_ACCT General Fact
C_ACCTSCHEMA_GL INTERCOMPANYDUETO_ACCT General Fact
C_ACCTSCHEMA_GL PPVOFFSET_ACCT MatchPO
C_ACCTSCHEMA_GL SUSPENSEBALANCING_ACCT General Fact
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 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 -> 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) (Error unbalancing on 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) (Error unbalancing on Allocation)
C_BP_VENDOR_ACCT V_PREPAYMENT_ACCT Allocation

Payment

Product Category -> Accounting M_PRODUCT_CATEGORY_ACCT P_ASSET_ACCT Default Level 1 -> Product
M_PRODUCT_CATEGORY_ACCT P_AVERAGECOSTVARIANCE_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_RATEVARIANCE_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
Product -> Accounting M_PRODUCT_ACCT P_ASSET_ACCT InOut

Inventory
Movement
Production
ProjectIssue

M_PRODUCT_ACCT P_AVERAGECOSTVARIANCE_ACCT Not Used
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_RATEVARIANCE_ACCT Not Used (Design Error)
M_PRODUCT_ACCT P_REVENUE_ACCT Invoice (SO)
M_PRODUCT_ACCT P_TRADEDISCOUNTGRANT_ACCT Invoice (SO)
M_PRODUCT_ACCT P_TRADEDISCOUNTREC_ACCT Invoice (PO)
Bank -> Account -> Accounting C_BANKACCOUNT_ACCT B_ASSET_ACCT Bank
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_UNALLOCATEDCASH_ACCT Allocation

Payment (SO)

Charge -> Accounting C_CHARGE_ACCT CH_EXPENSE_ACCT Bank

Cash
Inventory
Invoice
Payment

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)
Warehouse & Locators -> Accounting M_WAREHOUSE_ACCT W_DIFFERENCES_ACCT Inventory

See also

Retrieved from "https://wiki.idempiere.org/w-en/index.php?title=Default_Accounts_Usage&oldid=10614"
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
GNU-Lizenz für freie Dokumentation 1.3 oder höher
Powered by MediaWiki