1
=== added directory 'account_bankimport'
2
=== added file 'account_bankimport/__init__.py'
3
--- account_bankimport/__init__.py	1970-01-01 00:00:00 +0000
4
+++ account_bankimport/__init__.py	2010-03-04 01:53:21 +0000
5
@@ -0,0 +1,37 @@
6
1
##############################################################################
7
2
#
8
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
9
4
#                          All Rights Reserved.
10
5
#                    Fabien Pinckaers <fp@tiny.Be>
11
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
12
7
#
13
8
# WARNING: This program as such is intended to be used by professional
14
9
# programmers who take the whole responsability of assessing all potential
15
10
# consequences resulting from its eventual inadequacies and bugs
16
11
# End users who are looking for a ready-to-use solution with commercial
17
12
# garantees and support are strongly adviced to contract a Free Software
18
13
# Service Company
19
14
#
20
15
# This program is Free Software; you can redistribute it and/or
21
16
# modify it under the terms of the GNU General Public License
22
17
# as published by the Free Software Foundation; either version 2
23
18
# of the License, or (at your option) any later version.
24
19
#
25
20
# This program is distributed in the hope that it will be useful,
26
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
27
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
28
23
# GNU General Public License for more details.
29
24
#
30
25
# You should have received a copy of the GNU General Public License
31
26
# along with this program; if not, write to the Free Software
32
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
33
28
#
34
29
##############################################################################
35
30
# I used the code of account_coda as base for this module. The module does
36
31
# exactly the same thing as account_coda. The difference is the file-layout. 
37
32
#
38
33
# This module can import .asc-files (BRI-layout).
39
34
#
40
35
41
36
import bankimport
42
37
import wizard
43
0
\ No newline at end of file
38
\ No newline at end of file
44
1
39
45
=== added file 'account_bankimport/__terp__.py'
46
--- account_bankimport/__terp__.py	1970-01-01 00:00:00 +0000
47
+++ account_bankimport/__terp__.py	2010-03-04 01:53:21 +0000
48
@@ -0,0 +1,52 @@
49
1
##############################################################################
50
2
#
51
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
52
4
#                          All Rights Reserved.
53
5
#                    Fabien Pinckaers <fp@tiny.Be>
54
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
55
7
#                    Jan Verlaan <informatie@veritos.nl>
56
8
#
57
9
# WARNING: This program as such is intended to be used by professional
58
10
# programmers who take the whole responsability of assessing all potential
59
11
# consequences resulting from its eventual inadequacies and bugs
60
12
# End users who are looking for a ready-to-use solution with commercial
61
13
# garantees and support are strongly adviced to contract a Free Software
62
14
# Service Company
63
15
#
64
16
# This program is Free Software; you can redistribute it and/or
65
17
# modify it under the terms of the GNU General Public License
66
18
# as published by the Free Software Foundation; either version 2
67
19
# of the License, or (at your option) any later version.
68
20
#
69
21
# This program is distributed in the hope that it will be useful,
70
22
# but WITHOUT ANY WARRANTY; without even the implied warranty of
71
23
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
72
24
# GNU General Public License for more details.
73
25
#
74
26
# You should have received a copy of the GNU General Public License
75
27
# along with this program; if not, write to the Free Software
76
28
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
77
29
#
78
30
##############################################################################
79
31
# I used the code of account_coda as base for this module. The module does
80
32
# exactly the same thing as account_coda. The difference is the file-layout. 
81
33
#
82
34
# This module can import .asc-files (BRI-layout).
83
35
# 06-10-2009 jverlaan added MT940 filter for Postbank and ING
84
36
#
85
37
86
38
{
87
39
	"name":"Account Bankimport",
88
40
	"version":"0.0.2",
89
41
	"author":"Tiny / Eddy Boer",
90
42
	"category":"Account Bankimport",
91
43
	"depends":["base", "account","account_report","base_iban"],
92
44
	"init_xml":[],
93
45
	"update_xml" : [
94
46
		"security/ir.model.access.csv",
95
47
		"bankimport_wizard.xml",
96
48
		"bankimport_view.xml",
97
49
	],
98
50
	"active":False,
99
51
	"installable":True,
100
52
}
101
0
53
102
=== added file 'account_bankimport/bankimport.py'
103
--- account_bankimport/bankimport.py	1970-01-01 00:00:00 +0000
104
+++ account_bankimport/bankimport.py	2010-03-04 01:53:21 +0000
105
@@ -0,0 +1,238 @@
106
1
##############################################################################
107
2
#
108
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
109
4
#                          All Rights Reserved.
110
5
#                    Fabien Pinckaers <fp@tiny.Be>
111
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
112
7
#
113
8
# WARNING: This program as such is intended to be used by professional
114
9
# programmers who take the whole responsability of assessing all potential
115
10
# consequences resulting from its eventual inadequacies and bugs
116
11
# End users who are looking for a ready-to-use solution with commercial
117
12
# garantees and support are strongly adviced to contract a Free Software
118
13
# Service Company
119
14
#
120
15
# This program is Free Software; you can redistribute it and/or
121
16
# modify it under the terms of the GNU General Public License
122
17
# as published by the Free Software Foundation; either version 2
123
18
# of the License, or (at your option) any later version.
124
19
#
125
20
# This program is distributed in the hope that it will be useful,
126
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
127
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
128
23
# GNU General Public License for more details.
129
24
#
130
25
# You should have received a copy of the GNU General Public License
131
26
# along with this program; if not, write to the Free Software
132
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
133
28
#
134
29
##############################################################################
135
30
# I used the code of account_coda as base for this module. The module does
136
31
# exactly the same thing as account_coda. The difference is the file-layout. 
137
32
#
138
33
# This module can import .asc-files (BRI-layout).
139
34
#
140
35
141
36
import time
142
37
from osv import osv,fields
143
38
144
39
import urllib, urllib2, sgmllib
145
40
from BeautifulSoup import BeautifulSoup, SoupStrainer
146
41
import re, string
147
42
148
43
def _opschonen(name):
149
44
	p = name.split('>')
150
45
	n = p[2].split('<')
151
46
	return n[0]
152
47
	
153
48
def _get_bank_data(bank_acc):
154
49
155
50
	p = {}
156
51
	
157
52
	urldata = {'number':bank_acc,'method':'POST'}
158
53
	
159
54
	data = urllib.urlencode(urldata)
160
55
	link = "http://www.ibannl.org/iban_check.php"
161
56
	
162
57
	req = urllib2.Request(link, data)
163
58
	f = urllib2.urlopen(req)
164
59
	s = f.read()
165
60
	
166
61
	soup = BeautifulSoup(''.join(s))
167
62
	test = soup.findAll('td')
168
63
	
169
64
	bank_id = 0
170
65
	
171
66
	if len(test) > 1 :
172
67
		p['iban'] = _opschonen(str(test[1]))
173
68
		p['bic'] = _opschonen(str(test[3]))
174
69
		p['bank_name'] = _opschonen(str(test[5]))
175
70
		
176
71
		
177
72
		return p
178
73
	
179
74
	else:
180
75
		return False
181
76
		
182
77
    
183
78
184
79
185
80
186
81
187
82
class account_bankimport_filters(osv.osv):
188
83
    _name = "account.bankimport.filters"
189
84
    _description = "Define the filters, which is related to the file"
190
85
    _columns = {
191
86
        'filter' : fields.char('Filtername', size=64, required=True),
192
87
        'name' : fields.char('Filename', size=128, required=True),
193
88
    }
194
89
account_bankimport_filters()
195
90
196
91
# Save data for each company
197
92
class res_company(osv.osv):
198
93
	_inherit = 'res.company'
199
94
	_columns = {
200
95
		'bank_journalid' :  fields.many2one('account.journal', 'Bank Journal', required=True),
201
96
		'def_payable' :  fields.many2one('account.account', 'Default Payable Account', required=True, domain=[('type','=','payable')]),
202
97
		'def_receivable' :  fields.many2one('account.account', 'Default Receivable Account', required=True, domain=[('type','=','receivable')]),
203
98
		'filters': fields.many2one('account.bankimport.filters', 'Filter', required=True),
204
99
		'bank_file' :  fields.char('File Location', size=128, required=True),
205
100
	}
206
101
res_company()
207
102
208
103
class account_bankimport(osv.osv):
209
104
    _name = "account.bankimport"
210
105
    _description = "import Bank statements-file for an Account"
211
106
    _columns = {
212
107
        'name': fields.char('Name', size=64),
213
108
        'file': fields.binary('bankimport file', readonly=True),
214
109
        'statement_id': fields.many2one('account.bank.statement','Generated Bank Statement', select=True,readonly=True),
215
110
        'note': fields.text('Import log', readonly=True),
216
111
        'journal_id': fields.many2one('account.journal','Bank Journal', readonly=True,select=True),
217
112
        'date': fields.date('Import Date', readonly=True,select=True),
218
113
        'user_id': fields.many2one('res.users','User', readonly=True, select=True),
219
114
    }
220
115
    _defaults = {
221
116
        'date': lambda *a: time.strftime('%Y-%m-%d'),
222
117
        'user_id': lambda self,cr,uid,context: uid,
223
118
    }
224
119
account_bankimport()
225
120
226
121
class account_bank_statement(osv.osv):
227
122
    _inherit = "account.bank.statement"
228
123
    _columns = {
229
124
        'bankimport_id':fields.many2one('account.bankimport','bankimport'),
230
125
        'state': fields.selection([('draft', 'Draft'),('draft_import', 'Draft Imported'),('confirm', 'Confirm')],
231
126
            'State', required=True,
232
127
            states={'confirm': [('readonly', True)]}, readonly="1"),
233
128
    }
234
129
    
235
130
    
236
131
account_bank_statement()
237
132
238
133
class bank_statement_line(osv.osv):
239
134
	_inherit = "account.bank.statement.line"
240
135
	_columns = {
241
136
		'bank_accnumber':fields.char('Bank account importfile', size=64, required=False),	
242
137
		'amount': fields.float('Amount', states={'draft_import': [('readonly', True)]} ),
243
138
		'ref': fields.char('Ref.', size=32, states={'draft_import': [('readonly', True)]} ),
244
139
		'name': fields.char('Name', size=64, required=True, states={'draft_import': [('readonly', True)]} ),
245
140
      'date': fields.date('Date', required=True, states={'draft_import': [('readonly', True)]} ),
246
141
		
247
142
            
248
143
	}
249
144
	
250
145
	def onchange_partner_id(self, cursor, user, line_id, partner_id, type, currency_id,
251
146
		context={}):
252
147
		if not partner_id:
253
148
			return {}
254
149
		res_currency_obj = self.pool.get('res.currency')
255
150
		res_users_obj = self.pool.get('res.users')
256
151
		
257
152
		company_currency_id = res_users_obj.browse(cursor, user, user,
258
153
			context=context).company_id.currency_id.id
259
154
			
260
155
		if not currency_id:
261
156
			currency_id = company_currency_id
262
157
		
263
158
		part = self.pool.get('res.partner').browse(cursor, user, partner_id,
264
159
			context=context)
265
160
		if part.supplier == 1 and part.customer == 0:
266
161
			account_id = part.property_account_payable.id
267
162
			type = 'supplier'
268
163
		elif part.supplier == 0 and part.customer == 1:
269
164
			account_id =  part.property_account_receivable.id
270
165
			type = 'customer'
271
166
		else:
272
167
			account_id = 0
273
168
			type = 'general'
274
169
				
275
170
		return {'value': {'type': type , 'account_id': account_id}}
276
171
277
172
278
173
	def write(self, cr, uid, ids, vals, context={}):
279
174
		acc_numbers = []
280
175
		
281
176
		if 'partner_id' in vals:
282
177
			db_data = self.pool.get('res.partner.bank').search(cr,uid, [('partner_id','=', vals['partner_id']) ] )
283
178
			acc_nums = self.pool.get('res.partner.bank').browse(cr,uid, db_data )
284
179
		
285
180
			import_acc = self.pool.get('account.bank.statement.line').browse(cr,uid, ids )
286
181
		
287
182
			for num in acc_nums:
288
183
				if num.acc_number:
289
184
					acc_numbers.append(num.acc_number)
290
185
				else:
291
186
					acc_numbers.append(num.iban)
292
187
		
293
188
			found_acc = False		
294
189
			for x in import_acc:
295
190
				if x.bank_accnumber in acc_numbers:
296
191
					found_acc = True
297
192
				
298
193
			if not found_acc:
299
194
				for x in import_acc:
300
195
					p = _get_bank_data(x.bank_accnumber)
301
196
				
302
197
					if p:
303
198
					# test if the bank exists
304
199
						bank_id = self.pool.get('res.bank').search(cr,uid,[('name','=',p['bank_name'])])
305
200
						if not bank_id:
306
201
							bank_id = pool.get('res.bank').create(cr,uid,{
307
202
									'name' : p['bank_name'],
308
203
									'bic' : p['bic'],
309
204
									'active' : 1,
310
205
								})
311
206
						else:
312
207
							bank_id = bank_id[0]
313
208
						
314
209
	
315
210
						bank_acc = self.pool.get('res.partner.bank').create(cr,uid,{
316
211
										'state' : 'bank',
317
212
										'partner_id': vals['partner_id'],
318
213
										'bank' : bank_id,
319
214
										'acc_number' : x.bank_accnumber,
320
215
								})
321
216
		
322
217
						bank_iban = self.pool.get('res.partner.bank').create(cr,uid,{
323
218
   	      						'state' : 'iban',
324
219
      	   						'partner_id': vals['partner_id'],
325
220
         							'bank' : bank_id,
326
221
         							'iban' : p['iban'],
327
222
         					})
328
223
         		
329
224
         			
330
225
					else:
331
226
						bank_acc = self.pool.get('res.partner.bank').create(cr,uid,{
332
227
       					  			'state' : 'bank',
333
228
         							'partner_id': vals['partner_id'],
334
229
          							'acc_number' : x.bank_accnumber,
335
230
         					})
336
231
337
232
    
338
233
     					
339
234
		return super(bank_statement_line, self).write(cr, uid, ids, vals, context)
340
235
341
236
	
342
237
343
238
bank_statement_line()
344
0
239
345
=== added file 'account_bankimport/bankimport_data.xml'
346
--- account_bankimport/bankimport_data.xml	1970-01-01 00:00:00 +0000
347
+++ account_bankimport/bankimport_data.xml	2010-03-04 01:53:21 +0000
348
@@ -0,0 +1,16 @@
349
1
<?xml version="1.0" encoding="utf-8"?>
350
2
<openerp>
351
3
<data>
352
4
353
5
	<record model="res.partner.bank" id="base.res_partner_agrolait">
354
6
		<field name="acc_number">301915554082</field>
355
7
		<field name="partner_id" ref="base.res_partner_agrolait"/>
356
8
	</record>
357
9
358
10
	<record model="res.partner.bank" id="base.res_partner_10">
359
11
		<field name="acc_number">050000000017</field>
360
12
		<field name="partner_id" ref="base.res_partner_10"/>
361
13
	</record>
362
14
363
15
</data>
364
16
</openerp>
365
0
17
366
=== added file 'account_bankimport/bankimport_demo.xml'
367
--- account_bankimport/bankimport_demo.xml	1970-01-01 00:00:00 +0000
368
+++ account_bankimport/bankimport_demo.xml	2010-03-04 01:53:21 +0000
369
@@ -0,0 +1,32 @@
370
1
<?xml version="1.0" encoding="utf-8"?>
371
2
<openerp>
372
3
<data noupdate="1">
373
4
	<record model="res.partner" id="partner_demo1">
374
5
		<field name="name">Tiny S.p.r.l</field>
375
6
	</record>
376
7
	<record model="res.partner.bank" id="partner_bank1">
377
8
		<field name="acc_number">301915554082</field>
378
9
		<field name="state">bank</field>
379
10
		<field name="partner_id" ref="partner_demo1"></field>
380
11
	</record>
381
12
382
13
	<record model="res.partner" id="partner_demo2">
383
14
		<field name="name">The-design Company</field>
384
15
	</record>
385
16
	<record model="res.partner.bank" id="partner_bank2">
386
17
     	<field name="acc_number">050000000017</field>
387
18
		<field name="state">iban</field>
388
19
		<field name="partner_id" ref="partner_demo2"></field>
389
20
	</record>
390
21
391
22
<!--	<record model="res.partner.bank" id="partner_agrolait">
392
23
		<field name="acc_number">301915554082</field>
393
24
		<field name="partner_id" ref="base.res_partner_agrolait"/>
394
25
	</record>
395
26
396
27
	<record model="res.partner.bank" id="res_partner_10">
397
28
		<field name="acc_number">050000000017</field>
398
29
		<field name="partner_id" ref="base.res_partner_10"/>
399
30
	</record>-->
400
31
</data>
401
32
</openerp>
402
0
33
403
=== added file 'account_bankimport/bankimport_view.xml'
404
--- account_bankimport/bankimport_view.xml	1970-01-01 00:00:00 +0000
405
+++ account_bankimport/bankimport_view.xml	2010-03-04 01:53:21 +0000
406
@@ -0,0 +1,119 @@
407
1
<?xml version="1.0" encoding="utf-8"?>
408
2
<openerp>
409
3
<data>
410
4
411
5
	<record model="ir.ui.view" id="view_company_for_bankimport">
412
6
		<field name="name">res.company.form</field>
413
7
		<field name="model">res.company</field>
414
8
		<field name="inherit_id" ref="base.view_company_form"/>
415
9
		<field name="type">form</field>
416
10
		<field name="arch" type="xml">
417
11
			<field name="currency_id" position="after">
418
12
				<separator string="Import Bank Statements" colspan="4"/>		
419
13
				<field name="bank_journalid" />
420
14
				<field name="def_payable" />
421
15
				<field name="def_receivable" />
422
16
				<field name="filters" />
423
17
				<field name="bank_file" />
424
18
			</field>
425
19
		</field>
426
20
	</record>
427
21
	
428
22
	<record model="ir.ui.view" id="view_account_bankimport_form">
429
23
		<field name="name">account.bankimport.form</field>
430
24
		<field name="model">account.bankimport</field>
431
25
		<field name="type">form</field>
432
26
		<field name="arch" type="xml">
433
27
			<form string="Import bank statements">
434
28
				<field name="name" />
435
29
				<field name="journal_id" />
436
30
				<field name="date" />
437
31
				<field name="user_id" />
438
32
				<field name="statement_id"/>
439
33
				<field name="file"/>
440
34
				<field name="note" colspan="4"/>
441
35
			</form>
442
36
		</field>
443
37
	</record>
444
38
445
39
446
40
	<record model="ir.ui.view" id="view_account_bankimport_tree">
447
41
		<field name="name">account.bankimport.tree</field>
448
42
		<field name="model">account.bankimport</field>
449
43
		<field name="type">tree</field>
450
44
		<field name="arch" type="xml">
451
45
			<tree string="Import bank statements">
452
46
				<field name="journal_id" />
453
47
				<field name="date" />
454
48
				<field name="user_id" />
455
49
			</tree>
456
50
		</field>
457
51
	</record>
458
52
459
53
	<record model="ir.actions.act_window" id="action_account_bankimport">
460
54
		<field name="name">Import bank statements</field>
461
55
		<field name="type">ir.actions.act_window</field>
462
56
		<field name="res_model">account.bankimport</field>
463
57
		<field name="view_type">form</field>
464
58
		<field name="view_mode">tree,form</field>
465
59
	</record>
466
60
467
61
	<menuitem name="Financial Management/Reporting/Bankimport Statements" id="menu_action_account_bankimport" action="action_account_bankimport" sequence="12" />
468
62
469
63
	<menuitem name="Financial Management/Periodical Processing/Import Bank Statements" action="wizard_account_bankimport" type="wizard"  id="menu_account_bankimport_wizard" sequence="15"/>
470
64
471
65
	<act_window name="Import Bank Statements"
472
66
		domain="[('statement_id', '=', active_id)]"
473
67
		res_model="account.bankimport"
474
68
		src_model="account.bank.statement"
475
69
		view_type="form"
476
70
		view_mode="tree,form"
477
71
 		id="act_account_payment_account_bank_statement"/>
478
72
479
73
480
74
<!-- View for adding / changing filters -->
481
75
482
76
483
77
484
78
	<record model="ir.ui.view" id="view_account_bankimport_filters_form">
485
79
		<field name="name">account.bankimport.filters.form</field>
486
80
		<field name="model">account.bankimport.filters</field>
487
81
		<field name="type">form</field>
488
82
		<field name="arch" type="xml">
489
83
			<form string="Define import filters">
490
84
				<field name="filter" />
491
85
				<field name="name" />
492
86
			</form>
493
87
		</field>
494
88
	</record>
495
89
496
90
497
91
	<record model="ir.ui.view" id="view_account_bankimport_filters_tree">
498
92
		<field name="name">account.bankimport.filters.tree</field>
499
93
		<field name="model">account.bankimport.filters</field>
500
94
		<field name="type">tree</field>
501
95
		<field name="arch" type="xml">
502
96
			<tree string="Import filters">
503
97
				<field name="filter" />
504
98
				<field name="name" />
505
99
			</tree>
506
100
		</field>
507
101
	</record>
508
102
	
509
103
	<record model="ir.actions.act_window" id="action_account_bankimport_filters_tree">
510
104
		<field name="name">Define bankimport filters</field>
511
105
		<field name="res_model">account.bankimport.filters</field>
512
106
		<field name="view_type">form</field>
513
107
		<field name="view_mode">tree,form</field>
514
108
	</record>
515
109
<!--
516
110
	<menuitem name="Financial Management/Reporting/Bankimport Statements" id="menu_account_bankimport" action="action_bank_statement_tree" sequence="12"/>
517
111
-->
518
112
	<menuitem action="action_account_bankimport_filters_tree" id="menu_action_account_bankimport_filters_tree" parent="base.menu_users"/>
519
113
520
114
521
115
<!-- **** END ***** --> 
522
116
	
523
117
		
524
118
	</data>
525
119
</openerp>
526
0
120
527
=== added file 'account_bankimport/bankimport_wizard.xml'
528
--- account_bankimport/bankimport_wizard.xml	1970-01-01 00:00:00 +0000
529
+++ account_bankimport/bankimport_wizard.xml	2010-03-04 01:53:21 +0000
530
@@ -0,0 +1,13 @@
531
1
<?xml version="1.0" encoding="utf-8"?>
532
2
<openerp>
533
3
	<data>
534
4
535
5
		<wizard
536
6
		string="Import Bank statements file"
537
7
		model="account.bank.statement"
538
8
		name="account.bank_import"
539
9
		id="wizard_account_bankimport"
540
10
		/>
541
11
		
542
12
	</data>
543
13
</openerp>
544
0
14
545
=== added directory 'account_bankimport/security'
546
=== added file 'account_bankimport/security/ir.model.access.csv'
547
--- account_bankimport/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
548
+++ account_bankimport/security/ir.model.access.csv	2010-03-04 01:53:21 +0000
549
@@ -0,0 +1,3 @@
550
1
"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
551
2
"access_account_bankimport","account.bankimport","model_account_bankimport","account.group_account_manager",1,1,1,1
552
3
"access_account_bankimport_filters","account.bankimport.filters","model_account_bankimport_filters","account.group_account_manager",1,1,1,1
553
0
4
554
=== added file 'account_bankimport/usage_of_account_bankimport.pdf'
555
1
Binary files account_bankimport/usage_of_account_bankimport.pdf	1970-01-01 00:00:00 +0000 and account_bankimport/usage_of_account_bankimport.pdf	2010-03-04 01:53:21 +0000 differ
5
Binary files account_bankimport/usage_of_account_bankimport.pdf	1970-01-01 00:00:00 +0000 and account_bankimport/usage_of_account_bankimport.pdf	2010-03-04 01:53:21 +0000 differ
556
=== added directory 'account_bankimport/wizard'
557
=== added file 'account_bankimport/wizard/__init__.py'
558
--- account_bankimport/wizard/__init__.py	1970-01-01 00:00:00 +0000
559
+++ account_bankimport/wizard/__init__.py	2010-03-04 01:53:21 +0000
560
@@ -0,0 +1,35 @@
561
1
##############################################################################
562
2
#
563
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
564
4
#                          All Rights Reserved.
565
5
#                    Fabien Pinckaers <fp@tiny.Be>
566
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
567
7
#
568
8
# WARNING: This program as such is intended to be used by professional
569
9
# programmers who take the whole responsability of assessing all potential
570
10
# consequences resulting from its eventual inadequacies and bugs
571
11
# End users who are looking for a ready-to-use solution with commercial
572
12
# garantees and support are strongly adviced to contract a Free Software
573
13
# Service Company
574
14
#
575
15
# This program is Free Software; you can redistribute it and/or
576
16
# modify it under the terms of the GNU General Public License
577
17
# as published by the Free Software Foundation; either version 2
578
18
# of the License, or (at your option) any later version.
579
19
#
580
20
# This program is distributed in the hope that it will be useful,
581
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
582
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
583
23
# GNU General Public License for more details.
584
24
#
585
25
# You should have received a copy of the GNU General Public License
586
26
# along with this program; if not, write to the Free Software
587
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
588
28
#
589
29
##############################################################################
590
30
# I used the code of account_coda as base for this module. The module does
591
31
# exactly the same thing as account_coda. The difference is the file-layout. 
592
32
#
593
33
# This module can import .asc-files (BRI-layout).
594
34
#
595
35
import bank_import
596
0
36
597
=== added file 'account_bankimport/wizard/bank_import.py'
598
--- account_bankimport/wizard/bank_import.py	1970-01-01 00:00:00 +0000
599
+++ account_bankimport/wizard/bank_import.py	2010-03-04 01:53:21 +0000
600
@@ -0,0 +1,333 @@
601
1
##############################################################################
602
2
#
603
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
604
4
#                          All Rights Reserved.
605
5
#                    Fabien Pinckaers <fp@tiny.Be>
606
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
607
7
#
608
8
# WARNING: This program as such is intended to be used by professional
609
9
# programmers who take the whole responsability of assessing all potential
610
10
# consequences resulting from its eventual inadequacies and bugs
611
11
# End users who are looking for a ready-to-use solution with commercial
612
12
# garantees and support are strongly adviced to contract a Free Software
613
13
# Service Company
614
14
#
615
15
# This program is Free Software; you can redistribute it and/or
616
16
# modify it under the terms of the GNU General Public License
617
17
# as published by the Free Software Foundation; either version 2
618
18
# of the License, or (at your option) any later version.
619
19
#
620
20
# This program is distributed in the hope that it will be useful,
621
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
622
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
623
23
# GNU General Public License for more details.
624
24
#
625
25
# You should have received a copy of the GNU General Public License
626
26
# along with this program; if not, write to the Free Software
627
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
628
28
#
629
29
##############################################################################
630
30
# I used the code of account_coda as base for this module. The module does
631
31
# exactly the same thing as account_coda. The difference is the file-layout. 
632
32
#
633
33
# This module can import .asc-files (BRI-layout).
634
34
#
635
35
import pooler
636
36
import time
637
37
import datetime
638
38
import wizard
639
39
import netsvc
640
40
import base64
641
41
from osv import fields, osv
642
42
643
43
result_form = """<?xml version="1.0"?>
644
44
<form string="Import ASC Statement">
645
45
<separator colspan="4" string="Results :" />
646
46
    <field name="note" colspan="4" nolabel="1" width="500"/>
647
47
</form>
648
48
"""
649
49
650
50
result_fields = {
651
51
652
52
    'note' : {'string':'Log','type':'text'}
653
53
654
54
}
655
55
656
56
def _bank_import(self, cr, uid, data, context):
657
57
    
658
58
    pool = pooler.get_pool(cr.dbname)
659
59
660
60
    # setting variables 
661
61
    line_name = 0
662
62
    str_log = ""
663
63
    err_log = ""
664
64
    str_log1 = ""
665
65
    st_line_name = line_name
666
66
    
667
67
    bank_statement={}
668
68
    bank_statement_lines={}
669
69
    bank_statements=[]
670
70
671
71
    ########################	 
