[OFBIZ-1459] Implement an automatic GL posting service triggered when the ownerPartyId of an inventory item is changed

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Trunk
• Component/s: accounting
• Assignee: Anil K Patel
• Reporter: Jacopo Cappellato
• Created: 30/Nov/07 16:31
• Updated: 07/Dec/07 07:07
• Resolved: 04/Dec/07 02:02

Description

The name of the service can be "createAcctgTransForInventoryItemOwnerChange" or similar.
Input field: inventoryItemId, oldOwnerPartyId
Output field: acctgTransId

We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml

The service will do the following tasks:
1) compute the origAmount as: origAmount = inventoryItem.quantityOnHandTotal * inventoryItem.unitCost
2) prepare 2 AcctgTransEntry (a debit and a credit) for the oldOwnerPartyId:
CREDIT: debitCreditFlag=C, glAcctgTransTypeId=INVENTORY_XFER_IN, productId=InventoryItem.productId, origAmount=(the value computed in 1), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=oldOwnerPartyId
DEBIT: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 1), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=oldOwnerPartyId

3) prepare 2 AcctgTransEntry (a debit and a credit) for the inventoryItem.ownerPartyId:
CREDIT: debitCreditFlag=C, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 1), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=inventoryItem.ownerPartyId
DEBIT: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_XFER_OUT, productId=InventoryItem.productId, origAmount=(the value computed in 1), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=inventoryItem.ownerPartyId

4) put the 4 entries in a list and call the createAcctgTransAndEntries service with the following fields: acctgTransTypeId=INVENTORY, acctgTransEntries=(the list with the 4 entries), inventoryItemId=parameters.inventoryItemId, glFiscalTypeId=ACTUAL

The ECA will be:
<eca service="updateInventoryItem" event="commit">
<condition field-name="ownerPartyId" operator="is-not-empty"/>
<condition-field field-name="ownerPartyId" operator="not-equals" to-field-name="oldOwnerPartyId"/>
<action service="createAcctgTransForInventoryItemOwnerChange" mode="sync"/>
</eca>

You can then test the service when you go into an Inventory Item in the facility, and change the ownerPartyId of an inventory item.