Template Column Headings. Each column has one of the following colour codes: Orange - Mandatory Fields which must be populated. Failure to populate these fields will result in you being asked to resubmit your MI return. Blue - Required Field. Please populate as much as possible. Grey - Not required. Please do not populate these fields. Each column heading contains comments which will provide you with details of what is required in the column. Please check this before you populate. Acceptable Values: Where applicable, acceptable values may be listed within the comments field attached to each column or the comments will refer you to a tab contained within the MI template. Please ensure you use these acceptable values, these are case sensitive and must be completed as shown. Any other values entered within these fields will cause validation errors when loading onto MISO. Format of Data: Please ensure you enter the MI data in the correct data format for example date, currency, number. Please do not enter values such as N/A, dashes or TBC in any cells unless instructed to do so by the cell comments. Please also avoid using speech marks (") in any cell.
Template Column Headings. Each column has one of the following colour codes
Template Column Headings. Each column has one of the following colour codes: • Orange − Mandatory Fields which must be populated. Failure to populate these fields will result in you being asked to resubmit your MI return. • Blue − Required Field. Please populate as much as possible. • Grey − Not required. Please do not populate these fields. Each column heading contains comments which will provide you with details of what is required in the column. Please check this before you populate. Acceptable Values: Where applicable, acceptable values may be listed within the comments field attached to each column, provided in a drop−down box within the cell, or the comments will refer you to a tab contained within the MI template. Please ensure you use these acceptable values, these are case sensitive and must be completed as shown. Any other values entered within these fields will cause validation errors when loading onto MISO. Format of Data: Please ensure you enter the MI data in the correct data format for example date, currency, number. Please do not enter values such as NƒA, dashes or TBC in any cells unless instructed to do so by the cell comments. Please also avoid using speech marks (") in any cell. Quarterly MI: Columns A−D are mandatory for all bids submitted within the previous quarter. Please complete all relevant columns in E−I where you have made changes to your list of subcontractors Further Guidance: If your MI return fails to upload onto MISO please send a copy of your completed MI return and a screen shot of any error message to the below email address. Please contact the MISO support team using the contact details below if you require any assistance. MISO Mailbox: XXXX.Xxxxxxx@xxx.xxx.xxx.xx MISO Support Number: 0151 672 2040 INVOICES RAISED Lot Number MANDATORY FIELD Reference to identify the lot within the framework contract the invoiced is raised against. Customer URN MANDATORY FIELD Unique Reference Number (URN) of the public sector customer who made the procurement. Customer PostCode MANDATORY FIELD Post Code of the public sector customer who made the procurement. Customer Organisation MANDATORY FIELD Name of the public sector customer who made the procurement. Service Location MANDATORY FIELD Please indicate whether the service described has been carried out in Domestic or International territory Customer Invoice Date MANDATORY FIELD Date the invoice was raised. Customer Invoice Number MANDATORY FIELD Reference to identify the invoice issued to the customer Customer...
