Implement an automatic GL posting service for incoming payments
---------------------------------------------------------------
Key: OFBIZ-1490
URL: https://issues.apache.org/jira/browse/OFBIZ-1490
Project: OFBiz
Issue Type: Sub-task
Components: accounting
Affects Versions: SVN trunk
Reporter: Jacopo Cappellato
Name of the service: "createAcctgTransAndEntriesForIncomingPayment" or similar
Service definition:
<service name="createAcctgTransAndEntriesForIncomingPayment"
engine="simple" auth="true"
location="org/ofbiz/accounting/ledger/GeneralLedgerServices.xml"
invoke="createAcctgTransAndEntriesForIncomingPayment">
<description>Create an accounting transaction for a purchase
invoice</description>
<attribute name="paymentId" type="String" mode="IN" optional="false"/>
<attribute name="acctgTransId" type="String" mode="OUT"
optional="true"/>
</service>
1) get the Payment by paymentId
2) if (!UtilAccounting.isReceipt(payment)) then return; (hint: in Minilang, use
the "call-class-method" operation)
3) organizationPartyId = payment.partyIdTo
4) partyId = payment.partyIdFrom and roleTypeId = "BILL_TO_CUSTOMER"
5) create an AcctgTransEntry with:
5.1) debitCreditFlag=D, glAccountTypeId: do not set for now (<!--TODO-->),
origAmount=payment.amount, origCurrencyUomId=payment.currencyUomId
6) get the creditGlAccountTypeId in the following way:
6.1) get the PaymentGlAccountTypeMap for the given Payment.paymentTypeId and
organizationPartyId
6.2) creditGlAccountTypeId = PaymentGlAccountTypeMap.glAccountTypeId
7) for the credit entries: select the PaymentApplications associated to the
Payment and for each one:
7.1) create a AcctgTransEntry with: debitCreditFlag=C,
origAmount=paymentApplication.amountApplied,
origCurrencyUomId=payment.currencyUomId,
glAccountId=paymentApplication.overrideGlAccountId or (if empty)
payment.overrideGlAccountId, glAccountTypeId=creditGlAccountTypeId
7.2) amountAppliedTotal = amountAppliedTotal + paymentApplication.amountApplied
8) if ((payment.amount - amountAppliedTotal) > 0) then create another credit
entry with: debitCreditFlag=C, origAmount=(payment.amount -
amountAppliedTotal), origCurrencyUomId=payment.currencyUomId,
glAccountId=payment.overrideGlAccountId, glAccountTypeId=creditGlAccountTypeId
9) call the createAcctgTransAndEntries with the following fields
9.1) acctgTransEntries prepared at points 5, 7 and 8
9.2) acctgTransTypeId="INCOMING_PAYMENT"
9.3) partyId e roleTypeId (point 4), paymentId
Add the following secas to trigger the service:
<eca service="createPayment" event="commit">
<condition field-name="statusId" operator="equals" value="PMNT_RECEIVED"/>
<action service="createAcctgTransAndEntriesForIncomingPayment" mode="sync"/>
</eca>
<eca service="setPaymentStatus" event="commit">
<condition field-name="statusId" operator="equals" value="PMNT_RECEIVED"/>
<condition field-name="oldStatusId" operator="not-equals"
value="PMNT_RECEIVED"/>
<action service="createAcctgTransAndEntriesForIncomingPayment" mode="sync"/>
</eca>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
