Thanks Sharan, that is something to work with for starters.
I will go on with that when I have the data spec from the bank(s). THX. On Fri, 03 Jul 2015 13:41:03 +0200 "Sharan-F" <[email protected]> wrote: >Thanks for the recommendation Jacques. The book doesn't cover >importing bank >statements.(although there is a small appendix about importing >data via the >webtools menu) > >I think that if you want to look at importing a bank statement >then an xml >import is the way to go (so if you can convert it to xml you can >import it). >Effectively all you are doing is importing transactions. > >The challenge you may have is going to be the format and linking >with the GL >and other areas. I'd suggest you look at importing it as a >financial account >bank account to start with. That way you can have a play around >with the >different statuses and reconciliations available and posting the >transactions to the GL account you want. > >It's been a while since I looked at it but I remember some >functionality >around reconcilation that matches the closing balance of one >reconciliation >against the following one, which would help as an ongoing balance >check for >ongoing imports. > >It's a bit hard to say much more without more information. > >Anyway, hope this helps. > >Thanks >Sharan > > > >-- >View this message in context: >http://ofbiz.135035.n4.nabble.com/Import-of-bank-transaction- >statement-data-QIF-tp4670715p4670740.html >Sent from the OFBiz - User mailing list archive at Nabble.com.
