web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) delete sales history o...

Microsoft Dynamics RMS (Archived)

delete sales history only before a specific batch number

(0) Share

Report

Report

Posted on by Community Member

After proccessing the attached Query on the following URL . to delete sales history only before a specific batch number

http://blog.emick.us/MicrosoftRMS.php/2009/12/08/rms-maintenance-deleting-sales-history-in-microsoft-retail-management-system-store-operations

the item movement history report , show a wrong Item Qty , what to do

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

Re: delete sales history only before a specific batch number

This is totally inappropriate and you shouldn't have done it by any means! Deleting sales history without a proper archiving tool like Retail Realm Archiving Utility would make your data inconsistent.

The only way to have your deleted data recovered, is to restore a backup taken before you delete your data, then work on inserting the deleted records from the restored backup into the life database, you need to contact an RMS consultant with a good SQL knowledge

A Hassan

RMS Leaders

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: delete sales history only before a specific batch number

Dear Mr. A Hassan

thanks for reply , i make this test on a private database , not our main database , my target to find the right solution for delete the old transaction and keep my database consistent and health

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans