Transaction Settled but still open.

(0) Share

Report

Posted on by B.W

505

Good day experts.

i have a transaction that has been fully settled and has a zero balance, however the transaction still show as open in customer transactions as well as in settle open transactions form. i can see the transaction in the custtrans table seems to be offset with the transactions in custsettlement table. however there is no values in 'LastSettleAccountNum', 'LastSettleDate', 'LastSettleVoucher','Closed'

is there any way to mark these transaction to close it and remove it from settle open transactions?

i have found this question but there was no answer.

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/124753/settle-open-transactions-showing-cleared-invoices/266761#266761

any help would be appreciated.

I have the same question (0)

All responses (6)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi B.A.,

I have the same question that was asked in the old thread for you: What is your AX2012 version?

In addition, do you know if some system modifications have been made for settling open customer transactions?

Best regards,

Ludwig

Was this reply helpful? Yes No
B.W 505 on at

Like (0)

Report

Hi Ludwig.

thank you for your reply.

apologies, have i asked this previously?

Version: AX 2012 R2.

there are no modifications as far as i know of.

it looks like the transaction was settled but then a credit was processed incorrectly and reversed.

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

You could I suppose reverse all transactions and start again.

Use the Closed transaction editing in several currencies form to reverse settlements for customers. You might do this if the wrong date or settlement amount was used. When you reverse a settlement, all transaction distributions that were involved in settling an invoice with a payment are reversed, such as general ledger postings, exchange rate gains or losses, penny differences, and cash discount transactions.

The original invoice and payment transactions are not reversed automatically when you reverse settlements.The transaction reversal process reverses the original transaction and all related transactions that were created when the original transaction was posted. Before you reverse a transaction for the first time, select a number sequence for the Transaction reversal and Trace number references in the Number sequences area of the General ledger parameters form.

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/reverse-a-transaction

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/reverse-settlements

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi B.A.

There are a number of related issues posted on LCS, such as the following one:

KB 3077626The Customer Invoice Transactions report still shows closed or settled transactions even when Invoice type is set to Open

As you are operating on a very old version, I would recommend that you upgrade to a newer version where those fixed are already applied.

An alternative is of course asking a developer having a look at this issue and double check whether the hotfixes on LCS overcome the issue. If things are not that urgent and if you can replicate the issue in a different system / environment then you can alternatively open a support request with MS to get some help for getting this fixed.

Best regards,

Ludwig

Was this reply helpful? Yes No
real_ashwin 1,225 on at

Like (0)

Report

Since you are saying you can see transaction in the CustSettlement table that would mean that some partial or full settlement has been recorded. Check the totals first. Then try like magic said going into the closed transaction editing on the customer master and un mark these settlements and then check balance and re do the settlement. See if that works.

Was this reply helpful? Yes No
Verified answer

B.W 505 on at

Like (0)

Report

Good day.

Apologies for the late reply.

thank you to all for your advise.

we have managed to sort this issue out by writing a job to link the settlement transaction back to the custtrans record and close the open transaction. it was fully setting and did indeed have a zero balance.

Was this reply helpful? Yes No