Versions Compared

Version Old Version 18 New Version 19
Changes made by

Gracia Surialim

Gracia Surialim

Saved on

Key

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


Expand
titleMISC-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.

  • Please select on the Select Date Range 
  • Filter by Select Branch
  • Filter by Select Customer Type → deselect all will generate ALL customer type
  • Filter by Item Type → Deselect Select Item Type → deselect all will generate ALL item typeSelect
  • Key in Specific GL Code to be excluded from the report → optional

Image Added

  • Tick the Display Columns
Image Removed
  •  → for more columns or tables

Image Added


Expand
titleMISC-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.

...

Expand
titleMISC-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
titleMISC-10 Multi Branch Daily, Monthly, Quarter Yearly Sales, Purchase and Collection Report

Menu Path: Reports > Manager Report > MISC 10

  1. Please select on the Date Range → Day, Month or Quarter
  2. Filter by Branch
  3. Filter by Customer Category and Type → deselect all will generate ALL customer type
  4. Filter by Item Type → Deselect all will generate ALL item type
  5. Select the Display Columns

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 Tax column to:
      • GRN Tax
      • Purchase Return Tax
      • Net Purchase Tax

...

Expand
titleMISC-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 vailability 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. 

...