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.
|
|
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.
|
|
CONSOLIDATE_IO |
Specify if the internal order print is to consolidate like SKUs.
|
|
DEFAULT_IO_DESTINATION
|
Specify whether the final destination of goods is to be the ordering or receiving location of the internal order.
|
|
DEFAULT_IO_VIEW
|
Specify if the default view should be at line level or grouped by like items.
|
|
PO_SHOW_CATEGORY
|
Define whether a purchase order raised from an internal order should show the category and stock status of the item.
|
|
USE_IO_BUYER_LIMITS |
Define whether your system is to use buyer purchasing limits
|
Locations
Menu Location: System Admin > Sales > Set Up Locations
See 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
See 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
See 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. |
|
|
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
|
|
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
Feedback sent
We appreciate your effort and will try to fix the article