Difference between revisions of "Default Accounts Usage"

From iDempiere en
m (Reverted edits by Xiaobai (talk) to last revision by Thomas Thießen)
 
(14 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]]
 
This information is valid for iDempiere
 
  
 
== 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 75: 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 || NOTINVOICEDRECEIPTS_ACCT || Default Level 1 -> BP_Group
 
| || 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_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 93: 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 149: Line 147:
 
|-
 
|-
 
| || C_ACCTSCHEMA_GL || SUSPENSEBALANCING_ACCT || General Fact
 
| || C_ACCTSCHEMA_GL || SUSPENSEBALANCING_ACCT || General Fact
|-
 
| 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<br>
 
Cash<br>
 
Payment
 
|-
 
| || C_BANKACCOUNT_ACCT || B_PAYMENTSELECT_ACCT || Allocation<br>
 
Payment (PO)
 
|-
 
| || C_BANKACCOUNT_ACCT || B_UNALLOCATEDCASH_ACCT || Allocation<br>
 
Payment (SO)
 
|-
 
| 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)
 
 
|-
 
|-
 
| Business Partner Group -> Accounting || C_BP_GROUP_ACCT || C_PREPAYMENT_ACCT || Default Level 1 -> BP_Customer
 
| Business Partner Group -> Accounting || C_BP_GROUP_ACCT || C_PREPAYMENT_ACCT || Default Level 1 -> BP_Customer
Line 196: Line 170:
 
|-
 
|-
 
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
 
| || C_BP_GROUP_ACCT || WRITEOFF_ACCT || Allocation
 +
|-
 +
| 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) (Error unbalancing on 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>
+
| || M_PRODUCT_CATEGORY_ACCT || P_AVERAGECOSTVARIANCE_ACCT || Default Level 1 -> Product
Cash
 
 
|-
 
|-
| || C_CASHBOOK_ACCT || CB_DIFFERENCES_ACCT || Cash
+
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 1 -> Product
 
|-
 
|-
| || C_CASHBOOK_ACCT || CB_EXPENSE_ACCT || Cash
+
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_ACCT || Default Level 1 -> Product
 
|-
 
|-
| || C_CASHBOOK_ACCT || CB_RECEIPT_ACCT || Cash
+
| || M_PRODUCT_CATEGORY_ACCT || P_EXPENSE_ACCT || Default Level 1 -> Product
 
|-
 
|-
| Charge -> Accounting || C_CHARGE_ACCT || CH_EXPENSE_ACCT || Bank<br>
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 1 -> Product
Cash<br>
 
Inventory<br>
 
Invoice<br>
 
Payment
 
 
|-
 
|-
| General || C_INTERORG_ACCT || INTERCOMPANYDUEFROM_ACCT || Not Used
+
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
| || C_INTERORG_ACCT || INTERCOMPANYDUETO_ACCT || Not Used
+
| || 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_RATEVARIANCE_ACCT || Default Level 1 -> Product
 
|-
 
|-
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
+
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 1 -> Product
 
|-
 
|-
| Revenue Recognition -> Revenue Recognition Plan || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1 -> Product
 
|-
 
|-
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
+
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 1 -> Product
|-
 
| 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)
 
 
|-
 
|-
 
| Product -> Accounting || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
 
| Product -> Accounting || M_PRODUCT_ACCT || P_ASSET_ACCT || InOut<br>
Line 245: 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 263: 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 270: Line 245:
 
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Invoice (PO)
 
| || M_PRODUCT_ACCT || P_TRADEDISCOUNTREC_ACCT || Invoice (PO)
 
|-
 
|-
| 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
 +
|-
 +
| || 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)
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_COGS_ACCT || Default Level 1 -> Product
+
| || C_BANKACCOUNT_ACCT || B_UNALLOCATEDCASH_ACCT || Allocation<br>
 +
Payment (SO)
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_COSTADJUSTMENT_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_EXPENSE_ACCT || Default Level 1 -> Product
+
| Project -> Accounting || C_PROJECT_ACCT || PJ_ASSET_ACCT || ProjectIssue
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_INVENTORYCLEARING_ACCT || Default Level 1 -> Product
+
| || C_PROJECT_ACCT || PJ_WIP_ACCT || ProjectIssue
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_INVOICEPRICEVARIANCE_ACCT || Default Level 1 -> Product
+
| Revenue Recognition -> Revenue Recognition Plan || C_REVENUERECOGNITION_PLAN || P_REVENUE_ACCT || Created
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_PURCHASEPRICEVARIANCE_ACCT || Default Level 1 -> Product
+
| || C_REVENUERECOGNITION_PLAN || UNEARNEDREVENUE_ACCT || Created
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_REVENUE_ACCT || Default Level 1 -> Product
+
| Tax Rate -> Accounting || C_TAX_ACCT || T_CREDIT_ACCT || Invoice (PO)
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTGRANT_ACCT || Default Level 1 -> Product
+
| || C_TAX_ACCT || T_DUE_ACCT || Invoice (SO)
 
|-
 
|-
| || M_PRODUCT_CATEGORY_ACCT || P_TRADEDISCOUNTREC_ACCT || Default Level 1 -> Product
+
| || C_TAX_ACCT || T_EXPENSE_ACCT || Invoice (PO)
 
|-
 
|-
 
| Warehouse & Locators -> Accounting || M_WAREHOUSE_ACCT || W_DIFFERENCES_ACCT || Inventory
 
| 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

Cookies help us deliver our services. By using our services, you agree to our use of cookies.