Supplier Analysis
This report shows the Items that you have ordered and received from each Supplier during the report period. It also shows how many of those Items have been sold in the same period.
When printed to screen, the Supplier Analysis report has the HansaWorld Enterprise Drill-down feature. Click on any Supplier or Item Number in the report to open the Contact record for a Supplier or an Item record.
- Period
- Paste Special
Reporting Periods setting, System module
- The report period: the quantities or values shown in the report will be calculated from Purchase Orders, Goods Receipts and Invoices belonging to the period specified here. The default is the current calendar month.
- Supplier
- Paste Special
Suppliers in Contact register
- Range Reporting Alpha
- Specify a Supplier or range of Suppliers to list the Items ordered and received from those Suppliers during the report period.
- Supplier Cat.
- Paste Special
Supplier Categories setting, Purchase Ledger
- Specify a Supplier Category to list the Items ordered and received from Suppliers belonging to that Category during the report period.
- Location
- Paste Special
Locations setting, Stock module
- Specify a Location to list the Items that have been ordered for, received into and sold from that Location during the report period.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Specify an Item Group or range of Item Groups to limit the report to Items belonging to those Item Groups.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- Specify an Item Number or range of Item Numbers to limit the report to particular Items.
- Sums
- Use these options to specify whether the report should list each Item individually, or whether it should contain total figures for each Item Group.
- Per Item
- For each Supplier, the report will list each Item individually, with figures per Item for quantities or values ordered, received and sold.
- Per Item Group
- For each Supplier, the report will list each Item Group individually, with total figures for each Item Group for quantities or values ordered, received and sold. A separate line will show the total ordered, received and sold for Items that do not belong to an Item Group.
- Function
- Use these options to specify whether the report will contain quantities or values.
- Quantities
- For each Item or Item Group, the report will show the quantities on Purchase Orders, Goods Receipts and Sales Invoices during the report period.
- Values
- For each Item or Item Group, the report will show the quantities on Purchase Orders, Goods Receipts and Sales Invoices during the report period. Total Cost of Sales and Gross Profit for each Item or Item Group for the period will also be shown. These last two figures will be controlled by the GP Based options below.
In both cases, figures will be compiled from approved and unapproved Purchase Orders and Goods Receipts, but only from approved Sales Invoices.
- GP based
- If you produce the report using the Values option above, use these options to specify how the Cost of Sales and Gross Profit figures will be calculated.
- Today's Cost Price
- The Cost of Sales will be the current Cost Price from the Item record.
- Cost Price as of Delivery
- The Cost of Sales will be the Cost Price from the Item record as it was when the Item was received into stock.
- Queue Cost Price
- The Cost of Sales will be the actual stock value of the Item when it was removed from stock, calculated using the Item's usual Cost Model and shown in the FIFO or Row FIFO field of the appropriate Invoice or Delivery row.
Introduction to Reports in the Purchase Orders Module
