Printing General Ledger Reports

The Cost of Goods Sold Batch Report is created from the information in the sales journal file for the period you specify.

Note: You should use this report to create the cost of goods sold batch only if you post A/P information to your inventory account.

When you print this report, you can update your general ledger with this information. If you specify to update G/L with this information, the cost of goods sold batch is created, and the information automatically flows to your general ledger. If you create the batch, the Posted Cost of Goods Report prints. It is a list of all the information that the batch contains.

Notes: The system-generated batch number for cost of goods is 9996.

To post to individual departments in the cost account, you must specify a summary account number in the Cost Control and Cost Inv/Purch field in the (L2) G/L Master Numbers screen. A summary account number always ends with ØØ. If you are using the standard chart of account numbers provided with your system, specify the summary account numbers as follows: 501-00 in the Cost Control field; 104-00 in the Cost Inv/Purch field.

If you do not want to create a cost of goods sold batch, you can follow these same steps to print the To Be Posted To Cost Of Goods Report. You can use it to manually post the information in the General Ledger Posting window.

To build the Cost of Goods Sold Batch:

  1. In the (W) General Ledger Reports screen, select the [E] Build Cost of Goods Sold Batch function.

  2. In the Period From # field, enter the period for which to build the batch. To use the period entered in the Current Period field in the (L2) screen, press Enter.

Note: If you are building the cost of goods batch for a previous year, you must enter period 12 or 13 in the Period From # field. If you enter a closed period, you must enter the password from the Post to Closed Period Password in the General Ledger Close Period Passwords Parameters to continue.

  1. In the Fiscal Year # field, enter the fiscal year. To use the year set in the Fiscal Year field in the (L2) screen, press Enter.

  2. In the Journal field, enter the journal name from which to build the batch.

  3. In the Volume field, enter the volume serial where the journal is found.

  4. In the Cost Type field, enter the cost to use for the batch, according to the following codes:

     

    M

    Manufacturer’s cost

    W

    Wholesaler’s cost

    A

    Average cost

     P  

    Pricing cost

  1. In the Update field, specify whether to create the cost of goods sold batch.

    Type N to not create the cost of goods batch but still print To Be Posted To Cost of Goods Report.

    Type Y to create the cost of goods sold batch and automatically update your general ledger.

Note: The Auto Post field in the (L2) screen must be set to Y for the information to automatically flow to general ledger.

See also:

In the (L2) Screen