IDempiere Accounting - Revision history

CarlosRuiz at 18:48, 8 June 2023

2023-06-08T18:48:06Z

CarlosRuiz: /* MatchInv */

2023-06-08T18:46:53Z

MatchInv

CarlosRuiz: Cash accounting deprecated

2023-04-19T20:49:15Z

Cash accounting deprecated

CarlosRuiz at 20:41, 19 April 2023

2023-04-19T20:41:20Z

CarlosRuiz: Deprecated _Services_Acct

2023-04-19T20:39:10Z

Deprecated _Services_Acct

CarlosRuiz: Remove deprecated CH_Revenue_Acct

2023-04-19T20:28:22Z

Remove deprecated CH_Revenue_Acct

CarlosRuiz at 10:36, 8 October 2019

2019-10-08T10:36:56Z

Thomas Thießen: Add category

2015-10-25T10:01:37Z

Add category

CarlosRuiz: /* MatchInv */ fix

2014-01-16T19:51:20Z

MatchInv: fix

Hideaki Hagiwara: /* General Fact */

2013-11-18T13:59:38Z

General Fact

@@ Line 13: / Line 13: @@
 |-
-| Payment || || || || Based on C_AllocationHdr y C_AllocationLine
+| Payment || || || || Based on C_AllocationHdr and C_AllocationLine
 |-
 | Payment Without Invoice || || || if C_Invoice_ID = 0 (no invoice) Payment Only<br>if C_Payment.C_DocType->DocBaseType ||
@@ Line 93: / Line 93: @@
 |-
-| Bank Statement || || || || Based in C_BankStatement y C_BankStatementLine
+| Bank Statement || || || || Based in C_BankStatement and C_BankStatementLine
 |-
 | Bank Charges || C_BankAccount_Acct -> B_Asset_Acct || || || Bank (if debit or credit is determined according to the sign of value StmtAmt) <br><br> iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BankAccount_Acct -> B_InTransit_Acct is equal to C_BankAccount_Acct -> B_Asset_Acct)
@@ Line 117: / Line 117: @@
 |-
-| GL Journal || || || || Based in GL_Journal y GL_JournalLine
+| GL Journal || || || || Based in GL_Journal and GL_JournalLine
 |-
 | Journal || GL_JournalLine -> account_id || GL_JournalLine -> account_id || ||
@@ Line 133: / Line 133: @@
 |-
-| Shipments and Receipts || || || || Based in M_InOut y M_InOutLine
+| Shipments and Receipts || || || || Based in M_InOut and M_InOutLine
 |-
 | Sales shipment (DOC MatShipment) || M_Product_Acct -> P_Cogs_Acct || M_Product_Acct -> P_Asset_Acct || Sales - Shipment || calculates the cost based in M_Cost. If is a product create register in M_CostDetail
@@ Line 157: / Line 157: @@
 |-
-| Internal Use and Physical Inventory || || || || Based in M_Inventory y M_InventoryLine
+| Internal Use and Physical Inventory || || || || Based in M_Inventory and M_InventoryLine
 |-
 | || M_Product_Acct -> P_Asset_Acct || || || calculates the cost based in M_CostDetail
@@ Line 177: / Line 177: @@
 |-
-| Invoice || || || there is no accounting for not accrual || Based in C_Invoice, C_InvoiceTax y C_InvoiceLine
+| Invoice || || || there is no accounting for not accrual || Based in C_Invoice, C_InvoiceTax and C_InvoiceLine
 |-
 | Sales Invoice (Customer) (DOC ARInvoice or ARProForma) || || || ||
@@ Line 326: / Line 326: @@
 |-
-| Inventory Movement || || || || Based in M_Movement y M_MovementLine
+| Inventory Movement || || || || Based in M_Movement and M_MovementLine
 |-
 | || M_Product_Acct -> P_Asset_Acct || M_Product_Acct -> P_Asset_Acct || Inventory || DB or CR depending on thevalue, moving from a locator to another in accounting dimension
@@ Line 346: / Line 346: @@
 |-
-| Order || || || || Based in C_Order, C_OrderTax y C_OrderLine (goes to M_RequisitionLine)
+| Order || || || || Based in C_Order, C_OrderTax and C_OrderLine (goes to M_RequisitionLine)
 |-
 | Purchase Order (DOC Porder) || || || || update M_Product_PO.PriceLastPO, M_Product_Costing.PriceLastPO
@@ Line 407: / Line 407: @@
 |-
