Importing AR Customer Comments 1

[snowcapped]

I guess my first question would be, is this possible?
I've already exported them, and Accpac seems to be setup to handle the importation as well but I can't seem to get it to work for me.

I've tried importing new and even just updated comments via Excel and a CSV file, but every time I get this error message;

Invalid Input. Date 0000-00-00 is invalid.
Failed to insert record.

Any ideas?

 

[ettienne]

You need to provide a date... 0000-00-00 is not a valid date.
And yes, you can import customer comments.

 

[snowcapped]

I don't know where it's getting that date from as my date fields are being populated.

This is an excerpt of a comment I'm just trying to update.
It's pretty much exactly what I exported from Accpac;

IDCUST,DATEENTR,CNTUNIQ,DATEEXPR,DATEFLUP,TEXTCMNT,REVCOM,CMNTTYPE,
USERID

A0002,8/21/2009,1,8/21/2010,,"CHANGED PROCESS FOR HANDLING PREPAID ORDERS - BB
",999,

Thanks in advance

 

[ettienne]

Check DATEFLUP.

 

[snowcapped]

Bingo.
That was it.

Thanks Ettienne!