Real Vendor Invoice Dates Feature
|
Overview |
A feature has been added to the Accounts Payable System to enable you to transform estimated expenses into actual expenses. Upon receipt of your vendor’s invoice, you can now · Enter the actual invoice date, · Recalculate the due date based on the vendor’s terms, and · Enter the actual amount owed to the vendor. · In addition, authorized users are able to flag invoices as “approved” for payment to the vendor. (Note: authorized users are established on Page 2 of User Class Maintenance). This feature provides authorized operational staff with the ability to review and authorize payments for accounting. This feature works in conjunction with the A/P aging reports, inquiries, and check scheduling processes. The aging reports and inquiries will age by the actual vendor invoice date, if one has been entered, and the actual vendor invoice amount will become the balance due. Approved items will be denoted by an “A” printed or displayed after the payment date. The Cash Requirements Report can then be run for “approved” items only. The Check Scheduling by Vendor/Date program can be run for only “approved” items, as well. When checks are scheduled, the actual amount will be used to create a final payment on the item and the appropriate G/L offsets will be automatically created. A secondary vendor invoice number has also been added for additional reference. This invoice number can be selected and reported in the inquiry and will print on the Cash Requirements Report. Additionally, the A/R inquiry has been enhanced to display
and print the customer’s check total when an Inquiry by Check is done
including “zero” items. The inquiry will now also display the customer’s FAX
number in the inquiry. The A/P inquiry will display and print the check total
when an inquiry by check is done including “zero” items. It will also display
and print the paid statement total when an Inquiry by Statement Number is
done. Both inquiries will now provide immediate access to the aging totals
and the total balance due. |

|
Overview |
The Vendor Invoice Approval program allows you to flag invoices as “approved” for payment to the vendor. This feature provides authorized operational staff with the ability to review and authorize payments for accounting. Note: Only authorized users are able to
approve invoices for payment. However, the program can still be used to
change billing dates, payment dates, and the actual amounts. (Users are
authorized to approve payments on Page 2 of User
Class Maintenance). Note: An item will not display on the screen if a check has already been applied to it. The following table describes the fields that can be
modified on this screen. |
|
Field Name |
Data Entry |
Comment |
|
Vendor Number |
This field allows you to select a specific vendor associated with the invoices you would like to approve. |
|
|
Vendor Reference |
If you enter a vendor invoice number, only A/P records matching this vendor invoice number will be retrieved. Use this feature to quickly approve and verify an invoice. |
|
|
File Number |
If you enter a file number, only A/P records matching this file number will be retrieved. Use this feature to quickly approve and verify an invoice. |
|
|
Approved Control |
This is the total amount that you will approve. This control total will be checked against the approved totals. You will receive a warning message if the approved total exceeds this control total. |
|
|
Vref |
This is the original vendor reference number entered at
the time of billing. |
|
|
Vend Inv |
Enter a secondary vendor invoice number. |
This is a secondary vendor invoice number that can be used
in the inquiry and prints on the cash requirements report. |
|
Invce Date |
This is the actual vendor’s invoice date. If you enter a new invoice date, the pay date (see below) will be adjusted based on the vendor terms. The invoice date is used to age open items. |
|
|
Pay Date |
Enter a pay date or press ENTER to accept the calculated pay date. |
You may accept the default value to use the calculated pay
date or override the date. |
|
Real |
||
|
Amount |
This is the actual amount owed the vendor for this item. This amount will be used in inquiries and agings as well as check scheduling and entry. |
|
|
Approved |
Only authorized users may approve items for payment. The Cash Requirements Report can be configured to print only approved items. This can also be used in the Check Scheduling by Vendor/Date process to schedule only approved items. |
|
Note |
If an actual amount is entered or changed, the A/P file is
marked with who did the change on what date. If the item is approved, the A/P
file is marked with who did the approval and the date of the approval. |

|
A/P Inquiry |
2ndary Vend Inv field -- The secondary vendor invoice number can be used
to qualify the data retrieved by the A/P inquiry. This option is available if
an inquiry by vendor in date order or by invoice number is selected. Items
that have been approved through Vendor Invoice Approval are highlighted on
the Detail screen (see sample AP Inquiry Detail screen
below). |

|
A/P Inquiry Detail Screen |
Note
items number 13, 14, and 15: “A” displays between the Pay Date and
the Status columns for items that have been Approved for payment. |

|
Check Scheduling by
Vendor/Date |
Check
scheduling of statements and by Vendor/Date provides the user with the
ability to schedule only “approved” items. |

|
AP Report Parameters
Maintenance - CRQ |
The cash requirements report can be configured to print
only approved items by entering Y in the field #05 Approved
Items Only on the Additional Criteria screen. |
|
Overview |
Once a vendor invoice has been modified through the Vendor
Invoice Approval program, the A/P Detail Aging Report will print the item with its new date and
amount. Because of the changes made to
invoice dates and amount, the report cannot be used in balancing the A/P to
the A/P General Ledger account. |
Note: Items that have been approved through the Vendor
Invoice Approval program are highlighted on the report.
TradePoint Systems LLC (C1-D0) AP DETAIL AGING - ACETR (BEG-TODAY) by Vendor APDETAGE-D0-09/29/04 Page: 1
Date: 02/10/2006 Time: 12:44 Company All Report No 150
Non-divisionalized From Division First to Last From Customer First to Last Currency
Showing Paid Items From Vendor AA001 to AA001 From Vendor Type First to Last
Showing Check Recs From Inv. Date 01/01/1900 to 02/10/2006 From Invoice No First to Last
Invoice # Sf Inv Date Inv Amount Balance Due Pay Date St Chck/Stmnt Customer Vendor Inv Bk Expense # Liability Div# Co Age
------------ -------- ------------ ------------ -------- -- ---------- ---------- ------------ -- --------- --------- ---- -- -
1161009124 03/19/06 500.00 500.00 03/30/06 10300301 DAVTRGBMHT 001-70001116 1 501-0003 0200-0000 3 1 **
1161009123 03/20/06 500.00 500.00 04/10/06R DAVTRGBMHT 001-70001131 501-0003 0200-0000 3 1 **
1161009125 03/20/06 500.00 500.00 04/10/06R DAVTRGBMHT 001-70001120 501-0003 0200-0000 3 1 **
1161013490 03/24/06 250.00 150.00 04/05/06 PT 8542 TOOLDIE 00198342331 2 501-0001 0200-0000 1 1 **
1161020737 03/26/06 100.00 100.00 04/09/06 DEVIN 55555 1 0100-0000 1 1 **
1161020739 03/27/06 100.00 100.00 04/09/06 RABBIT 5435234523 1 0100-0000 1 1 **
1161020763 04/05/06 200.00 200.00 04/09/06ASC ROMER ABC763 1 0100-0000 1 1 **
1161020772 04/05/06 200.00 200.00 04/09/06ASC ROMER ABC772 1 0100-0000 1 1 **
1161020774 04/06/06 200.00 200.00 04/09/06ASC ROMER ABC774 1 0100-0000 1 1 **

|
A/P Inquiry by Check |
The inquiries will now display the check amount when an
inquiry by check showing “zero” items has been selected. |

|
User Class Maintenance set-up |
Only authorized user classes can approve payments in the new approval process. To
set up a User Class record to be an authorized user, enter Y in the Approve Payment
field on Page 2 of User Class Maintenance. |