Stock Label Print by Item Quantity

chrisstitch
Member Posts: 2
I've created a stock label in NAV2013 as a report, printing the 'Item Code','Item Name', 'Description' etc. using a list.
This produces one label per page as required but only produces one label per SKU.
I'm trying to get it to print the quantity in stock but haven't got an idea of where to start even though I've been reading up on this.
I've got it to filter to show only the SKU's in stock using Inventory_Item but there seems to be a lack of info to do with quantity's of print from within NAV.
I think its either printloop or copyloop but i'm not even sure about that. Can anyone point me in the right direction please?
This produces one label per page as required but only produces one label per SKU.
I'm trying to get it to print the quantity in stock but haven't got an idea of where to start even though I've been reading up on this.
I've got it to filter to show only the SKU's in stock using Inventory_Item but there seems to be a lack of info to do with quantity's of print from within NAV.
I think its either printloop or copyloop but i'm not even sure about that. Can anyone point me in the right direction please?
0
Comments
-
Add two data items in your report....
Item
<Indent>Integer
DataItem Item -> DataItemTableView : SORTING(No.) WHERE(Inventory=FILTER(<>0))
DataItem Integer -> OnPreDataItem
item.calcfields(inventory);
integer.setrange(Number,1,item.inventory);If your work becomes a passion...
www.pardaan.com0
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