ill try that now and let you know
that makes inventory respond correctly BUT order price changes again from a minus to a positive, we just mustnt be able to have a negative order price AND increase inventory in the action
Ok Rickh do this. Use variable for Price and Quantity set this in the rule
[=-1*TN('{QUANTITY}')]
[=TN(0-'{PRICE}')]
Order.Price is whats messing it all up.
That variable is better than just -1 anyway as it will ensure it always uses the Quantity and not just -1. I used -1 mostly for testing I knew it may not fit all situations.
1 Like
SPOT ON!!! it works!!
thankyou both so much for all your help and suggestions, let see if V5 will break my rules haha. At least it buys me some time if i NEED to look at changing my accounting slightly and my need for minus numbers for refunds haha 
1 Like
BTW another sneak peak:
Although I am fairly sure @QMcKay has a more interesting setup 
Right now it doesnt. But I kind of agree with @QMcKay that it could in future. You may want to revisit it when you start playing with V5.
I can tell you from messing with your Database in V5 and using rule debugger your setup works but you do have ALOT of unnecessary automation. Rule debugger is great for spotting this.
yea ill wait for V5 then have a play
