Separate Purchase Orders Using Excel Buffer

Hello all.

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.

Regards

 

Adam.

  • HI Adam,

     

    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.

     

    Kind Regards,

    Mahesh U

  • In reply to uppala mahesh:

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

    Many thanks.

    Regards

    Adam.

  • In reply to Adam Jones:

    Hi Adam,

    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

  • In reply to Raja Venkat:

    Hi Raja,

    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?

    Many thanks

    Regards

    Adam

     

  • In reply to Adam Jones:

    HI Adam,

     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

    Order No:

                     Item NO  ------ Qty..

    Easy right...Wink

  • In reply to Raja Venkat:

    Hi Raja,

    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.

    Many thanks

    Regards

    Adam.

  • In reply to Adam Jones:

    Hi Adam ,

     Here's Solution For Your Requirement Click Here

     

    If you need Any Help Let Me Know..

  • In reply to Raja Venkat:

    Hi Raja

    Thank you so much, this is excellent, many thanks

    Regards

    Adam

Related