Dynamics Community Forum Thread Details (2024)

currently I am using this code for sending the particular indent detail to concern person. But it is displaying the all total indents like register form...I need only the current indent details:

Mail.CreateMessage('MKU Private Limited','nav@mku.com','manish.yadav@mku.com','Indent Statistics','',TRUE) ;
//Mail.AddCC('rakesh.gupta@mku.com');
//Mail.AddBCC('prachi.gupta@mku.com');

Mail.AppendBody('Dear Sir / Madam,');
Mail.AppendBody(' ');
Mail.AppendBody('Please Find The Indent details:');
Mail.AppendBody(' '); //new

Mail.AppendBody('<th>Indent No.</th>');
Mail.AppendBody('<th>Indent Date</th>');
Mail.AppendBody('<th>Item Description</th>');
Mail.AppendBody('<th>Quantity</th>');
Mail.AppendBody('<th>Unit</th>');
Mail.AppendBody('<th>Due Date</th>');
Mail.AppendBody('<th>Purpose</th>');
Mail.AppendBody('</tr>');

IF ReqLine.FINDFIRST THEN REPEAT
Mail.AppendBody('<tr>');
Mail.AppendBody('<td>'+FORMAT(ReqLine."Indent No.")+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine."Indent Date")+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine.Description)+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine.Quantity)+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine."Unit of Measure Code")+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine."Due Date")+'</td>');
Mail.AppendBody('<td>'+FORMAT(ReqLine.Purpose)+'</td>');
Mail.AppendBody('</tr>');
UNTIL(ReqLine.NEXT=0);

Mail.AppendBody('</table>');
Mail.AppendBody(' ');
Mail.AppendBody('<Regards>');
//Mail.AppendBody('<td>'+FORMAT(ReqLine."Created by ID")+'</td>');
Mail.AppendBody(' ');
Mail.AppendBody('<HR>');
Mail.Send;
MESSAGE('Mail Sent Successfully..!!!!');

Indent No.

Indent Date

Item Description

Quantity

Unit

Due Date

Purpose

IND-101-15-01-0002

07-06-16

Rubber Beading 8mm UN Blue Medium

1,000

PCS

01-01-15

For Ghana Order

IND-101-15-01-0003

07-06-16

Rubber Beading 8mm UN Blue Large

2,000

PCS

01-01-15

For Ghana Order

IND-101-15-01-0005

08-01-15

DuPont Kevlar Laminated Fabric STYLE AS400 S 235Gs

503.098

SQM

08-01-15

For GMBH

IND-101-15-01-0006

08-01-15

Newar Nylon 19mm Light Brown Khakhi Thick soft

MTR

08-01-15

For MOD

IND-101-15-01-0007

08-01-15

Newar Nylon 25mm Light Brown Khakhi Thin soft

290

MTR

08-01-15

For MOD

IND-101-15-01-0008

12-12-14

Fabric Woven Nylon Navy Blue 450 gsm PVC coated

150

SQM

08-01-15

For Sample

IND-101-15-01-0009

08-01-15

C.Box-52x34x26cm

200

PCS

08-01-15

For Stock

IND-101-15-01-0010

10-01-15

Plywood

PCS

10-01-15

PPO-101-DM-15-007

IND-101-15-01-0011

12-01-15

Hook Fastner 100mm Black

2,000

MTR

12-01-15

For OS.No.1415/106

IND-101-15-01-0012

12-01-15

Hook Fastner 50mm Black

2,000

MTR

12-01-15

For OS.No.1415/106

IND-101-15-01-0013

12-01-15

Loop Fastner 50mm Black

2,000

MTR

12-01-15

For OS.No.1415/106

IND-101-15-01-0014

12-01-15

Hook Fastner 25mm Black

18,000

MTR

12-01-15

For OS.No.1415/106

IND-101-15-01-0015

12-01-15

Loop Fastner 25mm Black

30,000

MTR

12-01-15

For OS.No.1415/106

IND-101-15-01-0016

12-01-15

C. Box-42x42x20cm

200

PCS

12-01-15

For Regular Order

IND-101-15-01-0017

12-01-15

C. Box-58x52x17cm

200

PCS

12-01-15

For Regular Order

IND-101-15-01-0018

12-01-15

AM 106 Resin

10,000

KGS

13-01-15

For Stock

IND-101-15-01-0019

12-01-15

HV 953 Hardner

10,000

KGS

13-01-15

For Stock

IND-101-15-01-0020

14-01-15

GP Resin RPL 100

1,000

KGS

14-01-15

For OS.No.1415/106

IND-101-15-01-0021

14-01-15

Owens Corning Fibre Glass Woven Roving 610Gsm

2,500

KGS

20-01-15

for OS.No.1415/106

IND-101-15-01-0022

14-01-15

Benzene Peroxide (BPO)

KGS

20-01-15

for OS.No.1415/106

IND-101-15-01-0023

14-01-15

DSM PE UD SB-117 208-224Gsm

200

MTR

25-01-15

Agat. Tarun ji Mail Dt.14.1.15

IND-101-15-01-0024

14-01-15

DSM PE UD HB-210 136Gsm

200

MTR

25-01-15

Agat. Tarun ji Mail Dt.14.1.15

IND-101-15-01-0025

14-01-15

DSM PE UD HB-212 131-141Gsm

400

MTR

25-01-15

Agat. Tarun ji Mail Dt.14.1.15

IND-101-15-01-0026

15-01-15

Branding Logo for Outer Cover

100,000

PCS

20-01-15

For OS.No.1415/106

IND-101-15-01-0027

15-01-15

Stretch Film 18"

300

KGS

20-05-14

For OS.No.1415/106

IND-101-15-01-0028

15-01-15

