Hi, can anyone help me figure out why the first two lines below consolidate on import into BankRec and the third and fourth remain separate?

Date, BankRef, CustNam, GL Acc, GL Dep, ChqNum, Amt
6/1/2011, 6 11115, BO-128432/100134, 100134, 201, BO-128432, 2100
6/1/2011, 6 11116, BO-128432/100130, 100130, 201, BO-128432, 13207.28
6/1/2011, 6 11124, BO-128432/100131, 100131, 201, BO-128432, 987.9
6/1/2011, 6 11131, BO-128432/100132, 100132, 201, BO-128432, 1063.16


Thnx.

Imports fine for me into the sample data (after changing the g/l account-dept to match the sample chart of accounts.

Imports are fiddley. Does the import process report any errors?

The import process does not report any errors. It shows that 4 lines are imported, but when we check out the batch, there are 3 entries with the first 2 lines making up one entry in the batch. so far, it appears to happen when the lines have the same cheque number and the BankRefs are consecutive. Does that make sense?

Your import template should be "Detail Only" to correctly import these records. Could you check your import template?

Hi Janelle,

First I'll just mention that these types of topics, this one and the printing problem one, are more suited to the Technical Support forum rather than the the General Inquiries forum. The TS forum is meant for situations where the products are not acting as expected or are generating actual errors, while the GI forum is more suited to questions like "Can the product do this, Can the product handle that, What's needed to run the product, etc."

With respect to the import problem, it might help if:
(a) You posted the complete (including the date in brackets) version info. In fact, I would recommend that you include this info in the initial post for any Tech Support topic. This can be seen on the splash screen when starting the module or if already in the module, by selecting Help | About. My version is 8.1C (110512) and I happen to know that you upgraded to that version recently.

(b) You could provide an image of your Import Template definition, either by embedding a screen shot or attaching a .PDF (or some other common format) to the forum post. To get the Template definition, select [Print] from the Import Template window.

Your observation "so far, it appears to happen when the lines have the same cheque number and the BankRefs are consecutive" is interesting. If the Bank Ref were somehow being truncated by one digit on the right, "6 11115" and "6 11116" would not be unique whereas the others in your example would be. Food for thought.

Regards, Pete

Hi Pete -

Thanks for the clarification....the problem is that I am unable to add new posts in the Technical Support Forum.

Sedonia sent the file information to you on Friday as well as the template definition. We would like to call you to discuss this issue.

You should be able to post in the Technical Support Forum now.

Hi Janelle,

I believe that the rules for posting in the TSF are
(a) Be a Registered User on an Upgrades Plan (which you guys are) and
(b) Register (free) on the forum which I believe you have

... and the Adagio God says "ask and ye shall receive" Andrew sorted you out, so you should be good to go.

I'll be in touch.

Pete

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