I have a company where we sell pallets of rock. We tags the pallets with a barcode that represents the string "1.5*ARLR" (1.5=Qty and ARLR=Item code).
This way an employee does not have to enter the weight. This works great when the unit price does not change.
I would like to acheive the following: Scan a half pallet that may have a price of $150/ton and a qty of 0.75. However, I would like to set the price so that the unit price change to $180 for breaking the pallet and not $150.
Yes - 0.75 * $180 = $135.00 No - 0.75 * $150 = $112.50
My question is is there any way for include a unit price override in a string like this.
Thanks in advance.