TABLE OF CONTENTS

A. On The Water Overview 

  1. Setup

  2.  Overview of the On The Water Process

  3.  Purchase Orders

  4.  Receive On The Water

  5.  Distributions for On The Water Receipts

  6. View Inventory On The Water 

  7. Reports Inventory On The Water 

  8. Pre-Book/Pre-Allocate Inventory On The Water

  9.  Receipt of Goods Auto Allocate Received in The Warehouse 

  10. Receive in The Warehouse

 

A. ON THE WATER OVERVIEW

PURCHASE ORDER > MAIN MENU > PURCHASE ORDER ENTRY AND RECEIPT OF GOODS ENTRY

  • Receive Inventory the Water and Receive in the Warehouse the same Sage 100 receiving screen or can use automatic receiving.
  • Segregate Balance Sheet Inventory G/L account for goods on the water.
  • Segregate Quantity On Hand and Quantity Received for On the Water in Item Maintenance in for the warehouse and purchase orders.
  • Track multiple purchase orders in Containers.
  • Track Pallets in Containers with License Plate.
  • Actual landed costs are recorded to inventory when received in the warehouse. Estimates while on the water are reversed.
  • Pre-book Sales Order Allocations reserving on the water inventory transfers to Received to Warehouse.
  • Provide good visibility when inventory will be received for customer service in Sales Order Entry.
  • Easy to use because there are no new screens. The standard Sage Receipt of Goods and Purchase Order entry.
  • Inventory valuation and stock status reports segregating goods on the water versus in the warehouse. 

Know where your inventory is and if its on the water - everyone from Customer Service, Purchasing to the G/L Accountant knows. The regular Purchase Order Entry and Receipt of Goods screens handle when goods are received On The Water and In The Warehouse. There is no extra input most times in Receipt of Goods Entry because the system has the intelligence to when goods where the inventory is. Purchase Order Entry and Receipt of Goods have a few new fields so there are not a lot of changes to the existing procedures. Best of all, inventory valuations are right and quantities are tracked.

When looking up available inventory, the system presents estimated and actual dates when the goods hit the water and arrive in the warehouse. Inventory quantity on hand views and open purchase orders information reflects quantities on the water from in the warehouse. Customer service can pre-book to sales orders for inventory that has not been received in the warehouse yet. The system moves the allocations automatically as inventory arrives. The system takes care of the recording actual landed costs to inventory values; previously recorded estimated landed costs are backed out.

License plate (*P) users can track inventory on containers and even if goods are palleted in containers. Users can choose to automatically separate palleted inventory from the containers as goods are received. Scanco scanners further improve receiving in the warehouse. The warehouse can validate anticipated inventory coming in containers and multiple purchase orders in containers is scanned in as simple other receipts.

Inventory maintenance/inquiry provides an easy to view inventory that is on the water, purchase order information and know when goods will arrive.

 

Inventory lookup in sales order entry and in other screens provides an easy to view inventory that is on the water and know when goods will arrive. As estimates are updated with actual dates are provided. These pick restrictions are highlighted in easy to read in red. Options grant rights if inventory is allocable to transactions while they are on the water.

  Screen_Shot_2018-09-11_at_11.56.28_AM.png

 

1. ON THE WATER SETUP

PURCHASE ORDER > SETUP > PURCHASE ORDER OPTIONS

On The Water utilizes the history files in Sage. The following options in Sage need to be set so Sage stores information to its history files. The system checks some of these options are set when you enable On The Water.

In Purchase Order Options set these options:

  • Disable Automatically Close Partially Received Purchase Orders – Click OFF – PO Options – 1. Main Tab – Automati- cally Close Partially Received Purchase
  • Enable Batching for PO Receipt Entry – Click ON – PO Options – 4. Entry Tab – Receipt Entry for Batch Processing
  • If you desire landed costs Enable Allow Entry of Landed Cost – Click ON -- PO Options – 5. Line Entry Tab – Allow Entry of Landed Cost
  • Enable Retain Receipt History – Select Yes -- PO Options – 7. History tab - Retain Receipt History.

pg_123-a.PNG

 

INVENTORY MANAGEMENT > SETUP > SCANCO WAREHOUSE MGMT SYSTEM OPTIONS >MAIN TAB

