Internal Ordering Guide

Created by Migration Bot, Modified on Fri, 23 Oct at 2:29 PM by Migration Bot

Originally written by John Hardwick, last updated Oct 24, 2023, on the Swan Retail knowledge base (FRS).


This document is based on SwanFRS release version 1206

Overview

This document explains how to raise demand for replenishment and stocking purposes.

 Where stock is required for showroom / display purposes or if stocking levels are required to be kept at a reasonable level to facilitate quick delivery to customers it will be necessary to raise orders from suppliers where you, the retailer, is the buyer.

The process consists of

  • Raising a sales order on behalf of the retailer. This is referred to within SwanFRS as an Internal Order (Referred to in this document and in SwanFRS as IO).

  • Confirming the internal order - effectively closing the build process and creating the demand.

  • Converting the demand into one or more purchase orders

Internal order functionality resides within the purchasing menu folder.

Configuration

Application Parameters

Menu Location: System Admin > Application > Set Up Application Parameters

The following parameters affect the functionality of internal ordering.

ALWAYS_SHOW_STOCK_ON_IO

Specify whether the system is to include the stock id onto the internal order; if this is ticked then the CONSOLIDATE_IO is not considered.

  • Tick to include the stock ID when reporting the IO.

  • Untick to exclude the stock ID on the IO audit.

AUTO_GEN_TRANSFERS

Specify whether the system is to generate transfer notes should an item be GRN’d into a location other than its final destination.  This flag is only used when the final destination is set on the internal order and if, so this field is used to establish if an auto generated transfer note is required.

  • Tick to automatically create / add the item to a transfer note.

  • Unticking requires manual addition to a transfer note should this be necessary. 

CONSOLIDATE_IO

Specify if the internal order print is to consolidate like SKUs.

  • Tick to group by SKU

  • Untick to show one line per SKU on the IO print

DEFAULT_IO_DESTINATION

 

Specify whether the final destination of goods is to be the ordering or receiving location of the internal order.

  • Ordering Location - Final destination should be the ordering location of the initial order.

  • Receiving Location - Final destination should be the delivery/receiving location of the internal order.

DEFAULT_IO_VIEW

 

Specify if the default view should be at line level or grouped by like items.

  • Detailed – one line per SKU

  • Summary – collated by like SKU

PO_SHOW_CATEGORY

 

Define whether a purchase order raised from an internal order should show the category and stock status of the item.

  • Tick to show stock settings.

  • Untick to hide

USE_IO_BUYER_LIMITS

Define whether your system is to use buyer purchasing limits

  • Tick to show stock settings.

  • Untick to hide.

Locations

Menu Location: System Admin > Sales > Set Up Locations

Prior to generating internal orders, it is recommended that the following location specific defaults are set.

Define the default settings (red boxed items below) for –

  • Stock category

The default product category for goods ordered for this location.

  • Available to sell status

Specify whether the default setting for goods purchased via internal orders for this location are to be visible to sales. I.e. can be sold to customers once the internal order has been accepted.

  • Stock for display status

Specify whether the default setting for goods purchased via internal orders for this location are to be flagged as ‘for display’.

Access Roles

Menu Location: System Admin > Security > Set Up Roles

To create an internal order the operator must possess the INTERNAL_ORDER privilege.

 When operating with buyer purchasing limits the following two privileges are required.

CAN_CHANGE_IO_BUYER

Enables users to change the purchaser when creating / amending an internal order

CAN_OVER_IO_BUY

Allows users to over spend on internal orders

Users

Menu Location: System Admin > Security > Set Up Users

Where applicable set the buyer’s purchasing limit.

Reorder Quantities - optional

Menu Location: System Admin > Products > Set Up Products By Location

Where the supplier stipulates a minimum reorder quantity of a product this can be defined in the Set Up Products by Location and where set the IO ordering engine will advise the operator if the SKU is being ordered is being purchased in the correct multiple.

Operation

Internal Order Creation

Menu Location: Purchasing > Create Internal Order

This function allows the retailer to create a ‘shopping list' of items they wish to purchase, possibly from multiple suppliers, and without the requirement to link it to a customers sales order.

No items are ordered from the supplier until the IO is complete and at this point purchase orders are only generated if directed to do so by the operator.

The default internal order creation screen is shown below –

Field

Comments

Internal order

System generated ‘internal’ order reference

This process shares the numbering sequence of internal orders with sales orders. resulting in a mix of IOs and SOs however it is very easy to differentiate between the two when viewed within the system.

