How can I make a Vendor's purchase report?

moulayzaki

Hi all,

I am a newbie in the Navision World.

In fact I would make a report of purchases by vendor.

My first try was to do a report by two tables ( Vendor and Purchase Line ) and calculate the sum of amount line grouped by Vendor.

The complication was to make the sum weekly and monthly and yearly in the same report.

How can I make this.

Thanks for your help..

mohana_cse06

Did you Check base report 309 ?

moulayzaki

Yes I check it, but the data was not correct in my report.

mohana_cse06

Check the logic of report 309 and correct your logic..

moulayzaki

The logic in report 309 is based just on the table Vendor.
And the numbers there are different from what I need.

What I need is included in the Table "Purchase Line" especially the field "Line Amount".

Thanks for your help.

mohana_cse06

Check CalculateAmtOfPurchaseLCY function..

309 report used Vendor Ledger Entry to calculate the Total Amount..

Similarly you need to use Purchase Line in place of Vendor Ledger Entry

Savatage

moulayzaki wrote:

The complication was to make the sum weekly and monthly and yearly in the same report.

ONce you post your po - the data moves to the Purch. Inv. Line table

Puchase Line only shows you unposted po's

Best to use item ledger entry & look under entry type "Purchase"

YOu can modify this report..I've done it for vendors instead of customers.
viewtopic.php?f=5&t=10082

DenSter

First you say:

moulayzaki wrote:

I would make a report of purchases by vendor.

And then you say:

moulayzaki wrote:

What I need is included in the Table "Purchase Line" especially the field "Line Amount".

These two things do not compute. What is in the Purchase Line table has not been purchased yet, at least not when your system has been implemented properly. This table is used for transactions that have not been posted yet. At the very most, it contains received items, but it should not have affected your accounts payable yet.

If you need an accurate picture of historical purchases, the Purchase Line table is NOT where you should be looking at.

I wouldn't even be looking at purchase invoice line table either, because you can delete posted invoices. The most accurate numbers come from the sub ledgers.

moulayzaki

Thank you all for your responses.

In fact what I want to know is how much we ordered in a given period, whether is invoiced or not.

Which table should I use?

Kind Regards.