D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

10.0.6 - can't allocate payment against customer invoice

  • 1.  10.0.6 - can't allocate payment against customer invoice

    SILVER CONTRIBUTOR
    Posted Dec 22, 2019 05:26 PM

    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: 10.0.6 - can't allocate payment against customer invoice

    TOP CONTRIBUTOR
    Posted Dec 22, 2019 11:23 PM
    Ian,

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: 10.0.6 - can't allocate payment against customer invoice

    SILVER CONTRIBUTOR
    Posted Dec 22, 2019 11:43 PM
    Hi Ian,

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: 10.0.6 - can't allocate payment against customer invoice

    TOP CONTRIBUTOR
    Posted Dec 23, 2019 02:40 AM
    Ian, can you elaborate more of what/where you're experiencing?

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: 10.0.6 - can't allocate payment against customer invoice

    SILVER CONTRIBUTOR
    Posted Dec 23, 2019 03:59 AM

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: 10.0.6 - can't allocate payment against customer invoice

    SILVER CONTRIBUTOR
    Posted Dec 23, 2019 08:03 AM
    Hi Ian

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: 10.0.6 - can't allocate payment against customer invoice

    Posted Dec 23, 2019 08:12 AM

    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role