Order Allocation Archives - SQLWorks

Using Shipping Controls

According to recent ONS figures, over 30% of businesses in the UK experienced difficulties getting the stock they needed during 2021, as supply chain issues continue to bite. Ensuring goods and materials arrive on time, in the right place, has become an important part of maintaining productivity.

SQLWorks offers a range of optional shipping controls that can help businesses better manage challenging supply chains, including:

 

Consolidations

Consolidations allow a purchasing manager to group individual purchase orders together into a consolidated group (for example representing the contents of a single shipping container) and assign meta-data to that consolidation, such as freight vessel numbers, suppliers, delivery details, docking dates and more.

Each new consolidation can be managed from the Purchase Ledger – simply select the purchase orders that need to be grouped and move them across the screen from left to right to assign them to the container.

consolidations

Here you can also manage other important information about that container, including actual delivery circumstances, additional on-costs or customs duty, and complete the shipping process.

On-costs can even be automatically split among the contents of that container, allowing a business to factor in the cost of shipping goods into those stock items’ cost-prices, sale-prices, and their eventual profitability.

 

Barcoding

SQLWorks permits stock-handlers to assign a barcode to any stock item, for use elsewhere in the platform. Intelligent Stock Ledger search fields allow the user to also search based on these bar codes, identifying a stock item even if only its bar code is known.

barcoding

Besides each stock item’s ‘Bar Code’ field you can also generate a preview – this same technology can optionally be used on a company’s templates for orders, pick sheets, delivery notes and many others, to help speed-up stock identification wherever that paperwork needs to be used.

SQLWorks uses EAN13 barcode generation that is accurate, internationalised, and works with a wide range of 3rd-party barcode scanning devices.

 

Dangerous Goods & Tariff Codes

With the need to declare tariff codes for internationally shipped goods, and dangerous goods codes for anything hazardous, these can be assigned to any stock item in SQLWorks under the ‘Advanced’ Tab.

tariff codes

We use formats from the UK Department for International Trade’s published 2021 dataset as our starting point.

Much like pricing or descriptions, shipping codes can be merged wherever stock items appear on documentation – please discuss with the SQLWorks team if your business has any special requirements.

 

Please speak to the SQLWorks Team to learn how our software can transform business operations. Contact us.

Fact Sheet: Order Allocation

For the most professional warehousing operations, SQLWorks includes a powerful automated order allocation system.

‘Order Allocation’ can be accessed by users who have the SQLWorks Advanced Stock module under ‘Products’ in the main Navbar .

The top of this window gives you a series of filters for every stock order recorded in SQLWorks , with a series of configurable order allocation stages that your warehouse stock must move through to be dispatched in the panel below.

Typically stock will be progressing through one of six stages:

  • ‘Unallocated’ – Stock that has not yet been processed.
  • ‘Allocated’ – Stock from a specific warehouse reserved for a specific order.
  • ‘Released’ – Stock in a specific bin location or locations, approved for picking.
  • ‘In Pick’ –  Stock that has been picked and due to be dispatched to the customer.
  • In Transit’ – Stock that is part of internal stock movements between warehouses

By default all lines that meet your search criteria are displayed on the relevant tabs on the bottom of the window. These display is automatically ‘locked’ to editing, however using the radio buttons users can make the list ‘Selectable’ to turn on or off individual (or groups of) order lines, or ‘Editable’ to change individual allocation qty within a line. Right clicking a selectable or editable line opens helpful options for highlighting mass, order group or inverse line selections.

In the unallocated tab clicking the ‘Auto Set Values’ button on the right will allocate anything SQLWorks can, when you save it will move order lines to the ‘Allocated’ Tab. Since not every allocated stock item within an order is always available for dispatch, SQLWorks releases the order allocation based on the dispatch rules set in the order:

  • ‘Allow Back Orders’ – When picked, any outstanding stock is cancelled unless SQLWorks is told to hold as outstanding items for back ordering.
  • ‘Allow Part Order’ – SQLWorks will allocate order lines as they become available, unless told to wait until the full order can be fulfilled.
  • ‘Allow Split Line’ – Send partial quantities from lines whenever they are available.

You can specify saved defaults for your company’s SQLWorks order allocation, which can be overridden with a rule for specific customer’s sales account, and are then applied to each specific order for the account.

Once released, SQLWorks can auto-generate intelligent picking notes – itemising stock to be picked using optimal warehouse walking route based on the known locations of your warehouse bins. When a pick is complete, warehouse operatives can re-enter stock ‘Fail Quantity’ figures into your order allocation history, along with reporting reasons for why the stock in question could not be picked. The remaining quantity is then automatically moved to invoice, allowing you to dispatch large numbers of orders with ease and efficiency.

An inventory Audit Log also allows you to look back through a complete history of every order line, or you can refer to the ‘Order Processing’ Tab within the Stock Ledger for a graphical summary and past failed order data.

For a more professional stock control solution – contact us about SQLWorks today: 01271 375999