KIndly help.I have issue with importing sales invoices.I have arranged everything perfectly,it keeps on giving error message that the Total Payment in payment schedule should equal the grand total.In my arrangement the two are equal
See the error message
Traceback (most recent call last):
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/core/doctype/data_import/importer.py”, line 395, in upload
doc.insert()
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 221, in insert
self.run_before_save_methods()
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 862, in run_before_save_methods
self.run_method(“validate”)
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 758, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 1027, in composer
return composed(self, method, *args, **kwargs)
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 1010, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/model/document.py”, line 752, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/accounts/doctype/sales_invoice/sales_invoice.py”, line 58, in validate
super(SalesInvoice, self).validate()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/selling_controller.py”, line 37, in validate
super(SellingController, self).validate()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/stock_controller.py”, line 17, in validate
super(StockController, self).validate()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/accounts_controller.py”, line 53, in validate
self.validate_all_documents_schedule()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/accounts_controller.py”, line 80, in validate_all_documents_schedule
self.validate_invoice_documents_schedule()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/accounts_controller.py”, line 69, in validate_invoice_documents_schedule
self.validate_payment_schedule_amount()
File “/home/fredoluka2015/frappe-bench/apps/erpnext/erpnext/controllers/accounts_controller.py”, line 736, in validate_payment_schedule_amount
frappe.throw(_(“Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total”))
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/init.py”, line 323, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’)
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/init.py”, line 309, in msgprint
_raise_exception()
File “/home/fredoluka2015/frappe-bench/apps/frappe/frappe/init.py”, line 282, in _raise_exception
raise raise_exception(encode(msg))
ValidationError: Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total
See my CSV table
Data Import Template
Table: Sales Invoice
Notes:
Please do not change the template headings.
First data column must be blank.
If you are uploading new records, leave the “name” (ID) column blank.
If you are uploading new records, “Naming Series” becomes mandatory, if present.
Only mandatory fields are necessary for new records. You can delete non-mandatory columns if you wish.
For updating, you can update only selective columns.
You can only upload upto 5000 records in one go. (may be less in some cases)
DocType: Sales Invoice ~ Sales Invoice Item items Payment Schedule payment_schedule ~ ~ ~ ~
Column Labels: ID Series Company Date Currency Exchange Rate Price List Price List Currency Price List Exchange Rate Net Total (Company Currency) Grand Total (Company Currency) Grand Total Debit To Item Name Description UOM UOM Conversion Factor Rate Amount Rate (Company Currency) Amount (Company Currency) Income Account Cost Center Due Date Payment Amount Payment Term Description Invoice Portion
Column Name: name naming_series company posting_date currency conversion_rate selling_price_list price_list_currency plc_conversion_rate base_net_total base_grand_total grand_total debit_to ~ item_name description uom conversion_factor rate amount base_rate base_amount income_account cost_center due_date payment_amount payment_term description invoice_portion ~
Mandatory: Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No
Type: Data (text) Select Link Date Link Float Link Link Float Currency Currency Currency Link Data Text Editor Link Float Currency Currency Currency Currency Link Link Date Currency Link Small Text Percent
Info: One of: SINV-, SINV-RET- Valid Company dd-mm-yyyy Valid Currency Valid Price List Valid Currency Valid Account Valid UOM Valid Account Valid Cost Center dd-mm-yyyy Valid Payment Term
Start entering data below this line
SINV- Cloudmaster Solution 22-05-2018 NGN 1.0 Standard Selling NGN 1.0 100000.0 105000.0 105000.0 1310 - Debtors - CS A A Hour 1.0 50000.0 100000.0 50000.0 100000.0 4110 - Sales - CS Main - CS 22-06-2018 105000.0 100.0
SINV- Cloudmaster Solution 21-06-2018 NGN 1.0 Standard Selling NGN 1.0 50000.0 50000.0 50000.0 1310 - Debtors - CS A A Hour 1.0 50000.0 50000.0 50000.0 50000.0 4110 - Sales - CS Main - CS 22-06-2018 50000.0 100.0
Pls help.Is there anything i am missing?
Thanks
Fred