Update: Looks like Janelle is sorted
In summary:
1. The data posted above is just an excerpt from the actual larger import file
2. The excerpt above if imported actually generates 1 entry not 3 entries. Janelle's reference to 3 entries were really made in the context of what happened to those particular records when importing from the entire file
3. Because Bank Reference is being imported (rather than defaulted or not imported at all) a "Standard" as opposed to a "Deposit" batch is being imported/created
4. Consecutive records with identical Check Numbers import as multiple "details(distributions)" of one entry
5. Once the Check Number changes, the import considers a new entry has started
6. Standard batch entries always show separately in the balances/reconcilliation windows - regardless of their Bank Reference (this is different for Deposit batches)
Assuming that Janelle always wants each individual record within the import file to generate a separate reconciliation transaction when posted in Adagio, the immediate solution (see example below) would be to modify the process that creates the import file so that both the Bank Reference and the Check Number fields have the same unique (from record to record) info. that is currently being placed in the Bank Reference field.
Example:
6/1/2011,6 11115,BO-128432/100134,100134,201,6 11115,2100
6/1/2011,6 11116,BO-128432/100130,100130,201,6 11116,13207.28
6/1/2011,6 11124,BO-128432/100131,100131,201,6 11124,987.9
6/1/2011,6 11131,BO-128432/100132,100132,201,6 11131,1063.16
Regards, Pete
Edited by BAMPH (07/27/11 07:44 PM)