COD Worksheet

Access

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 amounts 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 Area

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.

• Document

• Type - 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.

• Status - the delivery status (for example, SCH for scheduled or CWC for customer will call).

• Date

• Ship To

• Bill To

• Ship None - un-schedule all items for delivery. The Ship column in the grid updates to indicate the quantity scheduled, and the Deliver and Balance columns in the header area re-calculate accordingly.

• Ship All - schedule all items for delivery. The Ship column in the grid updates to indicate the quantity scheduled, and the Deliver and Balance columns in the header area re-calculate accordingly.

On the right side of the header area, the following rows display:

• Merchandise

• Delivery

• Fees/Charges

• Sales Tax

• Deposits - negative amounts indicate credits to the customer.

• Financing -  negative amounts indicate credits to the customer.

• Previous Deposits

• Anticipated COD

For each of the above rows, the following columns of information appear:

• Total - displays current dollar amounts on the sales order, as well as the total Anticipated COD amount, which is also the balance of the current order. Note that the totals displayed do not include previous deliveries or deposits applied to previous deliveries.

• Next Delivery - displays the dollar amounts associated with the scheduled delivery.  The deposits in this column represent the amount of the current deposits paid being to the delivery.  

• To Be Delivered - displays the projected dollar amounts after the proposed delivery, as well as the Anticipated COD amount for the final delivery. The deposits in this column are the deposits to be applied to the balance - assuming the Anticipated COD for the Next Delivery column is collected.  The Anticipated COD for this column equals the

total balance - deposits

or, in other words, the

Anticipated C.O.D. amount from the Total column - Anticipated COD amount from the Next Delivery column.

Grid Area

The grid contains the line items from the selected order. Use the fields below to calculate C.O.D. 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 amount and get a re-calculated C.O.D. amount.  

ProductEnter 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.

ShipThe amount from the Ship column for the selected line item appears. The system uses the amount from the Ship column to calculate COD for the line item. You can enter an amount equal to or less than the Schedule amount 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 amounts in this column.  This column populates for SCH and EST types only.

DescriptionThe description of the selected product displays.

ScheduledThe quantity scheduled displays.