672
72
	 # building the header. #
673
73
    ######################## 	 
674
74
    # First we get the company_id from the user.
675
75
    user_data = pool.get('res.users').browse(cr, uid, uid, context)
676
76
    
677
77
	 # No we get the company data (journals and the file to read)
678
78
    company_data = pool.get('res.company').browse(cr, uid, user_data.company_id.id, context)
679
79
680
80
    # create the base
681
81
    bankfile = company_data.bank_file
682
82
    def_pay_acc = company_data.def_payable.id
683
83
    def_rec_acc = company_data.def_receivable.id
684
84
    
685
85
    # get todays date and get the period. The todays date will also be used for the Date-field  
686
86
    today_date = datetime.date.today()
687
87
    periodDate = today_date.strftime('%Y-%m-%d')
688
88
    period_id = pool.get('account.period').search(cr,uid,[('date_start','<=',periodDate),('date_stop','>=',periodDate)])
689
89
    
690
90
    # getting the start data of the balance. We need this from the database
691
91
    # get the latest bank statement from the database (highest id
692
92
    cr.execute('select max(id) from account_bank_statement',)
693
93
    bal_id = cr.fetchone()[0]
694
94
    bal_prev = pool.get('account.bank.statement').browse(cr,uid,bal_id,context)
695
95
    
696
96
    if not bal_prev:
697
97
       # switch to 0	    
698
98
       bal_start = 0
699
99
    else :
700
100
       # use the balance_end_real as the start_balance for the new statement
701
101
       bal_start = bal_prev.balance_end_real    
702
102
    
703
103
    # fill the bankstatement
704
104
    bank_statement["bank_statement_line"]={}
705
105
    bank_statement['date'] = today_date.strftime('%d/%m/%Y')
706
106
    bank_statement['journal_id']=company_data.bank_journalid.id
707
107
    bank_statement['period_id'] = period_id[0]
708
108
    bank_statement['def_pay_acc'] = def_pay_acc
709
109
    bank_statement['def_rec_acc'] = def_rec_acc
710
110
    bank_statement['state']='draft'
711
111
    bank_statement["balance_start"]= bal_start
712
112
    # Because the company is linked to a Partner, we can get also the
713
113
    # acc_number. We can even use it to verify if the right bankstatements
714
114
    # were be imported (acc_numbers should be equal).
715
115
    acc_number_id = pool.get('res.partner.bank').search(cr, uid, [('partner_id','=',company_data.partner_id.id)])
716
116
    
717
117
    # check if we got a bank / iban number
718
118
    if len(acc_number_id) > 0:
719
119
       bank_statement["acc_number"] = []    
720
120
       # create a list of numbers 
721
121
       for acc in acc_number_id:
722
122
          acc_number = pool.get('res.partner.bank').browse(cr,uid,acc)
723
123
         
724
124
          if acc_number.acc_number :
725
125
          	bank_statement["acc_number"].append(acc_number.acc_number.lower())
726
126
          else :
727
127
          	bank_statement["acc_number"].append(acc_number.iban.lower())
728
128
          
729
129
    else :
730
130
    	raise wizard.except_wizard('ERROR !', 'We got no bank / iban number.')
731
131
    #   str_log1 = "We got no bank / iban number!"
732
132
    #   return {'note':str_log1 ,'journal_id':0 , 'asc':0,'statment_id':0}
733
133
734
134
    # We use the company name and not the partner name
735
135
    bank_statement["acc_holder"] =  company_data.name  
736
136
737
137
	 # setting the end value of the balance
738
138
    bal_end = bal_start
739
139
    
740
140
    bank_statement['bal_start'] = bal_start
741
141
    bank_statement['bal_end'] = bal_end
742
142
    
743
143
    # based on the filter we parse the document
744
144
    filterObject = 'account.bankimport.filter.' + str(company_data.filters)
745
145
    
746
146
    bank_data = pooler.get_pool(cr.dbname).get( filterObject )
747
147
    
748
148
    exec "from filters import " + company_data.filters.name + " as parser"
749
149
    #__import__( company_data.filters.name )
750
150
751
151
752
152
    # opening the file speficied as bank_file and read the data
753
153
    try:
754
154
      bf = open(bankfile, 'r')
755
155
    	
756
156
      try:
757
157
         mydata = bf.read()
758
158
         recordlist = mydata.split('\n') # bf.readlines()
759
159
         recordlist.pop()
760
160
         data = parser.get_data(self,cr,uid,recordlist,bank_statement) # parse the data through the filter
761
161
      finally:
762
162
         bf.close()
763
163
    except IOError:
764
164
       raise
765
165
          
766
166
767
167
    bank_statements.append(bank_statement)
768
168
    bkst_list=[]
769
169
    bk_st_id=0
770
170
771
171
    nb_err=0
772
172
    err_log=''
773
173
    str_log=''
774
174
    std_log=''
775
175
    str_log1 = str_log1 + "  Bank Statements were Imported  :  "
776
176
    str_not=''
777
177
    str_not1=''
778
178
    
779
179
    period = []
780
180
    
781
181
   
782
182
    # check if we have new bank statement lines.
783
183
    if len(data) >= 1:
784
184
    	p_bank_state = []
785
185
    	p_state_line = {}
786
186
    	
787
187
    	# move each line to the right period
788
188
    	for line in data:    		
789
189
    		periodDate = time.strftime('%Y-%m-%d', time.strptime(line['date'], '%d/%m/%y') )
790
190
    			
791
191
    		# get the period
792
192
    		periodD = pool.get('account.period').search(cr,uid,[('date_start','<=',periodDate),('date_stop','>=',periodDate)])[0]
793
193
    		
794
194
    		# check if the period already exists in the dictonairy
795
195
    		if periodD in p_state_line:
796
196
    			w = p_state_line[periodD] # fill the array with existing data
797
197
    		else:
798
198
    			w = []
799
199
    			
800
200
    		w.append(line)
801
201
    		p_state_line[periodD] = w
802
202
    		if periodD not in period:
803
203
    			period.append(periodD)
804
204
805
205
		# sort the periods
806
206
		period.sort()
807
207
		
808
208
		# set the start balance
809
209
		bal_start = float(bank_statement['balance_start'])
810
210
		
811
211
		# we have now a dictionary of statement lines based on the period, so we can create the bankstatements now    			
812
212
    	for li in period:
813
213
    		lines = p_state_line[li]    		
814
214
    		total = 0.0
815
215
    		
816
216
    		# calculate the ending balance
817
217
    		for lin in lines:
818
218
    			total += float(lin['amount'])
819
219
    		bal_end += total
820
220
    		
821
221
    		try:
822
222
    			bk_st_id = pool.get('account.bank.statement').create(cr,uid,{
823
223
    							'journal_id': bank_statement['journal_id'],
824
224
    							'date':today_date.strftime('%Y-%m-%d'),
825
225
    							'period_id':li,
826
226
    							'balance_start': bal_start,
827
227
    							'balance_end_real': bal_end,
828
228
    							'state':'draft',
829
229
    						})
830
230
    						
831
231
    			for line in lines:
832
232
    				str_not1="Partner name : %s\nPartner Account Number : %s\nCommunication : %s\nValue Date : %s\nEntry Date : %s\n" %(line["contry_name"],line["cntry_number"],line["free_comm"],line["val_date"],line["entry_date"][0])
833
233
    				
834
234
    				id=pool.get('account.bank.statement.line').create(cr,uid,{
835
235
    							'name':line['name'],
836
236
    							'date': time.strftime('%Y-%m-%d', time.strptime(line['date'], '%d/%m/%y') ),
837
237
    							'amount': line['amount'],
838
238
    							'partner_id':line['partner_id'] or 0,
839
239
    							'account_id':line['account_id'],
840
240
    							'statement_id': bk_st_id,
841
241
    							'note':str_not1,
842
242
    							'ref':line['ref'],
843
243
    							'bank_accnumber':line['partner_acc_number'],
844
244
    							'type':line['type'],
845
245
    						})
846
246
    			cr.commit()
847
247
    			
848
248
    			str_not= "\n \n Account Number: %s \n Account Holder Name: %s " %(bank_statement["acc_number"],bank_statement["acc_holder"])
849
249
    			std_log = std_log + "\nDate  : %s, Starting Balance :  %.2f , Ending Balance : %.2f "\
850
250
    					%(bank_statement['date'], bal_start, bal_end)
851
251
    			bkst_list.append(bk_st_id)
852
252
853
253
    			# move ending balance to the start balance   			
854
254
    			bal_start = bal_end
855
255
	
856
256
    		except osv.except_osv, e:
857
257
    			cr.rollback()
858
258
859
259
    		except osv.except_osv, e:
860
260
    			cr.rollback()
861
261
    			nb_err+=1
862
262
    			err_log= err_log +'\n Application Error : ' + str(e)
863
263
    			raise # REMOVEME
864
264
    		
865
265
    		except Exception, e:
866
266
    			cr.rollback()
867
267
    			nb_err+=1
868
268
    			err_log= err_log +'\n System Error : '+str(e)
869
269
    			raise # REMOVEME
870
270
    			
871
271
    		except :
872
272
    			cr.rollback()
873
273
    			nb_err+=1
874
274
    			err_log= err_log +'\n Unknown Error'
875
275
    			raise
876
276
    	err_log= err_log + '\n\nNumbers of statements : '+ str(len([bkst_list]))     
877
277
    	err_log= err_log + '\nNumber of error :'+ str(nb_err) +'\n'
878
278
879
279
    	   	
880
280
    	pool.get('account.bankimport').create(cr, uid,{
881
281
    		'file': base64.encodestring(mydata),
882
282
    		'statement_id':bk_st_id,
883
283
    		'note':str(str_log1) + str(str_not) + str(std_log+err_log),
884
284
    		'journal_id':company_data.bank_journalid.id,
885
285
    		'date':time.strftime("%Y-%m-%d"),
886
286
    		'user_id':uid,
887
287
    	})
888
288
    else:
889
289
       raise wizard.except_wizard('WARNING !', 'No new records found, nothing imported.')
890
290
	 # close the file
891
291
    bf.close()
892
292
#    return {}	 
893
293
     
894
294
    return {'note':str_log1 + std_log + err_log ,'journal_id': company_data.bank_journalid.id, 'asc': company_data.bank_file,'statment_id':bkst_list}
895
295
896
296
    
897
297
class bank_import(wizard.interface):
898
298
    def _action_open_window(self, cr, uid, data, context):
899
299
        form=data['form']
900
300
        return {
901
301
            'domain':"[('id','in',(%s,))]"%(",".join(map(str,form['statment_id']))),
902
302
            'name': 'Statement',
903
303
            'view_type': 'form',
904
304
            'view_mode': 'form,tree',
905
305
            'res_model': 'account.bank.statement',
906
306
            'view_id': False,
907
307
            'type': 'ir.actions.act_window',
908
308
            'res_id':form['statment_id'],
909
309
        }
910
310
    states = {
911
311
         'init' : {
912
312
            'actions' : [_bank_import],
913
313
            'result' : {'type' : 'form',
914
314
                    'arch' : result_form,
915
315
                    'fields' : result_fields,
916
316
                    'state' : [('end', '_Close', 'gtk-close'),('open', '_Open Statement','gtk-ok')]}
917
317
         },
918
318
         
919
319
         'extraction' : {
920
320
            'actions' : [_bank_import],
921
321
            'result' : {'type' : 'form',
922
322
                    'arch' : result_form,
923
323
                    'fields' : result_fields,
924
324
                    'state' : [('end', '_Close', 'gtk-close'),('open', '_Open Statement','gtk-ok')]}
925
325
        },
926
326
        'open': {
927
327
            'actions': [],
928
328
            'result': {'type': 'action', 'action': _action_open_window, 'state': 'end'}
929
329
930
330
            },
931
331
932
332
    }
933
333
bank_import("account.bank_import")
934
0
334
935
=== added directory 'account_bankimport/wizard/filters'
936
=== added file 'account_bankimport/wizard/filters/__init__.py'
937
--- account_bankimport/wizard/filters/__init__.py	1970-01-01 00:00:00 +0000
938
+++ account_bankimport/wizard/filters/__init__.py	2010-03-04 01:53:21 +0000
939
@@ -0,0 +1,36 @@
940
1
##############################################################################
941
2
#
942
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
943
4
#                          All Rights Reserved.
944
5
#                    Fabien Pinckaers <fp@tiny.Be>
945
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
946
7
#
947
8
# WARNING: This program as such is intended to be used by professional
948
9
# programmers who take the whole responsability of assessing all potential
949
10
# consequences resulting from its eventual inadequacies and bugs
950
11
# End users who are looking for a ready-to-use solution with commercial
951
12
# garantees and support are strongly adviced to contract a Free Software
952
13
# Service Company
953
14
#
954
15
# This program is Free Software; you can redistribute it and/or
955
16
# modify it under the terms of the GNU General Public License
956
17
# as published by the Free Software Foundation; either version 2
957
18
# of the License, or (at your option) any later version.
958
19
#
959
20
# This program is distributed in the hope that it will be useful,
960
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
961
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
962
23
# GNU General Public License for more details.
963
24
#
964
25
# You should have received a copy of the GNU General Public License
965
26
# along with this program; if not, write to the Free Software
966
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
967
28
#
968
29
##############################################################################
969
30
# I used the code of account_coda as base for this module. The module does
970
31
# exactly the same thing as account_coda. The difference is the file-layout. 
971
32
#
972
33
# This module can import .asc-files (BRI-layout).
973
34
#
974
35
975
36
#import 
976
0
\ No newline at end of file
37
\ No newline at end of file
977
1
38
978
=== added file 'account_bankimport/wizard/filters/asc.py'
979
--- account_bankimport/wizard/filters/asc.py	1970-01-01 00:00:00 +0000
980
+++ account_bankimport/wizard/filters/asc.py	2010-03-04 01:53:21 +0000
981
@@ -0,0 +1,186 @@
982
1
##############################################################################
983
2
#
984
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
985
4
#                          All Rights Reserved.
986
5
#                    Fabien Pinckaers <fp@tiny.Be>
987
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
988
7
#
989
8
# WARNING: This program as such is intended to be used by professional
990
9
# programmers who take the whole responsability of assessing all potential
991
10
# consequences resulting from its eventual inadequacies and bugs
992
11
# End users who are looking for a ready-to-use solution with commercial
993
12
# garantees and support are strongly adviced to contract a Free Software
994
13
# Service Company
995
14
#
996
15
# This program is Free Software; you can redistribute it and/or
997
16
# modify it under the terms of the GNU General Public License
998
17
# as published by the Free Software Foundation; either version 2
999
18
# of the License, or (at your option) any later version.
1000
19
#
1001
20
# This program is distributed in the hope that it will be useful,
1002
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
1003
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1004
23
# GNU General Public License for more details.
1005
24
#
1006
25
# You should have received a copy of the GNU General Public License
1007
26
# along with this program; if not, write to the Free Software
1008
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
1009
28
#
1010
29
##############################################################################
1011
30
# I used the code of account_coda as base for this module. The module does
1012
31
# exactly the same thing as account_coda. The difference is the file-layout. 
1013
32
#
1014
33
# This filter imports .asc-files (BRI-layout).
1015
34
#
1016
35
1017
36
from osv import fields, osv
1018
37
import time
1019
38
import pooler
1020
39
import conversion
1021
40
import string
1022
41
1023
42
def get_data(self, cr, uid, bankData, bank_statement):
1024
43
	   
1025
44
      pool = pooler.get_pool(cr.dbname)
1026
45
      
1027
46
      bal_end = bank_statement['bal_end']
1028
47
      bank_statement_lines={}
1029
48
      bank_statements=[]
1030
49
      line_name = 0
1031
50
      st_line_name = line_name
1032
51
      code4 = 0
1033
52
      
1034
53
      # parse every line in the file and get the right data
1035
54
      for line in bankData:
1036
55
         if len(line) <= 23:  # the end of the file has an empty line
1037
56
            pass
1038
57
         else:
1039
58
            # check if bankaccount in the file matches with the bankaccount of the database
1040
59
            bankaccount = line[0:10]
1041
60
            # Look if we can match our number with a number in the list
1042
61
            if bankaccount.lower() in bank_statement["acc_number"]:
1043
62
               # look for the recordtype
1044
63
               # 2 is the baserecord. We can also have 3 and 4. These are followrecords.
1045
64
               if line[23] == '2' and code4 == 0:
1046
65
                  st_line_name = line_name
1047
66
                  st_line = {}
1048
67
                  st_line['statement_id']=0
1049
68
                  st_line['name'] = line[48:72]
1050
69
                  st_line['date'] = conversion.str2date(line[87:93]) # boekingsdatum
1051
70
                  st_line_amt = conversion.list2float(line[73:86])
1052
71
                  
1053
72
                  if line[86] == "D": 
1054
73
                     st_line_amt = - st_line_amt
1055
74
                     st_line['account_id'] = bank_statement['def_pay_acc']
1056
75
                  else:
1057
76
                     st_line['account_id'] = bank_statement['def_rec_acc']
1058
77
                    
1059
78
                  st_line['entry_date']=time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(line[87:93]),"%d/%m/%y")),
1060
79
                  st_line['val_date']=time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(line[93:99]),"%d/%m/%y")),
1061
80
                              
1062
81
                  st_line['partner_id']=0
1063
82
                  st_line['amount'] = st_line_amt
1064
83
                  st_line['type'] = 'general'
1065
84
                 
1066
85
                  st_line_partner_acc = str(line[38:48]).strip()
1067
86
                  if st_line_partner_acc[:1] == '0':
1068
87
                  	st_line_partner_acc = st_line_partner_acc[1::]
1069
88
                  	
1070
89
                  st_line['partner_acc_number'] = st_line_partner_acc 
1071
90
                  	 	  
1072
91
                  cntry_number=st_line_partner_acc
1073
92
                  contry_name=line[48:72]
1074
93
                  bank_ids = pool.get('res.partner.bank').search(cr,uid,[('acc_number','=',st_line_partner_acc)])
1075
94
                  
1076
95
                  if bank_ids:
1077
96
                     bank = pool.get('res.partner.bank').browse(cr,uid,bank_ids[0],context={})
1078
97
                     st_line['cntry_number']=cntry_number
1079
98
                     st_line['contry_name']=contry_name
1080
99
      
1081
100
                     if st_line and bank.partner_id:
1082
101
                        st_line['partner_id']=bank.partner_id.id
1083
102
                        
1084
103
                        # Create a check if we don't already imported this statement
1085
104
                        # We make an unique check in the database with
1086
105
                        # partner, date and amount
1087
106
                        check_ids = pool.get('account.bank.statement.line').search(cr,uid,[('amount','=',st_line_amt), ('date','=',st_line['entry_date']),('partner_id','=',bank.partner_id.id)])
1088
107
                                         
1089
108
                                
1090
109
                        # check if the partner is a supplier or customer
1091
110
                        # if both, we don't add a account due to credit invoices		
1092
111
                        partner = pool.get('res.partner').browse(cr,uid,bank.partner_id,context={})
1093
112
                        
1094
113
                        st_line['type']='general'
1095
114
                        
1096
115
                        if bank.partner_id.supplier == True and bank.partner_id.customer == False:
1097
116
                        	st_line['account_id']= bank.partner_id.property_account_receivable.id
1098
117
                        	st_line['type']='supplier'
1099
118
1100
119
                        elif bank.partner_id.customer == True and bank.partner_id.supplier == False :
1101
120
                        	st_line['account_id']= bank.partner_id.property_account_payable.id
1102
121
                        	st_line['type']='customer'
1103
122
1104
123
                        #if st_line['amount'] < 0 :
1105
124
                        #   st_line['account_id']= bank.partner_id.property_account_payable.id
1106
125
                        #else :
1107
126
                        #   st_line['account_id']= bank.partner_id.property_account_receivable.id
1108
127
   
1109
128
                  else:
1110
129
                     st_line['cntry_number']=cntry_number
1111
130
                     st_line['contry_name']=contry_name
1112
131
                     
1113
132
                     # Create a check if we don't already imported this statement
1114
133
                     # We make an unique check in the database with
1115
134
                     # name, date and amount
1116
135
                     check_ids = pool.get('account.bank.statement.line').search(cr,uid,[('amount','=',st_line_amt), ('date','=',st_line['entry_date']), ('name','=',contry_name)])               
1117
136
                 
1118
137
                  st_line['free_comm']= ''
1119
138
                  st_line['ref']=''
1120
139
                
1121
140
               elif line[23] == '3' and code4 == 0 :      # get some information about the transaction
1122
141
                  st_line['free_comm']=line[56:119]
1123
142
                  refe = line[56:119].split(' ')
1124
143
                  stri = ''
1125
144
                  for t in refe:
1126
145
                  	if t.strip():
1127
146
                        	stri = stri + ' ' + ''.join(t.strip())
1128
147
                  
1129
148
                  st_line['ref']=stri
1130
149
                  code4 = int(line[120])
1131
150
                  if not check_ids:
1132
151
                     line_name += 1
1133
152
                     st_line_name = line_name      
1134
153
                     
1135
154
               elif line[23] == '4':      # get some more information about the transaction
1136
155
                  st_line['free_comm'] = st_line['free_comm'] + "\n" + line[24:119]
1137
156
                  code4 = code4 - 1
1138
157
               
1139
158
               if not check_ids:   
1140
159
                 bank_statement_lines[line_name]=st_line
1141
160
               #  bank_statements.append(st_line)    
1142
161
         
1143
162
1144
163
           # end if
1145
164
      # end for
1146
165
      
1147
166
      
1148
167
      
1149
168
      # delete latest row from the list because its an empty row
1150
169
      if len(bank_statement_lines) >= 1:
1151
170
         del bank_statement_lines[ line_name ]  # delete latest row from the list
1152
171
         for test in bank_statement_lines:
1153
172
            bank_statements.append(bank_statement_lines[test])
1154
173
         
1155
174
      # count the end balance
1156
175
#      for value in bank_statement_lines:
1157
176
#         line=bank_statement_lines[value]
1158
177
#         bal_end += line['amount']
1159
178
1160
179
#      bank_statement["balance_end_real"]= bal_end
1161
180
#      bank_statement["bank_statement_line"]=bank_statement_lines
1162
181
     
1163
182
      return bank_statements
1164
183
                
1165
184
            
1166
185
    #end for         
1167
186
#select distinct b.partner_id, p.ref from res_partner_bank b, res_partner p where b.bank='51' and b.partner_id = p.id
1168
0
187
1169
=== added file 'account_bankimport/wizard/filters/coda.py'
1170
--- account_bankimport/wizard/filters/coda.py	1970-01-01 00:00:00 +0000
1171
+++ account_bankimport/wizard/filters/coda.py	2010-03-04 01:53:21 +0000
1172
@@ -0,0 +1,150 @@
1173
1
##############################################################################
1174
2
#
1175
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Eddy Boer
1176
4
#                          All Rights Reserved.
1177
5
#                    Fabien Pinckaers <fp@tiny.Be>
1178
6
#                    Eddy Boer <tinyerp@EdbO.xs4all.nl>
1179
7
#
1180
8
# WARNING: This program as such is intended to be used by professional
1181
9
# programmers who take the whole responsability of assessing all potential
1182
10
# consequences resulting from its eventual inadequacies and bugs
1183
11
# End users who are looking for a ready-to-use solution with commercial
1184
12
# garantees and support are strongly adviced to contract a Free Software
1185
13
# Service Company
1186
14
#
1187
15
# This program is Free Software; you can redistribute it and/or
1188
16
# modify it under the terms of the GNU General Public License
1189
17
# as published by the Free Software Foundation; either version 2
1190
18
# of the License, or (at your option) any later version.
1191
19
#
1192
20
# This program is distributed in the hope that it will be useful,
1193
21
# but WITHOUT ANY WARRANTY; without even the implied warranty of
1194
22
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1195
23
# GNU General Public License for more details.
1196
24
#
1197
25
# You should have received a copy of the GNU General Public License
1198
26
# along with this program; if not, write to the Free Software
1199
27
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
1200
28
#
1201
29
##############################################################################
1202
30
# I used the code of account_coda as base for this module. The module does
1203
31
# exactly the same thing as account_coda. The difference is the file-layout. 
1204
32
#
1205
33
# This filter imports .coda-files (CODA-layout).
1206
34
#
1207
35
1208
36
1209
37
from osv import fields, osv
1210
38
import time
1211
39
import pooler
1212
40
import conversion
1213
41
1214
42
1215
43
def get_data(self, cr, uid, bankData, bank_statement):
1216
44
      pool = pooler.get_pool(cr.dbname)
1217
45
   
1218
46
      bal_end = bank_statement['bal_end']
1219
47
      bank_statement_lines={}
1220
48
      bank_statements=[]
1221
49
      line_name = 0
1222
50
      str_log = ""
1223
51
      err_log = ""
1224
52
      str_log1 = ""
1225
53
      st_line_name = line_name
1226
54
    
1227
55
      # parse every line in the file and get the right data
1228
56
      for line in bankData:
1229
57
        if line[0] == '0':
1230
58
            # header data
1231
59
#            bank_statement={}
1232
60
#            bank_statement_lines={}
1233
61
            bank_statement["bank_statement_line"]={}
1234
62
            #bank_statement['date'] = conversion.str2date(line[5:11])
1235
63
            #period_id = pool.get('account.period').search(cr,uid,[('date_start','<=',time.strftime("%y/%m/%d",time.strptime(bank_statement['date'],"%d/%m/%y"))),('date_stop','>=',time.strftime("%y/%m/%d",time.strptime(bank_statement['date'],"%d/%m/%y")))])
1236
64
            #period_id = pool.get('account.period').search(cr,uid,[('date_start','<=',time.strftime('%Y-%m-%d',time.strptime(bank_statement['date'],"%y/%m/%d"))),('date_stop','>=',time.strftime('%Y-%m-%d',time.strptime(bank_statement['date'],"%y/%m/%d")))])
1237
65
            #bank_statement['period_id'] = period_id[0]
1238
66
            #bank_statement['state']='draft'
1239
67
        elif line[0] == '1':
1240
68
            # old balance data
1241
69
            bal_start = conversion.list2float(line[43:58])
1242
70
            if line[42] == '1':
1243
71
                bal_start = - bal_start
1244
72
            bank_statement["balance_start"]= bal_start
1245
73
            bank_statement["acc_number"]=line[5:17]
1246
74
            bank_statement["acc_holder"]=line[64:90]
1247
75
1248
76
        elif line[0]=='2':
1249
77
            # movement data record 2
1250
78
            if line[1]=='1':
1251
79
                # movement data record 2.1
1252
80
                st_line = {}
1253
81
                st_line['statement_id']=0
1254
82
                st_line['name'] = line[2:10]
1255
83
                st_line['date'] = conversion.str2date(line[115:121])
1256
84
                st_line_amt = conversion.list2float(line[32:47])
1257
85
1258
86
                if line[61]=='1':
1259
87
                    st_line['ref']=(line[65:77])
1260
88
                    st_line['free_comm']=''
1261
89
                else:
1262
90
                    st_line['free_comm']=line[62:115]
1263
91
                    st_line['ref']=''
1264
92
1265
93
                st_line['val_date']=time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(line[47:53]),"%y/%m/%d")),
1266
94
                st_line['entry_date']=time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(line[115:121]),"%y/%m/%d")),
1267
95
                st_line['partner_id']=0
1268
96
                if line[31] == '1':
1269
97
                    st_line_amt = - st_line_amt
1270
98
                    st_line['account_id'] = bank_statement['def_pay_acc']
1271
99
                else:
1272
100
                    st_line['account_id'] = bank_statement['def_rec_acc']
1273
101
                st_line['amount'] = st_line_amt
1274
102
                bank_statement_lines[st_line['name']]=st_line
1275
103
                bank_statement["bank_statement_line"]=bank_statement_lines
1276
104
1277
105
            elif line[1] == '3':
1278
106
                # movement data record 3.1
1279
107
                st_line_name = line[2:10]
1280
108
                st_line_partner_acc = str(line[10:47]).strip()
1281
109
                cntry_number=line[10:47]
