Issue regarding Purchase order..

Fakerules

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...

kine

It depends on what you need, if only quantities, than look into shipments, if you need amounts, look into invoices.

jannestig

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

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

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)