Issue of sales register report

mkpjsr

In sales register report i want to display those records whose reference does not match with Sales Cr.Memo Header table. it means after cancellation its data should not visible into the sales register report.


I have used sales invoice header, sales invoice line and Sales Cr.Memo Header table

now i want to fetch record in this way where sales invoice header invoice no does not match with Sales Cr.Memo Header Applies-to Doc. No.

plz guide me how i will apply filter into the report

mohana_cse06

Try in Sales invoice Header OnAfterGetRecord Trigger

SalesCreditMemoHeader.RESET;
SalesCreditMemoHeader.SETRANGE("Applies-to Doc. Type",
SalesCreditMemoHeader."Applies-to Doc. Type"::Invoice);
SalesCreditMemoHeader.SETRANGE("Applies-to Doc. No.","Sales Invoice Header"."No.");
SalesCreditMemoHeader.SETRANGE("Return Order Type",
SalesCreditMemoHeader."Return Order Type"::"Sales Reversal");
IF SalesCreditMemoHeader.FINDFIRST THEN
   CurrReport.SKIP;