Versions Compared

Version Old Version 23 New Version 24
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.

  • 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
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

  • 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
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 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. 


Expand
titleMISC-12 Multi Branch Daily, Monthly and Quarter Yearly Sales VS Target Tax Reports


Panel


Image Added

  • 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

Image Added

  • 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 Accounting Maintenance or click the "Monthly Sales Target" on the right corner of MISC-12 Report Page

Image Added