Click ON Enable On The Water in company options.

pg_123-B.PNG
  

INVENTORY MANAGEMENT  > SETUP > ACS WAREHOUSE  MGMT  SYSTEM  OPTIONS  > ADDL TAB

 PG_124-A.PNG

G/L Acct Inventory On Water If you desire the balance sheet to separate Inventory On The Water from Inventory, desig- nate a G/L Account. The account is maintained for increases and decreases for the inventory on the water.

Container ID Type Code If License Plate is enabled, an ID for containers can be selected in PO Receipt of Goods entry. Espe- cially used for goods on the water vs not often used as goods re- ceived in the warehouse. The ID Type will save time because it will auto set the container ID type when in the ID column. Allows easy selection of ID’s and the next ID number.

Break Container ID during Receipt in Warehouse Enabled if License Plate is enabled. If you do not retain inventory in the Con- tainer when the goods arrive in the warehouse, this option will au- tomatically remove the Container ID number from the received inventory.

Default Allow to Pre-Book Allocations in Sales Order Sets the default as purchase orders are created if in Sales Order Entry users be allocate inventory while in transit on the water.

Default Allow to Pre-Book Allocations in Sales Order Sets the default as purchase orders are created if in Bill of Mate- rials and Work users be allocate inventory while in transit on the water. A future feature.

No of Days calculate Est Arrival Date, Clear Date and Received in the Warehouse Date sets the estimated date when goods will arrive in port. The estimated and actual dates can be entered from the hyperlink in the purchase order’s totals tab. Receipts in the Warehouse will set the actual Received in Whse Date.

Default to Allow Auto Allocation Sets the default as purchase orders are created when goods can be automatically allo- cated with Directed Picking. The default is when goods have been received in the warehouse and moved into a pickable location.

Default to Allow Auto Allocation Sets the default as purchase orders are created when goods can be shipped. The default is when goods have been received in the warehouse and moved into a pickable location.

Visual Integrator Add On The Fly - Create Pallet Case ID No on File Import Transactions (*P) If License Plate is ena- bled you can assign IDs for imports to Receipt of Goods.

 

ITEM MAINTENANCE - CUSTOM OFFICE CHANGE FOR QOH ON THE WATER BY WAREHOUSE

Add Custom Office field to QOH Grids: Item maintenance and grids using the IM_ItemWarehouse file - you can add the field D404_QuantityOTW to the grid.

 

A/P VENDOR DEFAULTS ON THE WATER

Vendors can default purchase orders for an On The Water transaction and the default the number of days goods are shipped after the purchase order date.

Default On The Water (In Vendor Maintenance) Sets the default for purchase orders created with this vendor will be an On The Water transaction.

OTW Lead Days the default the number of days goods are shipped after the purchase order date.

 

2. OVERVIEW OF THE ON THE WATER PROCESS 

PURCHASE ORDER > MAIN MENU > PURCHASE ORDER ENTRY AND RECEIPT OF GOODS ENTRY

 Screen_Shot_2018-09-11_at_11.27.26_AM.png

Screen_Shot_2018-09-11_at_11.27.49_AM.png

 RECEIVE GOODS ON THE WATER

Screen_Shot_2018-09-11_at_11.32.25_AM.png

Screen_Shot_2018-09-11_at_11.32.36_AM.png

 

RECEIVE GOODS IN THE WAREHOUSE  Screen_Shot_2018-09-11_at_11.32.55_AM.png Screen_Shot_2018-09-11_at_11.33.13_AM.png 3. PURCHASE ORDERS

PURCHASE ORDER > MAIN MENU > PURCHASE ORDER ENTRY

Purchase Orders can be entered the same way as usual. The new fields for On The Water and the Ship Date can be defaulted from the Vendor setup ease entry for On The Water vendors. The purchase order can be revisited to set actual ship dates and other actual dates if desired. New columns in the Lines panel provides balance information for the goods received on the water and in the warehouse.

 pg_126-a.PNG

On The Water Check to designate the P/O its an On The Water. Can override the Ship Date if known. Data is defaulted from the vendor.

  pg_126-b.PNG

