Difference between revisions of "Sales per Category"

(Changed categories.)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Sales Reports|Sales Reports List]] | [[Sales per Category]] | [[Sales per Category Aids]]
+
[[Sales Reports|Sales Reports List]] | [[Sales per Category]]
 
</div>
 
</div>
 
==Sales per Category==
 
==Sales per Category==
 +
 +
=====<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>=====
 +
 +
*The user should setup have the following records in order to proceed on using the Sales Journal
 +
**[[Item Master]]
 +
**[[Item Class]]
 +
**[[Warehouse]]
  
 
======Sales per Category Menu======
 
======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.
 
'''Sales per Category''' refers to the list of Sales Transaction per Category on a given period.
Line 47: Line 56:
 
**Warehouse with inactive [[Item Class]] will not be included in the computation of the total Amount.
 
**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> =====
+
=====<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 the Main Menu, Click '''[[Reports]]'''
# Under Reports Menu, Click '''[[Sales per Category]]''' under [[Sales Reports]].
+
#Under Reports Page, Click '''[[Sales per Category]]''' under [[Sales Reports]].
# Under [[Sales per Category]], click the '''Export Button''' on the right side. Take note that you can filter the Date, [[Item Class|Category]] and [[Warehouse]] for precise exportation of records.
+
#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;"
 
{| 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:
 
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Categories:
Line 58: Line 69:
 
|- style="height:25px;"
 
|- style="height:25px;"
 
| style="" |Maintenance
 
| style="" |Maintenance
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Warehouse]]
+
| style="" |[[Maintenance]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Warehouse]]
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
Line 67: Line 78:
 
| style="" |Sales Reports
 
| 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]]
 
| 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]]
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|- style="box-sizing: inherit;"
 
| style="" |Maintenance Aids
 
| style="" |[[Item Class Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]
 
 
|}
 
|}
 +
[[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