[jira] Created: (OFBIZ-2824) Implement Inventory Valuation report

[Nicolas Malin (Jira)]

Implement Inventory Valuation report
------------------------------------

                 Key: OFBIZ-2824
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2824
             Project: OFBiz
          Issue Type: Improvement
          Components: accounting
    Affects Versions: SVN trunk
            Reporter: Sumit Pandit
            Priority: Minor
             Fix For: SVN trunk


The reports should be placed under Reports tab in accounting.
Filters: Facility id (owned by the company for which we are running the GL), Product id , Product Category id, Date range; Cost Type
Columns: Product; Quantity on Hand; Unit Cost; Total Value.

According to the "Cost Type" selected the Unit Cost value will change; however for now we will only implement "average costing".
The drop down for "Cost Type" should contain the same values in this (Cost Of Goods Sold (COGS) Method):
https://localhost:8443/accounting/control/AdminMain?organizationPartyId=DemoLeadOwnersGroup
and the default value should be the same selected in that screen (PartyAcctgPreferences)

Reuse artifacts from the following report that is already computing average costs for products:
https://localhost:8443/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse


Thanks Eva, Vince and Jacopo for guidance.

--
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-2824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Surya Kusumakar updated OFBIZ-2824:
-----------------------------------

    Attachment: Ofbiz_2824.patch

Here is the patch for Inventory Valuation Report .
Currently this patch works only for average cost.

Thanks to Sumit,Rishi and Awdesh.
Surya Kusumakar

> Implement Inventory Valuation report
> ------------------------------------
>
>                 Key: OFBIZ-2824
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2824
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: Ofbiz_2824.patch
>
>
> The reports should be placed under Reports tab in accounting.
> Filters: Facility id (owned by the company for which we are running the GL), Product id , Product Category id, Date range; Cost Type
> Columns: Product; Quantity on Hand; Unit Cost; Total Value.
> According to the "Cost Type" selected the Unit Cost value will change; however for now we will only implement "average costing".
> The drop down for "Cost Type" should contain the same values in this (Cost Of Goods Sold (COGS) Method):
> https://localhost:8443/accounting/control/AdminMain?organizationPartyId=DemoLeadOwnersGroup
> and the default value should be the same selected in that screen (PartyAcctgPreferences)
> Reuse artifacts from the following report that is already computing average costs for products:
> https://localhost:8443/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse
> Thanks Eva, Vince and Jacopo for guidance.

--
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-2824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anil K Patel reassigned OFBIZ-2824:
-----------------------------------

    Assignee: Anil K Patel

> Implement Inventory Valuation report
> ------------------------------------
>
>                 Key: OFBIZ-2824
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2824
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Assignee: Anil K Patel
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: Ofbiz_2824.patch
>
>
> The reports should be placed under Reports tab in accounting.
> Filters: Facility id (owned by the company for which we are running the GL), Product id , Product Category id, Date range; Cost Type
> Columns: Product; Quantity on Hand; Unit Cost; Total Value.
> According to the "Cost Type" selected the Unit Cost value will change; however for now we will only implement "average costing".
> The drop down for "Cost Type" should contain the same values in this (Cost Of Goods Sold (COGS) Method):
> https://localhost:8443/accounting/control/AdminMain?organizationPartyId=DemoLeadOwnersGroup
> and the default value should be the same selected in that screen (PartyAcctgPreferences)
> Reuse artifacts from the following report that is already computing average costs for products:
> https://localhost:8443/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse
> Thanks Eva, Vince and Jacopo for guidance.

--
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-2824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anil K Patel closed OFBIZ-2824.
-------------------------------

    Resolution: Fixed

Patch applied to r 803363. Thanks.

> Implement Inventory Valuation report
> ------------------------------------
>
>                 Key: OFBIZ-2824
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2824
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Assignee: Anil K Patel
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: Ofbiz_2824.patch
>
>
> The reports should be placed under Reports tab in accounting.
> Filters: Facility id (owned by the company for which we are running the GL), Product id , Product Category id, Date range; Cost Type
> Columns: Product; Quantity on Hand; Unit Cost; Total Value.
> According to the "Cost Type" selected the Unit Cost value will change; however for now we will only implement "average costing".
> The drop down for "Cost Type" should contain the same values in this (Cost Of Goods Sold (COGS) Method):
> https://localhost:8443/accounting/control/AdminMain?organizationPartyId=DemoLeadOwnersGroup
> and the default value should be the same selected in that screen (PartyAcctgPreferences)
> Reuse artifacts from the following report that is already computing average costs for products:
> https://localhost:8443/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse
> Thanks Eva, Vince and Jacopo for guidance.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.