How to add Column in Posted Purchase Invoice list?

(0) Share

Report

Posted on by Lovisa LH

Hello all,

I'm brand new to this forum, and new to NAV so if I have posted in the wrong place, please let me know :-)

I want to add a column to my list of Posted Purchase invoices, so that I can pull out a list in Excel.

The field is Order No, that being where the associated purchase order number is filled (although I know that it isn't always populated).

I can see that it's possible to use Advanced Filter to filter by individual order number, but I would rather have the column Order No included in the list.

However I don't see it in the Choose Columns List.

Can anyone advise?

Thanking you in advance for reading,

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Then you should implement a page extention for the Posted sales invoice like this:

pageextension 50101 PostedSalesInvoiceExt extends "Posted Sales Invoices"

{

layout

{

addafter("No.")

{

field("Order No.";rec."Order No.")

{

ApplicationArea = all;

Visible = true;

}

}

}

}

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

And here is even one for the correct page - sorry:

pageextension 50101 PostedPurchaseExt extends "Posted Purchase Invoices"

{

layout

{

addafter("No.")

{

field("Order No."; rec."Order No.")

{

ApplicationArea = all;

Visible = true;

}

}

}

}

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, This is because the field is in the table, but not on the page.

Igne introduced the method of using Extension. If you have a development license, you can also add fields in the development environment.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

Dear Inge,

Thank you for the prompt response! Do you have some recommendation for a good place for a beginner to learn how to about use page extensions? There are so many bewildering resources available, it's hard to know where to start

Thank you in advance!

Was this reply helpful? Yes No
Verified answer

Lovisa LH 29 on at

Like (0)

Report

Thank you Zhu for the advice. I will look into it more with this point in mind. First to find out if we have a Developer licence or not!

Best,

Louise

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (1)

Report

Thank you Zhu! Once I found the right person to give me the required access, this was a very simple solution!

Was this reply helpful? Yes No