Discussion

Difference between revisions of "Average Cost"

(Changed categories.)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<div style="text-align: center;">[[Purchase Reports|Purchase Reports (Page)]] | [[Average Cost]] | [[Average Cost Aids]]</div>
+
<div style="text-align: center;">[[Purchase Reports|Purchase Reports (Page)]] | [[Average Cost]]</div>
  
 
==Average Cost==
 
==Average Cost==
  
 
======Average Cost Menu======
 
======Average Cost Menu======
−
[[File:Average Cost Menu List.png|center|thumb|1000x1000px|Average Cost Menu List]]
+
[[File:Purchase Reports - Average Cost - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 
'''Average Cost Report''' refers to the list of Inventory Average Costs.
 
'''Average Cost Report''' refers to the list of Inventory Average Costs.
  
−
#'''Search Bar''' - A field where the user is allowed to search for a specific Item in the record.
+
=====<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>=====
−
#'''Export''' - Allows the user to export the record depending on the filters applied.
 
−
#'''Item Code''' - Unique Reference Code for an Item.
 
−
#'''Item Name''' - Name of an Item corresponding to its Item Code
 
−
#'''Description''' - refers to any description or remarks regarding the Item.
 
−
#'''Stock''' - Number of Remaining Stocks of an Item to all [[Warehouse]]
 
−
#'''UOM''' - [[Unit of Measure]] of an Item.
 
−
#'''Average Cost''' - The overall average cost of an item based on the Transactions made.
 
−
#'''Total''' - Total Cost of an item based on its Average Cost and Number of Cost.
 
  
−
Notes:
+
*The user should setup have the following records in order to proceed on using the <span>Average Cost</span>
 +
*#[[Item Master]]
  
−
* 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]]
+
{| class="wikitable" style="margin: auto;"
 +
|+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.
 +
|}
  
 +
=====<span class="mw-headline" id="Exporting_Average_Cost" style="box-sizing: inherit;">Exporting Average Cost</span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Average Cost]]''' under [[Purchase Reports]] section.
 +
#Under Purchase report, click the Export Button on the right side. Take note that the user can search for a Specific Item before Exporting for precise search of records
 +
 +
[[File:Purchase Reports - Average Cost - Export.png|border|center|2332x2332px]]
 +
<br />
 
======Average Cost Breakdown======
 
======Average Cost Breakdown======
−
[[File:Average Cost Breakdown.png|center|thumb|815x815px|Average Cost Breakdown]]
+
[[File:Purchase Reports - Average Cost - Average Cost Breakdown.png|border|center|1108x1108px]]
 +
 
 +
 
 
'''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" style="margin: auto;"
 +
|+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]].
  
−
Average Cost Breakdown terms on Average Cost Menu
+
*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.
 +
|}
  
−
# '''Item Details''' - Basic information regarding the Item.
+
=====<span class="mw-headline" id="Viewing_Reference_Voucher_on_Average_Cost" style="box-sizing: inherit;">Viewing Reference Voucher on Average Cost</span>=====
−
# '''Export''' - allows the user to export the Average Cost Breakdown Record
 
−
# '''Movement Date''' - date when the transaction was created and when the stock in the Warehouse change.
 
−
# '''Document''' - Reference Transaction corresponding to its Movement date.
 
−
# '''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]]
 
−
# '''Stock Qty''' - Number of items available on [[Warehouse]].
 
−
# '''Cost''' - Cost of Items successfully purchased.
 
−
# '''Average Cost''' - The overall average cost of an item based on the Transactions made.
 
  
−
Notes:
+
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Average Cost]]''' under [[Purchase Reports]] section.
 +
#Under [[Average Cost]], clicking the linked item code under Item Code column will redirect the to detailed average cost breakdown.
 +
#Under Average Cost Breakdown, select a reference link under Document No. column to view the detailed voucher on the breakdown
  
−
* 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]]
+
[[File:Purchase Reports - Average Cost - View Detailed.png|border|center|2434x2434px]]
−
 
+
<br />
−
====== Average Cost Breakdown View Document ======
+
=====<span class="mw-headline" id="Exporting_Detailed_Average_Cost" style="box-sizing: inherit;">Exporting Detailed Average Cost</span>=====
−
[[File:Average Cost Breakdown View Document.png|center|thumb|1000x1000px|Average Cost Breakdown View Document]]
 
  
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[Average Cost]]''' under [[Purchase Reports]] Section.
 +
