Purchase Accrual Balance by Period

Form ID: (PO402000)

The inquiry form shows documents (purchase receipts, purchase returns, and AP bills) that were created by using the purchase order functionality and posted to the inventory and AP subledgers. The inquiry form facilitates the reconciliation of the purchase accrual account with the general ledger.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
View Unreleased IN Documents Opens the Release IN Documents (IN501000) form in a new browser window

Selection Area

You can use the settings in this area to narrow the range of documents listed in the table.

Element Description
Company/Branch

The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access. This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.

Vendor The vendor specified in the document. By default, this box is blank.
Period The posting period. The inquiry form shows documents that were posted in financial periods earlier than or the same as the selected financial period. By default, the system inserts the current posting period.
Account The control account for the purchase order functionality to which the transactions are posted. If only one PO control account is configured for the purchase order functionality, the system inserts this account by default. If multiple control accounts are configured in the system or only non-control accounts are configured, the Account box is blank by default.
Subaccount The subaccount of the specified account. By default, this box is blank.
Show Details By Line A check box that indicates (if selected) that the Warehouse, Inventory ID, and Description columns appear in the table. If the document in the table has more than one line, each line is displayed as a separate record in the table on the current form.
Unbilled Total The sum of all amounts in the Unbilled Amount column on the current form.
Not Received Total The sum of all amounts in the Not Received Amount column on the current form.
Drop-Ship Total Not Invoiced The sum of all amounts in the Drop-Ship Amount Not Invoiced column on the current form.
IN Adjustment Total Not Released The sum of the IN Adjustment Amount Not Released column on the current form.
PO Accrued Total The sum of the PO Accrued Amount column on the current form.
Table 1. Table Columns
Column Description
PO Type

The type of the purchase order for which the purchase receipt, purchase return, or AP bill was created and released. This column can have the following values:

  • Normal
  • Drop-Ship
  • Project Drop-Ship
PO Ref. Nbr. The reference number of the purchase order for which the purchase receipt, purchase return, or AP bill has been created and released. When you click the link, the system opens the purchase order on the Purchase Orders (PO301000) form in a new browser window.
Document Type

The type of the document. This column can have the following values:

  • PO Receipt
  • PO Return
  • AP Bill

If a drop-ship purchase order has a purchase receipt and AP bill released, the system displays the AP Bill value in this column.

Document Number The reference number of the document.
Document Date The date of the document.
Vendor The vendor specified in the document.
Vendor Name The description of the vendor specified in the document.
IN Document Ref. Nbr. The reference number of the inventory issue generated for the document.
Post Period The post period of the document.
Branch The company or branch for which the document has been created.
Account The account to which the transactions are posted.
Subaccount The subaccount of the control account.
Unbilled Amount

The unbilled amount in lines with stock and non-stock items in purchase receipts and returns for which no AP bill has been released.

For AP bills, this value always equals zero.

Not Received Amount

The unreceived amount in lines of an AP bill created and released for purchase orders of the Normal or Drop-Ship type.

For purchase receipts and returns, this value always equals zero.

Drop-Ship Amount Not Invoiced The amount in lines of drop-ship purchase receipts that have been billed to the customer and posted to the AR subledger, but have not been billed to the vendor.
IN Adjustment Amount Not Released

The sum of amounts of PPV and tax adjustments that are generated for an AP bill and are not released yet.

PO Accrued Amount The amount of a document that debited or credited the PO accrual account. The positive value indicates that the control account was debited. The negative value indicates that the control account was credited. This amount is grouped by subaccounts—that is, if a document contains several lines with different subaccount selected, the inquiry form shows a separate line with the same document for each subaccount.
IN Document Type

The type of the inventory document generated for the document. This column can have the following values:

  • Issue
  • Receipt
Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
PPV Adj. Ref. Nbr. The reference number of an unreleased PPV adjustment generated on the release of an AP bill.
Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
Tax Adj. Ref. Nbr. The reference number of an unreleased tax adjustment generated on the release of an AP bill.
Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
Warehouse The warehouse specified in a line of a document.
Inventory ID The inventory ID of an item in a line of a document.
Description The description of an item in a line of a document.