[jira] Created: (OFBIZ-1458) Implement an automatic GL posting service triggered when a physical inventory variance is performed
Locked
[jira] Created: (OFBIZ-1458) Implement an automatic GL posting service triggered when a physical inventory variance is performed
 
|
Implement an automatic GL posting service triggered when a physical inventory variance is performed
--------------------------------------------------------------------------------------------------- Key: OFBIZ-1458 URL: https://issues.apache.org/jira/browse/OFBIZ-1458 Project: OFBiz Issue Type: Sub-task Components: accounting Affects Versions: SVN trunk Reporter: Jacopo Cappellato The name of the service can be "createAcctgTransForPhysicalInventoryVariance" or similar. Input field: physicalInventoryId Output field: acctgTransId We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml The service is triggered by a SECA rule on createPhysicalInventoryAndVariance The service will do the following tasks: 1) select all the InventoryItemDetails for the given physicalInventoryId 2) iterate the list of InventoryItemDetails and for each InventoryItemDetail: 2a) select the associated InventoryItem 2b) compute the following amount: origAmount = InventoryItemDetail.quantityOnHandDiff * InventoryItem.unitCost 2c) create one AcctgTransEntry for the credit: debitCreditFlag=C, glAcctgTransTypeId=InventoryItemDetail.reasonId, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId 2d) create one AcctgTransEntry for the debit: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId 2e) put the two entries in a list (go back to 2a) 3) when the iteration is done, call the createAcctgTransAndEntries with the following fields: acctgTransTypeId=ITEM_VARIANCE_ACCTG_, acctgTransEntries=(the list at 2e), physicalInventoryId=parameters.physicalInventoryId, glFiscalTypeId=ACTUAL the ECA will be: <eca service="createPhysicalInventoryAndVariance" event="commit"> <condition field-name="physicalInventoryId" operator="is-not-empty"/> <action service="createAcctgTransForPhysicalInventoryVariance" mode="sync"/> </eca> You can then test the service when you go into an Inventory Item in the facility, and perform a manual inventory variance. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1458) Implement an automatic GL posting service triggered when a physical inventory variance is performed
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikas Mayur updated OFBIZ-1458: ------------------------------- Attachment: glPostingServiceForVariance.patch Patch from Sachin Chourasiya > Implement an automatic GL posting service triggered when a physical inventory variance is performed > --------------------------------------------------------------------------------------------------- > > Key: OFBIZ-1458 > URL: https://issues.apache.org/jira/browse/OFBIZ-1458 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingServiceForVariance.patch > > > The name of the service can be "createAcctgTransForPhysicalInventoryVariance" or similar. > Input field: physicalInventoryId > Output field: acctgTransId > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createPhysicalInventoryAndVariance > The service will do the following tasks: > 1) select all the InventoryItemDetails for the given physicalInventoryId > 2) iterate the list of InventoryItemDetails and for each InventoryItemDetail: > 2a) select the associated InventoryItem > 2b) compute the following amount: origAmount = InventoryItemDetail.quantityOnHandDiff * InventoryItem.unitCost > 2c) create one AcctgTransEntry for the credit: debitCreditFlag=C, glAcctgTransTypeId=InventoryItemDetail.reasonId, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2d) create one AcctgTransEntry for the debit: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2e) put the two entries in a list (go back to 2a) > 3) when the iteration is done, call the createAcctgTransAndEntries with the following fields: acctgTransTypeId=ITEM_VARIANCE_ACCTG_, acctgTransEntries=(the list at 2e), physicalInventoryId=parameters.physicalInventoryId, glFiscalTypeId=ACTUAL > the ECA will be: > <eca service="createPhysicalInventoryAndVariance" event="commit"> > <condition field-name="physicalInventoryId" operator="is-not-empty"/> > <action service="createAcctgTransForPhysicalInventoryVariance" mode="sync"/> > </eca> > You can then test the service when you go into an Inventory Item in the facility, and perform a manual inventory variance. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-1458) Implement an automatic GL posting service triggered when a physical inventory variance is performed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-1458: ----------------------------------- Assignee: Anil K Patel > Implement an automatic GL posting service triggered when a physical inventory variance is performed > --------------------------------------------------------------------------------------------------- > > Key: OFBIZ-1458 > URL: https://issues.apache.org/jira/browse/OFBIZ-1458 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Assignee: Anil K Patel > Attachments: glPostingServiceForVariance.patch > > > The name of the service can be "createAcctgTransForPhysicalInventoryVariance" or similar. > Input field: physicalInventoryId > Output field: acctgTransId > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createPhysicalInventoryAndVariance > The service will do the following tasks: > 1) select all the InventoryItemDetails for the given physicalInventoryId > 2) iterate the list of InventoryItemDetails and for each InventoryItemDetail: > 2a) select the associated InventoryItem > 2b) compute the following amount: origAmount = InventoryItemDetail.quantityOnHandDiff * InventoryItem.unitCost > 2c) create one AcctgTransEntry for the credit: debitCreditFlag=C, glAcctgTransTypeId=InventoryItemDetail.reasonId, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2d) create one AcctgTransEntry for the debit: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2e) put the two entries in a list (go back to 2a) > 3) when the iteration is done, call the createAcctgTransAndEntries with the following fields: acctgTransTypeId=ITEM_VARIANCE_ACCTG_, acctgTransEntries=(the list at 2e), physicalInventoryId=parameters.physicalInventoryId, glFiscalTypeId=ACTUAL > the ECA will be: > <eca service="createPhysicalInventoryAndVariance" event="commit"> > <condition field-name="physicalInventoryId" operator="is-not-empty"/> > <action service="createAcctgTransForPhysicalInventoryVariance" mode="sync"/> > </eca> > You can then test the service when you go into an Inventory Item in the facility, and perform a manual inventory variance. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-1458) Implement an automatic GL posting service triggered when a physical inventory variance is performed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel closed OFBIZ-1458. ------------------------------- Resolution: Fixed Thanks Sachin Chourasia and others for providing implementation. Patch is in rev# 600738 > Implement an automatic GL posting service triggered when a physical inventory variance is performed > --------------------------------------------------------------------------------------------------- > > Key: OFBIZ-1458 > URL: https://issues.apache.org/jira/browse/OFBIZ-1458 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Assignee: Anil K Patel > Attachments: glPostingServiceForVariance.patch > > > The name of the service can be "createAcctgTransForPhysicalInventoryVariance" or similar. > Input field: physicalInventoryId > Output field: acctgTransId > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createPhysicalInventoryAndVariance > The service will do the following tasks: > 1) select all the InventoryItemDetails for the given physicalInventoryId > 2) iterate the list of InventoryItemDetails and for each InventoryItemDetail: > 2a) select the associated InventoryItem > 2b) compute the following amount: origAmount = InventoryItemDetail.quantityOnHandDiff * InventoryItem.unitCost > 2c) create one AcctgTransEntry for the credit: debitCreditFlag=C, glAcctgTransTypeId=InventoryItemDetail.reasonId, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2d) create one AcctgTransEntry for the debit: debitCreditFlag=D, glAcctgTransTypeId=INVENTORY_ACCOUNT, productId=InventoryItem.productId, origAmount=(the value computed in 2b), origCurrencyUomId=InventoryItem.currencyUomId, organizationPartyId=InventoryItem.ownerPartyId > 2e) put the two entries in a list (go back to 2a) > 3) when the iteration is done, call the createAcctgTransAndEntries with the following fields: acctgTransTypeId=ITEM_VARIANCE_ACCTG_, acctgTransEntries=(the list at 2e), physicalInventoryId=parameters.physicalInventoryId, glFiscalTypeId=ACTUAL > the ECA will be: > <eca service="createPhysicalInventoryAndVariance" event="commit"> > <condition field-name="physicalInventoryId" operator="is-not-empty"/> > <action service="createAcctgTransForPhysicalInventoryVariance" mode="sync"/> > </eca> > You can then test the service when you go into an Inventory Item in the facility, and perform a manual inventory variance. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |