You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Ratnesh Upadhyay (JIRA)" <ji...@apache.org> on 2009/09/08 17:08:57 UTC
[jira] Created: (OFBIZ-2914) Improved Inventory Average Cost
Valuation Algorithm.
Improved Inventory Average Cost Valuation Algorithm.
----------------------------------------------------
Key: OFBIZ-2914
URL: https://issues.apache.org/jira/browse/OFBIZ-2914
Project: OFBiz
Issue Type: Improvement
Components: accounting
Affects Versions: SVN trunk
Reporter: Ratnesh Upadhyay
Fix For: SVN trunk
Now this calculation will be done by following formula : ( (old average cost * total old stock) + (new purchase price * new qty received) ) / (total old stock + new qty received).
You can verify calculated result from Accounting > Organization GL Settings > Reports > Inventory valuation report screen.
Regards,
-- Ratnesh Upadhyay
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2914) Improved Inventory Average Cost
Valuation Algorithm.
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12752972#action_12752972 ]
Jacques Le Roux commented on OFBIZ-2914:
----------------------------------------
The patch has been commited at r812744, should we not close ?
> Improved Inventory Average Cost Valuation Algorithm.
> ----------------------------------------------------
>
> Key: OFBIZ-2914
> URL: https://issues.apache.org/jira/browse/OFBIZ-2914
> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Ratnesh Upadhyay
> Assignee: Anil K Patel
> Fix For: SVN trunk
>
> Attachments: OFBiz-2914.patch
>
>
> Now this calculation will be done by following formula : ( (old average cost * total old stock) + (new purchase price * new qty received) ) / (total old stock + new qty received).
> You can verify calculated result from Accounting > Organization GL Settings > Reports > Inventory valuation report screen.
> Regards,
> -- Ratnesh Upadhyay
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-2914) Improved Inventory Average Cost
Valuation Algorithm.
Posted by "Ratnesh Upadhyay (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ratnesh Upadhyay updated OFBIZ-2914:
------------------------------------
Attachment: OFBiz-2914.patch
Attached patch for improved algorithm.
Thanks Sumit and Anil for discussion on it. I would like to give special Thanks to Eva for providing example process.
Regards,
-- Ratnesh Upadhyay
> Improved Inventory Average Cost Valuation Algorithm.
> ----------------------------------------------------
>
> Key: OFBIZ-2914
> URL: https://issues.apache.org/jira/browse/OFBIZ-2914
> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Ratnesh Upadhyay
> Fix For: SVN trunk
>
> Attachments: OFBiz-2914.patch
>
>
> Now this calculation will be done by following formula : ( (old average cost * total old stock) + (new purchase price * new qty received) ) / (total old stock + new qty received).
> You can verify calculated result from Accounting > Organization GL Settings > Reports > Inventory valuation report screen.
> Regards,
> -- Ratnesh Upadhyay
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-2914) Improved Inventory Average Cost
Valuation Algorithm.
Posted by "Vikas Mayur (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vikas Mayur closed OFBIZ-2914.
------------------------------
Resolution: Fixed
Patch is committed in r812744. Thank you - Everyone.
> Improved Inventory Average Cost Valuation Algorithm.
> ----------------------------------------------------
>
> Key: OFBIZ-2914
> URL: https://issues.apache.org/jira/browse/OFBIZ-2914
> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Ratnesh Upadhyay
> Assignee: Anil K Patel
> Fix For: SVN trunk
>
> Attachments: OFBiz-2914.patch
>
>
> Now this calculation will be done by following formula : ( (old average cost * total old stock) + (new purchase price * new qty received) ) / (total old stock + new qty received).
> You can verify calculated result from Accounting > Organization GL Settings > Reports > Inventory valuation report screen.
> Regards,
> -- Ratnesh Upadhyay
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (OFBIZ-2914) Improved Inventory Average Cost
Valuation Algorithm.
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anil K Patel reassigned OFBIZ-2914:
-----------------------------------
Assignee: Anil K Patel
> Improved Inventory Average Cost Valuation Algorithm.
> ----------------------------------------------------
>
> Key: OFBIZ-2914
> URL: https://issues.apache.org/jira/browse/OFBIZ-2914
> Project: OFBiz
> Issue Type: Improvement
> Components: accounting
> Affects Versions: SVN trunk
> Reporter: Ratnesh Upadhyay
> Assignee: Anil K Patel
> Fix For: SVN trunk
>
> Attachments: OFBiz-2914.patch
>
>
> Now this calculation will be done by following formula : ( (old average cost * total old stock) + (new purchase price * new qty received) ) / (total old stock + new qty received).
> You can verify calculated result from Accounting > Organization GL Settings > Reports > Inventory valuation report screen.
> Regards,
> -- Ratnesh Upadhyay
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.