COD Worksheet

Enter a Sales Order > Payment page > Actions button > COD Worksheet
Enter an Exchange > Payment page > Actions button > COD Worksheet
Payment Summary Window > Actions button > COD Worksheet

Use this screen to access customer C.O.D. information when entering sales orders or scheduling deliveries. This screen is unavailable for direct ship items. You can use it to re-calculate C.O.D. amounts if, for example, you need to withhold one or more pieces on an order from delivery. The calculations are strictly "what if" calculations within this worksheet, and do not affect amounts in the system. Initially, the Ship column contains zeros, but you can use the Ship field below to edit those quantities and calculate C.O.D. costs for one or more items on the order.

For example, assume you have an order with 5 line items with a quantity of one each. The grid on the COD Worksheet displays the order amounts for that order. If the customer asks to withhold one of the line items from the order, you can immediately re-calculate the C.O.D. costs for the reduced shipment and inform the customer.

The C.O.D calculation includes the

    - deposit hold-back percent (if any) as defined in the Accounts Receivable Control Settings as well as

    - the customer's previous AR balance.

The total required for any future invoice is the amount required to pay for the merchandise being completed plus the minimum deposit requirements for the undelivered merchandise. Any money paid is first applied to the merchandise being invoiced. Any balance of money paid is then applied to satisfy the minimum deposit requirements on the undelivered merchandise.

Header

The header area of the worksheet contains information from the current order. If the order contains multiple line item types (for example, delivery and take-with), you can edit the Status field to calculate a selected line item type. Otherwise, you cannot edit these fields, although system updates the dollar amounts based on changes you make to the grid or the Status field.

The current order number.

Click on the Arrow to display the line item types from the current order. If accessing from an order-entry routine, you can select one and recalculate the screen. If accessing from Logistical Scheduling, only delivery lines are available.

The date of the current order.

The delivery status of the current order;for example, SCH for scheduled or CWC for customer will call.

The customer name to which the order is shipping.

The customer name to which the order is billed.

Product Shipping

Enter the product whose COD amount you want to view or edit. You can enter the product directly into the field, or you can double-click on the line item in the grid.

The description of the selected product appears here.

The quantity from the Ship column for the selected line item appears. The system uses the quantity from the Ship column to calculate COD for the line item. You can enter a quantity equal to or less than the Scheduled quantity for the selected line item. When you click on Add, the system re-calculates the COD amount and updates the grid.

Note that orders with a delivery status of ASAP or CWC have no lines scheduled for delivery and thus generate no quantities in this column. This column populates for SCH and EST types only.

The quantity scheduled.

Click this button to un-schedule all items for delivery. The Ship column in the grid updates to indicate the quantity scheduled, and the Next Delivery and To Be Delivered columns in the Delivery Totals section re-calculate accordingly.

Click this button to schedule all items for delivery. The Total column in the grid updates to indicate the quantity scheduled, and the Next Delivery and To Be Delivered columns in the header area re-calculate accordingly.

The grid contains the line items from the selected order. Use the above fields above to calculate COD costs for one or more items. In the event you need to withhold one or more pieces from the shipment, you can enter the updated ship quantity and get a re-calculated COD amount. The grid displays the following columns:

Product
Description
Fulfillment Method
Schedule
Ship
Extension

Delivery Totals

Use this section to view cost information about the current order. Information in this section displays as read-only. This section is expandable/collapsible.

COD Worksheet

Header

Product Shipping

Delivery Totals

Columns

Rows