Home › Forums › Users › General User's Discussion ›

price rise

Submitted by Guest on Tue, 24/06/2008 - 16:24
in
Hi Tony,

can you do a mass update on our fixed price dispensing fees, and increase them all by $1.00.

Thanks, Bruce. _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/mailman/listinfo/users

‹ first time setup OpenVPMS version 1.2 beta 1 released ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Mass Price Update

Submitted by Matt C on Wed, 25/06/2008 - 01:00.

Hi Bruce,

As of Version 1.2 there was no price update functionality (it is planned as part of stock control work I think).  We at Boronia have applied a price update using direct SQL queries however. Clearly this is not the ideal solution as it could be quite damaging if written .... poorly.

 

Suffice to say we had some multiple copies of verified backups before applying the SQL.

 

Given the potentially disastrous implications of applying SQLs directly against the database I'll only provide the SQLs we used via private msg :)

 

Matt Costa

Syndicate content