Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Retail store transaction posting status showing as posted but there is no sales order or transaction showing

(0) ShareShare
ReportReport
Posted on by 59

Dear Members,

I have an issue on retail store transaction, Posting status showing as posted but there is no any sales order or transaction showing on that particular day. Highly appreciated your suggestions   

2541.png

5810.png

Thank you

  • Suggested answer
    Jaroslaw Piekarz Profile Picture
    on at
    RE: Retail store transaction posting status showing as posted but there is no sales order or transaction showing

    Hi Nazardeen,

    Yes, I would suggest you to open support ticket for this issue.

    It looks that retail sales transaction with TransactionId = 2286454 doesn't have any sales line and payment transaction.

    To verify it you may run sql queries as bellow in HQ and Store db's to verify if transaction is consistent:

    --In HQ db
    select * from RETAILTRANSACTIONTABLE where TRANSACTIONID = '2286454'
    select * from RETAILTRANSACTIONSALESTRANS where TRANSACTIONID = '2286454'
    select * from RETAILTRANSACTIONPAYMENTTRANS where TRANSACTIONID = '2286454'

    --In STORE db
    select * from ax.RETAILTRANSACTIONTABLE where TRANSACTIONID = '2286454'
    select * from ax.RETAILTRANSACTIONSALESTRANS where TRANSACTIONID = '2286454'
    select * from ax.RETAILTRANSACTIONPAYMENTTRANS where TRANSACTIONID = '2286454'

    Best regards,

    Jaroslaw Piekarz

  • silmi Profile Picture
    59 on at
    RE: Retail store transaction posting status showing as posted but there is no sales order or transaction showing

    Hi Andre,

    Thank you so much for your response

    We have a POS integration with Micros belongs to this retail statement and I couldn't find find any duplicate record for this transactions

    Thank you  

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    294,261 Super User 2025 Season 1 on at
    RE: Retail store transaction posting status showing as posted but there is no sales order or transaction showing

    Hi Nazardeen,

    Have you checked if the same transaction is imported twice where the other might have a sales order reference? If you don't have customizations, you can check on LCS issue search for known issues or contact Microsoft Support by creating a new ticket.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,996 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans