Search code examples
c#sdktransactionsdynamics-ax-2012

Retrieve item lines from suspended transactions, Microsoft Dynamics 2012 ax for POS RETAIL

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 enter image description here enter image description hereenter image description here

Solution

  • I'm not sure what you wanna fetch from the lines but you can start from the base tables, which are RETAILTRANSACTIONTABLE and RETAILTRANSACTIONSALESTRANS.

    Note that the RETAILTRANSACTIONTABLE is a multi purpose table, which stores every "transaction" generated in the POS.