Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== Order Fluctuations ======
+The purpose of this feature is to detect errors as the order is keyed.  Not all the fluctuations detected will be errors, some might well be larger than normal movements,  for this reason the user can choose to "Override" and accept the order quantity as keyed.
+Fluctuation checks quantities, incorrect products are detected by the Product Restriction feature.
+Comparing a customer's order, week on week, they are very stable.  Monday of this week is very similar to Monday of the previous week, Tuesday this week, is similar to Tuesday last week and so on for each day of the week. The system uses this as a basis for detecting fluctuations.
+There are obviously differences for Bank Holidays etc.
+On detailed examination it would be found that some customers orders are less stable than others, for example it may be found that a Market Trader's order will vary more than a normal supermarket or an own shop order.
+The order for some products also varies or fluctuates more than others, for example the order for bridge rolls will be more volatile than that of Medium Sliced.
+Very small orders do not have any great effect on the overall total and have to be ignored.  For example if the customer required 5 Medium Sliced and 8 was entered in error.  This error can be ignored for all practical purposes.
+Fluctuations are based on giving :-
+Each product in the product file
+  * A Fluctuation percentage
+  * A Low limit
+Each customer
+  * Fluctuation factor
+A customer fluctuation factor of zero will prevent the system from performing fluctuation checks on this customer.
+==== The Comparison Week ====
+The comparison week, this is dependant on how the customers is defined in the "Order Generated From" field. so could be either the previous week, or the customers base week order.
+===== Fluctuations Detection Logic =====
+When an order or a amendment to an order is keyed, the new order is compared product by product to the customers comparison weeks order.
+Where the order has varied by,
+more than the product fluctuation percentage, multiplied by the customers fluctuation factor,
+and the order is greater than the product low limit,
+a fluctuation error message will be given to the operator.
+Example
+   * Smiths Stores -    Fluctuation Factor   =   1
+   * Thin Sliced -    Fluctuation Percentage   =   20%
+   * Thin Sliced -    Low Limit       =   10
+   * Smiths Stores Comparison order
+   * Thin Sliced             =    50
+Using the fluctuation logic detailed above the following results would be achieved:
+^New Order   ^Result   ^Comment^
+|60   |OK    |50 + 20% = 60 Within tolerance|
+|61   |Warning    |61 is greater than 50 + 20% so is outside of the permitted tolerance and a warning will be displayed|
+|40   |OK    |50 - 20% = 40 Within tolerance|
+|39   |Warning    |39 is less that 40 so is outside of the permitted tolerance and a warning will be displayed|
+Had Smiths Stores had a Fluctuation Factor of 2 the following results would be achieved because the percentage is multiplied by the factor 20 x 2 = 40%.  The New Order will be allowed a wider fluctuation before a warning is given.
+^New Order   ^Result   ^Comment^
+|70   |OK    |50 + 40% = 70 Within tolerance|
+|71   |Warning    |71 is greater than 50 + 40% so is outside of the permitted tolerance and a warning will be displayed|
+|30   |OK    |50 - 40% = 30 Within tolerance|
+|29   |Warning    |29 is less that 30 so is outside of the permitted tolerance and a warning will be displayed|