Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path: Inventory > Reports > Stock Availability  or  Trading > Other Functions > Stock Availability

Panel

Stock availability enables the user to check whether the selected stock still exists in the warehouse.

  1. Select location(s)
  2. Type Key In Item Fuzzy Search if any
  3. Key in Item Codes Rangeif any
  4. Select the Item Category to search by category → if any(need to be more than 2 characters) or Item Code Range or Select Item Category
  5. Select Status → default is active
  6. Select the inventory type
  7. Tick Options:
      • Show Zero Balance – To show the item with 0 quantity
      • Show Jobsheet Balance - Normally used by assembly operations where different parts are put together to create something whole. (Eg. auto workshop, computers)
      • Show Sales Order Balance - The amount to be sold to customers, already ordered by customers
      • Show Purchase Order Balance - The amount already ordered from the suppliers using Purchase Order
      • Show Transit Balance – To show the stock that transfer in process
      • Min Quantity – For stock replenishment
      • Max Quantity - For stock replenishment
      • Below Min Quantity - For stock replenishment
      • Above Max Quantity - For stock replenishment
      • Show Only Negative Stock – To show stock with negative quantity only
      • Display Product Image – If any image on the item
      • Description
      • Show Batch Details
      • Show Prices Exclusive of Tax
  8. Click 'Generate Report Now'
Tips

Image Removed

The quantities have codes defining different coloured fonts:

...

Image Added

  • Red Font - The stock available is above the maximum quantity level. Too much stock has been ordered and stored.stored → configure under Stock Control
  • Green Font - The stock available is below the minimum quantity level. It would be safer to make more orders as buffer stock.stock → configure under Stock Control
  • Yellow Highlight - List price is below the cost the of the stock purchased by user company. If the list price is not increased, the company will suffer a loss.
  • Purple – Service Item Type

Image Added

...

Image Removed

Image Removed

...

  • Put the cursor on the quantity to check the item information as above

Image Added

  • Click on Quantity to check the stock transaction ahead report 
NOTES:

Image Added

  • Total SO column will show when user select to show sales order balance on the option

Image Added






Related WIKI Pages:

Panel

Search Results
spacekeyWMS
maxLimit5
querystock
typepage

...