General Ledger Integration with separate header and footer lines
Sorry – missed filling out the description when I submitted.
My issue is that all the samples I’ve seen show one line header/footer records for GL journal entry integration. I have a pipe-delimited text file with separate header and detail lines. I’ve used the multi-data source feature and created two select statements and joined them on the key field which is the batch number. For some reason it is bringing the same journal entry in twice. Any help is greatly appreciated.
And I would also suspect that your statement “separate header and footer lines” really means “separate header and footer files“.
Assuming so, then the answer is “yes” – a couple different ways.
You could use an ODBC Query on both files to join them into one SQL query results that you would process.
Or you could use a multi-data source and two text files and let SC join them together for you.
I added a comment after I realized I forgot to put in a description. I’m getting duplicate Journal Entries and not sure why.
If you would like to submit an answer or comment, please sign in to the eOne portal.