Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
| Account No. | Debit | Credit | Posting Comment | Journal Comment |
| 6570-00 | 500.00 | 0.00 | Test comment line | Test journal comment |
| 1014-00 | 0.00 | 500.00 | Test comment line again | Test journal comment again |
The issue is with the Journal Comment header value, it is currently being added as a zero line item to GL_GeneralJournalDetail on the Posting Comment line. It's also only importing the Header row value "Journal Comment" not the values in the cells below the header. Can the zero line item with "Journal Comment" header be skipped on the Line record?
I've tried several "Skip Record" parameters without success, and changing the Journal Comment operation to "Run Assign" but that always fails. I learned at least 1 H field needs to be a "Replace" operation otherwise the job will always fail. I tried making it a constant column like Posting Date but Excel was not passing the dates correctly even with cell formatting and the VI Job Date Mask set to the same format.
Can anyone help point me in the correct direction or understand why this isn't possible?
Thanks,
Charles
