On 25/10/12 11:04 -0700, Albert Cervera i Areny wrote: > El dijous 25 d’octubre de 2012 12:04:06 UTC+2, Cédric Krier va escriure: > > On 25/10/12 11:50 +0200, Albert Cervera i Areny wrote: > > > 2012/10/25 Cédric Krier <[email protected] <javascript:>>: > > > > On 25/10/12 10:44 +0200, Albert Cervera i Areny wrote: > > > >> I've created a Blueprint here: > > > >> > > > >> http://code.google.com/p/tryton/wiki/StatementImport > > > >> > > > >> Comments are very welcomed! > > > > > > > > I don't see the need of such infrastructure. > > > > > > > >> Store the bank statement keeping the same data provided by the bank > > > > > > > > It just needs to create a Binary field to store the imported file on > the > > > > statement. I think it is better to have one field per format so each > > > > module that adds support for 1 format should create it. > > > > > > I thought of using attachments. But I'm ok with a binary file too. > > > > > > >> Rule system to ease and automate the process of finding invoices and > > > >> reconciliation or determining accounts to use > > > > > > > > I think we already have it: search_rec_name > > > > > > The problem is that bank statment file can contain several fields not > > > just one. Hence search_rec_name is not appropriate to handle this. For > > > example, some information that can be found (optionally) is the > > > description of the line, the VAT number of the sender/receiver, as > > > well as extra information. This already exists in AEB43 and I guess > > > others will have something similar. > > > > So search for each fields you have but you can not do that in a generic > > way because each format will give you a specific set of information. > > It depends. Amount and description are quite usually there. Also, there are > some complex cases. For example, in Spain you may receive a single payment > that corresponds to the payment of several customers (yes, I know it sounds > strange to you) which the user may have already sent to the bank the > request. Don't want to get into details about this but basically one bank > statement line can correspond to hundreds of different invoices (have now a > customer that corresponds to thousands of them). That can usually be > automated (we inform the system that there will be this payment) but in > OpenERP the search system was linked to the import process and had to > change it because you may not have some information at the import time on > the system. Then you make changes to the statement and when you have all > the information you want the system to "recheck" some of the lines of the > original statement. In order for the automatic system to find invoices (or > whatever) for the user.
I don't understand why you want to put all in the statement. If you don't find invoice on the statement that's not a big issue, just make the reconciliation later. -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: [email protected] Website: http://www.b2ck.com/
pgpFEQ7DBPbeM.pgp
Description: PGP signature
