Fact Sheet: Stock Quantities
SQLWorks calculates a number of different stock quantities for measuring how much stock you have.
These allow you to measure how much of each stock item are at different stages of your stock control process, and can be found displayed in the Stock Ledger for each stock item as follows. Scroll down for more information about each.
Actual
‘What I own now’
- Actual Stock is the quantity of an item you currently own within your warehouse(s.)
Pending
‘What I own which is temporarily unavailable’
- Pending Stock is the quantity of an item you currently own which is not to hand – for example Stock you own which is in ‘Transit’ internally, or stock currently waiting in ‘Make’ Bins for manufacturing.*
*The exact nature of Pending stock may vary between individual SQLWorks companies, and may represent stock dispatched but not processed, if this setting is applied – please contact your account manager to clarify.
Allocated
‘What’s been sold to a specific customer’
- Allocated Stock is the quantity of an item you currently own which has been reserved to fulfil a specific customer’s order.
Free
‘What’s really in hand’
- Free Stock is your Actual Stock minus any stock currently Pending or Allocated. This count typically represents the amount of stock you own that’s on hand, and does not include anything currently in transit, or already allocated to fulfil specific sales orders.
SOP
‘What’s been ordered’
- SOP stock is the quantity of a stock item which is wanted by your customers (currently outstanding on your sales orders.) This includes any Allocated stock already reserved to fulfil specific sales orders.
SQLWorks can be configured to exclude Forward Orders from this number.
Available
‘What would I have left’
Available stock is your Actual Stock minus your SOP. This count represents the maximum quantity of a stock item you own which could still be sold if all your sales orders were fulfilled.
WoP
‘What’s needed for parts / to be made from parts’
- WoP Stock is the quantity of an item currently listed on outstanding works orders – to be made from other stock items, or used to make other stock items.
POP
‘What’s on order’
- POP stock is the quantity of an item currently listed on outstanding purchase orders. This is stock you are expecting to be delivered by suppliers.
SQLWorks can be configured to exclude Forward Orders from this number.
Potential
‘What I could have’
- Potential Stock is all your potential stock added together. This count represents the maximum amount of stock you would have if you fulfilled all outstanding customer orders, received all outstanding purchase orders and build all outstanding works orders.
- If you are using SQLWorks MRP, the Potential stock is the quantity that will be compared to your re-order level for each stock item (within your chosen time horizon) to inform whether additional stock needs to be purchased or manufactured.
Stock Quantities Overall:
|
|
For help and advice on SQLWorks’ Stock Control capabilities, please contact our team today.