How to Change the Description that Posts to GL ?

(1) Share

Report

Posted on by Muhammad Arif Maseed

768

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

All responses (7)

Answers (1)

Verified answer

Muhammad Arif Maseed 768 on at

Like (0)

Report

RE: How to Change the Description that Posts to GL ?

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

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to Change the Description that Posts to GL ?

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

Abdullah Satti 5 on at

Like (1)

Report

RE: How to Change the Description that Posts to GL ?

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to Change the Description that Posts to GL ?

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to Change the Description that Posts to GL ?

Hi Marco

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

Best regards

Martin Bønnelykke Jensen
Suggested answer

Vanessa Garcia on at

Like (0)

Report

RE: How to Change the Description that Posts to GL ?

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

Marco Mels on at

Like (0)

Report

RE: How to Change the Description that Posts to GL ?

Hello,

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

Thanks