Working with A/P Invoice Entry (MAPE)

Purpose: Use A/P Invoice Entry to set up controls for an invoice, select the purchase order against which merchandise has been invoiced or create an invoice, and review the contents of a purchase order receipt.

Entering an invoice initiates aging on the system, and allows you to generate a check for the vendor.

Invoice upload: You can also use the A/P invoice upload to create invoices if you receive invoices from a remote system. See Working with A/P Invoice Upload Errors (WAPU) for an overview.

In this topic:

Enter A/P Invoices Screen (When Using Batching)

Enter A/P Invoices Screen (When Not Using Batching)

A/P Invoice Entry Screen (Selecting an A/P Vendor)

Vendor Selection Window

A/P Select PO by Date Screen

A/P Select PO by Vendor Screen

A/P Select Drop Ship Invoice Screen

A/P Display PO Receipts Screen

Enter A/P Invoices Screen (When Using Batching)

Purpose: This screen allows you to enter batch controls and represents the fields that display when the Batch Entry of A/P Invoices (F02) system control value is selected. See Enter A/P Invoices Screen (When Not Using Batching) for more information on using this screen when the system control value is unselected.

How to display this screen: Enter MAPE in the Fast path field at the top of any menu or select A/P Invoice Entry from a menu.

Field

Description

Date

The date the invoices are posted in the system. The current date defaults, but you can override it.

This date appears on the screens you use to work with a batch. Once you process the batch, this date is used to post to the General Ledger Interface table, and appears in A/P Inquiry as the Posted date and the Activity date for each invoice in the batch.

Numeric, 6 positions; MMDDYY format, required.

Division

The code for the division against which the batch of invoices will post to the General Ledger Interface table. The G/L number for A/P purchases is defined in the Division record.

If you are matching an A/P invoice to a purchase order and there is a Division specified for the warehouse where you received the purchase order, the system uses this division to post to the General Ledger Interface table instead.

Division codes are defined in and validated against the Division table; see Working with Divisions (WDIV).

Alphanumeric, 2 positions; required.

Bank

The code for the bank against which the account transaction for these invoices will be performed. The bank code is important because the bank record includes the A/P Cash G/L number against which this purchase will be posted.

Bank codes are defined in and validated against the Bank table; see Working with Banks (WBNK).

Numeric, 3 positions; required.

Note: At least one of the following fields is required.

Total # invoices (Total number of invoices)

The total number of invoices being entered in this batch. The system will not allow you to accept the batch if the Total # invoices value here does not match the number of invoices you actually enter.

You can change A/P batch totals through the Work with A/P Invoice Batches Screen if you have proper authority.

Numeric, 5 positions; optional.

Total $

The total dollar value of the invoices being entered in this batch. The system will not allow you to accept the batch if the Total $ value here does not match the dollar total you actually enter.

This dollar total includes both merchandise and “other” entries on an invoice. Also, if the Enter Gross A/P Invoice Amount (F03) system control value is selected, this total includes the gross merchandise totals from all invoices, not reduced by any discounts.

You can change A/P batch totals through the Work with A/P Invoice Batches Screen if you have proper authority.

Numeric, 11 positions with a 2-place decimal; optional.

Total units

The total number of units (of merchandise or other, such as an additional charge) associated with all invoices in this batch. The system will not allow you to accept the batch if the Total units value here does not match the number of units on all invoices in the batch.

You can change A/P batch totals through the Work with A/P Invoice Batches Screen if you have proper authority.

Numeric, 9 positions; optional.

Total vnd# hash (Total vendor number hash)

The sum of the vendor numbers associated with the A/P invoices in the batch.

For example, if you are posting invoices for vendor numbers 100, 650, 35, and 62, you would enter 847 in this field. If the batch includes more than one invoice for the same vendor, you would multiply the vendor number by the number of invoices. You will not be allowed to accept the postings if these values do not match.

You can change A/P batch totals through the Work with A/P Invoice Batches Screen if you have proper authority.

