Account Detail Inquiry

This program (Customer AR Inquiry) can be found on the Accounts Receivable Inquiries menu (AR-2-1), Billing Inquiries menu (BI-2-1), Collections Inquiries menu (CO-2-1), Order Entry Inquiries menu (OE-2-4), and the Tele-Sales Inquiries menu (TS-2-1). It allows you to view a customer's full Accounts Receivable detail. This includes the current Accounts Receivable balance and Accounts Receivable history. Any valid customer can be accessed either by customer number, phone number, or alpha search. The total amount due and aging breakdown is also included. Options include the ability to view and change the Customer Message (MESSAGE.DT) file. A specific invoice number can also be entered and the detail of the invoice displayed. There is also the ability to enter a specific date range and view the AR detail found within the specified date range. You may also view only current open invoices with a balance greater than zero, or view only invoices with a balance of zero that are considered paid records.

Following is a screen display of the customer account, which shows the dollar amount for each invoice and the aging period at the bottom of the screen:

The AR Account Detail Inquiry provides the ability to view a customer's full Accounts Receivable detail. This includes the current AR and AR History. The current AR and AR History can also be printed through the inquiry. Any valid customer can be accessed either by customer number, phone number, or an alpha search. The total amount due and an aging breakdown is also included.

Within the inquiry are numerous features and options. They include the display of and the ability to change the Customer Message File. A specific invoice number can also be entered and the detail of the invoice displayed. There is also the ability to enter a specific date range and view the AR detail found within the specified date range. You may also view only current open invoices with a balance greater than zero, or view only invoices that have a balance of zero and are considered paid records.

Enter Data

Cust.No/Phone No

To exit the program, enter an E or END.

There are three ways to access a customers AR. The first is to enter the bill to customer account number. The second is to enter the phone number that is stored in field 8 of Customer File Maintenance. The third is to enter an alpha search of the customer name.

When at least one alpha character is entered, the program performs an alpha search. Up to 20 alphanumeric characters can be entered. The Customer File is searched. If a customers name matches or begins with the input, that customer name is displayed on the customer choice screen. The following is displayed for each alpha customer choice selection.

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No/Phone No K

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

No Customer Name Address City St

1 K&L OFFICE EQUIPMENT 2121 VAN DEUREN ST GREEN BAY WI

2 KEARNY MESA TOYOTA 2350 MAIN ST MESA AZ

3 KEESTER'S CORNER 887 STATE ST SW SEATTLE WA

4 KEESTER'S OTHER CORNER 502 WINTERHAVEN DR NE SEATTLE WA

5 KELLER, NAVIN 289 COLLEGE BUR VT

6 KMART HIGHWAY 16 LA CROSSE WI

Select Customer Choice Or E'nd:

No A computer-assigned line number.

Customer Name The customer name that matches the alpha input.

Address The first address line from the Customer File.

City The customers city from the Customer File.

St The customers state from the Customer File.

Enter Data (Contd)

One of the following prompts appears:

Select Customer Choice Or End:

Display Next, Select Customer Choice, Or End:

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No/Phone No THE

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

No Customer Name Address City St

1 THE ABC SUPPLY COMPANY 424 NORTH 11TH ST LACROSSE WI

2 THE ACCOUNTING FIRM 3458 MADISON ST LA CROSSE WI

3 THE BROSTROM 1515 CTH. 29 LA CRESCENT MN

4 THE COPIERS ARE US 355 4TH STREET LA CROSSE WI

5 THE DEPARTMENT STORE 1341 MORMON COULEE ROAD LA CROSSE WI

6 THE HOWARD S. BECK CO. 1919 TOWER DRIVE LA CROSSE WI

7 THE HOWARD TROUT CO 3678 WESTON VIEW LANE LA CROSSE WI

8 THE HUNT CLUB ATTN: JIM BROWN LA CROSSE WI

9 THE HUNT CLUB 2 345 TENT AVE LA CROSSE WI

10 THE LA CROSSE BOATING CO. 1230 MISSISSIPPI RIV. DRV LA CROSSE WI

11 THE MALL OF AMERICA P.O. BOX 99 MINNEAPOLIS MN

12 THE MILTON INN 3876 MILTON DRIVE LA CROSSE WI

13 THE OTHER WORLD 1500 GEORGE ST LA CROSSE WI

14 THE OTHER WORLDS 1800 WORK AVE LA CROSSE WI

15 THE ROLLING MEADOW CLINIC SUITE 700 LA CROSSE WI

16 THE SECOND WORLD 2041 NINE ST LA CROSSE WI

Display N'ext, Select Customer Choice, Or E'nd: N

The first prompt appears when there are less than 17 customer choices. The second prompt appears when there are more than 16 customer choices. Enter a carriage return to accept the default of a N for next. The next screen of selections appears. Enter an E to exit the alpha search. The cursor returns to the Cust.No/Phone No prompt. Enter the computer assigned line number that corresponds with the desired customer choice selection. (3 Alphanumeric)

When entering a N for next, the next screen of alpha customer choices appears. This prompt displays.

Display Next, Previous, Select Customer Choice, Or End:

Enter a carriage return to accept the default of a N for next. The next screen of selections appears. Enter an E to exit the alpha search. The cursor return to the Cust. No/Phone No prompt. Enter the computer-assigned line number that corresponds with the desired customer choice selection. Enter a P to go back one screen of customer selections. Once the last screen is reached, the following prompt appears.

Enter Data (Contd)

Display Previous, Select Customer Choice, Or End:

Enter an E to exit the alpha search. The cursor returns to the Cust. No/Phone No prompt. Enter the computer-assigned line number that corresponds with the desired customer choice selection. Enter a P to go back one screen of customer selections.

If a line number is entered that does not exist, the prompt Selection Is Out of Range appears. The cursor returns for reinput. A line number from a previous screen can be re-entered without it being displayed.

Once a valid account is selected or input the Customer Message File is searched. This is the Customer Message File that is shared by Service Call, Order, and Invoice Entry. If a Message File exists, the message is displayed. See the example. The cursor is at the following prompt.

CR To Continue

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No/Phone No 2223344

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

CONTRACT ON 2004 COPIER, SERIAL # 58 INCLUDES ALL SUPPLIES.

CUSTOMER IS PRICE LEVEL A, EXCEPTION IS FAX PAPER, WHICH IS AT $45.00

A CASE

'CR' To Continue

Enter a carriage return, and the customers AR account detail is accessed.

