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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Open In Excel gives er...
Finance | Project Operations, Human Resources, ...
Answered

Open In Excel gives error on Customer Payment Journal

(0) ShareShare
ReportReport
Posted on by Sophia.r 235

I am experiencing an error for one of my clients on the Customer payment Journal (Accounts Receivable > Payments > Customer payment journal) If you select the Open in Microsoft > Open in Excel > Customer payment journal > Download. I get an error An error occurred during the report - Record for id - (AD84C2A4-4E8B....) not found. I have checked that no extensions exist for this Composite entity CustomerPaymentJournal or the Data entities it contains CustomerPaymentJournalLineEntity and CustomerPaymentJournalHeaderEntity. I have checked that other composite entities work such as SalesOrdersV3 and my Office App parameters have been setup. Any idea how I can debug this or somehow determine what is causing it. Note : there are new fields added to the tables within the above mentioned data Entities but no changes to the data enI am experiencing an error for one of my clients on the Customer payment Journal (Accounts Receivable > Payments > Customer payment journal)  If you select the Open in Microsoft > Open in Excel > Customer payment journal > Download.  I get an error  An error occurred during the report - Record for id - (AD84C2A4-4E8B....) not found. I have checked that no extensions exist for this Composite entity CustomerPaymentJournal or the Data entities it contains CustomerPaymentJournalLineEntity and CustomerPaymentJournalHeaderEntity.  I have checked that other composite entities work such as SalesOrdersV3 and my Office App parameters have been setup.  Any idea how I can debug this or somehow determine what is causing it.  Note : there are new fields added to the tables within the above mentioned data Entities but no changes to the data entities.

7041.Error.JPG

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Sophia,

    Can you review the text as some information seems to be overwritten or incomplete. Some sentences are duplicated in your question.

    Can you elaborate on the "new fields added"?

  • Sophia.r Profile Picture
    Sophia.r 235 on at

    (Please see my text again, I apologise)

    I am experiencing an error for one of my clients on the Customer payment Journal (Accounts Receivable > Payments > Customer payment journal),

    If you select the Open in Microsoft > Open in Excel > Customer payment journal > Download. I get an error "An error occurred during the export " - Record for id - (AD84C2A4-4E8B....) not found.

    I have checked that no extensions exist for this Composite entity CustomerPaymentJournal or the Data entities it contains CustomerPaymentJournalLineEntity and CustomerPaymentJournalHeaderEntity.

    I have checked that other composite entities work such as SalesOrdersV3 and that my Office App parameters have been setup.

    Any idea how I can debug this or somehow determine what is causing it.

    Note : there are new fields added to the tables within the above mentioned data Entities but no changes to the data entities.

    1.  1 new field added to LedgerJournalTable  but not included on data entities .

                 (KAPPaymentAdvise enum NoYes)

    2.  3 New fields added to LedgerjournalTrans but not included on data entities.

                 (PBFCustomerRef text field)

                 (KAPMarkInvoiceDummy   edt InvoiceId)

                 (AmountCurCreditDummy edt AmountCurCredit)

    Please help I can not see how to find what is causing this error

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

    Hi Sophia.r,

    Do you exprience this issue just with customer payment journal?

    Can you share more information about journal line type that you want to export to Excel?

  • Sophia.r Profile Picture
    Sophia.r 235 on at

    Hi Alireza

    I have tested a few others that also use Composite Data Entities and they seem to be working fine. It is only Customer payment journal.

    I get the error on the Accounts receivable> Payments>Customer payment journal >Open in Excel > Customer payment journal which is on Header level and if I view the lines.  The Journal Types are all Customer payment.

    What field are you referring to when you ask for more information about Journal line type?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

    Hi Sophia.r,

    I mean that if you have Account type other than customer and bank in the payment journal:

    pastedimage1650898718916v1.png

    Do you get the same error message while you open the Excel add in from journal lines?

    pastedimage1650898789565v2.png

  • Sophia.r Profile Picture
    Sophia.r 235 on at

    Customer-Payments.JPG

    Yes I get the same error when I open it from journal lines.  All my account types are Customer

  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

    Thanks for info.

    Please try to

    1- Delete usage data (Reset usage data)

    2- "Reload system templates" from Organization administration > Setup > Document template  and then check if there is template for "CustomerPaymentJournalTemplate" and then try again to import journal lines

    pastedimage1650900570349v1.png

  • Sophia.r Profile Picture
    Sophia.r 235 on at

    Thank you so much it worked.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans