What is the General Ledger cost account retrieval hierarchy in Job Cost?
Description
Cause
Resolution

Job Cost, Accounts Payable, Equipment Cost, Payroll, Purchasing and Inventory retrieve General Ledger cost accounts for jobs based on the retrieval method you select in Job Cost.

Note: If the interface to General Ledger is turned off in Job Cost, the hierarchy will skip Job Cost and continue retrieving based on the hierarchy. For example, a Payroll pay would start the retrieval at the Pay setup instead of in Job Cost.

View or select the retrieval method, as follows:

Note: Due to the interrelation between applications, you would not normally change these settings after you set up Sage 300 Construction and Real Estate. If you have questions about making changes, contact your business partner or Sage customer support.

  1. In Job Cost, from File menu, select Company Settings, JC Settings.
  2. Click GL Entry
  3. View or select the appropriate option in the Retrieval method list.

The retrieval methods available are:

  • By job: The application retrieves the account from the Cost account found in Setup, Jobs, AP and GL. If no account is found here, it uses the Default account in JC Settings, GL Entry
  • By cost code: The application retrieves the account from the Cost account found in Setup, Cost Codes, General. If no account is found here, it uses the Default account in JC Settings, GL Entry
  • By category: The application retrieves the account from the Cost account found in Setup, Category, General. If no account is found here, it uses the Default account in JC Settings, GL Entry
  • Use default: The application retrieves the Default account found in JC Settings, GL Entry
  • Use hierarchy: The application retrieves the account from the first Job Cost source that contains an account. The sequence for retrieval as follows:
    1. Category
      If Categories are used, The Cost account is in Setup, Categories, Select the Job, Cost code and under the General tab
    2. Cost code
      The Cost Account is Setup, Cost Codes, Pull up the Job and Cost Code and look under the the General tab.
    3. Job
      Cost Account if found under Setup, Jobs, AP and GL
    4. Default account
      Default account found in JC Settings, GL Entry.

    Note: For more information on the hierarchy search see the Job Cost Help topic "Use hierarchy cost account retrieval search."

NOTE: If a hierarchy or Job group is changed after a job is set up, the new accounts will not write to existing/already set up jobs. If, for example, the hierarchy is currently set to category and changed to cost code, existing jobs will not have the GL accounts on existing cost codes. The retrieval will then default to the default account from JC settings. The existing jobs will have to have the account added manually to existing jobs at the correct hierarchy level (category, cost code, job). Same goes for Job Group - if job is set up under Group A and changed to Group B - all existing cost accounts will be set up to Group A and will have to be manually changed to Group B.

Defect ID
Steps to duplicate
Related Articles