Sales Item Import error 25

[JBentley]

Hi there

Can someone please assist with Import error 25.

Documents attached.

TIA
JB

[Komal_S]

Hi @JBentley 

The Total amount is normally calculated as Qty x Price== Total. If we look at the first line in your import file, the Qty is 0 and Price is 199.09 and if these two values are multiplied, the Total amount turns out to be zero ( but in your import file the Total amount is 199.09).

Since the values in the import file do not equate to the mathematical calculation, you will keep on getting this error. In order to resolve it, please enter a digit in the quantity field that would result in a positive amount as shown in the Total field in the import file.

Let us know if you have additional questions on this. 

[JBentley]

Good morning Komal

Thank you for your reply, please see new error 232 - error log attached.

JBentley

[Komal_S · Accepted solution]

Hi @JBentley 

I've tried to import the same file and it worked without giving the error you're getting. Please check a few things to ensure that the import works as expected: 

1) Check what fields you're matching the import file by, as an example I've chosen to match by Co./Last Name:

2) If you have also selected Co./Last Name, ensure that the Co./Last Name available field is matched to Co./Last Name import field and the First Name is matched to First Name. If you're auto-matching the fields, this order can be incorrect, therefore please ensure all the fields are correct by manually matching them( if required)  before moving to the next one: 

3) Finally, unmatch Card ID and Record ID as shown because it can sometimes cause interference if the card is matched by Co./Last Name:

Besides these things, the name of the cards also matters. If these names are in the upper case in AccountRight, they should be upper case in the import file as well.

Let me know how you go on with these changes.