I use the export to Excel function in reports, and would like to export the purchase lines to excel with the purchase header number as a header for the column.
Is there a way to do this using the Excel Buffer? I am using NAV 2015 without a developer licence, so any coding can be report side only.
Many thanks for any help given.
Yes you can create a export to excel but you need to write a custom code for that.try to develop and post here if you need any suggestions.
In reply to uppala mahesh:
Thanks for your reply. I can do the export to excel, its the part where I need to have separate columns for each purchase order qty, with the purchase order number as the header. If I have 5 purchase orders for the same item, how would I get 5 columns with a different purchase order in each column, with the PO number as the header?
In reply to Adam Jones:
Which tables you are taking .. If you are taking Purchase Line then you first Sort table by OnPretrigger in ascending Order
by setting key as Document No. So Purchase Orders Will come in Order One After other For Respective Items So that you have loop Through the items On Rows So that to specify Value As Per Requirement and go For Another item which has same
Document No(i.e Purchase Order)...Then If Document No Changed Then Go For New Column......
If You Need Any Help let Us Know
Don't forget to the post(s) that solved your pro
In reply to Raja Venkat:
I'm using the item table, to get the list of items, with the second data item being purchase lines, with a link between the two on item no. I've put the key as the purchase order number
Do I then need to put in a page loop, or an array? I'm stuck at getting the different purchase orders into different columns?
I think you should take another Dataitem of Item so that later you have to search for Item to Print Oust Quantity...
i mean like this
Dataitem Item1 //
Dataitem Purchase Line//dont indent with above item
-->Dataitem Item2//indent with purchaseline
first print items in excel then save next open that sheet read sheet when found respective item Add Column with order no..
But there would be lots of orders ... think about it...
My standard way is regular one i.e
Item NO ------ Qty..
I'm still getting a list of purchase orders, rather than a separate order in each column.
I have narrowed the list to just 1 vendor, so I am not getting hundreds of records, only about 10 different purchase orders.
Hi Adam ,
Here's Solution For Your Requirement Click Here
If you need Any Help Let Me Know..
Thank you so much, this is excellent, many thanks