Errors when importing a purchase order template can be caused by numerous issues in the data of the import file. The follow are common errors and their solutions.
A Line Item Doesn't Exist In the Import
Check for blank data at the ends of the import preview. Blank data could be related to phantom data in the spreadsheet. Blank data should be deleted from the spreadsheet and re-imported.
Invalid Product Number/Name
Check that the product number exists and is active in the catalog. Check that the product name exists and is written exactly as it exists in the catalog.
Invalid Room Number
Check that both Site ID and Room exists in the site importing the data. The import file must include the Site ID – not the Site Name – and the room must exist on the import file exactly how it is written in Asset Management.
Invalid Order Number
Check that the user has created the Purchase Order shell in purchasing. The Purchase Order shell must exist in Asset Management prior to being uploaded.