GL Entries - Purchase Line Description

(0) Share

Report

Posted on by Community Member

Hi All ,

We have a requirement where we need to pull the line description entered during the purchase invoice in to the General Ledger Entries (Page 20).

Since the document number is a many-many on both table 17 & 123 and due to this we don't have a clue on how this could be achieved since we don't have mechanism to relate the line items as NAV 2016. we tried using the lookup method with a custom text field created on the table 17 but the if there are 5 line items on table 123 always the line 1 description of the purchase invoice is replicated on the rest of the line in table 17 and i believe this is due to the relationship mapping.

Really appreciate if anyone could anybody enlighten us on this .

Thanks ,

Uwais

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

In GL Entry there will always one entry for financial transactions but in value entry it will show all details

If you are doing report then it will easier to display there but if you are trying to add data in custom field of GL Entry then I think it is not possible line by line but yes if you can concatenate the description and record the data in custom field but what will happen when data is more as that field will also have limit of 1024 characters.

May be you need to customize the posting routine but this will create mess in financial transactions.

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

Hi

For this you need to check the codeunit 90, how the fields form Purchase line copied to the temporary table and to General Ledger entries.

this is common request which was discussed so many times, you can google it for code changes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Amol ,

Thanks for the quick reply . well in my case when there are 5 lines on a purchase invoice all the line are appearing as GL entries which is fine . But the issues is with the line description and though it is a very basic requirement and not sure why its not an option by default in NAV :(

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

Conceptually its one to one relationship between Purch. Inv. line table and G/L Entry. You are partially correct if there are other entries such as VAT.

To cater your requirement, you need to do a small customization. Check CopyFromGenJnlLine function of Table 17.

Especially this line -> Description := GenJnlLine.Description;

You need to write your logic according to this function.

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

By default, the Description to GL Entries is populated via Posting Description field in the header of the Purchase Order.

The reason why Line description from PO is not populated to GL Entries is because GL Entries can be summarized. That is, you will have many lines in PO but NAV might (or might not) generate only one G/L Entry for them. It depends on how they are different - e.g., if they use the same G/L account and same dimension value, they can be summarized; if they have different dimension values, they will be different.

The reason why it has been designed so by Microsoft is a save the space of the database - to post to G/L as less entries as possible.

So if you need to make NAV the 1-to-1 relationship between PO lines and G/L Entries, you need to do a small customization (the fact that you now have such relationship is just a co-incidence of your particular document posting).

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

This is the best forum thread that I have found regarding this issue. See the code changes suggested by Jonathan2708. The code of NAV has changed a little since that forum discussion, but the concept is the same.

forum.mibuso.com/.../g-l-description-to-contain-same-text-as-invoice-line

Was this reply helpful? Yes No