Qty On The Water Column Reflects the balance received on the water for the purchase order line item. It is increased as inventory is received on the water and reduced for the inventory received in the warehouse. The system uses the field to know how much inventory has yet to be received in the warehouse.

Qty Rec Whse reflects the quantity received in the warehouse. It is increased as inventory is received in the warehouse.

 

pg_126-c.PNG

InTransit—On The Water if you desire to track actual dates inventory hits the water and received into the dock, click to open the dialog screen. The actual date received in the warehouse is set automatically when goods are received in the warehouse.

Date fields are shown along side with looking up inventory.

4. RECEIVE  ON THE WATER

PURCHASE ORDER > MAIN MENU > RECEIPT OF GOODS ENTRY

P/O receipt of goods On The Water means the goods are in-transit to you and you have taken ownership of the goods. The On The Water option to Receipt of Goods will record inventory in your business. Cost of these goods are usually reasonably accurate except for the landed cost which usually can be estimated at this point. Later when you receive the goods in the warehouse the costs can be trued up and the net item cost can also be trued up.

pg_127-a.PNG

Receipt of goods for On The Water can be entered in the entry screen and can be imported with VI. Inventory received On The Water will be stored in the system with restrictions. Goods can be selected and allocated to orders. Inventory can be restricted from shipment but you can account for this inven- tory in look ups, stock status and valuation reports. With the License Plate (*P), you can record inventory to Pallets, Containers, Cartons and Case Packs.

On The Water designates the receipt of goods as an On The Water type. P/ O Entry defaults this option.

Rec on Water (Receipt Option) is defaulted to Rec On Water when no receipts have been do the purchase order. If this field is defaulted to Rec In Whse there was a previous receipt on this purchase order. You can change the option to Rec on Water when you are receiving more inventory on the water for the purchase order.

5. DISTRIBUTIONS FOR ON THE WATER RECEIPTS

pg_127-B.PNG

 6. VIEW  INVENTORY ON THE WATER 

INVENTORY MANAGEMENT > MAIN MENU > ITEM MAINTENANCE/INQUIRY

 Screen_Shot_2018-09-11_at_11.41.37_AM.png

 

 

Screen_Shot_2018-09-11_at_11.42.04_AM.png

INVENTORY MANAGEMENT > MAIN & SETUP MENU > PALLET ID MAINTENANCE/INQUIRY 

PG_128-b.PNG

7. REPORTS INVENTORY ON THE WATER

INVENTORY MANAGEMENT > REPORTS

pg_129-a.PNG

 

pg_129-b.PNG

  pg_129-c.PNG 8. PRE-BOOK/PRE-ALLOCATE INVENTORY ON THE WATER

SALES ORDER > MAIN MENU > SALES ORDER ENTRY

Sales Order Pre-Book Allocation: Allocate inventory from the restricted location, from a pallet ID and all of which within a Container ID. This Item is allocated from a pallet PAL..2 within the container CON..4.

Screen_Shot_2018-09-11_at_12.15.32_PM.png

Screen_Shot_2018-09-11_at_12.10.57_PM.png

Screen_Shot_2018-09-11_at_12.15.41_PM.png

Screen_Shot_2018-09-11_at_12.15.49_PM.png

Sales Order Allocation after Receipt In The Warehouse: Inventory and the allocation is the moved from the restricted location to the location designated in Receipt of Goods (e.g., RECEIVING). The Break Container option will remove the container ID from the inventory and allocation.

Screen_Shot_2018-09-11_at_12.15.57_PM.png

 

 

 

 

9. RECEIPT OF GOODS AUTO ALLOCATED RECEIVED IN THE WAREHOUSE

pg_130-B.PNG

  10. RECEIPT OF GOODS IN THE WAREHOUSE

PURCHASE ORDER > MAIN MENU > PURCHASE ORDER ENTRY

 

 PG_131-A.PNG


 
PG_131-B.PNG

 

 PG_131-C.PNG

--------------------------------------------------------------------------------------------------------------

(*E) Feature for Add-on for Expiration Date and Vendor Lot Traceability

(*P) Feature for Add-on for License Plating - Case Packs, Pallets, and Containers

(*W) Feature for Add-on for Wave Batch Picking