Hi all,
I want to fetch the description of second line and third line from sales invoice line table on Integer Header and Footer Section.
I have written the following code in OnPreSection of Header but its not working
Line2Data->Text
Line3Data->Text
SalesInvoiceLine.RESET;
SalesInvoiceLine.SETRANGE("Document No.","No.");
//SalesInvoiceLine.FINDFIRST;
IF(SalesInvoiceLine."Line No."=20000) THEN
Line2data:=SalesInvoiceLine.Description;
IF(SalesInvoiceLine."Line No."=30000) THEN
Line3Data:=SalesInvoiceLine.Description;
can anybody tell me the solution
Markandey Pandey
0
Comments
I don't know the reason why you do this, so i don't know is this the best solution, but about the code
You will never know if second line is 20000 and third is 30000 so maybe little correction:
What if the sales line has more than 1 item?
http://ssdynamics.co.in
that is what i have written, i want to fetch the second and third line description and its clear that there cannot be more than 3 lines also here second and third line is having only description.
People may ask why i am doing so, actually 2nd and 3rd line description is being used as comment in case the 1st line contains supplementry bill.
The problem is resolved