Page Comparison

Report Code	Report Name	Description
MISC-01	Multi Branch Daily Sales, Purchases And Collection Report	Users such as higher level management may find this report very useful. At one glance, users will be able to see the sales, gross profit, GRN, trade-in, purchases from suppliers and collection from customers by filtering by item type. It is somewhat a brief bird's-eye view of the management of the business on a daily basis.
MISC-02	Total Cash Collection For Delivered Invoices Report	VAT Report summarizes all the tax charged for every Invoice or Sales Return made in the selected branches and month. To set the default tax rate and branches, please refer to Configure Tax Settings and then proceed to Add Items to set tax rate for individual item codes.
MISC-03	Invoices By Delivery Status Report	This Report will show the which Invoice Number that related to delivery trips base on the State.
MISC-04	Hourly Sales Text File Report
MISC-05	Item Price Change Report
MISC-06	GST / WHT On Card Charges Report
MISC-07	GST Details On Cash Collected Basis Report
MISC-08	Controlled Drug Sales Report
MISC-09	Daily Sales Order Invoice and Collection Report
MISC-10	Multi Branch Daily, Monthly and Quarter Yearly Sales, Purchases and Collection Report
MISC-11	Purchasing and Delivery Management Report	This report is very useful for management to compare on the Sales Order Outstanding, Purchase Order Outstanding and Stock availability which can be filter by Sales Order and Delivery Date
MISC-12	Multi Branch Daily, Monthly and Quarter Yearly Sales VS Target

Expand

title	MISC-01 Multi Branch Daily Sales, Purchase and Collection Report

Users such as higher level management may find this report very useful. At one glance, users will be able to see the sales, gross profit, GRN, trade-in, purchases from suppliers and collection from customers by filtering by item type. It is somewhat a brief bird's-eye view of the management of the business on a daily basis.

Select Date Range
Select Branch
Select Customer Type → deselect all will generate ALL customer type
Select Item Type → deselect all will generate ALL item type
Key in Specific GL Code to be excluded from the report → optional

Select Calculate Base On → base on Inventory (Permission)
Tick the Display Columns → for more columns or tables

Click Printable Page → to print current columns or tables
Click Export Excel or CSV → to export current columns or tables

...

Expand

title	MISC-09 Daily Sales Order Invoice and Collection Report

SO Outstanding > refers to outstanding value of product that has not been delivered

Captured Sales > Sales Order + Cash Sales + New Invoice

Expand

title	MISC-10 Multi Branch Daily, Monthly, Quarter Yearly Sales, Purchase and Collection Report

Menu Path: Reports > Manager Report > MISC 10

Select Date Range
Select Branch
Select Customer Category → deselect all will generate ALL customer type
Select Customer Type → deselect all will generate ALL customer type
Select Item Type → deselect all will generate ALL item type
Select Calculate Base On → base on Inventory (Permission)
Tick the Display Columns → for more columns or tables

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

Notes:

Checkbox for Breakdown of Sales Figure
If user tick this option, the system will:
- Break the current Sales Before Tax column to:
  - Sales Before Tax
  - Sales Return Before Tax
  - Net Sales Before Tax
- Break the current Sales Tax column to:
  - Sales Tax
  - Sales Return Tax
  - Net Sales Tax
- Break the current Sales After Tax column to:
  - Sales After Tax
  - Sales Return After Tax
  - Net Sales After Tax

Checkbox for Breakdown of Purchase Figure
If user tick this option, the system will:
- Break the current GRN column to:
  - GRN
  - Purchase Return
  - Net Purchase
- Break the current GRN Before Tax column to:
  - GRN Tax
  - Purchase Return Tax
  - Net Purchase Tax
- Break the current GRN Tax column to:
  - Trade In
  - Payment
  - Collection

...

Expand

title	MISC-11 Purchasing and Delivery Management Report

Menu Path: Reports > Manager Report > MISC 11

Panel
This report is very useful for management to compare on the Sales Order Outstanding, Purchase Order Outstanding and Stock availability which can be filter by Sales Order and Delivery Date

Select the Branch
Key in the Customer Code or click Select for search function
Select and Tick on the checkbox for either Sales Order Date or Delivery Date → if needed
Key in specific Item Code or click Item Code Fuzzy Search → tick allow search for desctiption if want to search by any description
Key in Item Code Range → if want to filter by range
Select Item Categories → if want to filter by category
Select Item Status → All, active, inactive and deleted
Select Item Type → deselect will generate all
Select filter by Outstanding Quantity → All, zero, outstanding
Select Order Status
Tick Options → to show Quantity Available add PO Outstanding QUantity

Click on the Generate Report Now

The last columns of the report displays the computation for Availability Qty and Qty Shortage.

...

panel

Expand

title	MISC-12 Multi Branch Daily, Monthly and Quarter Yearly Sales VS Target Tax Reports

Select Date Range → Daily, Monthly etc
Select Branch → refer to Manager Reports (Perrmission)
Select Customer Category and Customer Type→ if any
Select Item Type → deselect all will generate ALL TYPE
Click Generate Report Now

Click Printable Page → to print current columns
Click Export Excel or CSV → to export current columns

NOTES:

Make sure the SALES TARGET is being SET before under Sales Target or click the "Monthly Sales Target" on the right corner of MISC-12 Report Page

User need to be GIVEN the permission to set Sales Target under Accounting (Permission) - General Permission

...

Version	Old Version 25	New Version 26
Changes made by	Gracia Surialim	Gracia Surialim
Saved on	2019-Mar-09	2019-Jun-27

Page Comparison

Versions Compared

Key

Notes: