<< Click to Display Table of Contents >> Navigation:  Report Dashboard > PO by Cost Center - Report Writer > Description and Usage

The PO by Cost Center Report will gather all Purchase Journal entries for a given date range, Department and/or Purchase Order range. It will print all of the General Ledger entries associated with the first PO in the selection, which will be determined by looking at the Invoice Number and then to the PO Number. In this case the General Ledger number may be duplicated on the report because it would have one line entry for each General Ledger number, Invoice Number and PO Number. There also could be different General Ledger's on the same invoice for the same PO, in which case each General Ledger for this department would print on its own line. This report will sort first by cost center, then account number sequence, and then by date.

 

After all General Ledger number's have printed for the given PO Number, the PO Detail will print. This will include every item on the PO, as there is no way to associate only certain items with certain General Ledger entries. The dollar amounts on the PO will not all add up to the dollar amounts of the General Ledger entries. The PO number could be on the report multiple times if it has General Ledger entries for multiple departments and those multiple departments are selected when running the report.

 

The Report Writer application allows the user to filter, sort and manipulate this report so that they may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.

 

 

PO by Cost Center - Report Writer

 

 

 

 

 

Listed below is an explanation of each column:

 

•Co. (Company Number): Lists the company number where the General Ledger account number is retained.

 

•GL#: Lists the General Ledger account number the PO is hitting.

 

•Description: Lists the General Ledger account description from the Chart of Accounts.

 

•Date: Transaction Date for each entry made to the General Ledger account number.

 

•Memo: Pulls from the Memo field used in Transaction Entry for additional information.

 

•Reference: Pulls from the Reference field used in Transaction Entry for additional information.

 

•Journal: Journal Type of each entry, which is determined by the entry source. Only Journal Type "PJ" will pull to this report.

 

•CSNum: Displays the assigned CS Number of the individual who made the General Ledger entry.

 

•Batch: This is a unique number assigned by the system that represents which batch the entries were posted to. This number will change each time the Transaction Edit List is moved to permanent file.

 

•Seq.: Unique number assigned by the system that represents the order in which the entries affected the General Ledger account number.

 

•Amount: Dollar amount of each entry.

 

•PO #: Purchase Order number associated with the General Ledger entry.

 

•Page: Page the item resides on the PO.

 

•Item: Charge item number that was expensed to the listed General Ledger number on the PO.

 

•Description: Description of the charge item number.

 

•Ordered: Oordered quantity entered on the PO.

 

•Received: Received quantity entered during PO Reconciliation.

 

•Invoiced: Iinvoiced quantity entered during Invoice Entry.

 

•Cost: Pulls the cost of the charge item number from page 2 of the Item Master.