Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

excel invoice import error

Posted By xye over 5 years ago

I am importing an excel template for invoices. An error message appeared 'Terms code 1 must be blank'. There was previously a '1' in this field and I deleted it and retried the import but the error message came up again. Can some help to resolve this issue. Thanks

0 Jay Converse Acumen over 5 years ago

Except for the header row, leave all the rows on the Invoice_Payment_Schedules tab empty.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 xye over 5 years ago in reply to Jay Converse Acumen

Thanks Jay. I deleted all the detail except for the header row but still got the same error message. I note that the Termcode header is on the Invoices tab. Does this make any difference?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 5 years ago in reply to xye

Delete the terms code column, let the system select it from the customer default.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

excel invoice import error

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING