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:24] 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
-====Modify a record:==== +
- +
-++++Select a student | {{page>general:select_a_student&inline}} ++++  /*Inline folded include*+
- +
- +
-^ Field                                        ^ Description    /*Table with two rows*+
-^Campus ID|++|{{page>general:campus_id}}++|  /*Folded include*+
-^ Pass/Fail|{{page>general:pass_fail}}|      /*Include, not folded*+
- +
-Click **Save**.<WRAP box>**NOTE:</WRAP +
- +
- +
-====Other functions and features:==== +
- +
-^{{:tsds:images:trash_delete.gif|Trashcan Icon}} | ++ Delete a row.|{{page>general:delete_a_row}}++|  /*Table row with text link*/  +
- +
  
 +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*/
 +^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}}
purchasing/reports/purchaseorderreports/commoditycodesactualcostreport.1570235071.txt.gz · Last modified: 2019/10/04 19:24 (external edit)