User Tools

Site Tools


purchasing:reports:purchaseorderreports:commoditycodesactualcostreport

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
purchasing:reports:purchaseorderreports:commoditycodesactualcostreport [2019/10/05 00:28] emorenopurchasing:reports:purchaseorderreports:commoditycodesactualcostreport [2024/08/02 19:12] (current) emoreno
Line 5: Line 5:
 //**Purchasing > Reports > Purchase Order Reports > Commodity Codes Actual Cost Report**// //**Purchasing > Reports > Purchase Order Reports > Commodity Codes Actual Cost Report**//
  
-<WRAP round intro>Include the short page introduction here.</WRAP>+<WRAP round intro>This report is used to track actual cost data for commodity items. The report only displays purchase orders that have been received in Purchasing.  
 +  * The **Projected Cost** column is calculated by multiplying the **Quantity Received** by **Unit Cost** from the purchase order 
 +  * The **Actual Cost ** column will remain blank until an amount is entered on either the [[finance:maintenance:pendingpayables|Finance Maintenance > Pending Payables]] page or the [[purchasing:maintenance:actualcost|Purchasing > Maintenance > Actual Cost]] page. 
  
-^ Parameter                                       ^ Description    /*Table with two rows*/ +The report lists item amounts with totals by item and group based on the selected parameters. 
-^Purchasing (P), Warehouse (W), or Both (B)|    | +
-^From Received Date (MMDDYYYY), or blank for ALL|   | +
-^To Received Date (MMDDYYYY), or blank for ALL|   | +
-^Select Commodity Code(s), or blank for ALL|   | +
-^Threshold Percentage|   |+
  
 +Purchasing and Warehouse data is included; however, only restock orders are used from Warehouse.
 +</WRAP>
 +^ Parameter                                       ^ Description    /*Table with two rows*/
 +^Purchasing (P), Warehouse (W), or Both (B)|Purchasing (P) - Include Purchasing data only.\\  \\  Warehouse (W) - Include Warehouse data only.\\  \\  Both (B) - Include both Purchasing and Warehouse data. |
 +^From Received Date (MMDDYYYY), or blank for ALL|Type the from received date in the MMDDYYYY format, or leave blank to use all from dates.|
 +^To Received Date (MMDDYYYY), or blank for ALL|Type the to received date in the MMDDYYYY format, or leave blank to use all to dates.|
 +^Select Commodity Code(s), or blank for ALL|Type the commodity codes, or click {{:images:picklist_large.png|Ellipsis Icon}} to search for commodity codes. Otherwise, leave blank to use all commodity codes.|
 +^Threshold Percentage|Enter a value to list only those commodities with totals that exceed the stated percentage (i.e. threshold is $100 and the items received/ordered total to $70, the data is used when the percentage is 70% but not when it is 71%). |
  
 +[[purchasing:reports:purchaseorderreports|Generate the report.]] 
  
  
 {{indexmenu_n>8}} {{indexmenu_n>8}}
purchasing/reports/purchaseorderreports/commoditycodesactualcostreport.1570235280.txt.gz · Last modified: 2019/10/04 19:28 (external edit)