How does the tool work when uploading general journals in foreign amounts? The journals won’t be posted until the rate and LCY currency are generated. Typically, Business Central handles this when posting via Edit in Excel or through the UI. However, users of the import tool need to update those fields through the import tool, but currencies are not known by the users.
The Import Export PowerTool does not do any data analysis other than applying any filters that you set. The data needs to follow all the same rules as with a configuration package. You would need to work with your Business Central partner to make sure that the data and layout are valid before importing it.
A general suggestion would be to export some valid records and compare them to your data to make sure you are following the same formatting.