Purchase cost analysis report detailing costs associated with purchasing every product during given period of time.



Input:

Following are input for this report



From
Allow user to select a date i.e. beginning date of required report
To
Allow user to select a date i.e. closing/end date of required report
Currency
Allow user to select Currency for report
Update
Update button which refresh report results
Apply Filter
This button show option to set filter on fields used in report
Export
This button will allow user to export report data in Excel, PDF or RTF format


Output:

After setting inputs described above, when you press update button, report will refresh as per inputs selected. There are following output field available for this report.



Supplier

 Supplier name.

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.

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.

Journals

 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.

Currency

 Supplier currency code this purchase is created in.

Category

 Product category.

Brand

 Product brand.

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.

Status

 Purchase status.

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.