Difference between revisions of "Sales per Warehouse"

(Changed categories.)
 
(5 intermediate revisions by the same user not shown)
Line 5: Line 5:
  
 
======Sales per Warehouse Menu List======
 
======Sales per Warehouse Menu List======
 +
[[File:Sales Reports - Sales per Warehouse - Record List.png|border|center|1500x1500px]]
 +
 +
 
'''Sales per Warehouse''' refers to the list of sales transaction per warehouse.
 
'''Sales per Warehouse''' refers to the list of sales transaction per warehouse.
  
 
=====<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 Warehouse</span></span></span></span>=====
 
=====<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 Warehouse</span></span></span></span>=====
  
*The user should setup have the following records in order to proceed on using the <span style="box-sizing: inherit;">Sales Report</span>
+
*The user should setup have the following records in order to proceed on using the <span style="box-sizing: inherit;">Sales per Warehouse</span>
*#[[Customer]]
+
*#[[Item Master]]
*#[[Sales Invoice]]
+
*#[[Warehouse]]
*#[[Accounts Receivable]]
 
  
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 44: Line 46:
 
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Sales per Warehouse</span>=====
 
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Sales per Warehouse</span>=====
  
#Under the Main Menu, Click '''[[Reports]]'''
+
#Click [[Reports]] under Main Menu
#Under Reports Menu, Click '''[[Sales per Warehouse]]''' under [[Sales Reports]].
+
#Under Reports page, click [[Sales per Warehouse]] under Sales Reports section
#Under Sales per Warehouse, click the '''Export Button''' on the right side. Take note that you can filter the Date, Partner and the Bank for precise exportation of records.
+
#Under Sales per Warehouse report, click the '''Export Button''' on the right side. Take note that the user can filter the date and the warehouse for precise exportation of records.
  
 +
[[File:Sales Reports - Sales per Warehouse - Export.png|border|center|1658x1658px]]
 +
<br />
 
=====<span class="mw-headline ve-pasteProtect" id="Viewing_Detailed_Report_on_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Viewing Detailed Report on Sales per Warehouse</span>=====
 
=====<span class="mw-headline ve-pasteProtect" id="Viewing_Detailed_Report_on_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Viewing Detailed Report on Sales per Warehouse</span>=====
  
 
#Under the Main Menu, Click '''[[Reports]]'''
 
#Under the Main Menu, Click '''[[Reports]]'''
 
#Under Reports Menu, Click '''[[Sales per Warehouse]]''' under [[Sales Reports]]
 
#Under Reports Menu, Click '''[[Sales per Warehouse]]''' under [[Sales Reports]]
#Under Sales per Warehouse, Check the Warehouse Code Column, you will see the Warehouse Code list with links. Click on the warehouse to redirect you to the View mode of the Detailed Report
+
#Under Sales Report per Warehouse, Click the warehouse links corresponding to the specific warehouse code column to view its detailed report.
  
 +
[[File:Sales Reports - Sales per Warehouse - View Detailed Report.png|border|center|1609x1609px]]
 +
<br />
 
======Detailed Report per Warehouse======
 
======Detailed Report per Warehouse======
 +
[[File:Sales Reports - Sales per Warehouse - Detailed Record List.png|border|center|1500x1500px]]
 +
 +
 
'''Detailed Report per Warehouse''' refers to the additional information on the [[Sales per Warehouse]] which includes the name of Items as well as the Quantity and corresponding Amount.
 
'''Detailed Report per Warehouse''' refers to the additional information on the [[Sales per Warehouse]] which includes the name of Items as well as the Quantity and corresponding Amount.
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 95: Line 104:
 
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Detailed_Report_on_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Detailed Report on Sales per Warehouse</span>=====
 
=====<span class="mw-headline ve-pasteProtect" id="Exporting_Detailed_Report_on_Sales_per_Warehouse" style="box-sizing: inherit;" data-ve-attributes="{&quot;style&quot;:&quot;box-sizing: inherit;&quot;}">Exporting Detailed Report on Sales per Warehouse</span>=====
  
