Sales Invoice Import Error

Hi Team,

I’m facing an issue while importing a GST Sales Invoice using the Data Import Tool in ERPNext. The error message I get is:
Total Payment Amount in Payment Schedule must be equal to Grand / Rounded Total
I’ve already ensured that the Payment Schedule amount matches the Grand Total.
Would appreciate any help or advice from the community!
Thanks in advance

Hi

The payment Schedule table in Terms section of sales invoice doctype which you are defining must match with grand total of the invoice. The payment schedule table can be defined with multiple terms and future dates with partial amount

Infact uploading invoices by data import does not require net total and grand total fields to be filled in your excel as those are going to be tabulated by multiplication of qty and rate fields of item table automatically.

I believe you have to work with mandatory fields only as data import is tricky for a new user.

1 Like