AROLOAD Accounts Receivable A/R Open Item File Maintenance

A/R Open Item File Maintenance

Application Overview

 

The A/R Open Item File is the file where all transactions that occur between you and your customers are stored.  As such, it is a very im­portant file.  Any time you want to know how much a customer owes you or how old an account is, the programs will refer to this file to find out.

 

Initial setup of the Accounts Receivable package will require entering all open items that are outstanding at the present time with your cus­tomers.  The A/R Open Item File application is where you will do this data entry.  This may be a considerable amount of data entry, but is necessary to set your customers’ balance and provide some detail on the customers’ statements.

 

When you finish entering the initial contents of the A/R Open Item File, you can then run the Set Customer Account Balance application.  This application will read through all transactions for each customer, totaling them up as it goes.  It will then set the Account Balance field in the customer's record to this total.  This is a handy way to ensure that the customer's account balance as stored in his Customer record actually agrees with the contents of his account.

 

You should also be aware that the transactions you enter into a cus­tomer's account will not be posted to any Sales or Accounts Receivable account in the General Ledger, to any salesman in the salesman file, to any record in the commissions due file, or to any file other than the A/R Open Item File.  If you are also using the General Ledger package, you will have to make manual entries into these accounts that correspond to the Sales and Accounts Receivable figures entered here.

 

Once you have entered into the A/R Open Item File its initial contents, you will probably never use this application again.  From that time on, all sales transactions will be entered by way of the Sales Processing application and all payments will be entered through Cash Receipts processing.

 

These transaction applications will automatically record the amounts that are to be posted to General Ledger.  You will no longer have to make manual entries to G/L once you start using Sales and Cash Receipts processing.

 

What does an open item mean?  It is a record of some transaction in the customer's account that has not yet been fully paid off.  For example, if a customer made a purchase from you in the amount of $500 the record of this transaction in the A/R Open Item File is called an open item.

 

Even when the open item is fully paid off, it still remains on file until you decide it is time to remove it.  Elliott does not automatically remove every open item that is paid off from the Open Item File.  The invoice and all payments that have been applied to it are kept on file.  Otherwise, the statements that you send to customers would not properly reflect all the business activity that has transpired.  When you have printed statements and are convinced that they are accurate, then run the Purge Closed Open Items File application to remove all fully paid open items.

 

Document Types

 

There are six different types of transactions that can be stored in the A/R Open Item File.  When you are entering data during A/R Open Item File Load, one of the fields you will have to enter is the open item type.  The six types of open items are:

 

I = Invoice.  This is the record of a regular sale.  The $500 purchase your customer made from your company would be recorded by way of an invoice.

 

P = Payment.  A payment transaction is the record of a payment made by the customer on their account.  If the customer sent you $300 toward the $500 he owes you, the record of the $300 payment would become a payment transaction.

 

C = Credit Memo.  A Credit Memo is a transaction recording some sort of credit you are giving the customer, usually because some of the goods sold were found to be unsatisfactory upon receipt.  Perhaps some of the goods were damaged or found not to be exactly what was ordered.  In this case, you would give the customer credit against the amount of the original invoice by entering a Credit Memo.

 

D = Debit Memo.  A Debit Memo is a transaction recording some sort of an additional charge that is to be added to the customer's account.  For example, let us say that the price of the sale was negotiated with the customer based on a certain shipping method, which later on turned out not to be fast enough, and a  faster (and more expensive) method of shipping was used.  You could charge the customer for this additional expense by entering a Debit Memo, which will add to the amount the customer owes you for the sale.

 

F = Finance Charge.  A Finance Charge is an amount the customer owes you because he has open items on his account, which are too long over­due.

 

B = Balance Forward. This type of transaction is not one that you will deal with very often, especially after you have entered the initial contents of the A/R Open Item File.  The purpose of this type of trans­action is to allow you to enter a single amount that the customer owes as of a certain date, without having to enter all the detail that com­prises that amount.  For example, when you are first loading the A/R Open Item File, you may not want to enter every outstanding open item for every customer.  Instead, you could enter just one Balance Forward transaction for the total amount of what the customer owes you at that time.

 

Note:  This should only be used for Balance Forward Customers.

 

Apply‑To Numbers

 

If a customer uses Open Item accounting, he will usually designate which open items he is paying when he sends a payment for his account.

 

In other words, he applies cash to particular open items.  The way Elliott keeps track of this is by storing in the payment trans­action the invoice number of the sale transaction that is being paid.

 

The invoice number that is being stored in the payment transaction is called its apply‑to number.  Then, Elliott can determine that a payment was made on a certain invoice by looking at the Apply‑To Number field of the payment.

 

Also, Credit Memos and Debit Memos usually apply to an invoice.  Be sure that you enter the correct apply‑to number when you enter Credit Memos and Debit Memos.

 

For Invoices and Balance Forward transactions, the program will automatically set the apply‑to number equal to the document number.  You will be allowed to change this assigned apply‑to number, but there is no reason to do so.

 

One important thing to keep in mind is that if the customer uses Bal­ance Forward accounting, then he does not apply cash payments to par­ticular invoices.  For this reason, the concept of apply‑to numbers is not pertinent to a Balance Forward customer.  Elliott will auto­matically set the apply‑to number for all transactions for a Balance Forward customer to zero.  You will be allowed to change this apply‑to number if you wish, but there is no reason to do so.

  

Run Instructions

 

Select Open Item File from the pull down A/R Maintenance window.  The following screen will then be displayed:

 

 

A/R Open Item File Maintenance Entry Screen

 

 

 

