Periodic Checking

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

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


This document is based on SwanFRS version 1206

Overview

SwanFRS monitors the status of orders and stock within the system, however it is necessary to ensure the data being entered it is accurate, and that tasks are being completed in a timely manner this document details the steps recommended at specific time frames to ensure the information available is accurate and representative of the actual position.

The reports listed in this document are a guide to the type of audit available, there are additional reports available within the system and not all reports are listed here.  It is recommended that each report is examined for suitability and added into the daily, weekly or periodic process as appropriate to your business.

This document does not address any accounting interface, concentrating primarily on the sales, purchase and stock processes within SwanFRS.

Recommendations and suggestions are optional, but if adopted should result in a more controlled and managed system.

Daily

During the day orders are processed, stock receipted / delivered and moved, monies received and so on. To ensure this data is correctly and accurately specified the following steps are recommended.

Sales Ordering

Salesperson

It is recommended that each salesperson checks their own orders daily to ensure they are processed to the appropriate state.

At the end of each day, or more frequently if desired, each salesperson should use the Find Sales Order routine to check their own orders.

Menu Location: Sales > Find Sales Orders

The screen may appear differently on your system.

Branch:

This needs to be the salespersons place or work for the searched date range.

Sales Order Date Between:

Specify the date range to be used.  Usually this will be the current working date or perhaps yesterday to today.

The larger the date range the more orders will be reported.

Show Open Orders Only

Ticking extracts only orders where further action is required.  It excludes quotations, cancelled sales and fully delivered sales.

Salesperson:

Select the salespersons name from the list

Search First Only

Ticking this box will only extract sales orders where the selected salesperson is the primary salesperson, leaving this un-ticked will bring back all orders where the salesperson has one or more order lines linked to them.

Other search criteria may be specified however this is the minimum requirement to view the list of ‘open’ orders processed within the selected date range.

 Having selected the SEARCH button, the screen will list orders matching the selection criteria.

  • The salesperson should work through the list ensuring all orders are accepted .  The rule should be that no orders are left in the ON HOLD status longer than absolutely necessary. 

  •  All orders showing a blank customer should be modified or cancelled.

  •  All orders showing zero quantities should be completed or cancelled.

(Orders showing no customer and no quantity are indicative of someone using the new sales order to view stock).

The salesperson should also check to ensure there are no missing or additional orders on the list – if this is the case then someone may be using your login code erroneously and perhaps a password change is required.

It is the salespersons responsibility to ensure orders are entered on to the system correctly – if orders are not being recorded correctly this causes all following sales activities to become compromised.

Do not leave this to someone else. Check your own orders and ensure the order has been recorded correctly before moving on to the new day’s activities.

Ideally there should be no ON HOLD orders at the end of each day.

Sales Managers

It is recommended that each sales manager checks the order book daily.

At the end of each day, or more frequently if desired, use the FIND SALES ORDERS routine to check order status.

Menu Location: Sales > Find Sales Orders

The screen may appear differently on your system.

Branch:

This needs to be the salespersons place or work for the searched date range.

Sales Order Date Between:

Specify the date range to be used.  Usually this will be the current working date or perhaps yesterday to today.

The larger the date range the more orders will be reported.

Click the ignore date range option to get a full picture of the order book.

Show Open Orders Only

Ticking extracts only orders where further action is required.  It excludes quotations, cancelled sales and fully delivered sales.

Order Status

Select each one in turn to ensure the order book is correctly managed.

If an order is unauthorised, unaccepted or on hold it can cause a delay in delivery and indicates that staff may not be completing order creation / amendments correctly.

Goods Status

Using the filters, it is possible to establish the status of the order lines, thus enabling decisions to be made as to whether customers can be contacted for final payment / deliveries scheduled etc.

Financial Status / Type

Using these filters, it is possible to ensure monies are requested from customers in a timely manner and where appropriate funds are requested from the finance house.

Having clicked the SEARCHbutton, the screen will list orders matching the selection criteria.

Purchasing

Sales Demand

This is recommended for the person responsible for ensuring goods get ordered from the supplier in a timely manner.  It is suggested this process be performed daily but this can be less frequent dependent upon purchasing policy.

Check demand in the system to ensure goods are being ordered in a timely manner.

Menu Location: Purchasing > Create Purchase Orders

The All branches option shows all purchase demand alternatively use the appropriate branch.

Alternatively, if a purchase demand list can be obtained by using the purchase order optimization routine.

If a report is preferred the purchase demand report is available.

Remember goods cannot be purchase ordered for a sales order until it has been accepted at least once.

Deliveries

Delivery Scheduling

Recommended for the salesperson or admin team responsible for contacting the client re progression of the order.

It is suggested that whenever possible the following procedure is used to ensure deliverable items are flagged for delivery as soon as possible.

