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
- 309 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 to show which serial number of Bin Content quantity
rajneilg
Member Posts: 2
Hi All,
I have a question which I have looked on this forum for and everywhre on the net but have not been able to find the answer for. I am trying to write a report that displays the Bin Code, Item No, and Quantity from the Bin Contents table. I want to then list the serial numbers that relate to the bin that makes up the total quantity value of the Bin Content. I have got to a point where I list all the warehouse entries relating to the serial number but this obviously shows the negative and positive movements. My question is, how do i filter the serial numbers so it only shows the one that has stock against it. I had a look at the code for the Phys. Inventory list report (722) where this seems to be doing what I want to achieve. But I cannot figure out where it is filtering the serial numbers. If someone could point me in the right direction please. Any help will be much appreciated!
Raj.
I have a question which I have looked on this forum for and everywhre on the net but have not been able to find the answer for. I am trying to write a report that displays the Bin Code, Item No, and Quantity from the Bin Contents table. I want to then list the serial numbers that relate to the bin that makes up the total quantity value of the Bin Content. I have got to a point where I list all the warehouse entries relating to the serial number but this obviously shows the negative and positive movements. My question is, how do i filter the serial numbers so it only shows the one that has stock against it. I had a look at the code for the Phys. Inventory list report (722) where this seems to be doing what I want to achieve. But I cannot figure out where it is filtering the serial numbers. If someone could point me in the right direction please. Any help will be much appreciated!
Raj.
0
Comments
Off the top of my head, I'd try this approach....
Under the bin contents iteration add an Item Ledger Entry iteration, filtered for Positive = Yes, and Remaining Quantity > 0, and Serial No. <> ''. By definition, you should only find one ILE record for each serial number. This step is to ensure that you're only looking for serial numbers that are actually in stock, rather than checking every serial no that has ever been put in that bin.
After you've gotten the ILE record, use a Bin Contents variable such as BinCont2. Set filters to match the bin content record you're currently reporting and set the Serial No filter based on the ILE record you're pointed to. Then CalcFields() on the qty from BinCont2. If the quantity is zero, CurrReport.SKIP since that serial no is not in that bin. If the qty is greater than zero, show the qty in the ILE section via a text box.
There might be better ways. That's just one off the top of my head.
Hope it helped.