Vendor/Item Statistics

trin
Member Posts: 110
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
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
0
Comments
-
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?0 -
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.
Thanks0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions