GL Import from Excel Missing header on the first record
I have a problem where the first transaction is missing the header record when trying to import from an excel document. The other three transactions are fine. I believe I have the key set correctly. The key is the reference and it creates a transaction for each reference type.
I was able to identify the problem by running the map to a file and reading the xml. My excel data source is through ODBC Excel 2010.
The structure of the spreadsheet is:
How do I get the header record to populate?
I was able to identify the problem by running the map to a file and reading the xml. My excel data source is through ODBC Excel 2010.
The structure of the spreadsheet is:
CAMM Account | GPAccoun | Debits | Credits | Transaction Date | Reference |
How do I get the header record to populate?