Issue regarding Purchase order..

Fakerules
Fakerules Member Posts: 50
edited 2009-11-24 in NAV/Navision Classic Client
I need to make a report that summarize the puchase order of the last three months.

Which tabkes do I Need to refer to:

1.) Purchase header
2.) Purchase line

What about the orders that are partially of fully receivced where do they go..??

Purch. Rcpt. Header
Purch. Rcpt. Line
or any other table that I have look for the related issue..

Please help...

Comments

  • kine
    kine Member Posts: 12,562
    It depends on what you need, if only quantities, than look into shipments, if you need amounts, look into invoices.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • jannestig
    jannestig Member Posts: 1,000
    edited 2009-11-23
    What information is it you want to see ?

    Purchases by Vendor, Items etc or just costs?

    There is purchases statistics report and the Vendor/item report already.

    :oops: repeated kine, I hope i am not becoming a parrot like below
  • DevendraSharma
    DevendraSharma Member Posts: 23
    kine wrote:
    It depends on what you need, if only quantities, than look into shipments, if you need amounts, look into invoices.

    What information is it you want to need ?

    If you want to need Only quantities, then there is already two fields Quentity received And quentity to recive

    u can use these field in your report


    Thank's !!!

    Devendra
  • Fakerules
    Fakerules Member Posts: 50
    DevendraSharma wrote:
    kine wrote:
    It depends on what you need, if only quantities, than look into shipments, if you need amounts, look into invoices.

    What information is it you want to need ?

    If you want to need Only quantities, then there is already two fields Quentity received And quentity to recive

    u can use these field in your report


    Thank's !!!

    Devendra

    I want the net amount of each item from the purchase line (after calculating tax, discounts etc)

Categories