-| Production || || || || Based in M_Production, M_ProductionPlan y M_ProductionLine
+| Production || || || || Based in M_Production, M_ProductionPlan and M_ProductionLine
 |-
 | || M_Product_Acct -> P_Asset_Acct || M_Product_Acct -> P_Asset_Acct || Inventory || cost the BOM or the products
@@ Line 457: / Line 457: @@
 !width="100pt"|Comments
 |-
-| Requisitions || || || || Based in M_Requisition y M_RequisitionLine
+| Requisitions || || || || Based in M_Requisition and M_RequisitionLine
 |-
 | || || || if C_AcctSchema isCreateReservation post this with Reservation type ||

@@ Line 272: / Line 272: @@
 |-
-| Match Invoice || || || || Based in M_MatchInv, C_InvoiceLine y M_InOutLine
+| Match Invoice || || || || Based in M_MatchInv, C_InvoiceLine and M_InOutLine
 |-
 | || C_BP_Group_Acct -> NotInvoicedReceipts_Acct || || || iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BP_Group_Acct -> NotInvoicedReceipts_Acct is equal to  M_Product_Acct -> P_InventoryClearing_Acct)
@@ Line 288: / Line 288: @@
 | || || || Commitment release ||
 |-
-| || || || if isAccrual y isCreateCommitment ||
+| || || || if isAccrual and isCreateCommitment ||
 |-
 | || || M_Product_Acct -> P_Expense_Acct || for each commitment, this is each C_OrderLine that matches with an C_InvoiceLine or with a M_MatchPO ||

@@ Line 36: / Line 36: @@
 |-
 | || C_BankAccount_Acct -> B_UnallocatedCash_Acct || || else ||
 |-
 | || C_BP_Group_Acct -> PayDiscount_Exp_Acct || || if there is discount || value of DiscountAmt
@@ Line 60: / Line 58: @@
 |-
 | || || C_BankAccount_Acct -> B_UnallocatedCash_Acct || else ||
 |-
 | || || C_BP_Group_Acct -> PayDiscount_Rev_Acct || if there is discount ||
@@ Line 108: / Line 104: @@
 |-
 | || C_BankAccount_Acct -> B_InterestRev_Acct || C_BankAccount_Acct -> B_InterestRev_Acct || if C_BankStatementLine.InterestAmt > 0 || DB or CR depending on the sign of the quantity
 |}

@@ Line 289: / Line 289: @@
 | || || || Liability ||
 |-
-| || || C_BP_Vendor_Acct -> V_Liability_Acct || ||
+| || C_BP_Vendor_Acct -> V_Liability_Acct
 |-
 | Landed Cost Posting || M_Product_Acct -> P_CostAdjustment_Acct || || ||

@@ Line 236: / Line 236: @@
 |-
 | || C_BP_Customer_Acct -> C_Receivable_Acct || || || post the value of products
 |-
 | Credit Note (Customer) (DOC ARCredit) || || || ||
@@ Line 256: / Line 254: @@
 |-
 | || || C_BP_Customer_Acct -> C_Receivable_Acct || || post the value of products
 |-
 | Purchase Invoice (Vendor) (DOC APInvoice) || || || ||
@@ Line 276: / Line 272: @@
 |-
 | || || C_BP_Vendor_Acct -> V_Liability_Acct || ||
 |-
 | Credit Note (Vendor) (DOC APCredit) || || || ||
@@ Line 296: / Line 290: @@
 |-
 | || || C_BP_Vendor_Acct -> V_Liability_Acct || ||
 |-
 | Landed Cost Posting || M_Product_Acct -> P_CostAdjustment_Acct || || ||

@@ Line 103: / Line 103: @@
 | || || C_BankAccount_Acct -> B_InTransit_Acct || || Payment (value TrxAmt, DB or CR depending on the sign)
 |-
-| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 and amt > 0 || value ChargeAmt, DB or CR depending on the sign
+| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 || value ChargeAmt, DB or CR depending on the sign
 |-
 | || C_BankAccount_Acct -> B_InterestExp_Acct || C_BankAccount_Acct -> B_InterestExp_Acct || if C_BankStatementLine.InterestAmt < 0 || DB or CR depending on the sign of the quantity (value InterestAmt)
@@ Line 131: / Line 129: @@
 | Charges (CASH CHARGE) || || || if C_CashLine.CashType = C ||
 |-
-| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 and amt > 0 ||
+| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 ||
 |-
 | Difference in cash (CASH DIFFERENCE) || C_CashBook_Acct -> CB_Differences_Acct || || if C_CashLine.CashType = D ||
@@ Line 203: / Line 199: @@
 | || M_Product_Acct -> P_Asset_Acct || || || calculates the cost based in M_CostDetail
 |-
-| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 and amt > 0 ||
+| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 ||
 |-
 | || || M_Warehouse_Acct -> W_Differences_Acct || || recreate M_CostDetail
@@ Line 227: / Line 221: @@
 | || || || Header Charge ||
 |-
-| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 and amt < 0 ||
+| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 ||
 |-
 | || || C_Tax_Acct -> T_Due_Acct || for each tax ||
@@ Line 251: / Line 243: @@
 | || || || Header Charge ||
 |-
-| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 and amt > 0 ||
+| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 ||
 |-
 | || C_Tax_Acct -> T_Due_Acct || || for each tax ||
@@ Line 271: / Line 261: @@
 | Purchase Invoice (Vendor) (DOC APInvoice) || || || ||
 |-
-| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 and amt > 0 ||
+| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 ||
 |-
 | || C_Tax_Acct -> T_Credit_Acct o T_Expense_Acct (if sales tax) || || for each tax ||
@@ Line 293: / Line 281: @@
 | Credit Note (Vendor) (DOC APCredit) || || || ||
 |-
-| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 and amt > 0 ||
+| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 ||
 |-
 | || || C_Tax_Acct -> T_Credit_Acct o T_Expense_Acct (if sales tax) || TaxCredit ||
@@ Line 437: / Line 423: @@
 | Receipt (DOC ARR - ARReceipt) || C_BankAccount_Acct -> B_InTransit_Acct || || ||
 |-
-| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 and amt > 0 ||
+| || || C_Charge_Acct -> CH_Expense_Acct || if C_Charge_ID <> 0 ||
 |-
 | || || C_BP_Customer_Acct -> C_Prepayment_Acct || if C_Payment.isPrepayment ||
@@ Line 447: / Line 431: @@
 | Payment (DOC APP - APPayment) || || || ||
 |-
-| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 and amt > 0 ||
+| || C_Charge_Acct -> CH_Expense_Acct || || if C_Charge_ID <> 0 ||
 |-
 | || C_BP_Vendor_Acct -> V_Prepayment_Acct || || if C_Payment.isPrepayment ||

@@ Line 17: / Line 17: @@
 | Payment Without Invoice || || || if C_Invoice_ID = 0 (no invoice) Payment Only<br>if C_Payment.C_DocType->DocBaseType ||
 |-
-| || C_BankAccount_Acct -> B_PaymentSelect_Acct || || DocBaseType=APP ||[[File:B_PaymentSelect_Acct.jpeg]]
+| || C_BankAccount_Acct -> B_PaymentSelect_Acct || || DocBaseType=APP ||
 |-
-| || C_BP_Customer_Acct -> C_Prepayment_Acct || || DocBaseType<>APP and isPrepayment and isReceipt || [[File:C_Prepayment_Acct.jpeg]]
+| || C_BP_Customer_Acct -> C_Prepayment_Acct || || DocBaseType<>APP and isPrepayment and isReceipt ||
 |-
-| || C_BP_Vendor_Acct -> V_Prepayment_Acct || || DocBaseType<>APP and isPrepayment || [[File:V_Prepayment_Acct.jpeg]]
+| || C_BP_Vendor_Acct -> V_Prepayment_Acct || || DocBaseType<>APP and isPrepayment ||
 |-
-| || || C_BankAccount_Acct -> B_UnallocatedCash_Acct || || [[File:B_UnallocatedCash_Acct.jpeg]]
+| || || C_BankAccount_Acct -> B_UnallocatedCash_Acct || ||
 |-
-| Receipt Customer Invoice || || || if C_Invoice_ID and isSOTrx || Adempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account C_BankAccount_Acct -> B_UnallocatedCash_Acct is equal to C_BP_Customer_Acct -> C_Receivable_Acct)
+| Receipt Customer Invoice || || || if C_Invoice_ID and isSOTrx || iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account C_BankAccount_Acct -> B_UnallocatedCash_Acct is equal to C_BP_Customer_Acct -> C_Receivable_Acct)
 |-
 | || || || if C_Payment_ID > 0 ||
