Skip to main content
Answer

How does Acumatica know what "Account Group" should use for Employee Timesheet and payroll posting?

  • March 31, 2023
  • 6 replies
  • 215 views
aaghaei
Captain II
Forum|alt.badge.img+10

Hello Community,

 

I see when employees enter their Time Activities using a Project => Task => Cost Code, Acumatica in the Project Cost Budget creates a line with the same info plus “Account Group” L. How does Acumatica know what Account Group should use?

@brandontfrank

Best answer by aaghaei

Its not here. I guess I figured it out. I think it is driven from Payroll Preferences. Then based on this preferences gets the GL Accounts from chosen Entities like Earning Type, Employee, Labor Item, … then from the GL Account associated with the Entities finds the Account Group. This is what I guess but I will need to test and verify it.

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Janella

6 replies

aaghaei
Captain II
Forum|alt.badge.img+10
  • aaghaei
  • Author
  • Captain II
  • April 2, 2023

@Doug Johnson any help is appreciated 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • April 3, 2023

Hi @aaghaei 

Please refer to the following. 

https://help-2022r2.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=b841fc90-bd22-4fa9-b88c-cf7bb03cb35e

Account group should be picked based on debit GL account.

Hope this helps.

Regards,

VijayKumarU
Chris Hackett
aaghaei
Captain II
Forum|alt.badge.img+10
  • aaghaei
  • Author
  • Captain II
  • April 3, 2023

Thanks @vkumar 

What you are suggesting takes me here.

How this helps to determine the Account Group associated with the timesheets?

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
aaghaei
Captain II
Forum|alt.badge.img+10
  • aaghaei
  • Author
  • Captain II
  • Answer
  • April 3, 2023

Its not here. I guess I figured it out. I think it is driven from Payroll Preferences. Then based on this preferences gets the GL Accounts from chosen Entities like Earning Type, Employee, Labor Item, … then from the GL Account associated with the Entities finds the Account Group. This is what I guess but I will need to test and verify it.

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
Doug Johnson
Acumatica Moderator
Forum|alt.badge.img+4
  • Doug Johnson
  • Acumatica VP, Product Management
  • April 10, 2023

@aaghaei I think you figured it out … but just in case … 

If you have payroll enabled ... 

  • Set Payroll Preferences, Earnings Account
    • If Earning Type, then the system uses the GL Account from the Earning Types Codes, GL Accounts tab
    • If Employee, then the system uses the GL Account from the Employee Payroll Settings, GL Accounts tab
    • If Pay Group, then the system uses the Earnings Account from the appropriate line on the Pay Groups screen
    • If Labor Item, then the system uses the GL Account from the Non-Stock Item, GL Accounts tab
    • If Project or Project Task, then the system uses the information from the Project
Debit Account (and therefore Account Group) set using values on the Payroll Preferences screen

If payroll is NOT enabled … 

  • Set Project Preferences, Expense Account Source to either Labor Item or Employee
    • If Labor Item, then the system uses the GL Account from the Non-Stock Item, GL Accounts tab
    • If Employee, then the system uses the GL Account from the Employees, Financial tab
    • If Project or Project Task, then the system uses the information from the Project
Debit Account (and therefore Account Group) set using values on the Project Preferences screen

 

aaghaei
Chris Hackett
Robert Sternberg
aaghaei
Captain II
Forum|alt.badge.img+10
  • aaghaei
  • Author
  • Captain II
  • April 15, 2023

Thank you @Doug Johnson 

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility 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