General Journal Import errors

Modified on Sat, 20 Jul at 10:28 AM

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 1Dim 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 DeptIf 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) 

Date 

Details 

Link 

09/25/2023 

The first version of this Knowledge Base article was created. 

  

Attachments (1)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article