[jira] Created: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
Locked
[jira] Created: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
 
|
Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
------------------------------------------------------------------------------------------ Key: OFBIZ-1457 URL: https://issues.apache.org/jira/browse/OFBIZ-1457 Project: OFBiz Issue Type: Sub-task Components: accounting Affects Versions: SVN trunk Reporter: Jacopo Cappellato The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: origAmount = QOH * (oldUnitCost - newUnitCost) the glAccountTypeId to be used for the double entries are: INV_ADJ_VAL for D INVENTORY_ACCOUNT for C and the acctgTransTypeId is INVENTORY The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikas Mayur updated OFBIZ-1457: ------------------------------- Attachment: glPostingService.patch Patch from Jyotsna Rathore > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12547784 ] JyotsnaRathore commented on OFBIZ-1457: --------------------------------------- the recieptId is not created when we update the unitCost in InventoryItemDetail entity.I think condition should be recieptId is-empty. I've tested and uploaded the new patch with suggested modifications in code > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JyotsnaRathore updated OFBIZ-1457: ---------------------------------- Attachment: glPostingService.patch some updation in createAcctgTransForInventoryItemCostChange and seca rule. > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingService.patch, glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12547795 ] Jacopo Cappellato commented on OFBIZ-1457: ------------------------------------------ Jyotsna, you are completely right about the condition on receiptId: the service must be executed only if receiptId is-empty. Sorry for the confuusion. > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingService.patch, glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] JyotsnaRathore updated OFBIZ-1457: ---------------------------------- Attachment: glPostingService.patch > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Attachments: glPostingService.patch, glPostingService.patch, glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-1457: ----------------------------------- Assignee: Anil K Patel > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Assignee: Anil K Patel > Attachments: glPostingService.patch, glPostingService.patch, glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-1457) Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel closed OFBIZ-1457. ------------------------------- Resolution: Fixed Thanks Jyotsna Rathore and others for their help. Patch is in rev # 600730 > Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-1457 > URL: https://issues.apache.org/jira/browse/OFBIZ-1457 > Project: OFBiz > Issue Type: Sub-task > Components: accounting > Affects Versions: SVN trunk > Reporter: Jacopo Cappellato > Assignee: Anil K Patel > Attachments: glPostingService.patch, glPostingService.patch, glPostingService.patch > > > The name of the service can be "createAcctgTransForInventoryItemCostChange" or similar. > We can use the following template for this service: createAcctgTransForShipmentReceipt in GeneralLedgerServices.xml > The service is triggered by a SECA rule on createInventoryItemDetail with the condition: unitCost is-not-empty and receiptId is-not-empty (we don't want the service to run when the item is received aka created); in this way, every time an InventoryItemDetail with a non null unitCost is created (that means we have changed the cost of the item) we have to run the service to post the following adjustment to the GL: > origAmount = QOH * (oldUnitCost - newUnitCost) > the glAccountTypeId to be used for the double entries are: > INV_ADJ_VAL for D > INVENTORY_ACCOUNT for C > and the acctgTransTypeId is INVENTORY > The newUnitCost is the cost found in the last created InventoryItemDetail, the oldUnitCost is in the most recent InventoryItemDetail (that is not the last one) with unitCost != null -- 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 |