How to settle invoices which are already marked in AR Payment Journal

(0) Share

Report

Posted on by Community Member

One of my customer has 4 open invoices. But 3 of them are marked. So I can't settle them with a new payment. I found the Journal which settled those 3 invoices (was a mistake). But I can't edit this Journal since it's already posted. What are the steps I need to do to unmark those 3 invoices? Appreciated for any help.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

André Arnaud de Cal... 304,348 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna,

Are those invoices still marked for settlement or already settled? Marked transactions pending for settlement in a posted journal is usually not possible. So I assume the transactions are already settled. You can try to use the Transaction reversal functionality to reverse the wrong journal. You can also use the 'Edit closed transactions' functionality from the vendor list page or details form to unsettle the invoices.

Was this reply helpful? Yes No
Suggested answer

PA-22040759-0 6,194 on at

Like (0)

Report
Copy link

Link copied!

From the customer list page, you can click "Settle" / "Closed transaction editing". In the form that opens you find and mark the transactions in question and click "Reverse" to cancel the settlement and the transactions will now show up again as open transactions.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks André and Palle!

To answer André's question. Those transactions are not settled, and the Payment was Canceled when the AR person realized he settle it against the wrong invoices. That's why I can't do the reverse since the payment voucher is not showing in the "Closed transaction editing"

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

You need to reverse the 3 invoices which got settled by mistake

I suggest you to review following link, how to reverse the settlement

https://technet.microsoft.com/en-us/library/aa549970.aspx

Please verify and update us if this helps you

Was this reply helpful? Yes No
André Arnaud de Cal... 304,348 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Anna,

The situation where you say initial the journal is posted and the transactions are still marked sounds odd. Now you say the payment was cancelled. Please check if the journal is posted or not.

If the journal is NOT posted, you can delete the journal lines and the invoices should become unmarked.

Otherwise there might be an issue in your environment. Note that the table SpecTrans contains the references for marking the settlements before posting. Eventually you can find the records related to the three invoices and delete these records.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi André,

Now I'm thinking the Posted Journal is probably not related to those 3 invoices. In this journal, in the invoice column there is an ' * '. So I thought maybe that's the reason marked all the invoices.

I got the solution by going to this Customer > open transactions > inquiry>Specifications. It appears all linked document (invoices), click to open the invoice then received the a message indicating transaction was marked and give the option if I want to remove the marked transactions. I clicked yes. That's how the invoices are all unmarked.

Thanks for your help.

Anna

Was this reply helpful? Yes No
André Arnaud de Cal... 304,348 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna,

In this case you can mark your own answer. Then the thread will get the status answered.

Was this reply helpful? Yes No