Pad ref no

Optional manual reference number for this internal order.

Ordering branch

The current operating branch of the user creating the internal order.

Purchaser

This field defaults to the operator’s login and is blocked from change unless the operator has the CAN_CHANGE_IO_BUYER privilege.

Where the operator can change the purchaser the list of options is restricted to those users who have the INTERNAL_ORDER privilege and are able to gain access to the IO’s ‘ordering branch’

Create PO

Ticking this box informs SwanFRS to create the purchase order when the ACCEPT button is selected.

Where not ticked and the IO is accepted the demand is visible within the Create Purchase Orders routine giving the retailer the option to merge the IO demand with other demand items, for the same supplier, raised via the sales team. This is particularly important when managing containers or there is a minimum order value / quantity.

Order date

Defaulting to today’s date for new IOs, the date the internal order was created.

Receiving location

Specify the location the goods are to be shipped to from the manufacturer.

Final destination

Specify the location the goods need to be moved if the receiving location is not the final destination.  I.e. receive into central warehouse but send out to the store once checked.

Expected delivery

The date the goods are expected to arrive.

This is calculated from the lead times of goods ordered.

Required delivery

Specify the date the goods are required into stock.

This date cannot be earlier than the longest lead time of items on the IO.

Required at final

Specify the date the goods need to reach the final destination.

This cannot be before the required at warehouse date.

Category

Optionally Specify the default category for goods on the internal order.

This field will default to that set against the ordering location.

Items added will inherit this setting. If the setting is changed mid build only newly added items will inherit this setting.

It is possible to change the category at line level. This is purely the default setting for newly added items.

Available to sell

Tick to indicate goods are available to be sold once the internal order has been accepted. Unticked indicate the goods are not to be made visible to the sales teams.

The same logic applies to this field as the category. i.e. it acts as a default setting for newly added items (which can be manually adjusted if necessary).

Display

Tick to indicate goods are to be flagged as display stock once the internal order has been accepted.

This setting is used to ‘seed’ newly added demand items, which can be changed at line level if needed.

Buying limit

If the purchaser has a buying limit set, this limit will be displayed above the order total.

Order total

The expected total cost of all items added to the IO..

 Buttons available on this page

NOTES

Via this button it is possible to enter narrative linked to the IO.

The NOTES button changes from grey to green once one or more notes have been entered. Notes can be simple notational text or can be in the form of an action requiring a follow up.

SUMMARY VIEW

Toggling with DETAIL VIEW this button changes the display to show one line per stock item or one line per SKU/option combination and is of particular use when processing a large IO.

It is not possible to amend existing lines when viewing in summary mode.

COPY

Click to initially view previously generated internal orders with a view to copying the contents into this order.

The copy option copies the entire source IO adding it to the current IO. Once added it is possible to change quantities and remove items not required for this purchase.

ACCEPT

Click to accept the internal order. 

Accepting stops further change to the IO and should only be selected once the IO is complete.

If the Create Purchase Order checkbox is ticked this will also generate one or more purchase orders ready for issuing to the supplier.

if the Create Purchase Order checkbox is not ticked the IO is copied to the Create Purchase Orders program allowing the operator to choose how and when the purchase orders are created.

PRINT

Click to produce an audit of the internal order.

This is not a purchase order but an audit of the IO.

It should not be issued to the supplier as this will cause issues at time of acknowledgement and receipt.

CLOSE

Close the order and return to the previous screen.

This option allows the operator to leave the IO in the ‘on-hold’ or build state and doesn’t complete the order.

ADD

This button act as per the add button on the sales order, i.e. allows the operator to search the product catalogue and choose items to be added to the IO.

Copy Option

This feature allows the operator to select a previously created internal order and once selected load the contents into the current order.  This process is akin to cloning an order and reduces the need to rekey all the items previously ordered.

Selecting the COPY button generates the ‘find internal orders’ page.

This page may then be used to search for existing internal orders known to the system.

Specify the search options and click the SEARCH button.  The routine will then list all matching internal orders irrespective of status.

It is possible to drill down into the internal order via clicking on the IO Number hyperlink to view the products ordered or to use the notes column to view any notes previously entered against the order. 

If an order is found which is to be ‘cloned’ tick the box in the A/N column (or if all orders are required, click the A to tick all boxes – N unticks all boxes)

Once one or more internal order have been selected, clicking theIMPORTbutton copies the order line items to the internal order.

