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 on daily basis. Users will be able to know which used to monitor the daily performance of each salesman and filter the performance for each item type from this report. The sales amount, sales return amount, cost amount , gross profit amount, Number of Invoice/Sales Return, Average of Invoice and Quantity Sold for each salesman is listed in the report.

Image Removed

Image Removed

the salesman. 

Image Added

  • 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

Image Added

  • 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

Image Added

  • Click Printable Page → to print current tables or columns
  • 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

...

Expand
title SP-05 Gross Profit by Salesman by Invoice

This report lists the gross profit of the invoices categorized according to the salesman . users will find it which might be useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.

  • The dateitem code, item quantitystandard pricediscountunit priceunit cost, total amount, total cost and total gross profit for each invoice are stated clearly asInvoice Total.
  • The total of item quantitystandard pricediscountunit priceunit cost, total amount, total cost and total gross profit of invoices are calculated for each salesman stated as Salesman Total.

Image Removed

Image Removedcommission calculation purposes and salesman performance. 

Image Added

  • Key in Specific Invoice Id and Calculation base, click Submit

OR 

  • Select Branch → controlled by permission
  • Select Salesman
  • Select Date Range
  • Select Calculation Base → controlled by permission to view replacement cost or MA cost by company
  • Key in Item Code Fuzzy Search, Item Code Range, and Item Category → if any
  • Select Item Status → default status is active
  • Select Item Type → deselect will generate All item type
  • Key in Specific GL Code to be excluded from the report → optional

Image Added

  • Select Transactional Type → optional

Image Added

  • Click Printable (Item Point Summary) → for summary report by salesman

Image Added

  • Click Printable Item Point → to add Point Item Columns at current tables

Image Added

  • Click Printable Page → to print current columns or tables
  • Click Export Excel or CSV → to export current columns or tables
  • Click Export to Customer Report → to print invoice details per salesman

Image Added


Expand
title SP-06 Gross Profit by Index Salesman by Invoice Report with Inventory Category Grouping

This report lists the gross profit of the invoices categorized according to the salesman by filter by item type. Users will find it useful for salesman commission calculations, as well as performance ranking and appraisal for salesmen within a company.

  • The dateitem code, item quantitystandard pricediscountunit priceunit cost, total amount, total cost and total gross profit for each invoice are stated clearly as Invoice Total.
  • The total of item quantitystandard pricediscountunit priceunit cost, total amount, total cost and total gross profit of invoices are calculated for each salesman stated as Salesman Total.

...