Accounts Payable - List of Enhancements

Over the lifespan of the Accounts Payable system, a number of major enhancements and minor fixes have been applied.  Following is a brief summary, (listing the most recent items first).

Show/Hide Hidden Text

New and Different – Enhancements and Fixes in A/P

    For 2010

Canadian HST/GST

For Canadian companies, when entering A/P Transactions, the GST amount associated to a payable's invoice was automatically computed.  As of July 1, 2010, both British Columbia and Ontario are switching to a Harmonized Tax system, (where the provincial tax, and the GST taxes are combined as a single tax).  The A/P Transaction entry routines have been revised to reflect the new HST Tax.   (Jul-01-2010)

A/P Period Analysis Report/Inquiry

Normally this analysis may be executed for Calendar Months, Calendar Years, G/L Fiscal Periods or G/L Fiscal Years.  If you do not have the Series 5 General Ledger system, the Fiscal Years or Periods are undefined.  The routine has been enhanced to not offer these dates if the G/L system is not used.  Previously, an error was reported and the system exited the function.   (Feb-02-2010)

 

    For 2009

Quick Check and New A/P Transaction Entry

When entering the A/P Expense Account associated to a vendor's Invoice Transaction, it was possible to exit the entry screen with a ZERO account number.  This would result in having an undefined, ZERO, account being posted.  The problem has been fixed. (Dec-22-2009)

A/P Check Printing to Tractor Form Printers

Where a check is being printed on a tractor form feed printer, requiring more than one page, the Date line and the VOID literal line were being printed one line below the point that they were supposed to.  The actual check face with the amount was correct. The problem has been fixed. (Dec-18-2009)

A/P Period Analysis Inquiry/Report

The option to export data to spreadsheet has been enhanced.  There are up to 10 different types of data that may be output to an Excel spreadsheet.  Each type will now be output to it's own worksheet within the Excel workbook.  (Dec-11-2009)

Functions Exporting to Excel Spreadsheets

For those functions that export data to Excel spreadsheets, the following enhancements have been made:

 

When titles are output, they will be formatted as bold in 14-point
When legends are output, they will be formatted as bold in 12-point
When headers are output, they will be formatted as bold and italic
Dollar amount data column will be formatted for "Currency", (where $ signs will be displayed with 2 decimal places)

 

The following applications have been revised accordingly, where applicable (Dec-10-2009) :

 

A/P Open Items Report – With output to Spreadsheet – (with new default filenames of AP_Open_Summary or AP_Open_Detail)
Historic A/P Open Items Report – With output to Spreadsheet
Bank Fraud Interface – Format for Excel Spreadsheet
A/P Distributions Inquiry – Export function
Vendor Analysis – With output to Spreadsheet
Vendor Maintenance – Properties Export – (with a new default filename of Vendor_Properties)
A/P Period Analysis – Export functions

User Interface to A/P Invoices

A new option has been added that  offers the option to have a Pre-Load Summary report generated.  Used when interfacing a Columnar input file, (from spreadsheet, or tab-delimited, or CSV files).  These files contain transactions for a number of different Series 5 Company Systems.  The Pre-Load Summary read the input file, and identifies each of the companies for which transactions are to be loaded.  The report lists each company, the number of transactions, and the number of Vendors and G/L Accounts that have not been set up in each company's A/P.  It also lists the Vendor Codes and Names that are undefined. (May-1-2009)

Voiding A/P Checks

When an A/P check is Voided, the items that it had paid are re-instated as Open Items that will be eligible to be paid.  In the past, these Open Items were being flagged as being "Selected to be Paid".  Now, they will NOT be flagged.  To have them paid, they will have to be selected in the normal fashion. (April-24-2009)

Voiding Manuals, Prepaids and Quick Checks

In the A/P Check Processing Grid Screen, all unposted checks including computer generated, manuals, prepaid and "Quick" checks are listed.  In the past, computer checks could be voided directly from this screen.  The system has been enhanced so that now unposted Manuals, Prepaid and "Quick" checks may now be voided from this screen, (from the pop-up menu when the particular row is right-clicked).   (April-24-2009)

Integrated On-Line Help

On-Line Help is now available for all Accounts Payable applications functions. (April-23-2009)

User Interface to A/P Invoices

If when interfacing A/P Vendor Invoice transactions from a user developed invoicing system, undefined Expense Accounts were loaded, the system identifies the accounts with a message on the edit list as "**** Undefined Account Identified ***.    If a blank Expense account is read, the system will assign the account as 888888-88888. Also, the interface routine has been revised so that these transactions will now be copied into the selected A/P Transaction Batch, even though undefined expense accounts were found.  The theory is that it is easier to add the A/P Account to the A/P, after being interfaced. (April-15-2009)

