Menu Path: Reports > Manager Reports > Inventory Management
| Report # | Report Name | Description / Usage / Benefits |
|---|
| OR-03 | Item Code Stock Movement Report | This report is a combination of many reports into one. Different fields are plucked from various reports and combined into, Even though it looks very complicated, this report actually is a complete stock movement of IN and OUT together with the quantity with date range selection |
| IM-03 | Stock Balance and Sell Through Quantity by Location Report | This report is very useful to make comparison on the quantity sold within the stipulated period. This report check the stock balance, stock in and stock sell out by months |
| IM-04 | Stock Transactions Ahead Report | This report is linked from Stock Availability Reports which could view the Outstanding Purchase Order and Sales Order information. |
| Expand |
|---|
| title | OR-03 Item Code Stock Movement Report |
|---|
|
This is a combination of many reports into one. Different fields are plucked from various reports and combined into. Even though it looks very complicated, this report is actually a complete stock movement of IN and OUT, together with the quantity.
The balance quantity of item codes will be indeed, accurate. - Sales (+)
- Sales Return (-)
- Purchase (+)
- Purchase Return (-)
- COGS
- GP
- Transfer (+/-)
- Stock Adjustment (+/-)
Related Wiki Pages:| Search Results |
|---|
| spacekey | WMS |
|---|
| maxLimit | 5 |
|---|
| query | Item Code Stock |
|---|
| type | page |
|---|
|
|
...
| Expand |
|---|
| title | IM-03 Stock Balance and Sell Through Quantity by Location Report |
|---|
|
- The navigation to the IM-03 Report:
2. The main interface of IM-03 Report that user will be navigating through: 
3. The first enhancement: 
- The highlighted columns are those new columns has been added next to each respective "Sold" column. The added columns are as follows:
- Sold in last one month
- Sold in last 3 months
- Sold in last 6 months
- This enhancement allows user to make comparison on the quantity sold within the stipulated period.
4. Get Last Cost From:  Image Added
- Item Last Cost- Get from last_unit_cost column in inv_item table. Amount come from the latest price in Purchase Return, Stock Adjustment, Supplier Consignment or GRN.
- Last Purchase Cost- Get from unit_price column in inv_stock_delta table. Amount come from the unit price of latest GRN.
- Last Average Cost - Get from net_price column in supp_grn_item table. Amount come from the net price of latest GRN.
5. The latest enhancement: 
- The latest enhancement added the new filter as in Tick Option to filter result by Sold Last for 1 Month, 3 Month and 6 Months
- This indicates no any table of the report having the width looked disproportion due to previous enhancement made
 Image Added
- If the checkbox is not ticked, the Last Sold quantity will not be displayed separated as in 1 month, 3 months and 6 months, instead the quantity will be displayed in Total amount of previously sold quantities as per shown in the following image.
- The image above illustrates the result filtered by the ticked option
- As shown in the image above, the Sold Last is not ticked, which allows to generate the report without having to show the Sold Last in a single printable page
Related Wiki Pages:| Search Results |
|---|
| spacekey | WMS |
|---|
| maxLimit | 5 |
|---|
| query | IM-03 Report |
|---|
| type | page |
|---|
|
|
...
| Expand |
|---|
| title | IM-04 Stock Transaction Ahead Report |
|---|
|
 Image Added
- Select Date
- Select Location → compulsory
- Key in Item Fuzzy Search → if any
- Key In Item Code Range → if any
- select item category → if any
- select item status → default is active
- Select item type → deselect all to generate all type
- Tick Options → if any
- Click Generate Report Now
 Image Removed Image Added
 Image Added
 Image Removed Image Added
Related Wiki Pages:| Search Results |
|---|
| spacekey | WMS |
|---|
| maxLimit | 5 |
|---|
| query | Stock Transaction |
|---|
| type | page |
|---|
|
|
...