Versions Compared

Version Old Version 9 New Version Current
Changes made by

Jia Pei Chan

Priyasri Subramaniam

Saved on

Key

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


Report CodeReport NameDescription

SPR-01 

Stock Purchase Report
  • This report allows user to view the list of GRN's, Qty, Cost and Change in Price (%)
SPR-02 Stock Purchase with PO Details Report
  • User will be able to view the list of GRN and PR with Item code details 
SPR-03 Trade-In Report
  • This report lists out the Trade-In item codes and the CM document number as well as the Cost and Price Change (%)
SPR-04 Trade-In Summary with Inventory Category Grouping Report
  • This report displays the Documents related to Trade-in based on the filter selected for the Item Category
SPR-05 Purchase Return Details Report
  • User will be able to view the PR list with the relevant GRN No. and the details (Supplier, PIC, Item Code, Price and Qty)
SPR-06 Stock Purchase Report Group by Supplier
  • This report shows the list of GRN with the details and grouped by Suppliers 
SPR-07 Monthly Stock Purchase Report Summary Group by Supplier
  • This report sums up the Purchase amount by each supplier
SPR-08 Stock Purchase Vs Purchase Return Report
  • User will be able to generate the report to view the list of GRN and PR based on date range. This report also indicates the Total reduction after PR. 


Expand
titleSPR-01 Stock Purchase Report

Notes:

  • Red : Change in Price % is negative,  
  • Green : Change in Price % more than 3%  
  • Black : Change in Price % none of the above
  • Rebated Price : Recorded in PO/GRN
  • Rebate Items : Recorded in Edit Item > Pricing Scheme
  • Last Cost : Last Purchase Cost by Company


The image above shows the function page of SPR-01 Stock Purchase Report with Show few specific fields.

The new enhancement

, eg:

a 1. Added the Date and Rebate Columns

b

2.

Added the option

Option to display

only positive

specific balance quantity

3. Stock in or GRN from Supplier Consignment Conversion or Billing

Image Added

Notes:

  • Please refer to line 1 and 3 for the Stock IN or Stock Purchase from Supplier Consignment(Red Box)
  • Please refer to line 2 and 4 for the Stock Out or Stock Return from Supplier Consignment


Expand
titleSPR-02 Stock Purchase with PO Details Report

...

Image Removed

Image Removed
Expand
titleSPR-05 Purchase Return Details Report

Image Added

  • Select Branch
  • Key in Specific Supplier PKID or click Select for seach function
  • Key in Item Code 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 will generate ALL
  • Click Generate Now

Image Added

  • Click Printable Page → to print current columns


Expand
titleSPR-06 Stock Purchase Report Group by Supplier


Image Removed

Image Removed
Expand
titleSPR-07 Purchase Order Recommendation Listing

Image Removed

Expand
titleSPR-08 Monthly Stock Purchase Report Summary Group by Supplier

Image Added

  • Key in Specific Supplier PKID or click Select for search function
  • Select Location
  • Select Date Range
  • Key in Item Code 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 will generate ALL
  • Select Supplier Category → under Drop Down List
  • Click Generate Report Now

Image Added

  • Click Printable Page → to print current columns
  • Click Export Excel xls File → to export current columns to excel file
  • Click Export CSV → to export current columns to CSV file
Tips:
  • SPR-07 shows total EXCLUDE tax and Purchase Return → can be compared with GRN Listing

Image Added



Expand
titleSPR-09 08 Stock Purchase Vs Purchase Return Report

...