We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations and import the correct payment/deduction codes, taxes & payments; however the introduction of the "optional fields" components have rendered the import useless. Even when trying to incorporate the addtional "Optional Fields" tables into the existing workbook, import still fails.
I believe the problem is in Sage: Sage is looking to import a table called "Check_Header_Optional_Field_Valu", however, Excel naming conventions will only allow "Check_Header_Optional_Field_Val" - note the last character "u" is missing. Even if you export a "clean" table from Sage and then try to re-import it, you get the error stating that the import is not ready with a failure in the "Check_Header_Optional_Field_Valu" table.
Any help? Any suggestions? I can always hand key the data, but importing is more accurate and less time consuming. Also, if these are truly "optional" fields, why do they appear to be required as part of the import process?