Menu Location: Sales > Find Sales Orders

Ensure the Ignore Date Range is ticked, set the Show Ready-For-Delivery Orders Only. Other flags can be set as necessary.  Clicking search lists all the orders with one or more item which is ready for delivery.

 Ensure that there are no deliveries showing in the ‘confirm deliveries’ page for previous days.

Confirming Deliveries

Recommended for the delivery (warehouse) admin person

Daily the confirm delivery page should be checked to ensure deliveries are being processed correctly.

Ensure there are no deliveries which are waiting to be processed which are more than a couple of days old.

Menu Location: Deliveries > Confirm Deliveries

Finance

Recommended for the department head / admin team

At an appropriate time, each day the day’s monetary takings need to be checked, comparing the actual amount in the cash drawer to those recorded within SwanFRS.

If there is an inconsistency it is recommended that this be addressed as soon as possible as generally the person responsible for taking the payment would be on the premises to assist in the investigation.

Menu Location: Accounts > Cash Reconciliation

Alternatively use the Unreconciled Payments report

Weekly

Sales

Recommended for sales managers and department heads

Ensure the order intake is being managed correctly.  Spot check the sales consultants within the team.

Via the find sales orders option within the sales folder.

Look at the number of cancelled sales – do any members of the team need more training.

Chase Report

This report may be used to ensure orders are being processed correctly. This report should be as short as possible.

See Chase

Debtors Report

This report may be used to find which customers owe money to the company. The ideal is for this report to report a zero value.

See Debtors

Unallocated Payments

Use this report to see which customers have monies with the company which are not allocated to sales orders.  The ideal is that this report shows zero value each week.

Incomplete Sales

Use this report to identify sales orders where action is required to complete the sale.  The ideal is for the report to be as short as possible.

Low Deposits

Use this report to establish which orders have been taken where either the sales person too less than the selected minimum deposit percentage.

Unconfirmed Sales

This report lists all sales orders which have not been accepted i.e. ON HOLD status orders

Purchasing

Recommended for the purchasing manager

Ensure old purchase orders are completed – check to establish why the goods are outstanding (have not been receipted) and if necessary cancel the order remembering to also cancel any associated internal orders. 

Use Find Purchase Orders and the not received flag – move to the end of the list to find the oldest order. 

Menu Location: Purchasing > Find Purchase Orders

PO Not Acknowledged

Use this report to establish which orders have not been recognised by the supplier.  (Must set the normally acknowledge days against the supplier)

PO Chase / PO Chase Fax

Two flavours of this report are available which should be used as a reminder to the supplier.

Internal Orders

A check should be performed to ensure that internal orders being generated are correct and have been completed thus allowing them to be turned into purchase orders.  (Goods cannot be purchase ordered for an internal order until it has been accepted) use this routine to list all internal orders generated within the selected date range.

Menu Location: Purchasing > Find Internal Orders

Any internal order showing the ON HOLD badge will not show as demand. 

Stock

Recommended for the stock / manager (warehouse and store)

There are several areas within the stock arena requiring regular checking.

For each of the following it is recommended that the find option is used and the results check to ensure all actions are completed correctly.

Write On Notes

For a mature system write on notes should be at a minimum.  All notes should be finished i.e. showing the  icon.   ON HOLD indicates notes which are not finalised – if a note is several days old it should be investigated.

Menu Location: Warehouse > Find Write On Notes

If excessive use of write on notes is occurring investigate why goods are not being GRN’d into stock.

Write Off Notes

Write off notes are a way of leaching product from the system and need to be monitored and managed.

It is important that notes are completed and not left open – ensure the ‘date complete’ is set against each note.

Menu Location: Warehouse > Find Write Off Notes

Transfer Notes

Transfer notes should be completed – if a note shows a red lorry the note is open and can have additional stock added to it.  Old open notes need to be investigated.

  • Red badges indicate the transfer has not been sent.

  • Green badges indicate the transfer has been sent and may be partially received.

  • Blue badges indicate the transfer has been completed.

Any transfer with a green truck icon that is several days old should be investigated.

Menu Location: Warehouse > Find Transfer Notes

Return to Suppliers

Monitor the number of RTS notes in the system.

If the note shows a red lorry the goods are still in the system and have not been collected by the supplier.

Menu Location: Warehouse > Find RTS Notes

Transfer Stock

As goods are sold within the system they may need moving from one location to another.

Choose the function option and tick ‘require transfer’, used in partnership with the location and other options it is possible to see which goods need moving and to where.  In a managed system, this list should be minimal.

Menu Location: Warehouse > Search Stock

Deliveries

Recommended for system auditors and delivery department managers.

As per daily – spot check to ensure confirmations are being processed.

Periodic

It is recommended that system auditors and managers spot check the steps listed in the daily and weekly options to ensure the system is being kept up to 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