Post Job WIP Value to G/L Batch Job

This batch job posts the Amt. to Post to G/L in the Job Ledger Entry table to the corresponding general ledger accounts. After finishing the batch job, the Amt. Posted to G/L field in the Job Ledger Entry table is filled with the posted amounts. This requires that:

There are two types of job ledger entries: Usage and Sale. The valuation of the job's usage is determined in the Job Usage Posting field. You have the choice to post the job usage as unit prices or as unit costs to the general ledger accounts. In the corresponding manual and in the following examples the job usage posting will be at unit cost.

This batch job creates the following postings at the general ledger:

1. Entry type Usage:

WIP Costs (Balance Sheet)

Job Costs Adjustment (Inc. Statement)




Amount(Unit Cost)




Amount(Unit Cost)






2. Entry type Sales:

WIP Sales (Balance Sheet)

Job Sales Adjustment (Inc. Statement)





Amount(Invoiced Price)


Amount(Invoiced Price)







In case of G/L accounts used during the sale of jobs:

Customer (Balance Sheet)

G/L Exp. Sales Account (Inc. Statement)





Amount(Invoiced Price)


Amount(Invoiced Price)







The batch job also affects G/L accounts. It prints information about your choices on the Options tab Posting Method, Posting Date and Document No. All jobs included in this batch job are printed and totaled at the end of each job.

This batch job shows the contents of the following fields:

Entry No., Entry Type, No., Document No., Posting Date, Usage, Sales

You can define what is included in the batch job by setting filters. You can set additional fields on the tab by clicking the Field field, then clicking the AssistButton that appears to the right. Fill in the fields as follows:


No.: Here you can specify the numbers of the jobs to be included in the batch job. To see the existing job numbers, click the Filter field, then click the AssistButton that appears to the right.

Job Ledger Entry

Entry Type: Here you can determine whether to post using usage or sale type entries to the general ledger accounts. If you leave the field blank, both kinds of entries will be posted.

Posting Date: You can select a certain posting date or a period during which entries have been posted. It is possible to enter a date or a time interval. There are certain rules for how they should be entered:


Sample Expression

Entries Included

Equal to

12 15 00

Only those posted on 12 15 00.


12 15 00..01 15 01

..12 15 00

Those posted on dates between and including 12 15 00 and 01 15 01.

Those posted on 12 15 00 or earlier.


12 15 00|12 16 00

Those posted on either 12 15 00 or 12 16 00. If there are some entries posted each day, all will be displayed.

You are also allowed to combine the various format types:

12 15 00|12 01 00..12 10 00

Entries posted either on 12 15 00 or on dates between and including 12 01 00 and 12 10 00.

..12 14 00|12 30 00..

Entries posted on 12 14 00 or earlier, or entries posted on 12 30 00 or thereafter- that is, all entries except those posted on dates between and including 12 15 00 and 12 29 00.


Posting Method: Here you can decide between posting per job ledger entry or per entire job. When you choose per job ledger entry, you can keep track of each posting in the Job Ledger Entry table.

Posting Date: Here you have to enter the date, when the postings should be done in the general ledger.

Document No.: In this field, you should enter a document number for the entire posting process. Later, you will be able to track the posting with the help of the Navigate function.

Posting Description: This field contains as a default value the text: Posting %1 for Job Posting Group %2 . Upon posting the text, %1, will be replaced with the entry type and the text, %2, will be replaced with the corresponding Job Post Group. The contents can be modified.

Post: Place a check mark in this field if you want the program to post to the general ledger automatically. If you do not choose to post the Job WIP Value to G/L, the batch job will only print a test report, and on the report will appear: Test Report (not Posted).

Click the Print button to print out the batch job. If you want to see the batch job on the screen before printing, click the Preview button. If you do not want to print the batch job now, click Cancel to close the window.

Click the up-arrow in the lower left-had corner to see the results of the filter you have defined for the table.