GL Posting Table F/M (JCF960)

Use this program to create and maintain your own set of GL posting tables. Once you create GL posting tables, you can assign them to each job number so the job transactions post to the correct GL account numbers.

The posting tables determine the general ledger distribution after the printing of various registers throughout the system. Following are how registers use the GL account numbers set up in the JC GL posting tables:

• Sales - may be distributed during the JC Invoice Register.
  
• Accounts Receivable - may be distributed during the JC Invoice Register
  
• Job Cost Receipts - is distributed by the PO Receipt Register when job information is entered for a purchase order.
  
• Work-in-process (WIP) - when posting costing information to job cost from other modules (AP, PR, IC) or from job cost and posting to general ledger. Work-in-process is posted when the post work-in-process flag is set to Y in the JC to GL posting record. The WIP number used is the one assigned to the cost type of the cost code used. Refer to the JC to GL Posting F/M program.
  
• Cost of Goods Sold (COGS) - distributed in the JC Invoice Register if COGS is set to J in the JC to GL posting record. The COGS number used is the one assigned to the cost type of the cost code used. Refer to the JC to GL Posting F/M program.
  

See also

Posting to General Ledger from Job Cost

For more information how to use maintenances, refer to the following topics:

How to use file maintenance programs

Use the following fields to create GL posting tables:

1. GL Posting Table

Enter the General Ledger posting table (up to 3 characters). F2 allows a search.

2. Description

Enter the description of the GL posting table (up to 30 characters).

3. Sales GL #

Enter the sales GL account number to be distributed to after the job cost Invoice Register is printed (used by JC Invoice Register if posting sales by job). F2 allows a search.

4. Accounts Receivable GL #

Enter the Accounts Receivable GL account number to be distributed to after the job cost Invoice Register is printed (used by JC Invoice Register if posting accounts receivable by job). F2 allows a search.

5. Job Cost Receipts GL#

Enter the job cost receipts GL account number to be distributed to after the PO Receipt Register is printed (used by PO Receipt Register if job information entered on a purchase order). F2 allows a search.

Fields 6-14 are user defined. Each field is a cost type from the job cost type file. For each field the user has to enter a GL # for:

WIP debit

Enter work-in-process debit GL account numbers to be distributed. F2 allows a search.

Cost of goods sold

Enter the cost of goods sold GL account number to be distributed. F2 allows a search.