* Betr.: " Re: [tryton-dev] Statement Import" (Thu, 25 Oct 2012 18:35:45 +0200):
> Le Thu, 25 Oct 2012 18:14:05 +0200, > Mathias Behrle <[email protected]> a écrit : > > > * Betr.: " Re: [tryton-dev] Statement Import" (Thu, 25 Oct 2012 > > 17:37:12 +0200): > > > > I know what I'm talking about. I worked 2 years in a bank. > > > First of all, in belgium asking for a statement you already > > > received is charged by the bank. And a bank should not send you > > > twice the same statement by default, this is very basic logici if > > > they don't want customer complaints. > > > Second, detect duplicates could not be generic, again it will > > > depend on each format. I'm pretty that each standard format that > > > exists will have a unique reference for the statement and that this > > > statement could not contains duplicates lines. > > > > PLease re-read. I talked about exports from a banking software. And > > sorry, no, there is no unique reference despite all assumptions one > > would make (specifically talking about format MT940, which is a very > > current exchange format in Germany). > > Are you sure? from martin.hinner.info/bankconvert/swift_mt940_942.pdf, > I see a field "Statement Number/Sequence Number" which identify the > statement inside the year. Usage of those fields is far from being standardized, at least with German banks. There is for example field :20: of MT940, which is according to [1] (the standard document we are using as base for our implementations) designed to be a reference number. The problem is, that many (all?) german banks just don't use it this way... To our knowledge it is necessary to compare balances and accounts, as far as available, to provide reliable import results. > As Albert said earlier, there is a lot of different format. I fail to > see how to find common concepts except the statement itself. +1 [1] http://www.bankenverband.de/downloads/012010/version-2-4-anlage-3-dfue-abkommen.pdf -- Mathias Behrle MBSolutions Gilgenmatten 10 A D-79114 Freiburg Tel: +49(761)471023 Fax: +49(761)4770816 http://m9s.biz UStIdNr: DE 142009020 PGP/GnuPG key availabable from any keyserver, ID: 0x8405BBF6
signature.asc
Description: PGP signature
