Dividing formula or UOM formula
My customer pay for 1000bags. So there PO also indicate 1000 bags price and total bags requesting and the amount that they need to pay. Example: In PO in total order 10,000 in qty and amount 1200 for M (which is 1000 bags price) and total due = $12,000
When we send the orders, in the delivery slip we enter total rolls in total and in description Each roll has 500 bag . Example: Total Rolls = 10. Each roll has 500 bags. We don't enter total amount of bags. (Here is the problem occurs when I create invoice)
Every time I need to find the total bags when am doing Invoice. Example: 10 X 500 = 5000 /1000 = 5. So I enter "5" in total column in QuickBooks and enter the rate as $1200 of their PO price. Now the total amount displays as $6000 is due. ( So many delivered items will be in each invoice. There will be 10, 15 invoices in total and each time I need to this crab. Each customer has different style of paying. Some are for rolls, LB, 100 bags and1000 bags. So it is a multiple way I need to do it. My only concern is 1000 BAGS price.
My questions is now that " Is there any option in formula or editing option in item list data, that I just enter total bags 5000 in total and the formula should dived by 1000 when I enter the UOM as M and calculate with the Rate that I entered and display the total amount "? (Rather than me dividing and enter the number) Example: when I enter 5000 and M as the UOM the formula should take 5 and calculate with the Rate $1200 and = $6000.
What's happening is here some time I forgot to dived by 1000 and enter as 10 instead of 5. Because in the delivery note has total rolls as 10. So I enter has 10 in Total qty and the rate. So total amount will be wrong. (10 x $1200= $12000 which is wrong invoice.
Please advise me.
Vijitha