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 / Microsoft Dynamics AX (Archived) / Retrieve item lines fr...
Microsoft Dynamics AX (Archived)

Retrieve item lines from suspended transactions, POS RETAIL

(1) ShareShare
ReportReport
Posted on by saad nadir 282

Hello, i'm under Microsoft Dynamics AX for Retail POS and i'm facing an issue.

I'm wokring on a form that retrieive the suspended transactions filtred by the customer that i put in the BlankOperations project.

I was able to get the list of suspended transactions by customer but i can not find a way to retrieive the lines of each transaction.

After somes researchs i discover that the lines are stored in a Hexadecimal format in the database under the TRANSACTIONDATA field of the table SALESTRANSACTION.

When i convert the TRANSACTIONDATA  to string i get a XML String .

Now i'm asking if is there a way to retrieve the transaction lines based on the sdk retail. 

i put a screen so you can more understand what i am trying to do.

best regards

3554.recall.png

.transdata.png

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Roshani Profile Picture
    Roshani 20 on at

    Hi Saad,

    Plz. check out forum it seems discussing a query relevant to yours.  (stackoverflow.com/.../retrieve-item-lines-from-suspended-transactions-microsoft-dynamics-2012-ax-for)

  • Verified answer
    saad nadir Profile Picture
    saad nadir 282 on at

    it was my post that i written it before, thanks for the reply

  • mohammed.mqi Profile Picture
    mohammed.mqi 2,050 on at

    how did you retrieve suspended transactions

  • Verified answer
    saad nadir Profile Picture
    saad nadir 282 on at

    The RetailSuspendedTransactions table holds the suspended transactions information.

    Reference : msdn.microsoft.com/.../retailsuspendedtransactions.aspx

  • mohammed.mqi Profile Picture
    mohammed.mqi 2,050 on at

    thanks for replay

    but this table shown empty on db

    so i created new form for suspended transactions on bankoperation so i used this table SALESTRANSACTION

    but i can't retrieve to pos  (here my post)

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 24

#2
Michel ROY Profile Picture

Michel ROY 14

#3
Jagadabi Profile Picture

Jagadabi 6

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans