Automate A/R Cash Apps in Macola ES ?

[jbphmd]

Looking for how to Automate the A/R cash receipts into Macola ES from a file from someone like Wachovia Bank. Thanks

 

[abaldwin]

Well my first thought is to use Flex or VB and a connection to the DB. Please post your version of Macola, version of the backend db (i.e. Pervasive or MS-SQL) etc.
Thanks


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[jbphmd]

We are going to Macola ES 360 - Microsoft SQL - this month

Wondering if anyone has already done this ?

 

[jbphmd]

I mean has anyone automated the cash receipt function in Macola ES ?

 

[NEmacGuy]

Talked to your Var or Macola. The Financials part of ES are built around bank on a european model. You are suppose to be able to import a NACHA file (US standard for eletronic banking).

 

[jbphmd]

Thanks for your help. I have asked my Var and they do not know. Generally Macola is not helpful unless you know a particular person or group. Do you happen to know who would handle this or how I can get more information ?

Thanks

 

[dgillz]

Flex is not available in the financial modules of ES so I donot know how you would do this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[abaldwin]

Forgot about that. I would imagine you need to do this outside the system with VB or the import if available.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[NEmacGuy]

Well, I have somebody that wants to do the same thing. I have processed a few fake transactions, and I am going to contact exact, verify my testing.

 

[jbphmd]

Thanks - I'd like to hear if the testing is successful.

 

[dgillz]

NEmacGuy,

Talk to Carol Pahl. She helped Mike Leahy do something pretty exotic like this once. It was not cash receipts however.

I also believe this is sorely needed as I have 2 customers usings the AR Lockbox feature that used to be sold by Peak and they will not go to ES if they do not get the equivalent functionality.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[stravis]

This is part of Macola ES. You can import transactions that appear just as transactions entered through the G/L / Entries / Bank/Cash application. Information can be found about this entry on the Exact website in document 09.361.573. This document describes the capabilities and also references the CSV (Comma Seperated Values) file format.

You will need an application to translate your AR Lockbox file from your bank in to the format used by Macola ES but this is not a difficult process once you know the target data format.

Understand there are some limitations to this method. These cash receipts are not automatically matched and you will need to do this information on your own. I would suggest manually entering data through the entry screen to get an idea of what information you will have available and then from there you can determine if you have enough information in the system to meet your needs.

Scott Travis

http://www.infoSpring.net

 

[jbphmd]

Thanks for the Help - I'll give it a try