Customize Inventory value Report with Cost Amount based on CWQty?

(0) Share

Report

Posted on by Community Member

Hi all, so I've a requirement to customize existing Inventory Value report with additional CW Qty in each column and also the cost amount column based on CW Qty, so far I'm able to add the CW Qty (Financial CW Qty, Physical CWQty posted, Physical CW Qty non posted and also CW Qty) but I stuck at the Cost Amount based on CW Qty.

I've checked the Classes\InventValueReportPopulateItem\UpdateReportLineBalance where the cost amount are from Views\InventValueReportView\Amount field and the Amount field are pulled from InventValueFinancialBalance View which has computed column method as below.

5810.amount.png

In here i can see that the amount field is calculated from InventSum table Postedvalue field, now I'm stuck as how to calculate that amount based on CW Qty to present it in InventoryValue report?

As I've also checked the Posted Value seems that it's calculated from InventTrans/CostValue method which has this code :

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Ahau,

As far as I understand there is no "CW cost amount" because CW qty is just a qty converted to CW unit.

But it's more functional question than technical actually so maybe functional folks will correct me here.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen,

Do you mean that both cw qty and qty actually has the same cost amount since they are the same quantity?

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hi Ahau,

Yep. You have an inventory transaction that has two quantities and one cost amount for both of them.

Was this reply helpful? Yes No