GL Consolidation Error CSVI.C Open-ended quote String

SOLVED

Hi ,

while consolidating the Child companies to the parent company we are getting this error. we have 14 entities in the same consolidation all are working fine except two companies with the same error. 

when we further explore it we found that the issue is with the first Entry that is Opening Balances Entry, if we skip that entry then it is working fine. In the Opening Balance Entry first Two lines are getting imported and then the system is giving the error.  we have checked the same entry, exported it to excel but didn't find any issue with the account or the entry or even with the value. the GL Accounts are also not having any issue as they are the same in all the entities.  any idea?

Parents Reply Children
  • 0 in reply to [email protected]

    You can't see it in the file, open the export file in a text editor and you will see a line that doesn't start with a 1 or a 2, the line above has the issue, remove spaces until it lines up correctly with 2 for detail lines as the first number on the line. 
    It's a pain and usually it's where someone has copied text from say word into sage and that has hidden characters that you can't see, or commas in a description