Importing of WithholdingTaxcodes through DTW

[Former Member]

Hi All,

i have uploaded oWithholdingTaxcodes.But i got error like this "The field is too small to accept the data".

my template details

RecordKey WTcode Account WTName

1 WTC01 143033 WTN01

2 WTC02 143033 WTN02

Please explain how to do this?

[former_member708266 · Accepted solution]

Dear,

Just an additional information for your reference about this error:

1. Enter the correct values in the columns Recordkey.

2. Leave the column LineNum empty ion case you are importing new documents.

2. Use the date format "yyyymmdd" as described in attached Note 886339.

3. Do not delete any columns from the original templates delivered with the DTW installation as this might lead to errors in the import.

Regards

Apple

[Former Member]

The Header in your template

RecordKey WTcode Account WTName

should be repeated twice. It should be

RecordKey WTcode Account WTName

RecordKey WTcode Account WTName

Also mention if you are using Accounts - Segmentation. If so you have to use Format Code instead of G/L Code.