General Journal Import errors

Information  

• Products:  Sparkrock 365 

• Summary: The General Journal import file is not processed correctly and different errors are shown

Details  

With the update to Sparkrock 365 v22.4 deployed in September 2023, the General Journal Import template has received some modifications and improvements. Starting with this release, on the General Journals page, you can use the Import from Excel action to import all general journal data, including account set information. All the new features as well as the new template can be found under the General Journal Import documentation.

IMPORTANT: When you use the new Excel template, the captions for the dimension columns, such as, Dim 1, Dim 2, and so on, must match the dimension captions that are defined in your environment. For example, if the caption for Global Dimension 1 Code on the General Ledger Setup page is defined as Dept, you must rename the Dim 1 caption in the Excel template to Dept. If the dimension X caption is blank you can leave the Excel header for Dim X blank.

KNOWN ISSUE: if one of your Dimensions is called FUND, when you upload the Excel with that column, the system will throw an error message saying "Unable to parse data as Fund Balanced on line number X". The current workaround is to rename the column in Excel to FUND CODE and that should work as expected, the Development team will keep working on a definitive solution.

Resolution  

If you encounter error messages while using the new template please contact Support and we will be glad to help you. A copy of the file you are using will be needed to investigate the root cause.

Impact / Risks  

None 

Workaround  

Not applicable 

Related Information  

Not applicable 

Update History  

The following are the dates and actions pertinent to the history of this issue. 

NOTE: Add dates and actions pertinent to the history of this issue, including any links. (see sample below) 

Attachments (1)

value.png
202 KB