Crosscheck between InventSum to InventTrans

(0) Share

Report

Posted on by ShaqAX

709

Hello all,

If I have a value, lets say PhysicalValue in InventSum for 1 item, can I check the transactions in InvenTrans ? what is the connecctions ? InventTrans has field CostAmountPhysical, this is what I need to crosscheck, right? But I cannot seems to get the matching value?

Is it right to say, Sum of CostAmountPhysical in Inventtrans for each InventDimId is going to InventSum,PhysicalValue ? (in 1 item)

I'm using D365 F&O, btw. Afraid that different version has different meaning.

Kindly advice

Thanks,

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Sergei Minozhenko 23,097 on at

Like (1)

Report
Copy link

Link copied!

Hi ShaqAX,

sum of CostAmountPhysical on inventTrans should match to PhysicalValue on inventTrans. Have you checked if values matched within the item (without dimensions?)

By the way, there is a standard on-hand consistency check if you need to do it in System administration - Periodic

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

You're right. it should matched. Finally I found the cause. Solved.

Thanks for the tools as well. Don't know this before.

Thanks again.

Was this reply helpful? Yes No