1282
110
                contry_name=line[47:125]
1283
111
                #bank_ids = pool.get('res.partner.bank').search(cr,uid,[('number','=',st_line_partner_acc)])
1284
112
                bank_ids = pool.get('res.partner.bank').search(cr,uid,[('acc_number','=',st_line_partner_acc)])
1285
113
                if bank_ids:
1286
114
                    bank = pool.get('res.partner.bank').browse(cr,uid,bank_ids[0],context={})
1287
115
                    line=bank_statement_lines[st_line_name]
1288
116
                    line['cntry_number']=cntry_number
1289
117
                    line['contry_name']=contry_name
1290
118
1291
119
                    if line and bank.partner_id:
1292
120
                        line['partner_id']=bank.partner_id.id
1293
121
                        if line['amount'] < 0 :
1294
122
                            line['account_id']=bank.partner_id.property_account_payable.id
1295
123
                        else :
1296
124
                            line['account_id']=bank.partner_id.property_account_receivable.id
1297
125
1298
126
                        bank_statement_lines[st_line_name]=line
1299
127
                else:
1300
128
                    line=bank_statement_lines[st_line_name]
1301
129
                    line['cntry_number']=cntry_number
1302
130
                    line['contry_name']=contry_name
1303
131
                    bank_statement_lines[st_line_name]=line
1304
132
1305
133
1306
134
                bank_statement["bank_statement_line"]=bank_statement_lines
1307
135
        elif line[0]=='3':
1308
136
            pass
1309
137
        elif line[0]=='8':
1310
138
            # new balance record
1311
139
            bal_end = conversion.list2float(line[42:57])
1312
140
            if line[41] == '1':
1313
141
                bal_end = - bal_end
1314
142
            bank_statement["balance_end_real"]= bal_end
1315
143
1316
144
        elif line[0]=='9':
1317
145
            # footer record
1318
146
            pass
1319
147
            #bank_statements.append(bank_statement)
1320
148
     #end for
1321
149
      return bank_statement 
1322
150
1323
0
151
1324
=== added file 'account_bankimport/wizard/filters/conversion.py'
1325
--- account_bankimport/wizard/filters/conversion.py	1970-01-01 00:00:00 +0000
1326
+++ account_bankimport/wizard/filters/conversion.py	2010-03-04 01:53:21 +0000
1327
@@ -0,0 +1,20 @@
1328
1
import time
1329
2
1330
3
def str2date(date_str):
1331
4
      return time.strftime("%y/%m/%d",time.strptime(date_str,"%d%m%y"))
1332
5
1333
6
def str2float(str):
1334
7
     try:
1335
8
        return float(str)
1336
9
     except:
1337
10
        return 0.0
1338
11
1339
12
def list2float(lst):
1340
13
     try:
1341
14
        return str2float((lambda s : s[:-2] + '.' + s[-2:])(lst))
1342
15
     except:
1343
16
        return 0.0
1344
17
1345
18
def list2str(lst):
1346
19
     return str(lst).strip('[]').replace(',','').replace('\'','')
1347
20
1348
0
21
1349
=== added file 'account_bankimport/wizard/filters/mt940.py'
1350
--- account_bankimport/wizard/filters/mt940.py	1970-01-01 00:00:00 +0000
1351
+++ account_bankimport/wizard/filters/mt940.py	2010-03-04 01:53:21 +0000
1352
@@ -0,0 +1,173 @@
1353
1
##############################################################################
1354
2
#
1355
3
# Copyright (c) 2004-2006 TINY SPRL. (http://tiny.be) and Peter Dapper
1356
4
#                          All Rights Reserved.
1357
5
#                     Peter Dapper <verkoop@of-is.nl>
1358
6
#
1359
7
# WARNING: This program as such is intended to be used by professional
1360
8
# programmers who take the whole responsability of assessing all potential
1361
9
# consequences resulting from its eventual inadequacies and bugs
1362
10
# End users who are looking for a ready-to-use solution with commercial
1363
11
# garantees and support are strongly adviced to contract a Free Software
1364
12
# Service Company
1365
13
#
1366
14
# This program is Free Software; you can redistribute it and/or
1367
15
# modify it under the terms of the GNU General Public License
1368
16
# as published by the Free Software Foundation; either version 2
1369
17
# of the License, or (at your option) any later version.
1370
18
#
1371
19
# This program is distributed in the hope that it will be useful,
1372
20
# but WITHOUT ANY WARRANTY; without even the implied warranty of
1373
21
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1374
22
# GNU General Public License for more details.
1375
23
#
1376
24
# You should have received a copy of the GNU General Public License
1377
25
# along with this program; if not, write to the Free Software
1378
26
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
1379
27
#
1380
28
##############################################################################
1381
29
#
1382
30
# This filter imports .mt940-files 
1383
31
#
1384
32
1385
33
from osv import fields, osv
1386
34
import time
1387
35
import pooler
1388
36
import conversion
1389
37
import string
1390
38
import copy
1391
39
1392
40
def get_acc_number(statement_line):
1393
41
	pointer = 0
1394
42
	only_acc = ""
1395
43
	result=[]
1396
44
	# one of my suppliers uses incasso, and does not use white space in .940 file between bank account and name 
1397
45
	while statement_line[pointer]!= " " and statement_line[pointer]!= "C" and statement_line[pointer]!= "D" and statement_line[pointer]!= "Q":
1398
46
		only_acc = only_acc+statement_line[pointer]
1399
47
		pointer += 1
1400
48
	return only_acc
1401
49
1402
50
1403
51
def get_number(statement_line):
1404
52
	pointer = 7
1405
53
	only_amount = ""
1406
54
	while statement_line[pointer] in ["0","1","2","3","4","5","6","7","8","9",","]:
1407
55
		only_amount = only_amount+statement_line[pointer]
1408
56
		pointer += 1
1409
57
	only_amount = only_amount.replace(",",".")
1410
58
	return only_amount
1411
59
1412
60
1413
61
1414
62
def parse_sequence(bank_statement,bank, cr, uid,):
1415
63
	pool = pooler.get_pool(cr.dbname)
1416
64
	st_line = {}
1417
65
	bank_statement_output=[]
1418
66
	current=0
1419
67
	while current < len(bank_statement):
1420
68
		#if ':61:' in bank_statement[current]:
1421
69
		if bank_statement[current].has_key(':61:'):
1422
70
			# Pfff.. a line we can use. Gives us the date, debit/credit, and amount
1423
71
			st_line['date']=conversion.str2date(bank_statement[current][':61:'][0:6])
1424
72
			entry_date = time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(bank_statement[current][':61:'][0:6]),"%d/%m/%y")),
1425
73
			st_line['val_date']   = time.strftime('%Y-%m-%d',time.strptime(conversion.str2date(bank_statement[current][':61:'][0:6]),"%d/%m/%y")),
1426
74
			st_line['entry_date']=entry_date
1427
75
			# Pfff...get amount
1428
76
			amount =round(float(get_number(bank_statement[current][':61:'])),2)
1429
77
			st_line['amount']=amount
1430
78
			# Getting rich or poor
1431
79
			if bank_statement[current][':61:'][6] == "D":
1432
80
				st_line['account_id'] = bank['def_pay_acc']
1433
81
				st_line['amount'] = - st_line['amount']
1434
82
				# chek_ids did not work correctly because the amount could also be negativ
1435
83
				amount = - amount
1436
84
			else:
1437
85
				st_line['account_id'] = bank['def_rec_acc']
1438
86
			# Well, that was the transaction, now the details, directly next line..
1439
87
			current += 1
1440
88
			if bank_statement[current].has_key(':68:'):
1441
89
				st_line['free_comm'] = " "
1442
90
				st_line['partner_id'] = 0
1443
91
				st_line['type'] = 'general'
1444
92
				st_line['free_comm'] = " "
1445
93
				st_line['partner_acc_number'] = get_acc_number(bank_statement[current][':68:'])
1446
94
				st_line['cntry_number'] = get_acc_number(bank_statement[current][':68:'])
1447
95
				st_line['contry_name'] =bank_statement[current][':68:'][len(st_line['cntry_number']):]
1448
96
				st_line['name'] = bank_statement[current][':68:'][len(st_line['cntry_number']):]
1449
97
				st_line['ref'] =" " # Sometimes .. there is no ref. Still, it is being used by other scripts.
1450
98
				# Houston, we have a problem.. ING uses nicely a second :86: code, Postbank does not ... (back to the filling of the list,.done)
1451
99
				# See if we have a next rule, only description!! 
1452
100
				current += 1
1453
101
				if bank_statement[current].has_key(':68:'):
1454
102
					st_line['ref'] =bank_statement[current][':68:'][0:]
1455
103
					# extra comment.. filling the free_comm
1456
104
					current += 1
1457
105
					if bank_statement[current].has_key(':68:'):
1458
106
						st_line['free_comm'] = bank_statement[current][':68:'][0:]
1459
107
					else:
1460
108
						current -= 1
1461
109
			# check if there is already a statement like this...
1462
110
			check_ids = pool.get('account.bank.statement.line').search(cr,uid,[('amount','=',amount), ('date','=',entry_date),('name','=',st_line['name'])])
1463
111
			# check if there already is a relation ..., and use the ID
1464
112
			bank_ids = pool.get('res.partner.bank').search(cr,uid,[('acc_number','=',st_line['partner_acc_number'])])
1465
113
			if bank_ids:
1466
114
				bank = pool.get('res.partner.bank').browse(cr,uid,bank_ids[0],context={})
1467
115
				if bank.partner_id:
1468
116
					st_line['partner_id'] = bank.partner_id.id
1469
117
					partner = pool.get('res.partner').browse(cr,uid,bank.partner_id,context={})
1470
118
					if bank.partner_id.supplier == True and bank.partner_id.customer == False:
1471
119
						st_line['account_id'] = bank.partner_id.property_account_receivable.id
1472
120
						st_line['type'] ='supplier'
1473
121
					elif bank.partner_id.customer == True and bank.partner_id.supplier == False :
1474
122
						st_line['account_id'] = bank.partner_id.property_account_payable.id
1475
123
						st_line['type'] ='customer'
1476
124
			# ..Let see if we can make that just one line of imput
1477
125
			print st_line
1478
126
			if not check_ids:
1479
127
				bank_statement_output.append(st_line.copy())
1480
128
							
1481
129
				
1482
130
			
1483
131
		current += 1
1484
132
	return bank_statement_output
1485
133
1486
134
1487
135
def fill_simple_list(bankData):
1488
136
	current = 0
1489
137
	bank_statement_lines={}
1490
138
	bank_statements_list=[]
1491
139
	while current < len(bankData):
1492
140
		# codes used are 20,25,28,28c,60m,61,86,62,64,65. Only 61 and 68 are intresting (if you want more checks 25 and 60 are intresting)
1493
141
		statement_line = string.find(bankData[current], ':61:')
1494
142
		statement_description = string.find(bankData[current], ':86:')
1495
143
		# these codes we use to determin the possible end of the description
1496
144
		closing_balance = string.find(bankData[current], ':62F:')
1497
145
		closing_balance_available = string.find(bankData[current], ':64:')
1498
146
		if statement_line >= 0:
1499
147
			bank_statement_lines[":61:"]=bankData[current][4:]
1500
148
		if statement_description >= 0:
1501
149
			bank_statement_lines[":68:"]=bankData[current][4:]
1502
150
		if closing_balance >= 0:
1503
151
			bank_statement_lines[":62F:"]=bankData[current][5:]
1504
152
		if closing_balance_available >= 0:
1505
153
			bank_statement_lines[":64:"]=bankData[current][4:]
1506
154
		if bankData[current][0]!=":" and bankData[current][0]!="-" :
1507
155
			# some banks use LF , an not an extra :68:, so mutch for a standerd
1508
156
			bank_statement_lines[":68:"]=bankData[current][0:]
1509
157
		if  statement_line >= 0 or statement_description >= 0 or statement_description >= 0 or closing_balance_available>= 0:	
1510
158
			bank_statements_list.append(bank_statement_lines.copy())
1511
159
		bank_statement_lines={}
1512
160
		current += 1
1513
161
	return bank_statements_list
1514
162
1515
163
1516
164
def get_data(self, cr, uid, bankData, bank_statement):
1517
165
	#pool = pooler.get_pool(cr.dbname)
1518
166
	bank_statement_list=[]
1519
167
	bank_statement_output=[]
1520
168
	bank_statement_list = fill_simple_list(bankData) #just keeping it simple
1521
169
	bank_statement_output=parse_sequence(bank_statement_list,bank_statement,cr, uid,)
1522
170
	print bank_statement_output
1523
171
	return bank_statement_output
1524
172
1525
173
1526
0
174
1527
=== added directory 'account_banking'
1528
=== renamed directory 'account_banking' => 'account_banking.moved'
1529
=== added file 'account_banking/__init__.py'
1530
--- account_banking/__init__.py	1970-01-01 00:00:00 +0000
1531
+++ account_banking/__init__.py	2010-03-04 01:53:21 +0000
1532
@@ -0,0 +1,34 @@
1533
1
# -*- encoding: utf-8 -*-
1534
2
##############################################################################
1535
3
#
1536
4
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
1537
5
#    All Rights Reserved
1538
6
#
1539
7
#    WARNING: This program as such is intended to be used by professional
1540
8
#    programmers who take the whole responsability of assessing all potential
1541
9
#    consequences resulting from its eventual inadequacies and bugs
1542
10
#    End users who are looking for a ready-to-use solution with commercial
1543
11
#    garantees and support are strongly adviced to contract EduSense BV
1544
12
#
1545
13
#    This program is free software: you can redistribute it and/or modify
1546
14
#    it under the terms of the GNU General Public License as published by
1547
15
#    the Free Software Foundation, either version 3 of the License, or
1548
16
#    (at your option) any later version.
1549
17
#
1550
18
#    This program is distributed in the hope that it will be useful,
1551
19
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1552
20
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1553
21
#    GNU General Public License for more details.
1554
22
#
1555
23
#    You should have received a copy of the GNU General Public License
1556
24
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1557
25
#
1558
26
##############################################################################
1559
27
print 'Importing account_banking.account_banking'
1560
28
import account_banking
1561
29
print 'Importing account_banking.parsers'
1562
30
import parsers
1563
31
print 'Importing account_banking.wizard'
1564
32
import wizard
1565
33
1566
34
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
1567
0
35
1568
=== added file 'account_banking/__terp__.py'
1569
--- account_banking/__terp__.py	1970-01-01 00:00:00 +0000
1570
+++ account_banking/__terp__.py	2010-03-04 01:53:21 +0000
1571
@@ -0,0 +1,97 @@
1572
1
##############################################################################
1573
2
#
1574
3
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
1575
4
#    All Rights Reserved
1576
5
#
1577
6
#    WARNING: This program as such is intended to be used by professional
1578
7
#    programmers who take the whole responsability of assessing all potential
1579
8
#    consequences resulting from its eventual inadequacies and bugs
1580
9
#    End users who are looking for a ready-to-use solution with commercial
1581
10
#    garantees and support are strongly adviced to contract EduSense BV
1582
11
#
1583
12
#    This program is free software: you can redistribute it and/or modify
1584
13
#    it under the terms of the GNU General Public License as published by
1585
14
#    the Free Software Foundation, either version 3 of the License, or
1586
15
#    (at your option) any later version.
1587
16
#
1588
17
#    This program is distributed in the hope that it will be useful,
1589
18
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1590
19
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1591
20
#    GNU General Public License for more details.
1592
21
#
1593
22
#    You should have received a copy of the GNU General Public License
1594
23
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1595
24
#
1596
25
##############################################################################
1597
26
{
1598
27
    'name': 'Account Banking',
1599
28
    'version': '0.1',
1600
29
    'license': 'GPL-3',
1601
30
    'author': 'EduSense BV',
1602
31
    'category': 'Account Banking',
1603
32
    'depends': ['base', 'base_iban', 'account', 'account_payment'],
1604
33
    'init_xml': [],
1605
34
    'update_xml': [
1606
35
        #'security/ir.model.access.csv',
1607
36
        'account_banking_import_wizard.xml',
1608
37
        'account_banking_view.xml',
1609
38
        'account_banking_workflow.xml',
1610
39
    ],
1611
40
    'description': '''
1612
41
    Module to do banking.
1613
42
1614
43
    This modules tries to combine all current banking import and export
1615
44
    schemes. Rationale for this is that it is quite common to have foreign
1616
45
    bank account numbers next to national bank account numbers. The current
1617
46
    approach, which hides the national banking interface schemes in the
1618
47
    l10n_xxx modules, makes it very difficult to use these simultanious.
1619
48
    A more banking oriented approach seems more logical and cleaner.
1620
49
1621
50
    Changes to default OpenERP:
1622
51
1623
52
    * Puts focus on the real life messaging with banks:
1624
53
      + Bank statement lines upgraded to independent bank transactions.
1625
54
      + Banking statements have no special accountancy meaning, they're just
1626
55
        message envelopes for a number of bank transactions.
1627
56
      + Bank statements can be either encoded by hand to reflect the document
1628
57
        version of Bank Statements, or created as an optional side effect of
1629
58
        importing Bank Transactions.
1630
59
1631
60
    * Preparations for SEPA:
1632
61
      + IBAN accounts are the standard in the SEPA countries
1633
62
      + local accounts are derived from SEPA (excluding Turkey) but are
1634
63
        considered to be identical to the corresponding SEPA account.
1635
64
      + Banks are identified with either Country + Bank code + Branch code or BIC
1636
65
      + Each bank can have its own pace in introducing SEPA into their
1637
66
        communication with their customers.
1638
67
      + National online databases can be used to convert BBAN's to IBAN's.
1639
68
1640
69
    * Adds dropin extensible import facility for bank communication in:
1641
70
      + MultiBank (NL) format transaction files,
1642
71
      - (todo) MT940 (Swift) format transaction files,
1643
72
      - (todo) CODA (BE) format transaction files,
1644
73
      - (wish) SEPA Credits (ISO 200022) messages,
1645
74
1646
75
    * Extends payments for digital banking:
1647
76
      + Adapted workflow in payments to reflect banking operations
1648
77
      + Relies on account_payment mechanics to extend with export generators.
1649
78
      - ClieOp3 (NL) payment and direct debit orders files available as
1650
79
        account_banking_nl_clieop
1651
80
      - (wish) BTL91 (NL) payment orders files (no format description available),
1652
81
      - (wish) SEPA Direct Debits (ISO 200022) messages
1653
82
1654
83
    * Additional features for the import/export mechanism:
1655
84
      + Automatic matching and creation of bank accounts, banks and partners,
1656
85
        during import of statements.
1657
86
      + Automatic matching with invoices and payments.
1658
87
      + Sound import mechanism, allowing multiple imports of the same
1659
88
        transactions repeated over multiple files.
1660
89
      + Journal configuration per bank account.
1661
90
      + Business logic and format parsing strictly separated to ease the
1662
91
        development of new parsers.
1663
92
      + No special configuration needed for the parsers, new parsers are
1664
93
        recognized and made available at server (re)start.
1665
94
    ''',
1666
95
    'active': False,
1667
96
    'installable': True,
1668
97
}
1669
0
98
1670
=== added file 'account_banking/account_banking.py'
1671
--- account_banking/account_banking.py	1970-01-01 00:00:00 +0000
1672
+++ account_banking/account_banking.py	2010-03-04 01:53:21 +0000
1673
@@ -0,0 +1,752 @@
1674
1
# -*- encoding: utf-8 -*-
1675
2
##############################################################################
1676
3
#
1677
4
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
1678
5
#    All Rights Reserved
1679
6
#
1680
7
#    This program is free software: you can redistribute it and/or modify
1681
8
#    it under the terms of the GNU General Public License as published by
1682
9
#    the Free Software Foundation, either version 3 of the License, or
1683
10
#    (at your option) any later version.
1684
11
#
1685
12
#    This program is distributed in the hope that it will be useful,
1686
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
1687
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
1688
15
#    GNU General Public License for more details.
1689
16
#
1690
17
#    You should have received a copy of the GNU General Public License
1691
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
1692
19
#
1693
20
##############################################################################
1694
21
1695
22
'''
1696
23
This module shows resemblance to both account_bankimport/bankimport.py,
1697
24
account/account_bank_statement.py and account_payment(_export). All hail to
1698
25
the makers. account_bankimport is only referenced for their ideas and the
1699
26
framework of the filters, which they in their turn seem to have derived
1700
27
from account_coda.
1701
28
1702
29
Modifications are extensive:
1703
30
1704
31
1. In relation to account/account_bank_statement.py:
1705
32
    account.bank.statement is effectively stripped from its account.period
1706
33
    association, while account.bank.statement.line is extended with the same
1707
34
    association, thereby reflecting real world usage of bank.statement as a
1708
35
    list of bank transactions and bank.statement.line as a bank transaction.
1709
36
1710
37
2. In relation to account/account_bankimport:
1711
38
    All filter objects and extensions to res.company are removed. Instead a
1712
39
    flexible auto-loading and auto-browsing plugin structure is created,
1713
40
    whereby business logic and encoding logic are strictly separated.
1714
41
    Both parsers and business logic are rewritten from scratch.
1715
42
1716
43
    The association of account.journal with res.company is replaced by an
1717
44
    association of account.journal with res.partner.bank, thereby allowing
1718
45
    multiple bank accounts per company and one journal per bank account.
1719
46
1720
47
    The imported bank statement file does not result in a single 'bank
1721
48
    statement', but in a list of bank statements by definition of whatever the
1722
49
    bank sees as a statement. Every imported bank statement contains at least
1723
50
    one bank transaction, which is a modded account.bank.statement.line.
1724
51
1725
52
3. In relation to account_payment:
1726
53
    An additional state was inserted between 'open' and 'done', to reflect a
1727
54
    exported bank orders file which was not reported back through statements.
1728
55
    The import of statements matches the payments and reconciles them when
1729
56
    needed, flagging them 'done'. When no export wizards are found, the
1730
57
    default behavior is to flag the orders as 'sent', not as 'done'.
1731
58
'''
1732
59
import time
1733
60
from osv import osv, fields
1734
61
from tools.translate import _
1735
62
1736
63
class account_banking_account_settings(osv.osv):
1737
64
    '''Default Journal for Bank Account'''
1738
65
    _name = 'account.banking.account.settings'
1739
66
    _description = __doc__
1740
67
    _columns = {
1741
68
        'company_id': fields.many2one('res.company', 'Company', select=True,
1742
69
                                      required=True),
1743
70
        'partner_bank_id': fields.many2one('res.partner.bank', 'Bank Account',
1744
71
                                           select=True, required=True),
1745
72
        'journal_id': fields.many2one('account.journal', 'Journal',
1746
73
                                      required=True),
1747
74
        'default_credit_account_id': fields.many2one(
1748
75
            'account.account', 'Default credit account', select=True,
1749
76
            help=('The account to use when an unexpected payment was signaled. '
1750
77
                  'This can happen when a direct debit payment is cancelled '
1751
78
                  'by a customer, or when no matching payment can be found. '
1752
79
                  ' Mind that you can correct movements before confirming them.'
1753
80
                 ),
1754
81
            required=True
1755
82
        ),
1756
83
        'default_debit_account_id': fields.many2one(
1757
84
            'account.account', 'Default debit account',
1758
85
            select=True, required=True,
1759
86
            help=('The account to use when an unexpected payment is received. '
1760
87
                  'This can be needed when a customer pays in advance or when '
1761
88
                  'no matching invoice can be found. Mind that you can correct '
1762
89
                  'movements before confirming them.'
1763
90
                 ),
1764
91
        ),
1765
92
    }
1766
93
1767
94
    def _default_company(self, cursor, uid, context={}):
1768
95
        user = self.pool.get('res.users').browse(cursor, uid, uid, context=context)
1769
96
        if user.company_id:
1770
97
            return user.company_id.id
1771
98
        return self.pool.get('res.company').search(cursor, uid,
1772
99
                                                   [('parent_id', '=', False)]
1773
100
                                                  )[0]
1774
101
1775
102
    _defaults = {
1776
103
        'company_id': _default_company,
1777
104
    }
1778
105
account_banking_account_settings()
1779
106
1780
107
class account_banking_imported_file(osv.osv):
1781
108
    '''Imported Bank Statements File'''
1782
109
    _name = 'account.banking.imported.file'
1783
110
    _description = __doc__
1784
111
    _columns = {
1785
112
        'company_id': fields.many2one('res.company', 'Company',
1786
113
                                      select=True, readonly=True
1787
114
                                     ),
1788
115
        'date': fields.datetime('Import Date', readonly=False, select=True),
1789
116
        'format': fields.char('File Format', size=20, readonly=False),
1790
117
        'file': fields.binary('Raw Data', readonly=False),
1791
118
        'log': fields.text('Import Log', readonly=False),
1792
119
        'user_id': fields.many2one('res.users', 'Responsible User',
1793
120
                                   readonly=False, select=True
1794
121
                                  ),
1795
122
        'state': fields.selection(
1796
123
            [('unfinished', 'Unfinished'),
1797
124
             ('error', 'Error'),
1798
125
             ('ready', 'Finished'),
1799
126
            ], 'State', select=True, readonly=True
1800
127
        ),
1801
128
        'statement_ids': fields.one2many('account.bank.statement',
1802
129
                                         'banking_id', 'Statements',
1803
130
                                         readonly=False,
1804
131
                                  ),
1805
132
    }
1806
133
    _defaults = {
1807
134
        'date': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),
1808
135
        'user_id': lambda self, cursor, uid, context: uid,
1809
136
    }
1810
137
account_banking_imported_file()
1811
138
1812
139
class account_bank_statement(osv.osv):
1813
140
    '''
1814
141
    Extensions from account_bank_statement:
1815
142
        1. Removed period_id (transformed to optional boolean) - as it is no
1816
143
           longer needed.
1817
144
        2. Extended 'button_confirm' trigger to cope with the period per
1818
145
           statement_line situation.
1819
146
        3. Added optional relation with imported statements file
1820
147
    '''
1821
148
    _inherit = 'account.bank.statement'
1822
149
    _columns = {
1823
150
        'period_id': fields.many2one('account.period', 'Period',
1824
151
                                     required=False, readonly=True),
1825
152
        'banking_id': fields.many2one('account.banking.imported.file',
1826
153
                                     'Imported File', readonly=True,
1827
154
                                     ),
1828
155
    }
1829
156
    _defaults = {
1830
157
        'period_id': lambda *a: False,
1831
158
    }
1832
159
1833
160
    def _get_period(self, cursor, uid, date, context={}):
1834
161
        '''
1835
162
        Find matching period for date, not meant for _defaults.
1836
163
        '''
1837
164
        period_obj = self.pool.get('account.period')
1838
165
        periods = period_obj.find(cursor, uid, dt=date, context=context)
1839
166
        return periods and periods[0] or False
1840
167
1841
168
    def button_confirm(self, cursor, uid, ids, context=None):
1842
169
        # This is largely a copy of the original code in account
1843
170
        # As there is no valid inheritance mechanism for large actions, this
1844
171
        # is the only option to add functionality to existing actions.
1845
172
        # WARNING: when the original code changes, this trigger has to be
1846
173
        # updated in sync.
1847
174
        done = []
1848
175
        res_currency_obj = self.pool.get('res.currency')
1849
176
        res_users_obj = self.pool.get('res.users')
1850
177
        account_move_obj = self.pool.get('account.move')
1851
178
        account_move_line_obj = self.pool.get('account.move.line')
1852
179
        account_bank_statement_line_obj = \
1853
180
                self.pool.get('account.bank.statement.line')
1854
181
1855
182
        company_currency_id = res_users_obj.browse(cursor, uid, uid,
1856
183
                context=context).company_id.currency_id.id
1857
184
1858
185
        for st in self.browse(cursor, uid, ids, context):
1859
186
            if not st.state=='draft':
1860
187
                continue
1861
188
            end_bal = st.balance_end or 0.0
1862
189
            if not (abs(end_bal - st.balance_end_real) < 0.0001):
1863
190
                raise osv.except_osv(_('Error !'),
1864
191
                    _('The statement balance is incorrect !\n') +
1865
192
                    _('The expected balance (%.2f) is different '
1866
193
                      'than the computed one. (%.2f)') % (
1867
194
                          st.balance_end_real, st.balance_end
1868
195
                      ))
1869
196
            if (not st.journal_id.default_credit_account_id) \
1870
197
                    or (not st.journal_id.default_debit_account_id):
1871
198
                raise osv.except_osv(_('Configration Error !'),
1872
199
                    _('Please verify that an account is defined in the journal.'))
1873
200
1874
201
            for line in st.move_line_ids:
1875
202
                if line.state <> 'valid':
1876
203
                    raise osv.except_osv(_('Error !'),
1877
204
                        _('The account entries lines are not in valid state.'))
1878
205
1879
206
            for move in st.line_ids:
1880
207
                period_id = self._get_period(cursor, uid, move.date, context=context)
1881
208
                move_id = account_move_obj.create(cursor, uid, {
1882
209
                    'journal_id': st.journal_id.id,
1883
210
                    'period_id': period_id,
1884
211
                }, context=context)
1885
212
                account_bank_statement_line_obj.write(cursor, uid, [move.id], {
1886
213
                    'move_ids': [(4, move_id, False)]
1887
214
                })
1888
215
                if not move.amount:
1889
216
                    continue
1890
217
1891
218
                torec = []
1892
219
                if move.amount >= 0:
1893
220
                    account_id = st.journal_id.default_credit_account_id.id
1894
221
                else:
1895
222
                    account_id = st.journal_id.default_debit_account_id.id
1896
223
                acc_cur = ((move.amount<=0) and st.journal_id.default_debit_account_id) \
1897
224
                          or move.account_id
1898
225
                amount = res_currency_obj.compute(cursor, uid, st.currency.id,
1899
226
                        company_currency_id, move.amount, context=context,
1900
227
                        account=acc_cur)
1901
228
                if move.reconcile_id and move.reconcile_id.line_new_ids:
1902
229
                    for newline in move.reconcile_id.line_new_ids:
1903
230
                        amount += newline.amount
1904
231
1905
232
                val = {
1906
233
                    'name': move.name,
1907
234
                    'date': move.date,
1908
235
                    'ref': move.ref,
1909
236
                    'move_id': move_id,
1910
237
                    'partner_id': ((move.partner_id) and move.partner_id.id) or False,
1911
238
                    'account_id': (move.account_id) and move.account_id.id,
1912
239
                    'credit': ((amount>0) and amount) or 0.0,
1913
240
                    'debit': ((amount<0) and -amount) or 0.0,
1914
241
                    'statement_id': st.id,
1915
242
                    'journal_id': st.journal_id.id,
1916
243
                    'period_id': period_id,
1917
244
                    'currency_id': st.currency.id,
1918
245
                }
1919
246
1920
247
                amount = res_currency_obj.compute(cursor, uid, st.currency.id,
1921
248
                        company_currency_id, move.amount, context=context,
1922
249
                        account=acc_cur)
1923
250
1924
251
                if move.account_id and move.account_id.currency_id:
1925
252
                    val['currency_id'] = move.account_id.currency_id.id
1926
253
                    if company_currency_id==move.account_id.currency_id.id:
1927
254
                        amount_cur = move.amount
1928
255
                    else:
1929
256
                        amount_cur = res_currency_obj.compute(cursor, uid, company_currency_id,
1930
257
                                move.account_id.currency_id.id, amount, context=context,
1931
258
                                account=acc_cur)
1932
259
                    val['amount_currency'] = amount_cur
1933
260
1934
261
                torec.append(account_move_line_obj.create(cursor, uid, val , context=context))
1935
262
1936
263
                if move.reconcile_id and move.reconcile_id.line_new_ids:
1937
264
                    for newline in move.reconcile_id.line_new_ids:
1938
265
                        account_move_line_obj.create(cursor, uid, {
1939
266
                            'name': newline.name or move.name,
1940
267
                            'date': move.date,
1941
268
                            'ref': move.ref,
1942
269
                            'move_id': move_id,
1943
270
                            'partner_id': ((move.partner_id) and move.partner_id.id) or False,
1944
271
                            'account_id': (newline.account_id) and newline.account_id.id,
1945
272
                            'debit': newline.amount>0 and newline.amount or 0.0,
1946
273
                            'credit': newline.amount<0 and -newline.amount or 0.0,
1947
274
                            'statement_id': st.id,
1948
275
                            'journal_id': st.journal_id.id,
1949
276
                            'period_id': period_id,
1950
277
                        }, context=context)
1951
278
1952
279
                # Fill the secondary amount/currency
1953
280
                # if currency is not the same than the company
1954
281
                amount_currency = False
1955
282
                currency_id = False
1956
283
                if st.currency.id <> company_currency_id:
1957
284
                    amount_currency = move.amount
1958
285
                    currency_id = st.currency.id
1959
286
1960
287
                account_move_line_obj.create(cursor, uid, {
1961
288
                    'name': move.name,
1962
289
                    'date': move.date,
1963
290
                    'ref': move.ref,
1964
291
                    'move_id': move_id,
1965
292
                    'partner_id': ((move.partner_id) and move.partner_id.id) or False,
1966
293
                    'account_id': account_id,
1967
294
                    'credit': ((amount < 0) and -amount) or 0.0,
1968
295
                    'debit': ((amount > 0) and amount) or 0.0,
1969
296
                    'statement_id': st.id,
1970
297
                    'journal_id': st.journal_id.id,
1971
298
                    'period_id': period_id,
1972
299
                    'amount_currency': amount_currency,
1973
300
                    'currency_id': currency_id,
1974
301
                    }, context=context)
1975
302
1976
303
                for line in account_move_line_obj.browse(cursor, uid, [x.id for x in 
1977
304
                        account_move_obj.browse(cursor, uid, move_id, context=context).line_id
1978
305
                        ], context=context):
1979
306
                    if line.state <> 'valid':
1980
307
                        raise osv.except_osv(
1981
308
                            _('Error !'),
1982
309
                            _('Account move line "%s" is not valid')
1983
310
                            % line.name
1984
311
                        )
1985
312
1986
313
                if move.reconcile_id and move.reconcile_id.line_ids:
1987
314
                    torec += map(lambda x: x.id, move.reconcile_id.line_ids)
1988
315
                    #try:
1989
316
                    if abs(move.reconcile_amount-move.amount)<0.0001:
1990
317
                        account_move_line_obj.reconcile(
1991
318
                            cursor, uid, torec, 'statement', context
1992
319
                        )
1993
320
                    else:
1994
321
                        account_move_line_obj.reconcile_partial(
1995
322
                            cursor, uid, torec, 'statement', context
1996
323
                        )
1997
324
                    #except:
1998
325
                    #    raise osv.except_osv(
1999
326
                    #        _('Error !'),
2000
327
                    #        _('Unable to reconcile entry "%s": %.2f') %
2001
328
                    #        (move.name, move.amount)
2002
329
                    #    )
2003
330
2004
331
                if st.journal_id.entry_posted:
2005
332
                    account_move_obj.write(cursor, uid, [move_id], {'state':'posted'})
2006
333
            done.append(st.id)
2007
334
        self.write(cursor, uid, done, {'state':'confirm'}, context=context)
2008
335
        return True
2009
336
2010
337
account_bank_statement()
2011
338
2012
339
class account_bank_statement_line(osv.osv):
2013
340
    '''
2014
341
    Extension on basic class:
2015
342
        1. Extra links to account.period and res.partner.bank for tracing and
2016
343
           matching.
2017
344
        2. Extra 'trans' field to carry the transaction id of the bank.
2018
345
        3. Extra 'international' flag to indicate the missing of a remote
2019
346
           account number. Some banks use seperate international banking
2020
347
           modules that do not integrate with the standard transaction files.
2021
348
        4. Readonly states for most fields except when in draft.
2022
349
    '''
2023
350
    _inherit = 'account.bank.statement.line'
2024
351
    _description = 'Bank Transaction'
2025
352
2026
353
    def _get_period(self, cursor, uid, context={}):
2027
354
        date = context.get('date') and context['date'] or None
2028
355
        periods = self.pool.get('account.period').find(cursor, uid, dt=date)
2029
356
        return periods and periods[0] or False
2030
357
2031
358
    def _seems_international(self, cursor, uid, context={}):
2032
359
        '''
2033
360
        Some banks have seperate international banking modules which do not
2034
361
        translate correctly into the national formats. Instead, they
2035
362
        leave key fields blank and signal this anomaly with a special
2036
363
        transfer type.
2037
364
        With the introduction of SEPA, this may worsen greatly, as SEPA
2038
365
        payments are considered to be analogous to international payments
2039
366
        by most local formats.
2040
367
        '''
2041
368
        # Quick and dirty check: if remote bank account is missing, assume
2042
369
        # international transfer
2043
370
        return not (
2044
371
            context.get('partner_bank_id') and context['partner_bank_id']
2045
372
        )
2046
373
        # Not so dirty check: check if partner_id is set. If it is, check the
2047
374
        # default/invoice addresses country. If it is the same as our
2048
375
        # company's, its local, else international.
2049
376
        # TODO: to be done
2050
377
2051
378
    _columns = {
2052
379
        # Redefines
2053
380
        'amount': fields.float('Amount', readonly=True,
2054
381
                            states={'draft': [('readonly', False)]}),
2055
382
        'ref': fields.char('Ref.', size=32, readonly=True,
2056
383
                            states={'draft': [('readonly', False)]}),
2057
384
        'name': fields.char('Name', size=64, required=True, readonly=True,
2058
385
                            states={'draft': [('readonly', False)]}),
2059
386
        'date': fields.date('Date', required=True, readonly=True,
2060
387
                            states={'draft': [('readonly', False)]}),
2061
388
        # New columns
2062
389
        'trans': fields.char('Bank Transaction ID', size=15, required=False,
2063
390
                            readonly=True,
2064
391
                            states={'draft':[('readonly', False)]},
2065
392
                            ),
2066
393
        'partner_bank_id': fields.many2one('res.partner.bank', 'Bank Account',
2067
394
                            required=False, readonly=True,
2068
395
                            states={'draft':[('readonly', False)]},
2069
396
                            ),
2070
397
        'period_id': fields.many2one('account.period', 'Period', required=True,
2071
398
                            states={'confirm': [('readonly', True)]}),
2072
399
        # Not used yet, but usefull in the future.
2073
400
        'international': fields.boolean('International Transaction',
2074
401
                            required=False,
2075
402
                            states={'confirm': [('readonly', True)]},
2076
403
                            ),
2077
404
    }
2078
405
2079
406
    _defaults = {
2080
407
        'period_id': _get_period,
2081
408
        'international': _seems_international,
2082
409
    }
2083
410
2084
411
    def onchange_partner_id(self, cursor, uid, line_id, partner_id, type,
2085
412
                            currency_id, context={}
2086
413
                           ):
2087
414
        if not partner_id:
2088
415
            return {}
2089
416
        users_obj = self.pool.get('res.users')
2090
417
        partner_obj = self.pool.get('res.partner')
2091
418
        
2092
419
        company_currency_id = users_obj.browse(cursor, uid, uid, context=context)\
2093
420
                .company_id.currency_id.id
2094
421
            
2095
422
        if not currency_id:
2096
423
            currency_id = company_currency_id
2097
424
        
2098
425
        partner = partner_obj.browse(cursor, uid, partner_id, context=context)
2099
426
        if partner.supplier and not part.customer:
2100
427
            account_id = part.property_account_payable.id
2101
428
            type = 'supplier'
2102
429
        elif partner.supplier and not part.customer:
2103
430
            account_id =  part.property_account_receivable.id
2104
431
            type = 'customer'
2105
432
        else:
2106
433
            account_id = 0
2107
434
            type = 'general'
2108
435
2109
436
        return {'value': {'type': type , 'account_id': account_id}}
2110
437
2111
438
    def write(self, cursor, uid, ids, values, context={}):
2112
439
        # TODO: Not sure what to do with this, as it seems that most of
2113
440
        # this code is related to res_partner_bank and not to this class.
2114
441
        account_numbers = []
2115
442
        bank_obj = self.pool.get('res.partner.bank')
2116
443
        statement_line_obj = self.pool.get('account.bank.statement.line')
2117
444
2118
445
        if 'partner_id' in values:
2119
446
            bank_account_ids = bank_obj.search(cursor, uid,
2120
447
                                               [('partner_id','=', values['partner_id'])]
2121
448
                                              )
2122
449
            bank_accounts = bank_obj.browse(cursor, uid, bank_account_ids)
2123
450
            import_account_numbers = statement_line_obj.browse(cursor, uid, ids)
2124
451
2125
452
            for accno in bank_accounts:
2126
453
                # Allow acc_number and iban to co-exist (SEPA will unite the
2127
454
                # two, but - as seen now - in an uneven pace per country)
2128
455
                if accno.acc_number:
2129
456
                    account_numbers.append(accno.acc_number)
2130
457
                if accno.iban:
2131
458
                    account_numbers.append(accno.iban)
2132
459
2133
460
            if any([x for x in import_account_numbers if x.bank_accnumber in
2134
461
                    account_numbers]):
2135
462
                for accno in import_account_numbers:
2136
463
                    account_data = _get_account_data(accno.bank_accnumber)
2137
464
                    if account_data:
2138
465
                        bank_id = bank_obj.search(cursor, uid, [
2139
466
                            ('name', '=', account_data['bank_name'])
2140
467
                        ])
2141
468
                        if not bank_id:
2142
469
                            bank_id = bank_obj.create(cursor, uid, {
2143
470
                                'name': account_data['bank_name'],
2144
471
                                'bic': account_data['bic'],
2145
472
                                'active': 1,
2146
473
                            })
2147
474
                        else:
2148
475
                            bank_id = bank_id[0]
2149
476
2150
477
                        bank_acc = bank_obj.create(cursor, uid, {
2151
478
                            'state': 'bank',
2152
479
                            'partner_id': values['partner_id'],
2153
480
                            'bank': bank_id,
2154
481
                            'acc_number': accno.bank_accnumber,
2155
482
                        })
2156
483
2157
484
                        bank_iban = bank_obj.create(cursor, uid, {
2158
485
                            'state': 'iban',
2159
486
                            'partner_id': values['partner_id'],
2160
487
                            'bank': bank_id,
2161
488
                            'iban': account_data['iban'],
2162
489
                        })
2163
490
2164
491
                    else:
2165
492
                        bank_acc = bank_obj.create(cursor, uid, {
2166
493
                            'state': 'bank',
2167
494
                            'partner_id': values['partner_id'],
2168
495
                            'acc_number': accno.bank_accnumber,
2169
496
                        })
2170
497
2171
498
        return super(account_bank_statement_line, self).write(
2172
499
            cursor, uid, ids, values, context
2173
500
        )
2174
501
2175
502
account_bank_statement_line()
2176
503
2177
504
class payment_type(osv.osv):
2178
505
    '''
2179
506
    Make description field translatable #, add country context
2180
507
    '''
2181
508
    _inherit = 'payment.type'
2182
509
    _columns = {
2183
510
        'name': fields.char('Name', size=64, required=True, translate=True,
2184
511
                            help='Payment Type'
2185
512
                           ),
2186
513
        #'country_id': fields.many2one('res.country', 'Country',
2187
514
        #                    required=False,
2188
515
        #                    help='Use this to limit this type to a specific country'
2189
516
        #                   ),
2190
517
    }
2191
518
    #_defaults = {
2192
519
    #    'country_id': lambda *a: False,
2193
520
    #}
2194
521
payment_type()
2195
522
2196
523
class payment_line(osv.osv):
2197
524
    '''
2198
525
    Add extra export_state and date_done fields; make destination bank account
2199
526
    mandatory, as it makes no sense to send payments into thin air.
2200
527
    '''
2201
528
    _inherit = 'payment.line'
2202
529
    _columns = {
2203
530
        # New fields
2204
531
        'bank_id': fields.many2one('res.partner.bank',
2205
532
                                   'Destination Bank account',
2206
533
                                   required=True
2207
534
                                  ),
2208
535
        'export_state': fields.selection([
2209
536
            ('draft', 'Draft'),
2210
537
            ('open','Confirmed'),
2211
538
            ('cancel','Cancelled'),
2212
539
            ('sent', 'Sent'),
2213
540
            ('done','Done'),
2214
541
            ], 'State', select=True
2215
542
        ),
2216
543
        # Redefined fields: added states
2217
544
        'date_done': fields.datetime('Date Confirmed', select=True,
2218
545
                                     readonly=True),
2219
546
        'name': fields.char(
2220
547
            'Your Reference', size=64, required=True,
2221
548
            states={
2222
549
                'sent': [('readonly', True)],
2223
550
                'done': [('readonly', True)]
2224
551
            },
2225
552
        ),
2226
553
        'communication': fields.char(
2227
554
            'Communication', size=64, required=True, 
2228
555
            help=("Used as the message between ordering customer and current "
2229
556
                  "company. Depicts 'What do you want to say to the recipient"
2230
557
                  " about this order ?'"
2231
558
                 ),
2232
559
            states={
2233
560
                'sent': [('readonly', True)],
2234
561
                'done': [('readonly', True)]
2235
562
            },
2236
563
        ),
2237
564
        'communication2': fields.char(
2238
565
            'Communication 2', size=64,
2239
566
            help='The successor message of Communication.',
2240
567
            states={
2241
568
                'sent': [('readonly', True)],
2242
569
                'done': [('readonly', True)]
2243
570
            },
2244
571
        ),
2245
572
        'move_line_id': fields.many2one(
2246
573
            'account.move.line', 'Entry line',
2247
574
            domain=[('reconcile_id','=', False),
2248
575
                    ('account_id.type', '=','payable')
2249
576
                   ],
2250
577
            help=('This Entry Line will be referred for the information of '
2251
578
                  'the ordering customer.'
2252
579
                 ),
2253
580
            states={
2254
581
                'sent': [('readonly', True)],
2255
582
                'done': [('readonly', True)]
2256
583
            },
2257
584
        ),
2258
585
        'amount_currency': fields.float(
2259
586
            'Amount in Partner Currency', digits=(16,2),
2260
587
            required=True,
2261
588
            help='Payment amount in the partner currency',
2262
589
            states={
2263
590
                'sent': [('readonly', True)],
2264
591
                'done': [('readonly', True)]
2265
592
            },
2266
593
        ),
2267
594
        'currency': fields.many2one(
2268
595
            'res.currency', 'Partner Currency', required=True,
2269
596
            states={
2270
597
                'sent': [('readonly', True)],
2271
598
                'done': [('readonly', True)]
2272
599
            },
2273
600
        ),
2274
601
        'bank_id': fields.many2one(
2275
602
            'res.partner.bank', 'Destination Bank account',
2276
603
            states={
2277
604
                'sent': [('readonly', True)],
2278
605
                'done': [('readonly', True)]
2279
606
            },
2280
607
        ),
2281
608
        'order_id': fields.many2one(
2282
609
            'payment.order', 'Order', required=True,
2283
610
            ondelete='cascade', select=True,
2284
611
            states={
2285
612
                'sent': [('readonly', True)],
2286
613
                'done': [('readonly', True)]
2287
614
            },
2288
615
        ),
2289
616
        'partner_id': fields.many2one(
2290
617
            'res.partner', string="Partner", required=True,
2291
618
            help='The Ordering Customer',
2292
619
            states={
2293
620
                'sent': [('readonly', True)],
2294
621
                'done': [('readonly', True)]
2295
622
            },
2296
623
        ),
2297
624
        'date': fields.date(
2298
625
            'Payment Date',
2299
626
            help=("If no payment date is specified, the bank will treat this "
2300
627
                  "payment line directly"
2301
628
                 ),
2302
629
            states={
2303
630
                'sent': [('readonly', True)],
2304
631
                'done': [('readonly', True)]
2305
632
            },
2306
633
        ),
2307
634
        'state': fields.selection([
2308
635
            ('normal','Free'),
2309
636
            ('structured','Structured')
2310
637
            ], 'Communication Type', required=True,
2311
638
            states={
2312
639
                'sent': [('readonly', True)],
2313
640
                'done': [('readonly', True)]
2314
641
            },
2315
642
        ),
2316
643
    }
2317
644
    _defaults = {
2318
645
        'export_state': lambda *a: 'draft',
2319
646
        'date_done': lambda *a: False,
2320
647
    }
2321
648
payment_line()
2322
649
2323
650
class payment_order(osv.osv):
2324
651
    '''
2325
652
    Enable extra state for payment exports
2326
653
    '''
2327
654
    _inherit = 'payment.order'
2328
655
    _columns = {
2329
656
        'date_planned': fields.date(
2330
657
            'Scheduled date if fixed',
2331
658
            states={
2332
659
                'sent': [('readonly', True)],
2333
660
                'done': [('readonly', True)]
2334
661
            },
2335
662
            help='Select a date if you have chosen Preferred Date to be fixed.'
2336
663
        ),
2337
664
        'reference': fields.char(
2338
665
            'Reference', size=128, required=True,
2339
666
            states={
2340
667
                'sent': [('readonly', True)],
2341
668
                'done': [('readonly', True)]
2342
669
            },
2343
670
        ),
2344
671
        'mode': fields.many2one(
2345
672
            'payment.mode', 'Payment mode', select=True, required=True,
2346
673
            states={
2347
674
                'sent': [('readonly', True)],
2348
675
                'done': [('readonly', True)]
2349
676
            },
2350
677
            help='Select the Payment Mode to be applied.'
2351
678
        ),
2352
679
        'state': fields.selection([
2353
680
            ('draft', 'Draft'),
2354
681
            ('open','Confirmed'),
2355
682
            ('cancel','Cancelled'),
2356
683
            ('sent', 'Sent'),
2357
684
            ('done','Done'),
2358
685
            ], 'State', select=True
2359
686
        ),
2360
687
        'line_ids': fields.one2many(
2361
688
            'payment.line', 'order_id', 'Payment lines',
2362
689
            states={
2363
690
                'sent': [('readonly', True)],
2364
691
                'done': [('readonly', True)]
2365
692
            },
2366
693
        ),
2367
694
        'user_id': fields.many2one(
2368
695
            'res.users','User', required=True,
2369
696
            states={
2370
697
                'sent': [('readonly', True)],
2371
698
                'done': [('readonly', True)]
2372
699
            },
2373
700
        ),
2374
701
        'date_prefered': fields.selection([
2375
702
            ('now', 'Directly'),
2376
703
            ('due', 'Due date'),
2377
704
            ('fixed', 'Fixed date')
2378
705
            ], "Preferred date", change_default=True, required=True,
2379
706
            states={
2380
707
                'sent': [('readonly', True)],
2381
708
                'done': [('readonly', True)]
2382
709
            },
2383
710
            help=("Choose an option for the Payment Order:'Fixed' stands for a "
2384
711
                  "date specified by you.'Directly' stands for the direct "
2385
712
                  "execution.'Due date' stands for the scheduled date of "
2386
713
                  "execution."
2387
714
                 )
2388
715
            ),
2389
716
    }
2390
717
2391
718
    def set_to_draft(self, cr, uid, ids, *args):
2392
719
        cr.execute("UPDATE payment_line "
2393
720
                   "SET export_state = 'draft' "
2394
721
                   "WHERE order_id in (%s)" % (
2395
722
                       ','.join(map(str, ids))
2396
723
                   ))
2397
724
        return super(payment_order, self).set_to_draft(
2398
725
            cr, uid, ids, *args
2399
726
        )
2400
727
2401
728
    def action_sent(self, cr, uid, ids, *args):
2402
729
        cr.execute("UPDATE payment_line "
2403
730
                   "SET export_state = 'sent' "
2404
731
                   "WHERE order_id in (%s)" % (
2405
732
                       ','.join(map(str, ids))
2406
733
                   ))
2407
734
        return True
2408
735
2409
736
    def set_done(self, cr, uid, id, *args):
2410
737
        '''
2411
738
        Extend standard transition to update childs as well.
2412
739
        '''
2413
740
        cr.execute("UPDATE payment_line "
2414
741
                   "SET export_state = 'done', date_done = '%s' "
2415
742
                   "WHERE order_id = %s" % (
2416
743
                       time.strftime('%Y-%m-%d'),
2417
744
                       self.id
2418
745
                   ))
2419
746
        return super(payment_order, self).set_done(
2420
747
            cr, uid, id, *args
2421
748
        )
2422
749
2423
750
payment_order()
2424
751
2425
752
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
2426
0
753
2427
=== added file 'account_banking/account_banking_demo.xml'
2428
--- account_banking/account_banking_demo.xml	1970-01-01 00:00:00 +0000
2429
+++ account_banking/account_banking_demo.xml	2010-03-04 01:53:21 +0000
2430
@@ -0,0 +1,32 @@
2431
1
<?xml version="1.0" encoding="utf-8"?>
2432
2
<openerp>
2433
3
<data noupdate="1">
2434
4
	<record model="res.partner" id="partner_demo1">
2435
5
		<field name="name">Tiny S.p.r.l</field>
2436
6
	</record>
2437
7
	<record model="res.partner.bank" id="partner_bank1">
2438
8
		<field name="acc_number">301915554082</field>
2439
9
		<field name="state">bank</field>
2440
10
		<field name="partner_id" ref="partner_demo1"></field>
2441
11
	</record>
2442
12
2443
13
	<record model="res.partner" id="partner_demo2">
2444
14
		<field name="name">The-design Company</field>
2445
15
	</record>
2446
16
	<record model="res.partner.bank" id="partner_bank2">
2447
17
     	<field name="acc_number">050000000017</field>
2448
18
		<field name="state">iban</field>
2449
19
		<field name="partner_id" ref="partner_demo2"></field>
2450
20
	</record>
2451
21
2452
22
<!--	<record model="res.partner.bank" id="partner_agrolait">
2453
23
		<field name="acc_number">301915554082</field>
2454
24
		<field name="partner_id" ref="base.res_partner_agrolait"/>
2455
25
	</record>
2456
26
2457
27
	<record model="res.partner.bank" id="res_partner_10">
2458
28
		<field name="acc_number">050000000017</field>
2459
29
		<field name="partner_id" ref="base.res_partner_10"/>
2460
30
	</record>-->
2461
31
</data>
2462
32
</openerp>
2463
0
33
2464
=== added file 'account_banking/account_banking_import_wizard.xml'
2465
--- account_banking/account_banking_import_wizard.xml	1970-01-01 00:00:00 +0000
2466
+++ account_banking/account_banking_import_wizard.xml	2010-03-04 01:53:21 +0000
2467
@@ -0,0 +1,15 @@
2468
1
<?xml version="1.0" encoding="utf-8"?>
2469
2
<!--
2470
3
  Copyright (C) EduSense BV <http://www.edusense.nl>
2471
4
  All rights reserved.
2472
5
  The licence is in the file __terp__.py
2473
6
-->
2474
7
<openerp>
2475
8
    <data>
2476
9
        <wizard id="wizard_account_banking_import_file"
2477
10
            string="Import Bank Statements File"
2478
11
            model="account.bank.statement"
2479
12
            name="account_banking.banking_import"
2480
13
            />
2481
14
    </data>
2482
15
</openerp>
2483
0
16
2484
=== added file 'account_banking/account_banking_view.xml'
2485
--- account_banking/account_banking_view.xml	1970-01-01 00:00:00 +0000
2486
+++ account_banking/account_banking_view.xml	2010-03-04 01:53:21 +0000
2487
@@ -0,0 +1,211 @@
2488
1
<?xml version="1.0" encoding="utf-8"?>
2489
2
<!--
2490
3
  Copyright (C) EduSense BV <http://www.edusense.nl>
2491
4
  All rights reserved.
2492
5
  The licence is in the file __terp__.py
2493
6
-->
2494
7
<openerp>
2495
8
    <data>
2496
9
        <!-- Create new submenu in finance/periodical processing -->
2497
10
        <menuitem name="Banking"
2498
11
            id="account_banking.menu_finance_banking_actions"
2499
12
            parent="account.menu_finance_periodical_processing"
