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

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Adding new column to General Ledger entries list

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
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Adding new column to General Ledger entries list

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.
Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Adding new column to General Ledger entries list

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.