All order lines imported on to the internal order will take the headers default definitions i.e. receiving location, category, display status etc.  (If various settings are required import items, change the header settings, import a second time, the second block of items will inherit different settings to the first block.)

SKU items which are no longer available will be ignored.

A message will be presented to screen identifying the number of order lines added and the number omitted due to discontinuation settings.

The import button may be used as many times as needed within the one IO.

Using this method, it will be possible to duplicate previously processed internal orders and to modify quantities / options as necessary once the import has completed.

The import loads all lines in the source internal order, items loaded must be removed manually using a ‘line by line’ principal.

Adding Products to the Internal Order

The process of adding product to the internal order follows the same processes as that of adding product to a sales order.

Items can be added via the ADDbutton or via the Add Product on the side panel. The system then produces the standard catalogue search options followed by a list of products matching the search pattern.

It is possible to select multiple items from a single search by ticking in the A/N column and clicking the SELECT MULTIPLESbutton. Using this feature produces a screen like that below whereby it is necessary to turn each rows tick green before the items can be added to the order.

The stock levels presented are not selectable and the prices displayed are the current promotional cost price rather than the promotional selling price displayed when viewed from with the catalogue search from the Sales menu.

Using this method it is not possible to change the category or intended status, however once added to the IO via the these settings can be adjusted.

When adding individual SKUs or editing previously added SKUs on the IO, the screen allows the setting of line specific categories, available to sell and display controls.

Note this screen shows the cost and not the selling values of the items.

The ADVANCED button allows cost price changes not selling prices. 

Where the item has a ‘standard purchase quantity’ set the system will show the Check Reorder Quantity button.  Clicking shows the purchase quantity settings for this SKU.  If an attempt to order a quantity which is not a multiple of this value a message like that shown below will be displayed.

If an SKU has options but no specific option reorder quantity the system will use the generic SKU reorder setting.

Having elected to add the item to the order if the SKU order quantity is not a multiple of the reorder value a warning screen is produced (like that shown below) where the operator may choose to continue with the chosen order quantity or replace with a recommended order quantity.

When this window is displayed the operator may elect to CONTNUE with the original specified quantity, via the ORDER X button change the quantity to a multiple of the reorder quantity or CANCEL the action.

Lower down the page theRECALCULATE button may be used if a product with options is purchased in that the option combinations may affect the standard reorder quantity.

The system will use the internal orders default settings for ‘category’, ‘available to sell’ and ‘display’ when adding new items to the order.  These may be manually modified if required.

Discounting

Line Level

When adding products use the ADVANCEDbutton to alter the cost price or click into the line value in the Total column from the Internal Order Detail page.

The final destination location will default to that set for the internal order and may be changed as required.  If the final destination is different to the receiving location, SwanFRS will, if instructed to do so, raise a transfer note to send the GRN’d stock from the receiving location to the destination location automatically.

Order Total

This feature is also available for the whole IO, Clicking Advanced from the side panel

The discount given is applied on a pro-rata basis across the items on the IO.

Order Total discounts can be removed via the CLEAR DISCOUNT button if needed.

Accepting the Internal Order

The internal order acts as a shopping list capable of holding purchase demand for several suppliers on the one order.  The operator may return to the order as many times as necessary until all items to be purchased are entered. A print out feature is available should approval be required before accepting the order.

When the IO is complete and approval to purchase gained the ACCEPT button should be selected to finalise the IO.

After this point it is no longer possible to change the composition of the order.

When in use the buyers purchasing limit will be checked and a warning produced if the sum of the cost of goods on the order exceeds this limit.

If the operator possesses the CAN_OVER_IO_BUY privilege, an alternative message will be displayed (as shown below)

Once accepted the order changes from its ON-HOLD status to COMPLETE

Once this point has reached the operator can ‘accept’ the order thus converting demand into purchase orders.

  • If the Create Purchase Orders checkbox is ticked the process will automatically create one or more purchase orders which will be waiting in the Find Purchase Order program ready for onwards progression.

  • If the Create Purchase Orders checkbox isn’t ticked the demand will be visible in the Create Purchase Orders program.

The acceptance process generates an internal order document. This is not a purchase order but a printed record of the items ordered or placed on demand.

If the Create Purchase Orders checkbox is ticked SwanFRS will, once the audit has been confirmed or cancelled display the purchase orders created within the Find Purchase Order program.

Closing this page returns control back to the internal order where the items are now shown with a yellow stock status icon.

If the Create Purchase Orders checkbox is not ticked, the IOs order lines will show with a NOT ON ORDER stock status.

