Timesheet Import Error: SubAccountID Cannot Be Found

​@janinakeith Thank you for the additional screenshots, these are very helpful in identifying the root cause.

Looking at the Import Timesheets screen, I can see the Sub Account ID column is showing values of -2147483647 and -2147483646. These are system placeholder values not real subaccount IDs which is why the system is throwing the 'Sub account not found' error.

Please try the following:

Option 1 — Leave Sub Account blank in the import file (Recommended):
Since you mentioned the Sub Account column is not in your Excel file, the import is likely picking up a default invalid value. Please check your import file and ensure the Sub Account column is either:

• Completely removed from the file
• Left blank for those two employees

The system will then use the default subaccount configured on the employee record instead of trying to match an invalid value.

Option 2 — Check employee subaccount setup:

• Go to Employees (EP203000)
• Open each of the two affected employees
• Go to Financial tab
• Check the Subaccount field is set to a valid active subaccount
• This will be used as the default when no subaccount is specified in the import

Option 3 — Check your import file mapping:

• Go to your import batch TSB001522
• Check the column mapping for Sub Account ID
• If it is mapped to a column that does not exist or is blank in your Excel file — remove the mapping entirely

Do NOT delete the SubAccountID field from Acumatica   just ensure it is either blank or correctly mapped in your import file.
 

Please try Option 1 first as it is the quickest fix. Let me know how it goes."