Finance | Project Operations, Human Resources, ...

Inventory Value Report Financial Amount Calculation

(0) Share

Report

Posted on by ADJ_

How we can calculate Inventory: Financial amount for inventory value report in Microsoft dynamics 365 Finance and Operations. Any calculations are required there?

InventTrans is the table I have used.To find the financial cost amount I have applied this condition,
If StatusIssue <= 1 (None or Sold) and StatusReceipt <= 1 (None or Purchased), then the cost of that InventTrans record is CostAmountPosted + CostAmountAdjustment.

But it's not matching in all the cases(Inventory value report and InventTrans)

Do we need to apply any other conditions ?

Thanks in Advance.

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

moved to the d365 forum

Was this reply helpful? Yes No
Suggested answer

OsmanIstanbul 2,818 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You must take CostAmountPosted from inventtrans and CostAmountAdjustment from inventsettlement. For inventsettlement use inventsettlement.transdate. Hope this helps.

Best Regards.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Osman Akgündüz, resolved ,Thanks

Was this reply helpful? Yes No
OsmanIstanbul 2,818 on at

Like (0)

Report
Copy link

Link copied!

Thank you Aj for the update, if your issue is solved, please kindly mark it as solved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The issue was solved, but I can't login in with that Id. So that I don't have the permission to mark it as solved. Sorry for that and thanks,

Regards,

Ann James

Was this reply helpful? Yes No