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