#Under the Main Menu, Click '''Reports'''
+
#Click [[Reports]] under Main Menu
#Under Reports Menu, Click '''[[Sales per Warehouse]]''' under [[Sales Reports]]
+
#Under Reports Page, Click '''[[Sales per Warehouse]]''' under [[Sales Reports]]
#Under [[Sales per Warehouse]], Check the Warehouse Code Column, you will see the Warehouse Code list with links. Click on the warehouse to redirect you to the View mode of the Detailed Report.
+
#Under Sales Report per Warehouse, Click the warehouse links corresponding to the specific warehouse code column to view its detailed report.
 
#Click '''Export'''
 
#Click '''Export'''
  
 +
[[File:Sales Reports - Sales per Warehouse - Export Detailed Report.png|border|center|2141x2141px]]
 +
<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 114: Line 125:
 
| 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 Master Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]
 
 
|}
 
|}
 +
[[Category:Sales]]
 +
[[Category:Sales Reports]]

Latest revision as of 14:15, 6 April 2022

Sales per Warehouse

Sales per Warehouse Menu List
Sales Reports - Sales per Warehouse - Record List.png


Sales per Warehouse refers to the list of sales transaction per warehouse.

Requirements before using Sales per Warehouse
  • The user should setup have the following records in order to proceed on using the Sales per Warehouse
    1. Item Master
    2. Warehouse
Sales per Warehouse terms on Oojeema System
Field Description
1. Export Allows the user to Export the record to Spreadsheet.
2. Record Filter(Date Range, Warehouse) List of record filters for precise search of records.
  • Date Range will be set on current date by default
  • Warehouse will be set to none by default.
3. Warehouse Code Reference Code for a specific Warehouse
4. Warehouse Name of Warehouse corresponding to its Warehouse Code
5. Quantity Total number of items sold in the warehouse.

Notes:

  • Warehouse status should be ACTIVE in order to view its records.
    • Warehouse status can be seen in Warehouse Maintenance Module
Exporting Sales per Warehouse
  1. Click Reports under Main Menu
  2. Under Reports page, click Sales per Warehouse under Sales Reports section
  3. Under Sales per Warehouse report, click the Export Button on the right side. Take note that the user can filter the date and the warehouse for precise exportation of records.
Sales Reports - Sales per Warehouse - Export.png


Viewing Detailed Report on Sales per Warehouse
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Sales per Warehouse under Sales Reports
  3. Under Sales Report per Warehouse, Click the warehouse links corresponding to the specific warehouse code column to view its detailed report.
Sales Reports - Sales per Warehouse - View Detailed Report.png


Detailed Report per Warehouse
Sales Reports - Sales per Warehouse - Detailed Record List.png


Detailed Report per Warehouse refers to the additional information on the Sales per Warehouse which includes the name of Items as well as the Quantity and corresponding Amount.

Detailed Report per Warehouse on Oojeema System
Field Description
1. Warehouse Code Reference No. of the Warehouse
2. Description Description of the Warehouse
3. Item Code List of Reference No of Items in the Warehouse
4. Item Name Name of the Item corresponds to its Item Code
5. Quantity Number of Items sold on the specific Item Code/Name
6. Unit of Measure Unit of Measure of the Item
7. Price Unit Price per Unit of the specific Item
8. Amount Total Amount based on the quantity of the item and its price per Unit.

Notes:

  • Inactive Item Codes are still included in the Detailed Report
  • Changes on Prices will be shown in the Detailed Report
  • Detailed Warehouse Report can be seen only if the Warehouse status is ACTIVE
    • Warehouse status can be seen in Warehouse Maintenance Module
  • For detailed instructions on how to Export detailed Warehouse Sales Records and how to check the Detailed Report per Warehouse under Sales per Warehouse Menu. The user may visit the Sales per Warehouse Job Aid which can be found here
Exporting Detailed Report on Sales per Warehouse
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Sales per Warehouse under Sales Reports
  3. Under Sales Report per Warehouse, Click the warehouse links corresponding to the specific warehouse code column to view its detailed report.
  4. Click Export
Sales Reports - Sales per Warehouse - Export Detailed Report.png


Categories:
Modules
Maintenance Maintenance | 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