[jira] Created: (OFBIZ-1742) Implementation of a service to compute the product average cost
Locked
[jira] Created: (OFBIZ-1742) Implementation of a service to compute the product average cost
 
|
Implementation of a service to compute the product average cost
--------------------------------------------------------------- Key: OFBIZ-1742 URL: https://issues.apache.org/jira/browse/OFBIZ-1742 Project: OFBiz Issue Type: New Feature Components: accounting, product Affects Versions: SVN trunk Reporter: Rashko Rejmer Priority: Minor Fix For: SVN trunk Attachments: averageCostScreen.patch Based on: http://markmail.org/message/shcyetdwusggu6eo Jacopo Cappelato says: "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... Do you think that storing it in the ProductAverageCost entity is a good idea? However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rashko Rejmer updated OFBIZ-1742: --------------------------------- Attachment: averageCostScreen.patch This patch contains service for product average cost calculation and screen that displays product average costs for a facility. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rashko Rejmer updated OFBIZ-1742: --------------------------------- Attachment: ProductAverageCostEntity.patch This patch contains mentioned changes to ProductAverageCost entity, CRUD services, new ProductAverageCostType entity and seed data. There is still missing part of this issue - the service that will be invoked when the QOH is changed. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux reassigned OFBIZ-1742: -------------------------------------- Assignee: Jacques Le Roux > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676268#action_12676268 ] Jacques Le Roux commented on OFBIZ-1742: ---------------------------------------- Thanks Rashko, I have commited modified patchs from yours in trunk at revision 747364 & 747377. Still waiting for somebody to cover the remaining of this issue before closing : The service that will be invoked when the QOH is changed and that will store/update ProductAverageCost values. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sumit Pandit updated OFBIZ-1742: -------------------------------- Attachment: ProdAverageCost.patch Here in attached patch(ProdAverageCost.patch), a service which is invoked on receive Inventory (receiveInventoryProduct) service, it expires existing ProductAverageCost value, recalculate the average cost and create a new one. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740394#action_12740394 ] Sumit Pandit commented on OFBIZ-1742: ------------------------------------- Hello All, Along with this service, I would like to modify existing general ledger services where accounting transaction for COGS is posted (createAcctgTransForSalesShipmentIssuance, createAcctgTransForCanceledSalesShipmentIssuance, createAcctgTransForShipmentReceipt). In above services cost of goods sold is calculated by ProductAverageCost instead of InventoryItem.unitCost. Now the patch will be consolidated patch for costing algorithms and where the calculated average cost can be used. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sumit Pandit updated OFBIZ-1742: -------------------------------- Attachment: ProdAverageCost.patch Here is consolidated patch to calculate the average cost and use the same for accounting transaction entries for COGS. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Jacques Le Roux > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-1742: ----------------------------------- Assignee: Anil K Patel (was: Jacques Le Roux) > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Anil K Patel > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741295#action_12741295 ] Anil K Patel commented on OFBIZ-1742: ------------------------------------- Patch applied to Ofbiz r802764. Sumit Thanks for patch. > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Anil K Patel > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-1742) Implementation of a service to compute the product average cost
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-1742. ---------------------------------- Resolution: Fixed > Implementation of a service to compute the product average cost > --------------------------------------------------------------- > > Key: OFBIZ-1742 > URL: https://issues.apache.org/jira/browse/OFBIZ-1742 > Project: OFBiz > Issue Type: New Feature > Components: accounting, product > Affects Versions: SVN trunk > Reporter: Rashko Rejmer > Assignee: Anil K Patel > Priority: Minor > Fix For: SVN trunk > > Attachments: averageCostScreen.patch, ProdAverageCost.patch, ProdAverageCost.patch, ProductAverageCostEntity.patch > > > Based on: > http://markmail.org/message/shcyetdwusggu6eo > Jacopo Cappelato says: > "I have to implement a service that computes the inventory average cost of a product (based on current QOH and inventory items' unit costs) and stores it somewhere... > Do you think that storing it in the ProductAverageCost entity is a good idea? > However I think that it is important to give the ability to maintain a separate cost for each facility (for example the items in a facility in US and the ones in a facility in China could have very different inventory costs); the key of the ProductAverageCost is now composed by productId, organizationPartyId, fromDate so I think we should add to it also the facilityId and possibly a productAverageCostTypeId field (to maintain different types of averages).... > ... and run the service (probably as a seca) every time a product is received/shipped/etc... (i.e. everytime the qoh of a product changes); the result of the service call could be stored in the ProductAverageCost entity." -- 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 |