Difference between revisions of "Average Cost"

(Tag: 2017 source edit)
Line 4: Line 4:
  
 
======Average Cost Menu======
 
======Average Cost Menu======
[[File:Average Cost Menu List.png|center|thumb|1000x1000px|Average Cost Menu List]]
 
 
'''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.
 
|}
 
|}
Notes:
 
  
*For detailed instructions on how to Export the Record and how to view the Average Cost Breakdown of an Item. The user may visit the Average Cost Aids which can be found [[Average Cost Aids|here]]
+
===== <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.
 
|}
 
|}
Notes:
 
  
*For detailed instructions on how to Export the Record under Average Cost Breakdown and how to view the Document breakdown of an Item. The user may visit the Average Cost Aids which can be found [[Average Cost Aids|here]]
+
===== <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> =====
  
======Average Cost Breakdown View Document======
+
# Under the Main Menu, Click '''[[Reports]]'''
[[File:Average Cost Breakdown View Document.png|center|thumb|1000x1000px|Average Cost Breakdown View Document]]
+
# 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

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
    1. Item Master
Average Cost Report Terms on Oojeema Prime
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
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Average Cost under Purchase Reports.
  3. Under Average Cost, click the Export Button on the right side.


Average Cost Breakdown
File:Average Cost Breakdown.png
Average Cost Breakdown

Average Cost Breakdown refers to in detail record of transactions related on a specific item.

Average Cost Breakdown terms on Average Cost Menu
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.
  • Quantities with parenthesis () refers to the quantity that is out in the Warehouse
  • Quantities without parenthesis refers to the quantity that is going in to 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
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Average Cost under Purchase Reports.
  3. 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.
  4. You can check the details of the voucher by clicking the voucher link on the Document Column.
Exporting Detailed Average Cost
  1. Under the Main Menu, Click Reports
  2. Under Reports Menu, Click Average Cost under Purchase Reports.
  3. 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.
  4. Click Export.
Categories:
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