10.0.6 – can’t allocate payment against customer invoice

We’re afflicted by an issue where we try to allocate a customer payment against an invoice, only to find it appears to being locked by another user. WE’Re told this is a well known issue with 10.0.6 but won’t be fixed until the cadence containing 10.0.8 (which for us is February). Microsoft have a script they can run on demand for us on our production instance, which operationally/usually takes two days to queue up for us.

The one thing that is bugging my senior management is wondering why we appear to be the only user out there who appears to have this problem – and wondering why (we have no customisations active afaik).

Is anyone else impaled on the same issue?

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Harwell Didcot
——————————

What leads your senior management to believe that you’re the only customer experiencing this problem?

I work for a Microsoft Partner. We see plenty of locked by user / system issues where we need to escalate to Microsoft’s ICM team for a PROD script.

Optimization advisor workspace sometimes shows the issue and resolves it, but most of the time we lean on Microsoft to fix.

——————————
Ian Gorman, PMP, MCSE
Senior Consultant
——————————
——————————————-

My management are querying it as it’s the second time we’ve had an issue that afflicts our ability to do processes fundamental to our overall business performance, but that our prime SI (Columbus Global) claim to haven’t seen anywhere else. It may be that it’s due to a lot of their base being on-prem and manufactring (we also appear to have been very early for them in getting RSAT and monthly cadences fired up, which we have run since April).

Hence good to know that others see the issues. Thank you. Would value knowing anyone else also seeing them 🙂

Ian W.

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Harwell Didcot
——————————
——————————————-

What versions are you seeing being impacted? 10.0.6 and what else?

Do you see those “marked” transactions showing up in both AP and AR modules?

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

Hi Zvika,

We’ve only experienced it on AP. Reply we got from Microsoft Premier Support (which is excellent btw) says:

Symptom:
User cannot settle customer transactions due to error message “This transaction has been marked for settlement by another user”

Cause:

BUG 338471 – SpecTrans marked for settlement by orphaned payment proposals in posted payment journal

Users have generated a payment proposal and did not transfer the payment proposal lines to the payment journal and posted the payment journal with different payments or deleted the journal. This essentially locks all the invoices for payment from other payment journals or settlement and the user has no way to recover these invoices.

Resolution:
Run Repair Scripts for deleting the invoice marking and the payment proposal lines for posted payment journals and for deleting payment proposals and invoice markings for payment journals that were orphaned to a deleted payment journal.

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Harwell Didcot
——————————
——————————————-

Having worked with Dynamics since AX2009 I can say this issue has always been in there. We used to know it as the red hand gang error as that is what used to display against the marked records.

We used to clear it manually through the AOT by clearing any open payment journals then deleting the SpecTrans table records but as access is now blocked for this it has to be done by MS scripts.

I guess beforehand MS had very little visibility of this issue as it as always cleared by partner support but now they have to deal with it they are releasing a full fix in 10.0.8.

The issue is caused by payment proposals being dropped either by webpage timeouts or users closing the page etc. and I have just had a customer with the exact same issue in 10.0.6.

Thanks and happy holidays to all!

Mark

——————————
Mark Bailey
Application Consultant
Annata
Portsmouth
——————————
——————————————-

Hi Ian

The issue is also known to Columbus, at least in Denmark, where I work as consultant :-). Both on AP and AR sides.

Glad to hear, that somehow in 10.0.8. that it will be possible to resolve the issue as user (and not just the promised optimization advisor, that doesn’t work). The settlement/SpecTrans issue has been open for many years in the different versions of AX/D365 and now, the tablebrowser option can’t be used any more.

——————————
Erik Pedersen
Columbus Global
Ballerup
——————————
——————————————-