Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example scenario: If a member of the Electrical department, in the Residential division, works on a Job in the Commercial division for 30 of 40 hours in a week, the costs of the member's benefits and tools costs for all 40 hours go to the Electrical department but 30 hours' worth of revenue is generated in the Commercial division. As a result, the division has profit, even with the Cost of Goods Sold amounts that it carries, and the Electrical department does not. If this happens often, financial reports can start to indicate that the Electrical department and even the Residential division is not contributing to profitability.


Note

At minimum, you MUST assign an All - Default: REQUIRED account for each origin/account type combination in the account tree. However, this account would only be used if you did not have accounts assigned anywhere in the individual Division tree levels.
You can access the Payroll and Overhead Offset Accounts Setup in the following ways:

  • From the main menu, choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Account Setup > Payroll Offset Accounts.
  • In Service Management, from the Invoice Accounts window (Microsoft Dynamics GP > Tools > Service Management > Invoice Setup > Invoice Accounts > Payroll Offset button).
  • In Service Management, from the Maintenance Accounts window (Microsoft Dynamics GP > Tools > Service Management > Maintenance Setup > Accounts > Payroll Offset button).

...

To keep better track of which accounts were assigned, we recommend you periodically print the Signature Payroll and Offset Accounts list. In the Payroll and Overhead Offset Accounts window, click on the printer button that appears at the bottom left of the window. Complete the Report Destination window to print the report.

Note: If a setup option has been unmarked (for example, Create Expense/Travel Transactions in the TimeTrack Setup Options window) after an account was assigned in this tree that required the setting of that option, the account designation will still print in this report; however, the account cannot be posted to.

...

  1. In the Payroll and Overhead Offset Accounts window, select the Origin and Account Type.
  2. Locate the Division for which you want to assign accounts. Use the tree view to navigate as far down the tree as you desire, until you hit the level at which you want to assign an account. To save time, you can navigate the tree using arrow keys. When you get to a level/node that for which you can assign accounts, the account field at the bottom of the window is enabled. Some origin/account type trees do not go as deep as others. For example, for the travel offset account type, you can specify accounts at the Pay Code level. For the expense account type, you can assign accounts one level deeper, at the Cost Element level.
  3. You can select an account in one of two ways:
    • Double-click on the node to which you are assigning the account (ex. Pay Code). The Accounts window opens. Select an account, then click Select. The account displays in the account number in the account field. The account is saved automatically. - OR -
    • Highlight the node in the tree, then enter the account manually in the account field at the bottom of the window. When finished, click the Save button. (You only need to click Save when you enter accounts manually.) 

...

    • Note

      Assign more accounts; remember to assign at least

...

    • an All - Default: REQUIRED

...

    •  account for each origin/account type combination. If you close the window without having assigned Default accounts, a missing required account number message will display.


  1. Choose OK to disregard the error and keep the window open. You will get this message until you enter the required account that the system is looking for.
  2. Choose Ignore to close the window.

...

In this section, we will look at a sample General Ledger after payroll has been posted, in this case, through the Signature Transaction Entry window. Included is where from within the Payroll and Overhead Offset Accounts Setup window the accounts were grabbed.

After running Signature Payroll Post, the posting journal report contains account information, including GL accounts and amounts. Below is a table of the accounts and windows/areas within Signature Job Cost from which the accounts were taken.


Area from Payroll and Overhead Offset Accounts Setup windowAccountDescriptionDebitCredit

Division Account Setup - COMMERCIAL Division - Labor Cost element

000-1410-02

WIP-Labor-Jobs-COMMERCIAL

$2100.00

$0.00

Payroll and Overhead Offset Account Setup - Gross Pay Offset Credit Account - HOUR pay code

000-5100-00

Salaries and Wages

0.00

1070.00

Payroll and Overhead Offset Account Setup - Overhead Offset Credit Account - HOUR pay code

000-4801-00

Overhead Offset Job Cost Labor

0.00

1036.00

Payroll and Overhead Offset Account Setup - Travel Offset Credit Account - TRAVEL pay code

000-4800-00

Overhead

0.00

3.80

 

 

Totals

$2100.00

$2100.00

...

During the upgrade installation to 10EX Feature Pack 1, several accounts were moved from existing windows to the new Payroll and Overhead Offset Accounts Setup window. In addition, some windows were removed and some retained.

  • Job Cost Overhead Detail Accounts window (in Job Cost) - This window was removed during upgrade.
  • Expense and Travel Offset Account Setup window (in TimeTrack) - This window was removed during upgrade.
  • Invoice Accounts - Costs window (in Service Management) - This window was retained because it is still used by plus (plus) button transactions.
  • Maintenance Accounts - Costs (in Service Management) - This window was retained because it is still used by plus (plus) button transactions.

Account conversion diagrams

...