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


There are phone number in the database exceeds 20 charaters.


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