Job Cost cost account retrieval
Description
Cause
Resolution

Information

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

If you turn off the interface to General Ledger in Job Cost, the hierarchy skips Job Cost and continues retrieving based on the hierarchy. For example, a Payroll pay starts the retrieval at the Pay setup instead of in Job Cost.

If you change the hierarchy or Job group after you set up a job, the new accounts won’t write to existing jobs. Due to the interrelation between applications, you don't normally change these settings after you set up Sage 300 Construction and Real Estate. If you have questions about making changes, contact your Sage Consultant or Sage Support.

Retrieval Methods

Determine the retrieval method.

  1. Log into Sage 300 CRE as an administrator.
  2. Go to Job Cost, File, Company Settings, JC Settings.
  3. Click GL Entry on the right.
  4. View or select the appropriate option in the Retrieval method list.

Available retrieval methods

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

  • By job: The application retrieves the account from the Cost account found in Setup, Jobs, AP and GL. If it doesn't find an account 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 it doesn't find an account 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 it doesn't find an account 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 is as follows:
    • Category
      The Cost account is in Setup, Categories, select the Job, Cost code and under the General tab
    • Cost code
      The Cost Account is in Setup, Cost Codes, select the Job and Cost Code and under the General tab
    • Job
      Cost Account if found under Setup, Jobs, AP and GL
    • Default account
      Default account found in JC Settings, GL Entry
Steps to duplicate
Related Solutions