Notifications
Announcements
No record found.
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
Thank you
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.
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
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 dbselect * from RETAILTRANSACTIONTABLE where TRANSACTIONID = '2286454'select * from RETAILTRANSACTIONSALESTRANS where TRANSACTIONID = '2286454'select * from RETAILTRANSACTIONPAYMENTTRANS where TRANSACTIONID = '2286454'
--In STORE dbselect * from ax.RETAILTRANSACTIONTABLE where TRANSACTIONID = '2286454'select * from ax.RETAILTRANSACTIONSALESTRANS where TRANSACTIONID = '2286454'select * from ax.RETAILTRANSACTIONPAYMENTTRANS where TRANSACTIONID = '2286454'
Best regards,
Jaroslaw Piekarz
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
