I have created a BAQ export to create a CSV file. It is used to upload our 401k deductions to the plan provider and needs to match a very specific format. The columns are SSN, Name, 401k Employee, 401k Employer and 401k Caft. I created calculated fields to put the deduction amount in the correct column.
The name and SSN are in quotes as they should be but the remaining columns which are all decimal also export with quotes around them. I also tried adding "convert(decimal," to the calculated field and got the same result. Anyone run into this?
Mark