web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Customer Posted Paymen...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Customer Posted Payment Journal Report in ER in D365 F&O

(1) Share

Report

Report

Posted on by Raj Borad

1,578

Hi all,

I am creating a Customer Posted Payment Journal Report in ER in D365 F&O.

I got the data for the journal header and lines using the calculated fields of $LedgerJournalTable.

But I can't get the Customer Transactions from Ledger Trans, because of No nested relations from Ledger Heder to Ledger Trans to Cust Trans.

If there are any suggestions or details regarding the above query is appreciated.

Thank you,

Raj D Borad

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Sort by

Suggested answer

BillurSamdancioglu 21,343 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi As you mentioned there is no direct relation.

Also I would advise you to use only transaction tables for the critical reporting.

Was this reply helpful? Yes No

Raj Borad

1,578 on at

Like (0)

Report

Hi BillurSamdancioglu,

Can you please elaborate more in details?

I want this kind of report form ER.

Customer Posted Payment Journal
LedgerJournalTable		LedgerJournalTrans					CustTrans			Data sources
JournalNo	JournalName	Account	AccountName	Credit	Debit	Voucher	Invoice	CustTransDate	CustCurrencyCode

Where a Single Journal Header has a multiple Journal Lines and One Journal Lines have multiple Customer Transactions lines.

Was this reply helpful? Yes No

Suggested answer

Alireza Eshaghzadeh 15,225 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you use the "LedgerJournalTrans" table, it has a relation to customer transactions ($CustTrans> @.'>Relations'.CustTrans). You can also establish a relation to customer settlements.

FILTER(CustSettlement,

AND(CustSettlement.OffsetRecid=@.'$CustTrans'.RecId,

CustSettlement.OffsetCompany=@.'$CustTrans'.dataAreaId))

Was this reply helpful? Yes No
Raj Borad 1,578 on at

Like (0)

Report
Copy link

Link copied!

Hi,

We created the model and getting the proper records in XML format as per the requirement.

we are not able to fill the blank cell using the excel format.

We want to fill the blank cell with the value above it using format and want to import that format in ER.

We have created 3 lines in Name manager. for Header, Trans and Settlement.

Excel format mapping is:

Any suggestion regarding the issue is appreciated.

Thank you,

Raj D Borad

Was this reply helpful? Yes No
Alireza Eshaghzadeh 15,225 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,.
In Excel you need to define labels and values via Name manger.

For example:
Voucher_Label

Voucher_Value

In your case that you use fixed labels, you need to define Range for Lines and Settlement in the Excel file.

You can evaluate to redefine settlement under lines:

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

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

#1

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

#2

#3

Martin Dráb 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans