How to Change the Description that Posts to GL ?

(1) Share

Report

Posted on by Muhammad Arif Maseed

782

Hello, I am trying to Post purchase invoice but i want to post the actual line description to G/L Entry instead of "Posting Description"?

Nav 2018

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

In the communities we did discuss cross reference setup. Maybe that is helpful for you as well?

Thanks

Was this reply helpful? Yes No
Suggested answer

Vanessa Garcia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello! :-)

you have 2 options:

a) you can change the code behind here:

to what you want to write always as Posting Description automatically instead of the current standard code (Document type + No.)

b) You can edit the Page 51 to show Posting Description and change it there (manual every time)

I hope it helps :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Marco

What are "cross reference setup" and where are "the communities"?

Best regards

Martin Bønnelykke Jensen

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I think my users have the same issue as @Muhammad Arif

We need the Purchase Invoice Line Description to dictate what the Posting Description will be.

Today I posted an invoice from "BridgeCompany", we had crossed their bridge twice this month. And I had entered these lines on the Purchase Invoice:

G/L Account: "3000 Sales Department, travel costs" | Description: "Visited Customer ABC"

G/L Account: "80000 Private costs, to be deducted in salary" | Description: "Employee MBJ, private bridge expense"

Now when i look at the G/L Entries on these accounts i see 2 entries, with the Description: "BridgeCompany", and that is not useful to us, we need meaningful Descriptions.

Do you know a fix for this?

Thank you.

- Martin Bønnelykke Jensen

Was this reply helpful? Yes No
Suggested answer

Abdullah Satti 5 on at

Like (1)

Report
Copy link

Link copied!

Hi,

While Posting Purchase Invoice the data is inserted in Table 49 "Invoice Post. Buffer" temporary. You have to create two fields "Posting Debscription" and "Line No." to save the Purchase Line and Description field.Add "Line No." to the primary key.

While Posting Purchase Invoice Code unit 90. It prepares the Purchase invoice post buffer where you can save the purchase line description in custom field.

Subscribe the "OnAfterInvPostBufferPreparePurchase" the event for table 49 and assign the purchase line description to temperary buffer newly created field.

You have to subscribe another event "OnBeforePostInvPostBuffer" for codeunit 90 and then assign the temporaryfield "Posting Description" to GenJnlLine description.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Muhammad,

Adding to other replies... In new releases of BC, you can use a Posting Description or Line Description. For NAV, you will need to contact your Partner to add some logic to replace the Description posted to the General Ledger Entries table with the Line Description.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Verified answer

Muhammad Arif Maseed 782 on at

Like (0)

Report
Copy link

Link copied!

Hi Steven,

Thank you for your response, I already implemented the same. I did reverse enginerring then i found that there is posting description available and that worked for me.

Was this reply helpful? Yes No