don't want to print the undo transaction record

yonhantdaenta89@hotmail.com

Hi all,

i am having trouble when i want to print the document. when it has the undo record, the system just print all of it , right ? do anyone know how to print only NON-undo lines?

for example
line 1 Qty 100
line 2 Qty -100
line 3 Qty 20

print only line 3.

many thanks,

yonhantdaenta89@hotmail.com

Hi all,

later on. i check on other document that has similar information.
i print on posted whse shipment and i check the undo shipment from posted sales shipment

thanks,

AntidotE

This is area of data gathering.
You may firstly generate records and then delete the ones which are opposite to each other or whatsoever.
It is much harder to maintain dataset filtering on printing stage.

concerning your example one of possible solutions should be with several dataitems:
headerrec
  integerrec

on header section, add code to fill temporary records, kind of this:
headerrec.onaftergetrecord

templinesrec.deleteall;
linesrec.setrange(docno,headerrec."no.");
if linesrec.findset then repeat
  currentsum += linesrec.qty;
  if currentsum = 0 then       //<==== kind of main check
    templinesrec.deleteall     //<==== result of check
  else begin
    templinesrec := linesrec;
    templinesrec.insert;
  end;
until linesrec.next=0;

integerrec.onpredataitem

integerrec.setrange(number,1,templinesrec.count)

integerrec.onaftergetrecord

if integerrec.number >1 then
  templinesrec.next
else
  templinesrec.findfirst;

yonhantdaenta89@hotmail.com

Hi all,

later on. i check on other document that has similar information.
i print on posted whse shipment and i check the undo shipment from posted sales shipment

thanks,

vijay_g

Document undo lines are already hide based on the check "Show Correction Lines" set false in the request page of standard report.

yonhantdaenta89@hotmail.com

Hi @vijay_g : i dont see that on request page, and what happen if that report don't have a request page. the report just provide reqfilterfield

thanks,

vijay_g

I can see this in standard report 208 Sales - Shipment and it works. still if you want to identify the records which has undo lines is marked in field Correction=True in shipment line table. hope this will help you.