Display Vendor Invoices

Use the AP Inquiry (NI) program to display invoices from vendors and determine payments owed to vendors. See Road Map for work flow.

Enter the vendor number or click the Lookup icon and use the standard lookup options to select the vendor from a list. The program displays the vendor's name, phone number, currency, and tax type: 1099, GST, or No tax.
The Print in summary or detail program option determines the fields initially displayed. You can click Sum/Dtl at any time to switch between modes.

For a summary inquiry, the program displays these fields:

Field Name	Displays
Invoice no	The number for the invoice
Org	The AP organization code for the invoice
Status	Indicates if the invoice is on hold If you use a third-party system to pay AP invoices, Pend is displayed once the invoice has been selected for payment. The status is cleared when PowerShift receives information from the third-party that the invoice was paid.
Invoice amount	The invoice amount
Payment amount	The payment amount
Net amount	The net amount due: Invoice amount - Payment amount
Notes	* (asterisk) indicates that notes for one or more of the invoice distribution lines were entered in AP Invoice Maintenance

For a detail inquiry, the program displays these fields:

Field Name	Displays
Invoice no	The number for the invoice
Trans date	The invoice date
Tr	The transaction code for the invoice: BF: Fixed filling BI: Billing invoice CM: Cash payment DM: Debit memo CP: Check printed
Due date	The due date; for a CP transaction, the posting date
Disc date	The discount date
Disc amount	The potential discount amount
Amount	The transaction amount, including any discounts taken
Payment no	The number of the printed check or the system-assigned payment number
Mthd	The payment method
Reference	The reference for the invoice. The reference is specified when the invoice is entered. If the invoice was system-generated, the PO number or, if it was generated for an ERS receipt, the packing list number (if entered when goods were received) is used.
Status	Indicates if the invoice is on hold. If you use a third-party system to pay AP invoices, Pend is displayed once the invoice has been selected for payment. The status is cleared when PowerShift receives information from the third-party that the invoice was paid.
1099 report amt	If the vendor's tax type is 1099, the invoice amount eligible for 1099 withholding
Org	The AP organization code for the invoice
AP acct no	The AP account number for the invoice
1099 vendor	The vendor where the 1099 will be sent
Post date	The date the payment was posted
Date/time	The system date and time when the posting occurred
Reg no	The GL register
User	The user that entered the transaction
Notes	* (asterisk) indicates that notes were entered in AP Invoice Maintenance

(Optional) Click Prog opts to review your options. To change them:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
2. Click the Sort tab to set sort order.
3. Click the Selection tab to select specific records.
4. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Include history?

Optional

Select to list fully paid invoices that have been moved to history with the AP Transaction Archive (NEX) program or leave blank to omit them.

Print in summary or detail

Optional
1 alphanumeric

Select S to display a summary inquiry or select D to display a detail inquiry when you run the program. You can click Sum/Dtl at any time to switch between modes.

Include O=Open, C=Closed, or B=Both?

Optional
1 alphanumeric

Select which invoices to include:

Select	To display
O	Open invoices only (a non-zero balance)
C	Closed (paid) invoices only (a zero balance)
B or blank	Both open and closed invoices

Include only invoices overdue?

Optional

If you entered O for the Include O=Open, C=Closed, or B=Both? option, select to display only invoices that are overdue or leave blank to display all open invoices.

Select to age on I=Invoice or D=Due date

Optional
1 alphanumeric

Select D to age on the date the invoice is due or select I to age on the date the invoice was entered.

1. Click Save to save these options for future use.
2. Click Refresh to redisplay current options.
3. Click OK to apply these options or click Cancel to exit without applying them.

Choose the appropriate options:

To	Do This
Review you options for this program	Click Prog opts. See step 3.
Print the list of invoices	Click Print. See Print an Inquiry.
Switch between a summary and a detail inquiry	Click Sum/Dtl.
Display only the total amounts and subtotal amounts if you selected Subtotal? for a sort option	Click Totals. Click Totals again to redisplay details.
Display purchase order information for an invoice	Highlight the line and click Purchases or double click the line. See Display AP-Purchasing Detail by Invoice Number. Click OK to return to this program.
Display account distributions for an invoice	Highlight the line and click Invoice. See Display Invoice Distributions. Click OK to return to this program.
Display payment information for an invoice	Highlight the line and click Payment. See Display AP Payments. Click OK to return to this program.
Display journal details for a transaction	Highlight the line and click GL journal. See Display an Interface Journal. Click OK to return to this program.
Display 1099 information for a transaction	Highlight the line and click 1099 info. See Display Invoices for a 1099 Vendor. Click OK to return to this program. This button displays only if the vendor's tax type is GST or 1099.
Display notes	Click Notes.
Display balances for each aging period	Click Age. Click OK to continue.
Specify a different vendor	Click OK.
Exit the program	Click Exit.