If you are using the A/P invoice upload, the system populates this hash total when it creates a suspended batch. Each unique vendor number is included in the hash total just once, even if there are multiple invoices for the vendor. If there are any invoices in the batch in an open or closed status, those vendor numbers are not included in the hash total. See Working with A/P Invoice Upload Errors (WAPU) for an overview.

Numeric, 9 positions; optional.

Total G/L# hash (Total General Ledger number hash)

The sum of the General Ledger numbers to which you are posting A/P invoices.

For example, if you are posting invoices to General Ledger account numbers 10010100, 10020200, 10030300, and 10040400, you would enter 40101000 in this field. If you use the same G/L number on more than one invoice detail line, you would multiply the G/L number by the total number of detail lines.

You can change A/P batch totals through the Work with A/P Invoice Batches Screen if you have proper authority.

If you are using the A/P invoice upload, the system populates this hash total when it creates a suspended batch. The hash total does not include the general ledger number at the invoice header; detail lines only are included. If there are any invoices in the batch in an open or closed status, those general ledger numbers are not included in the hash total. See Working with A/P Invoice Upload Errors (WAPU) for an overview.

Numeric, 10 positions; optional.

Completing this screen for invoice entry:

1. Verify the batch date, or enter a different date if necessary.

2. Complete the Division and Bank fields.

3. Complete at least one of the control fields.

4. Select OK to advance to the A/P Invoice Entry Screen (Selecting an A/P Vendor).

Completing this screen for invoice maintenance of open or held invoices:

1. Verify the batch date, or enter a different date if necessary.

2. Complete the Division and Bank fields.

3. Select Maintain to advance to the Select A/P Invoice Screen (for Maintenance).

Screen Option

Procedure

Maintain open or held (non-batched) invoices

Complete the first three fields and select Maintain. See Maintaining A/P Invoices.

Work with existing A/P invoice batches

Select View Batches. See Working with and Processing A/P Batches.

Generate the A/P Purchase Journal to review the invoices posted or updated on the specified posted date.

Select Purchase Journal. See Printing the Purchase Journals.

Enter A/P Invoices Screen (When Not Using Batching)

Purpose: This screen allows you to enter batch controls and represents the fields that display when the Batch Entry of A/P Invoices (F02) system control value is unselected. See Enter A/P Invoices Screen (When Using Batching) for more information on using this screen when the system control value is selected.

How to display this screen: Enter MAPE in the Fast path field at the top of any menu or select A/P Invoice Entry from a menu.

Field

Description

Date

The date the invoices are posted in the system. The current date defaults, but you can override it. This date is used to post to the General Ledger Interface table, and appears in A/P Inquiry as the Posted date and the Activity date for the invoice.

Numeric, 6 positions; MMDDYY format, required.

Division

The code for the division against which the batch of invoices will post to the General Ledger Interface table. The G/L number for A/P purchases is defined in the Division record.

If you are matching an A/P invoice to a purchase order and there is a Division specified for the warehouse where you received the purchase order, the system uses this division to post to the General Ledger Interface table instead.

Division codes are defined in and validated against the Division table; see Working with Divisions (WDIV).

Alphanumeric, 2 positions; required.

Bank

The code for the bank against which the account transaction for the invoices will be performed. The bank code is important because the bank record includes the A/P Cash G/L number against which this purchase will be posted.

Bank codes are defined in and validated against the Bank table; see Working with Banks (WBNK).

Numeric, 3 positions; required.

Completing this screen for invoice entry:

1. Verify the batch date, or enter a different date if necessary.

2. Complete the Division and Bank fields.

3. Select OK to advance to the A/P Invoice Entry Screen (Selecting an A/P Vendor).

Completing this screen for invoice maintenance of open or held invoices:

1. Verify the batch date, or enter a different date if necessary.

2. Complete the Division and Bank fields.

3. Select Maintain to advance to the Select A/P Invoice Screen (for Maintenance).

