Vendor/Item Statistics

trin
trin Member Posts: 110
edited 2006-03-21 in Navision Attain
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

Comments

  • Savatage
    Savatage Member Posts: 7,142
    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
    trin Member Posts: 110
    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