There is an unlimited amount of message lines that can be on an account. Fourteen message line can be displayed on one screen. If there are more than 14 message lines, the following prompt appears.

Display Next Page (Y/N)

Enter a Y for yes to display the next page of messages. Enter a N for no not to display the next page. A N for no accesses the customers AR account detail.

Enter Data (Contd)

The Customer Message File can be modified within the Account Detail Inquiry. To modify the Message File, enter MSG at the Cust. No/Phone No prompt. The MSG is entered instead of an account number or alpha search. The program than chains to the Customer Message File Maintenance program. The following prompt appears.

Enter Procedure Type Add Change Delete End

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No/Phone No MSG

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

Enter Procedure Type A'dd C'hange D'elete E'nd

Customer Number :

Notes: ^ = Go Back 1 Space

/ = Cancel

Enter an E to exit the Customer Message File Maintenance program. The cursor returns to the Cust. No/Phone No prompt. Enter an A to add a Customer Message File. Enter a C to change an existing Message File. Enter a D to delete a Message File. The cursor proceed to the following prompt.

Customer Number:

Enter the desired customer number on which the message is to be added or changed or deleted. A / to cancel or an up arrow key to go back one space returns the cursor to the Enter Procedure Type prompt. When an invalid customer number is entered, the prompt Invalid Customer appears. The cursor returns for reinput.

Adding a Customer Message

If the customer number that is entered as an add already has an existing message, the prompt Message Already Exists displays. The cursor returns to the Enter Procedure Type prompt. A change has to be done. When a successful customer is entered, this prompt appears.

Enter Message - CR To Continue

Enter Data (Contd)

Adding a Customer Message

Enter Message - CR To Continue

Input the desired message. Each line can be 74 alphanumeric characters long and there is an unlimited amount of lines. Enter a carriage return to end the adding of the messages. The cursor returns to the Enter Procedure Choice prompt.

Changing A Customer Message

If the customer number that is entered as a change does not have an existing message, the prompt Message Does Not Exist appears. The cursor returns to the Enter Procedure Type prompt. An add has to be done. When a successful customer is entered, the existing message lines are displayed. Thirteen message lines display per screen. Each message is assigned a computer line number. If there are more than 13 lines, the prompt Display Next Page (Yes, No) appears. Enter a Y for yes to display the next page of message lines. Enter a N for no not to display the next page of message lines.

When the last screen is reached or a N for no is entered or there are less than 14 message lines, the following prompt displays.

Enter Add - Change - Delete - CR To End Message

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No/Phone No MSG

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

Enter Procedure Type A'dd C'hange D'elete E'nd C

Customer Number : 7856200 MISSISSIPPI BOAT SERVICES

1 ) THIS IS A CUSTOMER MESSAGE FOR 7856200.

2 ) THEY ARE OPEN ONLY ON TUES THRU FRIDAY.

Enter A'dd - C'hange - D'elete - 'CR' To End Message

Enter Data (Contd)

Changing A Customer Message (Contd)

Enter Add - Change - Delete - CR To End Message

Enter a carriage return to exit that Customer Message File. The cursor returns to the Enter Procedure Type prompt.

Enter an A to add additional lines to the message. This prompt appears.

Enter Message - CR To Continue

Input the desired message. Each line can be 74 characters line and there is an unlimited amount of lines. Enter a carriage return to end the adding of the message lines. The cursor returns to the Enter Add - Change - Delete prompt.

Enter a C to change an existing message line. This prompt appears.

Enter Message Number To Change - End

The existing message lines are displayed along with the computer-assigned number. Enter an E to exit the change mode. The cursor returns to the Enter Add - Change - Delete prompt. Enter the computer-assigned line number that corresponds with the message line you wish to change. This prompt appears.

Enter New Message

A 74 character message can be entered. A carriage return changes the message to a blank message.

Delete A Customer Message

Enter a D to delete an existing message line. This prompt appears.

Enter Message Number To Delete - End

Enter an E to exit the delete mode. The cursor returns to the Add Change - Delete prompt. Enter the computer-assigned line number which corresponds with the message line you wish to delete.

Enter Data (Contd)

Delete A Customer Message (Contd)

While doing a change or a delete of a line number and it does not exist, the prompt Selection Is Out Of Range, Please Enter # Thru # appears. The message tells you the valid range of line numbers. The cursor returns for reinput of a line number.

At the Enter Procedure Type prompt, enter a D for delete. The entire Customer Message File is deleted. The following prompt appears.

Please Verify Delete Cancel

Enter a D to delete this Customer Message File. Enter a C to cancel the delete. Remember the Customer Message File is shared by the Service and Order departments. DO NOT change or delete messages that were created for those departments.

