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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Marked Transactions in...
Microsoft Dynamics AX (Archived)

Marked Transactions in the A/R Open transaction Editing

(0) ShareShare
ReportReport
Posted on by Julie Jansen 285

We accidentally setup a customer with a default of Cash in the payment terms on the customer card.  We then received a check from the customer, entered the check in the payment journal went to settlement and applied Invoices to this check and then posted the payment journal.  Now when we goto the Customer Account/Open Transaction Editing those invoices have the red hand in the marked field, but we cannot figure out how to unmark them.

 Does anyone know how we can unmark those transactions?

 

 

*This post is locked for comments

I have the same question (0)
  • Gabriel Challen Profile Picture
    Gabriel Challen 20 on at

    Delete related entry from the Spectrans table

  • Padmini Lilachand Profile Picture
    Padmini Lilachand 100 on at

    Is there a way of removing marked Transactions in the A/R Open transaction Editing via the Front end.I do not have access to the database.

     

    Thanks

  • user5555 Profile Picture
    user5555 7,437 on at

    Hi,

    I encountered similar problem (https://community.dynamics.com/forums/p/26765/44559.aspx#44559) and "Delete related entry from the Spectrans table". Do make backup of db of course. The spectrans table is an 'intermediate' table. You can look which records are referring to the transaction. Most likely the transaction has been interrupted?

     There is no front end. Ask somebody to help in SQL or use AOT.

    select * from spectrans to see what records are there. Must be just a few or somebody is processing transactions which then are stored here intermediately.

    delete * spectrans is the SQL statement you need.

    J.

  • user5555 Profile Picture
    user5555 7,437 on at
    Suggestion for Microsoft AX Development team.

     

  • Battery Boy Profile Picture
    Battery Boy 445 on at

    Have been struggling with a similar issue all day (on AX 4.0) - intercompany transactions were fully matched on one side, but had the red hand next to the transactions on the other side. Could find no way of unmarking these from the front end.

    Ran the following SQL: 

     

    select

     * into SPECTRANS_140110 from SPECTRANS --to copy table

    delete

     from SPECTRANS

    where

     DATAAREAID = 'xxx'

    which worked. Must be dodgy code somewhere. Something to do with year end?

     

  • user5555 Profile Picture
    user5555 7,437 on at

    Reported to the Microsoft Family: https://connect.microsoft.com/dynamicssuggestions/feedback/ViewFeedback.aspx?FeedbackID=525321

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,842 Super User 2026 Season 1 on at

    Hi,

    Yesterday we installed AX2009 SP1 Hotfix RU3. I found that a delete action was added on the LedgerJournalTrans. Now the SpecTrans is deleted according deleting ledger journal lines. Seems that the hanging SpecTrans records are resolved.

    regards,

    André

  • Community Member Profile Picture
    Community Member on at

    This can be done from the front end. All you need to do is trace the jounal number that was used in marking those transactions. After tracing, you now manually unmark the transactions. Trace by:

    General Ledger Module/Reports/Journals/Nonposted journal lines

    After the nonposted journal lines window comes up, click the select button.

    Select your criteria:

     Ledger journal table -Journal type = Customer payment

    Journal lines - Account type = Customer

    Journal lines - Account = Applicable customer account

    Click ok.

    These will bring out all non posted lines of the applicable customer, trace to find out which one the transaction has been marked on.

    you can also use the date on journal lines as criteria.

     

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 10

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dserp Profile Picture

dserp 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans