+1-888-319-3663

COMMUNITY FORUM

taUpdateCreateAccountRcd

dcomber asked 10 years ago

Hello, trying to do a bulk load and using an Excel file with changes only for GL Account Description. My map is using the Update Existing flag, but when I run the map, I am getting the following:

Sql procedure error codes returned:
<taUpdateCreateAccountRcd>
<UpdateIfExists>1</UpdateIfExists>
<ACTNUMST>Actual GL Number</ACTNUMST>
<ACTDESCR>New Description</ACTDESCR>
</taUpdateCreateAccountRcd>

Is this a limitation of some sort? Anything else I can try?

Geoff James replied 10 years ago

Hi dcomber,

Try adding the Account Category, as it is a mandatory field if you were making the change manually.

Regards,

Geoff James

Answers

0 Vote Up Vote Down

Best Answer

dcomber answered 10 years ago

Thanks Geoff, that worked. When I clicked the option "Show Required Only", this column did not appear. Thanks for your help.

Dean

If you would like to submit an answer or comment, please sign in to the eOne portal.