Purchase Report

Hi,
I want to take purchase report from Navision.
Can you please help me to take item-wise purchase report in the below format.


Item

Qty

Location

Vendor No.

Invoice No.

Posting Date







We need to take this report for re-export purpose. There are 1000 items for that we need to get complete purchase details from Navision.

Please help.

Thanks & Regards,
Ratna

create a new report and give dataitems as item,vendor…then goto sections and design ur report as u like.

But i am not developer. I am an end User. End user can create new report in Navision??

yes u can create.

Could you please tell me how to create such report?

Have a look at the Purchase Invoice Line . You will get all purchase data

As well as look at the Vendor/Item Purchases Report too.

It is available in Purchase–>Order Processing–> Reports

But i dont get here Purchase Invoice No. In the value field i have taken both document & external document no. still i dint get document No.( Invoice No.)

In which report have u taken document and external document no?

Vendor/Item Purchase is standard report , which shows purchases vendor wise item purchase. In this report grouping is done on Item no. so the document no./external document no. wont be shown.

Design a new report, if u want the details.

Thank you so much for all replies.

Can anybody tell me how to design report in Navision.

I need below details in Purchase report.

Item

Qty

Vendor No.

Invoice No.

Posting Date

Location

Please help.

Thanks & Regards,

Open new blank report → give dataitem as item , vendor ----> then goto sections Alt+v+N —> then add labels in header and textboxes in body…then goto properties of textbox and give source exp.

Sorry where do i find blank report in Navision?

Regards,

Ratna

Go to reports → Alt+N–>press ok and add dataitems.

How can one get the Invoice no. and posting date by just taking Vendor as dataItem.

I would rather suggest Item and Purch. Inv. Line as dataitems.

Also Ratna if you have access to cside development manuals for creating reports,please go through it for detail.

Go to Tools–>Object Designer

Click on Report → Click On New

Blank Report will open

Select Purch.Inv Line as DataItem

Go to Tool → Section

Click on Field Menu

Select the fields you want to show in Report

Save and complie the report by giving giving object id ,Name to it and ( Pressing Ctrl+S or File Menu → save)

Run the report and see the output

Thats it …

Thanks for all replies.

We dont have permission to create new rule in Navision. It is blocked.

But i took the report following below steps,

Item card–Item–Entries–Value Entry

Once again thanks for all replies.

Ratna

Thanks for all replies.

We dont have permission to create new rule in Navision. It is blocked.

But i took the report following below steps,

Item card–Item–Entries–Value Entry

Once again thanks for all replies.

Ratna