Skip to end of banner Go to start of banner

Other Stock Reports

Skip to end of metadata

Created by Jessie Ju (Unlicensed) , last modified by Gracia Surialim on 2019-Mar-16

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

OR-01 Stock Aging Report

OR-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

OR-03 Item Code Stock Movement Report

Select Location
Select Date → by Date Range, by Month or by Single Date
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 → by item category level
Tick Option → to show GP amount

OR-04 Stock Adjustment By Reset Moving Average

Key in specific Item Code or leave it blank for all
Select Location
Select User
Select Item Code Range → optional
Select Date Range
Select Entity Type → optional
Select Sort By
Click Generate Report Now

This report also shown the "Entity" which link with the Reference Doc under Reset MA

OR-05 Item Stock Listing by Category

OR-06 Stock Movement Details by GRN Report

OR-07 Stock Value by Level Report

OR-08 GRN, Purchase Return and Trade In Listing

Select Branch → refer permission Inventory (Permission) under Other Report section
Select Document Type → deselect all will generate ALL
Select Date Range
Click Generate Report Now

OR-09 Price Movement History Report

OR-10 Gross Profit Report with Adjustable Cost

OR-11 Multi Stock Card Report

OR-12 Batch and Expiry Date Report

OR-13 Stock Adjustment by Reset Moving Average by Company

OR-14 Historical Stock Value by Level Report

OR-15 Item Weight Report

OR-16 Encoded Item Code Stock Movement Report

No labels

Private & Confidential