Skip to main content

Accounts Rates & Bases

Table of Contents

Accounts Rates & Bases 2

Processing Summary 2

Processing Details 2

Item Overrides 4

Accounts Rates & Bases

Processing Summary

  • Work With Storers
  • Maintain Storer Rates & Bases
  • Work With Items
  • Maintain Item Rates & Bases

Processing Details

From the "Maintenance" menu, take the "Work With Storers" option.  After you press the <Enter> key you will be presented with the following panel.

Image

Use the search criteria at the top of the panel to locate a given storer by storer numbe r or by storer name.  The order of the storer records is determined by the criteria. If a storer number or no criteria is entered, the sort will be by number.  If a name was specified, the sort will be storer name.  Place the "Rates & Bases" option, 2R, next to the account and press the <Enter> key.  The following panel will then be displayed.

Image

The default freight charge indicates the default that is to be assumed whenever a new order is entered into the system.  This code indicates who is responsible for the transportation charges associated with this shipment.  The standard charges are PS-prepaid by storer, PW-prepaid by warehouse, CO-collect, and WC-consignee will pick-up at warehouse (will call).

The default cash on delivery (COD) charge is the default amount that should print on the bill of lading for a collect shipment.  Collect shipments are generally no longer made, so this field is typically left blank.

The deferred handling percentage is used by a special report to estimate the amount of handling fees that were collected upon product receipt to cover future labor costs involved in shipping out the products.  This percentage is used to calculate how much of the handling fees collected should be shown as deferred on the report to cover these future costs.

The next entries represent rates and bases that are used to calculate storage and handling fees that will be charged to the account.  All rates support up to four digits of precision to the right of the decimal point.  The bases are used to determine the quantity that the rate is to extend to calculate the charge.  The valid bases are QY-quantity in inventory units, CW-hundred weight, CF-cubic feet, PL-pallet, or any unit of measure.  Unless otherwise overridden on an item level, these rates and bases will be used.

The recurring storage rate and basis determine the amount that will be charged for products stored in the warehouse at the close of each accounting period.

The receiving storage rate and basis determine the amount that will be charged on the warehouse receipt whenever an item is received into the warehouse.

The regular, alternate, and distribution handling rates and bases are used to calculate the handling charge during warehouse receipt.  For each warehouse receipt (and for each line on the receipt) the applicable type of handling is indicated.  The appropriate rate and basis are then used to calculate the charge.

The insurance liability amount and basis are used to report the approximate value of the inventory on hand.

Three warehouse receipt minimums can be specified for an account.  The item minimum is the minimum that will be charged for each discrete item on a receipt.  The lot minimum is the minimum that will be charged for each discrete lot on a receipt.  The total minimum is the minimum that will be charged for any receipt regardless of the size or number of items.

The recurring storage invoice minimums can be specified for an account.  As listed above, the minimums are applied at the lot, item, and total levels.  After you press the <Enter> key, you will return to the "Work With Storers" panel.

Item Overrides

Sometimes unique items exist in the account that require special handling or are oddly sized, etc.   A different rate can be associated with those items.  It is generally better to set the storer rates and leave the item rates blank.  This makes it easier to implement a rate change.  To override the rate used on a particular item, locate the item on the "Work With Items" panel and place the "Rates & Bases" option next to it.

Image

The top portion of the panel shows the storer level settings for each of the charges.  If the storer settings are appropriate for this item, leave the entries blank.  The storer settings will then be applied by all the charging processes.  This also makes it easy to implement changes to contract rates, since they only have to be done at the storer level.

Enter the receiving storage rate, basis, and minimum when this item deviates from the storer settings.  This is the pricing structure that will be charged each time the item is received into the warehouse.  Rates can have up to 4 decimal positions.  The basis may be QY-quantity in inventory units, CW-hundred weight, CF-cubic feet, PL-pallet, or any of the item's units of measure.  The minimum is the amount that will be charged if even 1 unit of the item is received.

Enter the recurring storage rate, basis, and minimum when this item deviates from the storer settings.  This is the pricing structure that will be charged at the close of each period based upon the quantity of the item that is in the warehouse at that time.  Rates can have up to 4 decimal positions. The valid bases are the same as for receiving storage.  The minimum is the amount that will be charged if even 1 unit of the item is in the warehouse.

Three handling rates are supported and are specified at the time the warehouse receipt invoice is produced.  Regular, alternate, and distribution handling rates are used to apply different pricing strategies for various types of product receipt such as regular shipments with an advanced notification, unannounced shipments, customer returns, or cross-dock shipments.

Enter a handling rate, basis, and minimum when this item deviates from the storer settings.  Rates can have up to 4 decimal positions.  The valid bases are the same as for receiving storage.  The minimum is the amount that will be charged if even 1 unit of the item is received.

The insurance liability amount is currently not used.  It is provided to support a planned report that will estimate the amount of the insurance coverage required for an account or building.  After you press the <Enter> key, the values are recorded and you will return to the "Work With Items" panel.