2500
13
            />
2501
14
        <!-- Create new submenu in finance/configuration -->
2502
15
        <menuitem name="Banking"
2503
16
            id="account_banking.menu_finance_banking_settings"
2504
17
            parent="account.menu_finance_configuration"
2505
18
            />
2506
19
2507
20
        <!-- Create new view on default journals for bank accounts -->
2508
21
        <record model="ir.ui.view" id="view_banking_account_settings_form">
2509
22
            <field name="name">account.banking.account.settings.form</field>
2510
23
            <field name="model">account.banking.account.settings</field>
2511
24
            <field name="type">form</field>
2512
25
            <field name="arch" type="xml">
2513
26
                <form string="Default Import Settings for Bank Account">
2514
27
                    <field name="company_id" />
2515
28
                    <separator string="Bank Account Details" colspan="4" />
2516
29
                    <field name="partner_bank_id" /> <!-- Needs fiddling... domain="[('partner_id','=',company_id.partner_id)]"/-->
2517
30
                    <field name="journal_id" domain="[('type','=','cash')]" />
2518
31
                    <separator string="Default Accounts for Unknown Movements" colspan="4" />
2519
32
                    <field name="default_credit_account_id" />
2520
33
                    <field name="default_debit_account_id" />
2521
34
                </form>
2522
35
            </field>
2523
36
        </record>
2524
37
        <record model="ir.ui.view" id="view_banking_account_settings_tree">
2525
38
            <field name="name">account.banking.account.settings.tree</field>
2526
39
            <field name="model">account.banking.account.settings</field>
2527
40
            <field name="type">tree</field>
2528
41
            <field name="arch" type="xml">
2529
42
                <tree string="Default Import Settings for Bank Account">
2530
43
                    <field name="company_id" />
2531
44
                    <field name="partner_bank_id" /> <!-- Needs fiddling... domain="[('partner_id','=',company_id.partner_id)]"/-->
2532
45
                    <field name="journal_id" domain="[('type','=','cash')]" />
2533
46
                </tree>
2534
47
            </field>
2535
48
        </record>
2536
49
        <record model="ir.actions.act_window" id="action_account_banking_journals">
2537
50
            <field name="name">Default Import Settings for Bank Accounts</field>
2538
51
            <field name="type">ir.actions.act_window</field>
2539
52
            <field name="res_model">account.banking.account.settings</field>
2540
53
            <field name="view_type">form</field>
2541
54
            <field name="view_mode">tree,form</field>
2542
55
        </record>
2543
56
2544
57
        <!-- Create new submenu for finance configuration -->
2545
58
        <menuitem name="Default Import Settings for Bank Accounts"
2546
59
            id="menu_action_account_banking_bank_journals"
2547
60
            parent="account_banking.menu_finance_banking_settings"
2548
61
            action="action_account_banking_journals"
2549
62
            sequence="12"
2550
63
         />
2551
64
        
2552
65
        <!-- Create new view on imported statement files -->
2553
66
        <record model="ir.ui.view" id="view_account_banking_imported_file_form">
2554
67
            <field name="name">account.banking.imported.file.form</field>
2555
68
            <field name="model">account.banking.imported.file</field>
2556
69
            <field name="type">form</field>
2557
70
            <field name="arch" type="xml">
2558
71
                <form string="Imported Bank Statements">
2559
72
                    <notebook colspan="4">
2560
73
                        <page string="Import Details">
2561
74
                            <field name="company_id" />
2562
75
                            <field name="date" />
2563
76
                            <field name="user_id" />
2564
77
                            <field name="state" />
2565
78
                            <field name="file"/>
2566
79
                            <field name="format" />
2567
80
                        </page>
2568
81
                        <page string="Statements">
2569
82
                            <field name="statement_ids" colspan="4"/>
2570
83
                        </page>
2571
84
                        <page string="Import Log">
2572
85
                            <field name="log" colspan="4"/>
2573
86
                        </page>
2574
87
                    </notebook>
2575
88
                </form>
2576
89
            </field>
2577
90
        </record>
2578
91
        <record model="ir.ui.view" id="view_account_banking_imported_file_tree">
2579
92
            <field name="name">account.banking.imported.file.tree</field>
2580
93
            <field name="model">account.banking.imported.file</field>
2581
94
            <field name="type">tree</field>
2582
95
            <field name="arch" type="xml">
2583
96
                <tree string="Imported Bank Statements Files" colors="red:state=='error';blue:state=='unfinished'">
2584
97
                    <field name="company_id" />
2585
98
                    <field name="date" />
2586
99
                    <field name="user_id" />
2587
100
                    <field name="state" />
2588
101
                </tree>
2589
102
            </field>
2590
103
        </record>
2591
104
        <record model="ir.actions.act_window" id="action_account_banking_imported_files">
2592
105
            <field name="name">Imported Bank Statements Files</field>
2593
106
            <field name="type">ir.actions.act_window</field>
2594
107
            <field name="res_model">account.banking.imported.file</field>
2595
108
            <field name="view_type">form</field>
2596
109
            <field name="view_mode">tree,form</field>
2597
110
        </record>
2598
111
2599
112
        <!-- Add a menu item for it -->
2600
113
        <menuitem name="Imported Bank Statements Files"
2601
114
            id="menu_action_account_banking_imported_files"
2602
115
            parent="account_banking.menu_finance_banking_actions"
2603
116
            action="action_account_banking_imported_files"
2604
117
            sequence="12"
2605
118
         />
2606
119
2607
120
        <!-- Add the import wizard to the menu -->
2608
121
        <menuitem name="Import Bank Statements File"
2609
122
            id="menu_account_banking_import_wizard"
2610
123
            parent="account_banking.menu_finance_banking_actions"
2611
124
            type="wizard"
2612
125
            action="wizard_account_banking_import_file"
2613
126
            sequence="15"/>
2614
127
2615
128
        <!-- Create right menu entry to see statements -->
2616
129
        <act_window name="Bank Statements File"
2617
130
            domain="[('banking_id', '=', active_id)]"
2618
131
            res_model="account.banking.imported.file"
2619
132
            src_model="account.bank.statement"
2620
133
            view_type="form"
2621
134
            view_mode="tree,form"
2622
135
            id="act_account_payment_account_bank_statement"/>
2623
136
2624
137
        <!-- Move period_id from bank_statement form to bank_statement_line form
2625
138
        -->
2626
139
        <record id="view_banking_bank_statement_tree_1" model="ir.ui.view">
2627
140
            <field name="name">account.bank.statement.tree.banking</field>
2628
141
            <field name="inherit_id" ref="account.view_bank_statement_tree" />
2629
142
            <field name="model">account.bank.statement</field>
2630
143
            <field name="type">tree</field>
2631
144
            <field name="arch" type="xml">
2632
145
                <field name="period_id" position="replace"/>
2633
146
            </field>
2634
147
        </record>
2635
148
        <record id="view_banking_bank_statement_form_1" model="ir.ui.view">
2636
149
            <field name="name">account.bank.statement.form.banking-1</field>
2637
150
            <field name="inherit_id" ref="account.view_bank_statement_form" />
2638
151
            <field name="model">account.bank.statement</field>
2639
152
            <field name="type">form</field>
2640
153
            <field name="arch" type="xml">
2641
154
                <field name="period_id" position="replace"/>
2642
155
            </field>
2643
156
        </record>
2644
157
        <record id="view_banking_bank_statement_form_2" model="ir.ui.view">
2645
158
            <field name="name">account.bank.statement.form.banking-2</field>
2646
159
            <field name="inherit_id" ref="account.view_bank_statement_form" />
2647
160
            <field name="model">account.bank.statement</field>
2648
161
            <field name="type">form</field>
2649
162
            <field name="arch" type="xml">
2650
163
                <xpath expr="/form/notebook/page[@string='Entry encoding']/field/tree/field[@name='type']" position="after">
2651
164
                    <field name="period_id"/>
2652
165
                </xpath>
2653
166
            </field>
2654
167
        </record>
2655
168
        <record id="view_banking_bank_statement_form_3" model="ir.ui.view">
2656
169
            <field name="name">account.bank.statement.form.banking-3</field>
2657
170
            <field name="inherit_id" ref="account.view_bank_statement_form" />
2658
171
            <field name="model">account.bank.statement</field>
2659
172
            <field name="type">form</field>
2660
173
            <field name="arch" type="xml">
2661
174
                <xpath expr="/form/notebook/page[@string='Entry encoding']/field/form/field[@name='type']" position="after">
2662
175
                    <field name="period_id"/>
2663
176
                </xpath>
2664
177
            </field>
2665
178
        </record>
2666
179
2667
180
        <!-- Reset trigger on button_confirm to the trigger code in this module -->
2668
181
        <record id="view_banking_bank_statement_form_4" model="ir.ui.view">
2669
182
            <field name="name">account.bank.statement.form.banking-4</field>
2670
183
            <field name="inherit_id" ref="account.view_bank_statement_form" />
2671
184
            <field name="model">account.bank.statement</field>
2672
185
            <field name="type">form</field>
2673
186
            <field name="arch" type="xml">
2674
187
                <button name="button_confirm" position="replace">
2675
188
                    <button name="button_confirm" states="draft" string="Confirm" type="object"/>
2676
189
                </button>
2677
190
            </field>
2678
191
        </record>
2679
192
2680
193
        <!-- Make buttons on payment order sensitive for 'Sent' state -->
2681
194
        <record id="view_banking_payment_order_form_1" model="ir.ui.view">
2682
195
            <field name="name">account.payment.order.form.banking-1</field>
2683
196
            <field name="inherit_id" ref="account_payment.view_payment_order_form" />
2684
197
            <field name="model">payment.order</field>
2685
198
            <field name="type">form</field>
2686
199
            <field name="arch" type="xml">
2687
200
                <xpath expr="/form/button[@string='Select Invoices to Pay']"
2688
201
                    position="replace">
2689
202
                    <button name="%(account_payment.wizard_populate_payment)s"
2690
203
                        colspan="2" type="action" states="draft,open"
2691
204
                        string="Select Invoices to Pay"
2692
205
                        />
2693
206
                </xpath>
2694
207
            </field>
2695
208
        </record>
2696
209
2697
210
    </data>
2698
211
</openerp>
2699
0
212
2700
=== added file 'account_banking/account_banking_workflow.xml'
2701
--- account_banking/account_banking_workflow.xml	1970-01-01 00:00:00 +0000
2702
+++ account_banking/account_banking_workflow.xml	2010-03-04 01:53:21 +0000
2703
@@ -0,0 +1,30 @@
2704
1
<?xml version="1.0" encoding="utf-8"?>
2705
2
<!--
2706
3
  Copyright (C) EduSense BV <http://www.edusense.nl>
2707
4
  All rights reserved.
2708
5
  The licence is in the file __terp__.py
2709
6
-->
2710
7
<openerp>
2711
8
    <data>
2712
9
        <!-- New activity for workflow payment order: sent -->
2713
10
        <record id="act_sent" model="workflow.activity">
2714
11
            <field name="name">sent</field>
2715
12
            <field name="wkf_id" ref="account_payment.wkf_payment_order"/>
2716
13
            <field name="action">action_sent()
2717
14
write({'state':'sent'})</field>
2718
15
            <field name="kind">function</field>
2719
16
        </record>
2720
17
        <!-- Add new transition sent -> done -->
2721
18
        <record id="trans_sent_done" model="workflow.transition">
2722
19
            <field name="act_from" ref="act_sent"/>
2723
20
            <field name="act_to" ref="account_payment.act_done"/>
2724
21
            <field name="signal">done</field>
2725
22
        </record>
2726
23
        <!-- Rewrite existing open -> done transition to include 'sent' -->
2727
24
        <record id="account_payment.trans_open_done" model="workflow.transition">
2728
25
            <field name="act_from" ref="account_payment.act_open"/>
2729
26
            <field name="act_to" ref="act_sent"/>
2730
27
            <field name="signal">sent</field>
2731
28
        </record>
2732
29
    </data>