@@ Line 45: / Line 45: @@
 | || || C_BP_Customer_Acct -> C_Receivable_Acct || if c_acctschema.isAccrual || value of AmtSource + DiscountAmt + WriteOffAmt
 |-
-| || || || when the schema is not accrual Adempiere generates different posting in createCashBasedAcct (still not described in this document) ||
+| || || || when the schema is not accrual iDempiere generates different posting in createCashBasedAcct (still not described in this document) ||
 |-
-| Payment Purchase Invoice || || || || Adempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account C_BankAccount_Acct -> B_PaymentSelect_Acct is equal to C_BP_Vendor_Acct -> V_Liability_Acct)
+| Payment Purchase Invoice || || || || iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account C_BankAccount_Acct -> B_PaymentSelect_Acct is equal to C_BP_Vendor_Acct -> V_Liability_Acct)
 |-
 | || C_BP_Vendor_Acct -> V_Liability_Acct || || if c_acctschema.isAccrual ||
@@ Line 99: / Line 99: @@
 | Bank Statement || || || || Based in C_BankStatement y C_BankStatementLine
 |-
-| Bank Charges || C_BankAccount_Acct -> B_Asset_Acct || || || Bank (if debit or credit is determined according to the sign of value StmtAmt) <br><br> Adempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BankAccount_Acct -> B_InTransit_Acct is equal to C_BankAccount_Acct -> B_Asset_Acct)
+| Bank Charges || C_BankAccount_Acct -> B_Asset_Acct || || || Bank (if debit or credit is determined according to the sign of value StmtAmt) <br><br> iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BankAccount_Acct -> B_InTransit_Acct is equal to C_BankAccount_Acct -> B_Asset_Acct)
 |-
 | || || C_BankAccount_Acct -> B_InTransit_Acct || || Payment (value TrxAmt, DB or CR depending on the sign)
@@ Line 333: / Line 333: @@
 | Match Invoice || || || || Based in M_MatchInv, C_InvoiceLine y M_InOutLine
 |-
-| || C_BP_Group_Acct -> NotInvoicedReceipts_Acct || || || Adempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BP_Group_Acct -> NotInvoicedReceipts_Acct is equal to  M_Product_Acct -> P_InventoryClearing_Acct)
+| || C_BP_Group_Acct -> NotInvoicedReceipts_Acct || || || iDempiere won't post clearing if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account  C_BP_Group_Acct -> NotInvoicedReceipts_Acct is equal to  M_Product_Acct -> P_InventoryClearing_Acct)
 |-
 | || || || if isAccrual ||
@@ Line 341: / Line 341: @@
 | || || M_Product_Acct -> P_Expense_Acct || if non-item ||
 |-
-| || || || when the schema is not accrual Adempiere generates different posting in createCashBasedAcct (still not described in this document) ||
+| || || || when the schema is not accrual iDempiere generates different posting in createCashBasedAcct (still not described in this document) ||
 |-
 | || M_Product_Acct -> P_InvoicePriceVariance_Acct || || Invoice Price Variance difference || Update M_Product_Costing
@@ Line 367: / Line 367: @@
 |-
-| Match Purchase Order || || || || Just for standard costing<br>Adempiere won't post this if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account M_Product_Acct -> P_PurchasePriceVariance_Acct is equal to C_AcctSchema_GL -> PPVOffset_Acct)
+| Match Purchase Order || || || || Just for standard costing<br>iDempiere won't post this if C_AcctSchema.isPostIfClearingEqual = N AND (clearing account M_Product_Acct -> P_PurchasePriceVariance_Acct is equal to C_AcctSchema_GL -> PPVOffset_Acct)
 |-
 | || M_Product_Acct -> P_PurchasePriceVariance_Acct || C_AcctSchema_GL -> PPVOffset_Acct || || post the difference between the cost of the order line vs the standard cost

← Older revision		Revision as of 10:01, 25 October 2015
Line 550:		Line 550:
	* [[Accounting_Schema_(Window_ID-125)\|Accounting Schema Window]]		* [[Accounting_Schema_(Window_ID-125)\|Accounting Schema Window]]

−	[[Category:Accounting]]	+
		+	[[Category: Financial accounting]]
		+	[[Category: Accounting]]
		+	[[Category: Development]]

@@ Line 533: / Line 533: @@
 |-
 !width="100pt"|Description of Document
-!width="70pt"|DB
+!width="70pt"|DR
 !width="70pt"|CR
 !width="200pt"|Conditions