Purchase Report

The purchase report enables you to get a full view of your purchase expenses. You can choose to see the report By SKU, By Partner, By order, etc.

  1. Click Purchase in the top menu and select Purchase in the report section in the drop-down menu.
  2. Use the filter search on the left. (If you are working from a small screen, you can find the filters by clicking the magnifying glass by the Printer friendly button on the right.) You can filter by Country, Order Tags, Supplier, Supplier Tags, Stock Keeping Units, SKU Tags, etc. Click Apply to activate the filters.
  3. In the tabs of the table you can limit the shown information. You can select By SKU, By SKU Tag, By Country, By Partner, By Order By Month or Extraction.
  4. You can click Printer friendly to get a simpler version for print, or
  5. Click XLSX to export the report as a spreadsheet file.

Below, you can se a description of each column per tab.

 

By SKU

Column name Explanation
SKU Global name and SKU number of the purchased Stock Keeping Unit.
Units This is the unit of the SKU eg. Colli, kg, liter etc. The unit of measure is selected when setting up the SKU. Read more about units of measure here.
Free Units, UoM This is the number of free Units of Measure on purchase orders in the selected unit of measure of the SKU.
Purchase Value of Free Units This is the value of the free units of measure based on the price of the other units of the same SKU on the purchase order.
Quantity This is the sold quantity of the SKU.
Quantity, UoM This is the number of sold units in the entered unit of measure of the SKU.
Goods Purchase: Expected This is the expected purchase price of the specific SKU
Cost Price: Expected This is the expected cost price entered in the lot lines of purchase orders, or automatically obtained from a linked price list. Read more about price lists here.
Cost Price: Actual This is the actual cost price from the linked expenses imported from your accounting system.

 

By SKU Tag

Column name Explanation
Tags The Column is divided by tags added to SKUs. Read more about Tags here
Goods Purchase: Expected This is the expected purchase price of SKUs with the specific tag.
Cost Price: Expected This is the expected cost price entered in the lot lines of purchase orders, or automatically obtained from a linked price list. Read more about price lists here.
Cost Price: Actual This is the actual cost price from the linked expenses imported from your accounting system.

 

By Country

Column name Explanation
Country This column is divided by supplier country.
Goods Purchase: Expected This is the expected purchase price of goods from the specific country.
Service Lines: Expected This is the expected price of service lines on purchase orders from the specific country
Purchase: Total This is the total amount of purchased goods and service lines from orders placed to partners in the specific country.
Cost Price: Expected This is the sum of expected cost prices from purchase orders to the specific country.
Cost Price: Actual This is the actual cost price of purchase orders imported from your accounting system.

 

By Partner

Column name Explanation
Partner No. This is the unique partner number in tracezilla.
Creditor no. This is the creditor number of the partner.
Name This is the company name of the supplier (partner). The supplier name appears on each purchase order.
Goods Purchase: Expected This is the expected purchase price of SKUs ordered from the specific partner.
Service Lines: Expected This is the expected expenses of service lines on purchase orders from the specific partner.
Purchase: Total This is the total expenses of purchased goods and service lines from orders placed to the specific partner.
Cost Price: Expected This is the sum of expected cost prices from purchase orders to the specific partner.
Cost Price: Actual This is the actual cost price of purchase orders imported from your accounting system.

 

By Order

Column name Explanation
Order # This is the number of the purchase order. You can use this number to search for the specific purchase order in the order view.
Supplier This is the supplier specified on the order header of the purchase order.
Status This is the status of the order. Here, you can see if the orders is received, in transit, cancelled, etc.
Del. date This is the delivery date specified under Delivery Details in the order header of the sales order.
Goods Purchase: Expected This is the expected purchase price of SKUs on the purchase order.
Service Lines: Expected This is the expected purchase price of lot lines on the purchase order.
Purchase: Total This is the sum of purchased lots and service lines on the purchase order.
Cost Price: Expected The expected cost price is the sum of expenses on the purchase order.
Cost Price: Actual This is the actual cost price of the purchase order. The data is imported from your accounting system.

 

By Month

Column name Explanation
Month This column is divided into months in which the orders were created according to order date.
The order date is specified in the Order Details of the purchase order.
Goods Purchase: Expected This is the expected purchase price of SKUs on the purchase orders.
Service lines: Expected This is the expected purchase price of lot lines on the purchase orders.
Purchase: Total This is the sum of purchased lots and service lines on purchase orders.
Cost Price: Expected The expected cost price is the sum of expenses on purchase orders.
Cost Price: Actual This is the actual cost price of purchase orders. The data is imported from your accounting system.

 

Extraction

If you want to create your own purchase report which contains the exact information of your needs, you can create a pivot table. Your data is already in tabulated form - which means, that every single type of data is in separate columns, to ensure the data is compatible when generating a pivot table.

Click the tab Extraction in the purchase report, and click XLSX in the upper right corner. By this, a spreadsheet is generated for download, which can then be adjusted to your needs.

Most spreadsheets has a pivot function. It varies from sheet to sheet, how the pivot table is generated. You can do an internet search, by entering e.g. “Pivot table excel” into your search engine.

Outline