About Unit Code Reporting

These are the basic assumptions of unit code reporting throughout the system.

Account Structure

The account structure in the system is:

  • Account - Main account
  • Unit Code 1 - Department
  • Unit Code 2 - Product Code
  • Unit Code 3 - User Defined
  • Unit Code 4 - User Defined

Account is part of the account template, unit codes are not. Any unit code can be tied to a main account, provided the Chart of Accounts setup allows that chart record access to that unit code.

Chart of Accounts

On the Chart of Accounts, you can set each unit code with one of these three attributes:

  • Not Accessible: The Reporting Unit field is not accessible for this account in the system. If this option is selected, the unit code is not posted. The system also disables the corresponding Unit Code tab on the form.
  • Accessible: The Reporting Unit field is accessible for this account everywhere in the system. If this option is selected, you may enter that unit code for the associated account, but it is not mandatory.
  • Required: The Reporting Unit field is required for this account everywhere in the system. If this option is selected, you must enter the unit code for the associated account. An error occurs if you leave the unit code blank when one is required. If no unit code is entered, posting fails.

Inventory Transactions

For transactions involving inventory distribution accounts, the unit codes are pulled from Item Stockroom Locations.

Labor Posting

(Debits) From Job Header WIP Accounts (Cost Detail) Account UC1 UC2 UC3 UC4
WIP Material XXXX XXX XXX XXX XXX
WIP Labor XXXX XXX XXX XXX XXX
WIP Fixed Overhead XXXX XXX XXX XXX XXX
WIP Variable Overhead XXXX XXX XXX XXX XXX
WIP Outside Services XXXX XXX XXX XXX XXX
(Credits) From Work Center of Operation (Dept of WC) Departments record Account UC1 UC2 UC3 UC4
Direct Labor Expense XXXX XXX XXX XXX XXX
Fixed Labor Overhead Applied XXXX XXX XXX XXX XXX
Variable Labor Applied XXXX XXX XXX XXX XXX

In standard costing, variance transactions use Unit Code 2 from the Product Codes form General tab. For labor rate variance, it also uses Unit Code 1 from the Departments form. Other unit codes are pulled from the Product Codes form Variance tab.