Purchase cost analysis report detailing the costs associated with purchasing every product during a given period. Use this report to view Quantity, Main Cost, Additional Cost, Journal Cost and Tax for every product purchased over the report period. The output can be customised to show product details, PO #, supplier, location, status and time period.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allow user to select the time period from a list of options are set custom a custom date range.|
|Currency||Allow user to select currency to be used in the report|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|PO #||Purchase order number identifying the purchase.|
|Invoice #||Purchase invoice number.|
|SKU||Unique product stock keeping unit.|
|Product||Name of the product.|
|Location||Location product is received at.|
|Batch #||Batch or Serial number associated with stock received.|
|Currency||Supplier currency code this purchase is created in.|
|Product Tags||Comma-separated product tags.|
|Family||Product family name.|
|Unit||Product unit of measure.|
|Supplier SKU||Product stock keeping unit assigned by supplier.|
|Supplier Product||Product name assigned by supplier.|
|Order Date||Date when purchase was created.|
|Expiry Date||Date when current product batch expires.|
|Year||Year of invoice date.|
|Quarter||Quarter of invoice date.|
|Month||Month of invoice date.|
|Supplier Additional Attribute 1-10||Values of Additional supplier attributes.|
|Product Additional Attribute 1-10||Values of product additional attributes.|
|Quantity||Received quantity minus unstock quantity if any.|
|Main Cost||Main invoice cost for the batch.|
|Additional Cost||Portion of additional costs distributed to the batch.|
|Journal Cost||Portion of additional not capitalised costs distributed to the batch.|
|Tax||Tax amount combining both main invoice and portion of additional costs associated with the batch.|
NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields.