Versions Compared

Key

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


Panel

A sales analysis report shows the trends that occur in a company's sales volume over time. A record of calls made and products sold during a particular time frame kept by a sales person , outlet manager or management. For example, a sales volume observed per item or group of items.

In its most basic form, a sales analysis report shows whether sales are increasing or declining. At any time during the fiscal year, sales managers may analyze the trends in the report to determine the best course of action. Managers often use sales analysis reports to identify market opportunities and areas where they could increase volume. For instance, sales trends during periods and revenue reports. This data can help direct the company to establish market trends and demands. 

...

Expand
titleSR-01 Daily Sales Report With Cash Flow Analysis

This report allow user/Manager to monitor daily/weekly/monthly/yearly Net Sales and Collection generated by Branch

  • Select Branch
  • Select Date Range 
  • Select Customer Type from the drop down list → deselect will generate ALL types
  • Select DetailsCompany Name or Contact Person and Company Name
  • Tick Display Columns if needed

  • Tick Options → Show Receipt with 0 amount
  • Click Generate Report
  • Click Printable Page → to print current columns or tables
  • Click Printable Page without Salesman → to print current columns or tables without salesman column
  • Click Printable Page with Branch Running Number → to print current columns or tables with Branch Running Number

  • Click Printable Page with Customer Invoice Listing → to print without Payment Method, Terms, Trade In, Disc, Tax and User

  • Click Printabe Page with Signature → to print current columns or table with signature

  • Click Printable Page with Vehicle → to print current columns or table with vehicle information

NOTES:

Terms = Invoice Amount - Sum of Receipt (RCT) / Cedit Memo (CM)   
  • This Column will ONLY shown current transaction amount instead of the entire transaction amount. 

...

Expand
titleSR-05 Stock Sales Report

This report displays the In and Out of inventory quantities due to Sales or Sales Return. the balance quantity can be obtained here as at specific dates. The other information provided are :

  • Unit price = How much it is invoiced (sales price) or for Sales Return (how much is refunded or CM to customers).
  • Unit Cost (Average) = Cost / Quantity
  • Amount = Quantity x Unit price
  • Cost = Quantity x Unit Cost (Average)
  • Gross Margin = Amount - Cost
  • Margin (%) = Gross Margin / Amount x 100%

Image RemovedImage Added

  • Key in Customer PKID or click Select for search function
  • Select Custumer Type → base on drop down list under Drop Down List
  • Select Customer Category →base on drop down list under Drop Down List
  • Select Location → under Inventory (Permission) for SSR-01 Report
  • Select Branch → under Inventory (Permission) for SSR-01 Report
  • Select Date Range
  • Key in Invoice Remarks
  • Key In Item Code Fuzzy Search
  • Key in Item Code Range → if any
  • Select Item Category→ if any
  • Select Item Status → default is active

Image Added

  • Select Item Type → deselect all will generate ALL
  • Select or Tick to Separate by Salesman → if any
  • Select or Tick to Separate by Technician→ if any
  • Select Choose By → default is item code
  • Tick Options →for extra information

  • Key in Item's Unit Price Range → if any

  • Select Calculate Base On → under Inventory (Permission)
  • Select Transaction Type → if any
  • Select Display Item Category → it will shown at printable 5
  • Select GL Dimension for Filter make sure GL Dimension configuration is ENABLED under EMP Configuration - Trading

  • Click Generate Now or Generate and Export to CSV

  • Click Printable Page → to print current columns
  • Click Printable Page 2 → to print current columns without branch, customer category, customer code and salesman

  • Click Printable Page 3 → to print detailed product sales

  • Click Printable Page 4 → to print with PO Number

  • Click Pintable Page 5 → to print Display Item Category with Quantity, Selling Price, Cost Price and Amount
  • Click Export Excel xls File → to export current columns to excel file
  • Click Export CSV → to export current colums to csv file

...