I wrote an integration to add lots of records to the general journal.
After running the integration, I can go into GP, look under batches, and find the batch ID I used with my integration.
At this point, my batch hasn't been posted.
When I click on "Transactions" I see my various general journal entries, BUT most of the data fields are blank! I don't see any data in the debit field, the credit field, etc.
Any ideas?
I'll describe my integration below.
I read in two (2) CSV files, one named GJ-header, and the other just named GJ. The header has one row for every two rows in the other file, and I link them together using a column named "rownum". In the main GJ file, I have a row for the debit record and then a row for the credit record.
In the GJ-header file, I have a rownum column, a batch ID column and a reference column.
In the GJ file, I have a rownum column, an account column, a debit column, a credit column and a distribution reference column.
When I run the integration, I don't get any errors or warnings.
Any ideas?
Thanks in advance.
*This post is locked for comments
I have the same question (0)