A/P Period Analysis Inquiry/Report

Integrated Help has been introduced to the Period Analysis function.  (April-07-2009)

A/P Period Analysis Report        

When the analysis was executed, work files were created using the users' PID Id #.  If the user left the A/P system, then returned to the Period Analysis system later, if they did not get the same PID number allocated, they were not seeing the correct analysis work files.  Now, the 1st 10 characters of the user's signon name will be used in the name of the work files, so they will always be guaranteed to see the correct files. (April-07-2009)

A/P Vendor Bulk Email Generator Function

When emails are generated, the message may contain a number of different pseudo variables.  These get replaced with specific fields from the Vendor's properties records.  These pseudo variables may now be displayed on a tabbed screen that may be selected when specifying the assorted options. (March-25-2009)

"Quick" Check Entry Function

The Series 5 system provides the ability to indicate the default printer queue and print options to be used when "Quick" checks are generated.  These were not being defaulted correctly.  The problem has been fixed. (March-18-2009)

A/P Vendor Code Entry

In a number of different A/P functions where a Vendor code needs to be entered, the field used to enter the code has been increased in size.  In some cases where a PC's resolution was set for large fonts, it was not large enough to display all 6 characters. (March-18-2009)

Check Processing

After checks have been generated and printed, and before being posted, the checks are displayed in the grid.  Double-clicking a given row produced a screen that displays the check along with the items that are being paid.   For computer generated checks, the vouchers being paid were not being listed. This problem has been fixed. (Mar-04-2009)

Historic Check Register Report

As a new selection filter, you may now select to list only checks that had a Payee Name that was different from that of the Vendor's Name. (Feb-27-2009)

Electronic Invoices Interface

This function has been enhanced to provide the option of interfacing from a flat sequential file, from a columnar tab-delimited or CSV file, or from a MS Excel spreadsheet.  For each type of input file, two types of records are input; one for the Vendor and Invoice detail, and one for the assorted Expense Distributions that may apply.  This function becomes a useful means of entering your employee Expenses that may have been recorded to a 3rd party's web based application. (Feb-25-2009)

A/P Transaction Entry

The function to "Replicate a given Transaction into a Series of Transactions" has been enhanced.  You may now have a series of transactions automatically generated based on an Interval of a Quarter of a Year. (Feb-06-2009)

 

    For 2008

A/P Transaction Entry

When entering an A/P Transaction, (including "Quick" Checks, and Re-Occurring Transactions), the logic and screen for entering the A/P Expense Distribution Account has been enhanced.  You may now enter the Account directly into the field presented. (In other words, a separate window is no longer displayed).  The new field is presented as a drop-down list, that you can either enter the account # directly, or choose from the 10 most recently entered accounts.  When entering the account number each segment of the Account number may  be separated with either a Space, or the "-" character. (Nov-21-2008)

Fraud Interface (Positive Pay) Files for Banks

The Fraud Interface properties of a given Bank Code has been revised.  You may now specify a number of different formats that the interface file can be generated for.  The system supports a Tab-Delimited ASCII text file, an Excel spreadsheet, a custom layout for Northern Trust banks, and a custom layout for JP Morgan Chase banks.  The routines that generate the Fraud Interface files has been revised to output the correct format, for the Bank Code that is selected. (Nov-21-2008)

"Quick" Check Entry Function

Two problems were identified.

1.If while entering a Quick Check, the operator may choose to exit and save the data entered as a Draft Quick Check, prior to it being printed.  However when returning to load that Draft Quick Check, the system did not load the data correctly.
2.If there was more than one Invoice entered to be paid by the Quick Check, attempting to edit a previously entered Invoice, prior to the check being printed, reported a message that the Invoice was not on file.

Both these issues have been fixed.  After installing the release with this fix, it will be necessary to first delete the data file named APQUICKCHKS.DAT before selecting the Quick Check entry function.  (This file is used only to store draft QuickChecks) (Nov-20-2008)

Historic Check Register Report

As a new selection filter, you may now select to list only checks valued either greater than or less than an operator entered value. (Nov-18-2008)

Vendor Maintenance

If a vendor Listing is generated, that is sorted grouped by one of the possible fields, the Accounts Payable amount was not being accumulated.  Also, the totals that were printed after each occurrence of the selected group were not being cleared, so the totals printed were an accumulated total.  These problems have been fixed. (Nov-16-2008)

On-Line Help

The Accounts Payable system now has On-Line Help.  You can access these help files from the application's screens or menu bars. (Aug-01-2008)