Purchase order - Use total cost and number of units to calculate unit price
Ability to enter total amount of Purchase Order and number of units, then the unit price will be automatically calculated. Have quotes given by suppliers that are a fixed amount that cannot be changed, and because of the Unit number the total has to round up, it doesn’t give the same total.
Sarina Schmidt
shared this idea
Hi team, sorry we've not returned to this idea sooner. You'll have seen that we've released a new experience for Purchase orders.
When entering lines of your purchase order you have the ability to use Xero's inbuilt calculator, meaning you can enter a formula in the price field to calculate the price.
For example you have 6 units and the total of the purchase order is $5,360 - entering this in the Price field as 5360/6 will auto calculate the unit price for you to 4 decimal places. 🙂
We appreciate how this can be helpful when given total amounts by your supplier and hope this helps in entering the information in Xero. Thanks
