Versions Compared

Version Old Version 3 New Version Current
Changes made by

Priyasri Subramaniam

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

Image Added

Image Added

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


SPR-01 Stock Purchase Report Show few specific fields, eg:

 1. Date and Rebate Columns

Image Added

2. Option to display specific balance quantity

Image Added

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 Added

Image Added


Expand
titleSPR-03 Trade-In Report

Image Added

Image Added


Expand
titleSPR-04 Trade-In Summary with Inventory Category Grouping Report

Image Added

Image Added


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 Added

Image Added


Purchase Order Recommendation Listing
Expand
titleSPR-07 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-08 Stock Purchase Vs Purchase Return Report

Image Added

Image Added