You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Average Cost"
(Tag: Visual edit) |
(Tag: 2017 source edit) |
||
Line 4: | Line 4: | ||
======Average Cost Menu====== | ======Average Cost Menu====== | ||
− | |||
'''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> ===== | ||
+ | |||
+ | * The user should setup have the following records in order to proceed on using the <span>Average Cost</span> | ||
+ | *# [[Item Master]] | ||
+ | |||
{| class="wikitable" | {| class="wikitable" | ||
|+Average Cost Report Terms on Oojeema Prime | |+Average Cost Report Terms on Oojeema Prime | ||
Line 38: | Line 43: | ||
|Total Cost of an item based on its Average Cost and Number of Cost. | |Total Cost of an item based on its Average Cost and Number of Cost. | ||
|} | |} | ||
− | |||
− | + | ===== <span class="mw-headline" id="Exporting_Average_Cost" style="box-sizing: inherit;">Exporting Average Cost</span> ===== | |
+ | |||
+ | # 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. | ||
+ | <br /> | ||
======Average Cost Breakdown====== | ======Average Cost Breakdown====== | ||
[[File:Average Cost Breakdown.png|center|thumb|815x815px|Average Cost Breakdown]] | [[File:Average Cost Breakdown.png|center|thumb|815x815px|Average Cost Breakdown]] | ||
Line 77: | Line 86: | ||
|The overall average cost of an item based on the Transactions made. | |The overall average cost of an item based on the Transactions made. | ||
|} | |} | ||
− | |||
− | + | ===== <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 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. | ||
+ | |||
+ | ===== <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 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.''' | ||
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
+ | |+ Categories: | ||
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules''' | | colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules''' | ||
|- | |- |
Revision as of 13:19, 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 | |
Sales Aids | Delivery Receipt |
Purchase Aids | Purchase Receipt Aid |
Financials Aids | Inventory Adjustment Aids | Purchase Return Aids | Sales Return Aids |
Maintenance Aids | Item Master Aids | Unit of Measure Aids |
Reports Module(Reports) | |
Reports | Purchase Reports |
Purchase Reports | Purchase Report | Average Cost |
Reports Aid | |
Purchase Reports | Purchase Report Aids | Average Cost Aids |