A/P Invoice Entry Screen (Selecting an A/P Vendor)

Purpose: Use this screen to identify the purchase order you are paying with the A/P invoice you are about to create, or to enter other identifying information for the invoice if you do not use A/P-PO matching.

Selection options: The information you enter on this screen controls the screen formats and options available for invoice entry:

matching to a purchase order (including drop ship purchase orders): You can review and adjust the item details from the purchase order, work with discounts, and use different methods to select the items you are paying. To use this entry format, you must specify the purchase order you are matching.

matching to a drop ship invoice (if the vendor uses drop ship picks): You can review and adjust item details, but cannot work with discounts or use all the different methods to select items for payment. To use this entry format, you must specify the drop ship invoice number you are matching.

entering an unmatched invoice: You must enter all detail information to be paid with the invoice. To use this entry format, you need only to specify the vendor.

How to display this screen:

• complete the required fields at the Enter A/P Invoices Screen (When Using Batching)

• select Create at the Work with A/P Invoices within a Batch Screen

Field

Description

Batch #

The number that identifies the batch of invoices you are entering. This field appears only if the Batch Entry of A/P Invoices (F02) system control value is selected.

Numeric, 5 positions; display-only, assigned by the system.

Vendor #

A code to identify the supplier of an item or service.

Enter a valid vendor number to advance directly to the Work with A/P Invoices Screen (Entering Invoice Header Information), where you can enter an unmatched invoice for this vendor.

If the vendor number you enter is not valid, you advance to the Vendor Selection Window.

Vendor codes are defined in and validated against the Vendor table; see Working with Vendors (WVEN).

Numeric, 7 positions; optional.

Vendor name

The name of the vendor who provided the merchandise or service.

Enter a full or partial vendor name to advance to the Vendor Selection Window.

Alphanumeric, 30 positions; optional.

P/O #

The number of the purchase order on which you received the merchandise.

Enter a purchase order number to enter a matched A/P invoice. If you enter a:

• valid purchase order number (including a valid drop ship purchase order number): you advance to the Work with A/P Invoices Screen (Entering A/P Invoice Header Information), where you can enter a matched invoice.

• invalid purchase order number: you advance to the A/P Select PO by Date Screen, where you can select a valid purchase order for matching.

Numeric, 7 positions; optional.

P/O receipt date

The date when you received the merchandise ordered on a purchase order. The system captures this information at PO Receiving.

Enter a purchase order receipt date in this field to advance to the A/P Select PO by Date Screen, where you can select a valid purchase order for matching.

Numeric, 6 positions (MMDDYY format); optional.

Drop ship invoice #

The invoice number assigned by the system for a shipment directly to your customer from a vendor.

Enter a drop ship invoice number to enter an invoice matched to a drop ship invoice. See Entering Drop Ship Invoices.

You can use a drop ship invoice number to match an A/P invoice only for vendors who use drop ship picks (the Drop Ship Output field for the vendor is Drop ship pick). If the vendor uses drop ship purchase orders, you enter the purchase order number to match the invoice.

Numeric, 7 positions; optional.

Screen Option

Procedure

Review an existing A/P invoice

Select A/P Inquiry; see A/P Invoice Inquiry (DAPI).

Display batch totals

Select Dsp Batch Totals. This option is available only if you use batch entry (the Batch Entry of A/P Invoices (F02) field in the System Control table is selected). See Working with and Processing A/P Batches.

Accept the batch of A/P invoices, if batching

Select Accept Batch. See Working with and Processing A/P Batches.

Work with invoices in the current batch

Select Work with Invoice. See Working with and Processing A/P Batches.

Vendor Selection Window

Purpose: Use this window to locate the vendor for whom you are entering an A/P invoice.

Vendor Selection by Number

Purpose: This window lists the vendors for your company in numeric order by vendor number, beginning with your entry. The vendor name also displays