2733
30
</openerp>
2734
0
31
2735
=== added directory 'account_banking/i18n'
2736
=== added file 'account_banking/i18n/account_banking.pot'
2737
--- account_banking/i18n/account_banking.pot	1970-01-01 00:00:00 +0000
2738
+++ account_banking/i18n/account_banking.pot	2010-03-04 01:53:21 +0000
2739
@@ -0,0 +1,562 @@
2740
1
# Translation of OpenERP Server.
2741
2
# This file contains the translation of the following modules:
2742
3
#	* account_banking
2743
4
#
2744
5
msgid ""
2745
6
msgstr ""
2746
7
"Project-Id-Version: OpenERP Server 5.0.7\n"
2747
8
"Report-Msgid-Bugs-To: support@openerp.com\n"
2748
9
"POT-Creation-Date: 2010-01-08 15:30:50+0000\n"
2749
10
"PO-Revision-Date: 2010-01-08 15:30:50+0000\n"
2750
11
"Last-Translator: <>\n"
2751
12
"Language-Team: \n"
2752
13
"MIME-Version: 1.0\n"
2753
14
"Content-Type: text/plain; charset=UTF-8\n"
2754
15
"Content-Transfer-Encoding: \n"
2755
16
"Plural-Forms: \n"
2756
17
2757
18
#. module: account_banking
2758
19
#: wizard_view:account_banking.banking_import,import:0
2759
20
msgid "Results:"
2760
21
msgstr ""
2761
22
2762
23
#. module: account_banking
2763
24
#: code:addons/account_banking/wizard/bank_import.py:0
2764
25
#, python-format
2765
26
msgid "Number of errors found"
2766
27
msgstr ""
2767
28
2768
29
#. module: account_banking
2769
30
#: wizard_view:account_banking.banking_import,init:0
2770
31
msgid "Select the processing details:"
2771
32
msgstr ""
2772
33
2773
34
#. module: account_banking
2774
35
#: constraint:ir.actions.act_window:0
2775
36
msgid "Invalid model name in the action definition."
2776
37
msgstr ""
2777
38
2778
39
#. module: account_banking
2779
40
#: wizard_button:account_banking.banking_import,import,open:0
2780
41
msgid "_Open Statement"
2781
42
msgstr ""
2782
43
2783
44
#. module: account_banking
2784
45
#: field:payment.line,date_done:0
2785
46
msgid "Date Confirmed"
2786
47
msgstr ""
2787
48
2788
49
#. module: account_banking
2789
50
#: wizard_button:account_banking.banking_import,import,end:0
2790
51
msgid "_Close"
2791
52
msgstr ""
2792
53
2793
54
#. module: account_banking
2794
55
#: model:ir.model,name:account_banking.model_account_banking_account_settings
2795
56
msgid "Default Journal for Bank Account"
2796
57
msgstr ""
2797
58
2798
59
#. module: account_banking
2799
60
#: wizard_field:account_banking.banking_import,init,file:0
2800
61
msgid "Statements File"
2801
62
msgstr ""
2802
63
2803
64
#. module: account_banking
2804
65
#: code:addons/account_banking/wizard/banktools.py:0
2805
66
#, python-format
2806
67
msgid "More than one bank account was found with the same number %(account_no)s"
2807
68
msgstr ""
2808
69
2809
70
#. module: account_banking
2810
71
#: code:addons/account_banking/wizard/bank_import.py:0
2811
72
#, python-format
2812
73
msgid "Total number of transactions"
2813
74
msgstr ""
2814
75
2815
76
#. module: account_banking
2816
77
#: code:addons/account_banking/account_banking.py:0
2817
78
#, python-format
2818
79
msgid "Account move line \"%s\" is not valid"
2819
80
msgstr ""
2820
81
2821
82
#. module: account_banking
2822
83
#: help:account.banking.account.settings,default_debit_account_id:0
2823
84
msgid "The account to use when an unexpected payment is received. This can be needed when a customer pays in advance or when no matching invoice can be found. Mind that you can correct movements before confirming them."
2824
85
msgstr ""
2825
86
2826
87
#. module: account_banking
2827
88
#: code:addons/account_banking/wizard/banktools.py:0
2828
89
#, python-format
2829
90
msgid "Bank account %(account_no)s was not found in the database"
2830
91
msgstr ""
2831
92
2832
93
#. module: account_banking
2833
94
#: code:addons/account_banking/wizard/bank_import.py:0
2834
95
#, python-format
2835
96
msgid "Number of transactions skipped due to errors"
2836
97
msgstr ""
2837
98
2838
99
#. module: account_banking
2839
100
#: code:addons/account_banking/account_banking.py:0
2840
101
#, python-format
2841
102
msgid "The expected balance (%.2f) is different '\n"
2842
103
"                      'than the computed one. (%.2f)"
2843
104
msgstr ""
2844
105
2845
106
#. module: account_banking
2846
107
#: code:addons/account_banking/wizard/bank_import.py:0
2847
108
#, python-format
2848
109
msgid "Statement for account %(bank_account)s uses different '\n"
2849
110
"                  'currency than the defined bank journal."
2850
111
msgstr ""
2851
112
2852
113
#. module: account_banking
2853
114
#: code:addons/account_banking/wizard/bank_import.py:0
2854
115
#, python-format
2855
116
msgid "Number of statements skipped due to errors"
2856
117
msgstr ""
2857
118
2858
119
#. module: account_banking
2859
120
#: view:account.banking.account.settings:0
2860
121
msgid "Default Import Settings for Bank Account"
2861
122
msgstr ""
2862
123
2863
124
#. module: account_banking
2864
125
#: help:account.banking.account.settings,default_credit_account_id:0
2865
126
msgid "The account to use when an unexpected payment was signaled. This can happen when a direct debit payment is cancelled by a customer, or when no matching payment can be found.  Mind that you can correct movements before confirming them."
2866
127
msgstr ""
2867
128
2868
129
#. module: account_banking
2869
130
#: code:addons/account_banking/wizard/bank_import.py:0
2870
131
#, python-format
2871
132
msgid "Unable to import parser %(parser)s. Parser class not found."
2872
133
msgstr ""
2873
134
2874
135
#. module: account_banking
2875
136
#: selection:payment.line,export_state:0
2876
137
msgid "Cancelled"
2877
138
msgstr ""
2878
139
2879
140
#. module: account_banking
2880
141
#: view:account.banking.imported.file:0
2881
142
#: field:account.banking.imported.file,statement_ids:0
2882
143
msgid "Statements"
2883
144
msgstr ""
2884
145
2885
146
#. module: account_banking
2886
147
#: field:account.banking.account.settings,default_debit_account_id:0
2887
148
msgid "Default debit account"
2888
149
msgstr ""
2889
150
2890
151
#. module: account_banking
2891
152
#: wizard_button:account_banking.banking_import,init,end:0
2892
153
msgid "_Cancel"
2893
154
msgstr ""
2894
155
2895
156
#. module: account_banking
2896
157
#: selection:payment.line,export_state:0
2897
158
msgid "Draft"
2898
159
msgstr ""
2899
160
2900
161
#. module: account_banking
2901
162
#: field:account.banking.imported.file,date:0
2902
163
msgid "Import Date"
2903
164
msgstr ""
2904
165
2905
166
#. module: account_banking
2906
167
#: selection:payment.line,export_state:0
2907
168
msgid "Confirmed"
2908
169
msgstr ""
2909
170
2910
171
#. module: account_banking
2911
172
#: view:account.banking.account.settings:0
2912
173
msgid "Default Accounts for Unknown Movements"
2913
174
msgstr ""
2914
175
2915
176
#. module: account_banking
2916
177
#: view:account.bank.statement:0
2917
178
msgid "Confirm"
2918
179
msgstr ""
2919
180
2920
181
#. module: account_banking
2921
182
#: field:account.banking.account.settings,default_credit_account_id:0
2922
183
msgid "Default credit account"
2923
184
msgstr ""
2924
185
2925
186
#. module: account_banking
2926
187
#: code:addons/account_banking/wizard/bank_import.py:0
2927
188
#, python-format
2928
189
msgid "Statements found for account %(bank_account)s, '\n"
2929
190
"                      'but no default journal was defined."
2930
191
msgstr ""
2931
192
2932
193
#. module: account_banking
2933
194
#: field:account.bank.statement.line,international:0
2934
195
msgid "International Transaction"
2935
196
msgstr ""
2936
197
2937
198
#. module: account_banking
2938
199
#: code:addons/account_banking/account_banking.py:0
2939
200
#, python-format
2940
201
msgid "Please verify that an account is defined in the journal."
2941
202
msgstr ""
2942
203
2943
204
#. module: account_banking
2944
205
#: field:account.bank.statement.line,trans:0
2945
206
msgid "Bank Transaction ID"
2946
207
msgstr ""
2947
208
2948
209
#. module: account_banking
2949
210
#: code:addons/account_banking/wizard/bank_import.py:0
2950
211
#, python-format
2951
212
msgid "Statement %(id)s known - skipped"
2952
213
msgstr ""
2953
214
2954
215
#. module: account_banking
2955
216
#: selection:payment.line,export_state:0
2956
217
msgid "Sent"
2957
218
msgstr ""
2958
219
2959
220
#. module: account_banking
2960
221
#: code:addons/account_banking/account_banking.py:0
2961
222
#, python-format
2962
223
msgid "Error !"
2963
224
msgstr ""
2964
225
2965
226
#. module: account_banking
2966
227
#: code:addons/account_banking/account_banking.py:0
2967
228
#, python-format
2968
229
msgid "The account entries lines are not in valid state."
2969
230
msgstr ""
2970
231
2971
232
#. module: account_banking
2972
233
#: model:ir.actions.act_window,name:account_banking.action_account_banking_journals
2973
234
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_bank_journals
2974
235
msgid "Default Import Settings for Bank Accounts"
2975
236
msgstr ""
2976
237
2977
238
#. module: account_banking
2978
239
#: model:ir.actions.wizard,name:account_banking.wizard_account_banking_import_file
2979
240
#: model:ir.ui.menu,name:account_banking.menu_account_banking_import_wizard
2980
241
msgid "Import Bank Statements File"
2981
242
msgstr ""
2982
243
2983
244
#. module: account_banking
2984
245
#: help:account_banking.banking_import,init,file:0
2985
246
msgid "The Transactions File to import. Please note that while it is perfectly safe to reload the same file multiple times or to load in timeframe overlapping statements files, there are formats that may introduce different sequencing, which may create double entries.\n"
2986
247
"\n"
2987
248
"To stay on the safe side, always load bank statements files using the same format."
2988
249
msgstr ""
2989
250
2990
251
#. module: account_banking
2991
252
#: constraint:ir.ui.view:0
2992
253
msgid "Invalid XML for View Architecture!"
2993
254
msgstr ""
2994
255
2995
256
#. module: account_banking
2996
257
#: view:account.banking.imported.file:0
2997
258
msgid "Imported Bank Statements"
2998
259
msgstr ""
2999
260
3000
261
#. module: account_banking
3001
262
#: wizard_view:account_banking.banking_import,import:0
3002
263
#: wizard_view:account_banking.banking_import,init:0
3003
264
msgid "Import Bank Transactions File"
3004
265
msgstr ""
3005
266
3006
267
#. module: account_banking
3007
268
#: code:addons/account_banking/wizard/banktools.py:0
3008
269
#, python-format
3009
270
msgid "Account %(account_no)s is not owned by %(partner)s"
3010
271
msgstr ""
3011
272
3012
273
#. module: account_banking
3013
274
#: wizard_button:account_banking.banking_import,init,import:0
3014
275
msgid "_Ok"
3015
276
msgstr ""
3016
277
3017
278
#. module: account_banking
3018
279
#: code:addons/account_banking/wizard/banktools.py:0
3019
280
#, python-format
3020
281
msgid "More then one possible match found for partner with name %(name)s"
3021
282
msgstr ""
3022
283
3023
284
#. module: account_banking
3024
285
#: field:account.banking.imported.file,state:0
3025
286
#: field:payment.line,export_state:0
3026
287
msgid "State"
3027
288
msgstr ""
3028
289
3029
290
#. module: account_banking
3030
291
#: code:addons/account_banking/wizard/bank_import.py:0
3031
292
#, python-format
3032
293
msgid "ERROR!"
3033
294
msgstr ""
3034
295
3035
296
#. module: account_banking
3036
297
#: code:addons/account_banking/wizard/banktools.py:0
3037
298
#, python-format
3038
299
msgid "No suitable period found for date %(date)s"
3039
300
msgstr ""
3040
301
3041
302
#. module: account_banking
3042
303
#: code:addons/account_banking/wizard/banktools.py:0
3043
304
#, python-format
3044
305
msgid "Multiple overlapping periods for date %(date)s"
3045
306
msgstr ""
3046
307
3047
308
#. module: account_banking
3048
309
#: field:account.banking.account.settings,company_id:0
3049
310
#: field:account.banking.imported.file,company_id:0
3050
311
#: wizard_field:account_banking.banking_import,init,company:0
3051
312
msgid "Company"
3052
313
msgstr ""
3053
314
3054
315
#. module: account_banking
3055
316
#: wizard_field:account_banking.banking_import,import,log:0
3056
317
msgid "Log"
3057
318
msgstr ""
3058
319
3059
320
#. module: account_banking
3060
321
#: field:account.banking.imported.file,file:0
3061
322
msgid "Raw Data"
3062
323
msgstr ""
3063
324
3064
325
#. module: account_banking
3065
326
#: code:addons/account_banking/account_banking.py:0
3066
327
#, python-format
3067
328
msgid "Configration Error !"
3068
329
msgstr ""
3069
330
3070
331
#. module: account_banking
3071
332
#: model:ir.module.module,description:account_banking.module_meta_information
3072
333
msgid "\n"
3073
334
"    Module to do banking.\n"
3074
335
"\n"
3075
336
"    This modules tries to combine all current banking import and export\n"
3076
337
"    schemes. Rationale for this is that it is quite common to have foreign\n"
3077
338
"    bank account numbers next to national bank account numbers. The current\n"
3078
339
"    approach, which hides the national banking interface schemes in the\n"
3079
340
"    l10n_xxx modules, makes it very difficult to use these simultanious.\n"
3080
341
"    A more banking oriented approach seems more logical and cleaner.\n"
3081
342
"\n"
3082
343
"    Changes to default OpenERP:\n"
3083
344
"\n"
3084
345
"    * Puts focus on the real life messaging with banks:\n"
3085
346
"      + Bank statement lines upgraded to independent bank transactions.\n"
3086
347
"      + Banking statements have no special accountancy meaning, they're just\n"
3087
348
"        message envelopes for a number of bank transactions.\n"
3088
349
"      + Bank statements can be either encoded by hand to reflect the document\n"
3089
350
"        version of Bank Statements, or created as an optional side effect of\n"
3090
351
"        importing Bank Transactions.\n"
3091
352
"\n"
3092
353
"    * Preparations for SEPA:\n"
3093
354
"      + IBAN accounts are the standard in the SEPA countries\n"
3094
355
"      + local accounts are derived from SEPA (excluding Turkey) but are\n"
3095
356
"        considered to be identical to the corresponding SEPA account.\n"
3096
357
"      + Banks are identified with either Country + Bank code + Branch code or BIC\n"
3097
358
"      + Each bank can have its own pace in introducing SEPA into their\n"
3098
359
"        communication with their customers.\n"
3099
360
"      + National online databases can be used to convert BBAN's to IBAN's.\n"
3100
361
"\n"
3101
362
"    * Adds dropin extensible import facility for bank communication in:\n"
3102
363
"      + MultiBank (NL) format transaction files,\n"
3103
364
"      - (todo) MT940 (Swift) format transaction files,\n"
3104
365
"      - (todo) CODA (BE) format transaction files,\n"
3105
366
"      - (wish) SEPA Credits (ISO 200022) messages,\n"
3106
367
"\n"
3107
368
"    * Extends payments for digital banking:\n"
3108
369
"      + Adapted workflow in payments to reflect banking operations\n"
3109
370
"      + Relies on account_payment mechanics to extend with export generators.\n"
3110
371
"      - ClieOp3 (NL) payment and direct debit orders files available as\n"
3111
372
"        account_banking_nl_clieop\n"
3112
373
"      - (wish) BTL91 (NL) payment orders files (no format description available),\n"
3113
374
"      - (wish) SEPA Direct Debits (ISO 200022) messages\n"
3114
375
"\n"
3115
376
"    * Additional features for the import/export mechanism:\n"
3116
377
"      + Automatic matching and creation of bank accounts, banks and partners,\n"
3117
378
"        during import of statements.\n"
3118
379
"      + Automatic matching with invoices and payments.\n"
3119
380
"      + Sound import mechanism, allowing multiple imports of the same\n"
3120
381
"        transactions repeated over multiple files.\n"
3121
382
"      + Journal configuration per bank account.\n"
3122
383
"      + Business logic and format parsing strictly separated to ease the\n"
3123
384
"        development of new parsers.\n"
3124
385
"      + No special configuration needed for the parsers, new parsers are\n"
3125
386
"        recognized and made available at server (re)start.\n"
3126
387
"    "
3127
388
msgstr ""
3128
389
3129
390
#. module: account_banking
3130
391
#: model:ir.actions.act_window,name:account_banking.act_account_payment_account_bank_statement
3131
392
msgid "Bank Statements File"
3132
393
msgstr ""
3133
394
3134
395
#. module: account_banking
3135
396
#: code:addons/account_banking/parsers/models.py:0
3136
397
#, python-format
3137
398
msgid "This is a stub. Please implement your own."
3138
399
msgstr ""
3139
400
3140
401
#. module: account_banking
3141
402
#: view:account.banking.imported.file:0
3142
403
#: model:ir.actions.act_window,name:account_banking.action_account_banking_imported_files
3143
404
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_imported_files
3144
405
msgid "Imported Bank Statements Files"
3145
406
msgstr ""
3146
407
3147
408
#. module: account_banking
3148
409
#: field:account.bank.statement,banking_id:0
3149
410
msgid "Imported File"
3150
411
msgstr ""
3151
412
3152
413
#. module: account_banking
3153
414
#: view:account.banking.imported.file:0
3154
415
#: field:account.banking.imported.file,log:0
3155
416
msgid "Import Log"
3156
417
msgstr ""
3157
418
3158
419
#. module: account_banking
3159
420
#: code:addons/account_banking/wizard/bank_import.py:0
3160
421
#, python-format
3161
422
msgid "The imported statements appear to be invalid! Check your file."
3162
423
msgstr ""
3163
424
3164
425
#. module: account_banking
3165
426
#: code:addons/account_banking/wizard/bank_import.py:0
3166
427
#, python-format
3167
428
msgid "Number of statements loaded"
3168
429
msgstr ""
3169
430
3170
431
#. module: account_banking
3171
432
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_actions
3172
433
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_settings
3173
434
msgid "Banking"
3174
435
msgstr ""
3175
436
3176
437
#. module: account_banking
3177
438
#: selection:account.banking.imported.file,state:0
3178
439
msgid "Error"
3179
440
msgstr ""
3180
441
3181
442
#. module: account_banking
3182
443
#: code:addons/account_banking/account_banking.py:0
3183
444
#, python-format
3184
445
msgid "Unable to reconcile entry \"%s\": %.2f"
3185
446
msgstr ""
3186
447
3187
448
#. module: account_banking
3188
449
#: view:account.banking.imported.file:0
3189
450
msgid "Import Details"
3190
451
msgstr ""
3191
452
3192
453
#. module: account_banking
3193
454
#: field:account.bank.statement.line,period_id:0
3194
455
msgid "Period"
3195
456
msgstr ""
3196
457
3197
458
#. module: account_banking
3198
459
#: selection:payment.line,export_state:0
3199
460
msgid "Done"
3200
461
msgstr ""
3201
462
3202
463
#. module: account_banking
3203
464
#: view:payment.order:0
3204
465
msgid "Select Invoices to Pay"
3205
466
msgstr ""
3206
467
3207
468
#. module: account_banking
3208
469
#: field:account.banking.imported.file,user_id:0
3209
470
msgid "Responsible User"
3210
471
msgstr ""
3211
472
3212
473
#. module: account_banking
3213
474
#: code:addons/account_banking/account_banking.py:0
3214
475
#, python-format
3215
476
msgid "The statement balance is incorrect !\n"
3216
477
msgstr ""
3217
478
3218
479
#. module: account_banking
3219
480
#: constraint:ir.model:0
3220
481
msgid "The Object name must start with x_ and not contain any special character !"
3221
482
msgstr ""
3222
483
3223
484
#. module: account_banking
3224
485
#: selection:account.banking.imported.file,state:0
3225
486
msgid "Unfinished"
3226
487
msgstr ""
3227
488
3228
489
#. module: account_banking
3229
490
#: code:addons/account_banking/wizard/bank_import.py:0
3230
491
#, python-format
3231
492
msgid "Statements found for unknown account %(bank_account)s"
3232
493
msgstr ""
3233
494
3234
495
#. module: account_banking
3235
496
#: model:ir.module.module,shortdesc:account_banking.module_meta_information
3236
497
msgid "Account Banking"
3237
498
msgstr ""
3238
499
3239
500
#. module: account_banking
3240
501
#: code:addons/account_banking/wizard/bank_import.py:0
3241
502
#, python-format
3242
503
msgid "Total number of statements"
3243
504
msgstr ""
3244
505
3245
506
#. module: account_banking
3246
507
#: field:account.banking.imported.file,format:0
3247
508
#: wizard_field:account_banking.banking_import,init,parser:0
3248
509
msgid "File Format"
3249
510
msgstr ""
3250
511
3251
512
#. module: account_banking
3252
513
#: field:account.banking.account.settings,journal_id:0
3253
514
msgid "Journal"
3254
515
msgstr ""
3255
516
3256
517
#. module: account_banking
3257
518
#: selection:account.banking.imported.file,state:0
3258
519
msgid "Finished"
3259
520
msgstr ""
3260
521
3261
522
#. module: account_banking
3262
523
#: code:addons/account_banking/wizard/banktools.py:0
3263
524
#, python-format
3264
525
msgid "No suitable fiscal year found for company %(company_name)s"
3265
526
msgstr ""
3266
527
3267
528
#. module: account_banking
3268
529
#: view:account.banking.account.settings:0
3269
530
msgid "Bank Account Details"
3270
531
msgstr ""
3271
532
3272
533
#. module: account_banking
3273
534
#: code:addons/account_banking/wizard/bank_import.py:0
3274
535
#, python-format
3275
536
msgid "Unable to link transaction %(trans)s to invoice: '\n"
3276
537
"                  '%(no_candidates)s candidates found; can\'t choose."
3277
538
msgstr ""
3278
539
3279
540
#. module: account_banking
3280
541
#: field:account.bank.statement.line,partner_bank_id:0
3281
542
#: field:account.banking.account.settings,partner_bank_id:0
3282
543
msgid "Bank Account"
3283
544
msgstr ""
3284
545
3285
546
#. module: account_banking
3286
547
#: code:addons/account_banking/wizard/bank_import.py:0
3287
548
#, python-format
3288
549
msgid "Number of transactions loaded"
3289
550
msgstr ""
3290
551
3291
552
#. module: account_banking
3292
553
#: code:addons/account_banking/wizard/banktools.py:0
3293
554
#, python-format
3294
555
msgid "Multiple overlapping fiscal years found for date %(date)s"
3295
556
msgstr ""
3296
557
3297
558
#. module: account_banking
3298
559
#: model:ir.model,name:account_banking.model_account_banking_imported_file
3299
560
msgid "Imported Bank Statements File"
3300
561
msgstr ""
3301
562
3302
0
563
3303
=== added file 'account_banking/i18n/en_US.po'
3304
--- account_banking/i18n/en_US.po	1970-01-01 00:00:00 +0000
3305
+++ account_banking/i18n/en_US.po	2010-03-04 01:53:21 +0000
3306
@@ -0,0 +1,562 @@
3307
1
# Translation of OpenERP Server.
3308
2
# This file contains the translation of the following modules:
3309
3
#	* account_banking
3310
4
#
3311
5
msgid ""
3312
6
msgstr ""
3313
7
"Project-Id-Version: OpenERP Server 5.0.7\n"
3314
8
"Report-Msgid-Bugs-To: support@openerp.com\n"
3315
9
"POT-Creation-Date: 2010-01-08 15:30:50+0000\n"
3316
10
"PO-Revision-Date: 2010-01-08 15:30:50+0000\n"
3317
11
"Last-Translator: <>\n"
3318
12
"Language-Team: \n"
3319
13
"MIME-Version: 1.0\n"
3320
14
"Content-Type: text/plain; charset=UTF-8\n"
3321
15
"Content-Transfer-Encoding: \n"
3322
16
"Plural-Forms: \n"
3323
17
3324
18
#. module: account_banking
3325
19
#: wizard_view:account_banking.banking_import,import:0
3326
20
msgid "Results:"
3327
21
msgstr ""
3328
22
3329
23
#. module: account_banking
3330
24
#: code:addons/account_banking/wizard/bank_import.py:0
3331
25
#, python-format
3332
26
msgid "Number of errors found"
3333
27
msgstr ""
3334
28
3335
29
#. module: account_banking
3336
30
#: wizard_view:account_banking.banking_import,init:0
3337
31
msgid "Select the processing details:"
3338
32
msgstr ""
3339
33
3340
34
#. module: account_banking
3341
35
#: constraint:ir.actions.act_window:0
3342
36
msgid "Invalid model name in the action definition."
3343
37
msgstr ""
3344
38
3345
39
#. module: account_banking
3346
40
#: wizard_button:account_banking.banking_import,import,open:0
3347
41
msgid "_Open Statement"
3348
42
msgstr ""
3349
43
3350
44
#. module: account_banking
3351
45
#: field:payment.line,date_done:0
3352
46
msgid "Date Confirmed"
3353
47
msgstr ""
3354
48
3355
49
#. module: account_banking
3356
50
#: wizard_button:account_banking.banking_import,import,end:0
3357
51
msgid "_Close"
3358
52
msgstr ""
3359
53
3360
54
#. module: account_banking
3361
55
#: model:ir.model,name:account_banking.model_account_banking_account_settings
3362
56
msgid "Default Journal for Bank Account"
3363
57
msgstr ""
3364
58
3365
59
#. module: account_banking
3366
60
#: wizard_field:account_banking.banking_import,init,file:0
3367
61
msgid "Statements File"
3368
62
msgstr ""
3369
63
3370
64
#. module: account_banking
3371
65
#: code:addons/account_banking/wizard/banktools.py:0
3372
66
#, python-format
3373
67
msgid "More than one bank account was found with the same number %(account_no)s"
3374
68
msgstr ""
3375
69
3376
70
#. module: account_banking
3377
71
#: code:addons/account_banking/wizard/bank_import.py:0
3378
72
#, python-format
3379
73
msgid "Total number of transactions"
3380
74
msgstr ""
3381
75
3382
76
#. module: account_banking
3383
77
#: code:addons/account_banking/account_banking.py:0
3384
78
#, python-format
3385
79
msgid "Account move line \"%s\" is not valid"
3386
80
msgstr ""
3387
81
3388
82
#. module: account_banking
3389
83
#: help:account.banking.account.settings,default_debit_account_id:0
3390
84
msgid "The account to use when an unexpected payment is received. This can be needed when a customer pays in advance or when no matching invoice can be found. Mind that you can correct movements before confirming them."
3391
85
msgstr ""
3392
86
3393
87
#. module: account_banking
3394
88
#: code:addons/account_banking/wizard/banktools.py:0
3395
89
#, python-format
3396
90
msgid "Bank account %(account_no)s was not found in the database"
3397
91
msgstr ""
3398
92
3399
93
#. module: account_banking
3400
94
#: code:addons/account_banking/wizard/bank_import.py:0
3401
95
#, python-format
3402
96
msgid "Number of transactions skipped due to errors"
3403
97
msgstr ""
3404
98
3405
99
#. module: account_banking
3406
100
#: code:addons/account_banking/account_banking.py:0
3407
101
#, python-format
3408
102
msgid "The expected balance (%.2f) is different '\n"
3409
103
"                      'than the computed one. (%.2f)"
3410
104
msgstr ""
3411
105
3412
106
#. module: account_banking
3413
107
#: code:addons/account_banking/wizard/bank_import.py:0
3414
108
#, python-format
3415
109
msgid "Statement for account %(bank_account)s uses different '\n"
3416
110
"                  'currency than the defined bank journal."
3417
111
msgstr ""
3418
112
3419
113
#. module: account_banking
3420
114
#: code:addons/account_banking/wizard/bank_import.py:0
3421
115
#, python-format
3422
116
msgid "Number of statements skipped due to errors"
3423
117
msgstr ""
3424
118
3425
119
#. module: account_banking
3426
120
#: view:account.banking.account.settings:0
3427
121
msgid "Default Import Settings for Bank Account"
3428
122
msgstr ""
3429
123
3430
124
#. module: account_banking
3431
125
#: help:account.banking.account.settings,default_credit_account_id:0
3432
126
msgid "The account to use when an unexpected payment was signaled. This can happen when a direct debit payment is cancelled by a customer, or when no matching payment can be found.  Mind that you can correct movements before confirming them."
3433
127
msgstr ""
3434
128
3435
129
#. module: account_banking
3436
130
#: code:addons/account_banking/wizard/bank_import.py:0
3437
131
#, python-format
3438
132
msgid "Unable to import parser %(parser)s. Parser class not found."
3439
133
msgstr ""
3440
134
3441
135
#. module: account_banking
3442
136
#: selection:payment.line,export_state:0
3443
137
msgid "Cancelled"
3444
138
msgstr ""
3445
139
3446
140
#. module: account_banking
3447
141
#: view:account.banking.imported.file:0
3448
142
#: field:account.banking.imported.file,statement_ids:0
3449
143
msgid "Statements"
3450
144
msgstr ""
3451
145
3452
146
#. module: account_banking
3453
147
#: field:account.banking.account.settings,default_debit_account_id:0
3454
148
msgid "Default debit account"
3455
149
msgstr ""
3456
150
3457
151
#. module: account_banking
3458
152
#: wizard_button:account_banking.banking_import,init,end:0
3459
153
msgid "_Cancel"
3460
154
msgstr ""
3461
155
3462
156
#. module: account_banking
3463
157
#: selection:payment.line,export_state:0
3464
158
msgid "Draft"
3465
159
msgstr ""
3466
160
3467
161
#. module: account_banking
3468
162
#: field:account.banking.imported.file,date:0
3469
163
msgid "Import Date"
3470
164
msgstr ""
3471
165
3472
166
#. module: account_banking
3473
167
#: selection:payment.line,export_state:0
3474
168
msgid "Confirmed"
3475
169
msgstr ""
3476
170
3477
171
#. module: account_banking
3478
172
#: view:account.banking.account.settings:0
3479
173
msgid "Default Accounts for Unknown Movements"
3480
174
msgstr ""
3481
175
3482
176
#. module: account_banking
3483
177
#: view:account.bank.statement:0
3484
178
msgid "Confirm"
3485
179
msgstr ""
3486
180
3487
181
#. module: account_banking
3488
182
#: field:account.banking.account.settings,default_credit_account_id:0
3489
183
msgid "Default credit account"
3490
184
msgstr ""
3491
185
3492
186
#. module: account_banking
3493
187
#: code:addons/account_banking/wizard/bank_import.py:0
3494
188
#, python-format
3495
189
msgid "Statements found for account %(bank_account)s, '\n"
3496
190
"                      'but no default journal was defined."
3497
191
msgstr ""
3498
192
3499
193
#. module: account_banking
3500
194
#: field:account.bank.statement.line,international:0
3501
195
msgid "International Transaction"
3502
196
msgstr ""
3503
197
3504
198
#. module: account_banking
3505
199
#: code:addons/account_banking/account_banking.py:0
3506
200
#, python-format
3507
201
msgid "Please verify that an account is defined in the journal."
3508
202
msgstr ""
3509
203
3510
204
#. module: account_banking
3511
205
#: field:account.bank.statement.line,trans:0
3512
206
msgid "Bank Transaction ID"
3513
207
msgstr ""
3514
208
3515
209
#. module: account_banking
3516
210
#: code:addons/account_banking/wizard/bank_import.py:0
3517
211
#, python-format
3518
212
msgid "Statement %(id)s known - skipped"
3519
213
msgstr ""
3520
214
3521
215
#. module: account_banking
3522
216
#: selection:payment.line,export_state:0
3523
217
msgid "Sent"
3524
218
msgstr ""
3525
219
3526
220
#. module: account_banking
3527
221
#: code:addons/account_banking/account_banking.py:0
3528
222
#, python-format
3529
223
msgid "Error !"
3530
224
msgstr ""
3531
225
3532
226
#. module: account_banking
3533
227
#: code:addons/account_banking/account_banking.py:0
3534
228
#, python-format
3535
229
msgid "The account entries lines are not in valid state."
3536
230
msgstr ""
3537
231
3538
232
#. module: account_banking
3539
233
#: model:ir.actions.act_window,name:account_banking.action_account_banking_journals
3540
234
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_bank_journals
3541
235
msgid "Default Import Settings for Bank Accounts"
3542
236
msgstr ""
3543
237
3544
238
#. module: account_banking
3545
239
#: model:ir.actions.wizard,name:account_banking.wizard_account_banking_import_file
3546
240
#: model:ir.ui.menu,name:account_banking.menu_account_banking_import_wizard
3547
241
msgid "Import Bank Statements File"
3548
242
msgstr ""
3549
243
3550
244
#. module: account_banking
3551
245
#: help:account_banking.banking_import,init,file:0
3552
246
msgid "The Transactions File to import. Please note that while it is perfectly safe to reload the same file multiple times or to load in timeframe overlapping statements files, there are formats that may introduce different sequencing, which may create double entries.\n"
3553
247
"\n"
3554
248
"To stay on the safe side, always load bank statements files using the same format."
3555
249
msgstr ""
3556
250
3557
251
#. module: account_banking
3558
252
#: constraint:ir.ui.view:0
3559
253
msgid "Invalid XML for View Architecture!"
3560
254
msgstr ""
3561
255
3562
256
#. module: account_banking
3563
257
#: view:account.banking.imported.file:0
3564
258
msgid "Imported Bank Statements"
3565
259
msgstr ""
3566
260
3567
261
#. module: account_banking
3568
262
#: wizard_view:account_banking.banking_import,import:0
3569
263
#: wizard_view:account_banking.banking_import,init:0
3570
264
msgid "Import Bank Transactions File"
3571
265
msgstr ""
3572
266
3573
267
#. module: account_banking
3574
268
#: code:addons/account_banking/wizard/banktools.py:0
3575
269
#, python-format
3576
270
msgid "Account %(account_no)s is not owned by %(partner)s"
3577
271
msgstr ""
3578
272
3579
273
#. module: account_banking
3580
274
#: wizard_button:account_banking.banking_import,init,import:0
3581
275
msgid "_Ok"
3582
276
msgstr ""
3583
277
3584
278
#. module: account_banking
3585
279
#: code:addons/account_banking/wizard/banktools.py:0
3586
280
#, python-format
3587
281
msgid "More then one possible match found for partner with name %(name)s"
3588
282
msgstr ""
3589
283
3590
284
#. module: account_banking
3591
285
#: field:account.banking.imported.file,state:0
3592
286
#: field:payment.line,export_state:0
3593
287
msgid "State"
3594
288
msgstr ""
3595
289
3596
290
#. module: account_banking
3597
291
#: code:addons/account_banking/wizard/bank_import.py:0
3598
292
#, python-format
3599
293
msgid "ERROR!"
3600
294
msgstr ""
3601
295
3602
296
#. module: account_banking
3603
297
#: code:addons/account_banking/wizard/banktools.py:0
3604
298
#, python-format
3605
299
msgid "No suitable period found for date %(date)s"
3606
300
msgstr ""
3607
301
3608
302
#. module: account_banking
3609
303
#: code:addons/account_banking/wizard/banktools.py:0
3610
304
#, python-format
3611
305
msgid "Multiple overlapping periods for date %(date)s"
3612
306
msgstr ""
3613
307
3614
308
#. module: account_banking
3615
309
#: field:account.banking.account.settings,company_id:0
3616
310
#: field:account.banking.imported.file,company_id:0
3617
311
#: wizard_field:account_banking.banking_import,init,company:0
3618
312
msgid "Company"
3619
313
msgstr ""
3620
314
3621
315
#. module: account_banking
3622
316
#: wizard_field:account_banking.banking_import,import,log:0
3623
317
msgid "Log"
3624
318
msgstr ""
3625
319
3626
320
#. module: account_banking
3627
321
#: field:account.banking.imported.file,file:0
3628
322
msgid "Raw Data"
3629
323
msgstr ""
3630
324
3631
325
#. module: account_banking
3632
326
#: code:addons/account_banking/account_banking.py:0
3633
327
#, python-format
3634
328
msgid "Configration Error !"
3635
329
msgstr ""
3636
330
3637
331
#. module: account_banking
3638
332
#: model:ir.module.module,description:account_banking.module_meta_information
3639
333
msgid "\n"
3640
334
"    Module to do banking.\n"
3641
335
"\n"
3642
336
"    This modules tries to combine all current banking import and export\n"
3643
337
"    schemes. Rationale for this is that it is quite common to have foreign\n"
3644
338
"    bank account numbers next to national bank account numbers. The current\n"
3645
339
"    approach, which hides the national banking interface schemes in the\n"
3646
340
"    l10n_xxx modules, makes it very difficult to use these simultanious.\n"
3647
341
"    A more banking oriented approach seems more logical and cleaner.\n"
3648
342
"\n"
3649
343
"    Changes to default OpenERP:\n"
3650
344
"\n"
3651
345
"    * Puts focus on the real life messaging with banks:\n"
3652
346
"      + Bank statement lines upgraded to independent bank transactions.\n"
3653
347
"      + Banking statements have no special accountancy meaning, they're just\n"
3654
348
"        message envelopes for a number of bank transactions.\n"
3655
349
"      + Bank statements can be either encoded by hand to reflect the document\n"
3656
350
"        version of Bank Statements, or created as an optional side effect of\n"
3657
351
"        importing Bank Transactions.\n"
3658
352
"\n"
3659
353
"    * Preparations for SEPA:\n"
3660
354
"      + IBAN accounts are the standard in the SEPA countries\n"
3661
355
"      + local accounts are derived from SEPA (excluding Turkey) but are\n"
3662
356
"        considered to be identical to the corresponding SEPA account.\n"
3663
357
"      + Banks are identified with either Country + Bank code + Branch code or BIC\n"
3664
358
"      + Each bank can have its own pace in introducing SEPA into their\n"
3665
359
"        communication with their customers.\n"
3666
360
"      + National online databases can be used to convert BBAN's to IBAN's.\n"
3667
361
"\n"
3668
362
"    * Adds dropin extensible import facility for bank communication in:\n"
3669
363
"      + MultiBank (NL) format transaction files,\n"
3670
364
"      - (todo) MT940 (Swift) format transaction files,\n"
3671
365
"      - (todo) CODA (BE) format transaction files,\n"
3672
366
"      - (wish) SEPA Credits (ISO 200022) messages,\n"
3673
367
"\n"
3674
368
"    * Extends payments for digital banking:\n"
3675
369
"      + Adapted workflow in payments to reflect banking operations\n"
3676
370
"      + Relies on account_payment mechanics to extend with export generators.\n"
3677
371
"      - ClieOp3 (NL) payment and direct debit orders files available as\n"
3678
372
"        account_banking_nl_clieop\n"
3679
373
"      - (wish) BTL91 (NL) payment orders files (no format description available),\n"
3680
374
"      - (wish) SEPA Direct Debits (ISO 200022) messages\n"
3681
375
"\n"
3682
376
"    * Additional features for the import/export mechanism:\n"
3683
377
"      + Automatic matching and creation of bank accounts, banks and partners,\n"
3684
378
"        during import of statements.\n"
3685
379
"      + Automatic matching with invoices and payments.\n"
3686
380
"      + Sound import mechanism, allowing multiple imports of the same\n"
3687
381
"        transactions repeated over multiple files.\n"
3688
382
"      + Journal configuration per bank account.\n"
3689
383
"      + Business logic and format parsing strictly separated to ease the\n"
3690
384
"        development of new parsers.\n"
3691
385
"      + No special configuration needed for the parsers, new parsers are\n"
3692
386
"        recognized and made available at server (re)start.\n"
3693
387
"    "
3694
388
msgstr ""
3695
389
3696
390
#. module: account_banking
3697
391
#: model:ir.actions.act_window,name:account_banking.act_account_payment_account_bank_statement
3698
392
msgid "Bank Statements File"
3699
393
msgstr ""
3700
394
3701
395
#. module: account_banking
3702
396
#: code:addons/account_banking/parsers/models.py:0
3703
397
#, python-format
3704
398
msgid "This is a stub. Please implement your own."
3705
399
msgstr ""
3706
400
3707
401
#. module: account_banking
3708
402
#: view:account.banking.imported.file:0
3709
403
#: model:ir.actions.act_window,name:account_banking.action_account_banking_imported_files
3710
404
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_imported_files
3711
405
msgid "Imported Bank Statements Files"
3712
406
msgstr ""
3713
407
3714
408
#. module: account_banking
3715
409
#: field:account.bank.statement,banking_id:0
3716
410
msgid "Imported File"
3717
411
msgstr ""
3718
412
3719
413
#. module: account_banking
3720
414
#: view:account.banking.imported.file:0
3721
415
#: field:account.banking.imported.file,log:0
3722
416
msgid "Import Log"
3723
417
msgstr ""
3724
418
3725
419
#. module: account_banking
3726
420
#: code:addons/account_banking/wizard/bank_import.py:0
3727
421
#, python-format
3728
422
msgid "The imported statements appear to be invalid! Check your file."
3729
423
msgstr ""
3730
424
3731
425
#. module: account_banking
3732
426
#: code:addons/account_banking/wizard/bank_import.py:0
3733
427
#, python-format
3734
428
msgid "Number of statements loaded"
3735
429
msgstr ""
3736
430
3737
431
#. module: account_banking
3738
432
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_actions
3739
433
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_settings
3740
434
msgid "Banking"
3741
435
msgstr ""
3742
436
3743
437
#. module: account_banking
3744
438
#: selection:account.banking.imported.file,state:0
3745
439
msgid "Error"
3746
440
msgstr ""
3747
441
3748
442
#. module: account_banking
3749
443
#: code:addons/account_banking/account_banking.py:0
3750
444
#, python-format
3751
445
msgid "Unable to reconcile entry \"%s\": %.2f"
3752
446
msgstr ""
3753
447
3754
448
#. module: account_banking
3755
449
#: view:account.banking.imported.file:0
3756
450
msgid "Import Details"
3757
451
msgstr ""
3758
452
3759
453
#. module: account_banking
3760
454
#: field:account.bank.statement.line,period_id:0
3761
455
msgid "Period"
3762
456
msgstr ""
3763
457
3764
458
#. module: account_banking
3765
459
#: selection:payment.line,export_state:0
3766
460
msgid "Done"
3767
461
msgstr ""
3768
462
3769
463
#. module: account_banking
3770
464
#: view:payment.order:0
3771
465
msgid "Select Invoices to Pay"
3772
466
msgstr ""
3773
467
3774
468
#. module: account_banking
3775
469
#: field:account.banking.imported.file,user_id:0
3776
470
msgid "Responsible User"
3777
471
msgstr ""
3778
472
3779
473
#. module: account_banking
3780
474
#: code:addons/account_banking/account_banking.py:0
3781
475
#, python-format
3782
476
msgid "The statement balance is incorrect !\n"
3783
477
msgstr ""
3784
478
3785
479
#. module: account_banking
3786
480
#: constraint:ir.model:0
3787
481
msgid "The Object name must start with x_ and not contain any special character !"
3788
482
msgstr ""
3789
483
3790
484
#. module: account_banking
3791
485
#: selection:account.banking.imported.file,state:0
3792
486
msgid "Unfinished"
3793
487
msgstr ""
3794
488
3795
489
#. module: account_banking
3796
490
#: code:addons/account_banking/wizard/bank_import.py:0
3797
491
#, python-format
3798
492
msgid "Statements found for unknown account %(bank_account)s"
3799
493
msgstr ""
3800
494
3801
495
#. module: account_banking
3802
496
#: model:ir.module.module,shortdesc:account_banking.module_meta_information
3803
497
msgid "Account Banking"
3804
498
msgstr ""
3805
499
3806
500
#. module: account_banking
3807
501
#: code:addons/account_banking/wizard/bank_import.py:0
3808
502
#, python-format
3809
503
msgid "Total number of statements"
3810
504
msgstr ""
3811
505
3812
506
#. module: account_banking
3813
507
#: field:account.banking.imported.file,format:0
3814
508
#: wizard_field:account_banking.banking_import,init,parser:0
3815
509
msgid "File Format"
3816
510
msgstr ""
3817
511
3818
512
#. module: account_banking
3819
513
#: field:account.banking.account.settings,journal_id:0
3820
514
msgid "Journal"
3821
515
msgstr ""
3822
516
3823
517
#. module: account_banking
3824
518
#: selection:account.banking.imported.file,state:0
3825
519
msgid "Finished"
3826
520
msgstr ""
3827
521
3828
522
#. module: account_banking
3829
523
#: code:addons/account_banking/wizard/banktools.py:0
3830
524
#, python-format
3831
525
msgid "No suitable fiscal year found for company %(company_name)s"
3832
526
msgstr ""
3833
527
3834
528
#. module: account_banking
3835
529
#: view:account.banking.account.settings:0
3836
530
msgid "Bank Account Details"
3837
531
msgstr ""
3838
532
3839
533
#. module: account_banking
3840
534
#: code:addons/account_banking/wizard/bank_import.py:0
3841
535
#, python-format
3842
536
msgid "Unable to link transaction %(trans)s to invoice: '\n"
3843
537
"                  '%(no_candidates)s candidates found; can\'t choose."
3844
538
msgstr ""
3845
539
3846
540
#. module: account_banking
3847
541
#: field:account.bank.statement.line,partner_bank_id:0
3848
542
#: field:account.banking.account.settings,partner_bank_id:0
3849
543
msgid "Bank Account"
3850
544
msgstr ""
3851
545
3852
546
#. module: account_banking
3853
547
#: code:addons/account_banking/wizard/bank_import.py:0
3854
548
#, python-format
3855
549
msgid "Number of transactions loaded"
3856
550
msgstr ""
3857
551
3858
552
#. module: account_banking
3859
553
#: code:addons/account_banking/wizard/banktools.py:0
3860
554
#, python-format
3861
555
msgid "Multiple overlapping fiscal years found for date %(date)s"
3862
556
msgstr ""
3863
557
3864
558
#. module: account_banking
3865
559
#: model:ir.model,name:account_banking.model_account_banking_imported_file
3866
560
msgid "Imported Bank Statements File"
3867
561
msgstr ""
3868
562
3869
0
563
3870
=== added file 'account_banking/i18n/nl_NL.po'
3871
--- account_banking/i18n/nl_NL.po	1970-01-01 00:00:00 +0000
3872
+++ account_banking/i18n/nl_NL.po	2010-03-04 01:53:21 +0000
3873
@@ -0,0 +1,607 @@
3874
1
# Translation of OpenERP Server.
3875
2
# This file contains the translation of the following modules:
3876
3
#	* account_banking
3877
4
#
3878
5
msgid ""
3879
6
msgstr ""
3880
7
"Project-Id-Version: OpenERP Server 5.0.7\n"
3881
8
"Report-Msgid-Bugs-To: support@openerp.com\n"
3882
9
"POT-Creation-Date: 2010-01-08 15:18:44+0000\n"
3883
10
"PO-Revision-Date: 2010-01-08 15:18:44+0000\n"
3884
11
"Last-Translator: <>\n"
3885
12
"Language-Team: \n"
3886
13
"MIME-Version: 1.0\n"
3887
14
"Content-Type: text/plain; charset=UTF-8\n"
3888
15
"Content-Transfer-Encoding: \n"
3889
16
"Plural-Forms: \n"
3890
17
3891
18
#. module: account_banking
3892
19
#: wizard_view:account_banking.banking_import,import:0
3893
20
msgid "Results:"
3894
21
msgstr "Resultaat:"
3895
22
3896
23
#. module: account_banking
3897
24
#: code:addons/account_banking/wizard/bank_import.py:0
3898
25
#, python-format
3899
26
msgid "Number of errors found"
3900
27
msgstr "Aantal gevonden fouten"
3901
28
3902
29
#. module: account_banking
3903
30
#: wizard_view:account_banking.banking_import,init:0
3904
31
msgid "Select the processing details:"
3905
32
msgstr "Kies de verwerkings-details:"
3906
33
3907
34
#. module: account_banking
3908
35
#: constraint:ir.actions.act_window:0
3909
36
msgid "Invalid model name in the action definition."
3910
37
msgstr "Ongeldige naam in actie-definitie."
3911
38
3912
39
#. module: account_banking
3913
40
#: wizard_button:account_banking.banking_import,import,open:0
3914
41
msgid "_Open Statement"
3915
42
msgstr "_Open bankafschriften"
3916
43
3917
44
#. module: account_banking
3918
45
#: field:payment.line,date_done:0
3919
46
msgid "Date Confirmed"
3920
47
msgstr "Bevestigingsdatum"
3921
48
3922
49
#. module: account_banking
3923
50
#: wizard_button:account_banking.banking_import,import,end:0
3924
51
msgid "_Close"
3925
52
msgstr "_Sluit"
3926
53
3927
54
#. module: account_banking
3928
55
#: model:ir.model,name:account_banking.model_account_banking_account_settings
3929
56
msgid "Default Journal for Bank Account"
3930
57
msgstr "Standaard dagboek voor bankrekening"
3931
58
3932
59
#. module: account_banking
3933
60
#: wizard_field:account_banking.banking_import,init,file:0
3934
61
msgid "Statements File"
3935
62
msgstr "Transactiebestand"
3936
63
3937
64
#. module: account_banking
3938
65
#: code:addons/account_banking/wizard/banktools.py:0
3939
66
#, python-format
3940
67
msgid "More than one bank account was found with the same number %(account_no)s"
3941
68
msgstr "Meer dan Ã©Ã©n bankrekening gevonden met hetzelfde rekeningnummer %(account_no)s"
3942
69
3943
70
#. module: account_banking
3944
71
#: code:addons/account_banking/wizard/bank_import.py:0
3945
72
#, python-format
3946
73
msgid "Total number of transactions"
3947
74
msgstr "Totaal aantal transacties"
3948
75
3949
76
#. module: account_banking
3950
77
#: code:addons/account_banking/account_banking.py:0
3951
78
#, python-format
3952
79
msgid "Account move line \"%s\" is not valid"
3953
80
msgstr "Boekingsregel \"%s\" is onjuist."
3954
81
3955
82
#. module: account_banking
3956
83
#: help:account.banking.account.settings,default_debit_account_id:0
3957
84
msgid "The account to use when an unexpected payment is received. This can be needed when a customer pays in advance or when no matching invoice can be found. Mind that you can correct movements before confirming them."
3958
85
msgstr "De rekening waarop geboekt moet worden bij onverwachte betalingen. Dit kan nodig zijn als een klant vooruit betaalt of wanneer er geen overeenkomende factuur gevonden kan worden. Merk op dat u altijd boekingen kunt corrigeren voordat u deze bevestigt."
3959
86
3960
87
#. module: account_banking
3961
88
#: code:addons/account_banking/wizard/banktools.py:0
3962
89
#, python-format
3963
90
msgid "Bank account %(account_no)s was not found in the database"
3964
91
msgstr "Bankrekening %(account)s niet gevonden in de database"
3965
92
3966
93
#. module: account_banking
3967
94
#: code:addons/account_banking/wizard/bank_import.py:0
3968
95
#, python-format
3969
96
msgid "Number of transactions skipped due to errors"
3970
97
msgstr "Aantal overgeslagen transacties als gevolg van fouten"
3971
98
3972
99
#. module: account_banking
3973
100
#: code:addons/account_banking/account_banking.py:0
3974
101
#, python-format
3975
102
msgid "The expected balance (%.2f) is different '\n"
3976
103
"                      'than the computed one. (%.2f)"
3977
104
msgstr "Het verwachte saldo (%.2f) wijkt af van het berekende- (%.2f)."
3978
105
3979
106
#. module: account_banking
3980
107
#: code:addons/account_banking/wizard/bank_import.py:0
3981
108
#, python-format
3982
109
msgid "Statement for account %(bank_account)s uses different '\n"
3983
110
"                  'currency than the defined bank journal."
3984
111
msgstr "Afschrift voor bankrekening %(account)s gebruik andere valuta dan opgegeven in het bankdagboek."
3985
112
3986
113
#. module: account_banking
3987
114
#: code:addons/account_banking/wizard/bank_import.py:0
3988
115
#, python-format
3989
116
msgid "Number of statements skipped due to errors"
3990
117
msgstr "Aantal afschriften overgeslagen door fouten"
3991
118
3992
119
#. module: account_banking
3993
120
#: view:account.banking.account.settings:0
3994
121
msgid "Default Import Settings for Bank Account"
3995
122
msgstr "Standaardinstellingen voor bankrekeningen"
3996
123
3997
124
#. module: account_banking
3998
125
#: help:account.banking.account.settings,default_credit_account_id:0
3999
126
msgid "The account to use when an unexpected payment was signaled. This can happen when a direct debit payment is cancelled by a customer, or when no matching payment can be found.  Mind that you can correct movements before confirming them."
4000
127
msgstr "De te gebruiken rekening bij onverwachte betalingen. Dit kan voorkomen indien een incasso-opdracht door een klant is geannuleerd, of wanneer er geen overeenkomende betaling kan worden gevonden. Merk op dat u altijd boekingen kunt corrigeren voordat u deze bevestigt."
4001
128
4002
129
#. module: account_banking
4003
130
#: code:addons/account_banking/wizard/bank_import.py:0
4004
131
#, python-format
4005
132
msgid "Unable to import parser %(parser)s. Parser class not found."
4006
133
msgstr "Niet in staat parser %(parser)s te importeren. Parser class niet gevonden."
4007
134
4008
135
#. module: account_banking
4009
136
#: selection:payment.line,export_state:0
4010
137
msgid "Cancelled"
4011
138
msgstr "Geannuleerd"
4012
139
4013
140
#. module: account_banking
4014
141
#: view:account.banking.imported.file:0
4015
142
#: field:account.banking.imported.file,statement_ids:0
4016
143
msgid "Statements"
4017
144
msgstr "Afschriften"
4018
145
4019
146
#. module: account_banking
4020
147
#: field:account.banking.account.settings,default_debit_account_id:0
4021
148
msgid "Default debit account"
4022
149
msgstr "Standaard debet-rekening"
4023
150
4024
151
#. module: account_banking
4025
152
4026
153
#. module: account_banking
4027
154
#: field:account.banking.imported.file,date:0
4028
155
msgid "Import Date"
4029
156
msgstr "Importdatum"
4030
157
4031
158
#. module: account_banking
4032
159
#: selection:payment.line,export_state:0
4033
160
msgid "Confirmed"
4034
161
msgstr "Bevestigd"
4035
162
4036
163
#. module: account_banking
4037
164
#: view:account.banking.account.settings:0
4038
165
msgid "Default Accounts for Unknown Movements"
4039
166
msgstr "Standaard rekeningen voor onverwachte mutaties"
4040
167
4041
168
#. module: account_banking
4042
169
#: view:account.bank.statement:0
4043
170
msgid "Confirm"
4044
171
msgstr "Bevestig"
4045
172
4046
173
#. module: account_banking
4047
174
#: field:account.banking.account.settings,default_credit_account_id:0
4048
175
msgid "Default credit account"
4049
176
msgstr "Standaard credit-rekening"
4050
177
4051
178
#. module: account_banking
4052
179
#: code:addons/account_banking/wizard/bank_import.py:0
4053
180
#, python-format
4054
181
msgid "Statements found for account %(bank_account)s, '\n"
4055
182
"                      'but no default journal was defined."
4056
183
msgstr "Afschriften gevonden voor bankrekening %(bank_account)s, maar geen gedefinieerd dagboek gevonden hiervoor."
4057
184
4058
185
#. module: account_banking
4059
186
#: field:account.bank.statement.line,international:0
4060
187
msgid "International Transaction"
4061
188
msgstr "Internationale transactie"
4062
189
4063
190
#. module: account_banking
4064
191
#: code:addons/account_banking/account_banking.py:0
4065
192
#, python-format
4066
193
msgid "Please verify that an account is defined in the journal."
4067
194
msgstr "Controleer alstublieft of een rekening is opgegeven in het journaal"
4068
195
4069
196
#. module: account_banking
4070
197
#: field:account.bank.statement.line,trans:0
4071
198
msgid "Bank Transaction ID"
4072
199
msgstr "Transactie ID bank"
4073
200
4074
201
#. module: account_banking
4075
202
#: code:addons/account_banking/wizard/bank_import.py:0
4076
203
#, python-format
4077
204
msgid "Statement %(id)s known - skipped"
4078
205
msgstr "Afschrift %(id)s al bekend - overgeslagen"
4079
206
4080
207
#. module: account_banking
4081
208
#: selection:payment.line,export_state:0
4082
209
msgid "Sent"
4083
210
msgstr "Verzonden"
4084
211
4085
212
#. module: account_banking
4086
213
#: code:addons/account_banking/account_banking.py:0
4087
214
#, python-format
4088
215
msgid "Error !"
4089
216
msgstr "Fout !"
4090
217
4091
218
#. module: account_banking
4092
219
#: code:addons/account_banking/account_banking.py:0
4093
220
#, python-format
4094
221
msgid "The account entries lines are not in valid state."
4095
222
msgstr "De boekingsregels zijn niet geldig."
4096
223
4097
224
#. module: account_banking
4098
225
#: model:ir.actions.act_window,name:account_banking.action_account_banking_journals
4099
226
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_bank_journals
4100
227
msgid "Default Import Settings for Bank Accounts"
4101
228
msgstr "Standaardinstellingen voor bankrekeningen"
4102
229
4103
230
#. module: account_banking
4104
231
#: model:ir.actions.wizard,name:account_banking.wizard_account_banking_import_file
4105
232
#: model:ir.ui.menu,name:account_banking.menu_account_banking_import_wizard
4106
233
msgid "Import Bank Statements File"
4107
234
msgstr "Importeer bankafschrift bestand"
4108
235
4109
236
#. module: account_banking
4110
237
#: help:account_banking.banking_import,init,file:0
4111
238
msgid "The Transactions File to import. Please note that while it is perfectly safe to reload the same file multiple times or to load in timeframe overlapping statements files, there are formats that may introduce different sequencing, which may create double entries.\n"
4112
239
"\n"
4113
240
"To stay on the safe side, always load bank statements files using the same format."
4114
241
msgstr "Het te importeren transactiebestand. Let alstublieft op: hoewel het zondermeer veilig is om hetzelfde bestand meerdere keren te importeren of om in tijd overlappende bestanden te importeren, zijn er formaten die een ander nummeringsschema introduceren, wat tot problemen kan leiden.\n"
4115
242
"\n"
4116
243
"Om aan de veilige kant te blijven, importeer altijd transactiebestanden in hetzelfde formaat."
4117
244
4118
245
#. module: account_banking
4119
246
#: constraint:ir.ui.view:0
4120
247
msgid "Invalid XML for View Architecture!"
4121
248
msgstr "Ongeldige XML voor overzicht"
4122
249
4123
250
#. module: account_banking
4124
251
#: view:account.banking.imported.file:0
4125
252
msgid "Imported Bank Statements"
4126
253
msgstr "GeÃ¯mporteerde bankafschriften"
4127
254
4128
255
#. module: account_banking
4129
256
#: wizard_view:account_banking.banking_import,import:0
4130
257
#: wizard_view:account_banking.banking_import,init:0
4131
258
msgid "Import Bank Transactions File"
4132
259
msgstr "Importeer banktransacties-bestand"
4133
260
4134
261
#. module: account_banking
4135
262
#: code:addons/account_banking/wizard/banktools.py:0
4136
263
#, python-format
4137
264
msgid "Account %(account_no)s is not owned by %(partner)s"
4138
265
msgstr "Rekening %(account_no)s is geen eigendom van %(partner)s"
4139
266
4140
267
#. module: account_banking
4141
268
#: wizard_button:account_banking.banking_import,init,import:0
4142
269
msgid "_Ok"
4143
270
msgstr "_Ok"
4144
271
4145
272
#. module: account_banking
4146
273
#: code:addons/account_banking/wizard/banktools.py:0
4147
274
#, python-format
4148
275
msgid "More then one possible match found for partner with name %(name)s"
4149
276
msgstr "Meer dan Ã©Ã©n mogelijke match gevonden voor partner met naam %(name)s"
4150
277
4151
278
#. module: account_banking
4152
279
#: field:account.banking.imported.file,state:0
4153
280
#: field:payment.line,export_state:0
4154
281
msgid "State"
4155
282
msgstr "Status"
4156
283
4157
284
4158
285
#. module: account_banking
4159
286
#: code:addons/account_banking/wizard/banktools.py:0
4160
287
#, python-format
4161
288
msgid "No suitable period found for date %(date)s"
4162
289
msgstr "Geen geschikte periode gevonden voor datum %(date)s"
4163
290
4164
291
#. module: account_banking
4165
292
#: code:addons/account_banking/wizard/banktools.py:0
4166
293
#, python-format
4167
294
msgid "Multiple overlapping periods for date %(date)s"
4168
295
msgstr "Meerdere overlappende periodes gevonden voor datum %(date)s"
4169
296
4170
297
#. module: account_banking
4171
298
#: field:account.banking.account.settings,company_id:0
4172
299
#: field:account.banking.imported.file,company_id:0
4173
300
#: wizard_field:account_banking.banking_import,init,company:0
4174
301
msgid "Company"
4175
302
msgstr "Bedrijf"
4176
303
4177
304
#. module: account_banking
4178
305
#: wizard_field:account_banking.banking_import,import,log:0
4179
306
msgid "Log"
4180
307
msgstr "Logboek"
4181
308
4182
309
#. module: account_banking
4183
310
#: field:account.banking.imported.file,file:0
4184
311
msgid "Raw Data"
4185
312
msgstr "Ruwe data"
4186
313
4187
314
#. module: account_banking
4188
315
#: code:addons/account_banking/account_banking.py:0
4189
316
#, python-format
4190
317
msgid "Configration Error !"
4191
318
msgstr "Instellingsfout!"
4192
319
4193
320
#. module: account_banking
4194
321
#: model:ir.module.module,description:account_banking.module_meta_information
4195
322
msgid "\n"
4196
323
"    Module to do banking.\n"
4197
324
"\n"
4198
325
"    This modules tries to combine all current banking import and export\n"
4199
326
"    schemes. Rationale for this is that it is quite common to have foreign\n"
4200
327
"    bank account numbers next to national bank account numbers. The current\n"
4201
328
"    approach, which hides the national banking interface schemes in the\n"
4202
329
"    l10n_xxx modules, makes it very difficult to use these simultanious.\n"
4203
330
"    A more banking oriented approach seems more logical and cleaner.\n"
4204
331
"\n"
4205
332
"    Changes to default OpenERP:\n"
4206
333
"\n"
4207
334
"    * Puts focus on the real life messaging with banks:\n"
4208
335
"      + Bank statement lines upgraded to independent bank transactions.\n"
4209
336
"      + Banking statements have no special accountancy meaning, they're just\n"
4210
337
"        message envelopes for a number of bank transactions.\n"
4211
338
"      + Bank statements can be either encoded by hand to reflect the document\n"
4212
339
"        version of Bank Statements, or created as an optional side effect of\n"
4213
340
"        importing Bank Transactions.\n"
4214
341
"\n"
4215
342
"    * Preparations for SEPA:\n"
4216
343
"      + IBAN accounts are the standard in the SEPA countries\n"
4217
344
"      + local accounts are derived from SEPA (excluding Turkey) but are\n"
4218
345
"        considered to be identical to the corresponding SEPA account.\n"
4219
346
"      + Banks are identified with either Country + Bank code + Branch code or BIC\n"
4220
347
"      + Each bank can have its own pace in introducing SEPA into their\n"
4221
348
"        communication with their customers.\n"
4222
349
"      + National online databases can be used to convert BBAN's to IBAN's.\n"
4223
350
"\n"
4224
351
"    * Adds dropin extensible import facility for bank communication in:\n"
4225
352
"      + MultiBank (NL) format transaction files,\n"
4226
353
"      - (todo) MT940 (Swift) format transaction files,\n"
4227
354
"      - (todo) CODA (BE) format transaction files,\n"
4228
355
"      - (wish) SEPA Credits (ISO 200022) messages,\n"
4229
356
"\n"
4230
357
"    * Extends payments for digital banking:\n"
4231
358
"      + Adapted workflow in payments to reflect banking operations\n"
4232
359
"      + Relies on account_payment mechanics to extend with export generators.\n"
4233
360
"      - ClieOp3 (NL) payment and direct debit orders files available as\n"
4234
361
"        account_banking_nl_clieop\n"
4235
362
"      - (wish) BTL91 (NL) payment orders files (no format description available),\n"
4236
363
"      - (wish) SEPA Direct Debits (ISO 200022) messages\n"
4237
364
"\n"
4238
365
"    * Additional features for the import/export mechanism:\n"
4239
366
"      + Automatic matching and creation of bank accounts, banks and partners,\n"
4240
367
"        during import of statements.\n"
4241
368
"      + Automatic matching with invoices and payments.\n"
4242
369
"      + Sound import mechanism, allowing multiple imports of the same\n"
4243
370
"        transactions repeated over multiple files.\n"
4244
371
"      + Journal configuration per bank account.\n"
4245
372
"      + Business logic and format parsing strictly separated to ease the\n"
4246
373
"        development of new parsers.\n"
4247
374
"      + No special configuration needed for the parsers, new parsers are\n"
4248
375
"        recognized and made available at server (re)start.\n"
4249
376
"    "
4250
377
msgstr "    Module voor bankzaken.\n"
4251
378
"\n"
4252
379
"    Deze module probeert alle bestaande bankimport- en -exportschema's\n"
4253
380
"    te combineren. Ratio hierachter is dat het vrij gebruikelijk is om\n"
4254
381
"    buitenlandse bankrekeningen te hebben naast nationale-. De huidige\n"
4255
382
"    benadering waarbij nationale bankinterfaces ondergebracht worden in\n"
4256
383
"    de l10n_xxx modules, maakt het zeer lastig om deze naast elkaar te\n"
4257
384
"    gebruiken. Een meer bank-geÃ¶riÃ«nteerde benadering lijkt logischer en\n"
4258
385
"    'schoner'.\n"
4259
386
"\n"
4260
387
"    Wijzigingen op standaard OpenERP:\n"
4261
388
"\n"
4262
389
"    * Legt focus op berichtuitwisseling met banken:\n"
4263
390
"      + Bankafschriftregels opgewaardeerd naar onafhankelijke banktransacties.\n"
4264
391
"      + Bankafschriften hebben geen speciale accountancy-betekenis, ze zijn\n"
4265
392
"        slechts enveloppen voor een reeks banktransacties.\n"
4266
393
"      + Bankafschriften kunnen hetzij met de hand worden ingevoerd als projectie\n"
4267
394
"        van de papieren versie, of gemaakt worden als neveneffect van het\n"
4268
395
"        importeren van banktransacties.\n"
4269
396
"\n"
4270
397
"    * Voorbereidingen voor SEPA:\n"
4271
398
"      + IBAN bankrekeningen zijn de standaard in de SEPA-landen\n"
4272
399
"      + lokale bankrekeningen worden afgeleid van SEPA (uitgezonderd Turkije)\n"
4273
400
"        maar worden beschouwd als identiek aan de corresponderende IBAN-rekening.\n"
4274
401
"      + Banken worden geÃ¯dentificeerd met hetzij land + bankcode + branchcode of BIC\n"
4275
402
"      - Each bank can have its own pace in introducing SEPA into their\n"
4276
403
"        communication with their customers.\n"
4277
404
"      + Nationale online databases kunnen gebruikt worden om BBAN's naar IBAN's te\n"
4278
405
"        converteren.\n"
4279
406
"\n"
4280
407
"    * Geeft dropin uitbreidbare importvoorzieningen voor bankcommunicatie in:\n"
4281
408
"      + MultiBank (NL) formaat transactiebestanden,\n"
4282
409
"      - (todo) MT940 (Swift) formaat transactiebestanden,\n"
4283
410
"      - (todo) CODA (BE) formaat transactiebestanden,\n"
4284
411
"      - (wish) SEPA Credits (ISO 200022) berichten,\n"
4285
412
"\n"
4286
413
"    * Breidt betalingen uit voor digitaal bankieren:\n"
4287
414
"      + Werkstroom in betalingen aangepast voor bank-operaties\n"
4288
415
"      + Bouwt op account_payment mechanieken voor uitbreidingen met export generatoren.\n"
4289
416
"      - ClieOp3 (NL) betalings- en incasso-opdrachten beschikbaar in de\n"
4290
417
"        account_banking_nl_clieop module\n"
4291
418
"      - (wish) BTL91 (NL) batalingsopdrachten (geen formaatbeschrijving beschikbaar),\n"
4292
419
"      - (wish) SEPA Direct Debits (ISO 200022) berichten\n"
4293
420
"\n"
4294
421
"    * Toegevoegde mogelijkheden voor het import/export mechanisme:\n"
4295
422
"      + Automatische koppeling en aanmaken van bankrekeningen, banken en relaties\n"
4296
423
"        tijdens het importeren van transacties.\n"
4297
424
"      + Automatisch koppelen met facturen en betalingen.\n"
4298
425
"      + Solide importmechanisme dat meerdere imports van dezelfde transacties over\n"
4299
426
"        over meerdere bestanden toestaat.\n"
4300
427
"      + Dagboek-instellingen per bankrekening.\n"
4301
428
"      + Business logica en bestands-parsing strikt gescheiden om de ontwikkeling\n"
4302
429
"        van nieuwe parsers te vergemakkelijken\n"
4303
430
"      + Geen speciale configuratie nodig voor de parsers, nieuwe parsers worden\n"
4304
431
"        herkend en beschikbaar gemaakt voor gebuikers bij server(her)start.\n"
4305
432
"    "
4306
433
4307
434
#. module: account_banking
4308
435
#: model:ir.actions.act_window,name:account_banking.act_account_payment_account_bank_statement
4309
436
msgid "Bank Statements File"
4310
437
msgstr "Bankafschrift bestand"
4311
438
4312
439
#. module: account_banking
4313
440
#: code:addons/account_banking/parsers/models.py:0
4314
441
#, python-format
4315
442
msgid "This is a stub. Please implement your own."
4316
443
msgstr "Dit is een stub. Maak alstublieft uw eigen versie."
4317
444
4318
445
#. module: account_banking
4319
446
#: view:account.banking.imported.file:0
4320
447
#: model:ir.actions.act_window,name:account_banking.action_account_banking_imported_files
4321
448
#: model:ir.ui.menu,name:account_banking.menu_action_account_banking_imported_files
4322
449
msgid "Imported Bank Statements Files"
4323
450
msgstr "GeÃ¯mporteerde bankafschrift bestanden"
4324
451
4325
452
#. module: account_banking
4326
453
#: field:account.bank.statement,banking_id:0
4327
454
msgid "Imported File"
4328
455
msgstr "GeÃ¯mporteerd bestand"
4329
456
4330
457
#. module: account_banking
4331
458
#: view:account.banking.imported.file:0
4332
459
#: field:account.banking.imported.file,log:0
4333
460
msgid "Import Log"
4334
461
msgstr "Import log"
4335
462
4336
463
#. module: account_banking
4337
464
#: code:addons/account_banking/wizard/bank_import.py:0
4338
465
#, python-format
4339
466
msgid "The imported statements appear to be invalid! Check your file."
4340
467
msgstr "De geÃ¯mporteerde afschriften lijken onjuist! Controleer uw bestand."
4341
468
4342
469
#. module: account_banking
4343
470
#: code:addons/account_banking/wizard/bank_import.py:0
4344
471
#, python-format
4345
472
msgid "Number of statements loaded"
4346
473
msgstr "Aantal geladen afschriften"
4347
474
4348
475
#. module: account_banking
4349
476
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_actions
4350
477
#: model:ir.ui.menu,name:account_banking.menu_finance_banking_settings
4351
478
msgid "Banking"
4352
479
msgstr "Bankzaken"
4353
480
4354
481
#. module: account_banking
4355
482
#: selection:account.banking.imported.file,state:0
4356
483
msgid "Error"
4357
484
msgstr "Fout"
4358
485
4359
486
#. module: account_banking
4360
487
#: code:addons/account_banking/account_banking.py:0
4361
488
#, python-format
4362
489
msgid "Unable to reconcile entry \"%s\": %.2f"
4363
490
msgstr "Niet in staat boeking af te letteren \"%s\": %.2f"
4364
491
4365
492
#. module: account_banking
4366
493
#: view:account.banking.imported.file:0
4367
494
msgid "Import Details"
4368
495
msgstr "Details import"
4369
496
4370
497
#. module: account_banking
4371
498
#: field:account.bank.statement.line,period_id:0
4372
499
msgid "Period"
4373
500
msgstr "Periode"
4374
501
4375
502
#. module: account_banking
4376
503
#: selection:payment.line,export_state:0
4377
504
msgid "Done"
4378
505
msgstr "Verwerkt"
4379
506
4380
507
#. module: account_banking
4381
508
#: view:payment.order:0
4382
509
msgid "Select Invoices to Pay"
4383
510
msgstr "Kies te betalen facturen"
4384
511
4385
512
#. module: account_banking
4386
513
#: field:account.banking.imported.file,user_id:0
4387
514
msgid "Responsible User"
4388
515
msgstr "Verantwoordelijke gebruiker"
4389
516
4390
517
#. module: account_banking
4391
518
#: code:addons/account_banking/account_banking.py:0
4392
519
#, python-format
4393
520
msgid "The statement balance is incorrect !\n"
4394
521
msgstr "Het saldo op het afschrift is onjuist!\n"
4395
522
4396
523
#. module: account_banking
4397
524
#: constraint:ir.model:0
4398
525
msgid "The Object name must start with x_ and not contain any special character !"
4399
526
msgstr "De objectnaam moet beginnen met x_ en mag geen speciale karakters bevatten !"
4400
527
4401
528
#. module: account_banking
4402
529
#: selection:account.banking.imported.file,state:0
4403
530
msgid "Unfinished"
4404
531
msgstr "Onvoltooid"
4405
532
4406
533
#. module: account_banking
4407
534
#: code:addons/account_banking/wizard/bank_import.py:0
4408
535
#, python-format
4409
536
msgid "Statements found for unknown account %(bank_account)s"
4410
537
msgstr "Afschriften gevonden voor onbekende bankrekening %(bank_account)s"
4411
538
4412
539
#. module: account_banking
4413
540
#: model:ir.module.module,shortdesc:account_banking.module_meta_information
4414
541
msgid "Account Banking"
4415
542
msgstr "Account Banking"
4416
543
4417
544
#. module: account_banking
4418
545
#: code:addons/account_banking/wizard/bank_import.py:0
4419
546
#, python-format
4420
547
msgid "Total number of statements"
4421
548
msgstr "Totaal aantal afschriften"
4422
549
4423
550
#. module: account_banking
4424
551
#: field:account.banking.imported.file,format:0
4425
552
#: wizard_field:account_banking.banking_import,init,parser:0
4426
553
msgid "File Format"
4427
554
msgstr "Bestandsformaat"
4428
555
4429
556
#. module: account_banking
4430
557
#: field:account.banking.account.settings,journal_id:0
4431
558
msgid "Journal"
4432
559
msgstr "Dagboek"
4433
560
4434
561
#. module: account_banking
4435
562
#: selection:account.banking.imported.file,state:0
4436
563
msgid "Finished"
4437
564
msgstr "Gereed"
4438
565
4439
566
#. module: account_banking
4440
567
#: code:addons/account_banking/wizard/banktools.py:0
4441
568
#, python-format
4442
569
msgid "No suitable fiscal year found for company %(company_name)s"
4443
570
msgstr "Geen geschikt boekjaar gevonden voor bedrijf %(company_name)s"
4444
571
4445
572
#. module: account_banking
4446
573
#: view:account.banking.account.settings:0
4447
574
msgid "Bank Account Details"
4448
575
msgstr "Details bankrekening"
4449
576
4450
577
#. module: account_banking
4451
578
#: code:addons/account_banking/wizard/bank_import.py:0
4452
579
#, python-format
4453
580
msgid "Unable to link transaction %(trans)s to invoice: '\n"
4454
581
"                  '%(no_candidates)s candidates found; can\'t choose."
4455
582
msgstr "Niet in staat transactie %(trans)s aan factuur te koppelen: '\n"
4456
583
"                  '%(no_candidates)s kandidaten gevonden; kan niet kiezen."
4457
584
4458
585
#. module: account_banking
4459
586
#: field:account.bank.statement.line,partner_bank_id:0
4460
587
#: field:account.banking.account.settings,partner_bank_id:0
4461
588
msgid "Bank Account"
4462
589
msgstr "Bankrekening"
4463
590
4464
591
#. module: account_banking
4465
592
#: code:addons/account_banking/wizard/bank_import.py:0
4466
593
#, python-format
4467
594
msgid "Number of transactions loaded"
4468
595
msgstr "Aantal geladen transacties"
4469
596
4470
597
#. module: account_banking
4471
598
#: code:addons/account_banking/wizard/banktools.py:0
4472
599
#, python-format
4473
600
msgid "Multiple overlapping fiscal years found for date %(date)s"
4474
601
msgstr "Meerdere overlappende boekjaren gevonden voor datum %(date)s"
4475
602
4476
603
#. module: account_banking
4477
604
#: model:ir.model,name:account_banking.model_account_banking_imported_file
4478
605
msgid "Imported Bank Statements File"
4479
606
msgstr "GeÃ¯mporteerde bankafschrift bestand"
4480
607
4481
0
608
4482
=== added directory 'account_banking/parsers'
4483
=== added file 'account_banking/parsers/__init__.py'
4484
--- account_banking/parsers/__init__.py	1970-01-01 00:00:00 +0000
4485
+++ account_banking/parsers/__init__.py	2010-03-04 01:53:21 +0000
4486
@@ -0,0 +1,24 @@
4487
1
# -*- encoding: utf-8 -*-
4488
2
##############################################################################
4489
3
#
4490
4
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
4491
5
#    All Rights Reserved
4492
6
#
4493
7
#    This program is free software: you can redistribute it and/or modify
4494
8
#    it under the terms of the GNU General Public License as published by
4495
9
#    the Free Software Foundation, either version 3 of the License, or
4496
10
#    (at your option) any later version.
4497
11
#
4498
12
#    This program is distributed in the hope that it will be useful,
4499
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
4500
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4501
15
#    GNU General Public License for more details.
4502
16
#
4503
17
#    You should have received a copy of the GNU General Public License
4504
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
4505
19
#
4506
20
##############################################################################
4507
21
4508
22
import models
4509
23
4510
24
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
4511
0
25
4512
=== added file 'account_banking/parsers/convert.py'
4513
--- account_banking/parsers/convert.py	1970-01-01 00:00:00 +0000
4514
+++ account_banking/parsers/convert.py	2010-03-04 01:53:21 +0000
4515
@@ -0,0 +1,41 @@
4516
1
# -*- encoding: utf-8 -*-
4517
2
##############################################################################
4518
3
#
4519
4
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
4520
5
#    All Rights Reserved
4521
6
#
4522
7
#    This program is free software: you can redistribute it and/or modify
4523
8
#    it under the terms of the GNU General Public License as published by
4524
9
#    the Free Software Foundation, either version 3 of the License, or
4525
10
#    (at your option) any later version.
4526
11
#
4527
12
#    This program is distributed in the hope that it will be useful,
4528
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
4529
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4530
15
#    GNU General Public License for more details.
4531
16
#
4532
17
#    You should have received a copy of the GNU General Public License
4533
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
4534
19
#
4535
20
##############################################################################
4536
21
4537
22
__all__ = ['str2date', 'date2str', 'date2date']
4538
23
4539
24
import datetime
4540
25
4541
26
def str2date(datestr, format='%d/%m/%y'):
4542
27
    '''Convert a string to a datatime object'''
