Miscellaneous

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

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.

This Report will show the which Invoice Number that related to delivery trips base on the State.

• Key in specific Customer PKID or Select Customer for search function → leave 0 will generate ALL customer
• Enter the Date Range and Sort by → Dispatch Date or Invoice Date
• Select State
• Click 'Generate Report Now'

Notes:

• The Reference No on the List is referring to the 3rd Party Consignment Note which has been scan into delivery pool

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

Captured Sales > Sales Order + Cash Sales + New Invoice

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

Menu Path: Reports > Manager Report > MISC 11

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

• 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