You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Sales Report"
(Tag: 2017 source edit) |
(Tag: Visual edit) |
||
Line 4: | Line 4: | ||
==Sales Report== | ==Sales Report== | ||
− | |||
− | |||
− | |||
− | |||
− | |||
'''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. | ||
− | ===== <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> | + | *The user should setup have the following records in order to proceed on using the <span>Sales Report</span> |
− | *# [[Customer]] | + | *#[[Customer]] |
− | *# [[Sales Invoice]] | + | *#[[Sales Invoice]] |
− | *# [[Accounts Receivable]] | + | *#[[Accounts Receivable]] |
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 34: | Line 29: | ||
|- | |- | ||
|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 67: | Line 62: | ||
|- | |- | ||
|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 | ||
|- | |- | ||
|7. [[Accounts Receivable|AR No]] | |7. [[Accounts Receivable|AR No]] | ||
Line 75: | Line 69: | ||
|- | |- | ||
|8. Amount | |8. Amount | ||
− | |Total Amount of the Sales Invoice. | + | |Total Amount of the [[Sales Invoice|Sales Invoice.]] |
|} | |} | ||
Notes: | Notes: | ||
Line 82: | Line 76: | ||
**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]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
− | # Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]]. | + | #Under Reports Menu, Click '''[[Sales Report]]''' under [[Sales Reports]]. |
− | # 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 you can filter the Date, 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> ===== | + | =====<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]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
− | # 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]], 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. |
− | ===== <span class="mw-headline" id="Export_Detailed_Report_on_Sales_Report" style="box-sizing: inherit;">Exporting Detailed Report on Sales Report</span> ===== | + | =====<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]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
− | # 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. | + | #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 Detailed Report, click '''Export.''' | + | #Under Detailed Report, click '''Export.''' |
− | {| class="wikitable | + | {| 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''' |
Revision as of 14:27, 2 December 2021
Contents
Sales Report
Sales Report refers to the list of sales transactions in a given month or per year basis.
Requirements before using Sales Report
- The user should setup have the following records in order to proceed on using the Sales Report
Field | Description |
---|---|
1. Record Filter (Year, Customer) | Set of filter options for precise search of records.
|
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
Detailed Sales Report Menu refers to the detailed information per customer regarding their sales status.
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
|
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
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Sales Report under Sales Reports.
- 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.
Viewing Vouchers on Sales Report
- Under the Main Menu, Click 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.
Exporting Detailed Report on Sales Report
- Under the Main Menu, Click 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.
- Under Detailed Report, click Export.
Modules | |
---|---|
Sales | 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 |
Job Aid Modules | |
Maintenance Aids | Customer Aids |