You will find a general description of how to manage lists in MONITOR in the chapter Managing Lists in the System under General in the MONITOR Basics guide.
What Does This Procedure Do?
Under the Create tab, you can create a log containing the purchase statistics per supplier, part, order or date. You can also view these statistics as a total per week, month, quarter or year. The Supplier Invoice Log procedure shows the same information as the procedures Purchase Statistics - Suppliers and Purchase Statistics - Parts.
There are different list types to choose from. Each list type presents the information in a different way. For the total list types, you can select Compare price in order to calculate the price difference (PD). In the Log list type you will see coding and Intrastat information for each invoice row. Intrastat information means the Statistical Goods Codes and VAT number of the supplier. The different list types are described under Printout Samples.
You can also choose which invoice row types you want to include in the lists.
What are Purchase Statistics?
You can create purchase statistics on two occasions in MONITOR; either during arrival reporting using the Arrival Reporting and Bar Code Arrival Reporting procedures, during subcontract reporting or when linking arrival reported orders to a supplier invoice in the Register Supplier Invoice procedure. This is determined by the settings Create supplier invoice basis During Arrival Reporting and Create supplier invoice basis during Subcontract Reporting, under the Accounts Payable section under the Purchase tab in the Settings procedure.
The system will then calculate all the purchase statistics and load it from the supplier invoice log. You can also create purchase statistics in the procedures Purchase Statistics - Parts, Purchase Statistics - Suppliers and Service Statistics in the Sales module.
The equivalent sales statistics are created in the Invoicing Log during invoicing.
What Update Options Exist for this Procedure?
When using the Log list you can update standard prices and purchase prices for parts, provided that the part on the invoice has row type 1. This is done by right-clicking. Please read more about Updating prices in the chapter called MONITOR General Information in the MONITOR Basics.
There are no other update options in the procedure, as the information is basically just a statistics printout.
Can Any Charts Be Displayed?
In the Display List mode, you can view a chart of the list if you have selected the list type Only total.
Window Functions
Read more about the Window functions under Window Functions in the MONITOR Basics guide.