Integrate to GL

Integrate Work in Progress to the General Ledger. Create a Work In Progress batch on demand. The batches will be placed in the list of unposted GL Batches. To complete the integration procedure you must post the batches.

• Summarised - integrate to GL by producing a batch that transfers totals only per Job from JC to the GL codes specified for Job Groups.
• Detailed - integrate to GL by producing a batch that transfers on a transaction by transaction basis to GL codes specified for Job Groups.
• Not integrated - will not integrate to GL.

The amounts transferred to GL are calculated according to the Work In Progress basis selected (see below) and can be reported on the Work In Progress Detail report and Job Balances Report. As there are various ways of valuing Work In Progress, this may not always be the required answer. To value Work In Progress differently do not integrate to GL - enter the correct journals manually.

If you change from Not integrated to Summarised or Detailed, you will be prompted for a Period to start the integration from. If transactions before the period that have not been transferred to GL exist, they will be marked as Transferred to GL without creating a GL batch. This process can take some time.

GL Closing Work In Progress Account

GL Work In Progress Account

Default GL Accounts for JC Job Groups.

Note: When you change Integration GL Accounts, on Save you will be prompted to apply the Integration GL Account changes to any Job Groups that have matching GL Accounts.

Consolidate WIP for related Jobs

When Selected, the decision for whether related Jobs have WIP to transfer to GL is made at a consolidated level.

i.e.

For Work In Progress Basis Cost

Sum(Actual Cost for Related Jobs) - Sum(Recovered Cost for Related Jobs) > 0.

For Work In Progress Basis Sell

Sum(Actual Costs for Related Jobs) - Sum(Recovered Sell for Related Jobs) > 0.

Note: Selecting or Unselecting the setting will apply the change to Active and Hold Jobs at next transfer to GL and will potentially result in GL batches for prior periods.