Difference between revisions of "Default Accounts Usage"

From iDempiere en
m (Reverted edits by Xiaobai (talk) to last revision by Thomas Thießen)
 
(19 intermediate revisions by 4 users not shown)
Line 2: Line 2:
 
Quality Systems & Solutions - QSS Ltda.<br>
 
Quality Systems & Solutions - QSS Ltda.<br>
 
[[User:CarlosRuiz|Carlos Ruiz]]
 
[[User:CarlosRuiz|Carlos Ruiz]]
−
 
−
Also see [[Default accounts]],[[Default accounts 360lts]].
 
  
 
== Prefixes in Default Columns ==
 
== Prefixes in Default Columns ==
Line 11: Line 9:
 
{| border="0"  
 
{| border="0"  
 
|-  
 
|-  
−
! Prefix
+
! Prefix
 
! Table
 
! Table
 
|-
 
|-
Line 19: Line 17:
 
|-
 
|-
 
| V || C_BP_Vendor_Acct
 
| V || C_BP_Vendor_Acct
−
|-
 
−
| CB || C_CashBook_Acct
 
 
|-
 
|-
 
| CH || C_Charge_Acct
 
| CH || C_Charge_Acct
Line 35: Line 31:
 
M_Product_Acct default accounts are inherited from M_Product_Category_Acct (but can be modified)
 
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)
+
C_BP_Customer_Acct and C_BP_Vendor_Acct are inherited from C_BP_Group_Acct (but can be modified)
−
 
 
−
 
 
  
 
== Usage ==
 
== Usage ==
Line 48: Line 42:
 
!width="100"| Used in
 
!width="100"| Used in
 
|-
 
|-
−
| Not Available || A_ASSET_ACCT || A_ACCUMDEPRECIATION_ACCT || Not Used
+
| Accounting Schema -> Defaults || C_ACCTSCHEMA_DEFAULT || B_ASSET_ACCT || Default Level 1 -> Bank
−
|-
 
−
| || 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
 
−
|-
 
−
| [[ManPageW_AccountingSchema#Tab:_Defaults|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_INTERESTEXP_ACCT || Default Level 1 -> Bank
Line 71: Line 51:
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || B_PAYMENTSELECT_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_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_PREPAYMENT_ACCT || Default Level 2 -> BP_Group
Line 101: Line 71:
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || CH_EXPENSE_ACCT || Default Level 1 -> Charge
 
| || 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 || NOTINVOICEDRECEIPTS_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || NOTINVOICEDRECEIVABLES_ACCT || Default Level 1 -> BP_Group
+
| || C_ACCTSCHEMA_DEFAULT || P_ASSET_ACCT || Default Level 2 -> Product_Category
−
|-
 
−
| || 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_AVERAGECOSTVARIANCE_ACCT || Default Level 2 -> Product_Category
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || P_COGS_ACCT || Default Level 2 -> Product_Category
 
| || C_ACCTSCHEMA_DEFAULT || P_COGS_ACCT || Default Level 2 -> Product_Category
Line 127: Line 89:
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || P_PURCHASEPRICEVARIANCE_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)<br>Default Level 2 -> Product_Category
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || P_REVENUE_ACCT || Default Level 2 -> Product_Category
 
| || C_ACCTSCHEMA_DEFAULT || P_REVENUE_ACCT || Default Level 2 -> Product_Category
Line 151: Line 115:
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || T_EXPENSE_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 || UNEARNEDREVENUE_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDGAIN_ACCT || Default Level 1 -> BP_Group
+
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDGAIN_ACCT || Process Invoice Not Realized Gain/Loss
 
|-
 
|-
−
| || C_ACCTSCHEMA_DEFAULT || UNREALIZEDLOSS_ACCT || Default Level 1 -> BP_Group
+
| || 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_ACCT || Default Level 2 -> BP_Group
Line 169: Line 129:
 
|-
 
|-
 
| || C_ACCTSCHEMA_DEFAULT || W_DIFFERENCES_ACCT || Default Level 1 -> Warehouse
 
| || 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
 
| || C_ACCTSCHEMA_DEFAULT || WRITEOFF_ACCT || Default Level 1 -> BP_Group
 
|-
 
|-
−
| [[ManPageW_AccountingSchema#Tab:_General_Ledger|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 193: 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
−
|-
 
−
| [[ManPageW_Bank#Tab:_Accounting|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<br>
 
−
Cash<br>
 
−
Payment
 
−
|-
 
−
| || C_BANKACCOUNT_ACCT || B_PAYMENTSELECT_ACCT || Allocation<br>
 
−
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<br>
 
−
Payment (SO)
 
−
|-
 
−
| || C_BANKACCOUNT_ACCT || B_UNIDENTIFIED_ACCT || Not Used
 
−
|-
 
−
| [[ManPageW_BusinessPartner#Tab:_Customer_Accounting|Business Partner -> Customer -> Customer Accounting]] || C_BP_CUSTOMER_ACCT || C_PREPAYMENT_ACCT || Allocation<br>
 
−
Payment
 
−
|-
 
−
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_ACCT || Allocation<br>
 
−
Invoice (SO)
 
−
|-
 
−
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_SERVICES_ACCT || Invoice (SO)
 
−
|-
 
−
| [[ManPageW_BusinessPartner#Tab:_Employee_Accounting|Business Partner -> Employee -> Employee Accounting]] || C_BP_EMPLOYEE_ACCT || E_EXPENSE_ACCT || Not Used
 
−
|-
 
−
| || C_BP_EMPLOYEE_ACCT || E_PREPAYMENT_ACCT || Not Used
 
−
|-
 
−
| [[ManPageW_BusinessPartnerGroup#Tab:_Accounting|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_ACCT || Default Level 1 -> BP_Customer
Line 248: Line 156:
 
| || C_BP_GROUP_ACCT || NOTINVOICEDRECEIPTS_ACCT || InOut<br>
 
| || C_BP_GROUP_ACCT || NOTINVOICEDRECEIPTS_ACCT || InOut<br>
 
MatchInv
 
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_EXP_ACCT || Allocation
Line 267: Line 171:
 
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
 
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
 
|-
 
|-
−
| [[ManPageW_BusinessPartner#Tab:_Vendor_Accounting|Business Partner -> Vendor -> Vendor Accounting]] || C_BP_VENDOR_ACCT || V_LIABILITY_ACCT || Allocation<br>
+
| Business Partner -> Customer -> Customer Accounting || C_BP_CUSTOMER_ACCT || C_PREPAYMENT_ACCT || Allocation<br>
−
Invoice (PO)
 
−
|-
 
−
| || C_BP_VENDOR_ACCT || V_LIABILITY_SERVICES_ACCT || Invoice (PO)
 
−
|-
 
−
| || C_BP_VENDOR_ACCT || V_PREPAYMENT_ACCT || Allocation<br>
 
 
Payment
 
Payment
 
|-
 
|-
−
| [[ManPageW_Cashbook#Tab:_Accounting|Cashbook -> Accounting]] || C_CASHBOOK_ACCT || CB_ASSET_ACCT || Cash
+
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_ACCT || Allocation<br>
 +
Invoice (SO)
 
|-
 
|-
−
| || C_CASHBOOK_ACCT || CB_CASHTRANSFER_ACCT || Allocation<br>
+
| || C_BP_CUSTOMER_ACCT || C_RECEIVABLE_SERVICES_ACCT || Invoice (SO) (Error unbalancing on Allocation)
−
Cash
 
 
|-
 
|-
−
| || C_CASHBOOK_ACCT || CB_DIFFERENCES_ACCT || Cash
+
| Business Partner -> Vendor -> Vendor Accounting || C_BP_VENDOR_ACCT || V_LIABILITY_ACCT || Allocation<br>
 +
Invoice (PO)
 
|-
 
|-
−
| || C_CASHBOOK_ACCT || CB_EXPENSE_ACCT || Cash
+
| || C_BP_VENDOR_ACCT || V_LIABILITY_SERVICES_ACCT || Invoice (PO) (Error unbalancing on Allocation)
 
|-
 
|-
−
| || C_CASHBOOK_ACCT || CB_RECEIPT_ACCT || Cash
+
| || C_BP_VENDOR_ACCT || V_PREPAYMENT_ACCT || Allocation<br>
−
|-
 
−
| [[ManPageW_Charge#Tab:_Accounting|Charge -> Accounting]] || C_CHARGE_ACCT || CH_EXPENSE_ACCT || Bank<br>
 
−
Cash<br>
 
−
Inventory<br>
 
−
Invoice<br>
 
 
Payment
 
Payment
 
|-
 
|-
−
| || C_CHARGE_ACCT || CH_REVENUE_ACCT || Bank<br>
+
| Product Category -> Accounting || M_PRODUCT_CATEGORY_ACCT || P_ASSET_ACCT || Default Level 1 -> Product
−
Cash<br>
 
−
Inventory<br>
 
−
Invoice<br>
 
−
Payment
 
 
|-
 
|-
−
| [[ManPageW_Currency#Tab:_Accounting|Currency -> Accounting]] || C_CURRENCY_ACCT || REALIZEDGAIN_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_AVERAGECOSTVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_CURRENCY_ACCT || REALIZEDLOSS_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_CURRENCY_ACCT || UNREALIZEDGAIN_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_CURRENCY_ACCT || UNREALIZEDLOSS_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_EXPENSE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| Not Available || C_INTERORG_ACCT || INTERCOMPANYDUEFROM_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_INTERORG_ACCT || INTERCOMPANYDUETO_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| [[ManPageW_Project#Tab:_Accounting|Project -> Accounting]] || C_PROJECT_ACCT || PJ_ASSET_ACCT || ProjectIssue
+
| || M_PRODUCT_CATEGORY_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
+
| || M_PRODUCT_CATEGORY_ACCT || P_RATEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| [[ManPageW_RevenueRecognition#Tab:_Revenue_Recognition_Plan|Revenue Recognition -> Revenue Recognition Plan]] || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1 -> Product
 
|-
 
|-
−
| [[ManPageW_TaxRate#Tab:_Accounting|Tax Rate -> Accounting]] || C_TAX_ACCT || T_CREDIT_ACCT || Invoice (PO)
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 1 -> Product
−
|-
 
−
| || 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
 
−
|-
 
−
| [[ManPageW_Withholding%281099%29#Tab:_Accounting|Withholding -> Accounting]] || C_WITHHOLDING_ACCT || WITHHOLDING_ACCT || Not Used
 
 
|-
 
|-
−
| [[ManPageW_Product#Tab:_Accounting|Product -> Accounting]] || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
+
| Product -> Accounting || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
 
Inventory<br>
 
Inventory<br>
 
Movement<br>
 
Movement<br>
 
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 353: 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)
Line 360: Line 245:
 
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Invoice (PO)
 
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Invoice (PO)
 
|-
 
|-
−
| [[ManPageW_ProductCategory#Tab:_Accounting|Product Category -> Accounting]] || M_PRODUCT_CATEGORY_ACCT || P_ASSET_ACCT || Default Level 1 -> Product
+
| Bank -> Account -> Accounting || C_BANKACCOUNT_ACCT || B_ASSET_ACCT || Bank
 +
|-
 +
| || C_BANKACCOUNT_ACCT || B_INTERESTEXP_ACCT || Bank
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 1 -> Product
+
| || C_BANKACCOUNT_ACCT || B_INTERESTREV_ACCT || Bank
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_ACCT || Default Level 1 -> Product
+
| || C_BANKACCOUNT_ACCT || B_INTRANSIT_ACCT || Bank<br>
 +
Cash<br>
 +
Payment
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_EXPENSE_ACCT || Default Level 1 -> Product
+
| || C_BANKACCOUNT_ACCT || B_PAYMENTSELECT_ACCT || Allocation<br>
 +
Payment (PO)
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 1 -> Product
+
| || C_BANKACCOUNT_ACCT || B_UNALLOCATEDCASH_ACCT || Allocation<br>
 +
Payment (SO)
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1 -> Product
+
| 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 1 -> Product
+
| Project -> Accounting || C_PROJECT_ACCT || PJ_ASSET_ACCT || ProjectIssue
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 1 -> Product
+
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1 -> Product
+
| Revenue Recognition -> Revenue Recognition Plan || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
 
|-
 
|-
−
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 1 -> Product
+
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
 
|-
 
|-
−
| [[ManPageW_WarehouseLocators#Tab:_Accounting|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
 
|}
 
|}
  
−
[[Category:Accounting]]
+
== 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