Views:

An issue has been reported in Reckon APS Tax 2019.5.0 where users are unable to create bulk Activity Statement under a specific matter due to the below error:

Exception [SQLException], Message = Received an invalid column length from the bcp client for colid 42

Cause

There are phone number in the database exceeds 20 charaters.

Resolution

Run the script below against your aps_dsql database, to look up phone number more than 20 charaters in the database.

select cltPhone, cltSortName from cdbClient where LEN(cltPhone) > 20;

Reduce the phone number to below 20 charaters for all entities per the script result. Then run the bulk creator again. 

Related Products: APS TAX AU