News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Help! I put everything...

Microsoft Dynamics RMS (Archived)

Help! I put everything on sale

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I was trying to clean up what showed as being on sale using the price wizard. Unfortunately, I ended up marking everything as on sale. The date of the "sale" expired but, the items still claim to be on sale. The funny thing is that the regular price of the item is listed as the sale price.

I just need to run a script to de-select the box that says "this item is on sale." I've done this type of thing before, but I don't know how to write the script and I don't want to mess it all up.

Can anyone help?

Thanks!

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Sad 650 on at

Like (0)

Report

Re: Help! I put everything on sale

Hi Meralee,

Do not panic,

1- first make a backup of your database

2- Try this sql statment,( I suppose that you know how to run sql query in RMS administrator ):

Update item

set saletype = 0

where ( your condition like lastsold < '04-05-2011' )

note: you can omit the third line if you want all items in inventory to uncheck 'onSale'

3- check your items

hope this is helpfull for you

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans