Difference between revisions of "Sales Report"

(Tag: 2017 source edit)
(Changed categories.)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{DISPLAYTITLE:Sales Report(Module)}}<div style="text-align: center;">
 
{{DISPLAYTITLE:Sales Report(Module)}}<div style="text-align: center;">
[[Sales Reports|Sales Reports List]] | [[Sales Report]] | [[Sales Report Aids]]
+
[[Sales Reports|Sales Reports List]] | [[Sales Report]]
 
</div>
 
</div>
  
 
==Sales Report==
 
==Sales Report==
 
======Sales Report Menu======
 
[[File:Sales Report Menu1.png|center|thumb|1052x1052px|Sales Report Menu]]
 
 
 
 
'''Sales Report''' refers to the list of sales transactions in a given month or per year basis.
 
'''Sales Report''' refers to the list of sales transactions in a given month or per year basis.
 +
[[File:Sales Reports - Sales Report - Record List.png|border|center|1500x1500px]]
 +
<br />
 +
=====<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 Report</span></span></span>=====
  
===== <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 Report</span></span></span> =====
+
*The user should setup have the following records in order to proceed on using the <span>Sales Report</span>
 
+
*#[[Customer]]
* The user should setup have the following records in order to proceed on using the <span>Sales Report</span>
+
*#[[Sales Invoice]]
*# [[Customer]]
+
*#[[Accounts Receivable]]
*# [[Sales Invoice]]
 
*# [[Accounts Receivable]]
 
  
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 34: Line 30:
 
|-
 
|-
 
|3. '''[[Customer]]'''
 
|3. '''[[Customer]]'''
|List of Customer on the Sales Report Record
+
|List of Customer on the [[Sales Report]] Record
 
|-
 
|-
 
|4. Month Range
 
|4. Month Range
Line 45: Line 41:
  
 
======Detailed Sales Report Menu======
 
======Detailed Sales Report Menu======
 +
[[File:Sales Reports - Sales Report - Detailed Record List.png|border|center|739x739px]]
 +
 +
 
'''Detailed Sales Report''' Menu refers to the detailed information per customer regarding their sales status.
 
'''Detailed Sales Report''' Menu refers to the detailed information per customer regarding their sales status.
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
Line 67: Line 66:
 
|-
 
|-
 
|6. Reference
 
|6. Reference
|The reference transaction no. attached for the Sales Invoice
+
|The reference transaction no. attached for the [[Sales Invoice]]
 
+
*It is different from Sales Invoice No. Reference
*It is different from the Sales Invoice No. Reference
 
 
|-
 
|-
 
|7. [[Accounts Receivable|AR No]]
 
|7. [[Accounts Receivable|AR No]]
Line 75: Line 73:
 
|-
 
|-
 
|8. Amount
 
|8. Amount
|Total Amount of the Sales Invoice.
+
|Total Amount of the [[Sales Invoice|Sales Invoice.]]
 
|}
 
|}
 
Notes:
 
Notes:
Line 82: Line 80:
 
**Customer status can be seen in [[Customer]] Maintenance Module
 
**Customer status can be seen in [[Customer]] Maintenance Module
  
===== <span class="mw-headline" id="Exporting_Sales_Report" style="box-sizing: inherit;">Exporting Sales Report</span> =====
+
=====<span class="mw-headline" id="Exporting_Sales_Report" style="box-sizing: inherit;">Exporting Sales Report</span>=====
  
# Under the Main Menu, Click '''[[Reports]]'''
+
#Click [[Reports]] under Main Menu
# Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]].
+
#Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]] Section.
# Under [[Sales Report]], click the '''Export Button''' on the right side. Take note that you can filter the Date, and the Customer for precise exportation of records.
+
#Under Sales Report, click the Export Button on the right side. Take note that the user can filter the year and the customer for precise exportation of records.
  
===== <span class="mw-headline" id="Viewing_Vouchers_on_Sales_Report" style="box-sizing: inherit;">Viewing Vouchers on Sales Report</span> =====
+
[[File:Sales Reports - Sales Report - Export.png|border|center|2412x2412px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_Sales_Report" style="box-sizing: inherit;">Viewing Vouchers on Sales Report</span>=====
  
# Under the Main Menu, Click '''[[Reports]]'''
+
#Click [[Reports]] under Main Menu
# Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]].
+
#Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]].
# Under [[Sales Report]], Check the Check Number Column, you will see the amount list per month with links. Click on the amount to redirect you to the detailed report of that month. Click on the specific voucher to view its details.
+
#Under [[Sales Report]], Click the amount links corresponding to the specific month column to view its detailed report.
 +
#Under Detailed Report, click on the record links to view its details
  
===== <span class="mw-headline" id="Export_Detailed_Report_on_Sales_Report" style="box-sizing: inherit;">Exporting Detailed Report on Sales Report</span> =====
+
[[File:Sales Reports - Sales Report - View.png|border|center|2697x2697px]]
 +
<br />
 +
=====<span class="mw-headline" id="Export_Detailed_Report_on_Sales_Report" style="box-sizing: inherit;">Exporting Detailed Report on Sales Report</span>=====
  
# Under the Main Menu, Click '''[[Reports]]'''
+
#Click [[Reports]] under Main Menu
# Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]].
+
#Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]] Section.
# Under [[Sales Report]], Check the Check Number Column, you will see the amount list per month with links. Click on the amount to redirect you to the detailed report of that month.
+
#Under [[Sales Report]], Click the amount links corresponding to the specific month column to view its detailed report.
# Under Detailed Report, click '''Export.'''
+
#Under Detailed Report, click '''Export''' button'''.'''
  
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: 1em 0px; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" style="margin: auto;"
+
[[File:Sales Reports - Sales Report - Export Detailed.png|border|center|1964x1964px]]
 +
<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:
 
|+ 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'''
 
! colspan="2" style="background-color:rgb(234, 236, 240);text-align:center;" |'''Modules'''
 
|-
 
|-
 
|Sales
 
|Sales
|[[Sales Invoice]]
+
|[[Delivery Receipt]]<nowiki> | </nowiki>[[Sales Invoice]]
 
|-
 
|-
 
|Financial
 
|Financial
Line 121: Line 126:
 
| 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="" |[[Customer Aids]]
 
 
|}
 
|}
 +
[[Category:Sales Reports]]
 +
[[Category:Sales]]
 +
[[Category:Financials]]

Latest revision as of 14:24, 7 April 2022

Sales Report

Sales Report refers to the list of sales transactions in a given month or per year basis.

Sales Reports - Sales Report - Record List.png


Requirements before using Sales Report
List of Sales Report Module terms on Oojeema Prime.
Field Description
1. Record Filter (Year, Customer) Set of filter options for precise search of records.
  • Year will be set at the current year by default.
  • Customer filter dropdown will only show customers with Invoice Transactions.
2. Export Allows the user to Export the report into Spreadsheet
3. Customer List of Customer on the Sales Report Record
4. Month Range List of amount on a monthly basis in a span of a year period.

Notes:

  • Customers must be ACTIVE status in order to view its records in the report.
    • Customer status can be seen in Customer Maintenance Module
Detailed Sales Report Menu
Sales Reports - Sales Report - Detailed Record List.png


Detailed Sales Report Menu refers to the detailed information per customer regarding their sales status.

Detailed Sales Report Menu:
Field Description
1. Customer Customer Name in the Detailed Sales Report
2. Address The Customer's Address
3. Export Allows the User to Export the report into Spreedsheet
4. Date Date when the Sales Invoice is issued.
5. Sales Invoice No The reference number of the Sales Invoice.
6. Reference The reference transaction no. attached for the Sales Invoice
  • It is different from Sales Invoice No. Reference
7. AR No Reference number of the Accounts Receivable tag to the Sales Invoice
8. Amount Total Amount of the Sales Invoice.

Notes:

  • Customers must be ACTIVE status in order to view its records in the report.
    • Customer status can be seen in Customer Maintenance Module
Exporting Sales Report
  1. Click Reports under Main Menu
  2. Under Reports Menu, Click Sales Report under Sales Reports Section.
  3. Under Sales Report, click the Export Button on the right side. Take note that the user can filter the year and the customer for precise exportation of records.
Sales Reports - Sales Report - Export.png


Viewing Vouchers on Sales Report
  1. Click Reports under Main Menu
  2. Under Reports Menu, Click Sales Report under Sales Reports.
  3. Under Sales Report, Click the amount links corresponding to the specific month column to view its detailed report.
  4. Under Detailed Report, click on the record links to view its details
Sales Reports - Sales Report - View.png


Exporting Detailed Report on Sales Report
  1. Click Reports under Main Menu
  2. Under Reports Menu, Click Sales Report under Sales Reports Section.
  3. Under Sales Report, Click the amount links corresponding to the specific month column to view its detailed report.
  4. Under Detailed Report, click Export button.
Sales Reports - Sales Report - Export Detailed.png


Categories:
Modules
Sales Delivery Receipt | Sales Invoice
Financial Accounts Receivable
Maintenance Maintenance | Customer
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