Enter Data (Cont'd)

Once a valid account is selected or input, the customers AR account detail is accessed. If a ship to account or a customer is input that has no current Accounts Receivable records, the following prompt appears.

Customer Has No Current AR -- Master AR = ########

Customer AR Inquiry 4/03/97 Dated 4/03/97 By MDG

Cust.No. 7818047 MG OFFICE SUPPLIES, INC. ONALASKA AR Bal. .00

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

Credit Limit 100000

Terms 2% NET 10 P.O. Required

Customer Has No Current AR -- Master AR = 7818047

The bill to account number is listed. If it is different than the ship to account, try accessing that account number.

When a valid account is accessed and has AR detail, the cursor is at one of the two following prompts.

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd N

Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd N

If there is only one screen of AR detail or there is no AR detail, the Display O'ptions E'nd prompt appears. If there is more than one screen of AR detail, the Display N'ext P'revious O'ptions E'nd N prompt displays. Entering a N for next or a carriage return to accept the default of a N, accesses the next screen of AR detail. Entering a P for previous on the first screen redisplays the first screen. When the next screen is accessed, the following prompt appears.

Display Next Previous Options End N

Enter a N proceed to the next screen of AR detail. Enter a P for previous to go back one screen. When the last screen is reached, this prompt appears.

Display Previous Options End

Enter a P to go back one screen of AR detail.

The following information is displayed on the AR Account Detail Inquiry screen. See the example.

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 22437.61

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

Cust.No. The bill to customer number, name, and city.

AR Bal. The current AR balance on the account. This appears on every screen of the account.

Inv.No The invoice number of the AR record.

Company Number and AR Item Type The company number that was assigned to the invoice. The item type that was assigned to the invoice. Only invoice and credit memo type transactions have an item type.

Tac Transaction Accounting Code. This is the type of transaction.

Tdate The transaction date. This is the invoice date on an invoice or credit memo record. This is the transaction date on an AR transaction such as an ART or PMT.

Amount This is the amount of the transaction for that specific line.

Paid This is the amount paid for that specific line.

Enter Data (Cont'd)

Balance This is the balance of the invoice for that specific transaction. If there is more than one line of transactions for an invoice, you must look at the very last transaction record to find the ending balance of the invoice. See the following example. In the example, the invoices 94985 and 94994 have two transaction lines. For invoice 94985, the first line has the Tac code of INV (Invoice), which has a balance of 343.32, and the second line is a PMT Tac code (Payment). The balance is zero so the balance column is blank. For invoice 94994, the first line has the Tac code of INV (Invoice), which has a balance of 1249.88, and the second line is a PMT Tac code (Payment). The actual current balance of 649.88 is on the second line.

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 22437.61

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00

94988 1S INV 42497 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

Display N'ext P'revious O'ptions E'nd N

C/M.No Credit Memo Number

Ref Any reference that was assigned to the record. This can be a purchase order number, contract number, or an installment number. It also is any reference entered during the Cash Posting program. The Cash Posting program also inserts a date when more than one payment record is applied to an invoice.

Lstpmt The last payment date on that specific transaction line.

Enter Data (Cont'd)

O For Options

Specific Invoice #

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd N

Display P'revious O'ptions E'nd

The operation of a N for next and a P for previous is described on page 324. Entering an O for options produces this prompt.

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 22437.61

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

Display N'ext P'revious O'ptions E'nd N

An up arrow key may be entered to go back one space. The options mode is exited. The cursor returns to the Display N'ext P'revious prompts.

There is the ability to enter a specific invoice number. This is very helpful on a large account when you are checking on a specific invoice. Rather than searching through all of the screens for the invoice, the invoice number can be entered at the above prompt. See the following example.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 21437.61

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd 95002

If the invoice that is entered is found on the account, the record is displayed. If there is more than one transaction line for the invoice, all of the transactions are displayed. The cursor is at the following prompt.

Press 'CR' To Display Invoice Inquiry

Customer AR Inquiry 6/04/97 Dated 6/04/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 21437.6

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

95002 1E INV 50197 86.10 86.10

Press 'CR' To Display Invoice Inquiry

A carriage return is the only acceptable entry. This chains the program to the Invoice Inquiry. If the invoice header and line items have not purged, the invoice detail is viewable.

The cursor is at one of the three following prompts.

Next, Goto Last Screen, Serial Number Linkage, End

Previous, Serial Number Linkage, End

Serial Number Linkage or End

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Next, Goto Last Screen, Serial Number Linkage, End

Previous, Serial Number Linkage, End

Serial Number Linkage or End

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 5836 1 3/27/97 1 10 10 2 94458

Shipping Date Order Date Order Number

3/27/97 3/27/97 4733

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From Co 1

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200

-----------------------------------------------------------------------Br # 2

Ln Item No. Description Ord Shptd B/O UM Ext.Price

1 TONER CASE OF TONER 2 1 1 CT 55.00

WH# 1

2 LMS-K129 15000 COPY KIT 1 1 EA 128.25

WH# 1

3 1 * THE ITEMS LISTED BELOW ARE INCLUDED IN THE ABOVE PRICE.

4 1 * THE SUPPLIES WILL LAST FOR 15,000 COPIES.

5 * 946-181 TONER - BLACK 6 6 EA 84.00

Subtotal 208.25

Freight .00

Sales Tax 13.54

Total 221.79

N'ext, G'oto Last Screen, S'erial Number Linkage, E'nd N

The first prompt appears if the invoice inquiry exceeds more than one screen. The second prompt appears when the last of multiple invoice detail screens is reached. The third prompt appears when only one screen of invoice detail is available. Enter a N to display the next page of detail. Enter a G to display the last of invoice detail screens. Enter a S to access the serial number linkage screen. Enter a P to display the previous page of detail when paging through the inquiry. Enter an E to exit the inquiry. The cursor returns to the Next Previous Options End prompt.

Entering a G displays the last of several invoice detail screens. The Previous, Serial Number Linkage, End prompt becomes available. Entering a P at this point displays the page prior to the last page of detail rather than the page displayed before entering the G for Goto Last Screen.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

The following information appears in the invoice inquiry header: customer number, cutomer P.O./reference number, class, order date, the assigned terms code, the assigned tax codes, the invoice number, the invoice shipping date, the order date, the order number, sold to customer name and address, ship to customer name and address, the freight carrier, special insructions (if any), the bill to customer number, company number, and branch number. Note: The Order Date and Order Number fields are blank if the invoice is not created from an order. See the following example of the invoice inquiry header, invoice number 94994.

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 1 4/25/97 1 10 10 14 94994

Shipping Date Order Date Order Number

4/25/97 4912

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

The invoice inquiry provides detailed information on an invoice. The invoice inquiry screen displays the following invoice information per item number: line number, item number, item description, the quantity of the item ordered, the quantity of the item shipped, the quantity of the item back-ordered (if any), the items unit of measure, the extended price of the item (item price x item quantity), and the warehouse from which the item is shipped. See the following example of the invoice items, invoice number 94994.

Ln Item No. Description Ord Shptd B/O UM Ext.Price

1 111-222-3333 PART 3 3 EA 132.30

WH# 1

2 ZXT4M-TONER TONER 1 1 CT 61.75

WH# 1

3 PART MISC PART 1 1 CT 63.65

WH# 1

4 IBMTEST1 SUPPLY 2 2 EA 358.00

Subtotal 1653.90

Freight .00

Sales Tax 95.98

Total 1749.88

N'ext, G'oto Last Screen, S'erial Number Linkage, E'nd N

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

See the following example of an invoice inquiry, invoice number 94994.

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 1 4/25/97 1 10 10 14 94994

Shipping Date Order Date Order Number

4/25/97 4912

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Ln Item No. Description Ord Shptd B/O UM Ext.Price

1 111-222-3333 PART 3 3 EA 132.30

WH# 1

2 ZXT4M-TONER TONER 1 1 CT 61.75

WH# 1

3 PART MISC PART 1 1 CT 63.65

WH# 1

4 IBMTEST1 SUPPLY 2 2 EA 358.00

Subtotal 1653.90

Freight .00

Sales Tax 95.98

Total 1749.88

N'ext, G'oto Last Screen, S'erial Number Linkage, E'nd N

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 1 4/25/97 1 10 10 14 9499

Shipping Date Order Date Order Number

4/25/97 4912

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Ln Item No. Description Ord Shptd B/O UM Ext.Price

WH# 1

5 IBMTEST1 SUPPLY 2 2 EA 340.10

WH# 1

6 IBMTEST1 SUPPLY 2 2 EA 358.00

WH# 1

7 IBMTEST1 SUPPLY 2 2 EA 340.10

WH# 1

Subtotal 1653.90

Freight .00

Sales Tax 95.98

Total 1749.88

P'revious, S'erial Number Linkage, E'nd

If any items and messages on the invoice are part of a kit, each item and message in the kit is noted by an asterisk. The total price of the kit and each items individual price display. The subtotal of the invoice (total of the items extended prices) displays near the bottom of the invoice inquiry screen. The freight charge displays under the invoice subtotal. The sales tax of the invoice displays under the freight charge. The total of the invoice (total = subtotal + freight + sales tax) displays at the bottom of the invoice inquiry screen. Note: The subtotal, freight charge, sales tax, and total apply to the total invoice rather than the individual screen.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

If an order is voided after the invoice is created , the message *VOID* displays after the number in the Order Number field of the invoice inquiry header. The message *VOIDED* also appears between the invoice inquiry header and invoice inquiry line information. See the following example of a voided order on an invoice and a voided invoice with a voided order, invoice number 94461.

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

6666000 5841 1 3/27/97 1 10 10 9999 94461

Shipping Date Order Date Order Number

3/27/97 3/27/97 4735*VOID*

----- S O L D T O --------------- S H I P T O -------------------------------

THE WORLD INC THE WORLD INC S/Via U.P.S.

3568 ROADE ST. 3568 ROADE ST. From Co 1

P.O. BOX 86 P.O. BOX 86 Spec SPEC INST

LA CROSSE WI 546014522LA CROSSE WI 546014522 AR# 6666000

--------------------- ** V O I D E D ** ------------------------------Br # 2

Ln Item No. Description Ord Shptd B/O UM Ext.Price

1 TONER CASE OF TONER 2 2 CT 120.00

WH# 1

Subtotal 120.00

Freight .00

Sales Tax 7.80

Total 127.80

S'erial Number Linkage or E'nd

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 1 5/14/97 1 10 10 14 9508

Shipping Date Order Date Order Number

5/14/97 4836

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Item Number Linked Serial Contract # Service Plan Meter Reading

TONER BR85 2989 GM 23000

2110A BN879

946-181 BR85 2989 GM 23000

946-182 BR85 2989 GM 23000

946-189 BR85 2989 GM 23000

2110A CR4322

E'nd or R'eturn to Inquiry R

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Next, Goto Last Screen, Serial Number Linkage, End

Previous, Serial Number Linkage, End

Serial Number Linkage or End

While viewing an invoice, entering a S at any of the previous prompts accesses the serial number linkage screen, which displays the items on the invoice that are linked to a serial number. The following prompt displays.

End or Return to Inquiry R

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 5836 1 3/27/97 1 10 10 2 94458

Shipping Date Order Date Order Number

3/27/97 3/27/97 4733

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Item Number Linked Serial Contract # Service Plan Meter Reading

TONER 300 3003 CC 37000

946-181 300 3003 CC 37000

946-182 300 3003 CC 37000

946-189 300 3003 CC 37000

2110A CB7648

E'nd or R'eturn to Inquiry R

Carriage return to exit the serial number linkage screen and return to invoice inquiry.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

See the following example on an invoice header. The following information is included in the header when viewing an invoice:

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 5836 1 3/27/97 1 10 10 2 94458

Shipping Date Order Date Order Number

3/27/97 3/27/97 4733

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Cust No. The ship to customer number.

Cust.PO/Refer The purchase order number.

Class The assigned sales class. A class of 10 indicates the order is entered through Tele-Sales.

Date The invoice date.

Terms The assigned terms code.

Tax1 The assigned tax code 1.

Tax2 The assigned tax code 2.

Slm The sales rep or telemarketer number assigned to the invoice.

Inv.No. The invoice number.

Shipping Date The shipping date of the invoice.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

SOLD TO The complete name and address of the bill to customer.

SHIP TO The complete name and address of the ship to customer.

S/Via The assigned ship via (freight carrier).

From A shipped from entered in the invoice or order header overrides.

Spec Special instructions.

AR# The bill to customer number.

Co The assigned company number.

Br # The assigned branch number.

All of the items and messages that were input on the invoice display. The following information is included for each item when viewing an invoice:

Ln Item No. Description Ord Shptd B/O UM Ext.Price

1 TONER1 TONER 2 1 1 CT 55.00

WH# 0

2 LMS-K129 15000 COPY KIT 1 1 EA 128.25

WH# 0

3 1 * THE ITEMS LISTED BELOW ARE INCLUDED IN THE ABOVE PRICE.

4 1 * THE SUPPLIES WILL LAST FOR 15,000 COPIES.

5 * 946-181 TONER - BLACK 6 6 EA 84.00

Subtotal 208.25

Freight .00

Sales Tax 13.54

Total 221.79

N'ext, G'oto Last Screen, S'erial Number Linkage, E'nd N

Ln The number assigned to the invoice line.

Item No. The item number.

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Description Twenty five characters of the items description display.

Ord The total number of the item ordered.

Shptd The total number of the item shipped.

B/O The total number of the item back ordered.

UM The assigned unit of measure for the item.

Ext.Price The extended price of the item (quantity x price).

WH# The number of the warehouse from which the item is shipped.

See the following example on the serial number linkage screen. The following information is available for each line of the serial number linkage screen:

Cust No. Cust.PO/Refer Class Date Terms Tax1 Tax2 Slm Inv.No

5552222 5836 1 3/27/97 1 10 10 2 94458

Shipping Date Order Date Order Number

3/27/97 3/27/97 4733

----- S O L D T O --------------- S H I P T O -------------------------------

MISSISSIPPI BOAT SERVICES THE SLEEP INN MOTEL S/Via U.P.S.

E. WISCONSIN ST. 54 HOWARD ST From

P.O. BOX 345 P.O. BOX 1235 Spec

PORTAGE WI 539012222LA CROSSE WI 546032222 AR# 7856200 Co 1

-----------------------------------------------------------------------Br # 2

Item Number Linked Serial Contract # Service Plan Meter Reading

TONER 300 3003 CC 37000

946-181 300 3003 CC 37000

946-182 300 3003 CC 37000

946-189 300 3003 CC 37000

2110A CB7648

E'nd or R'eturn to Inquiry R

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Item Number The item number from the invoice which is linked to a serialized item number. The serialized item itself appears on the serial number linkage screen if it was also sold on the invoice.

Linked Serial The serial number of the machine to which the item on the invoice is linked.

Contract # The contract number of the machine that the item was linked to.

Service Plan The service plan of the machine that the item was linked to.

Meter Reading The meter reading if it was entered.

The information appearing on the serial number linkage screen is taken from the Sales History File (Shhist.dt). If an item on the invoice is not linked to a serial number, it does not appear on the serial number linkage screen. If a back-ordered item appears on the invoice, it does not appear on the serial number linkage screen because it is not yet in the Sales History File. If the back-ordered item is part of a kit which is already shipped, it appears on the serial number linkage screen because the kits items are in the Sales History File. If a serialized item number, such as a machine, appears on the serial number linkage screen, the serial number of the item displays after the item number. A serialized item number appears on the serial number linkage screen when it is sold on that specific invoice.

If the invoice number that was entered is not in the current AR detail but is in the customer's AR History File, the invoice is accessible. The Invoice Inquiry can be viewed if the invoice has not purged.

If the invoice number that was entered is not in the displayed account's current AR or AR History File, the following prompt displays.

Customer / Invoice Record Not Found

Enter Data (Cont'd)

O For Options (Contd)

Specific Invoice # (Contd)

Customer / Invoice Record Not Found

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No. 7818047 MG OFFICE SUPPLIES, INC. ONALASKA AR Bal. 1381.4

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

Customer / Invoice Record Not Found

The cursor is at the Press 'CR' To Display Invoice Inquiry prompt. The invoice may still be viewed if it has not been purged from the Invoice Files. This could be a common occurrence. The AR and AR History have been purged but the Invoice Files have not. The invoice could be viewed, even if the invoice is on a different account as long as it has not been purged from the system.

If the Invoice Files have been purged or have never existed, the following prompt appears. The cursor returns to the original screen where the O for options was entered.

Invoice Was Purged

6/04/97 Invoice Detail Inquiry

Invoice Was Purged

Note: When trying to view an installment invoice, you must enter the installment invoice number (i.e., 8342201 or 8342202) in order to access the AR detail. However, the Invoice File is not found. In order to view the Invoice Inquiry on an installment invoice, you must enter the invoice number less the installment number. (i.e., invoice number 83422 would be entered).

Enter Data (Cont'd)

O For Options (Contd)

H for History

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd

An invoice becomes a part of the AR History File when the invoice has a balance of zero and the Accounts Receivable/Order Purge has been run. To view the AR History records enter a H. If there is no AR History found, this prompt appears.

Customer Has No AR History Press 'CR' To Continue

A carriage return returns the cursor to the original screen where the options prompt was entered. Note: A customer may not have any current AR but still could have history. So when accessing a customer that has no current AR, the options prompt can still be entered to access the History File.

If there is history found, one of the following prompts appears.

Display N'ext P'revious O'ptions E'nd N

Display O'ptions E'nd

Customer AR History Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

41897 1 COA 41897 -5099.77 -5099.77 4/18

41897 1 ART 50997 5099.77 5/09

94793 1S C/M 32797 -85.46 -85.46 94793

94793 1 CMT 32797 85.46 94793 5/09

94803 1P C/M 32797 -71.36 -71.36 94803

94803 1 CMT 32797 71.36 94803 5/09

94830 1P C/M 40197 -142.72 -142.72 94830

94830 1 CMT 40197 142.72 94830 5/09

94831 1S INV 40197 114.09 114.02 .07 4/18

94831 1 PMT 50997 .07 A/C50997 5/09

94840 1P INV 40297 71.36 71.36 5/09

94842 1S INV 40297 216.62 216.62 5/09

94844 1L INV 40297 187.46 187.46 5/09

94845 1S INV 40297 235.14 235.14 5/09

94847 1P INV 40297 214.08 214.08 5/0

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

O For Options (Contd)

H For History (Cont'd)

Display N'ext P'revious O'ptions E'nd N

Display P'revious O'ptions E'nd

Display O'ptions E'nd

The first prompt appears if there is more than one screen of AR History. The third appears if there is only one screen of history. Note on the example, the heading now says Customer AR History Inquiry. Thus, you can tell when you are in the history data versus the current AR.

If there is more than one screen of AR history when the last screen is accessed, the prompt Display P'revious O'ptions E'nd appears.

Enter a N for next to access the next screen of the history display. Enter a P for previous to go back one screen of history. To exit the AR History Inquiry, enter an E to end. The cursor returns to the first screen of the current AR detail. The heading now says Customer AR Inquiry. The cursor is at the Display N'ext P'revious O'ptions prompts.

To access the options prompt when viewing the AR History, enter an O. The following prompt appears.

Enter Specific Invoice #, D'ate Range, Or E'nd

Enter Data (Cont'd)

O For Options (Contd)

H For History (Cont'd)

Enter Specific Invoice #, D'ate Range, Or E'nd

Customer AR History Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

41897 1 COA 41897 -5099.77 -5099.77 4/18

41897 1 ART 50997 5099.77 5/09

94793 1S C/M 32797 -85.46 -85.46 94793

94793 1 CMT 32797 85.46 94793 5/09

94803 1P C/M 32797 -71.36 -71.36 94803

94803 1 CMT 32797 71.36 94803 5/09

94830 1P C/M 40197 -142.72 -142.72 94830

94830 1 CMT 40197 142.72 94830 5/09

94831 1S INV 40197 114.09 114.02 .07 4/18

94831 1 PMT 50997 .07 A/C50997 5/09

94840 1P INV 40297 71.36 71.36 5/09

94842 1S INV 40297 216.62 216.62 5/09

94844 1L INV 40297 187.46 187.46 5/09

94845 1S INV 40297 235.14 235.14 5/09

94847 1P INV 40297 214.08 214.08 5/09

Enter Specific Invoice #, D'ate Range, Or E'nd

Enter an E to exit the options prompt. The cursor is at the AR History Inquiry Display N'ext P'revious O'ptions prompts.

There are two options within the AR History Inquiry. They are to enter a specific invoice and the date range option. The operation of these activities is exactly the same as described for the current AR inquiry. A specific invoice number, which is in the current AR, could also be input through the AR History options and vice versa. See page 327 to 339 for operation of specific invoice and page 343 to 346 for the date range option. When performing the date range option within the AR History Inquiry, the cursor exits the history inquiry and returns to the current AR inquiry once it is completed. Entering a specific invoice returns the cursor to the AR History Inquiry on the original screen upon which the option prompt was input.

The AR History Inquiry displays the same information as the current AR screen. See page 340 to 342 for details. Remember: An invoice does not become a part of the History File until the invoice has a balance of zero and the Accounts Receivable/Order Purge has run.

Enter Data (Cont'd)

O For Options (Contd)

D For Date Range

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd

To access the date range option enter a D. This allows the display of records that are within a specified time period. This includes the invoice date and the payment date. Thus, all AR records that have an invoice date or a payment date within the specified time period appear. When a D for date range is entered, these prompts display.

Beginning Date:

Ending Date:

Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

Beginning Date:

Ending Date:

An up arrow or / slash at the Beginning Date prompt returns the cursor to the Enter Specific Invoice # prompt. An up arrow key at Ending Date returns the cursor to the Beginning Date prompt. Enter the desired date range in this format MMDDYY. If an invalid date is entered, the prompt Invalid Date--Enter Again appears. The cursor returns for reinput. If an ending date is input that is less than the beginning date, the prompt Beginning Date Greater Than Ending appears. The cursor returns for reinput.

Enter Data (Cont'd)

O For Options (Contd)

D For Date Range (Contd)

The heading Date Range prints next to the Customer AR Inquiry title. This tells you that you are in the date range option. In the example, the dates of 05/01/97 to 06/06/97 were input. Every invoice that is included will either have a Tdate transaction date or a Lstpmt last payment date within the time span. Thus, you can view all invoices that were created or paid within the designated time span. Note on invoices 94985 and 94994 that there are two transaction lines. It the second line (the PMT line) that has a date in the range. The program always displays all of the lines of the record if at least one line has a date within the specified range. See the following example.

Date Range Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

95026 1P INV 50597 71.36 71.36

95029 1S INV 50597 93.72 93.72

95030 1S INV 50597 117.15 117.15

95031 1S INV 50597 340.80 340.80

95032 1S INV 50597 324.58 324.58

95037 1 INV 50597 36.19 36.19

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

O For Options (Contd)

D For Date Range (Contd)

See the following example. This is an example of the date range option within the AR History Inquiry. Note the heading Customer AR History Inquiry. The dates of 04/15/97 to 05/15/97 are entered. When entering a date range option in the AR History Inquiry, only records found in the History File are accessed. When entering the date range option in the current AR Inquiry, no AR History records are accessed.

Date Range Customer AR History Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

41897 1 COA 41897 -5099.77 -5099.77 4/18

41897 1 ART 50997 5099.77 5/09

94793 1S C/M 32797 -85.46 -85.46 94793

94793 1 CMT 32797 85.46 94793 5/09

94803 1P C/M 32797 -71.36 -71.36 94803

94803 1 CMT 32797 71.36 94803 5/09

94830 1P C/M 40197 -142.72 -142.72 94830

94830 1 CMT 40197 142.72 94830 5/09

94831 1S INV 40197 114.09 114.02 .07 4/18

94831 1 PMT 50997 .07 A/C50997 5/09

94840 1P INV 40297 71.36 71.36 5/09

94842 1S INV 40297 216.62 216.62 5/09

94844 1L INV 40297 187.46 187.46 5/09

94845 1S INV 40297 235.14 235.14 5/09

94847 1P INV 40297 214.08 214.08 5/09

Display N'ext P'revious O'ptions E'nd N

When there are no records found within the specified date range, a blank detail screen appears. The Date Range heading is displayed. When the date range option is entered within the AR History Inquiry, a message Customer Has No AR History Press 'CR' To Continue appears. A carriage return exits the history inquiry and returns to the first screen of the current AR Inquiry.

After inputting the date range prompt, one of the following prompts appears.

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

O For Options (Contd)

D For Date Range (Contd)

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd N

The first prompt appears when there is only one screen or no records found within the date range. The second prompt appears if there is more than one screen of records. Enter a N for next to view the next screen. Enter a P for previous to go back one screen. Once the last screen is reached, the prompt Display P'revious O'ptions E'nd, appears. Entering an E to end exits the date range screen. The first screen of the current AR detail displays. Entering an O for options displays the Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd prompt. You remain in the date range screen until something is entered at this prompt.

Enter Data (Cont'd)

O For Options (Contd)

O For Open Invoices and P For Paid Invoices

The last options available provide the ability to view only open or paid records. This option is not available in the AR History Inquiry as only paid records are in the History File. A record appears in the open screen if it has a balance greater than zero or a credit balance. A partially paid invoice is considered open as it does not have a balance of zero. A record appears in the paid screen if it has a balance of zero or is a zero invoice.

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd

Enter an O to view only open invoices. Enter a P to view paid invoices. See the following examples. The first example is the entire account, customer 7856200. Note that there are invoices that have a balance of zero and others that do not. The second example is the open invoices. Note that Open Invoices appears in the heading of the open invoices. Notice that all of the records have a balance greater than zero. The third example is of paid invoices. Note that Paid Invoices displays in the heading when P for paid invoices is selected. All of the invoices have a balance of zero.

Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 23886.64

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 543.32

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 1749.88

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

95026 1P INV 50597 71.36 71.36

95029 1S INV 50597 93.72 93.72

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

O For Options (Contd)

O For Open Invoices and P For Paid Invoices

Open Invoices Customer AR Inquiry 6/02/97 Dated 6/02/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 23886.64

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 543.32

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 1749.88

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

95026 1P INV 50597 71.36 71.36

95029 1S INV 50597 93.72 93.72

Display N'ext P'revious O'ptions E'nd N

Paid Invoices Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

94971 1E INV 42397 143.78 143.78 6/04

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

Display O'ptions E'nd

If the option of paid or open is entered, and there are no records found, a blank detail screen appears. The heading of Paid or Open Invoices displays. If records are or are not found, one of the following prompts display.

Display Options End

Display N'ext P'revious O'ptions E'nd N

Enter Data (Cont'd)

O For Options (Contd)

O For Open Invoices and P For Paid Invoices

Display Options End

Display N'ext P'revious O'ptions E'nd N

The first prompt appears when there is only one screen of records or no records found. The second prompt appears if there is more than one screen of records. Enter a N for next to view the next screen. Enter a P for previous to go back one screen. Once the last screen is reached, the prompt Display P'revious O'ptions E'nd, appears. Entering an E to end exits the open or paid screen. The first screen of the current AR detail displays. Entering an O for options displays the Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd prompt. You continue in the open or paid screen until something is entered at this prompt.

Enter Data (Cont'd)

O For Options (Contd)

Enter Specific Invoice #, H'istory, D'ate Range, O'pen, P'aid, Or E'nd

Entering an E to end exits the option screen. The original screen that was displayed when the O for option was entered is accessed. Thus, if you were in the Open Invoice Inquiry and entered an O for options then ended out, the open screen is displayed. If you were in the current AR and ended out of this prompt, the current AR screen appears.

The options screen must be ended out of before the account can be exited. Once you are back at the original prompts in the current AR detail, inputting an E at one of the three following prompts exits the account.

Display O'ptions E'nd

Display N'ext P'revious O'ptions E'nd

Display P'revious O'ptions E'nd

After entering an E to end, this prompt appears. Remember: This prompt is available only after exiting the options screens and the current AR detail screen. You also get the aging breakdown.

Enter Data (Cont'd)

O For Options (Contd)

Do You Wish To Print C'urrent AR, H'istory, B'oth, Or N'one N

Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

Credit Limit 10000

Terms 2% NET 10 Contract Pricing P.O. Required

Over 120 Over 90 Over 60 Over 30 Current

.00 .00 .00 3,701.55 22,578.02

Do You Wish To Print C'urrent AR, H'istory, B'oth, Or N'one N

Enter a C to print a hard copy of the current AR detail. Enter a H to print a hard copy of the AR History detail. Enter a B for both to print a hard copy of the current and the history. Enter a N or a carriage return to accept the default of a N for none not to print a hard copy. When a C, H, or B is entered, the printer routine appears. Select the desired printer. If the history option or both are selected and there is no history on the account, the prompt Customer Has No AR History - Press 'CR' To Continue appears. See the following example. The current AR detail is printed if the both option is entered.

Customer AR History Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7818047 MG OFFICE SUPPLIES, INC. ONALASKA AR Bal. 1381.45

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

Customer Has No AR History

Press 'CR' To Continue

Enter Data (Cont'd)

O For Options (Contd)

See the example of customer 7856200. This is the printout of the current AR and AR history. Note: All of the information that displays on the AR Inquiry screen prints. The AR History printout does not include the aging or customer information because there is no aging in the history as all invoices are paid. All of the records on the account print.

CUSTOMER AR INQUIRY 6/05/97 DATED 6/05/97 BY PAGE 1

CUST.NO. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR BAL. 26787.53

INV.NO TAC * TDATE AMOUNT PAID BALANCE C/M.NO REF LSTPMT

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

95021 1P INV 50597 71.36 71.36

95026 1P INV 50597 71.36 71.36

95029 1S INV 50597 93.72 93.72

95030 1S INV 50597 117.15 117.15

95031 1S INV 50597 340.80 340.80

95032 1S INV 50597 324.58 324.58

95037 1 INV 50597 36.19 36.19

95055 1S INV 50897 360.27 360.27 PO 12345

95069 1C INV 51297 373.23 373.23

95072 1 INV 51297 507.69 507.69

95074 1S INV 51297 338.93 338.93

95078 1C INV 51297 211.00 211.00

95079 1C INV 51297 437.67 437.67

95083 1C INV 51497 5869.24 5869.24

95084 1C INV 51497 5082.00 5082.00

95085 1C INV 51497 836.81 836.81

95088 1C INV 51597 3363.49 3363.49

95092 1B INV 51697 209.95 209.95

95093 1S INV 51697 46.42 46.42

95099 1C INV 52797 211.00 211.00

95126 1S INV 60297 42.33 42.33

95128 1S INV 60297 194.29 194.29

95138 1E INV 60597 3360.48 3360.48

95139 1S INV 60597 37.45 37.45

95140 1M INV 60597 1951.99 1951.99

CREDIT LIMIT 10000

TERMS 2% NET 10 CONTRACT PRICING P.O. REQUIRED

OVER 120 OVER 90 OVER 60 OVER 30 CURRENT

.00 .00 .00 3,701.55 22,578.02

CUSTOMER AR HISTORY INQUIRY 6/05/97 DATED 6/05/97 BY PAGE 1

CUST.NO. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR BAL. 26787.53

INV.NO TAC * TDATE AMOUNT PAID BALANCE C/M.NO REF LSTPMT

41897 1 COA 41897 -5099.77 -5099.77 4/18

41897 1 ART 50997 5099.77 5/09

94793 1S C/M 32797 -85.46 -85.46 94793

94793 1 CMT 32797 85.46 94793 5/09

94803 1P C/M 32797 -71.36 -71.36 94803

94803 1 CMT 32797 71.36 94803 5/09

94830 1P C/M 40197 -142.72 -142.72 94830

94830 1 CMT 40197 142.72 94830 5/09

94831 1S INV 40197 114.09 114.02 .07 4/18

94831 1 PMT 50997 .07 A/C50997 5/09

94840 1P INV 40297 71.36 71.36 5/09

94842 1S INV 40297 216.62 216.62 5/09

94844 1L INV 40297 187.46 187.46 5/09

94845 1S INV 40297 235.14 235.14 5/09

94847 1P INV 40297 214.08 214.08 5/09

94848 1 INV 40297 342.64 342.64 5/09

94852 1P C/M 40297 -71.36 -71.36 94852

94852 1 CMT 40297 71.36 94852 5/09

94866 1M INV 40497 300.74 300.74 5/09

94867 1M INV 40497 300.74 300.74 5/09

94869 1M INV 40897 298.20 298.20 5/09

94872 1S INV 40897 42.73 42.73 5/09

94873 1 INV 40997 36.19 36.19 5/09

94874 1 INV 40997 36.19 36.19 5/09

94875 1S INV 41097 2073.19 2073.19 5/09

94877 1 INV 41097 457.04 457.04 5/09

94880 1S INV 41097 419.64 419.64 5/09

94881 1 INV 41097 876.96 876.96 5/09

94882 1S INV 41097 699.48 699.48 5/09

94885 1S INV 41097 10.68 10.68 5/09

94890 1P INV 41097 781.94 781.94 5/09

94890 1S C/M 41497 -159.13 -159.13 94900

94890 1 CMT 41497 159.13 94900 5/09

94891 1P INV 41097 142.72 142.72 5/09

94896 1C INV 41097 288.90 288.90 7851 5/09

94897 1S INV 41197 421.54 421.54 5/09

94898 1 INV 41197 464.66 464.66 5/09

94901 1C INV 41497 5727.31 2557.30 3170.01 5/09

94901 1C C/M 41497 -3170.01 94909

94902 1S INV 41497 10.68 10.68 5/09

94905 1S INV 41497 187.45 187.45 5/09

94906 1P INV 41497 213.01 213.01 5/09

94908 1C INV 41497 4952.96 4952.96 5/09

94912 1E C/M 41597 -43.04 -43.04 94912

94912 1 CMT 41597 43.04 94912 5/09

94913 1C INV 41597 4611.02 4611.02 5/09

94923 1E C/M 41797 -43.04 -43.04 94923

94923 1 CMT 41797 43.04 94923 5/09

94926 1E C/M 41797 -143.78 -143.78 94926

94926 1 CMT 41797 143.78 94926 5/09

94931 1P INV 41897 212.99 212.99 5/09

CUSTOMER AR HISTORY INQUIRY 6/05/97 DATED 6/05/97 BY PAGE 2

CUST.NO. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR BAL. 26787.53

INV.NO TAC * TDATE AMOUNT PAID BALANCE C/M.NO REF LSTPMT

94932 1S INV 41897 470.07 470.07 5/09

94937 1E C/M 41897 -173.08 -173.08 94937

94937 1 CMT 41897 173.08 94937 5/09

94939 1E INV 41897 43.93 43.93 5/09

94940 1E C/M 41897 -43.93 -43.93 94940

94940 1 CMT 41897 43.93 94940 5/09

94949 1P INV 42197 71.36 71.36 5/09

94953 1M INV 42297 2490.73 2490.73 5/09

94954 1P INV 42297 142.71 142.71 5/09

94963 1S C/M 42297 -94.38 -94.38 94963

94963 1 CMT 42297 94.38 94963 5/09

94972 1S INV 42397 18.39 18.39 5/09

94980 1 INV 42497 72.38 72.38 5/09

95006 1C INV 50297 10238.50 26.11 10212.39 5/09

95006 1 PMT 50997 4041.34 6171.05 A/C50997 5/09

95006 1 ART 50997 -5099.77 1071.28 5/09

95006 1 CMT 32797 -85.46 985.82 94793 5/09

95006 1 CMT 32797 -71.36 914.46 94803 5/09

95006 1 CMT 40197 -142.72 771.74 94830 5/09

95006 1 CMT 40297 -71.36 700.38 94852 5/09

95006 1 CMT 41497 -159.13 541.25 94900 5/09

95006 1 CMT 41597 -43.04 498.21 94912 5/09

95006 1 CMT 41797 -43.04 455.17 94923 5/09

95006 1 CMT 41797 -143.78 311.39 94926 5/09

95006 1 CMT 41897 -173.08 138.31 94937 5/09

95006 1 CMT 41897 -43.93 94.38 94940 5/09

95006 1 CMT 42297 -94.38 94963 5/09

95009 1P INV 50297

95010 1P INV 50297

95012 1P INV 50297

95016 1P INV 50297

95020 1P INV 50597 1352.87 1352.87

95020 1P C/M 50597 -1352.87 95022

95027 1P INV 50597

95028 1S INV 50597

95033 1S INV 50697 1289.25 1289.25

95033 1S C/M 50697 -1289.25 95034

95073 1P INV 51297

95080 1S INV 51397

95090 1S INV 51597

95103 1S INV 52897

95110 1 INV 52897

95130 1 INV 60297

95131 1 INV 60297

Enter Data (Cont'd)

O For Options (Contd)

After the account is printed or a N for none not to print the account is entered, this prompt appears.

Additional Inquiries Required Yes No

Enter a N for no to exit the Account Inquiry. Enter a Y for yes to access another account and return to the Cust.No/Phone No prompt.

When the Do You Wish To Print C'urrent AR, H'istory, B'oth, Or N'one prompt is displayed, additional information appears on the screen. This is also included on the hard copy of the current AR. The information that is displayed or printed is as follows.

Customer AR Inquiry 6/05/97 Dated 6/05/97 By

Cust.No. 7856200 MISSISSIPPI BOAT SERVICES PORTAGE AR Bal. 26787.53

Inv.No Tac * Tdate Amount Paid Balance C/M.No Ref Lstpmt

60497 1 COA 60497 -856.22 -856.22 7856200ABCDE 6/04

94971 1E INV 42397 143.78 143.78 6/04

94973 1P INV 42397 282.39 282.39

94981 1P INV 42497 64.22 64.22

94983 1S INV 42497 122.39 122.39

94984 1S INV 42497 335.50 335.50

94985 1S INV 42497 543.32 200.00 343.32 6/02

94985 1 PMT 60497 343.32 A/C60497 6/04

94986 1S INV 42497 213.00 213.00

94988 1S INV 42497 436.65 436.65

94993 1S INV 42597 374.37 374.37

94994 1S INV 42597 1749.88 500.00 1249.88 6/02

94994 1 PMT 60497 600.00 649.88 A/C60497 6/04

95002 1E INV 50197 86.10 86.10

95011 1S INV 50297 81.89 81.89

Credit Limit 10000

Terms 2% NET 10 Contract Pricing P.O. Required

Over 120 Over 90 Over 60 Over 30 Current

.00 .00 .00 3,701.55 22,578.02

Do You Wish To Print C'urrent AR, H'istory, B'oth, Or N'one N

Aging Breakdown Over ### Current The current AR balance is aged into the proper number of days. The aging breakdown is defined in Global Record 0. Each invoice has its original transaction or invoice date compared to the system date. The balance of the invoice is added to the appropriate breakdown. The aging breakdown is for the total AR regardless of what screen the account was ended out of. It is not the aging breakdown of the displayed screen.

Enter Data (Cont'd)

O For Options (Contd)

Credit Limit An amount prints if there is an amount entered in field 13 in the Customer File Maintenance program.

Terms The description of the terms code that is stored in field 11 in the Customer File Maintenance program. Note: If this is C.O.D., it flashes.

Contract Pricing This appears if field 26 in the Customer File Maintenance program has a Y for yes.

Special Instructions Whatever is entered in field 10 in the Customer File Maintenance program displays.

P.O Required This appears if field 25 in the Customer File Maintenance program has a Y for yes.

Account Detail Inquiry (AR Inquiry) (BIIQ001)