4543
28
    return datetime.datetime.strptime(datestr, format)
4544
29
4545
30
def date2str(date, format='%Y-%m-%d'):
4546
31
    '''Convert a datetime object to a string'''
4547
32
    return date.strftime(format)
4548
33
4549
34
def date2date(datestr, fromfmt='%d/%m/%y', tofmt='%Y-%m-%d'):
4550
35
    '''
4551
36
    Convert a date in a string to another string, in a different
4552
37
    format
4553
38
    '''
4554
39
    return date2str(str2date(datestr, fromfmt), tofmt)
4555
40
4556
41
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
4557
0
42
4558
=== added file 'account_banking/parsers/models.py'
4559
--- account_banking/parsers/models.py	1970-01-01 00:00:00 +0000
4560
+++ account_banking/parsers/models.py	2010-03-04 01:53:21 +0000
4561
@@ -0,0 +1,161 @@
4562
1
# -*- encoding: utf-8 -*-
4563
2
##############################################################################
4564
3
#
4565
4
#  Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
4566
5
#  All Rights Reserved
4567
6
#
4568
7
#  This program is free software: you can redistribute it and/or modify
4569
8
#  it under the terms of the GNU General Public License as published by
4570
9
#  the Free Software Foundation, either version 3 of the License, or
4571
10
#  (at your option) any later version.
4572
11
#
4573
12
#  This program is distributed in the hope that it will be useful,
4574
13
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
4575
14
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4576
15
#  GNU General Public License for more details.
4577
16
#
4578
17
#  You should have received a copy of the GNU General Public License
4579
18
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
4580
19
#
4581
20
##############################################################################
4582
21
4583
22
class mem_bank_statement(object):
4584
23
    '''
4585
24
    A mem_bank_statement is a real life projection of a bank statement paper
4586
25
    containing a report of one or more transactions done. As these reports can
4587
26
    contain payments that originate in several accounting periods, period is an
4588
27
    attribute of mem_bank_transaction, not of mem_bank_statement.
4589
28
    Also note that the statement_id is copied from the bank statement, and not
4590
29
    generated from any sequence. This enables us to skip old data in new
4591
30
    statement files.
4592
31
    '''
