Discussion

Difference between revisions of "Sales per Category"

(Created page with "== Sales per Category == ===== Exporting Sales per Category Records ===== # Under the Main Menu, Click '''Reports'''center|624x624px<br /> # Under Repor...")
 
(Changed categories.)
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
== Sales per Category ==
+
<div style="text-align: center;">
 +
[[Sales Reports|Sales Reports List]] | [[Sales per Category]]
 +
</div>
 +
==Sales per Category==
  
−
===== Exporting Sales per Category Records =====
+
=====<span class="mw-headline" id="Requirements_before_using_Sales_Journal" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Returns_per_Customer" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Sales_Report" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_AR_Detailed_Report" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Accounts_Receivable_Aging" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using Sales per Category</span></span></span></span></span></span>=====
  
−
# Under the Main Menu, Click '''Reports'''[[File:Reports.png|center|624x624px]]<br />
+
*The user should setup have the following records in order to proceed on using the Sales Journal
−
# Under Reports Menu, Click '''Sales per Category''' under Sales Reports.[[File:Sales per Category(Export) - Step 2.png|center|624x624px]]<br />
+
**[[Item Master]]
−
# Under Sales per Category, click the '''Export Button''' on the right side. Take note that you can filter the Date, Category and Warehouse for precise exportation of records.[[File:Sales per Category(Export) - Step 3.png|center|624x624px]]<br />
+
**[[Item Class]]
 +
**[[Warehouse]]
 +
 
 +
======Sales per Category Menu======
 +
[[File:Sales Reports - Sales per Category - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 +
'''Sales per Category''' refers to the list of Sales Transaction per Category on a given period.
 +
{| class="wikitable" style="margin: auto;"
 +
|+Sales per Category Menu List on Oojeema System
 +
!Field
 +
!Description
 +
|-
 +
|1. '''Record Filter'''(Date Range, Item Class, Warehouse)
 +
|Set of filter options for precise search of records.
 +
 
 +
*Date Range will be set base on the current month by default
 +
*Item Class by default will be set as Filter: All
 +
*Warehouse by default will be set as Filter: All
 +
|-
 +
|2. '''Export'''
 +
|Allows the user to Export the report into spreadsheet.
 +
|-
 +
|3. '''Item Category'''
 +
|List of [[Item Class]] in the report
 +
|-
 +
|4. '''Sales Qty'''
 +
|Number of Items that has been sold in the assigned [[Warehouse|warehouses]]
 +
|-
 +
|5. '''Base Qty'''
 +
|Number of items that the [[Warehouse|warehouses]] has.
 +
|-
 +
|6. '''Amount'''
 +
|The total amount sold base on the items categorized in the [[Item Class]]
 +
|}
 +
 
 +
 
 +
Notes:
 +
 
 +
*[[Item Class]] status should be '''ACTIVE''' in order to check its sales report record.
 +
**Item Class status can be seen in [[Item Class]] Maintenance Module
 +
**Item Class with no Sales Confirmed on their [[Warehouse]] will not be shown in the records.
 +
**Item Class with inactive [[Warehouse]] will not be included in the computation of the total Amount.
 +
*[[Warehouse]] status should be '''ACTIVE''' in order to check its sales report record.
 +
**Warehouse Status can be seen in [[Item Class]] Maintenance Module
 +
**Warehouse with no Sales Confirmed will not be shown in the records.
 +
**Warehouse with inactive [[Item Class]] will not be included in the computation of the total Amount.
 +
 
 +
=====<span class="mw-headline" id="Exporting_Sales_per_Category_Records" style="box-sizing: inherit;">Exporting Sales per Category Records</span>=====
 +
 
 +
#Under the Main Menu, Click '''[[Reports]]'''
 +
#Under Reports Page, Click '''[[Sales per Category]]''' under [[Sales Reports]].
 +
#Under Sales per Category report, click the Export Button on the right side. Take note that the user can filter the date, Item Class, and Warehouse
 +
 
 +
[[File:Sales Reports - Sales per Category - Export.png|border|center|1501x1501px]]
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
 +
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
 +
|- style="height:25px;"
 +
| style="" |Maintenance
 +
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Warehouse]]
 +
|- style="box-sizing: inherit;"
 +
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 +
|- style="box-sizing: inherit;"
 +
| style="" |Reports
 +
| style="" |[[Sales Reports]]
 +
|- style="box-sizing: inherit;"
 +
| style="" |Sales Reports
 +
| style="" |[[Sales Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Register]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Warehouse]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Customer]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Stock]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Transfer per Stock]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Item]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Category]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Top Item|Sales-Top Item]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Returns per Customer]]
 +
|}
 +
[[Category:Sales]]
 +
[[Category:Sales Reports]]

Latest revision as of 14:23, 6 April 2022

Sales per Category

Requirements before using Sales per Category
Sales per Category Menu
Sales Reports - Sales per Category - Record List.png


Sales per Category refers to the list of Sales Transaction per Category on a given period.

Sales per Category Menu List on Oojeema System
Field Description
1. Record Filter(Date Range, Item Class, Warehouse) Set of filter options for precise search of records.
  • Date Range will be set base on the current month by default
  • Item Class by default will be set as Filter: All
  • Warehouse by default will be set as Filter: All
2. Export Allows the user to Export the report into spreadsheet.
3. Item Category List of Item Class in the report
4. Sales Qty Number of Items that has been sold in the assigned warehouses
5. Base Qty Number of items that the warehouses has.
6. Amount The total amount sold base on the items categorized in the Item Class


Notes:

  • Item Class status should be ACTIVE in order to check its sales report record.
    • Item Class status can be seen in Item Class Maintenance Module
    • Item Class with no Sales Confirmed on their Warehouse will not be shown in the records.
    • Item Class with inactive Warehouse will not be included in the computation of the total Amount.
  • Warehouse status should be ACTIVE in order to check its sales report record.
    • Warehouse Status can be seen in Item Class Maintenance Module
    • Warehouse with no Sales Confirmed will not be shown in the records.
    • Warehouse with inactive Item Class will not be included in the computation of the total Amount.
Exporting Sales per Category Records
  1. Under the Main Menu, Click Reports
  2. Under Reports Page, Click Sales per Category under Sales Reports.
  3. Under Sales per Category report, click the Export Button on the right side. Take note that the user can filter the date, Item Class, and Warehouse
Sales Reports - Sales per Category - Export.png


Categories:
Modules
Maintenance Maintenance | Item Class | Item Master | Warehouse
Reports Module (Reports)
Reports Sales Reports
Sales Reports Sales Report | Sales Register | Sales per Warehouse | Sales per Customer | Sales per Stock | Sales Transfer per Stock | Sales per Item | Sales per Category | Sales-Top Item | Returns per Customer
Retrieved from "https://docs.oojeema.com/index.php?title=Sales_per_Category&oldid=6534"