Difference between revisions of "How do I Use Stock Formulae?"

From Catalyst
Jump to: navigation, search
Line 1: Line 1:
−
{{Update}}
 
 
== Summary ==
 
== Summary ==
 
This article explains the stock calculation formulae used in Platinum and how to configure them.  
 
This article explains the stock calculation formulae used in Platinum and how to configure them.  
  
 
== More Information ==
 
== More Information ==
−
When items are added to a Stock Invoice or Stock Sales Order the system can use a formula to determine if the item's stock level is within certain limits. If you are using the Platinum Web Shop, you can also use these formulae to choose what to display when a real time stock check is carried out.
+
When items are added to a Stock Invoice or Stock Sales Order the system can use a formula to determine if the item's stock level is within certain limits.  
  
−
=== Setting up a Stock Formula ===
+
If you are using the Platinum Web Shop, you can also use a formula to choose what to display when a real time stock check is carried out.
  
−
==== Insufficient Stock ====
+
The [[A Quick Guide to Reordering|Reordering]] option can calculate [[How do I Write my Own Reorder Formula?|Reorder]] and Maximum levels, what needs to be ordered and the quantity to order based on formula.
−
When an item is added to a stock invoice in Invoicing and Customer Orders the system can perform a calculation to determine if the stock level is within the required limits. To configure this formula :
 
  
−
Go to {{PlatinumSettings}} and search for {{DataValue|insuf stock}}.
+
== Create or Edit Formula ==
−
* For {{DataPrompt|Insufficient stock formula}} select the formula code you require.
+
Go to {{Menu|{{ST}}|Maintenance Options|Formula Calculation}}.
 +
 
 +
=== Add a new Formula ===
 +
* Click {{Button|Add}}.
 +
* Enter a {{DataPrompt|Code}} (max 6 characters).
 +
* Enter a suitable {{DataPrompt|Description}}.
 +
* Enter your formula. To view a list of characters and operators to use press {{KeyPress|F11}}. The help file contains some examples to assit you with writing your own formula.
 +
* Click {{Button|Done}} and {{Button|Accept}} once the formula is complete.
 +
 
 +
=== Edit an existing Formula ===
 +
{{Warning|text=Be cautious when amending an existing formula in case it is in use within the system. We advise you make a note of the current formula before making any changes.}}
 +
 
 +
* Select the formula to amend and click {{Button|Edit}}.
 +
* Amend the {{DataPrompt|Description}} if necessary.
 +
* Amend the formula. To view a list of characters and operators to use press {{KeyPress|F11}}. The help file contains some examples to assit you with writing your own formula.
 +
* Click {{Button|Done}} and {{Button|Accept}} to save the changes.
 +
 
 +
== Applying Formula ==
  
−
See below for creating or amending these.
+
=== Insufficient Stock ===
 +
When an item is added to a stock invoice in Invoicing and Customer Orders and/or a sales Order in {{SO}} the system can perform a calculation to determine if the stock level is within the required limits. To configure this formula :
  
−
;Suggested Formula
+
Go to {{PlatinumSettings}} and search for {{DataValue|insuf stock}}.
−
* <code>S+O-A-Q1<0</code>  - will take account of the Current Stock, plus the quantity on Purchase Orders, less quantity on Sales Orders, less the quantity on the current sale and if this is less than 0 you will be shown a warning.
 
  
−
==== Reorder Formula ====
+
{{Information|iconsize=0.5|text=Each module has it's own setting.}}
−
Platinum can create a reorder report of items that need to be ordered based on this formula's result. To configure the formula :
 
  
−
Go to {{PlatinumSettings}} and search for {{DataValue|reorder}}.
+
* Select the relevant module: {{ST}} or {{SO}}.
−
* For {{DataPrompt|Default depot reorder formula}} select the formula code you require.
+
* Select {{DataPrompt|Insufficient stock formula}} and click {{Button|Edit}}.
 +
* Enter the formula code or press {{KeyPress|C-F1}} to select from a list of available formula.
  
−
See below for creating or amending these.
+
A suggested formula to use is {{DataValue|NOSTK}} {{DataValue|S+O-A-Q1<0}}
 +
This will take account of the Current Stock, plus the quantity on Purchase Orders, less quantity on Sales Orders, less the quantity on the current sale and if this is less than 0 you will be shown a warning.
  
−
;Suggested Formula
+
=== Calculating Reorder and Maximum Levels ===
−
* <code>IF S<R THEN (IF C=0 THEN (IF R=0 THEN 0 ELSE R-S) ELSE C-S) ELSE 0</code>. Using this formula if the current stock level is below the reorder level and there is a maximum stock level it will order enough to get to the maximum, else order enough to reach the reorder level else reorder nothing.
 
  
−
* You can setup multiple stock reorder formulae and these can then be applied to individual stock codes if you require
+
* See [[How do I Set Maximum and Reorder levels on Stock?#Calculate Levels|How do I Set Maximum and Reorder levels on Stock?]] to explain how to calculate levels using a formula.
 +
* See [[An In Depth Guide to Reordering]] to explain how to reorder stock and how to calculate Reorder and Maximum Levels using formula.
 +
You may also apply specific formula to individual stock items.
 
** Go to {{Menu|{{ST}}|Add or Edit Stock Items}}
 
** Go to {{Menu|{{ST}}|Add or Edit Stock Items}}
 
** Either enter in the stock code if you know it or [[How do I find a stock code?|search]] for the item.
 
** Either enter in the stock code if you know it or [[How do I find a stock code?|search]] for the item.
−
** Press {{KeyPress|F4}} to open the {{DataPrompt|Depots}} window.
+
** Click on the {{Tab|Depots}} tab.
−
** In the {{DataPrompt|Reorder Formula}} enter the code of your Reorder Formula you wish to use. If this field is left blank the system will use the default reorder formula.
+
** In the {{DataPrompt|Max Formula}} and/or {{DataPrompt|Min Formula}} enter the code of your formula to calculate the Maximum and Reorder Levels for this specific item. If this field is left blank the system will use the default formula.
−
 
 
−
==== Add or Edit Formula Calculations ====
 
−
* Select the {{DataPrompt|Formula Code:}} and enter in a new code or existing code for the formula.
 
−
* Enter a suitable description in the {{DataPrompt|Description}} field and press {{KeyPress|Enter}} to move to the formula details.
 
  
−
==== Available Variables ====
 
−
*{{DataValue|M0}} - Current months quantity sold to date.
 
−
*{{DataValue|M1}} - Last months quantity sold.
 
−
**{{DataValue|M??}} - Any number between 1 and 36 works also.
 
−
**{{DataValue|M36}} - 36 months ago sales quantity. This is the oldest available.
 
−
**{{DataValue|M1:36}} - Total of last 36 months sales. Also works with all other values from 1 to 36.
 
−
*{{DataValue|L0}} - Lost sales this month.
 
−
**{{DataValue|L1:6}} - Last 6 months lost sales not including this month.
 
−
*{{DataValue|S}} - Current stock quantity at the default stock depot.
 
−
*{{DataValue|T}} - Total stock quantity, taking in all stock depots.
 
−
*{{DataValue|O[...]}} - Quantity on purchase order [up to a due date].
 
−
*{{DataValue|A[...]}} - Allocated to sales orders [up to a due date].
 
−
**These will include any changes made on the current order.
 
−
**Adding a number after the 'O/A' will allow you to specify an end due date for orders to add to the quantity on purchase/sales order.
 
−
**{{DataValue|O7D/A7D}} - Orders due up to next week.
 
−
**{{DataValue|O1M/A1M}} - Orders due up to this day.
 
−
**{{DataValue|O1Y/A1Y}} - Orders due up to this day next year.
 
−
*{{DataValue|S+O-A}} - Free stock.
 
−
*{{DataValue|R}} - Reorder level.
 
−
*{{DataValue|C}} - Ceiling level (Maximum stocking level).
 
−
*{{DataValue|Q1}} - Current operation quantity. Selling/Purchase quantity.
 
−
*{{DataValue|Q2}} - Previous operation quantity . When editing a transaction, this will be the quantity before you amended any quantity information. '(Q1 - Q2)' = The change in quantity level for this operation, for new operations (adding items) this will be zero so the above formula will still work because (Q1 - 0) = Q1.
 
  
 
== See also ==
 
== See also ==
 
* [[How do I Run a Reorder Report?]]
 
* [[How do I Run a Reorder Report?]]
−
* [[Why are my stock levels wrong?]]
+
* [[How do I Set Maximum and Reorder levels on Stock?]]
 +
* [[How do I Write my Own Reorder Formula?]]
  
−
{{KB_Tags|Formula, Formulae, Formulas, Reorder, Invoicing, Insufficient}}
+
{{KB_Tags|Formula, Formulae, Formulas, Reorder, Invoicing, Insufficient, maximum, order}}
 
{{KB_ST}}
 
{{KB_ST}}

Revision as of 11:02, 17 October 2017

Summary

This article explains the stock calculation formulae used in Platinum and how to configure them.

More Information

When items are added to a Stock Invoice or Stock Sales Order the system can use a formula to determine if the item's stock level is within certain limits.

If you are using the Platinum Web Shop, you can also use a formula to choose what to display when a real time stock check is carried out.

The Reordering option can calculate Reorder and Maximum levels, what needs to be ordered and the quantity to order based on formula.

Create or Edit Formula

Go to " Stock Control Maintenance Options Formula Calculation".

Add a new Formula

  • Click [Add].
  • Enter a "Code" (max 6 characters).
  • Enter a suitable "Description".
  • Enter your formula. To view a list of characters and operators to use press <F11>. The help file contains some examples to assit you with writing your own formula.
  • Click [Done] and [Accept] once the formula is complete.

Edit an existing Formula

Be cautious when amending an existing formula in case it is in use within the system. We advise you make a note of the current formula before making any changes.
  • Select the formula to amend and click [Edit].
  • Amend the "Description" if necessary.
  • Amend the formula. To view a list of characters and operators to use press <F11>. The help file contains some examples to assit you with writing your own formula.
  • Click [Done] and [Accept] to save the changes.

Applying Formula

Insufficient Stock

When an item is added to a stock invoice in Invoicing and Customer Orders and/or a sales Order in Sales Order Processing the system can perform a calculation to determine if the stock level is within the required limits. To configure this formula :

Go to " Reports & Settings Maintenance Options System Administrator Platinum Settings" and search for 'insuf stock'.

Each module has it's own setting.
  • Select the relevant module: Stock Control or Sales Order Processing.
  • Select "Insufficient stock formula" and click [Edit].
  • Enter the formula code or press <Ctrl+F1> to select from a list of available formula.

A suggested formula to use is 'NOSTK' 'S+O-A-Q1<0' This will take account of the Current Stock, plus the quantity on Purchase Orders, less quantity on Sales Orders, less the quantity on the current sale and if this is less than 0 you will be shown a warning.

Calculating Reorder and Maximum Levels

You may also apply specific formula to individual stock items.

    • Go to " Stock Control Add or Edit Stock Items"
    • Either enter in the stock code if you know it or search for the item.
    • Click on the [Depots] tab.
    • In the "Max Formula" and/or "Min Formula" enter the code of your formula to calculate the Maximum and Reorder Levels for this specific item. If this field is left blank the system will use the default formula.


See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Formula, Formulae, Formulas, Reorder, Invoicing, Insufficient, maximum, order
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_do_I_Use_Stock_Formulae%3F&oldid=27977"