The ability to cancel or amend the internal order, once accepted, is controlled via the supplier’s purchase order grace periods.  If these controls are not set or the age of the internal order exceeds the ‘Grace’ period amendments are blocked.

Find Internal Order

Menu Location: Purchasing > Find Internal Orders

This routine allows the operator to view and possible change the details of Internal Orders.

Field

Comments

Internal order number

Optionally, specify the internal order reference(s) to be searched for.

Order pad reference

Optionally, enter a manual pad reference.

Internal order date range

Ignore Date Range

Specify the date range to be searched or tick the checkbox to ignore the date range filtering.

Branch

Select the branch to be searched for.

Branch type

Select the type of branch to be searched – options

  • Ordering

  • Delivery branch

Supplier

Optionally select a supplier from the pick list.

Include Cancelled Orders

Tick if the search results are to include cancelled Internal Orders

SEARCH

Search for internal orders matching the selection criteria. 

RESET

Reset the display back to that shown at page loading.

CLOSE

Close the page without saving changes.

It is possible to make changes to internal orders that have been accepted by clicking into the order and then selecting the AMENDbutton.   Please note however certain items may be blocked from amendment, cancellation or change dependent upon their stock status and control settings within the Set Up Supplier Purchase Order Terms routine. (This routine controls how many days each supplier will allow a purchase order change / cancellation)

Search Results

The find internal orders routine allows the operator to search for specific internals orders producing a list of matching items as shown below.

Field

Comments

A/N Tick box

This column is only used when selecting existing IOs within the copy option.

Acceptance status

ON HOLD IOs currently being built

ACCEPTED completed IOs possibly with linked purchase orders

CANCELLED The IO has been cancelled.

Internal order reference

Dynamic link to the internal order detail view. 

The display shows the SwanFRS number, a minus sign, and then the operators manual order reference. 

Order Date

The date the IO was created.

Order Branch

The ordering branch for the internal order.

Delivery branch

The location the goods are expected to be shipped to from the manufacturer. (expected GRN location not the final destination location)

Qty

The total order quantity.

Total value

The order value.

Date required

The date required.

Notes

 NOTES no notes have been entered against the IO

NOTES one or more event has been recorded against this IO

Clicking opens the notes page allowing the operator to view / amend or create new notes (subject to permission).

Order View

Clicking the Internal Order hyperlink, or if only a single internal order is found from the search, the following screen will be displayed. 

To amend an accepted internal order, click the AMEND button. The allows the operator to edit order items subject to the number of days since the order was last accepted.  (I.e. amend, cancellation and addition ‘Grace’ periods set within the setup supplier purchase order terms routine)

Items already in stock or linked to purchase orders flagged as ‘Work in progress’ cannot be amended (indicated by the lack of the and  icons against the order line)

The icon only displays if the order line can be amended. This is primarily controlled via the Supplier PO terms routine mentioned earlier in this document.

The icon appears only if the order line can be deleted. This is also controlled via the Supplier’s PO terms and whether the item is in stock or not. Cancelling an order line may be blocked if the supplier does not accept cancellations, the purchase order has been flagged as in production or if the time elapsed since generating the last iteration of the purchase order is larger than the delete grace period set at supplier level. 

When editing the order line, access to the selected options may be prohibited.

If the system establishes the supplier will not accept composition changes the system allows only category and price changes.

The system will allow new items to be added to the internal order however if the supplier does not allow additions to purchase orders, the purchase order is flagged as being manufactured or if the grace period for additions has elapsed the system will generate a new purchase order as opposed to adding the new item to an existing purchase order.

For changes to be applied, newly added items to be progressed the IO should be ACCEPTED again.

Only IOs currently being worked on should show the ON HOLD status

Goods Receipting for Internal Orders

In the example below the internal order has been created with a final destination.

The purchase order raised instructs the supplier to delivery to the receiving branch

When booking in goods (GRN) which are linked to an internal order the system is capable of automatically generating a stock transfer note.

Once the GRN process has completed, if the goods receipted are linked to an internal order and the final destination location differs from the receipting location the system will do one of two actions.

If the internal order has a final destination location the GRN routine will automatically add the items to an existing transfer note or create a new one.

This process will only occur if the AUTO_GEN_TRANSFERS application parameter is ticked.  If not, the stock items will indicate a transfer is required but will not automatically be added to a transfer note.  Items requiring transfer will show a red arrow.

The system will use the date required at final destination as the transfer note required date.

Files from the Confluence page

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article