On my Purchase Invoices. We are facing below problem.
Amount in Words do not show.
In the attached Purchase invoice. Some times our sellers enter upto 4 decimal places and in thier printouts only 2 decimal places show. Hence it becomes very difficult for us to
match the total amount after tax.
Eg. 2817.039 in our Sellers printout shows as 2817.03 . When I enter 2817.03 in Manager
total comes to 3,130,501.50 Where as my sellers invoice shows 3130511.50.
If Manager would allow me to enter the total amount and back calculate the unit price It would be great and helpful to many business. That decide the final amount with the customer and then work back the unit price.
Quote from Lubos
It would be only possible in sales invoices using custom HTML template.
But in what language do you need numbers to be shown as words? English or different?
Unquote
This is what I found on the forums. I couldnt find where some one insisted on Purchase Invoice.
Tried the template variables balance due and total.number, Which didnt work.
Is it possible on Purchase invoice ? If not. Whats the template variable to access the total on Purchase invoice.
The old links to template variables are broken.
The purchase invoice is an internal document. It’s intended as a way of recording an invoice that they have sent you. So I’m not sure you would need amount in words here?
I’ll leave the calculations to someone else to comment.
First, this is incorrect rounding by your supplier. 2817.039 should be rounded to 2817.04 if the supplier is displaying only 2 decimal places. So the supplier has truncated the number, not rounded it. But if that is how your supplier shows it, why do you think the unit price is something else?
Second, your other comments are confusing. You refer to “Sellers printout” and “sellers invoice.” Which documents are these? I assume that by seller, you mean supplier. But are you referring to the supplier’s sales invoice or to your corresponding purchase invoice? And are the numbers line item amounts or totals including IGST? In some ways, you seem to be referring to one and in different ways to the other.
Regardless, small differences between suppliers’ sales invoices and your purchase invoices often occur because of different methods of calculation. See this Guide for a general discussion: https://www.manager.io/guides/9499. The solution is to either (1) manually calculate unit prices that produce the Amount being charged by the supplier or (2) enter an adjustment line, listing the same inventory item but leaving the quantity blank (not zero) and entering the adjustment amount as the unit price. This would be much like adding freight-in costs manually as described here: https://www.manager.io/guides/9610. The second approach adjusts average cost in inventory without affecting quantity.
