Purpose: Use this menu option to reset the open A/P amount for each vendor, based on the balance remaining on open A/P invoices for the vendor.
When to run the reset: Normally, you use this menu option only if the A/P open balance is out of balance.
Viewing the open A/P: The open A/P amount is stored in the Open A/P field in the Vendor Extended table and displays on the following screens:
• Display or Change Vendor Extended Screen in the Working with Vendors (WVEN) menu option
• Display A/P Invoices Screen in the A/P Invoice Inquiry (DAPI) menu option
To reset: Enter ROAP in the Fast path field at the top of any menu or select Reset Open A/P from a menu and press Enter.
Note: The system does not advance you to a screen, and instead, automatically submits the Reset Open A/P program.
Determining the open A/P amount: The system looks at the Invoice Detail table to determine the open A/P balance amount for a vendor.
For each invoice detail record that is in an open status for the vendor, the system:
• multiplies the Cost by the number of Units to determine the open invoice amount.
• subtracts the Paid amount from the open invoice amount to determine the open A/P balance for each invoice.
• totals the open A/P balance for each invoice to determine the total open A/P amount for the vendor.
A/P Invoice Detail |
|
Field |
Comments |
Vendor nbr |
A separate open A/P balance amount is totaled for each vendor. |
Status |
The invoice must be in an open status to be included in the open A/P balance. |
Cost |
For each invoice detail in an open status for the vendor, the system multiplies the cost by the number of units to determine the open invoice amount. |
Units |
|
Paid amount |
For each invoice detail in an open status for the vendor, the system subtracts the paid amount from the open invoice amount to determine the open A/P balance. |
Example: The following invoices are in an open status for vendor 202:
Invoice |
Cost |
Units |
Paid Amount |
Open Balance |
2021 |
10.00 |
5 |
30.00 |
20.00 |
2022 |
12.00 |
6 |
.00 |
72.00 |
2023 |
-5.00 |
12 |
.00 |
-60.00 |
2024 |
40.00 |
24 |
100.00 |
860.00 |
Total: |
892.00 |
|||
Results: The system updates the Open A/P field in the Vendor Extended table for vendor 202 with 892.00. |
||||
| A/P Invoice Upload Error List | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Generating A/P Checks |
ROAP OROMS 5.0 2018 OTN