Howdy, Stranger!
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
- 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
- 310 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Report displaying all stock in a location with SO
Michaellee
Member Posts: 65
Hi all,
Relatively new on the development of Navision and I need to amend a report.
The issue is this:
I am looking for all stock in a certain location and based on the item, be able to detail what SO the item is reserved to, we also have items that are not reserved but are in stock which needs to be displayed as well.
So, I was thinking of using the item ledger entry table to start off as there is an existing report that we have that details all stock in a certain location so that is 1/2 the problem solved (or so I thought).
I then have used the reservation entry table as a Global variable to SETRANGE on each of the items to find all the reservations that are open for the said item. But now, I don't know how to display the SO numbers. I was thinking of using the WHILE statement to collate all the SO numbers into a text field but I am unsure of the syntax for the WHILE statement and have searched the help but to no avail... Also, would this be the best way to do this? We are on version 2.6.
I know that this is a real newbie question but any help would be appreciated.
Thanks in advance.
Relatively new on the development of Navision and I need to amend a report.
The issue is this:
I am looking for all stock in a certain location and based on the item, be able to detail what SO the item is reserved to, we also have items that are not reserved but are in stock which needs to be displayed as well.
So, I was thinking of using the item ledger entry table to start off as there is an existing report that we have that details all stock in a certain location so that is 1/2 the problem solved (or so I thought).
I then have used the reservation entry table as a Global variable to SETRANGE on each of the items to find all the reservations that are open for the said item. But now, I don't know how to display the SO numbers. I was thinking of using the WHILE statement to collate all the SO numbers into a text field but I am unsure of the syntax for the WHILE statement and have searched the help but to no avail... Also, would this be the best way to do this? We are on version 2.6.
I know that this is a real newbie question but any help would be appreciated.
Thanks in advance.
0
Answers
[PS: can you change the title to something that explains what the topic is about]
I think it is best you have a dataitem for "Item" in which the user can filter the items he wants to see. For the locationcode, you can request that from the user in the requestform.
Under the item, you can put another dataitem on reservation entry filtered by the item and the location code.
With this you can show the needed fields on the report.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Thanks again.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Mike