Small and medium business | Business Central, N...

Adding new column to General Ledger entries list

(0) Share

Report

Posted on by iamcharith

Can anyone tell me how to add an existing field of 'Purchase invoices' to the list of general ledger entries?

I want to filter data using that particular column.

For example - I have a field called 'Reason code' in the 'General tab' of the purchase invoice where I put the related expense type (Ex. travel/training). Now I want to filter the general ledger entries that are posted with the travel. But the reason code is not available in the list of 'choose columns' in the general ledger entries. How can I add this as a column into the general ledger entries list?

Thank you

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Hi,

For this do small customization.

Create one field in Gen. Journal Line and G/L Entry and write code in Purchase Post codeunit and G/L Entry Table --> Function name is CopyGlentryfromGenjournal

Regards

Amit Sharma

www.erpconsultors.com

press yes if info is useful.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Remember that you can put filter on a field even though it is not visible in the list you are looking at as long as the field is present on the source table.

If the field is in the table but not in the page you are looking at, you need a developer to add that field to your page.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I checked the NAV 2017.

This field exists in the G/L Entry (17) table, so you just need to add it on the page in Development Environment. (This requires a development license)

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No