Hi
One of our user is trying to settle Free Text Invoice of certain customer but whenever he marks the transaction is gives error "This transaction has been marked for settlement by another user". After going through the posted question related to same issue doesn't solve the problem, even I have checked the Inquiry specification and their is no any transaction which is unposted attaching both screen shots. Please share your expert advices in this regard.
Dynamics 365 Version
VERSION INFORMATION
Hi Fahad,
Do you have any unposted customer payment journals open?
Also, have you tried replicating the issue on a more recent machine?
The latest version is currently 10.0.13 and you are a number of Updates back.
Would be great if you could try replicating the same issue on a more recent machine.
Best regards,
Ludwig
Thanks Ludwig for your response.
I have checked the journal but no journal related to the invoice. I have replicate the issue on staging which is same version but at there I can see the journal but not in production environment. If this is due to version the option for other invoices is working fine.
Best Regards
Hope you have checked in invoice specifications for Journals, Sales order, Invoices and Payment proposals by changing the dropdown list values in the view.
or You can also check from the Table browser "SpecTrans" table if there will be some lines that relate to your case.
If you are able to find your particular line in the table "SpecTrans", note down the RefRecID and RefTableID, then further working can be done to identify the transactions where the same is marked for settlement.
Regards,
Neeraj Kumar
I had a similar issue because of deleted payment proposals, for some reason invoices stayed marked if the payment journal was deleted. It was recommended to run a script to check if orphaned markings have existed. You can try to make a DB copy from PROD to sandbox and run a script to check if that the case.
But the issue itself was solved by creating a support request to MS, as they had to delete these orphaned markings from the backend.
select distinct(PaymProposalLine.JournalId) from SpecTrans ST (nolock) join SysTableIdView TableView (nolock) on ST.SpecTableId = TableView.Id join CustVendPaymProposalLine PaymProposalLine (nolock) on ST.SpecRecId = PaymProposalLine.RecId where TableView.Name = 'CustVendPaymProposalLine' and PaymProposalLine.JournalId not in (Select distinct(JournalNum) from LedgerJournalTable Payment (nolock) where Payment.DataAreaId = PaymProposalLine.DataAreaId and Payment.JournalNum = PaymProposalLine.JournalId)
Thanks Neeraj I have found five transactions in said table and those are exact the one causing issue, now what would be the resolution or how I can resolve issue. Apologies as I am new to this environment.
Thanks & Regards
No rows returned.
Can you please share the RefTabID that you got!
Yes Sure, Its 15300 for all the transactions.
Hi Fahad, table ID 15300 represents table "EFDocumentReceivedXmlViewAddInfo_BR" but this doesn't seems to be correct table.
Please check data in this table or if blank , please share the screenshot of the result that you got in SpecTrans, might be it helps.
Hi Neeraj,
I have checked the Table its empty, as you suggested I have attached the screenshot of the table.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,100
André Arnaud de Cal... 890 Super User 2025 Season 2
Sohaib Cheema 633 User Group Leader
