Difference between revisions of "ADempiere Accounting"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
(→Movement) |
(→MatchPO) |
||
| Line 22: | Line 22: | ||
== MatchPO == | == MatchPO == | ||
| + | {| border="1" | ||
| + | |- | ||
| + | !width="100pt"|Description of Document | ||
| + | !width="150pt"|DB | ||
| + | !width="150pt"|CR | ||
| + | !width="150pt"|Conditions | ||
| + | !width="200pt"|Comments | ||
| + | |||
| + | |- | ||
| + | | Match Purchase Order || || || || Based in M_MatchPO, C_OrderLine, M_InOutLine y C_InvoiceLine | ||
| + | |- | ||
| + | | || M_Product_Acct -> P_PurchasePriceVariance_Acct || C_AcctSchema_GL -> PPVOffset_Acct || || calculate the difference in currencies | ||
| + | |||
| + | |||
| + | |||
| + | |} | ||
== Movement == | == Movement == | ||
Revision as of 23:18, 6 September 2007
Work in progress
Contributed by:
Quality Systems & Solutions - QSS Ltda.
Carlos Ruiz
Contents
Allocation
Bank
Cash
GLJournal
InOut (Shipment and Receipts)
Inventory
Invoice
MatchInv
MatchPO
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| Match Purchase Order | Based in M_MatchPO, C_OrderLine, M_InOutLine y C_InvoiceLine | |||
| M_Product_Acct -> P_PurchasePriceVariance_Acct | C_AcctSchema_GL -> PPVOffset_Acct | calculate the difference in currencies
|
Movement
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| Inventory Movement | Based in M_Movement y 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 | |
| if there was movement between organizations and the costing level in C_AcctSchema is organización then it creates movements in M_CostDetail
|
Order
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| Order | Based in C_Order, C_OrderTax y C_OrderLine (goes to M_RequisitionLine) | |||
| Purchase Order (DOC Porder) | update M_Product_PO.PriceLastPO, M_Product_Costing.PriceLastPO | |||
| if C_AcctSchema,isCreateCommitment post this with Commityment Type (to be released by Invoice Matching) | ||||
| M_Product_Acct -> P_Expense_Acct | ||||
| C_AcctSchema_GL -> CommitmentOffset_Acct | ||||
| if C_AcctSchema.isCreateReservation post this with Reservation Type (Release reservation) | ||||
| M_Product_Acct -> P_Expense_Acct | ||||
| C_AcctSchema_GL -> CommitmentOffset_Acct |
Payment
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| Payment | Based in C_Payment | |||
| 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_Revenue_Acct | if C_Charge_ID <> 0 and amt < 0 | |||
| C_BP_Customer_Acct -> C_Prepayment_Acct | if C_Payment.isPrepayment | |||
| C_BankAccount_Acct -> B_UnallocatedCash_Acct | else | |||
| Payment (DOC APP - APPayment) | ||||
| C_Charge_Acct -> CH_Expense_Acct | if C_Charge_ID <> 0 and amt > 0 | |||
| C_Charge_Acct -> CH_Revenue_Acct | if C_Charge_ID <> 0 and amt < 0 | |||
| C_BP_Vendor_Acct -> V_Prepayment_Acct | if C_Payment.isPrepayment | |||
| C_BankAccount_Acct -> B_PaymentSelect_Acct | else | |||
| C_BankAccount_Acct -> B_InTransit_Acct |
Production
| Description of Document | DB | CR | Conditions | Comments
|
|---|---|---|---|---|
| Production | Based in M_Production, M_ProductionPlan y M_ProductionLine | |||
| M_Product_Acct -> P_Asset_Acct | M_Product_Acct -> P_Asset_Acct | Inventory | cost the BOM or the products
|
ProjectIssue
| Description of Document | DB | CR | Conditions | Comments
|
|---|---|---|---|---|
| Project Issue | Based in C_ProjectIssue | |||
| if the project has M_InOutLine it calculates the cost of products from M_InOutLine, C_Order and C_OrderLine otherwise verifies if the project has S_TimeExpenseLine and calculates the cost of services (look out /** TODO Labor Cost */) | ||||
| C_Project_Acct -> PJ_WIP_Acct | ||||
| C_Project_Acct -> PJ_Asset_Acct | if projecdt category is AssetProject (A) | |||
| M_Product_Acct -> P_Expense_Acct | if product.isService | |||
| M_Product_Acct -> P_Asset_Acct | else |
|
Requisition
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| Requisitions | Based in M_Requisition y M_RequisitionLine | |||
| if C_AcctSchema isCreateReservation post this with Reservation type | ||||
| M_Product_Acct -> P_Expense_Acct | ||||
| C_AcctSchema_GL -> CommitmentOffset_Acct |
General Fact
| Description of Document | DB | CR | Conditions | Comments |
|---|---|---|---|---|
| All documents inter organization | C_AcctSchema_GL -> InterCompanyDueFrom_Acct | C_AcctSchema_GL -> InterCompanyDueTo_Acct | Posted when the accounting by organization must be balanced and transaction involves more than one organization | |
| All documents with currencies unbalanced | C_AcctSchema_GL -> CurrencyBalancing_Acct | If the GL schema is marked as currency balancing | ||
| All documents unbalanced | C_AcctSchema_GL -> SuspenseBalancing_Acct | If the GL schema is marked as use suspense balancing - it's posted when the document is unbalanced |
Default Accounts Usage
See also Default_Accounts_Usage
