Versions Compared

Version Old Version 17 New Version 18
Changes made by

Gracia Surialim

Gracia Surialim

Saved on

Key

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

...

Expand
title SP-05 Gross Profit by Salesman by Invoice

This report lists the gross profit of the invoices categorized according to the salesman which might be useful for commission calculation purposes and salesman performance. 

  • 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

  • Select Transactional Type → optional

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

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

  • 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

NOTES:

  • If View Last Cost of Stock under Inventory Permission is given to the user → Report will show Last Purchase Columns at SP-05

  • Tax Amount column refer to each item tax calculation per invoice


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 date, item code, item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit for each invoice are stated clearly as Invoice Total.
  • The total of item quantity, standard price, discount, unit price, unit cost, total amount, total cost and total gross profit of invoices are calculated for each salesman stated as Salesman Total.

...