hey everybody, Is there anyway RMS can automatically calculate lower bond for the item from their Cost. for example if i can set up the lower bond to be cost + 2%. it can calculate it automatically .
thank you, shoby
You could use the SQL Trigger below that would run every time you create or update an item. Open SO Admin connect to database copy and paste the below code into a new Query and press F5 to run. You will get a message saying 'Query executed successfully: -1 records(s) affected.'.
CREATE TRIGGER [utr_Item_Cost_LowerBound_Insert] ON [Item] FOR INSERT, UPDATE AS
/*************************************************** utr_Item_Cost_LowerBound_Insert sets LowerBound to Cost * 2% when item is created.
***************************************************/ BEGIN UPDATE Item SET LowerBound = i.Cost * 1.02 FROM Item INNER JOIN INSERTED i on Item.ID= i.ID ENDRob
"Shoby" wrote:
We have an application called Store Misc Utility [also one called HQ Misc Utility]. In that application there are 36 new wizards one of which allows you to set Upper and Lower bounds based on a formula.
If you wish to evaluate this please contact me by email
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO Retail Realm
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.