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 01:00] 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>This report is used to track actual cost data for commodity items. The report lists item amounts with totals by item and group based on the selected parameters. Purchasing and Warehouse data is included; however, only restock orders are used from Warehouse.</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. 
  
 +The report lists item amounts with totals by item and group based on the selected parameters. 
 +
 +Purchasing and Warehouse data is included; however, only restock orders are used from Warehouse.
 +</WRAP>
 ^ Parameter                                       ^ Description    /*Table with two rows*/ ^ 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. | ^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.| ^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.| ^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?60|Ellipsis Icon}} to search for commodity codes. Otherwise, leave blank to use all commodity codes.|+^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%). | ^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/commoditycodesactualcostreport.1570237210.txt.gz · Last modified: 2019/10/04 20:00 (external edit)