hi
how can we list the outstanding orders and posted orders in one report
thanks
hi
how can we list the outstanding orders and posted orders in one report
thanks
Hi Suman,
Create a report that first runs through Purchase Header Table (ID = 38), and then Purch. Inv. Header (ID = 122).
Apply the filters needed, and there You go.
hi sander,
ya i tried that one but could u plz tell me that what filter shall i use for that
That depends on what You want to have displayed in the report.
(Could be “Vendor No.” = xxxxxx, to have all orders regarding a specific vendor shown, or “Sales Peron/Purchaser” = xxxxx, to have all orders created by a specific user displayed, or any combo)
I would make the report so, that the user only can apply filters to e.g. table 38 when running the report.
Then on OnPreReport-trigger, copy the applied filters onto table 122
hi sander
the requerment is i need the outstanding orders and posted ones also
in the report i want the order No. and vendor name and Amount for that Order thats it
You need to put filter on table 38: “Document Type” := “Document Type”::Order;
If You put no more filters, You wil have a report that prints each and every purchase order in Nav, and each and every Purchase Invoice in the system.
Over time, the output of the report will increase.
If You want the report to just show Orders (both open and posted) for 1 specific Vendor, You will have to filter on this as well.
(Like I wrote earlier.)
This is designed in the Section-layout
But those values should be directly optainable.