Item Movement Report

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'

Reply to
datapac_bs
Loading thread data ...

I've got one with what you need. It's a Headquarters report. If you'd like I can send it to you.

snipped-for-privacy@venus.com

"datapac_bs" wrote:

Reply to
Luminox

Hi Luminox,

I would appreciate if you could send this report to me. My email address is snipped-for-privacy@datapac.com Many thanks.

Reply to
datapac bs

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.