1 Invoice Matching

Welcome to Oracle Retail Invoice Matching

Oracle Retail Invoice Matching (ReIM) allows you to verify merchandise invoice costs and quantities before payment. ReIM receives invoice data through Electronic Data Interchange (EDI), or data can be entered manually.

An automatic matching process verifies Invoice records against associated receipts. If invoices are matched to receipts within tolerance at a summary level, they are evaluated for best payment terms and posted to a staging table. The staging table interfaces with your accounts payable system, where payments are processed and corresponding accounting entries are posted.

If invoices and receipts are not matched at the summary level after a specified period of time, the auto-matching process attempts to match at the line level within tolerances. If matches are not identified at the line level, the process calculates a cost or quantity discrepancy. Discrepancies are routed to defined user groups for resolution. You can resolve discrepancies by applying reason codes based on a set of defined actions (for example, charge-back supplier). The reason codes determine disposition of the discrepancies.

The auto-match process routes discrepancies so that you can begin manual identification of summary and detail level matches. You can resolve line-level discrepancies, and you can also access invoices and receipts.

Navigation

This section describes how to navigate within ReIM. It describes how to:

• Log In and Exit ReIM

• Navigate Within a Window

• Sort and Filter Columns

Log In and Exit ReIM

Note: The way that you access ReIM depends on how the system is set up at your location. Contact your system administrator for instructions. After you have started ReIM, you are prompted to log on to the system.

Log In to ReIM

1. In the Login window, enter your user name in the Username field.

2. In the Password field, enter your password.

3. Click Log In. The ReIM Main Menu window is displayed.

Exit ReIM

1. From any screen in ReIM, click the Log Out button. You are prompted to confirm your decision.

2. Click OK. The Login window is displayed.

Navigate Within a Window

This section describes the navigation within the ReIM window.

Use a Drop-Down List

Some fields can accept values only from a predefined list of options. These fields have a down arrow button on the right side of the field.

1. Click the down arrow button. A drop-down list of options is displayed.

2. Select a value from the drop-down list. The selected option is entered in the field.

Use a List of Values Button

The List of Values button is found to the right of a field. The button displays all defined values or options available for the field.

Note: The list of values is empty if no values have been defined for the list.

1. Click the LOV button. A list of options is displayed.

2. Select an option from the list.

3. Click OK. The selected option is entered in the field.

Sort and Filter Columns

You can sort and filter data so that you can view the information you want.

Filter Information

Many windows use filters. You can use a filter to limit the records listed to those that match a certain criteria.

To select the criteria, choose from the values in the drop-down list associated with the field. You can filter multiple columns at the same time.

To display all records, select *All* from each drop-down list.

Sort Information

Many windows use underlined column headings to sort table data.

To sort the list, click on the underlined column heading of the column you want to use for sorting. You can only sort by one column at a time. An arrow indicates the column that is currently sorted, as well as the sort order.

To reverse the sort order, click the same column heading again.

Flexible Columns

You can customize your window view by clicking on the column button. You can change the columns that are hidden or displayed, or the order in which columns appear. After you rearrange the columns, the window view is the same every time you open the window.

Hide or Display a Column

1. Click the column button to the left of the window name. The Column Ordering Window opens.

2. Figure 1-1 Column Ordering Window

   
   

3. Select a column heading.

4. Use the left arrow button or the right arrow button to move the column heading to the Hidden Columns or the Visible Columns area.

   
   

   Note: Column headings with a double asterisk (**) cannot be hidden.

   
   

5. When the columns are in the Hidden Columns and Visible Columns as desired, click Apply. You return to your previous work area.

Change the Column Order

1. Click the column button. The Column Ordering window opens.

2. Select a column heading. Click the up arrow button or down arrow button to move the column heading order.

   1. Moving the column heading up on the list places it to the left side of the screen.

   2. Moving the column heading down on the list places it to the right side of the screen.

   3. To move a column to the top of the list, select the column heading and click top button.

   4. To move a column to the bottom of the list, select the column heading and click the bottom button.

3. When the columns are in the desired order, click Apply. You are returned to your previous work area.

Comments

In the Comments window, you can add additional information about a specific area of a window.

1. Click Comments. The Comments window opens

   Figure 1-2 Comments Window

   
   

2. In the Usage Type drop-down field, select Internal or External.

3. In the Item field, enter the item ID, or click the LOV button and select an item.

4. In the Comment field, enter your comments.

5. Click Add. Your comment is added to the table.

6. Click OK to save any changes and close the window.