4593
32
    # Lock attributes to enable parsers to trigger non-conformity faults
4594
33
    __slots__ = [
4595
34
        'start_balance','end_balance', 'date', 'local_account',
4596
35
        'local_currency', 'id', 'statements'
4597
36
    ]
4598
37
    def __init__(self, *args, **kwargs):
4599
38
        super(mem_bank_statement, self).__init__(*args, **kwargs)
4600
39
        self.id = ''
4601
40
        self.local_account = ''
4602
41
        self.local_currency = ''
4603
42
        self.start_balance = 0.0
4604
43
        self.end_balance = 0.0
4605
44
        self.date = ''
4606
45
        self.transactions = []
4607
46
4608
47
    def is_valid(self):
4609
48
        '''
4610
49
        Final check: ok if calculated end_balance and parsed end_balance are
4611
50
        identical and perform a heuristic check on the transactions.
4612
51
        '''
4613
52
        if any([x for x in self.transactions if not x.is_valid()]):
4614
53
            return False
4615
54
        check = float(self.start_balance)
4616
55
        for transaction in self.transactions:
4617
56
            check += float(transaction.transferred_amount)
4618
57
        return abs(check - float(self.end_balance)) < 0.0001
4619
58
4620
59
class mem_bank_transaction(object):
4621
60
    '''
4622
61
    A mem_bank_transaction is a real life copy of a bank transfer. Mapping to
4623
62
    OpenERP moves and linking to invoices and the like is done afterwards.
4624
63
    '''
4625
64
    # Lock attributes to enable parsers to trigger non-conformity faults
4626
65
    __slots__ = [
4627
66
        'id', 'local_account', 'local_currency', 'execution_date',
4628
67
        'effective_date', 'remote_owner', 'remote_account',
4629
68
        'remote_currency', 'transferred_amount', 'transfer_type',
4630
69
        'reference', 'message', 'statement_id',
4631
70
    ]
4632
71
4633
72
    def __init__(self, *args, **kwargs):
4634
73
        super(mem_bank_transaction, self).__init__(*args, **kwargs)
4635
74
        self.id = ''
4636
75
        self.local_account = ''
4637
76
        self.local_currency = ''
4638
77
        self.execution_date = ''
4639
78
        self.effective_date = ''
4640
79
        self.remote_account = ''
4641
80
        self.remote_owner = ''
4642
81
        self.remote_currency = ''
4643
82
        self.transferred_amount = ''
4644
83
        self.transfer_type = ''
4645
84
        self.reference = ''
4646
85
        self.message = ''
4647
86
        self.statement_id = ''
4648
87
4649
88
    def is_valid(self):
4650
89
        '''
4651
90
        Heuristic check: at least id, execution_date, remote_account and
4652
91
        transferred_amount should be filled to create a valid transfer.
4653
92
        '''
4654
93
        return (self.execution_date and self.remote_account
4655
94
                and self.transferred_amount and True) or False
4656
95
4657
96
class parser_type(type):
4658
97
    parsers = []
4659
98
    parser_by_name = {}
4660
99
    parser_by_code = {}
4661
100
    parser_by_classname = {}
4662
101
4663
102
    def __new__(metacls, clsname, bases, clsdict):
4664
103
        newcls = type.__new__(metacls, clsname, bases, clsdict)
4665
104
        if 'name' in clsdict and newcls.name:
4666
105
            metacls.parsers.append(newcls)
4667
106
            metacls.parser_by_name[newcls.name] = newcls
4668
107
            metacls.parser_by_code[newcls.code] = newcls
4669
108
            metacls.parser_by_classname[clsname] = newcls
4670
109
        return newcls
4671
110
4672
111
    @classmethod
4673
112
    def get_parser_types(cls, sort='name'):
4674
113
        if sort == 'name':
4675
114
            keys = cls.parser_by_name.keys()
4676
115
            parsers = cls.parser_by_name
4677
116
        else:
4678
117
            keys = cls.parser_by_code.itervalues()
4679
118
            parsers = cls.parser_by_code
4680
119
        keys.sort()
4681
120
        return [(parsers[x].code, parsers[x].name) for x in keys]
4682
121
4683
122
def create_parser(code):
4684
123
    if code in parser_type.parser_by_code:
4685
124
        return parser_type.parser_by_code[code]()
4686
125
    return None
4687
126
4688
127
class parser(object):
4689
128
    '''
4690
129
    A parser delivers the interface for any parser object. Inherit from
4691
130
    it to implement your own.
4692
131
    You should at least implement the following at the class level:
4693
132
        name -> the name of the parser, shown to the user and
4694
133
                    translatable.
4695
134
        code -> the identifier you care to give it. Not translatable
4696
135
        doc  -> the description of the identifier. Shown to the user.
4697
136
                    Translatable.
4698
137
4699
138
        parse -> the method for the actual parsing.
4700
139
    '''
4701
140
    __metaclass__ = parser_type
4702
141
    name = None
4703
142
    code = None
4704
143
    doc = __doc__
4705
144
4706
145
    def parse(self, data):
4707
146
        '''
4708
147
        Parse data.
4709
148
        
4710
149
        data is a raw in memory file object. You have to split it in
4711
150
        whatever chunks you see fit for parsing. It should return a list
4712
151
        of mem_bank_statement objects. Every mem_bank_statement object
4713
152
        should contain a list of mem_bank_transaction objects.
4714
153
4715
154
        For identification purposes, don't invent numbering of the transaction
4716
155
        numbers or bank statements ids on your own - stick with those provided
4717
156
        by your bank. Doing so enables the users to re-load old transaction
4718
157
        files without creating multiple identical bank statements.
4719
158
        '''
4720
159
        raise NotImplementedError(_('This is a stub. Please implement your own.'))
4721
160
4722
161
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
4723
0
162
4724
=== added file 'account_banking/record.py'
4725
--- account_banking/record.py	1970-01-01 00:00:00 +0000
4726
+++ account_banking/record.py	2010-03-04 01:53:21 +0000
4727
@@ -0,0 +1,182 @@
4728
1
# -*- encoding: utf-8 -*-
4729
2
##############################################################################
4730
3
#
4731
4
#    Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
4732
5
#    All Rights Reserved
4733
6
#
4734
7
#    This program is free software: you can redistribute it and/or modify
4735
8
#    it under the terms of the GNU General Public License as published by
4736
9
#    the Free Software Foundation, either version 3 of the License, or
4737
10
#    (at your option) any later version.
4738
11
#
4739
12
#    This program is distributed in the hope that it will be useful,
4740
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
4741
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4742
15
#    GNU General Public License for more details.
4743
16
#
4744
17
#    You should have received a copy of the GNU General Public License
4745
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
4746
19
#
4747
20
##############################################################################
4748
21
4749
22
__all__ = [
4750
23
    'Field', 'Filler', 'DateField', 'NumberField', 'RightAlignedField',
4751
24
    'RecordType', 'Record', 'asciify'
4752
25
]
4753
26
4754
27
__doc__ = '''Ease working with fixed length records in files'''
4755
28
4756
29
from datetime import datetime, date
4757
30
import unicodedata
4758
31
4759
32
class Field(object):
4760
33
    '''Base Field class - fixed length left aligned string field in a record'''
4761
34
    def __init__(self, name, length=1, fillchar=' '):
4762
35
        self.name = name.replace(' ', '_')
4763
36
        self.length = length
4764
37
        self.fillchar = fillchar
4765
38
4766
39
    def format(self, value):
4767
40
        value = str(value)
4768
41
        if len(value) > self.length:
4769
42
            return value[len(value) - self.length:]
4770
43
        return value.ljust(self.length, self.fillchar)
4771
44
4772
45
    def take(self, buffer):
4773
46
        offset = hasattr(self, 'offset') and self.offset or 0
4774
47
        return buffer[offset:offset + self.length].rstrip(self.fillchar)
4775
48
4776
49
    def __repr__(self):
4777
50
        return '%s "%s"' % (self.__class__.__name__, self.name)
4778
51
4779
52
class Filler(Field):
4780
53
    '''Constant value field'''
4781
54
    def __init__(self, name, length=1, value=' '):
4782
55
        super(Filler, self).__init__(name, length)
4783
56
        self.value = str(value)
4784
57
4785
58
    def take(self, buffer):
4786
59
        return self.format(buffer)
4787
60
4788
61
    def format(self, value):
4789
62
        return super(Filler, self).format(
4790
63
            self.value * (self.length / len(self.value) +1)
4791
64
        )
4792
65
4793
66
class DateField(Field):
4794
67
    '''Variable date field'''
4795
68
    def __init__(self, name, format='%Y-%m-%d', auto=False):
4796
69
        length = len(date.today().strftime(format))
4797
70
        super(DateField, self).__init__(name, length)
4798
71
        self.dateformat = format
4799
72
        self.auto = auto
4800
73
4801
74
    def format(self, value):
4802
75
        if isinstance(value, (str, unicode)) and \
4803
76
           len(value.strip()) == self.length:
4804
77
            value = datetime.strptime(value, self.dateformat).date()
4805
78
        elif not isinstance(value, (datetime, date)):
4806
79
            value = date.today()
4807
80
        return value.strftime(self.dateformat)
4808
81
4809
82
    def take(self, buffer):
4810
83
        value = super(DateField, self).take(buffer)
4811
84
        if value:
4812
85
            return datetime.strptime(value, self.dateformat).date()
4813
86
        return self.auto and date.today() or None
4814
87
4815
88
class RightAlignedField(Field):
4816
89
    '''Deviation of Field: right aligned'''
4817
90
    def format(self, value):
4818
91
        if len(value) > self.length:
4819
92
            return value[:self.length]
4820
93
        return value.rjust(self.length, self.fillchar)
4821
94
4822
95
    def take(self, buffer):
4823
96
        offset = hasattr(self, 'offset') and self.offset or 0
4824
97
        return buffer[offset:offset + self.length].lstrip(self.fillchar)
4825
98
4826
99
class NumberField(RightAlignedField):
4827
100
    '''Deviation of Field: left zero filled'''
4828
101
    def __init__(self, *args, **kwargs):
4829
102
        kwargs['fillchar'] = '0'
4830
103
        super(NumberField, self).__init__(*args, **kwargs)
4831
104
4832
105
    def format(self, value):
4833
106
        return super(NumberField, self).format(value and str(value) or '')
4834
107
4835
108
class RecordType(object):
4836
109
    fields = []
4837
110
4838
111
    def __init__(self, fields=[]):
4839
112
        if fields:
4840
113
            self.fields = fields
4841
114
        offset = 0
4842
115
        for field in self.fields:
4843
116
            field.offset = offset
4844
117
            offset += field.length
4845
118
4846
119
    def __len__(self):
4847
120
        return reduce(lambda x,y: x+y.length, self.fields, 0)
4848
121
4849
122
    def __contains__(self, key):
4850
123
        return any(lambda x, y=key: x.name == y, self.fields)
4851
124
4852
125
    def __getitem__(self, key):
4853
126
        for field in self.fields:
4854
127
            if field.name == key:
4855
128
                return field
4856
129
        raise KeyError, 'No such field: %s' % key
4857
130
4858
131
    def format(self, buffer):
4859
132
        result = []
4860
133
        for field in self.fields:
4861
134
            result.append(field.format(field.take(buffer)))
4862
135
        return ''.join(result)
4863
136
4864
137
    def take(self, buffer):
4865
138
        return dict(zip([x.name for x in self.fields],
4866
139
                        [x.take(buffer) for x in self.fields]
4867
140
                       ))
4868
141
4869
142
class Record(object):
4870
143
    _recordtype = None
4871
144
4872
145
    def __init__(self, recordtype=None, value=''):
4873
146
        if hasattr(self, '_fields') and self._fields:
4874
147
            self._recordtype = RecordType(self._fields)
4875
148
        if not self._recordtype and not recordtype:
4876
149
            raise ValueError, 'No recordtype specified'
4877
150
        if not self._recordtype:
4878
151
            self._recordtype = recordtype()
4879
152
        self._length = len(self._recordtype)
4880
153
        self._value = value.ljust(self._length)[:self._length]
4881
154
    
4882
155
    def __len__(self):
4883
156
        return self._length
4884
157
4885
158
    def __setattr__(self, attr, value):
4886
159
        if attr.startswith('_'):
4887
160
            super(Record, self).__setattr__(attr, value)
4888
161
        else:
4889
162
            field = self._recordtype[attr]
4890
163
            self._value = self._value[:field.offset] + \
4891
164
                    field.format(value) + \
4892
165
                    self._value[field.offset + field.length:]
4893
166
4894
167
    def __getattr__(self, attr):
4895
168
        if attr.startswith('_'):
4896
169
            return super(Record, self).__getattr__(attr)
4897
170
        field = self._recordtype[attr]
4898
171
        return field.take(self._value)
4899
172
    
4900
173
    def __str__(self):
4901
174
        return self._recordtype.format(self._value)
4902
175
4903
176
    def __unicode__(self):
4904
177
        return unicode(str(self))
4905
178
4906
179
def asciify(str):
4907
180
    return unicodedata.normalize('NFKD', str).encode('ascii', 'ignore')
4908
181
4909
182
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
4910
0
183
4911
=== added file 'account_banking/sepa.py'
4912
--- account_banking/sepa.py	1970-01-01 00:00:00 +0000
4913
+++ account_banking/sepa.py	2010-03-04 01:53:21 +0000
4914
@@ -0,0 +1,421 @@
4915
1
# -*- encoding: utf-8 -*-
4916
2
##############################################################################
4917
3
#
4918
4
#  Copyright (C) 2009 EduSense BV (<http://www.edusense.nl>).
4919
5
#  All Rights Reserved
4920
6
#
4921
7
#  This program is free software: you can redistribute it and/or modify
4922
8
#  it under the terms of the GNU General Public License as published by
4923
9
#  the Free Software Foundation, either version 3 of the License, or
4924
10
#  (at your option) any later version.
4925
11
#
4926
12
#  This program is distributed in the hope that it will be useful,
4927
13
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
4928
14
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
4929
15
#  GNU General Public License for more details.
4930
16
#
4931
17
#  You should have received a copy of the GNU General Public License
4932
18
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
4933
19
#
4934
20
##############################################################################
4935
21
4936
22
# The information about SEPA account numbers in this module are collected
4937
23
# from ISO 13616-1, which can be found at SWIFT's website:
4938
24
# http://www.swift.com/solutions/messaging/information_products/bic_downloads_documents/pdfs/IBAN_Registry.pdf
4939
25
#
4940
26
# This module uses both SEPA and IBAN as seemingly interchangeble terms.
4941
27
# However, a SEPA account is a bank account in the SEPA zone, which is
4942
28
# represented by a IBAN number, which is build up from a ISO-693-1 two letter
4943
29
# country code, two check digits and a BBAN number, representing the
4944
30
# local/national accounting scheme.
4945
31
#
4946
32
# With the exception of Turkey, all countries use the full local adressing
4947
33
# scheme in the IBAN numbers, making it possible to deduce the BBAN from the
4948
34
# IBAN. As Turkey uses an additional code in the local scheme which is not
4949
35
# part of the BBAN, for accounts located in Turkeys banks it is not possible
4950
36
# to use the BBAN to reconstruct the local account.
4951
37
#
4952
38
# WARNING:
4953
39
# This module contains seemingly enough info to create IBAN's from BBAN's.
4954
40
# Although many BBAN/IBAN conversions seem algorithmic, there is enough
4955
41
# deviation to take the warning from SEPA seriously: this is the domain of the
4956
42
# account owning banks. Don't use it, unless you are prepared to loose your
4957
43
# money. It is for heuristic validation purposes only.
4958
44
4959
45
__all__ = ['IBAN']
4960
46
4961
47
def modulo_97_base10(buffer):
4962
48
    '''
4963
49
    Calculate the modulo 97 value of a string in base10
4964
50
    '''
4965
51
    checksum = int(buffer[0])
4966
52
    for digit in buffer[1:]:
4967
53
        checksum *= 10;
4968
54
        checksum += int(digit)
4969
55
        checksum %= 97
4970
56
    return checksum
4971
57
4972
58
def base36_to_base10str(buffer):
4973
59
    '''
4974
60
    Convert a base36 string value to a string of base10 digits.
4975
61
    '''
4976
62
    result = ''
4977
63
    for digit in buffer:
4978
64
        if digit.isalpha():
4979
65
            result += str(ord(digit) - 55)
4980
66
        else:
4981
67
            result += digit
4982
68
    return result
4983
69
4984
70
class BBANFormat(object):
4985
71
    '''
4986
72
    A BBANFormat is an auxilliary class for IBAN. It represents the composition
4987
73
    of a BBAN number from the different elements in order to translate a
4988
74
    IBAN number to a localized number. The reverse route, transforming a local
4989
75
    account to a SEPA account, is the sole responsibility of the banks.
4990
76
    '''
4991
77
4992
78
    def __init__(self, ibanfmt, bbanfmt='%A', nolz=False):
4993
79
        '''
4994
80
        Specify the structure of the SEPA account in relation to the local
4995
81
        account. The XXZZ prefix that all SEPA accounts have is not part of
4996
82
        the structure in BBANFormat.
4997
83
        
4998
84
        ibanfmt: string of identifiers from position 5 (start = 1):
4999
85
            A = Account position
5000
86
            N = Account digit
Reviewer	Review Type	Date Requested	Status
OpenERP Core Team		2009-11-23	Pending
Review via email: mp+15162@code.launchpad.net