You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Sales Top Item"
(Tag: Visual edit) |
(Tag: Visual edit) |
||
Line 5: | Line 5: | ||
======Sales Top Item Menu List====== | ======Sales Top Item Menu List====== | ||
− | |||
− | |||
'''Sales Top Item''' refers the list of items sold at a Given Period, ranking the Top sales from highest to lowest. | '''Sales Top Item''' refers the list of items sold at a Given Period, ranking the Top sales from highest to lowest. | ||
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 55: | Line 53: | ||
**Brand status can be seen in [[Brand]] Maintenance Module | **Brand status can be seen in [[Brand]] Maintenance Module | ||
**No records will be display if all items in the Item Master has no brand indicated. | **No records will be display if all items in the Item Master has no brand indicated. | ||
− | *Clicking the link on Quantity Sold and Quantity Returned will redirect the user to the detailed List of Transactions corresponding to that Item.< | + | *Clicking the link on Quantity Sold and Quantity Returned will redirect the user to the detailed List of Transactions corresponding to that Item. |
+ | |||
+ | ===== <span class="mw-headline" id="Exporting_Sales_-_Top_Item" style="box-sizing: inherit;">Exporting Sales - Top Item</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''[[Reports]]''' | ||
+ | # Under Reports Menu, Click '''[[Sales Top Item|Sales - Top Item]]''' under [[Sales Reports]]. | ||
+ | # Under [[Sales Top Item|Sales - Top Item]], click the '''Export Button''' on the right side. Take note that you can filter the Date and [[Brand]] for precise exportation of records. | ||
======List of Transactions (Quantity Sold)====== | ======List of Transactions (Quantity Sold)====== | ||
Line 86: | Line 90: | ||
*Clicking on the Voucher Number will redirect the user to the View [[Sales Invoice]] Module. | *Clicking on the Voucher Number will redirect the user to the View [[Sales Invoice]] Module. | ||
+ | ===== <span class="mw-headline" id="Viewing_Quantity_Sold_on_Sales_Analysis_-_Top_Item" style="box-sizing: inherit;">Viewing Quantity Sold on Sales Analysis - Top Item</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''[[Reports]]''' | ||
+ | # Under [[Reports]] Menu, Click '''[[Sales Top Item|Sales - Top Item]]''' under [[Sales Reports]]. | ||
+ | # Under [[Sales Top Item|Sales – Top Item]], There is a linked Quantity under Qty Sold Column, Click the link Amount to view the detailed Transactions. | ||
+ | # You can also view the Vouchers attach on the Link amount by clicking the vouchers on the Voucher No. Column | ||
+ | |||
+ | <br /> | ||
======View Voucher under List of Transactions(Quantity Sold)====== | ======View Voucher under List of Transactions(Quantity Sold)====== | ||
======List of Transactions(Quantity Returned)====== | ======List of Transactions(Quantity Returned)====== | ||
− | + | '''List of Transactions for Quantity Returned''' refers to a detailed report of the returned item and its list of Sales Return breakdown. | |
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
|+List of Transactions for Quantity Returned Terms under Sales - Top Item Menu List | |+List of Transactions for Quantity Returned Terms under Sales - Top Item Menu List | ||
Line 117: | Line 129: | ||
*Clicking on the Voucher Number will redirect the user to the View [[Sales Return]] Module. | *Clicking on the Voucher Number will redirect the user to the View [[Sales Return]] Module. | ||
+ | |||
+ | ===== <span class="mw-headline" id="Viewing_Quantity_Returned_on_Sales_Analysis_-_Top_Item" style="box-sizing: inherit;">Viewing Quantity Returned on Sales Analysis - Top Item</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''[[Reports]]''' | ||
+ | # Under Reports Menu, Click '''[[Sales Top Item|Sales - Top Item]]''' under [[Sales Reports|Sales Reports.]] | ||
+ | # Under [[Sales Top Item|Sales – Top Item]], There is a linked Quantity under Qty Returned Column, Click the link Amount to view the detailed Transactions. | ||
+ | # You can also view the Vouchers attach on the Link amount by clicking the vouchers on the Voucher No. Column | ||
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
Line 140: | Line 159: | ||
|- 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''' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- style="box-sizing: inherit;" | |- style="box-sizing: inherit;" | ||
| style="" |Maintenance Aids | | style="" |Maintenance Aids | ||
| style="" |[[Brand]]<nowiki> | </nowiki>[[Item Class Aids]]<nowiki> | </nowiki>[[Warehouse Aids]] | | style="" |[[Brand]]<nowiki> | </nowiki>[[Item Class Aids]]<nowiki> | </nowiki>[[Warehouse Aids]] | ||
|} | |} |
Revision as of 13:25, 7 December 2021
Contents
Sales - Top Item
Sales Top Item Menu List
Sales Top Item refers the list of items sold at a Given Period, ranking the Top sales from highest to lowest.
Field | Description |
---|---|
1. Record Filter (Date Range, Brand, Item List) | Set of filter records for precise searching of records.
|
2. Export | Allows the user to Export the report into Spreadsheet. |
3. Rank | The rank of the items based on quantity and amount sales from highest to lowest. |
4. Item | The name of the item. |
5. Brand | The brand of the item. |
6. Category | The Class or the category of the item. |
7. Unit of Measure | The standard unit of measure of the item. |
8. Quantity Sold | Number of items sold |
9. Quantity Returned | Number of items returned |
10. Net Quantity | Total number of items sold based from its quantity sold and the items returned |
11. Amount | The total amount of all items based on its net quantity |
Notes:
- Brand must be on ACTIVE status in order to view its records in the report
- Brand status can be seen in Brand Maintenance Module
- No records will be display if all items in the Item Master has no brand indicated.
- Clicking the link on Quantity Sold and Quantity Returned will redirect the user to the detailed List of Transactions corresponding to that Item.
Exporting Sales - Top Item
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Sales - Top Item under Sales Reports.
- Under Sales - Top Item, click the Export Button on the right side. Take note that you can filter the Date and Brand for precise exportation of records.
List of Transactions (Quantity Sold)
List of Transactions for Quantity Sold refers to a detailed report of a specific item and its list of Invoices breakdown of its sales.
Field | Description |
---|---|
1. Item Code | Reference Number of the Item |
2. Search Bar | A search text box that guides the users to find a specific record. |
3. Transaction Date | Date when the transaction was created. |
4. Voucher No. | Reference No. of the Invoice |
5. Quantity | Number of Items sold in Sales Invoice |
6. Amount | The total amount sold based from the Quantity and its unit Price |
Notes:
- Clicking on the Voucher Number will redirect the user to the View Sales Invoice Module.
Viewing Quantity Sold on Sales Analysis - Top Item
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Sales - Top Item under Sales Reports.
- Under Sales – Top Item, There is a linked Quantity under Qty Sold Column, Click the link Amount to view the detailed Transactions.
- You can also view the Vouchers attach on the Link amount by clicking the vouchers on the Voucher No. Column
View Voucher under List of Transactions(Quantity Sold)
List of Transactions(Quantity Returned)
List of Transactions for Quantity Returned refers to a detailed report of the returned item and its list of Sales Return breakdown.
Field | Description |
---|---|
1. Item Code | Reference Number of the Item |
2. Search Bar | A search text box that guides the users to find a specific record. |
3. Transaction Date | Date when the transaction was created. |
4. Voucher No | Reference No. of the Sales Return |
5. Quantity | Number of Items Returned in the Sales Return record |
6. Amount | The total amount returned based from the Quantity and its unit Price |
Notes:
- Clicking on the Voucher Number will redirect the user to the View Sales Return Module.
Viewing Quantity Returned on Sales Analysis - Top Item
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Sales - Top Item under Sales Reports.
- Under Sales – Top Item, There is a linked Quantity under Qty Returned Column, Click the link Amount to view the detailed Transactions.
- You can also view the Vouchers attach on the Link amount by clicking the vouchers on the Voucher No. Column
Modules | |
---|---|
Sales | Sales Invoice |
Inventory Aids | Sales Return |
Maintenance | Maintenance | Brand | Item Class | 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 | Item Class Aids | Warehouse Aids |