web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / RESOLVED: How to s...
Microsoft Dynamics AX (Archived)

RESOLVED: How to settle transactions which are marked?

(2) ShareShare
ReportReport
Posted on by user5555 7,437

Hi,

If I open transaction editing, I see a voucher line with -50 and one with 50. So I want to settle both so that those two voucher lines are updated and not visible in the 'open transactions' report anymore.

For some reason I cannot setlle them. The 'red hand' is on top of one of them. How to see what is locking this transaction? And how to settle it?

Any help appreciated.

J.

*This post is locked for comments

I have the same question (0)
  • user5555 Profile Picture
    user5555 7,437 on at
    Friendly bump

     

  • user5555 Profile Picture
    user5555 7,437 on at

    If I mark, I receive next error: "This transaction has been marked for settlement by another user."

    ==> How can I see that and/or reset the pending marking operations?

    Any help appreciated.

    J.

  • user5555 Profile Picture
    user5555 7,437 on at
    I looked up in the code and see that a lookup is done on record existance in table: select * from SPECTRANS

    --> Can I just remove all the records there after I stop AOS and nobody is logged in?

    I tried to login to other users that I know and could remove existing transactions from 1 user only. I do not know where the tables refere to since the RelationShip model is not reflected in the diagrams of AX.

     --> Relationships are documented here: http://msdn.microsoft.com/en-us/library/aa608491.aspx (why no diagrams in which you can look them up through sql diagrams?) 

    J.
  • Community Member Profile Picture
    Community Member on at
    Did you find a solution for this? I'm getting the same problem.
  • user5555 Profile Picture
    user5555 7,437 on at
    no, did check one relation but found more of this data in correct. Also for return orders. If i find anything i will post here. Maybe we can team up.
  • spot Profile Picture
    spot 2,515 on at

    Hi

    yoiu have to go to the journal where it is marked and unmark it then only it will availabple for payment in another journal , this is a way of holding payments .

     

    Regards

     

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    How can I see easily which journal is holding/ marking those transactions? I see from the datamodel description which tables are involved. The relationships do not allow to easily see which records/ functionality is involved.

     If there would be a report or overview of users holding transactions that would be very helpful.

    J.

  • Community Member Profile Picture
    Community Member on at

     In my case, nobody had the journal open and had it marked, but AX thought someone did. That was my first guess too.

     I  found what it was in my case, the temporary transaction got hung in the SpecTrans table.  So I removed it from there, and then it worked.  So, I went to the AOT, Data Dictionary, Tables, SpecTrans.  Right click on SpecTrans and choose Add-ins, then Table Browser.  here's where the line will be.  You might have to do some searching to find the right one, but in my case it was the only one there.  So I deleted it, and then was able to mark the transaction for settlement.

    Ryan

  • user5555 Profile Picture
    user5555 7,437 on at

    Removing the records from this table or through the AOT does not have a side-effect ? So just remove them? No need to find to which tables the spectrans is related? It is just a table to 'memorize' temporarily which transactions have been marked? In case of an unexpected system failure/ shutdown, this table stays filled although it should have been emptied?

  • Community Member Profile Picture
    Community Member on at

     I would do a quick backup of your DB before doing this...I was thinking as soon as I deleted the transaction that I should've done this.  Anyway, it's just a temporary transaction, so it shouldn't have any side effects.  I'm not sure what would happen in a system failure/shutdown, to be honest.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans