How do I Use Stock Formulae?
From Catalyst
Revision as of 10:48, 28 August 2012 by Chris Morrison (talk | contribs)
 |
This article or section is under development. Be aware: Content will change as the document progresses. |
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.
Available Variables
- 'M0' - Current months quantity sold to date.
- 'M1' - Last months quantity sold.
- 'M??' - Any number between 1 and 36 works also.
- 'M36' - 36 months ago sales quantity. This is the oldest available.
- 'M1:36' - Total of last 36 months sales. Also works with all other values from 1 to 36.
- 'L0' - Lost sales this month.
- 'L1:6' - Last 6 months lost sales not including this month.
- 'S' - Current stock quantity at the default stock depot.
- 'T' - Total stock quantity, taking in all stock depots.
- 'O[...]' - Quantity on purchase order [up to a due date].
- '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/W/P' will allow you to specify an end due date for orders to add to the quantity on purchase/sales order.
- 'O7D/A7D' - Orders due up to next week.
- 'O1M/A1M' - Orders due up to this day.
- 'O1Y/A1Y' - Orders due up to this day next year.
- 'S+O-A' - Free stock.
- 'R' - Reorder level.
- 'C' - Ceiling level (Maximum stocking level).
- 'Q1' - Current operation quantity. Selling/Purchase quantity.
- '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.
