Order Entry Program

This program will:

File Layouts:

Inventory File

Customer File

Order Header File

Order Detail File

Next Order Num File

Item Num

Customer Num

Order Num

Order Num

Order Num

Item Name

Customer Name

Customer Num

Line Num

 

On Hand

Cust Street Adr

Date Order

Item Num

 

On Order

Cust City

Shipping Name

Item Name

 

ReOrder Point

Cust State

Shipping St Adr

Price

 

Committed

Cust ZIP

Shipping City

Num Ordered

 

Warehouse Loc

Cust Phone

Shipping State

Num Avail

 

Cost

 

Shipping ZIP

Num Back Ordr

 

Price

 

 

Warehouse Loc

 

The order entry screen should take in all of the information needed to create records on the Order Header File and the Order Detail File. Information available on the Inventory File or the Customer File that will be used to create the two Order files should be retrieved and displayed on the screen. In the case of shipping name and address information, the customer name and address information should be displayed as the default and the data entry person should have the ability to change the information to produce the shipping information.

When the program is started, the user should get the next order number from the Next Order Number File. This number should be used for the first order, all additional orders should be incremented by one and the next order number written to the Next Order Number File. At the end of processing, the next available order number should be in the one record on the Next Order Number File (in preparation for the next time the program is executed).

The first detail in an order is assigned line number of 1 and all additional details are assigned a line number one higher.

Number available and number backordered is determined by checking the on hand and the committed fields on the inventory file. If the number on hand minus the number committed is greater than or equal to the number ordered then committed should be increased by the number ordered and number available should equal the number ordered. If the difference between the on hand and the committed is less then the number ordered then number available should pick up what is available (on hand - committed) and committed should be increased by the number ordered. The number back ordered would be the difference between the number ordered and the number available.