Sales Order query help

[former_member224264]

Greetings of the day experts,

In the RDR1 or RDR2, can we identify the line status as Manually Closed or Cancelled?

Need a Sales Order report with ORDR, RDR1 and OCSN and tried joining them.  The fetched results are in multiple lines, if one line in order then query shows three lines.

Can anyone help?

Regards.

[Former Member]

Hi,

Could you post your query so that we can revise it to eliminate multiple lines.

Thanks,

Gordon

[former_member184146]

Hi,

in RDR1 table you can find line status in O , C i.e. Open and Closed/cancelled  and  RDR2 table is tax table linked with RDR1 with docentry .

please post your query here to check .

--Manish