Known Issues

File upload

CT-4159

Unresolved

When using Excel files to load data, such as Account Code, Billing Account ID, Cost Center Code, and so on, we’ve observed in some circumstances that the column value is being treated as a number or decimal instead of a string.

Examples:

• When Cost Center Code = 450 is uploaded, it is converted to 450.0, and the system throws a validation error.

• When the first few cells of a column are empty, followed by a string value, it throws an invalid data error, as the system expects the column to be a decimal but finds a string value.

Add a single quotation mark (') to the left of the first cell value. This ensures that the entire column is treated as a string.

File upload

CT-4257

Unresolved

When loading a spend file in XLSX format, if the initial rows of certain fields are empty, the system treats the entire column as empty and skips loading data from subsequent rows even if those rows include valid values.

As a temporary fix, use the CSV file format to load the data rather than XLSX.