Skip to main content
Solved

Timesheet Import Error: SubAccountID Cannot Be Found

  • August 12, 2026
  • 8 replies
  • 131 views
janinakeith
Freshman I

Hi everyone,

We’re getting the following error when importing timesheets for two specific employees:

[SubAccountID] cannot be found in the system. Please verify whether you have proper access rights to this object.
 

The import works for other employees.

Has anyone encountered this before? Could this be related to the employees’ Subaccount, account, or payroll setup? What configuration should we check to resolve this?

Thanks!

Best answer by Naveen Boga

​@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."

8 replies

A
Jr Varsity III
Forum|alt.badge.img+5

​@janinakeith Check this post to get an idea. → LINK

Abhishek Nikam || MVP 2026 || https://www.linkedin.com/in/abhisheknikam3
    janinakeith
    Freshman I
    • janinakeith
    • Author
    • Freshman I
    • August 12, 2026

    Shall I turn this on? 

     

      Naveen Boga
      Captain II
      Forum|alt.badge.img+20
      • Naveen Boga
      • Captain II
      • August 12, 2026

      Yes ​@janinakeith  Try that option and share the results.

      Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
        janinakeith
        Freshman I
        • janinakeith
        • Author
        • Freshman I
        • August 13, 2026

        Yes ​@janinakeith  Try that option and share the results.

        However, I want to know the purpose of that specific button

          Naveen Boga
          Captain II
          Forum|alt.badge.img+20
          • Naveen Boga
          • Captain II
          • August 13, 2026

          ​@janinakeith  This check box indicates (if selected) that users can enter new values of the segmented key on data entry forms. If you clear the check box, users can specify the segmented key values on data entry forms only by typing or selecting the existing values of the segmented key and its segments.
          The availability of the check box depends on the lookup mode i.e. By Segmented Key or By Segment: All Avail. Segment Values.

          Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
            janinakeith
            Freshman I
            • janinakeith
            • Author
            • Freshman I
            • August 17, 2026

            Hi ​@Naveen Boga this is noted thanks. However, after trying it just now it shows another error for sub account ID. Should I just delete the ID? It is not on the excel file I have tried to use to import after all.

             

              Naveen Boga
              Captain II
              Forum|alt.badge.img+20
              • Naveen Boga
              • Captain II
              • Answer
              • August 17, 2026

              ​@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."

              Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
                janinakeith
                Freshman I
                • janinakeith
                • Author
                • Freshman I
                • August 21, 2026

                Hi ​@Naveen Boga this is really helpful. I have tried the first one. While this will resolve the issue. I wonder why it’s failing and having an error even there are other employees that were I am able to upload their timesheet while on the other one is not allowing me at all. I have also checked the subaccount for under Financial Tab and its showing the subaccount is attached into it.

                  Terms & ConditionsAccessibility statement
                  About Acumatica ERP system
                  Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
                  © 2008 — 2024  Acumatica, Inc. All rights reserved