#Under Average Cost, clicking the linked item code under Item Code column will redirect the to detailed average cost breakdown.
 +
#Under detailed Average Cost Breakdown click Export
  
 +
[[File:Purchase Reports - Average Cost - Export Detailed.png|border|center|2643x2643px]]
 
<br />
 
<br />
−
{| class="wikitable" style="width:100%;"
+
{| class="wikitable" style="margin: auto;"
 +
|+Categories:
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Modules'''
 
|-
 
|-
Line 57: Line 122:
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| style="width:15%;" |Inventory
 
| style="width:15%;" |Inventory
−
| style="" |[[Inventory Adjustment]]<nowiki> |  | </nowiki>[[Purchase Return]]<nowiki> | </nowiki>[[Sales Return]]
+
| 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
 
| style="" |[[Item Master]]<nowiki> | </nowiki>[[Unit of Measure]]
 
| style="" |[[Item Master]]<nowiki> | </nowiki>[[Unit of Measure]]
−
|- style="box-sizing: inherit;"
 
−
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
−
|-
 
−
|Sales Aids
 
−
|[[Delivery Receipt]]
 
−
|-
 
−
| style="width:15%;" |Purchase Aids
 
−
|[[Purchase Receipt Aid]]
 
−
|- style="box-sizing: inherit;"
 
−
| style="width:15%;" |Financials Aids
 
−
| style="" |[[Inventory Adjustment Aids]]<nowiki> | </nowiki>[[Purchase Return Aids]]<nowiki> | </nowiki>[[Sales Return Aids]]
 
−
|- style="box-sizing: inherit;"
 
−
| style="width:15%;" |Maintenance Aids
 
−
| style="" |[[Item Master Aids]]<nowiki> | </nowiki>[[Unit of Measure Aids]]
 
 
|- style="box-sizing: inherit;"
 
|- style="box-sizing: inherit;"
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module([[Reports]])'''
Line 83: Line 134:
 
| style="width:15%;" |Purchase Reports
 
| style="width:15%;" |Purchase Reports
 
| style="" |[[Purchase Report]]<nowiki> | </nowiki>[[Average Cost]]
 
| style="" |[[Purchase Report]]<nowiki> | </nowiki>[[Average Cost]]
−
|- style="box-sizing: inherit;"
 
−
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Aid'''
 
−
|- style="box-sizing: inherit;"
 
−
| style="width:15%;" |Purchase Reports
 
−
| style="" |[[Purchase Report Aids]]<nowiki> | </nowiki>[[Average Cost Aids]]
 
 
|}
 
|}
 +
[[Category:Purchase]]
 +
[[Category:Purchase Reports]]
 +
[[Category:Sales]]
 +
[[Category:Inventory]]

Latest revision as of 12:20, 8 April 2022

Average Cost

Average Cost Menu
Purchase Reports - Average Cost - Record List.png


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. Click Reports under Main Menu
  2. Under Reports Page, Click Average Cost under Purchase Reports section.
  3. Under Purchase report, click the Export Button on the right side. Take note that the user can search for a Specific Item before Exporting for precise search of records
Purchase Reports - Average Cost - Export.png


Average Cost Breakdown
Purchase Reports - Average Cost - Average Cost Breakdown.png


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. Click Reports under Main Menu
  2. Under Reports Page, Click Average Cost under Purchase Reports section.
  3. Under Average Cost, clicking the linked item code under Item Code column will redirect the to detailed average cost breakdown.
  4. Under Average Cost Breakdown, select a reference link under Document No. column to view the detailed voucher on the breakdown
Purchase Reports - Average Cost - View Detailed.png


Exporting Detailed Average Cost
  1. Click Reports under Main Menu
  2. Under Reports Page, Click Average Cost under Purchase Reports Section.
  3. Under Average Cost, clicking the linked item code under Item Code column will redirect the to detailed average cost breakdown.
  4. Under detailed Average Cost Breakdown click Export
Purchase Reports - Average Cost - Export Detailed.png


Categories:
Modules
Sales Delivery Receipt
Purchase Purchase Receipt
Inventory Inventory Adjustment | Purchase Return | Sales Return
Maintenance Item Master | Unit of Measure
Reports Module(Reports)
Reports Purchase Reports
Purchase Reports Purchase Report | Average Cost
Retrieved from "https://docs.oojeema.com/index.php?title=Average_Cost&oldid=6664"