Finance | Project Operations, Human Resources, ...

Please help me solve this problem X++ IN (Customer payment journal)

(1) Share

Report

Posted on by CU03061204-0

Hello, I have a question for those with experience.

I have this body and I send it to receive a payment in the "Customer payment journal" screen. The problem I have is that when I send the invoice number "PayInvoice": "FTI-00000009", the system does not understand it even though it exists for the customer "US-001" ..... The system does not understand it unless I cross out the invoice number and write it again or select it from the lookup ..... I want help with a way for the system to understand the invoice number in order to make a correct settlement between the payment amount and the invoice amount

And this is when the payment reaches the screen.

So I understood that he did not understand the invoice.

It works when I delete the invoice number and select it from the lookup again.

Please help me solve this problem

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

CU03061204-0 8 on at

Like (0)

Report

Please help me solve this problem X++ IN (Customer payment journal)

Thank you Mr. "André Arnaud " for your advice.
I tried this code.

And it didn't work

And

If you have a code that solves this problem, I would be grateful to you.

This Code :

private void autoSettleInvoice(LedgerJournalId _journalNum, CustAccount _custAccount, InvoiceId _invoiceId, Counter _lineNum)
{
try
{
changecompany(curext())
{
// البحث عن حركة الدفعة مع forupdate
LedgerJournalTrans paymentTrans;
select forupdate paymentTrans
where paymentTrans.JournalNum == _journalNum
&& paymentTrans.AccountType == LedgerJournalACType::Cust;

if (paymentTrans.RecId)
{
ttsbegin;

// تحديث MarkedInvoice فقط
paymentTrans.MarkedInvoice = _invoiceId;
paymentTrans.Txt = strFmt("Payment for invoice %1", _invoiceId);
paymentTrans.update();

ttscommit;

info(strFmt("✅ Invoice %1 marked in payment journal %2", _invoiceId, _journalNum));

// إضافة تعليمات للمستخدم
info(strFmt("📝 Please open journal %1 and click 'Settle transactions' to complete settlement", _journalNum));
}
}
}
catch (Exception::Error)
{
warning(strFmt("Failed to mark invoice %1: %2", _invoiceId, infolog.text()));
}
}

private void auto...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Was this reply helpful? Yes No
Sohaib Cheema 48,482 User Group Leader on at

Like (0)

Report

Please help me solve this problem X++ IN (Customer payment journal)

It appears you are trying to settle the payment with an invoice using x++, plenty of code available online for that, which can be found by googling

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 298,698 Super User 2025 Season 2 on at

Like (0)

Report

Please help me solve this problem X++ IN (Customer payment journal)

Hi,

Can you tell us how you import the lines from your source file into Dynamics 365 Finance? Are you using a standard data entity, a custom import script or something different?

Note that when entering the value manually in the form, it will not only store the invoice number, but it will also mark transactions for settlement. You can check after the import if customer transactions are marked for settlement. You can do this by clicking on the menu item View marked transactions form the action bar above the lines grid. If the settlement exists, you can try to post it, otherwise review the import coding to add the markings for settlement.

Was this reply helpful? Yes No
André Arnaud de Cal... 298,698 Super User 2025 Season 2 on at

Like (0)

Report

Please help me solve this problem X++ IN (Customer payment journal)

Moved the question from the Dynamics 365 General to the Dynamics 365 Finance forum.

Was this reply helpful? Yes No