Error Messages #
The following are error messages that you may encounter, what it means, and how to resolve it.
Required #
What it means
This means that the field specified for the column field is a required field.
How to resolve
Make sure that the column field for the row being imported is not left blank
Duplicate in database #
What it means
There is already an existing record in the system
How to resolve
Make sure you are not re-uploading the same data or change the parameters of the record being uploaded
Parent is required if Type field is Child or Both #
What it means
You are uploading a GL account where you specified that it is a child account or both (meaning it is a child of an account and the account you are uploading is also a parent account) you have to specify the parent account.
How to resolve
Make sure you fill up the Parent column with the appropriate parent account.
[RECORD] Not Found #
What is means
When uploading transactions via a template and encountering an error message saying that a specific record is not found. It usually means one of the following:
- The record that the system is validating against is not existing yet.
- It may be existing but there are extra characters in the template that are not visible. This maybe be extra spaces in front or at the end of the record
How to resolve
- Make sure that record being referred to in the error message exists
- Check the record in your import template file and make sure there are no spaces in front or at the end.
- Try re-typing the data in the cell manually
Invalid date. Use YYYY-MM-DD format #
What is means
The system reads the date format in a specific way to make sure it doesn’t mix up the day and the month. In some cases, the spreadsheet you are using may have reformatted the date format you have entered.
How to resolve
- Make sure to set the correct date format
- You can add a single quote( ‘ ) in front of your date (ex. ‘2020-05-23). This will keep your spreadsheet software from changing the date format.
