Order Worksheet By Customer

** This utility is under development and is not yet available. **

The Sales Order Worksheet is similar to the Sales Order Report using the by Customer selection.
It shows the orders and the items ordered for each customer, with the location. The sales orders list in customer number order providing a useful consolidated list of orders for each customer.
For each product, the Worksheet prints the Original Quantity Ordered, the Quantity still on Order.
It prints the Unit Cost and Unit Selling price with the Margin, for quantities still on order and the Extended Cost, and Extended Selling price.

The Margin calculation used is: [ 1 - (COST divided by SELLING)] * 100%= MARGIN

The Selling Price is calculated as: (PRICE - DISCOUNT) * Currency Exchange = SELLING PRICE

The prompts are:

FROM CUSTOMER #

Leave this field blank to include orders for all customers or type in the beginning customer number.

TO CUSTOMER #

Leave this field blank for all customers or type in the ending customer number.

OPEN ORDERS ONLY

Enter N (NO) to print All orders in the selection range.

Enter Y (YES) for open orders only.

BACKORDERS ONLY

This prompt only applies if Open Orders Only are to be printed and is skipped if All orders are to be printed.

Type N (NO) to print all items not yet shipped.

Type Y (YES) to get a list of only the backordered items.
Orders that are not shipped yet, but are not flagged as Backordered either, are excluded.

ONLY PRINT ORDERS THAT CAN BE FILLED

This prompt only applies if Open Orders Only are to be printed and is skipped if All orders are to be printed.

Type Y (YES) to print only the orders for which there are sufficient quantities available at the location assigned to the order, to fill them. When quantities are used up, items on open orders will not be listed.

Type N (NO) to print all open orders regardless of quantities available.

ALL LOCATIONS

Type Y (YES) to print the report for all locations.

Type N (NO) to select the desired location.

LOC

Enter the specific location to print or select it from the drop-down list.

NARROW OR WIDE PAPER

Type N for narrow paper or type W to print on wide paper.

Finished?

A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.

Click the ACCEPT button to begin printing the report, or CANCEL to abort.