How to display this screen: Click on the arrow in the Vendor # field or enter an invalid vendor number:

Vendor Selection by Vendor Name

Purpose: This window lists vendors by name, beginning with your entry. Additionally, the associated vendor number and the number of open purchase orders for each vendor display on the right of the window. The Open POs field indicates the number of purchase orders that have been received, but not invoiced.

How to display this screen: Click on the arrow in the Vendor name field or enter a full or partial vendor name.

A/P Select PO by Date Screen

Purpose: Use this screen to locate and select a purchase order (including a drop ship purchase order) for matching.

This screen lists purchase orders by receipt date. Additionally, the vendor number, vendor name and dollar value of the purchase order display.

If you received more than one shipment against a purchase order, a separate entry appears on this screen for each receipt date. Also, if you created a new A/P transaction while you were entering an A/P invoice that matched the purchase order, an entry for this transaction appears on this screen. The total receipt amount displays next to each entry for a purchase order.

How to display this screen: Click on the arrow or enter information in the P/O # or P/O receipt date fields at the A/P Invoice Entry Screen (Selecting an A/P Vendor).

Screen Option

Procedure

Select the purchase order for matching

Select a purchase order to advance to the Work with A/P Invoices Screen (Entering A/P Invoice Header Information).

Review the contents of a purchase order receipt

Select Display receipt details for a purchase order to advance to the A/P Display PO Receipts Screen.

A/P Select PO by Vendor Screen

Purpose: Use this screen to locate and select a purchase order (including a drop ship purchase order) for matching.

This screen lists purchase orders by vendor number. Additionally, the purchase order number, vendor name, receipt date and dollar value of the purchase order display.

How to display this screen: Click on the arrow or enter information in the Vendor name field at the A/P Invoice Entry Screen (Selecting an A/P Vendor), then select a vendor at the Vendor Selection Window.

Screen Option

Procedure

Select the purchase order for matching

Select a purchase order to advance to the Work with A/P Invoices Screen (Entering A/P Invoice Header Information).

Review the contents of a purchase order receipt

Select Display receipt details for a purchase order to advance to the A/P Display PO Receipts Screen.

A/P Select Drop Ship Invoice Screen

Purpose: Use this screen to locate and select a drop ship invoice for matching. You can match by drop ship invoice number only if the vendor uses drop ship picks (the Drop ship output field for the vendor is Drop ship pick. If the vendor uses drop ship purchase orders (the Drop ship output field is set to Drop ship purchase order, you match by drop ship purchase order number, using the P/O # field at the A/P Invoice Entry Screen (Selecting an A/P Vendor).

This screen lists the drop ship invoices for shipments made directly from your vendors. The invoice number, vendor number, vendor name, invoice date, and dollar value of the drop ship items display on the right of the screen.

How to display this screen: Click on the arrow or enter an invalid drop ship invoice number in the Drop ship invoice # field at the A/P Invoice Entry Screen (Selecting an A/P Vendor). If you enter a valid drop ship invoice number, you advance directly to the Work with A/P Invoices Screen (Entering Invoice Header Information).

Screen Option

Procedure

Select a drop ship invoice for matching

Select an invoice. See Entering Drop Ship Invoices.

Review additional information about the drop ship invoice

Select Display receipt details for an invoice to advance to the A/P Display PO Receipts Screen.

A/P Display PO Receipts Screen

Purpose: Use this screen to review the contents of a purchase order receipt before you enter the associated invoice to pay the vendor for the merchandise or service received.

This screen lists the item, SKU, quantity received, receipt cost, cost extension (cost * quantity), receipt date, and the date the invoice was posted against the PO.

How to display this screen: Select Display receipt details for a purchase order listed on the A/P Select PO by Vendor Screen or the A/P Select PO by Date Screen to verify that the purchase order is the one against which you will enter an A/P invoice. See A/P Invoice Entry Screen (Selecting an A/P Vendor).

MAPE OROMS 5.0 2018 OTN