Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Query and tables
DarkHorse
Member Posts: 389
Dear folks, I use Microsoft Query (from excel) for showing amounts and work with them. I get the Item table to know the cost of my stock. I choose "Rep.Vendor" (a field that ) I've created, Inventory and Unit cost. After I multiply Inventory by Unit cost and it shows me the total cost of the stock from that vendor.
But know I want do the same but doing by Location, but there is not the Location field in this table. I've try to choose another table and unite the fields but it doesn't work. I don't know what table can I use to know this quantities by Location. Any idea please?.
Thanks in advance.
But know I want do the same but doing by Location, but there is not the Location field in this table. I've try to choose another table and unite the fields but it doesn't work. I don't know what table can I use to know this quantities by Location. Any idea please?.
Thanks in advance.
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Thanks for help.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n