You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Average Cost"
(Tag: 2017 source edit) |
(Tag: Visual edit) |
||
| Line 6: | Line 6: | ||
'''Average Cost Report''' refers to the list of Inventory Average Costs. | '''Average Cost Report''' refers to the list of Inventory Average Costs. | ||
| − | ===== <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 Average Cost</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 Average Cost</span></span></span></span>===== |
| − | * The user should setup have the following records in order to proceed on using the <span>Average Cost</span> | + | *The user should setup have the following records in order to proceed on using the <span>Average Cost</span> |
| − | *# [[Item Master]] | + | *#[[Item Master]] |
{| class="wikitable" style="margin: auto;" | {| class="wikitable" style="margin: auto;" | ||
| Line 44: | Line 44: | ||
|} | |} | ||
| − | ===== <span class="mw-headline" id="Exporting_Average_Cost" style="box-sizing: inherit;">Exporting Average Cost</span> ===== | + | =====<span class="mw-headline" id="Exporting_Average_Cost" style="box-sizing: inherit;">Exporting Average Cost</span>===== |
| − | # Under the Main Menu, Click '''[[Reports]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
| − | # Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. | + | #Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. |
| − | # Under Average Cost, click the '''Export Button''' on the right side. | + | #Under Average Cost, click the '''Export Button''' on the right side. |
| − | |||
======Average Cost Breakdown====== | ======Average Cost Breakdown====== | ||
| − | |||
'''Average Cost Breakdown''' refers to in detail record of transactions related on a specific item. | '''Average Cost Breakdown''' refers to in detail record of transactions related on a specific item. | ||
| − | {| class="wikitable" | + | {| class="wikitable" style="margin: auto;" |
|+Average Cost Breakdown terms on Average Cost Menu | |+Average Cost Breakdown terms on Average Cost Menu | ||
!Field | !Field | ||
| Line 87: | Line 85: | ||
|} | |} | ||
| − | ===== <span class="mw-headline" id="Viewing_Reference_Voucher_on_Average_Cost" style="box-sizing: inherit;">Viewing Reference Voucher on Average Cost</span> ===== | + | =====<span class="mw-headline" id="Viewing_Reference_Voucher_on_Average_Cost" style="box-sizing: inherit;">Viewing Reference Voucher on Average Cost</span>===== |
| − | # Under the Main Menu, Click '''[[Reports]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
| − | # Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. | + | #Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. |
| − | # Under [[Average Cost]], you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown. | + | #Under [[Average Cost]], you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown. |
| − | # You can check the details of the voucher by clicking the voucher link on the Document Column. | + | #You can check the details of the voucher by clicking the voucher link on the Document Column. |
| − | ===== <span class="mw-headline" id="Exporting_Detailed_Average_Cost" style="box-sizing: inherit;">Exporting Detailed Average Cost</span> ===== | + | =====<span class="mw-headline" id="Exporting_Detailed_Average_Cost" style="box-sizing: inherit;">Exporting Detailed Average Cost</span>===== |
| − | # Under the Main Menu, Click '''[[Reports]]''' | + | #Under the Main Menu, Click '''[[Reports]]''' |
| − | # Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. | + | #Under Reports Menu, Click '''[[Average Cost]]''' under [[Purchase Reports]]. |
| − | # Under Average Cost, you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown. | + | #Under Average Cost, you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown. |
| − | # Click '''Export.''' | + | #Click '''Export.''' |
| − | {| class="wikitable | + | {| class="wikitable" style="margin: auto;" |
| − | |+ Categories: | + | |+Categories: |
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules''' | | colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules''' | ||
|- | |- | ||
| Line 112: | Line 110: | ||
|- style="box-sizing: inherit;" | |- style="box-sizing: inherit;" | ||
| style="width:15%;" |Inventory | | style="width:15%;" |Inventory | ||
| − | | style="" |[[Inventory Adjustment]]<nowiki> | + | | style="" |[[Inventory Adjustment]]<nowiki> | </nowiki>[[Purchase Return]]<nowiki> | </nowiki>[[Sales Return]] |
|- style="box-sizing: inherit;" | |- style="box-sizing: inherit;" | ||
| style="width:15%;" |Maintenance | | style="width:15%;" |Maintenance | ||
| Line 118: | Line 116: | ||
|- 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="width:15%;" |Maintenance Aids | | style="width:15%;" |Maintenance Aids | ||
| Line 138: | Line 127: | ||
| style="width:15%;" |Purchase Reports | | style="width:15%;" |Purchase Reports | ||
| style="" |[[Purchase Report]]<nowiki> | </nowiki>[[Average Cost]] | | style="" |[[Purchase Report]]<nowiki> | </nowiki>[[Average Cost]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Revision as of 13:22, 14 December 2021
Contents
Average Cost
Average Cost Menu
Average Cost Report refers to the list of Inventory Average Costs.
Requirements before using Average Cost
- The user should setup have the following records in order to proceed on using the Average Cost
| Field | Description |
|---|---|
| 1. Search Bar | A field where the user is allowed to search for a specific Item in the record. |
| 2. Export | Allows the user to export the record depending on the filters applied. |
| 3. Item Code | Unique Reference Code for an Item. |
| 4. Item Name | Name of an Item corresponding to its Item Code |
| 5. Description | Refers to any description or remarks regarding the Item. |
| 6. Stock | Number of Remaining Stocks of an Item to all Warehouse |
| 7. UOM | Unit of Measure of an Item. |
| 8. Average Cost | The overall average cost of an item based on the Transactions made. |
| 9. Total | Total Cost of an item based on its Average Cost and Number of Cost. |
Exporting Average Cost
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Average Cost under Purchase Reports.
- Under Average Cost, click the Export Button on the right side.
Average Cost Breakdown
Average Cost Breakdown refers to in detail record of transactions related on a specific item.
| Field | Description |
|---|---|
| 1. Item Details | Basic information regarding the Item. |
| 2. Export | Allows the user to export the Average Cost Breakdown Record into Spreadsheet |
| 3. Movement Date | Date when the transaction was created and when the stock in the Warehouse change. |
| 4. Document | Reference Transaction corresponding to its Movement date. |
| 5. Movement Qty | Quantity of items move from/on the Warehouse. |
| 6. Stock Qty | Number of items available on Warehouse. |
| 7. Cost | Cost of Items successfully purchased. |
| 8. Average Cost | The overall average cost of an item based on the Transactions made. |
Viewing Reference Voucher on Average Cost
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Average Cost under Purchase Reports.
- Under Average Cost, you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown.
- You can check the details of the voucher by clicking the voucher link on the Document Column.
Exporting Detailed Average Cost
- Under the Main Menu, Click Reports
- Under Reports Menu, Click Average Cost under Purchase Reports.
- Under Average Cost, you can check the linked item codes in the Item Code column. Clicking the linked item code will redirect you to detailed average cost breakdown.
- Click Export.
| Modules | |
| Sales | Delivery Receipt |
| Purchase | Purchase Receipt |
| Inventory | Inventory Adjustment | Purchase Return | Sales Return |
| Maintenance | Item Master | Unit of Measure |
| Job Aid Modules | |
| Maintenance Aids | Item Master Aids | Unit of Measure Aids |
| Reports Module(Reports) | |
| Reports | Purchase Reports |
| Purchase Reports | Purchase Report | Average Cost |