List purchase oder

Business Central/NAV User Forum
1

hi

how can we list the outstanding orders and posted orders in one report

thanks

2

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.

3

hi sander,

ya i tried that one but could u plz tell me that what filter shall i use for that

4

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

5

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

6

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.