Customer Orders, shipments and invoices in one report

ismailthesacrificer1@gmail.com
ismailthesacrificer1@gmail.com Member Posts: 76
in NAV Three Tier
It should show Current Month Bookings, Current Month Shipments, Current Month Invoices against the Customer.
I created a new report by taking Customer table as source and written the code to show current month as
monthStart := CALCDATE('<-CM>',TODAY);
monthEnd:= CALCDATE('<CM>',TODAY);
SalesHeaderRec.SETRANGE("Order Date",monthStartDt,monthEnd);
SalesLineRec.SETRANGE("Shipment Date",monthStartDt,monthEnd);
SalesLineRec.SETRANGE("Posting Date",monthStartDt,monthEnd);
it was showing empty on it.
Can any one please suggest me regarding this issue.
Thanks in Advance.

Answers

  • lubost
    lubost Member Posts: 633
    - bookings should be filtered as you wrote (use FINDSET or nested SalesHeaderRec dataitem)
    - shipments filtering is much more better and efficient in T_110
    - invoices filtering is much more better and efficient in T_112/T_114
  • ismailthesacrificer1@gmail.com
    ismailthesacrificer1@gmail.com Member Posts: 76
    If Print Detail is checked then Report should show the Orders, Shipments and Invoice lines against that particular customer.

Categories