Import Purchase Order Error

smakheads · February 25, 2020, 2:42pm

HI - First post. So far have been having good success setting up erpnext for my Antique business. I have run into a small problem though.

I am trying to import to a Purchase Order from excel, and am having problems with this column on the template: payment_schedule Payment Amount.

When I go to import I get error saying this column must equal Rounding/Grand Total. So I’m wondering what amount needs to go in there. I would have thought it was just the QTY * Rate for each item, but I guess not! I have also tried to enter just the total of the entire purchase order. That doesn’t work either!

Anyone have any ideas or thoughts on this? Thank you.

Mark

clarkej · February 25, 2020, 4:46pm

Hi welcome to ERPNext Mark!

To illustrate and reduce the guesswork please post screenshots with precise details - ideally a listing of the input line where the import fails, the input line headers, and the actual error message.

To reverse engineer is another way to debug if you have not tried that - create and export an example PO to id exactly what value goes where, what is optional and so on?

Also to import and export csv can avoid problems to do with xlsx format.

Have fun Red Deer

smakheads · February 25, 2020, 6:02pm

Ok here is my input:

I have entered the total of all of column S in the first line of column AD. This is how it appears when I enter a purchase order and download the Update Lines template.

I have also tried to just import the lines, that doesn’t work as well and only imports the first line of the csv.

Mark

smakheads · February 25, 2020, 6:03pm

Here is the error:

clarkej · February 25, 2020, 7:12pm

The number of decimal digits in your input may be the issue - check whether Excel may be rounding or not displaying the actual values?

The validation code is fussy about decimal digit precision

github.com

frappe/erpnext/blob/0ebace5da2dbb93928d633e739778d4e7a0b6f73/erpnext/controllers/accounts_controller.py#L845


      
          			if self.doctype == "Sales Order" and getdate(d.due_date) < getdate(self.transaction_date):
          				frappe.throw(_("Row {0}: Due Date cannot be before posting date").format(d.idx))
          			elif d.due_date in dates:
          				li.append(_("{0} in row {1}").format(d.due_date, d.idx))
          			dates.append(d.due_date)
          
          
		if li:
          			duplicates = '<br>' + '<br>'.join(li)
          			frappe.throw(_("Rows with duplicate due dates in other rows were found: {0}").format(duplicates))
          
          
	def validate_payment_schedule_amount(self):
          		if self.doctype == 'Sales Invoice' and self.is_pos: return
          
          
		if self.get("payment_schedule"):
          			total = 0
          			for d in self.get("payment_schedule"):
          				total += flt(d.payment_amount)
          			total = flt(total, self.precision("grand_total"))
          
          
			grand_total = flt(self.get("rounded_total") or self.grand_total, self.precision('grand_total'))
          			if self.get("total_advance"):

A simple case with a single item and dollar amounts might shed light on the issue…