One purpose of the the Worksheet program is to allow entry of data directly from an invoice without requiring use of a calculator before you can enter the data.

DCs and NDCs have been a bit of a mystery and caused some confusion. In an attempt to clarify what the W/S program does I have tried to analyze the ways the fields could be used.

I can identify the following possible invoice arrangements. If there are others please let me know.

W/S  - explains how the sum of the entered values from
       the bottom of the screen are related to the fields 
       on the top of the screen.
CALC - explains what the calc program does to generate 
       the HTS values shown on the 7501
7501 - explains how the invoice summary entered value is 
       calculated.

INVOICE 1
item ---$
.
item ---$
PACKING (DC)		$		DCS INCLUDED
Invoice Total		$		INVOICE VALUE SHOWN
	W/S  - Entered Values=Invoice Total - DCs
	Calc - (Take dutiable chgs and prorate across items)
	7501 - Entered Value = Invoice Total

INVOICE 2
item ---$
.
item ---$
Freight	(NDC)		$		NDCS NOT PRORATED
Invoice Total		$		INVOICE VALUE SHOWN
	W/S  - Entered Values=Invoice Total - NDCs
	Calc - (Use values as entered on WS)
	7501 - Entered Value = Invoice Total - NDC

INVOICE 3
item ---$
.
item ---$
Invoice Total 		$		INVOICE VALUE SHOWN
which includes Freight (NDC) of	$	NDCS PRORATED
	W/S  - Entered Values=Invoice Total
	Calc - (Subtract prorated NDC from WS entered values)
	7501 - Entered Value = Invoice Total - NDC

INVOICE 4
item ---$
.
item ---$
Invoice Total 		$		INVOICE VALUE SHOWN
Packing (DC)		$		DCS NOT INCLUDED
	W/S  - Entered Values=Invoice Total
	Calc - (Take dutiable chgs and prorate across items)
	7501 - Entered Value = Invoice Total + DC

INVOICE 5
item ---$
.
item ---$
Less Discount %				DISCOUNT BEFORE
Invoice Total 		$		INVOICE VALUE SHOWN
	W/S  - Entered Values=Invoice Total+Discount Amount
	Calc - (Take discount amount and prorate across items)
	7501 - Entered Value = Invoice Total - Discount Amount

INVOICE 6
item ---$
.
item ---$
Invoice Total 		$		INVOICE VALUE SHOWN
Less Discount %				DISCOUNT AFTER
	W/S  - Entered Values=Invoice Total
	Calc - (Take discount amount and prorate across items)
	7501 - Entered Value = Invoice Total - Discount Amount

Any grouping of invoice styles can be used together (DCs, NDCs and discounts). Discounts are applied to the invoice total before DCs or NDCs are considered.