The Advanced Inventory Control (AIC) Module is an exciting development for businesses with or without a warehouse that require tracking and storing of inventory in more than one location. Stock items can be tracked through the picking and receiving process, allowing you to know where your stock is at all times.

The Advanced Inventory Control module allows you to represent a physical location with up to a 20 character code that can be created in segments that relate to physical partitioning of a location (for example; zone/row/shelf/bin) for better management. Each location can be associated with one or more inventory items and vice versa. This way our software allows you to run reports on all locations in which a specific inventory item resides in or identify what inventory items reside in a specific location.

Additionally, you can further define a location by:
  • Designating a special returns location where goods that are returned by customers can be placed.
  • Designating a cross-dock location where goods that are received and sent directly out to a customer or job site are placed.
  • Setting pick and put away locations priorities at the inventory item's location level. When receiving stock you can assign it to put away locations the system suggests and when invoicing you can pick from suggested pick locations.
  • Specifying a high quantity value for an inventory item at a location to indicate the maximum quantity for reordering purposes. High quantity is also used when receiving stock to indicate when a location is full or overstocked.
  • Indicating locations as "fixed" when there is a permanent link between the inventory item and the location whether there is stock in it or not.
  • Indicating locations as "random" when there is only a link between the stock and location while there is stock in the location. Random locations are generally used for areas where stock moves in and out of frequently and it is not the permanent holding location for the item (i.e., Cross-docking, Returns areas, Customer pick up areas etc.).
  • Quarantining one or more locations if you want to reserve an area while reorganizing the warehouse or if you want to reserve stock for a period of time. You need security privileges to sell from a quarantined location. (See Setup Wizard> Users and Security> Locations tab).

This module interacts with the inventory, invoicing, purchasing/receiving/billing, departments (optional), rental (optional) and units (optional).

Advanced Inventory Control (AIC) Features



The first thing that you will need to do is create locations, or a virtual map of your store, in System 5. In this way, you can define areas of your store, allowing you to later assign items of stock to very specific areas, such as zones, aisles, rows, sections, bins or any other area that you want to define. You can also label the zones with more specific names, such as "Chilled Section" or "Hazardous Goods Sections."


stock movements

The system also allows you to move stock to and from locations for purposes of optimization or replenishment, or inventory on a work order to a customer pick up location.



receive stock in locations

Inventory items can be assigned to Locations. When an item comes into your store, it can be recieved into the highest putaway priority location. For example, a certain item may have 3 locations; the front of your store, the back of your store and in your warehouse. The first putaway location would probably be the front of your store. If that area is already full, the system will default you to the second priority location at the back of your store. If that is also full, you will be directed to the correct area of your warehouse. This way, when an item is received, you can be sure that it ends up in the most crucial place. When you are receiving this stock, you can also make a manual adjustment to this location, allowing you the flexibility to change your stock locations as required.

The system also allows for "fixed" or "random" locations. Fixed locations are permanently attached to the stock item, while random locations are temporary holding areas, such as Cross Docking, Returns areas, or Customer pick up areas.

There will also be the ability to assign the SKU to a Random Location at time of receipt in the instance of new stock coming in and not having a permanent location. This could also be used for items like temporary stock or promotional stock that will not have a permanent location.


location maintenance

The system allows you to easily update and maintain your locations. Through the Location Wizard, you can quickly add hundreds of locations in minutes. Alternatively you can add locations one at a time via the Location Maintenance grid or alternatively change locations you have added in the past. You can change whether a location is quarantined, requires picking, allocation status, purpose of the location or add a comment on a location record. The grid will also display whether the location currently is linked to an inventory item and whether it contains any stock currently. You can link to the item location record through this screen to make changes to priorities for picking and putaway.


picking by locations

The pick priority is used to identify the primary picking location. The picking priority is used to determine the order of picking when multiple locations are associated to a SKU for picking. When a sale is made and stock is staged for picking, the system will provide the first location in picking priority order with enough stock to supply the order. If you sold 10 of a SKU and only 3 were in the first picking priority location, and 15 were in the second priority, you would have 2 records on the picking slip indicating to select 3 from location 1 and 7 from location 2. The user will have the option to change any location automatically selected by the system prior to printing the picking slip.

These locations are only suggested by the system, they can be changed prior to printing the pick slip to process picking. If no picking priority is entered then the system will base priority on the alpha numeric sequence of locations attached to the SKU.



auditing with aic

As with all inventory trasactions in System Five, a full audit of all inventory transactions is available at the point of sale and PO showing user, date, time, function, data modified.