Versions Compared

Key

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

...

Expand
title SP-04 Daily Gross Profit by Item Salesman Report

This report list the gross profit of sales by each salesman which used to monitor the daily performance of the salesman. 

  • Select Branch → controlled by permission
  • Select Salesman
  • Select Item Type → deselect all will generate ALL item type
  • Key in Specific GL Code to be excluded from the report → optional

  • Key in Specific Customer ID or click Select for search function
  • Select the Calculation Base → controlled by permission to view replacement cost or MA cost by company
  • Select Date Range

  • Click Printable Page → to print current tables or columns
  • Click Printable Page2 → to show print the summary of report of Gross Profit By Item Salesman

  • Click Export Excel or CSV → to export current tables or columns

Notes:

  • Calculation of AVG on INV: Eg. 100 invoice = total RM20,000; Average spend for the invoice = RM20,000 / 100 = RM200
  • For Sample Above: Salesman "wms1001" with 3 Invoices = total RM104,049.06; Average spend for the invoice = RM104,049.06 / 3 = RM 34,683.02
  • Total Unit Sold: Eg. each invoice with X number of items; Total unit sold = add up all X number for all invoice on the selected date
  • Invoices with Sales Return are not included in this report
  • GL Code item will show 0 on the Cost 


...