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

Notifications

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) / AX 2012 Retail POS: &q...
Microsoft Dynamics AX (Archived)

AX 2012 Retail POS: "RetailTransaction" table

(0) ShareShare
ReportReport
Posted on by Jonathancm 416

Hello everyone,

I'm investigating an issue in one of the store databases used by a customer. The thing is that the database is abnormally increasing, so it becomes useless in POS. 

I got the top tables in disk space usage, and I find very interesting one of the tables called RetailTransaction. This table usually has only about 3-8 records, but occupying up to 5 Gb of disk space. I'm finding hard to find information about this table and what acctually does in Retail process.

Can anyone give me a little information about this?

Thanks.  

*This post is locked for comments

I have the same question (0)
  • Verified answer
    sumit0417 Profile Picture
    sumit0417 2,890 on at

    Hi Jonathan,

    RetailTransaction table save the current information of the transaction at POS.

    For instance if you are doing any sales transaction at POS - Added Customer, Added item but not committed the transaction then the data will appear in the RetailTransaction . Once you commit the transaction this will be deleted. If you have records in this table then this might have caused due to closing the POS application through Task manager when there was a running transaction on it or any cause of sudden closure of POS application or there might be a transaction currently happening on the POS screen. I dont recommend deletion of the records from this table as there might be a sales transaction running. Make sure that the store operations are not happening and then delete the records.

  • Jonathancm Profile Picture
    Jonathancm 416 on at

    Thanks Sumit.

  • Community Member Profile Picture
    Community Member on at

    Hi Jonathan,

    Set up the 'Days transactions exist' on the functionalty profile which will automatically clean up the database tables when ending the shift.

    Read this blog for more suggestions:

    https://community.dynamics.com/ax/b/axsupport/archive/2014/01/10/ax-retail-retail-store-maintenance-and-sql-express.aspx

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans