Choosing Posting Options
Since journal entries are transferred to the appropriate accounts in the general ledger during posting, Job Cost contains multiple posting options that allow you to specify the source of your posting accounts. You can also specify how you will post your payroll and options for closing jobs. To print the JC Posting Options report, choose File > Print or choose the printer button.
- Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Job Cost Setup > Posting Options.
- Complete the Cost Code Debit Posting Accounts section by choosing the type of posting account. This allows you to specify where to define general ledger posting accounts for Job Cost transactions.
- Choose Cost Codes if:
- You want to assign a posting account for each cost code when you create a new job.
- You are using the immediate revenue recognition method and you want the ability to assign any general ledger account as the default debit posting account for any cost code assigned to a job.
- You do not post cost transactions to WIP accounts. With this option, you must assign a posting account to each Job Cost code.
- You assign a general ledger posting account while setting up cost codes in the Master Cost Codes Setup window. That account is added to the cost code record when you add cost codes to jobs in the Job Cost Codes Setup window. You can change the general ledger account number assigned to the code at that time.
- You want unlimited posting accounts, one for each cost code.
Choose Division if you are using the percentage-of-completion or completed contract revenue recognition method to post costs to WIP accounts. You can use this option for up to nine general ledger posting accounts, one for each cost element. Choosing this option requires you to assign default cost element posting accounts for each division. Transactions posted to all cost codes for the same cost element in a division update the same general ledger account.
If you are using the immediate revenue recognition method, you can use either the Cost Codes option or the Division option.
- Choose Cost Codes if:
- Choose one of the following Revenue Recognition Methods:
- None
- Percentage of Completion
- POC Calculation Method
You can use either labor hours or costs as the method of POC calculation. The percentage complete for a job is calculated as either Actual Labor Units divided by (Revised) Forecasted Labor Units or Actual Costs divided by Forecasted Costs. This is a global option; your selection applies to all jobs in the system. If you change this option, you must run the Recreate Job Master Summary utility for ALL jobs to recreate all months using the new POC calculation method. You may want to use the labor hours method if you find POC to be misleading when calculated based on cost, reflecting the cost of equipment or materials that are sitting in a warehouse rather than the cost of actual work that has been completed for the job. - Use Job and Project Loss Recognition
For more information on loss recognition and this setup option, see Loss Recognition.
- POC Calculation Method
Revenue Performance Obligations
CAUTION: DO NOT change the Revenue Recognition Method in Posting Options from RPO to POC if you have any active RPO jobs. If the Revenue Recognition Method is changed from RPO to POC, all RPO jobs will be missing from future POC processes. You will not have the ability to run the RPO process to recognize the missing revenue because the RPO fields will no longer be available.
Post Through the GL
Mark this checkbox if you want to post the transaction through the General Ledger. If you are using the Percentage of Completion or Revenue Performance Obligations method, a general ledger journal entry is created each period to recognize revenue and cost of sales. If you do not mark the Post Through the GL checkbox, you need to manually post the transaction stored in a general ledger batch at the end of each month. However, manual posting allows you to print an edit list and review the accounts that update before posting in the general ledger.This option overrides your GP Posting Setup option to allow batch posting only. If you post through the GL, transactions can be posted even without the Allow Transaction Posting GP option marked.
- Sales/Revenue Accounts for SOP Billing From
If you are using the Sales Order Processing (SOP) module to bill jobs, choose the accounts to be updated for billing SOP transactions. Choices include Job Cost and SOP. If you are using the revenue recognition percentage-of-completion posting method, the Job Cost radio button is selected automatically and cannot be changed.- Job Cost
If you choose Job Cost, the accounts set up in the Invoice Accounts Setup window (Microsoft Dynamics GP > Tools > Setup > Job Cost > Account Setup > Invoice Accounts) will be used. - SOP
If you choose SOP, either the item or customer accounts will be used, as set in the Sales Order Processing Setup window (Microsoft Dynamics GP > Tools > Setup > Sales > Sales Order Processing).
- Job Cost
- In the Payroll section, choose from the following options:
Certified Payroll
Mark this checkbox if you create certified payroll reports. If you use Microsoft Dynamics GP Payroll to print your company's payroll checks on a weekly basis and have certified payroll jobs, mark the Certified Payroll checkbox.If you do not use Microsoft Dynamics GP Payroll or do not have certified payroll jobs, leave this option unmarked. This option requires additional processing time during posting.
Rate Class
Mark this checkbox if you want to assign wage rates, benefits, and deductions to union employees, by category, using rate classes. See Setting up Rate Classes for Union Payroll.If you are ONLY using Rate Class to determine the pay rate amount for your payroll transaction, and Union reporting is NOT a requirement, we have added a new option to improve the process performance of running payroll. By adding this line to the Dex.ini file, benefit and deduction records will not be gathered in our tables: DisableRateClassBenefitsAndDeductions=TRUE DO NOT USE this option with the Rate class Prevailing Wage or Highest Wage options.
- Payroll Post Through the GL
Mark this checkbox to post Job Cost payroll batches through the General Ledger. Leave this option unmarked to post payroll batches manually in the General Ledger. A General Ledger journal entry is created automatically each time you post job transactions through Microsoft Dynamics GP Payroll to Job Cost. Payroll Post to Job Cost Only
Mark this checkbox if you do not use Microsoft Dynamics GP Payroll and you want to post Job Cost payroll transactions to Job Cost only. This option allows you to post payroll transactions without building checks first and deletes your payroll batch after posting. If you mark this option, make sure to also mark Payroll Post to Service Only in the Service Management Invoice Options window. Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Invoice Options.If you mark this checkbox, a GL batch will still be created when you post the Job Cost payroll transaction. If you do not want to update the general ledger, you should delete this batch.
- Payroll Post Transaction Summary
Mark this checkbox to create a General Ledger journal entry that totals all payroll transactions for each division. This option is useful if the same employee works on multiple jobs. If you do not mark this checkbox, a journal entry is created for each transaction. - Payroll Overhead Detail Distribution (optional):
Mark this checkbox if you wish to set up unique overhead offset accounts for each individual overhead detail code. An account must be assigned for each division and overhead detail code through the Payroll and Overhead Offset Accounts Setup window (Microsoft Dynamics GP > Tools > Setup > Job Cost > Account Setup > Payroll Offset Accounts).
In the (optional) Estimate Cost section, mark the Estimate Cost by Period checkbox if you would like to estimate your costs by fiscal period. Marking this checkbox disables the Estimate Units and Estimate Amount/Unit fields on the Job Cost Codes Setup window and enables the "+/-" button on the Job Cost Codes Setup window. See Revising estimated costs for information on entering estimates.
Do not change the Estimate Cost by Period option after creating jobs.
In the Close Jobs section, choose from the following:
Closing Jobs Journal Entry
Mark this checkbox to automatically create a closing jobs journal entry in the general ledger when you close a job. This entry credits the WIP accounts and debits the cost of sales for each cost element. The final revenue earned (the total contract amount) becomes a credit to your contract earned closed jobs account and a debit to your progress billings account. The journal entry moves these totals from the balance sheet to the profit-and-loss statement.If you use the completed contract revenue recognition method, you must mark the Closing Jobs Journal Entry checkbox. This option is marked automatically if you are using the percentage-of-completion revenue recognition method.
- Allow Job to Close if Committed Costs
Mark this checkbox to close jobs with committed costs. Post Through the GL
Mark this checkbox to post transactions through the General Ledger.Beginning with Signature 2018 R4, the Post Through the GL option only applies to the legacy Job Close window. If you are using the new Job Close window, you will need to manually post the batch.
- Allow Job to Close if Net Billed not equal to Expected Contract
Mark this checkbox if you want the ability to close a job when the billed amount does not equal the contracted amount. - Allow Job to Close if Net Billed not equal to Cash Received
Mark this checkbox if you want the ability to close a job when the billed amount does not equal the cashed received. - Only Allow Inactive Jobs to be Closed
Mark this checkbox if you do not want users to be able to close active jobs. When this option is marked, opening the Close Jobs window will not temporarily inactivate active jobs. Be aware that in a multi-user scenario, a job may be reactivated by one user while another user is attempting to close it.
- (Optional) To access the additional Job Close Setup window, select Additional from the top navigation and then select Job Close Setup. Use the Job Close Setup window to disable filters, indicate the columns that display related to jobs and projects, and to enable users to save a job close schedule. See Additional Job Close Setup for more information.
- Choose Save.