Administration, Core Financials, and Project Accounting

[JNEWSOME]

Is anyone using an AR import for electronically posting receivables from a bank lockbox?  If so, how are you doing that, did it require much programming by IT, and what bank are you using?

[jbuddecke]

We have done this for a client using FTP to download the info then use SQL tools including SQL jobs, DTS/SSIA and stored procedures.  It will take a little bit of work to get this working correctly for your setup, but it may be worth it over the long term.

Also, there is lockbox code included with the 7.3 SDK.  So, if you have access to a reseller with source code, then they may be able to do this for you in another way.

[JNEWSOME]

Does version 7.3 have the capability to import cash receipts without customizing?

[jbuddecke]

You should be able to do it via Dataporter but that would require manually configuring the spreadsheet file then importing on a daily basis.  You might also be able to set this up via Data Import Manager in version 7.2 or 7.3 to run on a scheduled basis.

[DFeller]

We have used the xAPI to import cash receipts into MAS 500.  Works great.

Dawn

[Jshadwell]

Dawn,

Can you give me more details on using the xAPI.   I have a client moving from 200 to 500 and I have to duplicate their current cash receipts import.

James

[JohnHanrahan]

James,

The xapi is from the old Sage PSG.  I don't believe PSG is alive anymore.  However if you call support I think they'll give the xapi for free.  You'll have to figure out how to use it yourself though.  For some of the projects I've done it wouldn't work so I had to code my own CR imports, it's been a while and I forgot why.

Good luck,

John