Discussions
Rate vs Amount Auto Interpolation
On my sales orders right now, the "Amount" column is a calculated field that multiplies QTY * Rate.
I am wondering if there is a way you can make the Rate column auto interpolate to Amount/QTY
What im trying to accomplish is, if i have a sales rep selling qty:8 of something for "13 dollars", i want him to be able to put 8 in the qty field, and 13 in the amount field and have the "rate" field automatically default to 13/8=1.625
quickbooks did this automatically so my sales guys are used to being able to do this. does anyone have a solution?