Products and their orders

The Products and their orders report adds up how much of each product you ordered and from whom - for example for negotiating with a supplier or checking material consumption.

You find the report in the menu Documents → Tools → Products and their orders or in the menu Products → Reports. You enter the period (“Export date from” and “to”, or you select a month) and ReFIS prepares an XLSX file. Nothing is shown on the screen.

Items from both issued and received purchase orders in the selected period, by the sending date of the purchase order (for one not sent, by the creation date). The rows are grouped by product, supplier and item description; quantities and amounts are added up.

Columns: amount description, product type, supplier, product identifier and name, product category, quantity from orders, unit, price excluding VAT, VAT rate, price including VAT, total price excluding and including VAT, web and note of the product, and label identifiers. “Price excluding VAT” and “Price including VAT” are unit prices, “Total price excluding VAT” and “Total price including VAT” are totals per row.

You see the report with the “Products and their orders” right.

• Products
• Orders