Tutorials

Documentation of tracezilla

Invoice report

In the invoice report you will get an overview of how much you have sold of certain types of goods, to which price and to whom.

This is how you select the report:

  1. Click Sales in the top menu and select the report Invoiced in the bottom of the drop-down menu.
  2. You can use the filters in the left side of the screen to refine your report. If you are working on a small screen you can find the filters by clicking on the magnifying glass. In order to close the filter click on the eye. You can filter by country, Order tag, Costumer, Costumer tag, Delivered to, Stock Keeping Units, SKU tags, Invoice Date and Owned by. Click on the button Apply to activate the filters.
  3. In the tabs above in the report you can limit your search. In the tabs you can choose to see your invoiced sales by SKU, by SKU tag, by Country, by Partner, by partner tag, by Owner, by Order, by Invoice or by Month.
  4. Below you can read about what the different columns in the table show.
  5. You can view the report in a printer-friendly format by clicking on the button Printer Friendly.
  6. You can export the report to Excel by clicking on the button XSLX.

By SKU

Column header Explanation
SKU Code This is the item number of the SKU
Global Name This is the original name of the SKU, specified when the SKU was created. During the creation of the SKU, it is possible to enter the name in several languages, which is why it is the Global Name.
Unit of Measure This is the unit that the SKU is measured in
Quantity This is the number of SKUs

(For finished products, this is the packaging unit / sales unit; for raw materials, this is the smallest unit of measurement).
Quantity, UoM This is the amount of units which the SKU is measured in.
Net Weight (kg) This is the total net weight of the invoiced SKUs
Free Units (UoM) This is the number of measured units that are free of charge.
Actual Costs of free Units This is the actual cost of the total number of free units of measurement
Revenue This is the total amount of revenue
Line discount This is the discount which is invoiced via service lines
Revenue, aft. discount Revenue, aft. discount

By SKU / Tag

Column header Explanation
Tags These are the tags used on the invoiced SKUs
Revenue, lot lines This is the revenue for the SKUs that are invoiced with the specific tags

By Country

Column header Explanation
Country This is the country that has been invoiced
Revenue, lot lines This is the total revenue from a particular country based on the total amount of lot lines
Revenue, service lines This is the total revenue from a particular country based on the total amount of service lines
Total revenue This is the total revenue from a particular country for both lot lines and service lines

By Partners

Column header Explanation
Partners This is the Partner that has been invoiced
Revenue, lot lines This is the total revenue from a particular Partner based on the total amount of lot lines
Revenue, service lines This is the total revenue from a particular Partner based on the total amount of service lines
Total revenue This is the total revenue from a particular Partner for both lot lines and service lines

By Partner / tag

Column header Explanation
Tag This is the tag used on the invoiced Partner
Revenue, lot lines This is the revenue from Partners with a specific tag based on the total amount of lot lines
Revenue, service lines This is the revenue from Partners with a specific tag based on the total amount of service lines
Total revenue This is the total revenue from Partners with a specific tag for both lot lines and service lines

By Owner

Column header Explanation
Owned by This is the owner of the orders invoiced
Revenue, lot lines This is the revenue of the invoiced lot lines based on the owner of the orders
Revenue, service lines This is the revenue of the invoiced service lines based on the owner of the orders
Total revenue This is the total revenue for both the invoiced lot lines and service lines based on the owner of the order

By Order

Column header Explanation
Order This is the particular order that has been invoiced
Revenue, lot lines This is the total revenue from a particular ordre based on the total amount of lot lines
Revenue, service lines This is the total revenue from a particular ordre based on the total amount of service lines
Total revenue This is the total revenue from a particular order for both lot lines and service lines

By Invoice

Column header Explanation
Number This is the invoice number
Costumer This is the costumer name
Invoice date This is the date the invoice was issued
Delivery date This is the date the invoiced order was delivered
Currency This is the currency of the invoice
Revenue, lot lines This is the total revenue from a particular invoice based on the total amount of lot lines
Revenue, service lines This is the total revenue from a particular invoice based on the total amount of service lines
Total revenue This is the total revenue from a particular invoice for both lot lines and service lines
Total revenue, currency This is the total revenue from a particular invoice for both lot lines and service line in the currency of the invoice
Amount payable, currency This is the amount to be paid (including tax).

By month

Column header Explanation
Month This is the month that is invoiced in
Revenue, lot lines This is the total revenue in the particular month based on the total amount of lot lines
Revenue, service lines This is the total revenue from a particular month based on the total amount of service lines
Total Revenue This is the total revenue from a particular month for both lot lines and service lines

 

Outline