web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Adding new field in GL tables and upating data while financial transactions posting

(0) ShareShare
ReportReport
Posted on by 3,012
Hi Team,
 
We have below requirement:
 
We need to add new field Customer posting layer (CustSpecificPostingLayer) in GeneralJournalEntry and GeneralJournalAccountEntry table for reporting purpose.
This needs to updated while posting all financial transactions such as sales invoice, purchase invoice, GL journals, fixed asset..etc.
We are using UDE for development purpose as our project using Power platform admin center.
 
I've modified LedgerVoucherObject and LedgerVoucheroTransObject classes and added x++ code. while debugging looks like data coming but it not reflecting in tables at the end. believe something here missing. 
Also written coc for insert,update methods of GeneralJournalEntry and GeneralJournalAccountEntry tables but debugger is not hitting.
 
Really appreciate if someone assist on this. explained requirement in detail below.
 
Detail explanation as below:
 
Custom field data mapping: Created new setup map which will have mapping of standard posting layer with customer specific posting layer. find below screenshot for example
 
  
We have aleady PostingLayer in  GeneralJournalEntry table.  While inserting data in same table we need to update the custom field CustSpecificPostingLayer with relevant data based on setup for both GeneralJournalEntry and GeneralJournalAccountEntry tables.
 
For example: If GeneralJournalEntry table having standard field 'Posting Layer (CurrentOperationTax is the Table field name)' has value customer layer1. then custom field 'CustSpecificPostingLayer' will have Cus_FR as per the setup form shown above in GeneralJournalEntry table.
Also for same in GeneralJournalAccountEntry table comparing data in GeneralJournalEntry table.
 
I will really appreciate on this if anyone came across this complex requirement and guide here on this.. Many thanks.
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 627

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 615 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans