We hace created a PO with amount as below
while making payment entry it says
I can’t say how Rounded Total applies here.
The message makes sense - indeed the payment advance exceeds the (Grand Total) amount due - it seems reasonable to prevent overpayment?
if advance.account_currency == self.currency:
order_total = self.grand_total
formatted_order_total = fmt_money(order_total, precision=self.precision("grand_total"),
currency=advance.account_currency)
else:
order_total = self.base_grand_total
formatted_order_total = fmt_money(order_total, precision=self.precision("base_grand_total"),
currency=advance.account_currency)
if self.currency == self.company_currency and advance_paid > order_total:
frappe.throw(_("Total advance ({0}) against Order {1} cannot be greater than the Grand Total ({2})")
.format(formatted_advance_paid, self.name, formatted_order_total))
frappe.db.set_value(self.doctype, self.name, "advance_paid", advance_paid)
@property
def company_abbr(self):
if not hasattr(self, "_abbr"):
self._abbr = frappe.db.get_value('Company', self.company, "abbr")
peterg
October 9, 2018, 1:16am
#3
It depends on what the purpose of the rounding is, I think. As I interpret it,Rounded Total indicates the amount that should be paid, so it’s confusing when paying that amount throws up errors. There’s space in the invoice form to write off a rounding difference, but it looks like it’s not getting thrown in automatically.
The other alternative for OP would be to disable rounding.
Thanks Peter - yes these exchanges support your interpretation that Rounded Total represents the payment amount due, at least in the case of Sales Invoice and Sales Order.
So why a PO does not seem to follow that covention, unless as you say rounding must be disabled in that case.
The issue is that outstanding amount is being calculated with Grand Total as reference. Shouldn’t the Rounded Total be used as reference ? This is creating an issue where even after payment entry being submitted, the invoice is overdue because there has been no payment allocation for that fraction amount.
[sales_inv_outstanding]
In this example, outstanding amount before the payment was Rs. 11,649.20. Now we get a cheque of Rs. 11649 and we create a payment entry and submit it with the sales i…
Hi,
If case is
In Sales Invoice as Include payment checked,
Grand total 10.31
Rounded Total is 10.00
So, it shows Outstanding amount 10.31
But if Payment received as rounded total 10.00,
shows in outstanding 0.31 !
How to set that 0.31 in round off account and not as outstanding amount? Preferably automatically?
How to make Rounded total same as outstanding total ,so the customer will pay only the rounded amount and change and other entries will be calculated on rounded amount.
[image]
i want the customer to pay rounded amount i.e 9 in above case but currently if he pays 9 , it shows change 0.1 which should not happen.
Its pretty simple and basic, so i think it should be already in system?
Can anyone guide me how to set this up?
Thanks.
https://support.erpnext.com/kb/accounting/purchase-invoice-round-off-account
https://erpnext.org/docs/user/manual/en/customize-erpnext/articles/disable-rounded-total
