The Warehouse Shipping Rates table contains shipping freight rates that are incurred when goods are transferred from the main warehouse to a secondary warehouse by warehouse transfer. When transfers are processed via the In-Transit method, triggered by using TAT code WHS in OE30 (for more information, see IN02), the cost of the transferred product is inflated by the Freight Percentage identified on this screen.
Inventory Transfer Methods-Transferring Products through an In-Transit Warehouse Transfer:
- Decreases quantity on hand in the sending location and increases quantity on order in the receiving location. The Transfers In-Transit account is debited; Inventory for the sending location is credited.
- When the goods are received at the destination location, the receipt is confirmed via programs IC55 and IC56. The quantity on order is reduced and quantity on hand is increased.
- Freight is added to the product cost as defined in this program. In this scenario, the G/L distribution of costs looks like this:
- assume transfer of product from whse 01 to whse 02
- assume product’s cost in whse 01 = $100.00
- assume freight factor incurred when shipping from 01 to 02 = 1%
When Warehouse 01 ships the goods:
DR In-Transit Clearing 100.00
CR Inventory-Whse 01 100.00
When Warehouse 02 receives the goods:
DR Inventory-Whse 02 101.00
CR In-Transit Clearing 100.00
CR Freight Clearing 1.00
- The GL accounts for In-Transit Clearing and Freight Clearing are defined in Company Control Initialization (CC00/Invoicing).
Note: If goods are returned, cost is reduced by the same percentage to reverse the mistake of the initial shipment.
Setting Up a Warehouse Shipping Rate:
- Enter or select from the query a warehouse in the Destination Warehouse field. Note: You cannot select the main warehouse (as set up in CC00/Inventory Control).
- Enter or select a commodity code in the Commodity Code field.
The Commodity Code is used to apply the Warehouse Shipping rate to a specific group of products. You can change the freight rates for different commodity codes. For example, the freight percentage for Garden supplies is 8% and the freight percentage for Housewares is 5%.
- Enter a percentage in the Freight Percentage field. This rate is applied whenever WHS type transactions are processed through Order Entry and Invoicing.
- Click Update to add the new Freight Percentage to the system.
The following table outlines the functionality of each button on the Warehouse Shipping Rates folder:
Button Label |
Icon |
Functionality |
Update |
|
Saves the information entered for the current destination warehouse. |
Delete |
|
Deletes the current destination warehouse.
Note: You cannot delete a destination warehouse if the code is assigned to a product in IM13. |
New |
|
All fields on this folder clear and you can begin adding a new destination warehouse record. |
IM09/Warehouse Shipping Rates
|