You’re offline. This is a read only version of the page.
90
Hello All,
We are using GP 10 SP4 and currently planning to change valuation method from FIFO to AVg. But as prerequisite if any item is there in unposted sales transaction entry, system won't allow to change valuation method.
Unfortunately we have thousands of Quote records which are showing as unposted, we don't have any problem to delete these transactions, but is there any easy way to delete them from database?
Means, is there any script or solution available to delete all unposted quote??
Thanks in Advance,
Dharmesh N. Vyas
*This post is locked for comments
Thanks Bradley, Appreciated your help!!! It's working perfectly!!
Hi Dharmesh,
I'll help you get it done quicker.
Send me your email address and I'll email you a script that will delete all the SOP Quotes quickly. Go to our website at www.ShammamConsulting.com and click "Connect" then click "Contact Us."
Thanks,
Bradley
Hi Bradley,
Thanks a lot for your reply.
Yes surely your idea helps, infact i tried Macro stuff before, but it takes a lot time, and i am having thousands unposted quotes and sales orders :(
Anyways, thanks for your suggestion.
Regards,
Dharmesh N. Vyas
Hello Dharmesh,
A simple way is to create a macro that will switch to the next document and press the delete button. When it prompts to confirm the delete have it pause for your input so that you can confirm the delete. Then save the macro, open it in notepad and copy/paste the lines that will repeat the process.
Let me know if that helps.
Bradley Shammam
Hi All,
Can someone suggest best option for above question?
Thanks,
Dharmesh N. Vyas
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (