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