Sr. No. (item tracking) printing prob.

upasanisandip
Member Posts: 405
HI,
I want to show Serial No. from Item tracking so i am using Resrevation Entry table for that.
In Repeat.. Unitl loop i am printing that.
But getting Sr. no. like following
Type No. Description
Item I0066 ABC
L1,L2
ITEM I0064 XYZ
L1,01,02
As you can see L1 is appearing again
I code for it like following
is there any error in that ?
CheckShptLines(SalesLine2 : Record "Sales Line")
// Added by sandip start
//MESSAGE (TempSrno);
CLEAR(TempSrno);
ReservationEntry.RESET;
ReservationEntry.SETFILTER(ReservationEntry."Source ID","Sales Line"."Document No.");
IF ReservationEntry.FIND('-') THEN
REPEAT
ReservationEntry.SETFILTER(ReservationEntry."Item No.","Sales Line"."No.");
IF TempSrno= '' THEN
TempSrno:= ReservationEntry."Serial No."
ELSE
TempSrno:=TempSrno + ',' + ReservationEntry."Serial No.";
UNTIL ReservationEntry.NEXT= 0;
Thanks,
Sandip.
I want to show Serial No. from Item tracking so i am using Resrevation Entry table for that.
In Repeat.. Unitl loop i am printing that.
But getting Sr. no. like following
Type No. Description
Item I0066 ABC
L1,L2
ITEM I0064 XYZ
L1,01,02
As you can see L1 is appearing again
I code for it like following
is there any error in that ?
CheckShptLines(SalesLine2 : Record "Sales Line")
// Added by sandip start
//MESSAGE (TempSrno);
CLEAR(TempSrno);
ReservationEntry.RESET;
ReservationEntry.SETFILTER(ReservationEntry."Source ID","Sales Line"."Document No.");
IF ReservationEntry.FIND('-') THEN
REPEAT
ReservationEntry.SETFILTER(ReservationEntry."Item No.","Sales Line"."No.");
IF TempSrno= '' THEN
TempSrno:= ReservationEntry."Serial No."
ELSE
TempSrno:=TempSrno + ',' + ReservationEntry."Serial No.";
UNTIL ReservationEntry.NEXT= 0;
Thanks,
Sandip.
0
Comments
-
Two different item number's can have the same serial number - so there is no error there.0
-
HI Girish,
My prob. is that it is carring out First items Sr. No. to Next item
See
Item I0066 ABC
L1,L2
ITEM I0064 XYZ
L1,01,02
L1 is carring out. I don't want that.
Sandip.0 -
girish.joshi wrote:Two different item number's can have the same serial number - so there is no error there.
Hi Girish,
My prob. is that Sr. No. of Previous Item is carring out to Next Item no.
You can see here L1 is printing again.
Item I0066 ABC
L1,L2
ITEM I0064 XYZ
L1,01,02
Sandip/0
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