Program Description
This program can be found on the Billing Data Entry menu (BI-1-2). This program is very similar to Invoice Entry in that customer information is entered to bill serialized machines that are placed at customer sites. Several data files are updated, including but not limited to the Customer (CUSTD), Tax (TAX2.DT), Invoice Header (INVHDRD), Invoice line (INVLID), Accounts Receivable (ARECD), Sales Analysis (SALID), and Contract History (CNHIST.DT) files.
See also:
Rev 15 Changes
There is a new global option in Global Record 2 to validate branch numbers in invoice entry, credit memo entry, order entry, order file maintenance, service invoicing, contract setup, contract changes and customer file maintenance. To be valid, branch numbers must match one of the ten branch numbers stored in Branch Global Record 5. Validation checks occur at the branch number prompt in the invoice or order header and in the line items of the invoice or order if branch per line item is activated. The Global Option is in Billing Control Global Record 2, field 52. If this Global Option is set to Y for yes, a valid branch must be entered in at the branch prompts. If an N for no is entered in this Global Option, then branches that are not in Branch Global Record 5 can be entered at the branch prompts. If you are currently using more than 10 branches, you will need to set this Global Option to N for no since only ten branches are stored are stored in Global Record 5. All branches must still be between 1 and 255.
When the new global option is set to Y for yes and the branch does not match any of the branches in Branch Global Record 5, the message “Invalid Branch Number” will appear at the bottom of the screen. The original branch will be redisplayed, and user has the option to accept the original branch or enter a new branch. It is possible that the original branch is invalid, and therefore it must be changed before proceeding.
Example: Invalid Branch In Header:

Example: Invalid Branch #2 in Line Item Split:

The programs previously checked to see if a branch was between 1 and 255 but did not display a message if it was not in the range. A message that states “Branch Number Must Be Between 1 And 255” has been added and will display when branch is not in the range. Original branch is redisplayed and cursor is placed for user to accept original branch or input a new branch.
Branch number is always checked to see if it is between 1 and 255 regardless of whether Global Record 2, field 52 is set to N for No or Y for Yes.
Example: Branch # 2 not between 1 and 255:

