Purchase Cost Analysis Report

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.


Prerequisite:


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Time PeriodAllow user to select the time period from a list of options are set custom a custom date range.
CurrencyAllow user to select currency to be used in the report
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Output:

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.


Fields
SupplierSupplier name.
PO #Purchase order number identifying the purchase.
Invoice #Purchase invoice number.
SKUUnique product stock keeping unit.
ProductName of the product.
LocationLocation product is received at.
Batch #Batch or Serial number associated with stock received.
CurrencySupplier currency code this purchase is created in.
CategoryProduct category.
BrandProduct brand.
Product TagsComma-separated product tags.
FamilyProduct family name.
UnitProduct unit of measure.
Supplier SKUProduct stock keeping unit assigned by supplier.
Supplier ProductProduct name assigned by supplier.
Order DateDate when purchase was created.
Expiry DateDate when current product batch expires.
StatusPurchase status.
YearYear of invoice date.
QuarterQuarter of invoice date.
MonthMonth of invoice date.
Supplier Additional Attribute 1-10Values of Additional supplier attributes.
Product Additional Attribute 1-10Values of product additional attributes.
Data Headers
QuantityReceived quantity minus unstock quantity if any.
Main CostMain invoice cost for the batch.
Additional CostPortion of additional costs distributed to the batch.
Journal CostPortion of additional not capitalised costs distributed to the batch.
TaxTax 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. 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.