Announcements
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
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
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.
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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156