Unique Business Challenges and General Discussion

[lkleinfelt]

I am trying to figure out how to use the bank reconcilation module. Everything seems to be in place, however, I am trying to determine how to get our AR to show. We use another database for receivables and import the information through the general ledger exchange. I would typically complete my import through a general journal entry. Do I have to use a transaction journal entry now? I've never used transaction journal entriy. How do I get an import to load in a transaction journal entry? Thanks

[thebottomline]

Since I have the VI module, I can't really comment on Exchange.  But gut feeling, is that if you want the deposits to show in BR, you will have to use VI to make it work.  Again, just a gut feeling.

Hopefully, someone else can verify.

[kanes]

We use VI to import into Transaction Journal Entry, which is linked to Bank Rec.

Steve

MAS200 V4.30.21

[lkleinfelt]

Well i received two responses and you both mentioned using the VI module to import transactions for BR. I don't know what the VI module is so am certain we don't currently have it. Guess I'll have to contact our reseller.

Thank you for your help.

[rmikolainis]

---

lkleinfelt wrote:

Well i received two responses and you both mentioned using the VI module to import transactions for BR. I don't know what the VI module is so am certain we don't currently have it. Guess I'll have to contact our reseller.

Thank you for your help.

---

VI - Visual Integrator

If you are EVER going to buy anything, buy this module!!!!! Its almost a no brainer to buy, it will pay for itself in less than a year with the time you'll save.

[SRYork]

You are correct, GL Transaction Entry is integrated with Bank Rec. But, I did a quick look and I don't believe you can use GL Exchange to import records into the GL Transaction Entry data files.  Therefore, I believe you have 2 options (both of which will require acquisition of VI):

1. Switch from using your current GL Exchange import to using a new GL Transaction Journal import.
2. Continue using your current GL Exchange import into General Journal entry and create a second VI import job to import the same import file into Bank Rec.

Obviously #1 is the most efficient.  GL Transaction Entry was designed to provide a means of entering a group of similar transactions.  Say for example sales.  You would set up the transaction to be a credit orientation and enter your sales (credit) detail, this would be totaled against a one line debit batch total.