Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

(1) Share

Report

Posted on by UserRecord

Hello!

I have a few custom fields added in PO & SO forms.I require these fields to flow to General Ledger entries as well when we post directly from SO or PO page.

Any suggestion on any events that can be subscribed to achieve this?

Thank you in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Ram Pranav 50 on at

Like (0)

Report

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Hi,

You need to create custom fields in both "Gen. Journal Line" and "G/L Entry" table to accommodate your custom fields from "Sales Header" or "Purchase Header" table.

Subscribe to the event OnAfterCopyGenJnlLineFromSalesHeader / OnAfterCopyGenJnlLineFromPurchHeader from the table "Gen. Journal Line" to assign the values of custom fields from "Sales Header" or "Purchase Header" to the "Gen. Journal Line" custom fields.

Subscribe to the event OnAfterCopyGLEntryFromGenJnlLine from the table "G/L Entry" to assign the values of custom fields from "Gen. Journal Line" to "G/L Entry" custom fields.

Regards,

Ram Pranav.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,855 Most Valuable Professional on at

Like (0)

Report

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Hello maybe this can help

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Gen. Jnl.-Post Line", 'OnAfterInsertGLEntry', '', false, false)]
local procedure OnAfterInsertGLEntry(var Sender: Codeunit "Gen. Jnl.-Post Line"; GLEntry: Record "G/L Entry"; GenJnlLine: Record "Gen. Journal Line"; TempGLEntryBuf: Record "G/L Entry" temporary; CalcAddCurrResiduals: Boolean);
begin
end;

#msdyn365bc - Flow Custom Fields from Sales Header to Customer Ledger?

https://www.youtube.com/watch?v=lTCoIYinldI

https://forum.mibuso.com/discussion/76306/flowing-custom-field-from-sales-documents-to-value-entries

Was this reply helpful? Yes No
UserRecord 54 on at

Like (0)

Report

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Hi Ram,

I tried you using your suggestion, however, it errors out saying There is no entry in Gen. Journal Line.

Was this reply helpful? Yes No
Ram Pranav 50 on at

Like (0)

Report

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

It would be helpful to analyse if you share your code.

Regards,

Ram Pranav.

Was this reply helpful? Yes No
UserRecord 54 on at

Like (0)

Report

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Hello!

The events OnAfterCopyGenJnlLineFromSalesHeader / OnAfterCopyGenJnlLineFromPurchHeader work in case of Invoice. However, if I am trying select Receive option they are not trigerred.

Can suggestions on any other events?

Thank you in advance.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Customs field to flow from Sales and Purchase order to General Ledger Entries when posting

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates