Difference between revisions of "How do I Use Stock Formulae?"
From Catalyst
(Created page with "{{Incomplete}} == Summary == This article explains the stock calculation formulae used in Platinum and how to configure them. == More Information == When items are added to a S...") |
m |
||
| Line 5: | Line 5: | ||
== 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. | 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 === | ||
| + | *{{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/W/P' 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 == | ||
Revision as of 10:48, 28 August 2012
 |
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.
