get unit price from value entry table in report based on grouping item ledger entry table

[ahmedsa]

I make report to grouping data in item ledger entry table as following

item no quantity amount

but i face problem .

unit price not found in item ledger entry table but it found in value entry table

How i got unit price from value entry table

can you show me example code

I need report as following

item no quantity unit price amount

I using dynamic nav 2009 r2

thanks

[faludigabor]

Hi,

You should be looking at Cost Amount (Actual) (and potentially Cost amount (Expected) ) and the quantity on the ILE . COA / Qty = Actual unit cost.

g.