Hi,
I am trying to add in the price and cost for each item on the Item Movement report. However this report seems to run off a view rather than a table. How can I join the ViewItemMovement view and the Item table in order to add in the Item.Price and Item.Cost fileds to this report? When I try to do this I get the following error :
'Aritmmetic Overflow error coverting expression to data type int'