/
Stock Purchase Report

Stock Purchase Report

Owned by Jessie Ju (Unlicensed)
Last updated: 2019-Oct-27 by Priyasri Subramaniam (Unlicensed)
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. 
 SPR-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


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

 1. Date and Rebate Columns

2. Option to display specific balance quantity

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

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
 SPR-02 Stock Purchase with PO Details Report

 SPR-03 Trade-In Report

 SPR-04 Trade-In Summary with Inventory Category Grouping Report

 SPR-05 Purchase Return Details Report

  • 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

  • Click Printable Page → to print current columns
 SPR-06 Stock Purchase Report Group by Supplier

 SPR-07 Monthly Stock Purchase Report Summary Group by Supplier

  • 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

  • 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


 SPR-08 Stock Purchase Vs Purchase Return Report

Private & Confidential