[jira] Created: (OFBIZ-2914) Improved Inventory Average Cost Valuation Algorithm.

[Nicolas Malin (Jira)]

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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

     [ 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.

[Nicolas Malin (Jira)]

    [ 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.

[Nicolas Malin (Jira)]

     [ 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.