A new Global option has been added to the Billing Control Record (Global Record 2). This is field number 53 (Display Ship-To/Bill-To Cust # During Alpha Search In Inv/Cash Posting (Y/N)). If this Global option is set to Y, a second line will display during Alpha Customer Name Search during Invoice Entry, Credit Memo Entry, Order Entry and Cash Posting that will display the Ship-To and Bill-To Customer Numbers. See Screen sample below:

The headings during the Coupon Inquiry during Invoice Entry, Credit Memo Entry, and Order Entry had the headings occasionally misaligned. This has been corrected. Also, there was a problem if the operator accessed an invoice, credit memo or order using Serial Number Access. If the machine had coupon books, the Coupon inquiry prompt would mention that the customer and the machine had coupon books. If the operator slashed out and then accessed a different customer number using customer access instead of Serial Number access, the coupon message would still mention that the machine had coupon books even though the operator had not entered a machine for the second customer. This has been corrected.
Internal changes were made to the program to accommodate the new position of the Number Of Coupons field in the Coupon Header File (CINVHDRD). On Fixed Quantity Coupon Books, the Number Of Coupons field was enlarged from 4 digits to 6 digits.
Rev 14 Changes
When a customer (or machine) has coupon books, and the quantity left is 0, a message stating that the customer (or machine) has coupons but they are all redeemed is displayed. Changes were made so that if the quantity left is negative, the operator will also get this message. Note: the quantity left should never be negative unless the coupon was modified through coupon file maintenance.
A new field was added to the Invoice Line Item File (INVLID), and Sales Analysis File (SALID). This is the Commission Cost field. With Revision 14, you can store a Commission Cost in the Special Price File (CONTPD). If the item being credited is a special price item from the Special Price File (CONTPD), the Commission Cost from the Special Price File will be written into the above files. If the item being credited is not in the Special Price File, or the Commission Cost in the Special Price File for that item is zero, the Commission Cost from the Item File (ITEM) will be written into the above files. On predefined kit line items and coupon line items, the special pricing file is not used. Therefore, the Commission Cost from the Item File (ITEM) will be written into the above files. End of Day Processing will then write the Commission Cost into the Sales History File (SHHIST.DT) from the Sales Analysis File (SALID). The Commission Cost field is not used for any of the existing Commission Reports. However, you can use this field to write custom Commission Reports with Application Manager.
Rev 13 Changes
This program was changed to lock the correct cost into the credit memo with regard to the cost lockout feature. When the Cost Lockout (Y/N) option (BI-3-1-18-2, field 15) from Billing Control File Maintenance is set to Y and a credit memo for a serialized item was created with no serial number, the cost was locked in at zero instead of the average cost from the Item (ITEM) data file. This problem has been resolved.
When customer messages are displayed, there is now the ability to enter N for next screen or P for previous screen. If the number of messages fit on one screen, press enter to continue.
Credit Memo Entry, Invoice Entry, and Order Entry can now display inquiry tables for tax code 1, tax 2, and city tax code.
There is now the ability to suppress printing of invoices or orders in Credit Memo Entry, Invoice Entry, and Order Entry.
Also, when performing serial number searches in the header portion of Invoice Entry, Order Entry, and Credit Memo Entry, the ID Number from the Serial data file (SERIALD) will display.
See also:
Rev 12 Documentation
Credit Memo Entry
Introduction
Credit Memo Entry is found on the Billing Data Entry menu, 1-2.
Internal changes were made to incorporate the file expansion of the Item and Serial File and Invoice Line Item and Invoice Header Files.
All of the price and cost fields in the Item File can have 4 digits after the decimal point. This is useful for costs and prices for cabling and corona wire. As an example, the cost or price could be .0123 or 1.0123. Because of this ability, the costs and prices always display with 4 numbers after the decimal point. Extended price and cost is always rounded to two decimals. This applies to all inputs of unit price and cost in the Invoice Entry program. One exception is the Serial File cost. This is only two decimals. Operation is the same as described for Invoice Entry. See pages 46 to 52.
Warehouse can now be any valid warehouse from 1 to 9999. This includes adding, changing, delete/insert, kits, and coupon credit memos.
The ship to name and address can be changed per credit memo. This is accomplished by selecting the ship to name and address on the overrides screen when creating the invoice header. Each line of the original name and address now remains on the screen as a default. A carriage return accepts the default or the name or address can be overridden. Any overrides only affect the current credit memo. Operation is the same as described for Invoice Entry. See page 45.
An exempt status has been added to the customer credit alert feature. Details of this is found on page 90.
The Model Association feature is available in Credit Memo Entry. Operation is the same as that described for Invoice Entry. See pages 64 - 89.
A correction was made on the entry of a serialized item. When a serialized item is entered and a N for no serial number is input, overriding the displayed average or last cost now flows through to the prompt to accept average/last cost or a cost of zero.
Credit Memo Entry (Cont’d)
Introduction (Cont’d)
When a serial numbered item is credited the serial number that is assigned on the invoice now writes into the Sales Analysis, Salid File. Only the serial number is written. This occurs automatically and is not a global option. There is no prompt involved. Whether the service plan linkage is activated or not has no bearing on this feature. The storing of the serial number in the Salid File is transferred to the Sales History, Shhist.dt File. By storing the serial number on the credit memo that the record was credited on, a complete history record for the machine is continued.
There is a feature during the entry of an item to enter INQ and view a brief inventory status inquiry. From this inquiry, an option to enter the Stock Status Inquiry is now available. This is the same Stock Status Inquiry that is available on the Inquiry menus. After exiting the Stock Status Inquiry the item that was being entered is returned to and the entry of the item can continue, if desired. This is available in the add and change and delete/insert mode. The INQ feature is not available on predefined or free flowing kits. Operation is the same as described on pages 53 - 54 for the program Invoice Entry.
When overriding the bill to customer number in the credit memo header, a message This Is Not A Bill To Customer Number appears when a ship to account number is input. The input is allowed. This is a warning message to alert the operator to the fact that they are adding Accounts Receivable to a ship to account.
In Revision 12, multiple contract discounts for an item or product class can now be provided to a customer through the use of multiple buying groups, which are assigned to the customer in Customer File Maintenance. When a customer is assigned to multiple buying groups and contract pricing is created for an item or product class, the system uses the lowest available value to price the item(s) on the customer’s order, invoice, service ticket, or credit memo. Also, if a customer is assigned to multiple buying groups, the system looks at the effective dates of each contract discount. If a contract discount is not effective, it is not used to price the item(s). If the customer is not assigned to multiple buying groups, contract pricing remains unchanged.
Credit Memo Entry (Cont’d)
Enter Data
A correction was made on the entry of a serialized item. When a serialized item is entered and a N for no serial number is input, the following prompt appears.
Average Cost or Last Cost = #######
Cost Of Serial Item Is Zero. Do You Wish To Use Average or Last Cost (Y/N)
CM Cust.No. Cust.PO./Refer Class Date Disc Terms Tax1 Tax2 Slm Inv.No
Hdr 5552222 1 1/20/97 1 10 10 2
----- 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 A/R# 7856200 Co 1
--------------P.O. Required----------------------------Credit Memo-- 94257 2
Item UM Description Qty Disc Price Extend
1 2110A EA COPY MACHINE -1 2345.0000 -2345.0
Warehouse 1
Average Cost = 1107.7300
Cost Of Serial Item Is Zero. Do You Wish To Use Average Cost (Y/N)
Depending upon the set up of the Global File determines whether the average or last cost is displayed. This was always from the Item File and not the cost that was input as the average or last cost when entering the item on the credit memo. This has been changed so that any overrides to the cost display in the above message. This cost is then used for the item on the credit memo when answering the prompt to use the average and last cost. Note: When the feature of cost lockout is activated, the above prompt never appears.
Credit Memo Entry (Cont’d)
Enter Data (Cont’d)
Contract Pricing
Multiple contract discounts can now be provided to a customer through the use of multiple buying groups, which are assigned to the customer in Customer File Maintenance. Contract discount prices can be assigned to an individual item or product class(es) in the Contract Pricing File Maintenance program. This can be by price or percentage discount. Contract discount prices can be specifically provided to the customer for an item or product class using the customer number or more generally provided by assigning the customer to one or more buying groups. If the customer has an individual contract discount and a buying group contract discount, contract pricing remains unchanged. The individual contract discount is used to price the item because it is customer-specific. If the customer has an individual contract discount and more than one buying group contract discount, the system looks at the item’s list price and all of the contract discounts to find the lowest value to price the item. If the customer has more than one buying group, the effective period of a contract discount can be determined by inputting a start and expiration date for the contract discount. If the customer has only an individual contract discount and/or one buying groups, the start and expiration dates of the contract pricing is for informational purposes.
To assign a customer to multiple buying groups, see Customer File Maintenance, Adding A Customer on page 137 or Changing A Customer on page 139 in the File Maintenance section.
To create contract discount pricing for an item or product class, see Contract Pricing File Maintenance on page 166 in the File Maintenance section.
The credit memo entry process in relation to contract pricing is similar to that described for invoice entry. See Contract Pricing on page 55 in the Invoice Entry section for details.
Billing Data Entry (Cont’d)
Customer Credit Alert
Invoice Entry
Credit Memo Entry
Order Entry
Customer File Maintenance
Introduction
There is an automatic credit alert that displays in Invoice Entry, Credit Memo Entry, and Order Entry. Operation is based on a field in the Customer File. There is also a number of days for past due alert that is defined in the Global File. In the Customer File a Yes or No for a credit alert can be defined. Even with a No for credit alert, the automatic credit alert appears if the customer has past due invoices. You also may enter an L for customer lock out. An additional option has been added in the Customer File to the credit alert feature. This is the ability to enter an E for exempt to any credit alert. The reason for this option is that some of the customers that have a large A/R account are always past due and the credit alert feature slows down the entry of the invoice or order. Storing an E for these customers prevents any automatic credit alert from occurring whether the customer has past due invoices or not. Note: You may still perform a credit inquiry. It is recommended that the storing of an E for exempt should only be used on accounts that you do not want the invoice or order entry operators to monitor the customer’s credit status.
Customer Credit Alert (Cont’d)
Enter Data
Customer File Maintenance
12-Credit Alert (Y/N/L/E):
Field 12 has been changed. The entry of an E for exempt has been added. Entering an E in field 12 prevents any automatic credit alert from occurring in Invoice Entry, Order Entry, and Credit Memo Entry. Even if the customer has past due invoices, an automatic credit alert does not occur. The operation of the credit alert remains the same when a N or Y or L is entered. Credit alert functions are generated from the bill to customer accounts. Thus, be sure and enter the E in the bill to customers’ accounts.
5/06/96 Customer File Maintenance 8:13
Enter Procedure Type A'dd C'hange D'elete E'nd
Fld-Cust.No: 1-Bill To: Date Added:
2-Company: Company:
3-Address 1: Address 1:
4-Address 2: Address 2:
5-City: City:
6-State: State:
7-Zip: Zip:
8-Phone: 20-Fax #:
9-Contact: 21-Tax Code 1:
10-Special Instr.: 22-Tax Code 2:
11-Terms Code: 23-Exempt Code:
12-Credit Alert (Y/N/L/E): 24-Tax Number:
13-Credit Limit: 25-P.O. Required:
14-Interest Charge: 26-Contract Pricing:
15-Discount (99.9): 27-Buying Group No:
16-Delivery Zone: 28-Suppress Statement:
17-SIC Code: 29-Service Zone:
18-Branch: 30-City Tax Code:
19-County Code: 31-Service Territory:
Customer Credit Alert (Cont’d)
Enter Data (Cont’d)
Invoice Entry, Credit Memo Entry, Order Entry
When an E is entered in the Customer File the automatic credit alert is bypassed. Instead of the credit alert, the cursor goes to the Credit I'nquiry C'ancel prompt to allow input of a credit inquiry, if desired. This occurs in Invoice Entry, Credit Memo Entry, and Order Entry. Following is an example of the effects within Invoice Entry when an E is entered in the Customer File.
The first example shows the customer with a N for no entered in the credit alert field in the Customer File. The credit alert appears because the customer has past due invoices.
Inv Cust.No. Cust.PO./Refer Class Date Disc Terms Tax1 Tax2 Slm Inv.No
Scr 5557777 5/06/96 1 16 16 1
----- S o l d T o --------------- S h i p T o -------------------------------
THE OTHER WORLD THE OTHER WORLD S/Via
1500 GEORGE ST 1500 GEORGE ST From
P.O. BOX 55 P.O. BOX 55 Spec
LA CROSSE WI 54601 LA CROSSE WI 54601 A/R# 5557777 Co 1
--------------P.O. Required---------------------------------------------Br 12
Credit Alert
Past Due Account
A/R Balance 9473.00
Open Orders 4373.56
Credit Limit 10000.00
Over Limit By 3846.56
Over 120 Over 90 Over 60 Over 30 Current
646.66 153.73 5,030.41 2,684.02 958.18
More D'etail N'o
Terms = NET 10 DAYS
Customer Credit Alert (Cont’d)
Enter Data (Cont’d)
Invoice Entry, Credit Memo Entry, Order Entry (Cont’d)
The next example shows the same customer but with an E entered in the credit alert field in Customer File Maintenance. The credit alert does not display. Instead of the automatic credit alert, the cursor is at the Credit Inquiry C’ancel prompt.
Inv Cust.No. Cust.PO./Refer Class Date Disc Terms Tax1 Tax2 Slm Inv.No
Scr 5557777 5/06/96 1 16 16 1
----- S o l d T o --------------- S h i p T o -------------------------------
THE OTHER WORLD THE OTHER WORLD S/Via
1500 GEORGE ST 1500 GEORGE ST From
P.O. BOX 55 P.O. BOX 55 Spec
LA CROSSE WI 54601 LA CROSSE WI 54601 A/R# 5557777 Co 1
--------------P.O. Required---------------------------------------------Br 12
Credit I'nquiry C'ancel
Terms = NET 10 DAYS