[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions
[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions
Home | Profile | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 QuoteWerks
 Products
 Advance Query MS SQL - New Modifier Refresh Prices
 Forum Locked
 Printer Friendly
Author Topic  

dustundag
QuoteWerks Master

Turkey
240 Posts

Posted - 11/04/2016 :  09:37:30  Show Profile  Visit dustundag's Homepage
Update Products_ShangdonLedeCo_Products
SET PriceModifier="M20"

This works. However prices are not reflected with the new modifier
and have to set for each product.
Is there any solution to refresh all prices with the new modifier?
Thanks

stevesiggs
QuoteWerks Genius

United Kingdom
2163 Posts

Posted - 11/04/2016 :  12:24:20  Show Profile  Visit stevesiggs's Homepage
quote:
Originally posted by dustundag

Update Products_ShangdonLedeCo_Products SET PriceModifier="M20"

This works. However prices are not reflected with the new modifier
and have to set for each product. Is there any solution to refresh all prices with the new modifier?

The Line Items Price on the Documents? Try clicking the 'Latest' button.

Hope this helps,

Stephen Siggs
Hilltops IT / ConnectIt Software
QuoteWerks Solution & Development Partner since 2005

Skype: stephen.siggs
Tel: +44(0) 344 357 7360
Cell: +44(0) 7875 423661
Email: steve@hilltopsit.co.uk
QuoteWerks services - www.hilltopsit.co.uk/quotewerks
QuoteWerks add-ons - www.connectit-software.co.uk
Go to Top of Page
  Topic  
 Forum Locked
 Printer Friendly
Jump To:
[Archived] QuoteWerks Support Forum - New Forum: https://tickets.quotewerks.com/support/discussions © Aspire Technologies, Inc Go To Top Of Page
Snitz Forums 2000