Finance | Project Operations, Human Resources, ...

(This transaction has been marked for settlement by Customer Payment XX-000000765 in company xxx.)

(1) Share

Report

Posted on by Community member

Hi ,

The REQUIREMENT is to import the customer payment journal lines.

Getting Error while importing customer payment journal lines with more than 1 lines having same invoice id and diff amount .

I am trying to import the data like below using the custom data entity (exact copy of standard customer payment journal lines entity ) with little changes like having extra fields like sales id.

CUSTACCOUNT	INVOICETOBEMARKED	CUSTPAYMMODE	CREDIT	SalesId
ABC	INV001	CC	1000	s001
ABC	INV001	CASH	2000	s001

But getting this error in DMF for each lines This transaction has been marked for settlement by Customer Payment XX-0(00000765 in company xxx.)

Is it possible to import such journal lines and post it successfully ?

I am able to make such journal line manually using the settlement transactions menu and editing the settle amount for each payment journal line.

please suggest the X++ code to import the journal lines correctly .

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Please explain how you are getting the DMF import to do customer payment settlements? To answer your question about how to do the settlements in code, have a look at CreditCardPaymentJournal class, settlePayment method as an example. This code needs to be adapted to handle multiple payments instead of just a single payment.

Was this reply helpful? Yes No
Poonam Verma 74 on at

Like (1)

Report

See if this resolves the issue: try running the Marked Transaction Detail under Periodic Tasks in the Accounts Receivable module by customer account. If the invoice is selected for settlement in a different journal, you should be able to unmark the transaction from there.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,854 Most Valuable Professional on at

Like (0)

Report

You can not have two lines with the same invoice number.

You can not do manually and by DMF.

It is not possible to do with X++,

You may first post one line with a journal, And then post in another journal.

Was this reply helpful? Yes No