Hello,
I am trying to set up a configuration table to import a CSV file of General Journal Entries from a different software.
It actually contains multiple entries but has extra columns and rows that are not needed. See the attachment.
I would want the Date, GL Accounts, amounts and to parse the account number from it being included with the name and hit the customer card,
Loan tables have not yet been created for each customer, but I am just testing things in the Sandbox environment.
I started configuring one like this:
With these fields:
I think I read that I can map columns in that one to what it should in BC, but is that correct?
Will it ignore the added TRANS rows and how would I get it to automatically parse the account number from the account number / name?
Some days there will be 5 entries. Some days there can be 50.
Any tips, help, recommendations, omissions or things I need to take out would be greatly appreciated.
By the way the Chart of Accounts is created using the same GL names.
Thanks,
Cedric
