When exporting G/L transactions which contain quotes in G/L consolidation, the G/L Consolidation import will fail with "CSVI.C - Open-Ended Quoted String" error.
The import file then needs to be manually modified and any additional line breaks removed in order to be able to import the file.
This has been a bug now in several versions up until the current version 6.1 and really needs a fix.
by: Andreas B. | over a year ago | Setup / Environment
Comments
I agree with Andreas B. The hot fix which Accpac provides does not work with all companies. i found that this error is occurring due to some special characters like " (quotation marks etc.) if this is avoided by a validation at a time of input it would help in preventing this kind of error. however this would be a temporary solution and not permanent.
This is causing a big issue at clients now as the manual process to remove the offending chars is very time consuming. This needs to be escalated as it has come from 5.x days
This is a big problem with a client as they have the import automated and so no errors are received and then it is a manual process to correct the errors.
Needs sorting ASAP, big hole the product, customers will loose confidence in Sage 300, if it cannot do a basic task without errors.
Have a very unhappy client. During the course of a month they will have this error occur 4-5 times when consolidating. Sage needs to scrub all invalid characters (carriage return line feed, commas, quote and any other characters) from the description and reference fields that can cause a problem on the import. We can provide sample files for testing if needed.
Causing grief and many, many hours of audit to confirm imports. Please fix to eliminate inra-field control characters such as CR-LF
Adding timestamp 2021 Dec 8th
Error Posting to a locked or Inactive Year.
Fix Review entry to confirm that you are posting to the correct year. If so, you will need to go to Common Services, Fiscal Calendar to unlock/activate the year.
Error Invoice XXXX already exists.
Fix You have already used that Invoice number for that vendor. Review whether you are duplicating the entry. If not, you can add a letter/number at the end of the invoice which will still help you to identify the payment to that invoice.
Error Net invoice amount is not equal to the net distributed amount for batch xxxx, entry xxx
Fix Review the entry, taxes, and totals to find the discrepancy.
Regards,
James
Any updates on this one?