AP1701 Accounts Payable A/P Account File Maintenance

A/P Account File Maintenance

Application Overview

 

Of all the accounts in your General Ledger, only some will be affected by A/P.  They are:

 

              One or more cash accounts;

              One or more A/P accounts;

              A discount taken account (this is a revenue);

             Several expense accounts possibly including miscellaneous charges expense, sales tax expense, and freight charges expense.

 

If you are using the General Ledger package and the Accounts Payable package, you may control where the Accounts Payable package will find the appropriate account in A/P Setup.  If you choose to have the accounts verified from Accounts Payable, then the A/P Account File stores the numbers of all the accounts that will be directly affected by Accounts Payable.  A description for each account is also stored.  When an account number is entered from within the Accounts Payable package, it is checked against this file.  If the account number is not found, the entry is invalid, and the operator must enter a different number.  If the account number is found, the description is displayed on the screen so he can see if this is the intended account.  This greatly reduces the number of operator entry errors that occur on account numbers.

 

The format of the account number is variable.  It can be a single number from one to eight characters, or it can be a triple number with a hyphen, each number having from one to eight characters. See the System Manager manual for a full description of how to set up your account number format.

 

The Import application will allow a range of accounts from the General Ledger Chart Of Accounts File to be imported into the Accounts Payable Account File. This selection appears only if the Elliott General Ledger package is installed.


Run Instructions

 

    Select A/P Account File from the pull-down A/P Maintenance window.  The following screen will then be displayed:




The following options are available:

    • Select the desired mode from the A/P Account File menu bar
    • Enter the data requested on the screen

       To exit press the ESC or F10 key when the cursor is positioned for entry of the first field on the screen.

     

        To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.


    Entry Field Descriptions

     

    Name

    Type and Description

    1.   Account No

    An account number in the standard account number format.

     

    Enter the account number from G/L.

     

    In the change, inquire or delete modes, pressing the F7 key will allow you to search for the main account by number or pressing the F8 key will allow you to search for the account by description.

    2.   Description

    30 alphanumeric characters.

     

    Enter a description of the account number, which will make it clear to the operator at a glance whether or not he has entered the correct number.

      

    List

     

    Name

    Type and Description

    Starting Account No

    An account number in the standard account number format.

     

    Enter the beginning of the range of accounts that you want to list, or press the RETURN key to list All accounts.

    Ending Account No

    An account number in the standard account number format.

     

    Enter the end of the range of accounts that you want to list.

     

    This field defaults to the starting account number to facilitate listing a single account number.


    Import

     

    Name

    Type and Description

    1.  Starting Account No

    An account number in the standard account number format.

     

    This question and the next one (Ending Account No) allow you to specify a range of accounts to be imported from the G/L Account File. If you press RETURN for the entry of the Starting Account No, the field will default to All accounts, and the entry of the Ending Account No will be skipped.

     

    NOTE:  If you have to change a description of an account in G/L and try to import it into A/P, the description will not import.  You must first delete the account in A/P, then import.

    2.  Ending Account No

    An account number in the standard account number format.

     

    If you press RETURN for the entry of the Ending Account No, the field will default to the same value as entered for the Starting Account No.


    Account Search by Number Screen:


    Account File Maintenance Screen:


    Account File List Screen:




    Import G/L Accounts Into AP Account File Screen:






    Accounts Payable

    1. AP0000 Accounts Payable Overview
    2. What Is The Difference Between Payment Date and Check Date during Print AP Check?
    3. How to Purge AP Distribution to GL Report
    4. DYO (Design Your Own) AP Laser Check Design
    5. How Can I Get a List of New Vendors Set Up Since a Certain Date?
    6. Why Doesn't the System Print the Bottom Stub on My Design-Your-Own AP Laser Check?
    7. System Period Control Does Not Apply to Recurring Transactions
    8. AP Check History Report That Includes Voided Check
    9. ERROR 035 on AP TEMP CHK File
    10. Feature - Voucher Criteria On Vendor Account Summary
    11. Feature - Voucher Reference on A/P Distribution to G/L Report
    12. Feature - A/P Simple Trx Processing
    13. AP01S4 Accounts Payable Vendor Audit Trail Report
    14. AP05S1 Accounts Payable A/P Open Item Report
    15. AP07S1 Accounts Payable Cash Requirements Report
    16. AP08S1 Accounts Payable Pre-Check Writing Report
    17. AP08S2 Accounts Payable Post A/P Checks
    18. AP08S4 Accounts Payable Void Checks After Posting
    19. AP10S1 Accounts Payable Check Reconciliation Report
    20. AP11S1 Accounts Payable Check History Report
    21. AP13S1 Accounts Payable Vendor History Report
    22. AP22S1 Accounts Payable Purge AP Open Item File
    23. AP0200 Accounts Payable Post AP Transactions
    24. AP0301 Accounts Payable Recurring Voucher Processing
    25. AP0302 Accounts Payable Post Recurring AP Transactions
    26. AP0400M Accounts Payable Vendor Account Inquiry
    27. AP0601 Accounts Payable Open Item Adjustment
    28. AP0800 Accounts Payable Payment Preparation
    29. AP0900 Accounts Payable AP Distribution to GL Report
    30. AP1001 Accounts Payable Check Reconciliation
    31. AP1200 Accounts Payable Vendor Analysis Report
    32. AP1400 Accounts Payable Job Distribution Report
    33. AP1500 Accounts Payable Job Analysis Report
    34. AP1600 Accounts Payable A/P Setup
    35. AP1701 Accounts Payable A/P Account File Maintenance
    36. AP1801 Accounts Payable FOB Code File Maintenance
    37. AP1901 Accounts Payable Ship Via Code File Maintenance
    38. AP2001 Accounts Payable Job Code File Maintenance
    39. AP2100 Accounts Payable Print/Create 1099 Forms
    40. AP2300 Accounts Payable Clear Vendor YTD Accumulators
    41. APDISSCN Accounts Payable Distribution History Report
    42. APINVIMS Accounts Payable Invoice Import Utility
    43. AP0100 Accounts Payable Vendor File Maintenance
    44. AP0202 Accounts Payable Transaction Processing
    45. FULLPAY Accounts Payable Reset Fully Paid Status
    46. Feature - Default Value For Create Variance Prompt
    47. Feature - Assign Next Manual Check Number in Computer Check Printing
    48. Feature - Added First Bank Export Format to Checks History Export
    49. I Forgot to Clear the AP Vendor Paid Accumulators at Year End
    50. What If I Do Not Run AP Manual Check Register?
    51. Feature - Add Ability to Include or Exclude by Vendor Type for AP Checks
    52. How to Find a Voided AP Check in Check History Report
    53. What Are the Impacts of Purging Accounts Payable Old Inactive Vendors?
    54. Feature - AP Check History CSV Creation
    55. AP Laser Check Layout
    56. How to Apply AP Credit to Voucher When Credit Is Greater Than Voucher Amount
    57. Feature - Add Amigo Support to Additional Transactional Files
    58. Feature - F1 Key Next Manual Check Support in Single Screen Transaction Processing

    Feedback and Knowledge Base