Purchases Clearing Report

Window Details		How Do I...
	Navigation		Create a Report Setting
	Overview		Print a Report, Form, or Listing
	Fields		E-mail, Fax, or Print a Report as a PDF
	Report Sample		Enter Multiple Values Using Separators

Related Topics
	Purchases Clearing in Open PO Format	Receipt of Goods Entry
	Receipt of Invoice Entry	Product Line Maintenance

Navigation

Select Purchase Order Period End menu > Purchases Clearing Report.

Overview

Use Purchases Clearing Report to simplify month-end reconciliation of the purchases clearing account balance with open amounts on purchase order. The purchases clearing account is a liability holding account that contains inventory received in Receipt of Goods Entry without an invoice until the invoice is posted in Receipt of Invoice Entry. This account is credited when goods are received into inventory and can also include allocated landed cost and sales tax. When the applicable invoice is recorded, it is debited and the corresponding Accounts Payable liability account is credited. This account is assigned to each product line in Inventory Management Product Line Maintenance.

Note This report reflects transactions entered in the Purchase Order module. Any transactions posted to the general ledger account from another module will have to be reconciled separately. For example, invoices entered in Accounts Payable Invoice Data Entry do not affect this report.

You can enter a selection of purchase order numbers, vendor numbers, order dates, last receipt dates, item codes, product lines, inventory account numbers, and user-defined fields (UDFs) to print.

The total purchases clearing amount on the Purchases Clearing in Open PO Format or Purchases Clearing Report will normally balance to the purchases clearing account. An out of balance exception can occur in the following scenarios:

Inventory receipts are updated in Transaction Entry.
The ordered quantity or unit cost is changed after performing either Receipt of Goods Entry or Receipt of Invoice Entry.
Manual postings have been updated to the purchases clearing account.
The Receipt of Goods Register or Receipt of Invoice Register has been updated to an incorrect general ledger period.

Note The total purchases clearing amount in the Purchases Clearing in Open PO Format or Purchases Clearing Report balances to the purchases clearing account as of the date the report is generated provided the report is run with the default sort options and selection criteria.

Fields

Report Setting	Sort Report By
Description	Calculate Purchases Clearing Amount Using
Type	Item Types to Print
Default Report	Operand
Print Report Settings	Value
Three Hole Punch	Printer/Output
Number of Copies	Keep Window Open After Print
Collated	Keep Window Open After Preview