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.

 

Vendor Invoice Approval screen:

 

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

Enter the vendor code.  If you press ENTER the program will start with the first vendor code in the file.

This field allows you to select a specific vendor associated with the invoices you would like to approve.

Vendor Reference

Enter the vendor reference or press ENTER to leave the field blank.

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

Enter the file number or press ENTER to see all files.

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

Enter the approved control amount. 

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

You may modify the Vendor Reference number, if necessary.

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

Press Enter skip the field or enter a new invoice date. If you have previously entered an invoice date, press ENTER to default the same invoice date into the field.

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

Enter the real pay date.

You may default the real pay date or enter a date to override it.

Amount

Enter the actual amount.

Note: You cannot change the billing amount if the G/L number is set up with a N in the A/P Final Payments field.

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

Enter Y to approve an individual item or enter APPR in ACTION field to set up ALL items on the screen as 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 Inqury screen:

 

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:

 

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 screen:

 

Check Scheduling by Vendor/Date

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

 

 

A/P Report Parameters screen for Cash Requirements Report (CRQ):

 

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.

 


A/P Detail Aging Report (AGE)

 

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.

 

Sample A/P Aging Report (AGE):

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 Inqury by Check:

 

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 (Page 2) screen:

 

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.

 

Copyright © 2006 TradePoint Systems LLC                                                                    [last revision date: 4/7/06]