Vendor/Item Statistics

trin

Hi,

This happens on 3.10 for report Vendor/Item Statistics. If I ran this report for company A it works, and if I ran it for another company-B it did not work. I mean if I pull all the value entries for one item and filtered by Invoiced Quantity<>0 within a time rang, the total amount matched for company A but did not match on the other one B. However, I knew for sure there are a lot of invoiced purchases on company B. Any ideas? This report has not been modified.

Thanks

Savatage

Just to be clear
1)So you have No filters on the Vendor Tab
2)On the Value Entry Tab You only use a posting date range & and Item #
2a) lose the <>0
3)You are goining into different companies & running the same report.
4)One you think is right & one you think is wrong.

You can verify the amounts by going to the items card then looking at
Item->statistics->Turnover

You can adjust this by day,week,month,quarter, year.

Are you sure Locations aren't playing a part?
You are not using a location filter?
Are you using a date filter or posting date?

trin

Hi,

I found out the problem. It was the dimension. Value entry have two dimensions but vendor only have one so when it tries to match no record can be found.

Thanks