Error Posting AR Invoice Batch "File Write Failed. Error - 12. G/L transaction processing completed. Errors found during processing"

When posting AR Invoice Batch list, we are getting an error "File Write Failed. Error - 12. G/L transaction processing completed. Errors found during processing."  This is normally due to the ??gltran.csv file meeting its cap. Article on csv file here --  www.sagecity.com/.../no-gl-no-problem. 

Normally renaming the csv file to old resolves this error.  This causes Sage to create a new csv file when posting.  However, this time when the csv file was recreated by Sage, Sage began writing batch 1 to the csv file instead of batch 3915.  It took 3 hours and then Sage failed writing batch 687 to the file because the csv file reached its cap again.  We renamed the file again and posted batch 3916.  Sage then began writing batch 688 to the csv file. 

We cannot continue this process of it writing old already posted batches to the csv file, failing, and renaming the file.  Sage is pulling the last written batch from a registry somewhere.  Does anyone know how to resolve this issue?

Parents
  • 0

    Every time that I have to contact Sage support it is a waste of time and in the end I always get no help or answer.  I did end up figuring this out myself.  Even though Sage support stated that they do not hold this value anywhere,  it is held in the table ARR06.  For the invoice batches it is GLINVCPOST.

Reply
  • 0

    Every time that I have to contact Sage support it is a waste of time and in the end I always get no help or answer.  I did end up figuring this out myself.  Even though Sage support stated that they do not hold this value anywhere,  it is held in the table ARR06.  For the invoice batches it is GLINVCPOST.

Children