Difference between revisions of "Sales per Item"

Line 13: Line 13:
 
!Description
 
!Description
 
|-
 
|-
|1. '''Record Filter'''
+
|1. Record Filter
 
|Set of Filter options for precise search of records.
 
|Set of Filter options for precise search of records.
  
Line 20: Line 20:
 
*Records will no Quantities will not be shown in the records.
 
*Records will no Quantities will not be shown in the records.
 
|-
 
|-
|2. '''Export'''
+
|2. Export
 
|Allows the user to export the record into spreadsheet
 
|Allows the user to export the record into spreadsheet
 
|-
 
|-
|3. '''[[Item Master|Item Codes]]'''
+
|3. [[Item Master|Item Codes]]
 
|List of Item Code on the sales report record.
 
|List of Item Code on the sales report record.
 
|-
 
|-
|4. [[Item Class|'''Category''']]
+
|4. [[Item Class|Category]]
 
|Item Class/Category of the Item Code
 
|Item Class/Category of the Item Code
 
|-
 
|-
|5. '''[[Unit of Measure]]'''
+
|5. [[Unit of Measure]]
 
|Unit of Measure of the Item
 
|Unit of Measure of the Item
 
|-
 
|-
|6. Quantity Sold  
+
|6. Quantity Sold
 
|Quantity of sold on a specific Item Code.
 
|Quantity of sold on a specific Item Code.
 
|-
 
|-
Line 75: Line 75:
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |Sales Reports
 
| style="" |Sales Reports
| style="" |[[Sales Person Report&action=view|Sales Person Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Stock Ledger&action=view|Stock Ledger]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[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;"
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
Line 85: Line 85:
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="" |Sales Reports
 
| style="" |Sales Reports
| style="" |[[Sales Person Report Aids&action=view|Sales Person Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Stock Ledger Aids&action=view|Stock Ledger Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Register Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Warehouse Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Customer Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Stock Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Transfer per Stock Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Item Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Category Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Category Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Top Item Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Returns per Customer Aids]]
+
| style="" |[[Sales Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Register Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Warehouse Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Customer Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Stock Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Transfer per Stock Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Item Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Category Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales per Category Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Sales Top Item Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Returns per Customer Aids]]
 
|}
 
|}

Revision as of 09:58, 30 April 2021

Sales per Item

Sales per Item Menu

File:Sales per Item Menu.png
Sales per Item Menu

Sales per Item refers to the sales transaction report per Item from a given period of time.

Sales per Item Menu List Terms on Oojeema Prime
Field Description
1. Record Filter Set of Filter options for precise search of records.
  • Date Range will be set by the current month by default
  • Customer, Item Class , Item Master, Item Type and Warehouse will be set as Filter: All by default
  • Records will no Quantities will not be shown in the records.
2. Export Allows the user to export the record into spreadsheet
3. Item Codes List of Item Code on the sales report record.
4. Category Item Class/Category of the Item Code
5. Unit of Measure Unit of Measure of the Item
6. Quantity Sold Quantity of sold on a specific Item Code.
7. Quantity Returned Quantity of returned on a specific Item Code.
8. Net Quantity Overall quantity based on sold and returned items.
9. Amount Overall amount based on the Net Quantity of the Item Code.

Notes:

  • Brands should be on ACTIVE status in order to view its records.
    • Brands status can be seen in Brand Maintenance Module
  • Item Master should be on ACTIVE status in order to view its item code records.
    • Items status can be seen in Item Master Maintenance Module
  • Categories should be on ACTIVE status in order to view its Records
    • Category status can be seen in Item Class Maintenance Module
    • Disable Categories will not be reflected in the record alongside with its corresponding Item Code
  • Item Type should be on ACTIVE status in order to view its records.
    • Item Type status can be seen in Item Type Maintenance Module.
    • Disabled Item Types will not be reflected in the record alongside with its corresponding Item Class and Item Code
  • Warehouse should be on ACTIVE status in order to view its records.
    • Warehouse status can be seen in Warehouse Maintenance Module
    • Disabled Warehouse will not be reflected in the record. Thus the amount will be computed differently.
  • For further instructions on how to Export Sales per Item Records, the user may visit the Sales per Item Job aids which can be found here


Categories:
Modules
Maintenance Maintenance | Brand | Customer | Item Class | Item Master | Item Type | Unit of Measure | 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
Job Aid Modules
Maintenance Aids Brand Aids | Customer Aids | Item Class Aids | Item Master Aids | Item Type Aids | Unit of Measure Aids | Warehouse Aids
Reports Aid
Sales Reports Sales Report Aids | Sales Register Aids | Sales per Warehouse Aids | Sales per Customer Aids | Sales per Stock Aids | Sales Transfer per Stock Aids | Sales per Item Aids | Sales per Category Aids | Sales per Category Aids | Sales Top Item Aids | Returns per Customer Aids