C spire data pass prices5/18/2023 ![]() ![]() For Price Matrix imports, if you are re-importing a price list (where you designate the customer and the part number) you will get duplicate values UNLESS the price matrix record number is part of the import.To import an account number, such as for the vendor import when you are designating a default vendor GL account, you probably will have to save your spreadsheet as a CSV first. ![]() ![]() The import data can be an underlying formula.There can be extra columns that do not form part of the import.It does not matter what order the rows are in.These are case sensitive – must be in all caps. Any codes that rely on existing data must exist, such as terms and ship via codes.The fields must have 0 and cannot be blank. You must have data in all numeric fields.The spreadsheet must be designed like a database, with a ‘header row’ for each piece of data or ‘field’ to be imported, and the data in rows underneath.It is typically done from an Excel spreadsheet. Importing must be done very carefully however, since it can also wreak havoc in your Spire data. Spire has a built-in utility to import data, which is important for a multitude of uses, such as updating customer or vendor pricing.
0 Comments
Leave a Reply. |