Aluminum Alloy Sheet 8ftX4ftX1mm (Checkered)

72.6

KGS

15-01-15

For OS.No.1415/007(DO)

IND-101-15-01-0029

15-01-15

Thermocol Sheet

PCS

15-01-15

For OS.No.1415/007(DO)

IND-101-15-01-0030

15-01-15

Ceramic Alo 98% SC 9.8mm 250x300mm Bitossi

PCS

25-01-15

For Upcoming Order

IND-101-15-01-0031

16-01-15

Plastic Transparent Sheet 1.47m Wide 1mm Thick

147

SQM

16-01-15

For OS.No.1415/106

IND-101-15-01-0032

17-01-15

Foam PU 1000 X 1000 X 1mm

SHEET

20-01-15

For R & D Purpose

IND-101-15-01-0033

17-01-15

Chemical Toluene

200

LTR

17-01-15

For Regular use

IND-101-15-01-0034

22-01-15

Dupont Aramid WV A802F 185±5Gsm WRT

1,520

SQM

31-01-15

For Minimum Stock

IND-101-15-01-0035

22-01-15

Leather Sheep Black

1,000

DM2

23-01-15

PPO-042 (Shree Lanka Tender)

IND-101-15-01-0036

21-01-15

DSM PE UD HB-56 226-240Gsm

960

SQM

30-01-15

For Minimum Stock

IND-101-15-01-0038

24-01-15

Packing Polythene Bag 30”x35”

500

KGS

27-01-15

For OS.No.1415/106

IND-101-15-01-0039

13-01-15

Newar Nylon Plain Weave 38mm Black Thick Soft

2,755

MTR

27-01-15

For OS.No.1415/106

IND-101-15-01-0040

27-01-15

C.Box 48x42x50 cm

100

PCS

31-01-15

For MOD Order

IND-101-15-01-0041

27-01-15

Plastic Transparent Sheet 1.47m Wide 1mm Thick

147

SQM

28-01-15

For OS.No.1415/106

IND-101-15-01-0042

29-01-15

Hook Fastner 100mm White

250

MTR

02-02-15

For OS.No.1415/009

IND-101-15-01-0043

29-01-15

Loop Fastner 100mm White

250

MTR

02-02-15

For OS.No.1415/009

IND-101-15-01-0044

29-01-15

C.Box-58X54X29cm

100

PCS

02-02-15

For OS.No.1415/009

IND-101-15-01-0045

29-01-15

Fabric Polyester White Binding Knitted 55mm

2,000

MTR

02-02-15

For OS.No.1415/009

IND-101-15-01-0046

31-01-15

DSM PE UD HB-212 131-141Gsm

400

MTR

10-02-15

For R & D Purpose

IND-101-15-01-0047

31-01-15

Fox Fury Shield Light with switch

PCS

10-02-15

for Minimum stock

IND-101-15-01-0048

31-01-15

Visor Shield level IIIA 270X120X22mm Curved

PCS

10-02-15

for Minimum stock

IND-101-15-01-0049

31-01-15

Visor Shield level III 270X120X39mm Flat

PCS

10-02-15

for Minimum stock

IND-101-15-01-0050

31-01-15

Visor Shield Level III 270x120x39mm Curved

PCS

10-02-15

for Minimum stock

IND-101-15-01-0051

31-01-15

C.Box-105X65XX20cm

PCS

05-02-15

For Sample Order

IND-101-15-01-0052

31-01-15

C.Box-85X50X52.5cm

PCS

05-02-15

For MOD Order

IND-101-15-01-0053

03-02-15

Chemical Toluene

400

LTR

05-02-15

PPO-101-EX-15-048

IND-101-15-02-0001

04-02-15

Ceramic Alo 98% MC top cut 8mm 298x248mm MOH-9

PCS

10-02-15

For R & D Purpose

IND-101-15-02-0002

04-02-15

Loop Fastner 25mm Black

4,000

MTR

04-02-15

For OS.1415/106

IND-101-15-02-0003

04-02-15

Chemical Toluene

200

LTR

05-02-15

for Regular Use

IND-101-15-02-0004

04-02-15

Rubber Adhesive

500

KGS

10-02-15

Regular Order Purpose

IND-101-15-02-0005

05-02-15

C.Box-58X54X29cm

325

PCS

05-02-15

For OS.No.1415/106

IND-101-15-02-0007

06-02-15

Newar Nylon Tubular Plain Weave 19mm Light green

500

MTR

10-02-15

For R & D Purpose

IND-101-15-02-0008

06-02-15

Fabric Polyester Brushed light Green 225 gsm

150

SQM

10-02-15

For R & D Purpose

IND-101-15-02-0009

06-02-15

Hook Fastener 100mm Light green

125

MTR

10-02-15

For R & D Purpose

IND-101-15-02-0010

06-02-15

Loop Fastener 100mm Light green

125

MTR

10-02-15

For R & D Purpose

IND-101-15-02-0011

06-02-15

Packing Polythene Bag 30”x35”

40.3

KGS

07-02-15

For OS.No.1415/106

IND-101-15-02-0012

09-02-15

Pro-System Aramid WR 2/2 Basket 400Gsm

5,000

SQM

20-02-15

For Chile Shiled Order

IND-101-15-02-0013

09-02-15

Shield Light Tir 6 LED Clear 50C03ZCR

180

SET

20-02-15

For Chile Shiled Order

IND-101-15-02-0014

09-02-15

Shield Light Tir 6 LED Red 50R03ZCR

180

SET

20-02-15

For Chile Shiled Order

IND-101-15-02-0015

09-02-15

Shrink Grip Shield

PCS

20-02-15

For Chile Shiled Order

IND-101-15-02-0016

09-02-15

Visor Shield Level IIIA 315X140x25mm Curved

180

PCS