The following options are available:

  • Add initial open items
  • Change initial open items
  • Delete initial open items
  • Print an open item edit listing

 

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

 


Entry Field Descriptions

 

Name

Type and Description

1.  Customer No

6 alphanumeric characters.

Enter the customer number.  This customer number can contain alphanumeric characters as well as purely numeric digits.

The customer's name will be displayed automatically.  After the entry of the first customer number, this Customer No field will default to the last customer entered.  This is done to speed up data entry when you are entering a series of open items for the same customer.

Press the F7 key for customer search by number.  Press the F8 key for customer search by name.

2.  Doc Date

A date in the standard date format.

Enter the date of the document.  Default is system date.

3.  Doc No

6 numeric digits (999999).

Enter the document number.

4.  Doc Type

1 alphanumeric character.

Enter one of the following characters to designate what type of transaction this is:

I               =              Invoice

P              =              Payment

C              =              Credit Memo

D              =              Debit Memo

F              =              Finance Charge

B              =              Balance Forward

The default for the document type is I for Invoice.

5.  Apply‑To‑No

6 numeric digits (999999).

If this transaction is a payment, credit memo or debit memo, enter the number of the invoice to which the transaction applies.  Other­wise, the program will automati­cally assign the apply‑to number.

6.  Terms Code

2 alphanumeric characters.

Enter the terms code for this open item.  This field defaults to the Terms Code for this customer in the Customer File.

Press the F7 key to search for a code.

7.  Due Date

A date in the standard date format.

Enter the due date.  This field defaults to a calculated due date which is based on the document date and the customer's terms.

8.  Salesman No

3 alphanumeric characters.

Enter the salesman for this open item.  This field defaults to the Salesman No for this customer in the Customer File.

Press the F7 key to search for a code.

9.  Amount‑1

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99

-).

The meaning of this Amount‑1 field and the next field called Amount‑2 will vary depending on what type of transaction you are entering as follows:

If you are entering an Invoice, Credit Memo or Debit Memo, Amount‑1 will be the amount of the sale minus any sales tax, freight charges or miscellaneous charges.  Enter for Amount‑2 the total of any sales tax, freight charges or miscellaneous charges.

If the transaction is a Payment, Amount‑1 will be the amount of cash being applied to the customer's account.  Enter for Amount‑2 the amount of any discount you are giving the customer along with the amount of cash being applied.

If the transaction is a Finance Charge, Amount‑1 will be the amount of the finance charge and Amount‑2 will automatically be skipped.  It does not have any pertinence for a Finance Charge.

If this is a Balance Forward transaction, enter into Amount‑1 the customer's account balance.  Again, the system will skip the Amount-2 field.

10.  Amount‑2

8 numeric digits with 2 decimal places and an optional minus sign (999,999.99-).

See Amount‑1 above for an explanation of what to enter for this field, depending on what type of transaction you are entering.

11.  Reference

30 alphanumeric characters.

Lower case letters are allowed.     What you enter here for the Reference field is entirely up to you.  Usually the field is used to record some brief explanation of the transaction or to make some comment about it.

The default reference consists of a brief description of the trans­actions.  For example, if you enter an invoice and you press the return key for the reference, the program will insert a default of:

CUST# XXXXXX  INV#  999999


 

 

 

Date filled out __________ by __________  ADD  CHANGE  DELETE

 

                     A/R OPEN ITEM FILE LOAD SHEET

 

 1.  Customer No     _ _ _ _ _ _

 

 2.  Doc Date        _ _ / _ _ / _ _

 

 3.  Document No     _ _ _ _ _ _

 

 4.  Doc Type        _       I = Invoice        F = Finance Charge

                             C = Credit Memo    P = Payment

                             D = Debit Memo     B = Balance Forward

 

 5.  Apply-to No     _ _ _ _ _ _

     

 6.  Terms Code      _ _

 

 7.  Due Date        _ _ / _ _ / _ _

 

 8.  Salesman No     _ _ _

 

 9.  Amount 1       $_ , _ _ _ , _ _ _ . _ _

 

10.  Amount 2       $_ _ _ , _ _ _ . _ _

 

11.  Reference       _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

                     _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

 

Date entered __________ by _______  Date verified __________ by _______

 

 

 

 

 

  

A/R Open Item File List For Customer 100

 

 

 

 

 

 

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Refund customer open credit / overpaid
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File
  78. NSCTLMN2 Accounts Receivable Global Setup 1
  79. NSCTLMN2 Accounts Receivable Global Setup 2
  80. NSCTLMN2 Accounts Receivable Global Setup 3
  81. NSCTLMN2 Accounts Payable Global Setup 1
  82. NSCTLMN2 Accounts Payable Global Setup 2
  83. NSCTLMN2 Accounts Payable Global Setup 3
  84. NSCTLMN2 Accounts Payable Global Setup 4
  85. NSCTLMN2 Accounts Payable Global Setup 5
  86. NSCTLMN2 Accounts Payable Global Setup 6
  87. NSCTLMN2 Accounting Global Setup: Index
  88. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  89. What Does the Asterisk Mean in A/R Account Inquiry?
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd
  93. Change - Sync Order Addresses in Customer Change Program
  94. Feature - Append Re-Apply Cr/Dr Memos Info To Log File
  95. Feature - Zone Breakdown Method by Freight Pay Code and State
  96. Feature - Enter Customer in Maintenance and Inquiry Event
  97. Feature - Added Phantom Locking to Customer File Maintenance

Feedback and Knowledge Base