Versions Compared

Key

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

...

Expand
titleOR-01 Stock Aging Report

Image Added

  • Select Company
  • Select Date → by day or month
  • Key in Item Code Fuzzy Search → tick to search by description
  • Key in Item Code Range or Specific Item Category
  • Select Item Status
  • Select Item Type → deselect will generate All
  • Select Group by → base on Item Category Grouping
  • Select Calculate cost base on → Current MA, Historical MA, GRN Cost
  • Select Order by 
  • Tick Options → Positive Balance, Zero Balance, and Negative Balance
  • Select Status
  • Click Generate Report Now

Image Added

Image Added

NOTES:

  • If you choose GRN Cost, please do not compare it with the Inventory Aging report, because the method of calculations are different


Expand
titleOR-02 Stock Aging Report by Location

This report helps to show the Stock Aging by Location, the quantity uses the first in first out method regardless of the calculation. 

  • Select Company and click Submit
  • Select Location
  • Key in Item Code Fuzzy Search → tick to search by description
  • Key in Item Code Range or Specific Item Category
  • Select Item Status
  • Select Item Type → deselect will generate All
  • Select Date → by day or month
  • Select Group by → base on Item Category Grouping
  • Tick Aging Range (in days) → if any
  • Select Calculate cost base on → Current MA, Historical MA, GRN Cost
  • Select Sort by 
  • Tick Options → Positive Balance, Zero Balance, and Negative Balance
  • Select Group by → location or company
  • Click Generate Report Now

NOTES:

  • If you choose GRN Cost, please do not compare it with the Inventory Aging report, because the method of calculations are different

...

Expand
titleOR-05 Item Stock Listing by Category

Image Added

  • Select Category
  • Tick to display pseudo items
  • Tick to display category 1 field
  • Click Submit

Image Added



Expand
titleOR-06 Stock Movement Details by GRN Report



...