This chapter contains the following topics:
Introduction to Load A/R Open Items
You use the Load A/R open items selection to transfer outstanding accounts receivable items from your former A/R program or manual system directly into A/R Open Items. No other A/R data is affected by this selection.
This selection is not under batch control and does not require posting.
Converting to PBS Accounts Receivable
Once all outstanding items have been entered and you have converted over to the PBS Accounts Receivable module, you no longer need Load A/R open items (Enter). Current accounts receivable activity is entered through Invoices, Cash receipts and Miscellaneous charges. Invoices, credit memos and payments may also be entered and posted to open items from Order Entry, Point of Sale and Customer Orders.
Editing Existing Open Items
Use this selection with caution when editing existing open items. There is no edit list, posting report or audit trail. You may only want to provide access to this menu selection for administrative users.
|
Note |
You may use this selection to view and modify the Terms, Due date, Amount-1, Amount-2, P.O.#, and Reference for most existing open items. For invoice type open items you may also modify the Sales rep and Commission fields if sales reps and commissions are used. However, it is highly recommended that you do not change the Amount-1 and Amount-2 fields. Changing an amount will not be reflected in distributions. If you need to reverse or adjust an amount, enter the appropriate credit memo, debit memo, negative cash receipt or whatever applies to the situation. Also, for changing the apply-to number or due date, we recommend that you use the functions in Open items (Change apply-to number or due date). |
You may want to print a list of your A/R open items using Reports, general (Open items) as the report lists open items created by all A/R functions, not just by Load A/R open items (Enter).
Follow these steps to change over from your former system to the PBS Accounts Receivable module:
| • | Determine the cut-off date to be used. The cut-off date is the latest date for items that you will enter (load) here. For example, if you choose a cut-off date of 3/31, you will enter open items dated 3/31 and earlier. |
| • | Enter these items into the A/R Open Item file through Load A/R open items (Enter). |
For open item customers, enter the items separately for proper aging and discounts. If you don’t want the A/R module to do aging or calculation of discounts, you may enter only the customer balances as of the cut-off date.
| • | Run Set customer account balances, as described in that chapter. This is the only time that you will ever use this selection, unless you are restoring your Customer file following loss of the original file. |
| • | The changeover is complete. Enter all open items after the cut-off date as new transactions, using Invoices. |
Select
Load A/R open items from the Utility menu.
The following screen appears:
From this screen you can work with both new and existing open items.
Enter the following information:
1. Customer #
Enter the customer number for the open item. For an existing entry, you may also use one of the options:
|
<F1> |
For the next open item entry on file |
|
<SF1> |
For the previous entry |
Options
You may use the option:
|
Format |
12 characters. The default is the customer number of the previous entry in this session, if there was one; if not, there is no default. |
|
Example |
Type 200 |
2. Doc date
Enter the document date of the open item.
|
Format |
MMDDYY. The first time you reach this field, the default is the current date. Thereafter, the default is the previously-entered document date. |
|
Example |
Type 30315 |
3. Doc #
Enter the document number of the A/R open item. You may leave this field blank, in which case a cash payment is assumed. Cash displays in this field, Payment displays in the next, and the cursor moves to Field #5.
|
Format |
8 characters, in the format defined as the Default doc # format in Control information. If a valid format is entered the numeric portion of the document number is incremented automatically with each entry. |
|
Example |
Type 3002 |
4. Doc type
If your entry for the previous field was blank for Cash, this field is automatically set to P.
Otherwise, enter the document type for this open item:
| • | B balance forward |
| • | F finance charge |
| • | C credit memo |
| • | P payment |
| • | D debit memo |
| • | R returned check |
| • | I invoice |
| • | N prepaid payment |
|
Format |
One letter from the list above. The default is I. |
|
Example |
Press <Enter> |
The entry of a Layaway type payment must originate from Point of Sale as it must be assigned to a specific invoice in Point of Sale. To edit an existing layaway do so in Point of Sale as well. A layaway type can only be changed if it has not been posted. When this is the case you must reverse the payment and enter a new layaway payment.
5. Apply-to #
Enter the number of the document to which this document applies. Any entry is accepted, and no test is made that this is a valid invoice.
Open Item Customers
For an invoice, debit memo, balance forward document, or finance charge, the document number (Field #3. Doc #) is automatically repeated here and the cursor skips this field. In the case of a debit memo, it is not always true that the two are the same; so you may have to change the apply-to number from Field number to change ?.
For a credit memo, payment, or returned check, an apply-to number may be entered. The field may also be left blank, in which case the word Open displays to indicate this is an open credit on account (not applied to a specific invoice).
Balance Forward Customers
The apply-to number is only meaningful for open-item customers, but nevertheless appears on balance-forward customers for all document types except payments (for which this field is always blank). For other document types, the document number (Field #3. Doc #) is automatically repeated here and the cursor skips this field.
|
Format |
8 characters |
|
Example |
(Displays automatically in this example because this is an invoice) |
New and Existing Entries
If an open item exists for the values entered in Fields #1 through 5, its values will display in the remaining fields and the cursor will move to Field number to change ?. No two entries can have the same values for these five fields.
If no open item already exists for these values, this is assumed to be a new entry and the cursor moves to the next field to continue data entry.
6. Terms
For a credit memo, payment, finance charge, or balance forward document, this field is skipped.
For a debit memo, this field is automatically set to the customer’s usual terms and may not be changed.
For an invoice, any valid terms code may be specified:
| • | When editing an existing open item the cursor is positioned in the field as usual. |
| • | When entering a new open item data entry is in two steps. First choose one of the options: |
|
<F2> |
To default to the customer’s usual terms code from |
|
<Enter> |
To override the customer’s terms code. The cursor moves back to Field #6 to allow data entry. |
Options
<F1> and <SF1> are not available, but <F8> may be used to view all valid terms codes.
|
Format |
3 characters |
|
Example |
Press <F2> |
7. Due date
Enter the date when the invoice, debit memo, or finance charge is due to be paid, or when the payment or returned check was supposed to have been paid. A valid date must be entered or defaulted for all document types.
|
Format |
MMDDYY. For an invoice the default is the due date computed from the terms code in Field #6. For a finance charge, there is no default. For all other document types, the default is the document date from Field #2. |
|
Example |
Press <Enter>. Since this customer’s payments are due in 25 days, a date of 03/28/15 is displayed. |
8. Amount-1 and
9. Amount-2
Enter these two amounts, which have the following meanings for different document types:
| Document type | Amount - 1 | Amount - 2 |
|---|---|---|
|
Invoice |
Discountable amount |
Non-discountable amount |
|
Balance forward |
Full amount |
N/A (forced to zero) |
|
Payment |
Cash receipt amount |
Discount + Allowance |
|
Finance charge |
Finance charge amount |
N/A (forced to zero) |
The total of Amount-1 and Amount-2 displays automatically upon entry of both.
|
Format |
999,999,999,999.99- at each field. A minus sign is not required for credit memos and payments. The software will deduct the amounts of these document types from a customer’s balance. |
|
Example |
Type 715.45 for the discountable amount Type 69.42 for the amount not subject to discount. |
10. P.O. #
Enter the customer’s purchase order number. This field is optional.
|
Format |
15 characters |
|
Example |
Press <Enter> |
11. Reference
Enter comments appropriate to the A/R open item. This field is optional.
|
Format |
25 characters |
|
Example |
Type Regular purchase |
12. Sales rep
If you specified in Control information that you do not employ sales representatives, or that you do not pay them by commissions, this field and the next do not appear on the screen at all. Such is also the case if you base commissions on sales rather than on payments.
Otherwise:
| • | If this document is a payment, a returned check, or a finance charge, this field displays as Not applicable and may not be entered. |
| • | If this document is an invoice, a debit / credit memo, or a balance forward, enter the code of the sales representative entitled to receive the commission. |
When entering an existing item, the cursor is positioned in the field as usual.
Options
When entering a new item, data entry is in two steps. First choose one of the options:
|
<F2> |
For the customer’s usual sales rep from Customers, displayed in Field #12. The cursor then moves to Field #13. |
|
<Enter> |
To override the customer’s sales rep. The cursor moves back to Field #12 to allow data entry. |
<F1> and <SF1> are not available, but <F8> may be used to view all valid sales representatives.
|
Format |
3 characters |
|
Example |
(This field does not appear in this example) |
13. Commission
This field appear on the screen, and can be entered, whenever Field #12 can be entered.
Enter the amount of the commission which will become due to the sales rep when this open item is fully paid (as discussed in the chapter titled Fully Paid Open Items). No default value is calculated and your entry is not checked against Fields #8 and 9.
|
Format |
99,999,999.99- |
|
Example |
(This field does not appear in this example) |
Field number to change ?
Make any needed changes, then press <Enter> to process another entry. For an existing entry, you may also use one of the options:
|
<F1> |
For the next open item entry |
|
<SF1> |
For the previous entry |
|
<F3> |
To delete this entry |
Options
Changes to Fields #1 through 5 are allowed for new entries but not existing ones. Even for new entries, any attempted change which would result in a duplicate entry is rejected.
This report lists all A/R open items currently on file, not merely those entered by Load A/R open items (Enter).
Select
Open items from the Reports, general menu.
The following screen appears:
Graphical Mode
Character Mode
Enter the following information:
Starting customer # and
Ending customer #
Specify the range of customer numbers to appear on the report. You may also use the option:
|
<F2> |
For the First starting customer or Last ending customer |
Options
You may use the option:
|
Format |
12 characters |
|
Example |
Press <F2> at each field |
Select OK to print the report or Cancel to return to the menu without printing.
Character Mode
Any Change ?
Respond Y to re-enter the screen, or N to print the A/R Open Item File Edit List.