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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / wondering about ax.Ret...
Finance | Project Operations, Human Resources, ...
Answered

wondering about ax.RetailTransactionSalesTrans Table

(0) ShareShare
ReportReport
Posted on by mohammed.mqi 2,050

in that table how did i know if product has been void transaction or suspend 

I have the same question (0)
  • Adhha Adnan Profile Picture
    Adhha Adnan 420 on at

    Hi Mohammed,

    From my understanding on your question. I believe you can view in transaction status column, where line status will be shown in the table unfortunately its only shown voided and posted status only.

    transstatus.png

  • Verified answer
    WillWU Profile Picture
    WillWU 22,363 on at

    Hi mohammed,

    There is a Enum field called 'transactionstatus' in the table RetailTransactionSalesTrans.

    pastedimage1583126182852v1.png

    pastedimage1583126283156v2.png

    And you can filter data by this field according to your requirements.(e.g. SELECT  * FROM ax.RetailTransactionSalesTrans where TRANSACTIONSTATUS=1; find the voided product).

    Hope this helps.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 613

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 455 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 292 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans