Purchase-related statistics

Related topics

You have the possibility to generate the following two types of statistical output:

  • Purchase statistics (i.e. Reception statistics)
  • Supplier evaluation statistics

Note: You can maintain the statistics specification for Purchase statistics as well as print the output. However, with Supplier evaluation statistics you only have the option to print the output.

Unlike the DC1 Report Writer, which often displays information on a higher level, the advantage with using the Purchase statistics routine, is being able to view detailed reception line information.

Apart from being able to generate statistical output, DC1 Distribution also automatically updates statistical-related fields. Note: These fields are a summation of Item and Supplier information.

You can find these fields in the:

  • Item file (Supplier information panel), where you can view information such as the:
    • Number of order lines generated for the item year-to-date
    • Total order value for the item year-to-date
    • Number of receptions for the item year-to-date
  • Item file (Warehouses panel) for an actual warehouse, where you can view information such as the:
    • Number of issues year-to-date and last year
    • Quantity issued year-to-date and last year
    • Number of receipts year-to-date and last year
    • Quantity received year-to-date and last year, etc.
  • Business partner file (Supplier file panel), where you can view information such as the:
    • Number of orders entered for the supplier year-to-date
    • Total purchase order value for the supplier year-to-date
    • Number of receptions year-to-date and last year

See the Panel help for the respective panels for more information.

When statistical data is created

The statistical information for the types of statistics you can generate is created at different events, which is dependent on the type of statistics. The sections, below, describe this.

Reception statistics

Prerequisites
In order to be able to receive this statistical information the following must be defined:

  • Add to statistics must be set to YES in the Purchase order type table
  • Purchase statistics must be set to YES in the Item file, Inventory information panel

Reception statistics are created at:

  • Reception note confirmation
  • Quality control confirmation

Supplier evaluation statistics

Prerequisites
In order to be able to receive this statistical information, Add to statistics must be set to YES in the Purchase order type table.

Supplier evaluation statistics are created at:

  • Reception note confirmation

Enquiries and printouts

  • Item file enquiry
  • Business partner file enquiry
  • Goods reception enquiry where you can view, for example, the purchase orders received from the supplier. You can use this program to compare what has been received against the supplier’s invoice. Note: In order to receive this information, the Add to rec field must have been set to YES for the order type in the Purchase order type table.
  • Item/supplier comparison enquiry where you can, for example, compare the different purchase prices for different suppliers and also obtain statistical-related information.
  • Print purchase statistics list
  • Print supplier evaluation list
  • Print item file list
  • Print business partner file list

Related topics