The Cove Search Button. Search Cove!
Welcome Home

EDI, Electronic Data Interchange - Stream V - Integrated Business Software

The Stream V Business Accounting Software - Multi Locational Inventory, EDI advantages
Stream V Business Accounting Software EDI, Multi Locational Inventory
EDI - Multi Locational Inventory, Eliminate Manual Data Entry while Increasing Efficiency & Profit in The Stream V Business Accounting Software


When an inbound 850 Sales Order is received two of the major processing issues are determining which item(s) the customer wants and selecting the appropriate inventory location from which the item should be shipped.

The system accepts three ways to identify an item; the customer item number, your house item number or the item's UPC code. 		Eliminate Manual data entry while increasing efficiency and profit. Multi Locational Inventory - EDI in The Stream V Business Accounting Software.
  • Reduce operating costs
  • Reduce total acquisition costs
  • Eliminate the source of error
  • Improve your supply chain
As the inbound 850 processor, EDI850IN, reads each EDI transaction it processes each item being ordered and performs the following steps.
  • First it tries to identify the item requested by the customer without regard to location. It does this by:
  • Searching for the customer's item number (if provided) in the cross reference data file. The cross reference file is searched for both customer specific cross reference numbers and general cross reference numbers. If the item it found in the cross reference table, and the SHIP_LOC field is set, the system uses the location from the cross reference record as the correct location to ship from. If the item number is not found the system then:
  • Searches for the house item number, if supplied by customer, in the product catalog. If the item number is not found the system then:
  • Searches for the UPC, if supplied by customer, in any location. If the item number is not found the system then saves the item with the reserved item number "MISSING ITEM" and stores all the item information provided in a comment attached to the sales order line.
  • Once the system has identified the item, it then selects the best location to ship the item from. First it determines the Default Location based on the customer's default division and department. If the customer is not assigned to a default division or department, the system uses the location associated with Division 1, Department 1.
    • Then, the system checks if there is a Preferred Location based on the zip code of the shipping address, by searching in the ZipCode file. If there is not a Preferred Shipping Location defined, the system sets the Preferred Location to the Default Location.
    • The system then checks for availability of the item in the Preferred Location. See the availability check section of this document.
    • If the item is not available in the Preferred Location, the system checks the Secondary Locations. The Secondary Locations are listed in a system control record in the sequence they should be checked.
      • The system finds the TEXTDATA record associated with the Preferred Location (TYPE="LOC", CODE="SHIPLOC1", ID=Preferred Location). If a control record exists, the system checks each of the warehouse locations (codes) listed for availability.
      • If the item is available in a Secondary Location, the system selects it as the location to ship from.
    • If the item is not available in any Secondary Location, the system backorders the item. Based on the system parameter F248:EDIBOFST the system either backorders the item in the first location that had available inventory (parameter set to Y), or it proceeds through the same sequence as when it first looked for the inventory.
Availability Check
During the processing of EDI lines the system does availability checks of the various warehouses in the system. Each time the system does an availability check on a warehouse it performs the following steps.

First, it checks if the item exists. If the item is not defined in this warehouse location it is not available.

Then, it checks if the quantity on hand, in this location, is greater than the quantity reserved. If not, the item is not available from this location.

If there is goods are available, the system then checks the cutoff time for the warehouse.

If the order shipment method (ShipVia) is flagged to check for cutoff times, and the warehouse location is flagged to check for cutoff times, and if we have passed the cut-off time, then the item is not available from this location.
Quantity Controlled Backorder Logic (QCBL)
When an item is not available in a warehouse location the system performs a check to determine whether or not to backorder the item in the current location. This check is based upon the control information defined by the QCBL table (in the LongCode file). The QCBL table contains a break point quantity that determines the point at which the required goods should automatically be backordered in first location the item is defined in. For example, if the break point is set to 10, then if the item is out of stock, the system would attempt to ship orders for 10 or less from another warehouse while orders for over 10 units would be backordered in the current warehouse.

To determine the point, at which the goods are backordered in the first warehouse where they are defined, the system checks the LongCode table for the appropriate the breakpoint quantity.
The system searches the LongCode file in the sequence below, searching first on the most specific criteria, then moving to the less specific criteria.
  • Customer Account/House Item Number
  • House Item Number
  • Customer Account/Product Line
  • Product Line
  • Customer Account
  • Default (record only have QCBL code set name and quantity)
  • The breakpoint quantity is stored in the DATA_4 field of the LongCode record.
©2010 Cove Systems, Inc. | Stream Vaast - ERP Saas Software | Stream V - Integrated Business Software | Stream POS - POS Software | Site Map