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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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)
  • Suggested answer
    CU09060827-0 Profile Picture
    CU09060827-0 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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dserp Profile Picture

dserp 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans