Unifield Server

Merge lp:~jfb-tempo-consulting/unifield-server/US-11026 into lp:unifield-server

  1. US-11026
  2. Merge into trunk
Proposed by jftempo
Status: Merged
Merged at revision: 6569
Proposed branch: lp:~jfb-tempo-consulting/unifield-server/US-11026
Merge into: lp:unifield-server
Diff against target: 2261 lines (+1961/-18)
12 files modified
bin/addons/account/account.py (+2/-2)
bin/addons/account_journal/account_journal.py (+1/-1)
bin/addons/msf_profile/data/patches.xml (+8/-1)
bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql (+520/-0)
bin/addons/msf_profile/i18n/fr_MF.po (+272/-11)
bin/addons/msf_profile/msf_profile.py (+11/-1)
bin/addons/register_accounting/report/report_liquidity_position.py (+0/-1)
bin/addons/spreadsheet_xml/xlsx_write.py (+7/-1)
bin/addons/vertical_integration/account_report.xml (+11/-0)
bin/addons/vertical_integration/report/__init__.py (+1/-0)
bin/addons/vertical_integration/report/field_balance_spec_report.py (+1090/-0)
bin/addons/vertical_integration/vertical_integration_wizard.xml (+38/-0)
To merge this branch: bzr merge lp:~jfb-tempo-consulting/unifield-server/US-11026
Reviewer Review Type Date Requested Status
UniField Reviewer Team Pending
Review via email: mp+450131@code.launchpad.net
To post a comment you must log in.
lp:~jfb-tempo-consulting/unifield-server/US-11026 updated
6570. By jftempo

US-11026 OCA patch script to set liquidity journal on migration JI

6571. By jftempo

Translations

6572. By jftempo

Translations

6573. By jftempo

Report name: disable translation

6574. By jftempo

[MERGE] UF30.1

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added directory 'bin/.update'
2=== modified file 'bin/addons/account/account.py'
3--- bin/addons/account/account.py 2023-06-26 14:31:43 +0000
4+++ bin/addons/account/account.py 2023-09-22 12:20:31 +0000
5@@ -307,7 +307,7 @@
6 ('liquidity','Liquidity'),
7 ('consolidation', 'Consolidation'),
8 ('closed', 'Closed'),
9- ], 'Internal Type', required=True, help="This type is used to differentiate types with "\
10+ ], 'Internal Type', required=True, select=1, help="This type is used to differentiate types with "\
11 "special effects in OpenERP: view can not have entries, consolidation are accounts that "\
12 "can have children accounts for multi-company consolidations, payable/receivable are for "\
13 "partners accounts (for debit/credit computations), closed for depreciated accounts."),
14@@ -657,7 +657,7 @@
15 _columns = {
16 'name': fields.char('Journal Name', size=64, required=True),
17 'code': fields.char('Code', size=5, required=True, help="The code will be used to generate the numbers of the journal entries of this journal."),
18- 'type': fields.selection([('sale', 'Sale'),('sale_refund','Sale Refund'), ('purchase', 'Purchase'), ('purchase_refund','Purchase Refund'), ('cash', 'Cash'), ('bank', 'Bank and Cheques'), ('general', 'General'), ('situation', 'Opening/Closing Situation')], 'Type', size=32, required=True,
19+ 'type': fields.selection([('sale', 'Sale'),('sale_refund','Sale Refund'), ('purchase', 'Purchase'), ('purchase_refund','Purchase Refund'), ('cash', 'Cash'), ('bank', 'Bank and Cheques'), ('general', 'General'), ('situation', 'Opening/Closing Situation')], 'Type', size=32, required=True, select=1,
20 help="Select 'Sale' for Sale journal to be used at the time of making invoice."\
21 " Select 'Purchase' for Purchase Journal to be used at the time of approving purchase order."\
22 " Select 'Cash' to be used at the time of making payment."\
23
24=== modified file 'bin/addons/account_journal/account_journal.py'
25--- bin/addons/account_journal/account_journal.py 2022-02-04 17:25:05 +0000
26+++ bin/addons/account_journal/account_journal.py 2023-09-22 12:20:31 +0000
27@@ -98,7 +98,7 @@
28 return res
29
30 _columns = {
31- 'type': fields.selection(get_journal_type, 'Type', size=32, required=True),
32+ 'type': fields.selection(get_journal_type, 'Type', size=32, required=True, select=1),
33 'code': fields.char('Code', size=10, required=True, help="The code will be used to generate the numbers of the journal entries of this journal."),
34 'bank_journal_id': fields.many2one('account.journal', _("Corresponding bank journal"),
35 domain="[('type', '=', 'bank'), ('currency', '=', currency), ('is_active', '=', True)]"),
36
37=== modified file 'bin/addons/msf_profile/data/patches.xml'
38--- bin/addons/msf_profile/data/patches.xml 2023-09-15 13:58:07 +0000
39+++ bin/addons/msf_profile/data/patches.xml 2023-09-22 12:20:31 +0000
40@@ -980,9 +980,16 @@
41 <field name="method">us_11810_fix_company_logo</field>
42 </record>
43
44- <!-- UF31.0 -->
45+ <!-- UF30.1 -->
46 <record id="us_11956_fix_po_line_reception_destination" model="patch.scripts">
47 <field name="method">us_11956_fix_po_line_reception_destination</field>
48 </record>
49+
50+ <!-- UF31.0 -->
51+ <record id="us_11026_oca_liquidity_migration_journal" model="patch.scripts">
52+ <field name="method">us_11026_oca_liquidity_migration_journal</field>
53+ </record>
54+
55+
56 </data>
57 </openerp>
58
59=== added file 'bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql'
60--- bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql 1970-01-01 00:00:00 +0000
61+++ bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql 2023-09-22 12:20:31 +0000
62@@ -0,0 +1,520 @@
63+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_CA005_05 PETTY DHK CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/28');
64+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_CA003_03 MAIN DHK CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/27');
65+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_CA002_02 MAIN DHK CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/30');
66+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_CA001_01 MAIN DHK CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/32');
67+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA006_06 CITIBANK DHK BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/34');
68+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA087_87 SONALI DHK-FLB BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/39');
69+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA065_65 DBBL DHK-KAM BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/38');
70+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA040_40 BDT DBBL DHK-KTP BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/37');
71+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA035_35 DBBL DHK-KTP BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/36');
72+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_DHK_BA007_07 SONALI DHK BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='5893ac00-2add-11e5-b429-d4c9efd9bef8/account_move_line/35');
73+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KTP_CA031_31 MAIN CXB-KTP CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae628161-2bbe-11e5-accc-28924acbffd0/account_move_line/1');
74+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KTP_CA033_33 PETTY CXB-KTP CASH BDT ') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae628161-2bbe-11e5-accc-28924acbffd0/account_move_line/2');
75+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KTP_BA036_36 DUTCH-BANGLA CXB-KTP BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae628161-2bbe-11e5-accc-28924acbffd0/account_move_line/4');
76+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_FUL_CA083_83 PETTY FLB CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='2c364780-2bc3-11e5-ba93-d4c9efd9bef8/account_move_line/2');
77+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_FUL_CA081_81 MAIN FLB CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='2c364780-2bc3-11e5-ba93-d4c9efd9bef8/account_move_line/1');
78+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_FUL_BA086_86 SONALI FLB BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='2c364780-2bc3-11e5-ba93-d4c9efd9bef8/account_move_line/4');
79+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KAM_CA061_61 MAIN KAM CASH BDT ') where id=(select res_id from ir_model_data where model='account.move.line' and name='8631b1a1-2bca-11e5-a465-28924acbffd0/account_move_line/1');
80+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KAM_CA063_63 PETTY KAM CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='8631b1a1-2bca-11e5-a465-28924acbffd0/account_move_line/2');
81+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_BD_KAM_BA062_62 DBBL KAM BANK BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='8631b1a1-2bca-11e5-a465-28924acbffd0/account_move_line/4');
82+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_CA004_4 PETTY CASH GOM CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2800');
83+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_CA005_5 MAIN SAFE GOM CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2802');
84+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_CA001_1 MAIN SAFE GOM CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2804');
85+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_CA002_2 PETTY CASH GOM CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2806');
86+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA013_13 ECOBANK GOMA CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2808');
87+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA016_16 PROCREDIT GOMA BANK CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2810');
88+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA086_86 MPESA GOMA CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2812');
89+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA088_88 MPESA GOMA AIRTEL CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2814');
90+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA010_10 RAWBANK GOMA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2816');
91+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA011_11 ECOBANK GOMA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2818');
92+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA012_12 BPR RWANDABANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2820');
93+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA015_15 PROCREDIT GOMA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2822');
94+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA085_85 MPESA GOMA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2824');
95+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_GOMA_BA087_ 87 MPESA GOMA AIRTEL USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0b48440-f9c6-11e6-a77e-5065f31b555a/account_move_line/2826');
96+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_CA032_32 MAIN SAFE WALIKALE CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/955');
97+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_CA033_33 PETTY CASH WALIKALE CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/965');
98+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_CA030_30 MAIN SAFE WALIKALE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/975');
99+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_CA031_31 PETTY CASH WALIKALE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/987');
100+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_BA035_35 MPESA WALIKALE CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/993');
101+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_BA037_37 WALIKALE AIRTEL CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/1005');
102+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_BA034_34 MPESA WALIKALE USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/1015');
103+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_WALI_BA036_36 WALIKALE AIRTEL USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='823868e1-f9c4-11e6-8cb0-5065f31b555a/account_move_line/1025');
104+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_MWES_CA022_22 MAIN SAFE MWESO CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='e54337c0-f9c5-11e6-baa1-5065f31b555a/account_move_line/526');
105+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_MWES_CA023_23 PETTY CASH MWESO CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='e54337c0-f9c5-11e6-baa1-5065f31b555a/account_move_line/528');
106+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_MWES_CA020_20 MAIN SAFE MWESO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='e54337c0-f9c5-11e6-baa1-5065f31b555a/account_move_line/530');
107+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CD_MWES_CA021_21 PETTY CASH MWESO USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='e54337c0-f9c5-11e6-baa1-5065f31b555a/account_move_line/532');
108+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_CA012_12 MAIN SAFE BANGUI CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/1');
109+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_CA014_14 MAIN SAFE BANGUI CASH USD ') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/3');
110+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_CA010_10 MAIN SAFE BANGUI CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/5');
111+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_CA011_11 PETTY CASH BANGUI CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/7');
112+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_CA071_71 PETTY CASH ZEMIO CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/9');
113+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_BA017_17 ECO BANK BANGUI BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/11');
114+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BANG_BA019_19 CBC BANK BANGUI BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='dc74cfe1-5fe2-11e7-9afe-74dfbfd4b23f/account_move_line/13');
115+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BOSS_CA030_30 MAIN SAFE BOSSANGOA CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='267c0af0-5ff1-11e7-88f9-74dfbfd4b23f/account_move_line/1');
116+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CF_BOSS_CA031_31 PETTY CASH BOSSANGOA CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='267c0af0-5ff1-11e7-88f9-74dfbfd4b23f/account_move_line/3');
117+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_CA027_27 MAIN SAFE N''DJ CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/1');
118+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_CA029_29 MAIN SAFE N''DJ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/3');
119+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_CA021_21 PETTY SAFE N''DJ CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/5');
120+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_CA022_22 MAIN SAFE N''DJ CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/7');
121+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_BA024_24 SGTB N''DJ BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/9');
122+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_NDJA_BA025_25 ECOBANK N''DJ BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='345e7c9e-9208-11e6-9fbb-74dfbfd4876f/account_move_line/11');
123+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_AMTI_CA061_61 PETTY CASH AM TIMAN CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='083339a1-9207-11e6-84fc-74dfbfd4876f/account_move_line/1');
124+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_AMTI_CA062_62 MAIN SAFE AM TIMAN CASH XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='083339a1-9207-11e6-84fc-74dfbfd4876f/account_move_line/3');
125+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_AMTI_BA031_31 ORABANK HEP E BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='083339a1-9207-11e6-84fc-74dfbfd4876f/account_move_line/5');
126+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TD_AMTI_BA064_64 ORABANK AM TIMAN BANK XAF') where id=(select res_id from ir_model_data where model='account.move.line' and name='083339a1-9207-11e6-84fc-74dfbfd4876f/account_move_line/7');
127+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA012_12 MAIN SAFE BUKAVU CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/59');
128+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA013_13 PETTY CASH BUKAVU CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/95');
129+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA043_43 PETTY CASH EPREP CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/97');
130+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA014_14 MAIN SAFE BUKAVU CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/99');
131+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA015_15 PETTY CASH BUKAVU CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/101');
132+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA010_10 MAIN SAFE BUKAVU CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/103');
133+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA011_11 PETTY CASH BUKAVU CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/105');
134+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_CA041_41 PETTY CASH EPREP CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/107');
135+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA047_47 CDF MPESA CASH 412 E-PREP ') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/109');
136+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA053_53 MPESA BULK 421 BUKAVU CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/111');
137+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA057_57 MPESA CASH 759 BUKAVU CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/113');
138+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA046_46 MPESA CASH 412 EPREP') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/115');
139+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA051_51 MPESA BULK 421 BUKAVU USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/117');
140+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA054_54 MPESA AGENT 077 BUKAVU USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/119');
141+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA056_56 MPESA CASH 759 BUKAVU USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/121');
142+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA081_81 FBNBANK BUKAVU USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/123');
143+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA083_83 ECOBANK BUKAVU USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/125');
144+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BUKA_BA085_85 ECOBANK RWANDA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d967940f-190e-11e7-8042-74dfbfd4b23f/account_move_line/127');
145+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_CA023_23 PETTY CASH BARAKA CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/1');
146+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_CA021_21 PETTY CASH BARAKA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/3');
147+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA025_25 MPESA AGENT 738 BARAKA CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/5');
148+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA027_27 MPESA CASH 276 BARAKA CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/7');
149+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA029_29 MPESA CASH 798 BARAKA CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/9');
150+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA024_24 MPESA AGENT 738 BARAKA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/11');
151+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA026_26 MPESA CASH 276 BARAKA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/13');
152+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_BARA_BA028_28 MPESA CASH 798 BARAKA USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f23c718f-1913-11e7-b0b8-74dfbfd4b23f/account_move_line/15');
153+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_CA033_33 PETTY CASH KIMBI CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/1');
154+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_CA031_31 PETTY CASH KIMBI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/3');
155+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA035_35 MPESA AGENT 739 KIMBI CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/5');
156+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA037_37 MPESA CASH 225 KIMBI CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/7');
157+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA039_39 MPESA CASH 629 KIMBI CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/9');
158+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA034_34 MPESA AGENT 739 KIMBI USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/11');
159+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA036_36 MPESA CASH 225 KIMBI USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/13');
160+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_KIMB_BA038_38 MPESA CASH 629 KIMBI USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b0c7afcf-190f-11e7-bf75-74dfbfd4b23f/account_move_line/15');
161+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_CA073_73 PETTY CASH HAT KIBOMBO CASH CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/1');
162+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_CA070_70 MAIN SAFE HAT KIBOMBO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/3');
163+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_CA071_71 PETTY CASH HAT KIBOMBO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/5');
164+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_BA075_75 MPESA AGENT 078 KIBOMBO CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/7');
165+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_BA077_77 MPESA CASH 536 KIBOMBO CDF') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/9');
166+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_BA074_74 MPESA AGENT 078 KIBOMBO USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/11');
167+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_CS_MHAT_BA076_76 MPESA CASH 536 KIBOMBO USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='632f1d61-1911-11e7-9b03-74dfbfd4b23f/account_move_line/13');
168+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_CA005_05 PETTY CASH ADDIS CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/1');
169+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_CA008_08 MAIN SAFE ADDIS CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/3');
170+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_CA006_06 MAIN SAFE ADDIS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/5');
171+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_BA001_01 CBE NT ADDIS BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/7');
172+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_BA002_02 CBE CURRENT ADDIS BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/9');
173+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ADAB_BA009_09 CBE BLOCKED ADDIS BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='a71e6351-7da2-11e7-94a9-ecb1d75c7ec2/account_move_line/11');
174+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ABDU_CA031_31 PETTY CASH ABDURAFI CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='8845b361-7da3-11e7-a9c5-ecb1d75c7ec2/account_move_line/1');
175+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ABDU_CA032_32 MAIN SAFE ABDURAFI CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='8845b361-7da3-11e7-a9c5-ecb1d75c7ec2/account_move_line/3');
176+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ABDU_BA033_33 CBE GONDER BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='8845b361-7da3-11e7-a9c5-ecb1d75c7ec2/account_move_line/5');
177+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_ABDU_BA038_38 CBE ABDURAFI BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='8845b361-7da3-11e7-a9c5-ecb1d75c7ec2/account_move_line/7');
178+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_GAMB_CA044_44 MAIN SAFE GAMBELA KULE CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='00f193b0-7da4-11e7-a662-ecb1d75c7ec2/account_move_line/1');
179+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_GAMB_CA045_45 PETTY CASH GAMBELA KULE CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='00f193b0-7da4-11e7-a662-ecb1d75c7ec2/account_move_line/3');
180+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_GAMB_BA042_42 CBE GAMBELA KULE BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='00f193b0-7da4-11e7-a662-ecb1d75c7ec2/account_move_line/5');
181+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_TIGR_CA050_50 PETTY CASH SHIRE CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='04e371e1-7da5-11e7-a37f-ecb1d75c7ec2/account_move_line/1');
182+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_TIGR_CA051_51 MAIN SAFE SHIRE CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='04e371e1-7da5-11e7-a37f-ecb1d75c7ec2/account_move_line/3');
183+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_TIGR_BA052_52 CBE SHIRE BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='04e371e1-7da5-11e7-a37f-ecb1d75c7ec2/account_move_line/5');
184+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_PUGN_CA060_60 PETTY CASH PUGNIDO CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7c930d4f-7da4-11e7-80e0-ecb1d75c7ec2/account_move_line/1');
185+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_PUGN_CA061_61 MAIN SAFE PUGNIDO CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7c930d4f-7da4-11e7-80e0-ecb1d75c7ec2/account_move_line/3');
186+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_PUGN_BA062_62 CBE PUGNIDO BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7c930d4f-7da4-11e7-80e0-ecb1d75c7ec2/account_move_line/5');
187+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA021_21 PETTY CASH WARDHER CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/1');
188+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA022_22 MAIN SAFE WARDHER CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/3');
189+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA024_24 PETTY CASH GALADI CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/5');
190+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA025_25 MAIN SAFE GALADI CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/7');
191+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA029_29 PETTY CASH JIJIGA CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/9');
192+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA036_36 PETTY CASH DANOD CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/11');
193+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_CA037_37 MAIN SAFE DANOD CASH ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/13');
194+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_BA020_20 CBE WARDHER BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/15');
195+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ET_WARD_BA028_28 CBE JIJIGA BANK ETB') where id=(select res_id from ir_model_data where model='account.move.line' and name='7a3a81de-7da5-11e7-aac5-ecb1d75c7ec2/account_move_line/17');
196+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA09_09 PETTY CASH COORD CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/39');
197+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA014_14 MAIN SAFE COORD CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/41');
198+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA012_12 MAIN SAFE COORD CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/43');
199+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA013_13 PETTY CASH COORD CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/45');
200+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA040_40 PETTY CASH AW CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/47');
201+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA010_10 MAIN SAFE COORD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/49');
202+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_CA011_11 PETTY CASH COORD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/51');
203+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_BA017_17 SOGEBANK COORD BANK HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/53');
204+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_BA015_15 SOGEBANK COORD BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/55');
205+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_COOR_BA019_19 UNIBANK COORD BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='414f7c2e-ccf9-11e6-8b7c-a4c494c80537/account_move_line/57');
206+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_CA032_32 MAIN SAFE CRUO CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/1');
207+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_CA033_33 PETTY CASH CRUO CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/3');
208+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_CA030_30 MAIN SAFE CRUO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/5');
209+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_CA031_ 31 PETTY CASH CRUO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/7');
210+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_BA036_36 UNIBANK CRUO BANK HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/9');
211+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CRUO_BA034_34 UNIBANK CRUO BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b3180e40-ccf9-11e6-9c8a-a4c494c80537/account_move_line/11');
212+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_SGBV_CA050_50 MAIN SAFE SGBV CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='3e2bb180-ccfa-11e6-b84a-a4c494c80537/account_move_line/1');
213+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_SGBV_CA051_51 PETTY CASH SGBV CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='3e2bb180-ccfa-11e6-b84a-a4c494c80537/account_move_line/3');
214+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_SGBV_BA052_52 UNIBANK SGBV BANK HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='3e2bb180-ccfa-11e6-b84a-a4c494c80537/account_move_line/5');
215+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CERU_CA060_60 MAIN SAFE HCERU CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae7d45e1-ccf8-11e6-b4b4-a4c494c80537/account_move_line/1');
216+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CERU_CA061_61 PETTY CASH HCERU CASH HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae7d45e1-ccf8-11e6-b4b4-a4c494c80537/account_move_line/3');
217+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_HT_CERU_BA062_62 UNIBANK HCERU BANK HTG') where id=(select res_id from ir_model_data where model='account.move.line' and name='ae7d45e1-ccf8-11e6-b4b4-a4c494c80537/account_move_line/5');
218+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA007_07 MAIN SAFE DELHI HQ CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1455');
219+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA002_02 MAIN SAFE HQ CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1457');
220+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA005_05 MAIN SAFE DELHI LO CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1459');
221+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA010_10 MAIN SAFE DELHI PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1461');
222+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA011_11 PETTY CASH DELHI PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1463');
223+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_CA009_09 MAIN SAFE DELHI HQ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1465');
224+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_BA004_04 AXIS BANK DELHI LO INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1467');
225+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_DELH_BA019_19 DEUTSCHE BANK DELHI PLC INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='345f9e00-b4fc-11e8-9832-ecb1d75c7ec2/account_move_line/1469');
226+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_MANI_CA056_56 PETTY CASH MANIPUR MOREH PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='37af7400-b4f6-11e8-81b1-ecb1d75c7ec2/account_move_line/944');
227+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_MANI_CA064_64 MAIN SAFE MANIPUR PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='37af7400-b4f6-11e8-81b1-ecb1d75c7ec2/account_move_line/946');
228+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_MANI_CA065_65 PETTY CASH MANIPUR PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='37af7400-b4f6-11e8-81b1-ecb1d75c7ec2/account_move_line/948');
229+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_MANI_BA063_63 HDFC BANK MANIPUR PLC INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='37af7400-b4f6-11e8-81b1-ecb1d75c7ec2/account_move_line/950');
230+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_CHHA_CA082_82 MAIN SAFE CHHATTISGARH PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='f6cea721-b4ec-11e8-b0e9-ecb1d75c7ec2/account_move_line/306');
231+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_CHHA_CA083_83 PETTY CASH CHHATTISGARH PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='f6cea721-b4ec-11e8-b0e9-ecb1d75c7ec2/account_move_line/308');
232+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_CHHA_BA081_81 UBI BANK CHHATTISGARH PLC INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='f6cea721-b4ec-11e8-b0e9-ecb1d75c7ec2/account_move_line/310');
233+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_KASH_CA042_42 MAIN SAFE SRINAGAR PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='092420f0-b4f5-11e8-93c6-ecb1d75c7ec2/account_move_line/204');
234+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_KASH_CA043_43 PETTY CASH SRINAGAR PLC CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='092420f0-b4f5-11e8-93c6-ecb1d75c7ec2/account_move_line/206');
235+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_KASH_BA041_41 J&K BANK SRINAGAR PLC INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='092420f0-b4f5-11e8-93c6-ecb1d75c7ec2/account_move_line/208');
236+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_SGBV_CA047_47 MAIN SAFE SGBV SEC 8 CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='4a7c44de-b4f7-11e8-a97a-ecb1d75c7ec2/account_move_line/1');
237+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_SGBV_CA048_48 PETTY CASH SGBV SEC 8 CASH INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='4a7c44de-b4f7-11e8-a97a-ecb1d75c7ec2/account_move_line/3');
238+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IN_SGBV_BA046_46 AXIS BANK SGBV SEC 8 INR') where id=(select res_id from ir_model_data where model='account.move.line' and name='4a7c44de-b4f7-11e8-a97a-ecb1d75c7ec2/account_move_line/5');
239+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_CA002_02 MAIN SAFE KURD CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/1');
240+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_CA004_04 PETTY CASH KURD CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/3');
241+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_CA001_01 MAIN SAFE KURD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/5');
242+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_CA003_03 PETTY CASH KURD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/7');
243+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_BA006_06 KURDISTAN BANK KURD BANK IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/9');
244+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_BA008_08 DAR ES SALAAM KURD BANK IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/11');
245+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_BA005_05 KURDISTAN BANK KURD BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/13');
246+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KURD_BA007_07 DAR ES SALAAM KURD BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a0e0bca1-2f0e-11e7-85c9-a4c494c80537/account_move_line/15');
247+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_SULI_CA022_22 PETTY CASH SULI CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1bde0700-2f0f-11e7-bebe-a4c494c80537/account_move_line/1');
248+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_SULI_CA024_24 MAIN SAFE SULI CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1bde0700-2f0f-11e7-bebe-a4c494c80537/account_move_line/3');
249+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_SULI_CA021_21 PETTY CASH SULI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1bde0700-2f0f-11e7-bebe-a4c494c80537/account_move_line/5');
250+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_SULI_CA023_23 MAIN SAFE SULI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1bde0700-2f0f-11e7-bebe-a4c494c80537/account_move_line/7');
251+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KHAQ_CA012_12 MAIN SAFE KHAQ CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='266ced8f-2f0e-11e7-8be5-a4c494c80537/account_move_line/1');
252+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KHAQ_CA014_14 PETTY CASH KHAQ CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='266ced8f-2f0e-11e7-8be5-a4c494c80537/account_move_line/3');
253+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KHAQ_CA011_11 MAIN SAFE KHAQ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='266ced8f-2f0e-11e7-8be5-a4c494c80537/account_move_line/5');
254+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_KHAQ_CA013_13 PETTY CASH KHAQ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='266ced8f-2f0e-11e7-8be5-a4c494c80537/account_move_line/7');
255+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_HAWI_CA026_26 MAIN SAFE KIRKUK CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9bef6fcf-2f0d-11e7-bc8e-a4c494c80537/account_move_line/1');
256+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_HAWI_CA028_28 PETTY CASH KIRKUK CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9bef6fcf-2f0d-11e7-bc8e-a4c494c80537/account_move_line/3');
257+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_HAWI_CA025_25 MAIN SAFE KIRKUK CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9bef6fcf-2f0d-11e7-bc8e-a4c494c80537/account_move_line/5');
258+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_IQ_HAWI_CA027_27 PETTY CASH KIRKUK CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9bef6fcf-2f0d-11e7-bc8e-a4c494c80537/account_move_line/7');
259+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_CA004_4 MAIN AMM CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/25');
260+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_CA002_2 PETTY AMM CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/29');
261+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_CA051_51 MAIN RW CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/31');
262+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_CA001_1 MAIN AMM CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/27');
263+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_CA003_3 MAIN AMM CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/33');
264+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_BA013_13 SCB AMM BANK JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/37');
265+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_BA010_10 SCB AMM SALARIES BANK JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/35');
266+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_AMM_BA011_11 SCB AMM BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='98c46e70-e06f-11e5-b431-d4c9efda6fb6/account_move_line/39');
267+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_RAM_CA021_21 MAIN RAM CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd2d7be1-e071-11e5-a008-d4c9efda6fb6/account_move_line/1');
268+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_RAM_CA022_22 PETTY RAM CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd2d7be1-e071-11e5-a008-d4c9efda6fb6/account_move_line/3');
269+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_IRB_CA031_31 MAIN IRB CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='e7ddcd1e-e070-11e5-962a-d4c9efda6fb6/account_move_line/1');
270+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_IRB_CA032_32 PETTY IRB CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='e7ddcd1e-e070-11e5-962a-d4c9efda6fb6/account_move_line/3');
271+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_ZAA_CA041_41 MAIN ZAA CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='bce4e840-e072-11e5-b92a-d4c9efda6fb6/account_move_line/1');
272+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_JO_ZAA_CA042_42 PETTY ZAA CASH JOD') where id=(select res_id from ir_model_data where model='account.move.line' and name='bce4e840-e072-11e5-b92a-d4c9efda6fb6/account_move_line/3');
273+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA008_08 PETTY CASH KO CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/1');
274+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA001_01 PETTY CASH KO CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/3');
275+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA030_30 PETTY CASH KENYA OFFICE CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/5');
276+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA005_05 PETTY CASH KO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/7');
277+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA031_31 PETTY CASH KENYA OFFICE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/9');
278+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA010_10 CBA KO BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/11');
279+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA034_34 CBA HCA KO BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/13');
280+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA003_03 CBA KO BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/15');
281+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA032_32 CBA HCA KO BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/17');
282+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA044_44 MPESA KO BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/19');
283+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA007_07 CBA KO BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/21');
284+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA033_33 CBA HCA KO BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/23');
285+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA008_08 PETTY CASH KO CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8660');
286+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA008_08 PETTY CASH KO CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8661');
287+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA001_01 PETTY CASH KO CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8663');
288+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA001_01 PETTY CASH KO CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8662');
289+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA005_05 PETTY CASH KO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8665');
290+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_CA005_05 PETTY CASH KO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8664');
291+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA003_03 CBA KO BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8667');
292+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA003_03 CBA KO BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8666');
293+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA007_07 CBA KO BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8669');
294+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LN_KNYA_BA007_07 CBA KO BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='19c72570-99ed-11e7-bec8-74dfbfd4b23f/account_move_line/8668');
295+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA001_01 MAIN SAFE TUNIS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/389');
296+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA002_02 MAIN SAFE TUNIS CASH TND') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/391');
297+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA003_03 PETTY CASH TUNIS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/393');
298+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA004_04 PETTY CASH TUNIS CASH TND') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/395');
299+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA005_05 PETTY CASH TUNIS CASH LYD') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/397');
300+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA030_30 MAIN SAFE CATANIA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/399');
301+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_CA031_31 PETTY CASH BOAT CATANIA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/403');
302+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TUNI_BA032_32 BANKA ETICA CATANIA BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='dd96c180-21fc-11e8-8e40-74dfbfd4b23f/account_move_line/405');
303+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TRIP_CA020_20 MAIN SAFE TRIPOLI CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='c9ddd76e-23b2-11e8-82be-74dfbfd4b23f/account_move_line/541');
304+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TRIP_CA021_21 MAIN SAFE TRIPOLI CASH LYD') where id=(select res_id from ir_model_data where model='account.move.line' and name='c9ddd76e-23b2-11e8-82be-74dfbfd4b23f/account_move_line/543');
305+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TRIP_CA023_23 PETTY CASH TRIPOLI CASH LYD') where id=(select res_id from ir_model_data where model='account.move.line' and name='c9ddd76e-23b2-11e8-82be-74dfbfd4b23f/account_move_line/545');
306+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TRIP_CA024_24 PETTY CASH TRIPOLI CASH TND') where id=(select res_id from ir_model_data where model='account.move.line' and name='c9ddd76e-23b2-11e8-82be-74dfbfd4b23f/account_move_line/549');
307+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_LY_TRIP_BA025_25 AMAN BANK TRIPOLI BANK LYD') where id=(select res_id from ir_model_data where model='account.move.line' and name='c9ddd76e-23b2-11e8-82be-74dfbfd4b23f/account_move_line/551');
308+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_CA026_26 PETTY CASH COORD CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/1');
309+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_CA013_13 MAIN SAFE COORD CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/3');
310+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_CA015_15 PETTY CASH COORD CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/5');
311+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_CA010_10 PETTY CASH COORD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/7');
312+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_CA025_25 MAIN SAFE COORD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/9');
313+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_BA014_14 KBZ COORD BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/11');
314+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_BA021_21 KBZ COORD BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/13');
315+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_MYAN_BA011_11 KBZ COORD BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8d0d11de-be4e-11e7-8abd-5065f31b555a/account_move_line/15');
316+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA043_43 PETTY CASH LAIZA CASH CNY') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/1');
317+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA041_41 PETTY CASH MYITKYINA CLINIC CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/3');
318+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA044_44 MAIN SAFE MYITKYINA CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/5');
319+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA045_45 PETTY CASH MYITKYINA OFFICE CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/7');
320+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA047_47 PETTY CASH LAIZA CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/9');
321+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA048_48 MAIN SAFE LAIZA CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/11');
322+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA049_49 PETTY CASH MOEGAUNG CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/13');
323+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA061_61 PETTY CASH HPAKANT CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/15');
324+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA064_64 MAIN SAFE HPAKANT CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/17');
325+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA071_71 PETTY CASH BHAMO CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/19');
326+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA074_74 MAIN SAFE BHAMO CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/21');
327+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_CA040_40 PETTY CASH MYITKYINA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/23');
328+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_BA046_46 KBZ MYITKYINA BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/25');
329+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_BA062_62 KBZ HPAKANT BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/27');
330+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_KACH_BA072_72 KBZ BHAMO BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ee8ba40-be4f-11e7-a327-5065f31b555a/account_move_line/29');
331+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA083_83 PETTY CASH MUSE CASH CNY') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/1');
332+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA081_81 PETTY CASH LASHIO CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/3');
333+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA084_84 PETTY CASH MUSE CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/5');
334+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA085_85 MAIN SAFE LASHIO CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/7');
335+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA091_91 MAIN SAFE MUSE CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/9');
336+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_CA080_80 PETTY CASH LASHIO CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/11');
337+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_BA087_87 KBZ LASHIO BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/13');
338+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_SHAN_BA089_89 KBZ MUSE BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='b30ca15e-be50-11e7-a67f-5065f31b555a/account_move_line/15');
339+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_CA016_16 PETTY CASH YANGON CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/1');
340+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_CA017_17 MAIN SAFE YANGON CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/3');
341+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_CA027_27 PETTY CASH YANGON INSEIN CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/5');
342+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_CA028_28 PETTY CASH YANGON TKT CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/7');
343+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_CA018_18 PETTY CASH YANGON CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/9');
344+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_YANG_BA022_22 KBZ YANGON BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b9450c0-be51-11e7-8f23-5065f31b555a/account_move_line/11');
345+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_NRS_CA053_53 PETTY CASH MAUNGDAW CASH BDT') where id=(select res_id from ir_model_data where model='account.move.line' and name='1da1228f-be50-11e7-8e4a-5065f31b555a/account_move_line/1');
346+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_NRS_CA051_51 PETTY CASH MAUNGDAW CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1da1228f-be50-11e7-8e4a-5065f31b555a/account_move_line/3');
347+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_NRS_CA054_54 MAIN SAFE MAUNGDAW CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1da1228f-be50-11e7-8e4a-5065f31b555a/account_move_line/5');
348+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_NRS_CA050_50 PETTY CASH MAUNGDAW CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1da1228f-be50-11e7-8e4a-5065f31b555a/account_move_line/7');
349+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_NRS_BA052_52 KBZ MAUNGDAW BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1da1228f-be50-11e7-8e4a-5065f31b555a/account_move_line/9');
350+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_ERS_CA031_31 PETTY CASH SITTWE CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1f40e551-be4f-11e7-9a61-5065f31b555a/account_move_line/1');
351+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_ERS_CA033_33 MAIN SAFE SITTWE CASH MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1f40e551-be4f-11e7-9a61-5065f31b555a/account_move_line/3');
352+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_ERS_CA030_30 PETTY CASH SITTWE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1f40e551-be4f-11e7-9a61-5065f31b555a/account_move_line/5');
353+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MM_ERS_BA032_32 KBZ SITTWE BANK MMK') where id=(select res_id from ir_model_data where model='account.move.line' and name='1f40e551-be4f-11e7-9a61-5065f31b555a/account_move_line/7');
354+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_CA001_01 MAIN SAFE PEN CASH MYR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/539');
355+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_CA002_02 MAIN SAFE PEN CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/541');
356+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_CA003_03 MAIN SAFE PEN CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/543');
357+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_CA004_04 MAIN SAFE PEN CASH SGD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/545');
358+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_CA008_08 PETTY CASH PEN CASH MYR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/547');
359+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_BA010_10 HSBC BANK WILLEMIEKE MYR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/549');
360+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_MY_COOR_BA011_11 CIMB BANK BEATRICE MYR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e0b7f4f-b098-11e6-968b-74dfbfd4b23f/account_move_line/551');
361+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA028_28 MAIN SAFE SOK CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/1');
362+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA032_32 MAIN SAFE SOK CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/3');
363+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA033_33 PETTY CASH SOK CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/5');
364+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA077_77 MAIN SAFE BORNO CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/7');
365+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA078_78 PETTY CASH BORNO CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/9');
366+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_CA034_34 MAIN SAFE SOK CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/11');
367+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_BA039_39 ZENITH BANK SOK BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/13');
368+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_BA037_37 ZENITH BANK SOK BANK NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/15');
369+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_COOR_BA038_38 ZENITH BANK SOK BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='aad15d8f-69df-11e6-94bd-3052cbe4f521/account_move_line/17');
370+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NOMA_CA040_40 MAIN SAFE NOMA CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='6412555e-69e1-11e6-8da5-3052cbe4f521/account_move_line/1');
371+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NOMA_CA041_41 PETTY CASH NOMA CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='6412555e-69e1-11e6-8da5-3052cbe4f521/account_move_line/3');
372+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NERU_CA050_50 PETTY CASH NERU CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='37939b30-69e0-11e6-9d2e-3052cbe4f521/account_move_line/1');
373+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_ANKA_CA070_70 PETTY CASH ANKA CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='dba68b80-69de-11e6-9190-3052cbe4f521/account_move_line/1');
374+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_ANKA_CA071_71 MAIN SAFE ANKA CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='dba68b80-69de-11e6-9190-3052cbe4f521/account_move_line/3');
375+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NGST_CA074_74 MAIN SAFE NIGER CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='c99b7c9e-69e0-11e6-85ea-3052cbe4f521/account_move_line/1');
376+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NGST_CA075_75 PETTY CASH NIGER CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='c99b7c9e-69e0-11e6-85ea-3052cbe4f521/account_move_line/3');
377+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_NGST_BA076_76 FIRST BANK NIGER BANK NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='c99b7c9e-69e0-11e6-85ea-3052cbe4f521/account_move_line/5');
378+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_ABUJ_CA013_13 PETTY CASH ABU CASH NGN') where id=(select res_id from ir_model_data where model='account.move.line' and name='2cef3830-69de-11e6-8847-3052cbe4f521/account_move_line/1');
379+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_NG_ABUJ_CA014_14 PETTY CASH ABU CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='2cef3830-69de-11e6-8847-3052cbe4f521/account_move_line/3');
380+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_CA009_09 PETTY CASH ISB CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1896');
381+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_CA012_12 MAIN SAFE ISB CASH PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1898');
382+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_CA017_17 PETTY CASH ISB CASH PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1900');
383+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_CA010_10 MAIN SAFE ISB CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1902');
384+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_BA019_19 BANK ISB EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1904');
385+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_BA013_13 BANK ISB PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1906');
386+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_BA015_15 BANK H ISB PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1908');
387+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_BA061_61 BANK SUKKUR PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1910');
388+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_ISB_BA011_11 BANK ISB USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='11f484c0-f784-11e6-9a3e-74dfbfd49121/account_move_line/1912');
389+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_QUET_CA022_22 PETTY CASH QUETTA CASH PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='24187da1-f473-11e6-896d-74dfbfd49121/account_move_line/351');
390+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_QUET_BA020_20 BANK QUETTA PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='24187da1-f473-11e6-896d-74dfbfd49121/account_move_line/353');
391+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_DERA_CA032_32 PETTY CASH DMJ CASH PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='3d427ccf-f474-11e6-97bc-74dfbfd49121/account_move_line/780');
392+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_DERA_BA031_31 BANK H DMJ PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='3d427ccf-f474-11e6-97bc-74dfbfd49121/account_move_line/782');
393+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_CHAM_CA040_40 PETTY CASH CHAMAN CASH PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='02c67b30-f472-11e6-b085-74dfbfd49121/account_move_line/559');
394+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_PK_CHAM_BA041_41 BANK H CHAMAN PKR') where id=(select res_id from ir_model_data where model='account.move.line' and name='02c67b30-f472-11e6-b085-74dfbfd49121/account_move_line/561');
395+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_CA081_81 MAIN SAFE MOS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/1');
396+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_CA077_77 MAIN SAFE MOS CASH RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/3');
397+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_CA078_78 PETTY CASH MOS CASH RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/5');
398+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_BA054_54 ALFABANK GROZ BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/7');
399+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_BA074_74 RBS BANK MOS EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/9');
400+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_BA053_53 ALFABANK MOS-GROZ BANK RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/11');
401+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MOSC_BA073_73 RBS BANK MOS RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='fca37b4f-91fb-11e6-a02a-74dfbfd4876f/account_move_line/13');
402+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_GROZ_CA057_57 MAIN SAFE GROZ CASH RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b5c78e1-91fb-11e6-9fd9-74dfbfd4876f/account_move_line/1');
403+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_GROZ_CA058_58 PETTY CASH GROZ CASH RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b5c78e1-91fb-11e6-9fd9-74dfbfd4876f/account_move_line/3');
404+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_GROZ_BA052_52 SBERBANK GROZ BANK RUB') where id=(select res_id from ir_model_data where model='account.move.line' and name='6b5c78e1-91fb-11e6-9fd9-74dfbfd4876f/account_move_line/5');
405+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MINS_CA069_69 MAIN SAFE MINS CASH BYN') where id=(select res_id from ir_model_data where model='account.move.line' and name='a818adde-91fa-11e6-9c08-74dfbfd4876f/account_move_line/1');
406+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MINS_CA061_61 MAIN SAFE MINS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='a818adde-91fa-11e6-9c08-74dfbfd4876f/account_move_line/3');
407+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MINS_BA060_60 PRIOR BANK MINS BANK BYN') where id=(select res_id from ir_model_data where model='account.move.line' and name='a818adde-91fa-11e6-9c08-74dfbfd4876f/account_move_line/5');
408+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_RU_MINS_BA064_64 PRIOR BANK MINS BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='a818adde-91fa-11e6-9c08-74dfbfd4876f/account_move_line/7');
409+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_CA012_12 MAIN SAFE FREETOWN CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/1');
410+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_CA010_10 MAIN SAFE FREETOWN CASH SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/3');
411+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_CA013_13 PETTY CASH FREETOWN CASH SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/5');
412+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_CA011_11 MAIN SAFE FREETOWN CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/7');
413+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_BA015_15 SCB FREETOWN BANK SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/9');
414+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_FRTN_BA017_17 SCB FREETOWN BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='d81c274f-1919-11e7-9514-5065f31b555a/account_move_line/11');
415+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_MAGB_CA060_60 PETTY CASH MAGB CASH SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e490880-191a-11e7-b5dc-5065f31b555a/account_move_line/1');
416+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_MAGB_CA061_61 MAIN SAFE MAGB SAFE SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e490880-191a-11e7-b5dc-5065f31b555a/account_move_line/3');
417+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SL_MAGB_BA062_62 FIB MAGB BANK SLL') where id=(select res_id from ir_model_data where model='account.move.line' and name='9e490880-191a-11e7-b5dc-5065f31b555a/account_move_line/5');
418+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_CA018_18 PETTY CASH SOMALIA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/1');
419+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_CA011_11 PETTY CASH SOMALIA CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/3');
420+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_CA014_14 MAIN SAFE SOMALIA CASH KES ') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/5');
421+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_CA015_15 PETTY CASH SOMALIA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/7');
422+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA020_20 KCB SOMALIA BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/9');
423+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA037_37 CBA SOMALIA BANK EUR HCA') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/11');
424+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA013_13 CBA SOMALIA BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/13');
425+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA035_35 CBA SOMALIA BANK KES HCA') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/15');
426+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA017_17 CBA SOMALIA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/17');
427+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SO_SOMA_BA036_36 CBA SOMALIA BANK USD HCA') where id=(select res_id from ir_model_data where model='account.move.line' and name='9eb0b0f0-99f0-11e7-8cad-74dfbfd4b23f/account_move_line/19');
428+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA003_03 MAIN SAFE JUBA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/813');
429+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA001_01 MAIN SAFE JUBA CASH SSP ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/815');
430+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA004_04 PETTY CASH JUBA CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/817');
431+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA031_31 PETTY CASH MUNDRI CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/819');
432+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA040_40 MAIN SAFE BENTIU CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/821');
433+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA041_41 PETTY CASH BENTIU CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/823');
434+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA050_50 MAIN SAFE LANKIEN CASH SSP ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/825');
435+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA051_51 PETTY CASH LANKIEN CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/827');
436+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA061_61 PETTY CASH SOUTHERN UNITY CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/829');
437+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA002_02 MAIN SAFE JUBA CASH USD ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/831');
438+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA005_05 PETTY CASH JUBA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/833');
439+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA012_12 PETTY CASH EXPAT JUBA CASH USD ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/835');
440+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA032_32 PETTY CASH MUNDRI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/837');
441+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA042_42 PETTY CASH BENTIU CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/839');
442+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA043_43 MAIN SAFE BENTIU CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/841');
443+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA052_52 PETTY CASH LANKIEN CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/843');
444+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA053_53 MAIN SAFE LANKIEN CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/845');
445+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA062_62 PETTY CASH SOUTHERN UNITY CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/847');
446+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA006_06 EQUITY BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/849');
447+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA008_08 KCB BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/851');
448+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA013_13 ECO BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/853');
449+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA007_07 EQUITY BANK JUBA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/855');
450+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA015_15 ECO BANK JUBA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/857');
451+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA003_03 MAIN SAFE JUBA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10479');
452+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA003_03 MAIN SAFE JUBA CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10480');
453+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA006_06 EQUITY BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10486');
454+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA001_01 MAIN SAFE JUBA CASH SSP ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10488');
455+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA004_04 PETTY CASH JUBA CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10487');
456+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA008_08 KCB BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10481');
457+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA006_06 EQUITY BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10482');
458+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA004_04 PETTY CASH JUBA CASH SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10483');
459+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA001_01 MAIN SAFE JUBA CASH SSP ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10484');
460+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA008_08 KCB BANK JUBA BANK SSP') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10485');
461+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA005_05 PETTY CASH JUBA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10493');
462+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA002_02 MAIN SAFE JUBA CASH USD ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10494');
463+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA007_07 EQUITY BANK JUBA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10489');
464+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA005_05 PETTY CASH JUBA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10490');
465+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_CA002_02 MAIN SAFE JUBA CASH USD ') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10491');
466+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_JUBA_BA007_07 EQUITY BANK JUBA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='1a0e54b0-99fa-11e7-9797-74dfbfd4b23f/account_move_line/10492');
467+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA029_29 MAIN SAFE LOKI CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/1');
468+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA019_19 PETTY CASH LOKI CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/3');
469+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA021_21 PETTY CASH LOKI CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/5');
470+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA024_24 MAIN SAFE LOKI CASH KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/7');
471+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA020_20 PETTY CASH LOKI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/9');
472+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA025_25 PETTY CASH LOKI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/11');
473+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_CA028_28 MAIN SAFE LOKI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/13');
474+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_BA023_23 KCB LOKI BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/15');
475+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_BA038_38 KCB LOKI BANK KES HCA') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/17');
476+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_BA043_43 MPESA LOKI BANK KES') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/19');
477+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_BA027_27 KCB LOKI BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/21');
478+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SU_LOKI_BA039_39 KCB LOKI BANK USD HCA') where id=(select res_id from ir_model_data where model='account.move.line' and name='99a1288f-9a01-11e7-83cf-74dfbfd4b23f/account_move_line/23');
479+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_BA020_20 ING AZG URFA BANK TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5129');
480+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_BA022_22 ING AZG URFA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5131');
481+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_BA027_27 ALBARAKA SUT URFA BANK TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5133');
482+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_BA028_28 ALBARAKA SUT URFA BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5135');
483+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA001_01 MAIN SAFE AZG URFA CASH TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5137');
484+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA003_03 MAIN SAFE AZG URFA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5139');
485+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA007_07 PETTY CASH AZG URFA CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5141');
486+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA017_17 PETTY CASH AZG URFA CASH TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5143');
487+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA018_18 PETTY CASH SUT URFA CASH TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5145');
488+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA009_09 PETTY CASH AZG EXPLO CASH TRY') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5147');
489+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA043_43 MAIN SAFE QAMISHLI CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5149');
490+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA046_46 PETTY CASH QAMISHLI CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5151');
491+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA047_47 PETTY CASH QAMISHLI CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5153');
492+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA050_50 PETTY CASH MENBIJ CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5155');
493+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA051_51 PETTY CASH MENBIJ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5157');
494+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_COOR_CA053_53 MAIN SAFE MENBIJ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='07848bcf-2789-11e8-8ce4-74dfbfd4b23f/account_move_line/5159');
495+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_KOBA_CA036_36 MAIN SAFE KOBANE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='ab0cef80-2870-11e8-9db9-74dfbfd4b23f/account_move_line/880');
496+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_KOBA_CA038_38 PETTY CASH KOBANE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='ab0cef80-2870-11e8-9db9-74dfbfd4b23f/account_move_line/882');
497+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_KOBA_CA039_39 PETTY CASH KOBANE CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='ab0cef80-2870-11e8-9db9-74dfbfd4b23f/account_move_line/884');
498+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_TALA_CA040_40 PETTY CASH TAL ABYAD CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='86a5e80f-2873-11e8-9e23-74dfbfd4b23f/account_move_line/1353');
499+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_TALA_CA041_41 PETTY CASH TAL ABYAD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='86a5e80f-2873-11e8-9e23-74dfbfd4b23f/account_move_line/1355');
500+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_TALA_CA044_44 MAIN SAFE TAL ABYAD CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='86a5e80f-2873-11e8-9e23-74dfbfd4b23f/account_move_line/1357');
501+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_TALA_CA045_45 MAIN SAFE TAL ABYAD CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='86a5e80f-2873-11e8-9e23-74dfbfd4b23f/account_move_line/1359');
502+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_RAQQ_CA084_84 PETTY CASH MISHLAB CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='8c56ed4f-2872-11e8-9d84-74dfbfd4b23f/account_move_line/1003');
503+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_RAQQ_CA085_85 PETTY CASH MISHLAB CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8c56ed4f-2872-11e8-9d84-74dfbfd4b23f/account_move_line/1005');
504+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_RAQQ_CA086_86 MAIN SAFE MISHLAB CASH SYP') where id=(select res_id from ir_model_data where model='account.move.line' and name='8c56ed4f-2872-11e8-9d84-74dfbfd4b23f/account_move_line/1007');
505+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_BA067_67 KIB ERBIL BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1215');
506+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_BA068_68 KIB ERBIL BANK IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1217');
507+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_BA072_72 CIHAN ERBIL BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1219');
508+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_BA073_73 CIHAN ERBIL BANK IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1221');
509+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_CA064_64 PETTY CASH ERBIL CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1223');
510+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_CA065_65 PETTY CASH ERBIL CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1225');
511+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_CA066_66 MAIN SAFE ERBIL CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1227');
512+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SY_ERBI_CA071_71 MAIN SAFE ERBIL CASH IQD') where id=(select res_id from ir_model_data where model='account.move.line' and name='b6599c1e-2790-11e8-951b-74dfbfd4b23f/account_move_line/1229');
513+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_CA010_10 PETTY CASH MANZ CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/7');
514+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_BA020_20 STB MANZ BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/9');
515+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_CA011_11 PETTY CASH MANZ CASH SZL') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/55');
516+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_CA014_14 MAIN SAFE MANZ CASH SZL') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/57');
517+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_BA021_21 STB MANZ BANK SZL') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/59');
518+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MANZ_CA012_12 PETTY CASH MANZ CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='6c67870f-017e-11e6-8b52-ecb1d73cc305/account_move_line/117');
519+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MATS_CA016_16 MAIN SAFE MATS CASH SZL') where id=(select res_id from ir_model_data where model='account.move.line' and name='252624f0-017f-11e6-b029-ecb1d73cc305/account_move_line/1');
520+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_SZ_MONE_CA017_17 PETTY CASH MONE CASH SZL') where id=(select res_id from ir_model_data where model='account.move.line' and name='eb47bb80-017f-11e6-8b1b-ecb1d73cc305/account_move_line/1');
521+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA002_2 MAIN SAFE DUS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/1');
522+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA003_3 MAIN SAFE DUS CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/3');
523+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA004_4 PETTY CASH DUS CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/5');
524+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA006_6 PETTY CASH PRIVATE DUS CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/7');
525+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA001_1 MAIN SAFE DUS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/9');
526+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA005_5 PETTY CASH PRIVATE DUS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/11');
527+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_CA007_7 PETTY CASH DUS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/13');
528+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_BA012_12 BANK CORP DUS BANK TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/15');
529+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_BA017_17 CORPORATE PLASTIC CARD DUS BANK TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/17');
530+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_BA010_10 BANK PRIVATE DUS BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/19');
531+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_DUSH_BA013_13 BANK CORP DUS BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='a6b2836e-23f7-11e6-abe7-3052cbe4f521/account_move_line/21');
532+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_KULO_CA020_20 PETTY CASH KUL CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='df554dae-23f8-11e6-94b8-3052cbe4f521/account_move_line/1');
533+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_KULO_CA021_21 MAIN SAFE KUL CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='df554dae-23f8-11e6-94b8-3052cbe4f521/account_move_line/3');
534+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_KULO_CA022_22 PETTY PRIVATE CASH KUL CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='df554dae-23f8-11e6-94b8-3052cbe4f521/account_move_line/5');
535+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_KULO_BA024_24 MAIN PLASTIC KUL BANK TJS  ') where id=(select res_id from ir_model_data where model='account.move.line' and name='df554dae-23f8-11e6-94b8-3052cbe4f521/account_move_line/7');
536+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_TJ_KULO_BA025_25 BANK CORP KUL BANK TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='df554dae-23f8-11e6-94b8-3052cbe4f521/account_move_line/9');
537+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA019_19 PETTY CASH PRIVATE TAS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/1');
538+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA028_28 MAIN SAFE PRIVATE FINCO TAS CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/3');
539+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA014_14 PETTY CASH PRIVATE TAS CASH TJS') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/5');
540+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA010_10 PETTY CASH PRIVATE TAS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/7');
541+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA011_11 PETTY CASH PRIVATE TAS CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/9');
542+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_CA012_12 MAIN SAFE PRIVATE FINCO TAS CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/11');
543+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_BA039_39 CREDIT CARD PRIVATE TAS BANK EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/13');
544+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_BA026_26 KAPITAL BANK CORP TAS BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/15');
545+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_BA034_34 KAPITAL BANK TAS BANK UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/17');
546+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_TASH_BA035_35 CORP CARD TAS BANK UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='339fddcf-23fa-11e6-9c15-3052cbe4f521/account_move_line/19');
547+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_NUKU_CA020_20 MAIN SAFE PRIVATE NUK CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='7d138940-23f9-11e6-bd2d-3052cbe4f521/account_move_line/1');
548+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_NUKU_CA021_21 PETTY CASH PRIVATE NUK CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='7d138940-23f9-11e6-bd2d-3052cbe4f521/account_move_line/3');
549+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_NUKU_CA022_22 MAIN SAFE PRIVATE NUK CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='7d138940-23f9-11e6-bd2d-3052cbe4f521/account_move_line/5');
550+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_NUKU_BA024_24 CORP CT PLASTIC NUK BANK UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='7d138940-23f9-11e6-bd2d-3052cbe4f521/account_move_line/7');
551+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_NUKU_BA037_37 CORP PLASTIC CARD NUK BANK UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='7d138940-23f9-11e6-bd2d-3052cbe4f521/account_move_line/9');
552+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_THIV_CA042_42 MAIN CASH PRIVATE HIV TAS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f64ebbcf-23fa-11e6-be9e-3052cbe4f521/account_move_line/1');
553+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_THIV_CA045_45 PETTY CASH PRIVATE HIV TAS CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='f64ebbcf-23fa-11e6-be9e-3052cbe4f521/account_move_line/3');
554+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_THIV_CA040_40 MAIN SAFE PRIVATE HIV TAS CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='f64ebbcf-23fa-11e6-be9e-3052cbe4f521/account_move_line/5');
555+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_THIV_CA041_41 PETTY CASH PRIVATE HIV TAS CASH UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='f64ebbcf-23fa-11e6-be9e-3052cbe4f521/account_move_line/7');
556+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_UZ_THIV_CA043_43 CORPORATE PLASTIC CARD TAS BANK UZS') where id=(select res_id from ir_model_data where model='account.move.line' and name='f64ebbcf-23fa-11e6-be9e-3052cbe4f521/account_move_line/9');
557+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_CA001_01 MAIN SAFE SANA''A CASH YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/523');
558+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_CA002_02 PETTY CASH SANA''A CASH YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/525');
559+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_CA003_03 MAIN SAFE SANA''A CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/527');
560+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_CA004_04 PETTY CASH SANA''A CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/529');
561+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_CA005_05 MAIN SAFE SANA''A CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/531');
562+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_BA006_06 TIIB SANA''A BANK YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/533');
563+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_COOR_BA008_08 TIIB SANA''A BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='db75d980-420a-11e8-85aa-5065f31b555a/account_move_line/535');
564+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_ADDH_BA022_22 TIIB ADDHALE BANK YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='734ed80f-421a-11e8-b7b1-5065f31b555a/account_move_line/1');
565+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_ADDH_BA024_24 TIIB ADDHALE BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='734ed80f-421a-11e8-b7b1-5065f31b555a/account_move_line/3');
566+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_HOUB_CA031_31 PETTY CASH TAIZ HOUBAN CASH YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='4b86c1f0-4236-11e8-a823-5065f31b555a/account_move_line/224');
567+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_HOUB_CA030_30 MAIN SAFE TAIZ HOUBAN CASH YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='4b86c1f0-4236-11e8-a823-5065f31b555a/account_move_line/226');
568+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_HOUB_BA032_32 TIIB TAIZ HOUBAN BANK YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='4b86c1f0-4236-11e8-a823-5065f31b555a/account_move_line/228');
569+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_HOUB_BA034_34 TIIB TAIZ HOUBAN BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='4b86c1f0-4236-11e8-a823-5065f31b555a/account_move_line/230');
570+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_TAIZ_CA041_41 PETTY CASH TAIZ CITY CASH YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='cc26c140-4257-11e8-a99f-5065f31b555a/account_move_line/1');
571+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_TAIZ_BA042_42 TIIB TAIZ CITY BANK YER') where id=(select res_id from ir_model_data where model='account.move.line' and name='cc26c140-4257-11e8-a99f-5065f31b555a/account_move_line/3');
572+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_YE_TAIZ_BA044_44 TIIB TAIZ CITY BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='cc26c140-4257-11e8-a99f-5065f31b555a/account_move_line/5');
573+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARARE_CA010_10 MAIN SAFE HRE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='5bf4e18f-b5c8-11e5-9cdc-d4c9efda6fb6/account_move_line/1');
574+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARARE_CA011_11 PETTY CASH HRE CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='5bf4e18f-b5c8-11e5-9cdc-d4c9efda6fb6/account_move_line/3');
575+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARARE_CA015_15 PETTY CASH HRE CASH EUR') where id=(select res_id from ir_model_data where model='account.move.line' and name='5bf4e18f-b5c8-11e5-9cdc-d4c9efda6fb6/account_move_line/5');
576+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARARE_CA016_16 PETTY CASH HRE CASH ZAR') where id=(select res_id from ir_model_data where model='account.move.line' and name='5bf4e18f-b5c8-11e5-9cdc-d4c9efda6fb6/account_move_line/7');
577+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARARE_BA012_12 BARCLAYS HRE BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='5bf4e18f-b5c8-11e5-9cdc-d4c9efda6fb6/account_move_line/9');
578+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_EPW_CA041_41 PETTY CASH EPW CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='0ab9facf-c02d-11e5-a5a8-d4c9efda6fb6/account_move_line/1');
579+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_EPW_CA044_44 MAIN SAFE EPW CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='0ab9facf-c02d-11e5-a5a8-d4c9efda6fb6/account_move_line/3');
580+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_EPW_BA042_42 NMB EPW BANK USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='0ab9facf-c02d-11e5-a5a8-d4c9efda6fb6/account_move_line/5');
581+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARPSY_CA051_51 PETTY CASH HPP CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ff820de-c02e-11e5-9198-d4c9efda6fb6/account_move_line/1');
582+update account_move_line set journal_id = (select res_id from ir_model_data where model='account.journal' and name='journal_ZW_HARPSY_CA053_53 MAIN SAFE HPP CASH USD') where id=(select res_id from ir_model_data where model='account.move.line' and name='8ff820de-c02e-11e5-9198-d4c9efda6fb6/account_move_line/3');
583
584=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
585--- bin/addons/msf_profile/i18n/fr_MF.po 2023-08-16 09:21:58 +0000
586+++ bin/addons/msf_profile/i18n/fr_MF.po 2023-09-22 12:20:31 +0000
587@@ -4744,8 +4744,9 @@
588 msgid "Back Order"
589 msgstr "Livraison en attente"
590
591-#. module: finance
592+#. module: finance, vertical_integration
593 #: report:cash.request.export:0
594+#: code:addons/vertical_integration/report/field_balance_spec_report.py:329
595 msgid "Month:"
596 msgstr "Mois :"
597
598@@ -5733,6 +5734,7 @@
599 #. module: vertical_integration
600 #: field:ocb.export.wizard,selection:0
601 #: field:wizard.hq.report.oca,selection:0
602+#: field:field.balance.spec.report,selection:0
603 msgid "Select"
604 msgstr "Sélectionner"
605
606@@ -16379,7 +16381,7 @@
607 msgid "Salesman"
608 msgstr "Responsable"
609
610-#. modules: msf_instance, finance, register_accounting
611+#. modules: msf_instance, finance, register_accounting, vertical_integration
612 #: field:cash.request,prop_instance_id:0
613 #: field:cash.request.liquidity,instance_id:0
614 #: field:cash.request.liquidity.bank,instance_id:0
615@@ -16388,6 +16390,7 @@
616 #: field:msf_instance.setup,instance_id:0
617 #: report:addons/register_accounting/report/liquidity_position_xls.mako:315
618 #: report:addons/register_accounting/report/liquidity_position_xls.mako:467
619+#: code:addons/vertical_integration/report/field_balance_spec_report.py:589
620 msgid "Proprietary instance"
621 msgstr "Instance propriétaire"
622
623@@ -23927,9 +23930,10 @@
624 msgid "Select this if you want to keep track of deletion on any record of the object of this rule"
625 msgstr "Sélectionner si vous voulez suivre l'annulation de tout enregistrement au sujet de cette règle"
626
627-#. modules: base, res_currency_tables
628+#. modules: base, res_currency_tables, vertical_integration
629 #: field:warning.import.currencies.lines,rate:0
630 #: field:res.currency.rate,rate:0
631+#: code:addons/vertical_integration/report/field_balance_spec_report.py:777
632 msgid "Rate"
633 msgstr "Taux"
634
635@@ -25355,6 +25359,7 @@
636 #: field:free.allocation.wizard,period_id:0
637 #: selection:integrity.finance.wizard,filter:0
638 #: report:addons/account/report/export_cv.mako:133
639+#: field:field.balance.spec.report,period_id:0
640 #, python-format
641 msgid "Period"
642 msgstr "Période"
643@@ -28394,7 +28399,7 @@
644 msgid "XML Identifier"
645 msgstr "Identifiant XML"
646
647-#. modules: msf_budget, account, stock_move_tracking, product, sale, stock_forecast, purchase_allocation_report, order_types, account_override
648+#. modules: msf_budget, account, stock_move_tracking, product, sale, stock_forecast, purchase_allocation_report, order_types, account_override, vertical_integration
649 #: view:account.aged.trial.balance:0
650 #: view:account.analytic.Journal.report:0
651 #: view:account.analytic.balance:0
652@@ -28412,6 +28417,7 @@
653 #: view:stock.forecast:0
654 #: view:stock.move.tracking:0
655 #: view:integrity.finance.wizard:0
656+#: view:field.balance.spec.report:0
657 msgid "Print"
658 msgstr "Imprimer"
659
660@@ -40042,7 +40048,7 @@
661 msgid "audittrail.log.sequence"
662 msgstr "audittrail.log.sequence"
663
664-#. modules: msf_doc_import, register_accounting, account_mcdb, analytic_distribution, account
665+#. modules: msf_doc_import, register_accounting, account_mcdb, analytic_distribution, account, vertical_integration
666 #: view:account.mcdb:0
667 #: field:analytic.distribution.wizard,document_date:0
668 #: field:msf.doc.import.accounting.lines,document_date:0
669@@ -40050,6 +40056,7 @@
670 #: field:account.direct.invoice.wizard,document_date:0
671 #: report:addons/account/report/free_allocation_report.mako:172
672 #: field:free.allocation.wizard,document_date_from:0
673+#: code:addons/vertical_integration/report/field_balance_spec_report.py:96
674 msgid "Document date"
675 msgstr "Date du document"
676
677@@ -47852,7 +47859,7 @@
678 msgid "Bangladesh"
679 msgstr "Bengladesh"
680
681-#. modules: account, msf_instance, finance, register_accounting
682+#. modules: account, msf_instance, finance, register_accounting, vertical_integration
683 #: field:account.analytic.journal,name:0
684 #: report:account.general.journal:0
685 #: field:account.journal,name:0
686@@ -47865,6 +47872,7 @@
687 #: field:account.journal.fake,name:0
688 #: report:addons/register_accounting/report/liquidity_position_xls.mako:321
689 #: report:addons/register_accounting/report/liquidity_position_xls.mako:473
690+#: code:addons/vertical_integration/report/field_balance_spec_report.py:588
691 msgid "Journal Name"
692 msgstr "Nom du Journal"
693
694@@ -64102,8 +64110,9 @@
695 msgid "Nothing to import"
696 msgstr "Rien à importer"
697
698-#. module: account_mcdb
699+#. module: account_mcdb, vertical_integration
700 #: selection:account.mcdb,currency_choice:0
701+#: code:addons/vertical_integration/report/field_balance_spec_report.py:94
702 msgid "Booking"
703 msgstr "Enregistrement"
704
705@@ -66668,6 +66677,7 @@
706 #: field:ocp.matching.export.wizard,instance_id:0
707 #: field:wizard.hq.report.oca,instance_id:0
708 #: field:wizard.hq.report.ocg,instance_id:0
709+#: field:field.balance.spec.report,instance_id:0
710 msgid "Top proprietary instance"
711 msgstr "Instance propriétaire parente"
712
713@@ -91134,7 +91144,7 @@
714 msgid "This is the list of all your pack types."
715 msgstr "Ceci est la liste de tous vos types de colis."
716
717-#. modules: account, account_mcdb, register_accounting, account_corrections, msf_doc_import, analytic_distribution
718+#. modules: account, account_mcdb, register_accounting, account_corrections, msf_doc_import, analytic_distribution, vertical_integration
719 #: field:account.invoice.refund,date:0
720 #: selection:account.journal.column,field:0
721 #: field:account.move.line,date:0
722@@ -91148,6 +91158,8 @@
723 #: report:addons/account/report/free_allocation_report.mako:173
724 #: field:free.allocation.wizard,posting_date_from:0
725 #: report:addons/account/report/invoice_excel_export.mako:78
726+#: code:addons/vertical_integration/report/field_balance_spec_report.py:100
727+#, python-format
728 msgid "Posting date"
729 msgstr "Date de Comptabilisation"
730
731@@ -97521,6 +97533,7 @@
732 #: view:select.actual.ship.date.wizard:0
733 #: view:non.conform.inpipe:0
734 #: view:warning.pick.partial.process.sign.wizard:0
735+#: view:field.balance.spec.report:0
736 #, python-format
737 msgid "Cancel"
738 msgstr "Annuler"
739@@ -97629,11 +97642,13 @@
740 msgid "Bank Account No"
741 msgstr "N° de Compte Bancaire"
742
743-#. modules: res_currency_functional, base, res_currency_tables
744+#. modules: res_currency_functional, base, res_currency_tables, vertical_integration
745 #: view:res.currency:0
746 #: field:res.currency,rate_ids:0
747 #: view:res.currency:0
748 #: view:res.currency.table:0
749+#: code:addons/vertical_integration/report/field_balance_spec_report.py:281
750+#: code:addons/vertical_integration/report/field_balance_spec_report.py:283
751 msgid "Rates"
752 msgstr "Taux"
753
754@@ -101632,7 +101647,7 @@
755 msgid "Linked Information"
756 msgstr "Information liée"
757
758-#. module: account
759+#. module: account, vertical_integration
760 #: report:account.third_party_ledger:0
761 #: report:account.third_party_ledger_other:0
762 #: report:addons/account/report/account_partner_ledger.mako:310
763@@ -101641,6 +101656,7 @@
764 #: report:account.employee_ledger:0
765 #: report:account.employee_ledger_other:0
766 #: report:addons/account/report/account_employee_ledger.mako:312
767+#: code:addons/vertical_integration/report/field_balance_spec_report.py:794
768 msgid "Reconcile Number"
769 msgstr "Numéro de lettrage"
770
771@@ -121443,10 +121459,255 @@
772 msgid "Partial process warning if signature"
773 msgstr "Avertissement si traitement partiel et signature"
774
775+#. module: vertical_integration
776+#: code:addons/vertical_integration/report/field_balance_spec_report.py:656
777+#: code:addons/vertical_integration/report/field_balance_spec_report.py:778
778+#, python-format
779+msgid "%s Amount"
780+msgstr "Montant en %s"
781+
782+#. module: vertical_integration
783+#: code:addons/vertical_integration/report/field_balance_spec_report.py:594
784+#, python-format
785+msgid "%s Amount with Current Period Rate"
786+msgstr "Montant en %s avec le Taux de la Période"
787+
788+#. module: vertical_integration
789+#: code:addons/vertical_integration/report/field_balance_spec_report.py:781
790+#, python-format
791+msgid "%s Amount with Current Period Rate"
792+msgstr "Montant en %s avec le Taux de la Période"
793+
794+#. module: vertical_integration
795+#: code:addons/vertical_integration/report/field_balance_spec_report.py:431
796+#: code:addons/vertical_integration/report/field_balance_spec_report.py:596
797+#: code:addons/vertical_integration/report/field_balance_spec_report.py:793
798+#, python-format
799+msgid "%s Amount with Year End Rate Currency Table"
800+msgstr "Montant en %s avec le Taux de fin d'année"
801+
802+#. module: vertical_integration
803+#: code:addons/vertical_integration/report/field_balance_spec_report.py:427
804+#, python-format
805+msgid "Balance accounts"
806+msgstr "Comptes de Bilan"
807+
808+#. module: vertical_integration
809+#: code:addons/vertical_integration/report/field_balance_spec_report.py:309
810+#, python-format
811+msgid "Country Program"
812+msgstr "Programme Pays"
813+
814+#. module: vertical_integration
815+#: code:addons/vertical_integration/report/field_balance_spec_report.py:591
816+#: code:addons/vertical_integration/report/field_balance_spec_report.py:788
817+#, python-format
818+msgid "Curr"
819+msgstr "Dev."
820+
821+#. module: vertical_integration
822+#: code:addons/vertical_integration/report/field_balance_spec_report.py:592
823+#: code:addons/vertical_integration/report/field_balance_spec_report.py:789
824+#, python-format
825+msgid "Currency Amount"
826+msgstr "Montant en devise"
827+
828+#. module: vertical_integration
829+#: code:addons/vertical_integration/report/field_balance_spec_report.py:282
830+#, python-format
831+msgid "Current period"
832+msgstr "Cette periode"
833+
834+#. module: vertical_integration
835+#: code:addons/vertical_integration/report/field_balance_spec_report.py:331
836+#, python-format
837+msgid "Date of review"
838+msgstr "Date de revue"
839+
840+#. module: vertical_integration
841+#: code:addons/vertical_integration/report/field_balance_spec_report.py:311
842+#, python-format
843+msgid "Date of the report"
844+msgstr "Date du rapport"
845+
846+#. module: vertical_integration
847+#: code:addons/vertical_integration/report/field_balance_spec_report.py:785
848+#, python-format
849+msgid "Description of the entry"
850+msgstr "Description de l'écriture"
851+
852+#. module: vertical_integration
853+#: selection:field.balance.spec.report,selection:0
854+msgid "Details of entries reconciled in later period"
855+msgstr "Détail des écritures lettrées dans une période ultérieure"
856+
857+#. module: vertical_integration
858+#: code:addons/vertical_integration/report/field_balance_spec_report.py:1062
859+#, python-format
860+msgid "END OF FIELD BALANCE SPECIFICATION REPORT"
861+msgstr "FIN DU RAPPORT BALANCE SPÉCIFICATION TERRAIN - UNIFIELD"
862+
863+#. module: vertical_integration
864+#: code:addons/vertical_integration/report/field_balance_spec_report.py:284
865+#: field:field.balance.spec.report,eoy:0
866+#, python-format
867+msgid "End of Year"
868+msgstr "Fin d'Année"
869+
870+#. module: vertical_integration
871+#: view:field.balance.spec.report:0
872+#: model:ir.actions.report.xml,name:vertical_integration.field_balance_spec_report
873+msgid "FIELD BALANCE SPECIFICATION REPORT"
874+msgstr "RAPPORT BALANCE SPÉCIFICAITON TERRAIN"
875+
876+#. module: vertical_integration
877+#: model:ir.actions.report.xml,name:vertical_integration.field_balance
878+msgid "FIELD BALANCE SPECIFICATION REPORT FROM UNIFIELD"
879+msgstr "RAPPORT BALANCE SPÉCIFICAITON TERRAIN - UNIFIELD"
880+
881+#. module: vertical_integration
882+#: model:ir.actions.act_window,name:vertical_integration.action_field_bal_spec_report
883+#: model:ir.ui.menu,name:vertical_integration.menu_action_field_bal_spec_report
884+msgid "Field Balance Specification Report"
885+msgstr "Rapport Balance Spécification Terrain"
886+
887+#. module: vertical_integration
888+#: code:addons/vertical_integration/report/field_balance_spec_report.py:182
889+#, python-format
890+msgid "Field Balance Specification Report From UniField"
891+msgstr "Rapport Balance Spécification Terrain - UniField"
892+
893+#. module: vertical_integration
894+#: code:addons/vertical_integration/report/field_balance_spec_report.py:59
895+#, python-format
896+msgid "Balance Specification"
897+msgstr "Balance Spécification"
898+
899+#. module: vertical_integration
900+#: help:field.balance.spec.report,eoy:0
901+msgid "Field is disabled if no valid currency table"
902+msgstr "Le champ est désactivé si aucune Table de Devises n'est active"
903+
904+#. module: vertical_integration
905+#: code:addons/vertical_integration/report/field_balance_spec_report.py:433
906+#: code:addons/vertical_integration/report/field_balance_spec_report.py:599
907+#: code:addons/vertical_integration/report/field_balance_spec_report.py:661
908+#: code:addons/vertical_integration/report/field_balance_spec_report.py:796
909+#, python-format
910+msgid "Field's Comments"
911+msgstr "Commentaires Terrain"
912+
913+#. module: vertical_integration
914+#: code:addons/vertical_integration/report/field_balance_spec_report.py:348
915+#, python-format
916+msgid "Finco Name:"
917+msgstr "Nom Finco :"
918+
919+#. module: vertical_integration
920+#: code:addons/vertical_integration/report/field_balance_spec_report.py:433
921+#: code:addons/vertical_integration/report/field_balance_spec_report.py:600
922+#: code:addons/vertical_integration/report/field_balance_spec_report.py:662
923+#: code:addons/vertical_integration/report/field_balance_spec_report.py:797
924+#, python-format
925+msgid "HQ Comments"
926+msgstr "Commentaires HQ"
927+
928+#. module: vertical_integration
929+#: code:addons/vertical_integration/report/field_balance_spec_report.py:386
930+#, python-format
931+msgid "HQ reviewer Name:"
932+msgstr "Nom du réviseur HQ :"
933+
934+#. module: vertical_integration
935+#: code:addons/vertical_integration/report/field_balance_spec_report.py:367
936+#, python-format
937+msgid "HoM Name:"
938+msgstr "Nom HoM :"
939+
940+#. module: vertical_integration
941+#: code:addons/vertical_integration/report/field_balance_spec_report.py:590
942+#, python-format
943+msgid "Journal Status"
944+msgstr "Statut du journal"
945+
946+#. module: vertical_integration
947+#: code:addons/vertical_integration/report/field_balance_spec_report.py:765
948+#: code:addons/vertical_integration/report/field_balance_spec_report.py:886
949+#, python-format
950+msgid "List of entries reconciled in later periods >>>"
951+msgstr "Liste des écritures lettrées dans des périodes ultérieures >>>"
952+
953+#. module: vertical_integration
954+#: code:addons/vertical_integration/report/field_balance_spec_report.py:593
955+#: code:addons/vertical_integration/report/field_balance_spec_report.py:780
956+#, python-format
957+msgid "Period Rate"
958+msgstr "Taux de la Période"
959+
960+#. module: vertical_integration
961+#: code:addons/vertical_integration/report/field_balance_spec_report.py:786
962+#, python-format
963+msgid "Reference of the entry"
964+msgstr "Référence de l'écriture"
965+
966+#. module: vertical_integration
967+#: code:addons/vertical_integration/report/field_balance_spec_report.py:314
968+#, python-format
969+msgid "Report exported from"
970+msgstr "Instance d'export"
971+
972+#. module: vertical_integration
973+#: code:addons/vertical_integration/report/field_balance_spec_report.py:659
974+#, python-format
975+msgid "Subaccount Number"
976+msgstr "Numéro Sous-Compte"
977+
978+#. module: vertical_integration
979+#: selection:field.balance.spec.report,selection:0
980+msgid "Total of entries reconciled in later period"
981+msgstr "Total des écritures lettrées dans une période ultérieure"
982+
983+#. module: vertical_integration
984+#: code:addons/vertical_integration/report/field_balance_spec_report.py:767
985+#: code:addons/vertical_integration/report/field_balance_spec_report.py:1030
986+#, python-format
987+msgid "Total of entries reconciled in later periods >>>"
988+msgstr "Total des écritures lettrées dans des périodes ultérieures >>>"
989+
990+#. module: vertical_integration
991+#: code:addons/vertical_integration/report/field_balance_spec_report.py:429
992+#, python-format
993+msgid "UniField Balance in %s"
994+msgstr "Balance UniField %s"
995+
996+#. module: vertical_integration
997+#: code:addons/vertical_integration/report/field_balance_spec_report.py:595
998+#: code:addons/vertical_integration/report/field_balance_spec_report.py:792
999+#, python-format
1000+msgid "Year End Rate Currency Table"
1001+msgstr "Taux fin d'année"
1002+
1003+#. module: vertical_integration
1004+#: code:addons/vertical_integration/report/field_balance_spec_report.py:198
1005+#, python-format
1006+msgid "page"
1007+msgstr "page"
1008+
1009+#. module: vertical_integration
1010+#: code:addons/vertical_integration/report/field_balance_spec_report.py:200
1011+#, python-format
1012+msgid "Posting Rate"
1013+msgstr "Taux de comptabilisation"
1014+
1015+#. module: vertical_integration
1016+#: code:addons/vertical_integration/report/field_balance_spec_report.py:210
1017+#, python-format
1018+msgid "Booking Rate"
1019+msgstr "Taux d'enregistrement"
1020+
1021 #. module: product_attributes
1022 #: code:addons/product_attributes/report/hq_product_mml_nonconform.py:53
1023 #: code:addons/product_attributes/report/product_mml_nonconform.py:67
1024 #, python-format
1025 msgid "In-Pipe Quantity included"
1026 msgstr "Quantité en attente incluse"
1027-
1028
1029=== modified file 'bin/addons/msf_profile/msf_profile.py'
1030--- bin/addons/msf_profile/msf_profile.py 2023-09-15 13:58:07 +0000
1031+++ bin/addons/msf_profile/msf_profile.py 2023-09-22 12:20:31 +0000
1032@@ -57,7 +57,17 @@
1033 'model': lambda *a: 'patch.scripts',
1034 }
1035
1036- # UF31.0
1037+
1038+ def us_11026_oca_liquidity_migration_journal(self, cr, uid, *a, **b):
1039+ entity_obj = self.pool.get('sync.client.entity')
1040+ if entity_obj and entity_obj.get_entity(cr, uid).oc == 'oca':
1041+ sql_file = opj('msf_profile', 'data', 'us_11026_migration_items_to_liquidity_journals.sql')
1042+ fp = tools.file_open(sql_file, 'r')
1043+ cr.execute(fp.read())
1044+ fp.close()
1045+ return True
1046+
1047+ # UF30.1
1048 def us_11956_fix_po_line_reception_destination(self, cr, uid, *a, **b):
1049 '''
1050 Set the Reception Destination to Cross Docking for all PO line by Nomenclature (no product) if they are linked
1051
1052=== modified file 'bin/addons/register_accounting/report/report_liquidity_position.py'
1053--- bin/addons/register_accounting/report/report_liquidity_position.py 2022-03-01 10:07:54 +0000
1054+++ bin/addons/register_accounting/report/report_liquidity_position.py 2023-09-22 12:20:31 +0000
1055@@ -115,7 +115,6 @@
1056 self.func_currency = func_curr.name
1057 self.func_currency_id = func_curr.id
1058 for reg in regs:
1059-
1060 journal = reg.journal_id
1061 currency = journal.currency
1062
1063
1064=== modified file 'bin/addons/spreadsheet_xml/xlsx_write.py'
1065--- bin/addons/spreadsheet_xml/xlsx_write.py 2023-05-26 13:44:43 +0000
1066+++ bin/addons/spreadsheet_xml/xlsx_write.py 2023-09-22 12:20:31 +0000
1067@@ -138,10 +138,16 @@
1068 str_date = value
1069 return datetime.datetime.strptime(str_date, "%Y-%m-%d %H:%M:%S")
1070
1071- def cell_ro(self, value, style=None, unlock=None):
1072+ def cell_ro(self, value, style=None, unlock=None, copy_style=None):
1073 new_cell = WriteOnlyCell(self.workbook.active, value=value)
1074 if style:
1075 new_cell.style = style
1076+ elif copy_style:
1077+ copied_style_name = '%s_style' % copy_style
1078+ if copied_style_name in self.workbook.named_styles:
1079+ new_cell.style = copied_style_name
1080+ else:
1081+ new_cell.style = self.create_style_from_template(copied_style_name, copy_style)
1082 if unlock:
1083 new_cell.protection = Protection(locked=False)
1084 return new_cell
1085
1086=== modified file 'bin/addons/vertical_integration/account_report.xml'
1087--- bin/addons/vertical_integration/account_report.xml 2023-06-06 08:31:15 +0000
1088+++ bin/addons/vertical_integration/account_report.xml 2023-09-22 12:20:31 +0000
1089@@ -19,6 +19,17 @@
1090 auto="False"
1091 menu="False"/>
1092
1093+ <report
1094+ id="field_balance_spec_report"
1095+ string="FIELD BALANCE SPECIFICATION REPORT"
1096+ model="field.balance.spec.parser"
1097+ name="field_balance_spec_report"
1098+ report_type="openpyxl"
1099+ auto="False"
1100+ target_filename="${_('Balance Specification')}"
1101+ menu="False"
1102+ />
1103+
1104
1105 <!-- Sequence for Finance export -->
1106
1107
1108=== modified file 'bin/addons/vertical_integration/report/__init__.py'
1109--- bin/addons/vertical_integration/report/__init__.py 2023-06-06 08:31:15 +0000
1110+++ bin/addons/vertical_integration/report/__init__.py 2023-09-22 12:20:31 +0000
1111@@ -3,3 +3,4 @@
1112 import hq_report_ocb
1113 import hq_report_ocp
1114 import hq_report_ocp_matching
1115+import field_balance_spec_report
1116
1117=== added file 'bin/addons/vertical_integration/report/field_balance_spec_report.py'
1118--- bin/addons/vertical_integration/report/field_balance_spec_report.py 1970-01-01 00:00:00 +0000
1119+++ bin/addons/vertical_integration/report/field_balance_spec_report.py 2023-09-22 12:20:31 +0000
1120@@ -0,0 +1,1090 @@
1121+# -*- coding: utf-8 -*-
1122+from osv import fields, osv
1123+from tools.translate import _
1124+from datetime import datetime
1125+from spreadsheet_xml.xlsx_write import XlsxReport
1126+from spreadsheet_xml.xlsx_write import XlsxReportParser
1127+from openpyxl.drawing import image
1128+from openpyxl.worksheet.header_footer import HeaderFooterItem
1129+import tools
1130+from PIL import Image as PILImage
1131+from dateutil.relativedelta import relativedelta
1132+import re
1133+from base import currency_date
1134+
1135+class field_balance_spec_report(osv.osv_memory):
1136+ _name = "field.balance.spec.report"
1137+
1138+
1139+ def _get_has_multi_table(self, cr, uid, ids, name, arg=None, context=None):
1140+ nb = self.pool.get('res.currency.table').search(cr, uid, [('sate', '=', 'valid')], count=True)
1141+ ret = {}
1142+ for _id in ids:
1143+ ret[_id] = nb > 1
1144+ return ret
1145+
1146+
1147+ _columns = {
1148+ 'instance_id': fields.many2one('msf.instance', 'Top proprietary instance', required=True, domain=[('level', '=', 'coordo'), ('state', '=', 'active'), ('instance_to_display_ids','=',True)]),
1149+ 'period_id': fields.many2one('account.period', 'Period', required=True, domain=[('state', 'in', ['draft', 'field-closed', 'mission-closed']), ('number', 'not in', [0, 16])]),
1150+ 'selection': fields.selection([('total', 'Total of entries reconciled in later period'),
1151+ ('details', 'Details of entries reconciled in later period')],
1152+ string="Select", required=True),
1153+ 'eoy': fields.boolean('End of Year', help='Field is disabled if no valid currency table'),
1154+ 'has_one_table': fields.boolean('Has a single valid currency table', readonly=1),
1155+ }
1156+
1157+ def _get_instance(self, cr, uid, *a, **b):
1158+ instance = self.pool.get('res.company')._get_instance_record(cr, uid)
1159+ if instance.level == 'coordo':
1160+ return instance.id
1161+ return False
1162+
1163+ def _get_has_currency_table(self, cr, uid, *a, **b):
1164+ return self.pool.get('res.currency.table').search_exists(cr, uid, [('state', '=', 'valid')])
1165+
1166+ _defaults = {
1167+ 'selection': lambda *a: 'details',
1168+ 'instance_id': lambda self, cr, uid, *a, **b: self._get_instance(cr, uid, *a, **b),
1169+ 'has_one_table': lambda self, cr, uid, *a, **b: self._get_has_currency_table(cr, uid, *a, **b),
1170+ }
1171+
1172+ def button_create_report(self, cr, uid, ids, context=None):
1173+ if context is None:
1174+ context = {}
1175+
1176+ if isinstance(ids, (int, long)):
1177+ ids = [ids]
1178+
1179+ report = self.browse(cr, uid, ids[0], context=context)
1180+ filename = '%s %s %s' % (report.instance_id.instance, report.period_id.name, 'Balance Specification')
1181+ background_id = self.pool.get('memory.background.report').create(cr, uid, {
1182+ 'file_name': filename,
1183+ 'report_name': 'field_balance_spec_report',
1184+ }, context=context)
1185+ context['background_id'] = background_id
1186+ context['background_time'] = 3
1187+
1188+ return {
1189+ 'type': 'ir.actions.report.xml',
1190+ 'report_name': 'field_balance_spec_report',
1191+ 'datas': {'ids': ids, 'target_filename': filename, 'context': context},
1192+ 'context': context,
1193+ }
1194+
1195+field_balance_spec_report()
1196+
1197+
1198+class field_balance_spec_parser(XlsxReportParser):
1199+ _name = "field.balance.spec.parser"
1200+
1201+ def append_line(self, data):
1202+ if not self.eoy:
1203+ del(data[9])
1204+ del(data[8])
1205+ self.workbook.active.append([self.cell_ro(x[0], x[1], unlock=len(x)>2 and x[2]) for x in data])
1206+
1207+ def generate(self, context=None):
1208+
1209+ bk_id = self.context.get('background_id')
1210+ bk_obj = self.pool.get('memory.background.report')
1211+
1212+ company = self.pool.get('res.users').browse(self.cr, self.uid, self.uid, fields_to_fetch=['company_id'], context=context).company_id
1213+
1214+ if currency_date.get_date_type(self, self.cr) == 'document':
1215+ date_used = 'document_date'
1216+ date_used_label = _('Document date')
1217+ rate_title_main = _('Booking Rate')
1218+ else:
1219+ date_used = 'date'
1220+ date_used_label = _('Posting date')
1221+ rate_title_main = _('Posting Rate')
1222+
1223+ report = self.pool.get('field.balance.spec.report').browse(self.cr, self.uid, self.ids[0], context=context)
1224+
1225+
1226+ self.eoy = report.eoy
1227+ all_instance_ids = [report.instance_id.id] + [x.id for x in report.instance_id.child_ids]
1228+
1229+ self.cr.execute('''
1230+ select
1231+ distinct cur.id, cur.name
1232+ from
1233+ account_move_line l, account_move m, res_currency cur, account_account a, account_period p
1234+ where
1235+ cur.id = l.currency_id
1236+ and a.id = l.account_id
1237+ and l.date <= %(last_date)s
1238+ and p.id = l.period_id
1239+ and p.number not in (0, 16)
1240+ and m.id = l.move_id
1241+ and m.state='posted'
1242+ and m.instance_id in %(instance)s
1243+ and (a.reconcile = 't' or a.type = 'liquidity')
1244+ and l.reconcile_id is null
1245+ group by
1246+ cur.id, cur.name
1247+ order by
1248+ cur.name
1249+ ''', {'last_date': report.period_id.date_stop, 'instance': tuple(all_instance_ids)} )
1250+
1251+ list_curr = ['EUR', 'USD']
1252+ curr_id = {}
1253+ for x in self.cr.fetchall():
1254+ if x[1] not in ('EUR', 'USD'):
1255+ list_curr.append(x[1])
1256+ curr_id[x[0]] = x[1]
1257+
1258+ if bk_id:
1259+ bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.1})
1260+
1261+ fx_rates = {}
1262+ fx_rates_by_id = {}
1263+ self.cr.execute('''
1264+ select cur.name,
1265+ (select rate.rate
1266+ from res_currency_rate rate
1267+ where rate.currency_id = cur.id and rate.name <= %s
1268+ order by
1269+ rate.name desc
1270+ limit 1
1271+ ) as fx_rate,
1272+ cur.id
1273+ from res_currency cur
1274+ where currency_table_id is null and cur.name in %s
1275+ ''', (report.period_id.date_start, tuple(list_curr) ))
1276+ for x in self.cr.fetchall():
1277+ fx_rates[x[0]] = x[1]
1278+ fx_rates_by_id[x[2]] = x[1]
1279+
1280+ ct_fx_rates = {}
1281+ ct_fx_rates_by_id = {}
1282+ if report.eoy:
1283+ self.cr.execute('''
1284+ select cur.name,
1285+ (select rate.rate
1286+ from res_currency_rate rate
1287+ where rate.currency_id = cur.id
1288+ order by
1289+ rate.name desc
1290+ limit 1
1291+ ) as fx_rate,
1292+ cur.reference_currency_id
1293+ from res_currency cur, res_currency_table t
1294+ where
1295+ cur.currency_table_id = t.id
1296+ and t.state = 'valid'
1297+ and cur.name in %s
1298+ ''', (tuple(list_curr), ))
1299+ for x in self.cr.fetchall():
1300+ ct_fx_rates[x[0]] = x[1]
1301+ ct_fx_rates_by_id[x[2]] = x[1]
1302+
1303+ rates = {}
1304+ ct_rates = {}
1305+ for n, cur in enumerate(list_curr[1:]):
1306+ rates[n] = {'name': cur, 'value': fx_rates[cur]}
1307+ if report.eoy:
1308+ ct_rates[n] = {'name': cur, 'value': ct_fx_rates[cur]}
1309+
1310+ page_title = _('Field Balance Specification Report From UniField')
1311+
1312+ sheet = self.workbook.active
1313+ sheet.sheet_view.zoomScale = 75
1314+ sheet.protection.formatCells = False
1315+ #sheet.protection.formatRows = False
1316+ #sheet.protection.formatColumns = False
1317+ sheet.protection.autoFilter = False
1318+ sheet.protection.sheet = True
1319+ sheet.sheet_view.showGridLines = True
1320+ sheet.page_setup.orientation = 'landscape'
1321+ sheet.page_setup.fitToPage = True
1322+ sheet.page_setup.fitToHeight = False
1323+ sheet.page_setup.paperSize = 9 # A4
1324+
1325+ footer = HeaderFooterItem()
1326+ footer.left.text = "%s, %s, %s, %s &[Page]/&N" % (page_title, report.instance_id.mission, report.period_id.name, _('page'))
1327+ footer.left.size = 8
1328+ sheet.oddFooter = footer
1329+ sheet.evenFooter = footer
1330+ sheet.page_margins.left = 0.2
1331+ sheet.page_margins.right = 0.2
1332+ sheet.page_margins.top = 0.2
1333+ sheet.page_margins.bottom = 1
1334+ sheet.freeze_panes = 'C9'
1335+
1336+ self.duplicate_column_dimensions()
1337+ self.duplicate_row_dimensions(range(1, 9))
1338+ if self.eoy:
1339+ sheet.column_dimensions['N'].width = sheet.column_dimensions['L'].width
1340+ sheet.column_dimensions['M'].width = sheet.column_dimensions['K'].width
1341+ sheet.column_dimensions['L'].width = sheet.column_dimensions['J'].width
1342+ sheet.column_dimensions['K'].width = sheet.column_dimensions['I'].width
1343+ sheet.column_dimensions['J'].width = sheet.column_dimensions['H'].width
1344+ sheet.column_dimensions['I'].width = sheet.column_dimensions['G'].width
1345+
1346+ pil_img = PILImage.open(tools.file_open('addons/msf_doc_import/report/images/msf-logo.png', 'rb'))
1347+ img = image.Image(pil_img)
1348+ orig_width = img.width
1349+ orig_height = img.height
1350+ img.width = 100.
1351+ img.height = orig_height * (img.width/orig_width)
1352+
1353+ sheet.add_image(img, 'A1')
1354+
1355+
1356+ self.create_style_from_template('logo_style', 'A1')
1357+ self.create_style_from_template('title_cell1_style', 'B1')
1358+ self.create_style_from_template('title_style', 'I1')
1359+ self.create_style_from_template('first_field_comment', 'K1')
1360+ self.create_style_from_template('first_hq_comment', 'L1')
1361+ self.create_style_from_template('rate_style', 'G1')
1362+ self.create_style_from_template('current_period_style', 'H1')
1363+ self.create_style_from_template('func_curr_name', 'G2')
1364+ self.create_style_from_template('func_curr_value', 'H2')
1365+ self.create_style_from_template('header_full_date', 'D3')
1366+ self.create_style_from_template('header_month_date', 'B4')
1367+ self.create_style_from_template('end_doc', 'B37')
1368+ self.create_style_from_template('end_doc_left', 'A37')
1369+ self.create_style_from_template('end_doc_right', 'L37')
1370+
1371+ self.create_style_from_template('default_header_style', 'B3')
1372+ self.create_style_from_template('header_1st_info_title', 'A3')
1373+ self.create_style_from_template('header_other_info_title', 'C3')
1374+ self.create_style_from_template('cur_name', 'G3')
1375+ self.create_style_from_template('cur_value', 'H3')
1376+ self.create_style_from_template('user_name', 'B5')
1377+ self.create_style_from_template('user_date', 'C5')
1378+
1379+ self.create_style_from_template('title_account', 'A18')
1380+ self.create_style_from_template('title_text', 'B18')
1381+ self.create_style_from_template('title_amount', 'F18')
1382+ self.create_style_from_template('title_info', 'I18')
1383+ self.create_style_from_template('title_hq_comment', 'L9')
1384+ self.create_style_from_template('line_account', 'A19')
1385+ self.create_style_from_template('line_rate', 'G19')
1386+ self.create_style_from_template('line_amount', 'H19')
1387+ self.create_style_from_template('line_text', 'B19')
1388+ self.create_style_from_template('line_date', 'D19')
1389+ self.create_style_from_template('line_total', 'H25')
1390+ self.create_style_from_template('line_curr', 'E15')
1391+ self.create_style_from_template('line_info', 'I24')
1392+ self.create_style_from_template('line_selection', 'A23')
1393+ self.create_style_from_template('field_comment', 'K10')
1394+ self.create_style_from_template('hq_comment', 'L10')
1395+
1396+
1397+
1398+ sheet.title = '%s %s' % (report.period_id.name, report.instance_id.code)
1399+ sheet.row_dimensions[1].height = 25
1400+
1401+
1402+ self.append_line([
1403+ ('', 'logo_style'),
1404+ (page_title, 'title_cell1_style'),
1405+ ('', 'title_style'),
1406+ ('', 'title_style'),
1407+ ('', 'title_style'),
1408+ ('', 'title_style'),
1409+ (_('Rates'), 'rate_style'),
1410+ (_('Current period'), 'current_period_style'),
1411+ (_('Rates'), 'rate_style'),
1412+ (_('End of Year'), 'current_period_style'),
1413+ ('', 'title_style'),
1414+ ('', 'title_style'),
1415+ ('', 'first_field_comment', True),
1416+ ('', 'first_hq_comment', True)
1417+ ])
1418+ sheet.merged_cells.ranges.append("B1:F1")
1419+
1420+ self.append_line(
1421+ [('', 'header_1st_info_title')] +
1422+ [('', 'default_header_style')] * 5 +
1423+ [
1424+ (company.currency_id.name, 'func_curr_name'),
1425+ (1, 'func_curr_value'),
1426+ (company.currency_id.name, 'func_curr_name'),
1427+ (1, 'func_curr_value'),
1428+ ] +
1429+ [('', 'default_header_style')] * 2 +
1430+ [
1431+ ('', 'field_comment', True),
1432+ ('', 'hq_comment', True),
1433+ ]
1434+ )
1435+
1436+ self.append_line([
1437+ (_('Country Program'), 'header_1st_info_title'),
1438+ (report.instance_id.mission or '', 'default_header_style'),
1439+ (_('Date of the report'), 'header_other_info_title'),
1440+ (datetime.now(), 'header_full_date'),
1441+ ('', 'default_header_style'),
1442+ (_('Report exported from'), 'header_other_info_title'),
1443+ ] + [
1444+ (rates.get(0, {}).get('name', ''), 'cur_name'),
1445+ (rates.get(0, {}).get('value', ''), 'cur_value'),
1446+ (ct_rates.get(0, {}).get('name', ''), 'cur_name'),
1447+ (ct_rates.get(0, {}).get('value', ''), 'cur_value')
1448+ ] +
1449+ [('', 'default_header_style')] * 2 +
1450+ [
1451+ ('', 'field_comment', True),
1452+ ('', 'hq_comment', True)
1453+ ],
1454+ )
1455+
1456+ self.append_line([
1457+ (_('Month:'), 'header_1st_info_title'),
1458+ (datetime.strptime(report.period_id.date_start, '%Y-%m-%d'), 'header_month_date'),
1459+ (_('Date of review'), 'header_other_info_title'),
1460+ ('', 'header_full_date'),
1461+ ('', 'default_header_style'),
1462+ (company.instance_id.instance, 'default_header_style'),
1463+ ] + [
1464+ (rates.get(1, {}).get('name', ''), 'cur_name'),
1465+ (rates.get(1, {}).get('value', ''), 'cur_value'),
1466+ (ct_rates.get(1, {}).get('name', ''), 'cur_name'),
1467+ (ct_rates.get(1, {}).get('value', ''), 'cur_value'),
1468+ ] + [('', 'default_header_style')] * 2 +
1469+ [
1470+ ('', 'field_comment', True),
1471+ ('', 'hq_comment', True)
1472+ ]
1473+ )
1474+
1475+ self.append_line([
1476+ (_('Finco Name:'), 'header_1st_info_title'),
1477+ ('', 'user_name', True),
1478+ ('', 'user_date', True),
1479+ ] +
1480+ [('', 'default_header_style')] * 3 +
1481+ [
1482+ (rates.get(2, {}).get('name', ''), 'cur_name'),
1483+ (rates.get(2, {}).get('value', ''), 'cur_value'),
1484+ (ct_rates.get(2, {}).get('name', ''), 'cur_name'),
1485+ (ct_rates.get(2, {}).get('value', ''), 'cur_value')
1486+ ] +
1487+ [('', 'default_header_style')] * 2 +
1488+ [
1489+ ('', 'field_comment', True),
1490+ ('', 'hq_comment', True)
1491+ ]
1492+ )
1493+
1494+ self.append_line([
1495+ (_('HoM Name:'), 'header_1st_info_title'),
1496+ ('', 'user_name', True),
1497+ ('', 'user_date', True),
1498+ ] +
1499+ [('', 'default_header_style')] * 3 +
1500+ [
1501+ (rates.get(3, {}).get('name', ''), 'cur_name'),
1502+ (rates.get(3, {}).get('value', ''), 'cur_value'),
1503+ (ct_rates.get(3, {}).get('name', ''), 'cur_name'),
1504+ (ct_rates.get(3, {}).get('value', ''), 'cur_value')
1505+ ] +
1506+ [('', 'default_header_style')] * 2 +
1507+ [
1508+ ('', 'field_comment', True),
1509+ ('', 'hq_comment', True)
1510+ ]
1511+ )
1512+
1513+ self.append_line([
1514+ (_('HQ reviewer Name:'), 'header_1st_info_title'),
1515+ ('', 'user_name', True),
1516+ ('', 'user_date', True),
1517+ ] +
1518+ [('', 'default_header_style')] * 3 +
1519+ [
1520+ (rates.get(4, {}).get('name', ''), 'cur_name'),
1521+ (rates.get(4, {}).get('value', ''), 'cur_value'),
1522+ (ct_rates.get(4, {}).get('name', ''), 'cur_name'),
1523+ (ct_rates.get(4, {}).get('value', ''), 'cur_value')
1524+ ] +
1525+ [('', 'default_header_style')] * 2 +
1526+ [
1527+ ('', 'field_comment', True),
1528+ ('', 'hq_comment', True)
1529+ ]
1530+ )
1531+ rate_idx = 5
1532+ line = 8
1533+ while rates.get(rate_idx):
1534+ self.append_line(
1535+ [('', 'header_1st_info_title')] +
1536+ [('', 'default_header_style')] * 5 +
1537+ [
1538+ (rates.get(rate_idx, {}).get('name', ''), 'cur_name'),
1539+ (rates.get(rate_idx, {}).get('value', ''), 'cur_value'),
1540+ (ct_rates.get(rate_idx, {}).get('name', ''), 'cur_name'),
1541+ (ct_rates.get(rate_idx, {}).get('value', ''), 'cur_value')
1542+ ] +
1543+ [('', 'default_header_style')] * 2 +
1544+ [
1545+ ('', 'field_comment', True),
1546+ ('', 'hq_comment', True)
1547+ ]
1548+ )
1549+ rate_idx += 1
1550+ line += 1
1551+
1552+ self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
1553+ line += 1
1554+ self.append_line(
1555+ [(_('Balance accounts'), 'title_account')] +
1556+ [('', 'title_text')] * 6 +
1557+ [(_('UniField Balance in %s') % (company.currency_id.name,) , 'title_amount')] +
1558+ [('', 'title_text')] +
1559+ [(_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount')] +
1560+ [('', 'title_text')] * 2 +
1561+ [(_("Field's Comments"), 'title_text'), (_("HQ Comments"), 'title_hq_comment')]
1562+ )
1563+
1564+ line += 1
1565+
1566+ register_details = {}
1567+ # sum of liquidity accounts
1568+ liq_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('type', '=', 'liquidity'), ('reconcile', '=', False)], context=context)
1569+ for liq_account in self.pool.get('account.account').browse(self.cr, self.uid, liq_account_ids, fields_to_fetch=['code', 'name'], context=context):
1570+ self.cr.execute('''
1571+ select
1572+ l.currency_id, sum(coalesce(amount_currency,0)), j.id
1573+ from
1574+ account_move_line l, account_move m, account_period p, account_journal j
1575+ where
1576+ l.move_id = m.id
1577+ and l.period_id = p.id
1578+ and j.id = l.journal_id
1579+ and l.instance_id in %(instance)s
1580+ -- and m.state = 'posted'
1581+ and p.number not in (0, 16)
1582+ and l.account_id = %(account_id)s
1583+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
1584+ and j.type in ('bank', 'cash')
1585+ group by
1586+ l.currency_id, j.id
1587+ ''', {
1588+ 'instance': tuple(all_instance_ids),
1589+ 'period_start': report.period_id.date_start,
1590+ 'period_number': report.period_id.number,
1591+ 'account_id': liq_account.id,
1592+ }
1593+ )
1594+ liq_sum = 0
1595+ ct_sum = 0
1596+ # total entry encoding
1597+ for liq in self.cr.fetchall():
1598+ register_details[liq[2]] = liq[1]
1599+ liq_sum += liq[1] / fx_rates_by_id.get(liq[0], 1)
1600+ ct_sum += liq[1] / ct_fx_rates_by_id.get(liq[0], 1)
1601+
1602+ self.append_line(
1603+ [('%s %s' % (liq_account.code, liq_account.name), 'line_account')] +
1604+ [('', 'line_text')] * 6 +
1605+ [(round(liq_sum, 2), 'line_amount')] +
1606+ [('', 'line_text')] +
1607+ [(round(ct_sum, 2), 'line_amount')] +
1608+ [('', 'line_text')] * 2 +
1609+ [('', 'field_comment', True), ('', 'hq_comment', True)]
1610+ )
1611+ line += 1
1612+
1613+ if bk_id:
1614+ bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.2})
1615+
1616+ # sum of reconciliable accounts
1617+ ctx_with_date = context.copy()
1618+ ctx_with_date['date'] = (datetime.strptime(report.period_id.date_stop, '%Y-%m-%d') + relativedelta(days=1)).strftime('%Y-%m-%d')
1619+ inactive_accounts = {}
1620+
1621+ req_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('code', '!=', '15640')], context=context)
1622+ special_account_id = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('code','=', '15640')], context=context)
1623+
1624+ all_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True)], context=context) # list ordered by code
1625+ chq_account = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('type', '=', 'liquidity')], context=context)
1626+
1627+ list_sum = {}
1628+ ct_list_sum = {}
1629+ for list_accounts in [req_account_ids, special_account_id]:
1630+ if not list_accounts:
1631+ continue
1632+ if list_accounts == special_account_id:
1633+ req_cond = ''
1634+ # req_cond = 'and l.employee_id is not null'
1635+ else:
1636+ req_cond = ''' and (
1637+ l.reconcile_id is null
1638+ or exists(
1639+ select rec_line.id from account_move_line rec_line, account_period rec_p
1640+ where
1641+ rec_line.reconcile_id = l.reconcile_id
1642+ and rec_p.id = rec_line.period_id
1643+ and (
1644+ rec_p.date_start > %(period_start)s
1645+ or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
1646+ )
1647+ )
1648+ )
1649+ '''
1650+ self.cr.execute('''
1651+ select
1652+ sum(coalesce(l.debit,0) - coalesce(l.credit,0)),
1653+ l.account_id,
1654+ sum(coalesce(amount_currency,0)),
1655+ l.currency_id
1656+ from
1657+ account_move_line l
1658+ inner join account_period p on p.id = l.period_id
1659+ inner join account_move m on l.move_id = m.id
1660+ inner join account_journal j on j.id = l.journal_id
1661+ where
1662+ l.account_id in %(account_id)s
1663+ and j.type != 'revaluation'
1664+ and p.number not in (0, 16)
1665+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
1666+ and m.state='posted'
1667+ and m.instance_id in %(instance)s
1668+ ''' + req_cond + '''
1669+ group by
1670+ l.account_id, l.currency_id
1671+ ''', {
1672+ 'account_id': tuple(list_accounts),
1673+ 'period_number': report.period_id.number,
1674+ 'period_start': report.period_id.date_start,
1675+ 'instance': tuple(all_instance_ids),
1676+ })
1677+ for ssum in self.cr.fetchall():
1678+ list_sum.setdefault(ssum[1], 0)
1679+ ct_list_sum.setdefault(ssum[1], 0)
1680+ if ssum[1] in chq_account and company.revaluation_default_account:
1681+ list_sum[ssum[1]] += ssum[2] / fx_rates_by_id.get(ssum[3], 1)
1682+ else:
1683+ list_sum[ssum[1]] += ssum[0]
1684+ ct_list_sum[ssum[1]] += ssum[2] / ct_fx_rates_by_id.get(ssum[3], 1)
1685+
1686+ for req_account in self.pool.get('account.account').browse(self.cr, self.uid, all_account_ids, fields_to_fetch=['code', 'name', 'filter_active'], context=ctx_with_date):
1687+ if not req_account.filter_active and not list_sum.get(req_account.id):
1688+ inactive_accounts[req_account.id] = True
1689+ continue
1690+
1691+ if req_account.id in special_account_id:
1692+ ct_amount = ''
1693+ else:
1694+ ct_amount = round(ct_list_sum.get(req_account.id) or 0, 2)
1695+ self.append_line(
1696+ [('%s %s' % (req_account.code, req_account.name), 'line_account')] +
1697+ [('', 'line_text')] * 6 +
1698+ [(round(list_sum.get(req_account.id) or 0, 2), 'line_amount')] +
1699+ [('', 'line_text')] +
1700+ [(ct_amount, 'line_amount')] +
1701+ [('', 'line_text')] * 2 +
1702+ [('', 'field_comment', True), ('', 'hq_comment', True)]
1703+ )
1704+ line += 1
1705+
1706+ self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
1707+ line += 1
1708+
1709+ year = datetime.strptime(report.period_id.date_start, '%Y-%m-%d').year
1710+ for j_type in ['cash', 'bank']:
1711+ j_ids = self.pool.get('account.journal').search(self.cr, self.uid, ['&', ('type', '=', j_type), '|', ('is_active', '=', True), ('inactivation_date', '>', '%s-01-31' % (year, )), ('instance_id', 'in', all_instance_ids)], context=context)
1712+ first_line = True
1713+ account_sum = 0
1714+ ct_account_sum = 0
1715+ for journal in self.pool.get('account.journal').browse(self.cr, self.uid, j_ids, context=context):
1716+ if first_line:
1717+ self.append_line(
1718+ [
1719+ ('%s - %s' % (journal.default_debit_account_id.code, journal.default_debit_account_id.name), 'title_account'),
1720+ (_('Journal Name'), 'title_text'),
1721+ (_('Proprietary instance'), 'title_text'),
1722+ (_('Journal Status'), 'title_text'),
1723+ (_('Curr'), 'title_info'),
1724+ (_('Currency Amount'), 'title_amount'),
1725+ (_('Period Rate'), 'title_amount'),
1726+ (_('%s Amount with Current Period Rate') % company.currency_id.name, 'title_amount'),
1727+ (_('Year End Rate Currency Table'), 'title_amount'),
1728+ (_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount'),
1729+ ('', 'title_text'),
1730+ ('', 'title_text'),
1731+ (_("Field's Comments"), 'title_text'),
1732+ (_("HQ Comments"), 'title_hq_comment'),
1733+ ]
1734+ )
1735+ line += 1
1736+ first_line = False
1737+ self.append_line([
1738+ (journal.code, 'line_account'),
1739+ (journal.name, 'line_text'),
1740+ (journal.instance_id.instance, 'line_text'),
1741+ (not journal.is_active and _('Inactive') or '', 'line_text'),
1742+ (journal.currency.name, 'line_curr'),
1743+ (register_details.get(journal.id, 0), 'line_amount'),
1744+ (fx_rates_by_id.get(journal.currency.id, 0), 'line_rate'),
1745+ (register_details.get(journal.id,0) / fx_rates_by_id.get(journal.currency.id, 1), 'line_amount'),
1746+ (ct_fx_rates_by_id.get(journal.currency.id, 0), 'line_rate'),
1747+ (register_details.get(journal.id,0) / ct_fx_rates_by_id.get(journal.currency.id, 1), 'line_amount'),
1748+ ('', 'line_text'),
1749+ ('', 'line_text'),
1750+ ('', 'field_comment', True),
1751+ ('', 'hq_comment', True),
1752+ ])
1753+ line += 1
1754+ account_sum += round(register_details.get(journal.id,0) / fx_rates_by_id.get(journal.currency.id, 1), 2)
1755+ if report.eoy:
1756+ ct_account_sum += round(register_details.get(journal.id,0) / ct_fx_rates_by_id.get(journal.currency.id, 1), 2)
1757+
1758+ self.append_line(
1759+ [('', 'header_1st_info_title')] +
1760+ [('', 'default_header_style')] * 6 +
1761+ [(account_sum, 'line_total')] +
1762+ [('', 'default_header_style'), (ct_account_sum if report.eoy else '', 'line_total')] +
1763+ [('', 'default_header_style')] * 2 +
1764+ [('', 'field_comment', True), ('', 'hq_comment', True)]
1765+ )
1766+ line += 1
1767+
1768+
1769+ self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
1770+ line += 1
1771+
1772+ if bk_id:
1773+ bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.5})
1774+
1775+ # details of reconciliable accounts
1776+ total_account = float(len(all_account_ids))
1777+ nb_account_done = 0
1778+ for req_account in self.pool.get('account.account').browse(self.cr, self.uid, all_account_ids, fields_to_fetch=['code', 'name'], context=context):
1779+ if req_account.id in inactive_accounts:
1780+ continue
1781+ account_sum = 0
1782+ ct_account_sum = 0
1783+ if req_account.code == '15640':
1784+ self.append_line(
1785+ [('%s - %s' % (req_account.code, req_account.name), 'title_account')] +
1786+ [('', 'title_text')] * 6 +
1787+ [
1788+ (_('%s Amount') % (company.currency_id.name, ), 'title_amount'),
1789+ ('', 'title_text'),
1790+ ('', 'title_text'),
1791+ (_('Subaccount Number'), 'title_info'),
1792+ ('', 'title_text'),
1793+ (_("Field's Comments"), 'title_text'),
1794+ (_("HQ Comments"), 'title_hq_comment'),
1795+ ]
1796+ )
1797+ line += 1
1798+ # unreconciled or partial rec
1799+ self.cr.execute('''
1800+ select name, sum(balance), identification_id from
1801+ (
1802+ select
1803+ coalesce(res.name, l.partner_txt, '') as name,
1804+ sum(coalesce(l.debit, 0) - coalesce(l.credit, 0)) as balance,
1805+ emp.identification_id as identification_id
1806+ from
1807+ account_move_line l
1808+ inner join account_account a on a.id = l.account_id
1809+ inner join account_period p on p.id = l.period_id
1810+ inner join account_move m on l.move_id = m.id
1811+ inner join account_journal j on j.id = l.journal_id
1812+ left join hr_employee emp on l.employee_id = emp.id
1813+ left join resource_resource res on res.id = emp.resource_id
1814+ where
1815+ l.account_id = %(account_id)s
1816+ and j.type != 'revaluation'
1817+ and p.number not in (0, 16)
1818+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
1819+ and m.state='posted'
1820+ and m.instance_id in %(instance)s
1821+ group by emp.id, coalesce(res.name, partner_txt, ''), emp.identification_id, res.active
1822+ having
1823+ res.active = 't' or abs(sum(coalesce(l.debit, 0) - coalesce(l.credit, 0))) > 0.001
1824+
1825+ UNION
1826+ select res.name as name, 0 as balance, emp.identification_id as identification_id
1827+ from
1828+ hr_employee emp, resource_resource res
1829+ where
1830+ res.id = emp.resource_id
1831+ and emp.employee_type='ex'
1832+ and res.active='t'
1833+ ) as EMP_ALL
1834+ group by
1835+ name, identification_id
1836+ order by
1837+ EMP_ALL.identification_id NULLS FIRST
1838+ ''', {
1839+ 'account_id': req_account.id,
1840+ 'period_number': report.period_id.number,
1841+ 'period_start': report.period_id.date_start,
1842+ 'instance': tuple(all_instance_ids),
1843+ })
1844+ partner_txt_lines = {}
1845+ all_lines = []
1846+ for emp in self.cr.fetchall():
1847+ line_amount = emp[1]
1848+ if emp[0] and not emp[2]:
1849+ # extract identification_id from partner_txt
1850+ if abs(line_amount) > 0.001:
1851+ m = re.search('([0-9]+)\s*$', emp[0])
1852+ if m:
1853+ if m.group(1) not in partner_txt_lines:
1854+ partner_txt_lines[m.group(1)] = {'name': emp[0], 'amount': line_amount}
1855+ else:
1856+ partner_txt_lines[m.group(1)]['amount'] += line_amount
1857+ continue
1858+ elif partner_txt_lines.get(emp[2]):
1859+ # add amount on partner_txt to existing employee_id line
1860+ line_amount += partner_txt_lines[emp[2]]['amount']
1861+ del partner_txt_lines[emp[2]]
1862+ if abs(line_amount) <= 0.001:
1863+ continue
1864+
1865+ emp_id = emp[2]
1866+ if emp_id:
1867+ try:
1868+ emp_id = int(emp[2])
1869+ except:
1870+ pass
1871+ all_lines.append([emp[0], line_amount, emp_id])
1872+
1873+ # partner_txt lines not linked to employee_id line
1874+ for emp_id in partner_txt_lines:
1875+ if abs(partner_txt_lines[emp_id]['amount']) > 0.001:
1876+ all_lines.append(partner_txt_lines[emp_id])
1877+
1878+ for emp in sorted(all_lines, key=lambda x: x[2]):
1879+ self.append_line(
1880+ [(emp[0], 'line_account')] +
1881+ [('', 'line_text')] * 6 +
1882+ [
1883+ (round(emp[1], 2), 'line_amount'),
1884+ ('', 'line_text'),
1885+ ('', 'line_text'),
1886+ ('%s'%emp[2], 'line_info'),
1887+ ('', 'line_text'),
1888+ ('', 'field_comment', True),
1889+ ('', 'hq_comment', True),
1890+ ]
1891+ )
1892+ line += 1
1893+ account_sum += round(emp[1], 2)
1894+
1895+
1896+ if report.selection == 'details':
1897+ title_sum = _('List of entries reconciled in later periods >>>')
1898+ else:
1899+ title_sum = _('Total of entries reconciled in later periods >>>')
1900+
1901+ self.append_line(
1902+ [(title_sum, 'line_selection')] +
1903+ [('', 'default_header_style')] * 11 +
1904+ [('', 'field_comment', True), ('', 'hq_comment', True)]
1905+ )
1906+ line += 1
1907+
1908+ else:
1909+ rate_title = rate_title_main
1910+ amount_title = _('%s Amount') % (company.currency_id.name, )
1911+ if req_account.id in chq_account and company.revaluation_default_account:
1912+ rate_title = _('Period Rate')
1913+ amount_title = _('%s Amount with Current Period Rate') % (company.currency_id.name, )
1914+
1915+ self.append_line([
1916+ ('%s - %s' % (req_account.code, req_account.name), 'title_account'),
1917+ (_('Description of the entry'), 'title_text'),
1918+ (_('Reference of the entry'), 'title_text'),
1919+ (date_used_label, 'title_text'),
1920+ (_('Curr'), 'title_info'),
1921+ (_('Currency Amount'), 'title_amount'),
1922+ (rate_title, 'title_amount'),
1923+ (amount_title, 'title_amount'),
1924+ (_('Year End Rate Currency Table'), 'title_amount'),
1925+ (_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount'),
1926+ (_('Reconcile Number'), 'title_info'),
1927+ (_('Third Party'), 'title_info'),
1928+ (_("Field's Comments"), 'title_text'),
1929+ (_("HQ Comments"), 'title_hq_comment'),
1930+ ])
1931+
1932+ line += 1
1933+
1934+ # unreconciled or partial rec
1935+ self.cr.execute('''
1936+ select
1937+ m.name, l.name, l.ref, l.''' + date_used + ''', cur.name, coalesce(l.amount_currency, 0),
1938+ (select
1939+ rate.rate
1940+ from
1941+ res_currency_rate rate
1942+ where
1943+ rate.currency_id = l.currency_id
1944+ and currency_table_id is null
1945+ and rate.name <= coalesce(l.source_date, l.''' + date_used + ''')
1946+ order by
1947+ rate.name desc
1948+ limit 1
1949+ ) as fx_rate,
1950+ coalesce(l.debit, 0) - coalesce(l.credit, 0),
1951+ partial.name,
1952+ coalesce(partner.name, j.code, case when emp.employee_type='ex' then emp.name_resource when emp.employee_type='local'then emp.name_resource||' '||emp.identification_id else partner_txt end),
1953+ (
1954+ select sum(amount_currency) from account_move_line where reconcile_partial_id is not null and reconcile_partial_id = partial.id
1955+ ),
1956+ cur.id
1957+ from
1958+ account_move_line l
1959+ inner join account_account a on a.id = l.account_id
1960+ inner join account_period p on p.id = l.period_id
1961+ inner join account_move m on l.move_id = m.id
1962+ inner join res_currency cur on cur.id = l.currency_id
1963+ inner join account_journal journal on journal.id = l.journal_id
1964+ left join account_move_reconcile partial on partial.id = l.reconcile_partial_id
1965+ left join res_partner partner on partner.id = l.partner_id
1966+ left join hr_employee emp on emp.id = l.employee_id
1967+ left join account_journal j on j.id = l.transfer_journal_id
1968+ where
1969+ l.account_id = %(account_id)s
1970+ and p.number not in (0, 16)
1971+ and journal.type != 'revaluation'
1972+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
1973+ and m.state='posted'
1974+ and m.instance_id in %(instance)s
1975+ and l.reconcile_id is null
1976+ order by
1977+ m.name, l.id
1978+ ''', {
1979+ 'account_id': req_account.id,
1980+ 'period_number': report.period_id.number,
1981+ 'period_start': report.period_id.date_start,
1982+ 'instance': tuple(all_instance_ids),
1983+ })
1984+
1985+ for account_line in self.cr.fetchall():
1986+ if req_account.id in chq_account and company.revaluation_default_account:
1987+ line_rate = fx_rates_by_id.get(account_line[11],'')
1988+ line_amount = account_line[5] / fx_rates_by_id.get(account_line[11], 1)
1989+ else:
1990+ line_rate = account_line[6]
1991+ line_amount = account_line[7]
1992+
1993+ ct_line_rate = ct_fx_rates_by_id.get(account_line[11],'')
1994+ ct_line_amount = account_line[5] / ct_fx_rates_by_id.get(account_line[11], 1)
1995+
1996+ self.append_line([
1997+ (account_line[0], 'line_account'),
1998+ (account_line[1], 'line_text'),
1999+ (account_line[2], 'line_text'),
2000+ (self.to_datetime(account_line[3]), 'line_date'),
2001+ (account_line[4], 'line_curr'),
2002+ (account_line[5], 'line_amount'),
2003+ (line_rate, 'line_rate'),
2004+ (line_amount, 'line_amount'),
2005+ (ct_line_rate, 'line_rate'),
2006+ (ct_line_amount, 'line_amount'),
2007+ (account_line[8] and '%s (%.02lf)' % (account_line[8], account_line[10]) or '', 'line_info'),
2008+ (account_line[9], 'line_text'),
2009+ ('', 'field_comment', True),
2010+ ('', 'hq_comment', True),
2011+ ])
2012+ line += 1
2013+ account_sum += round(line_amount, 2)
2014+ ct_account_sum += round(ct_line_amount, 2)
2015+
2016+ if report.selection == 'details':
2017+ self.append_line(
2018+ [(_('List of entries reconciled in later periods >>>'), 'line_selection')] +
2019+ [('', 'default_header_style')] * 11 +
2020+ [('', 'field_comment', True), ('', 'hq_comment', True)]
2021+ )
2022+ line += 1
2023+
2024+ # reconciled later
2025+ self.cr.execute('''
2026+ select
2027+ m.name, l.name, l.ref, l.date, cur.name, coalesce(l.amount_currency, 0),
2028+ (select
2029+ rate.rate
2030+ from
2031+ res_currency_rate rate
2032+ where
2033+ rate.currency_id = l.currency_id
2034+ and currency_table_id is null
2035+ and rate.name <= coalesce(l.source_date, l.''' + date_used + ''')
2036+ order by
2037+ rate.name desc
2038+ limit 1
2039+ ) as fx_rate,
2040+ coalesce(l.debit, 0) - coalesce(l.credit, 0),
2041+ rec.name,
2042+ coalesce(partner.name, j.code, emp.name_resource||' '||emp.identification_id),
2043+ cur.id
2044+ from
2045+ account_move_line l
2046+ inner join account_account a on a.id = l.account_id
2047+ inner join account_period p on p.id = l.period_id
2048+ inner join account_move m on l.move_id = m.id
2049+ inner join res_currency cur on cur.id = l.currency_id
2050+ inner join account_move_reconcile rec on rec.id = l.reconcile_id
2051+ inner join account_journal journal on journal.id = l.journal_id
2052+ left join res_partner partner on partner.id = l.partner_id
2053+ left join hr_employee emp on emp.id = l.employee_id
2054+ left join account_journal j on j.id = l.transfer_journal_id
2055+ where
2056+ l.account_id = %(account_id)s
2057+ and journal.type != 'revaluation'
2058+ and p.number not in (0, 16)
2059+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
2060+ and m.state='posted'
2061+ and m.instance_id in %(instance)s
2062+ and
2063+ exists(
2064+ select rec_line.id from account_move_line rec_line, account_period rec_p
2065+ where
2066+ rec_line.reconcile_id = l.reconcile_id
2067+ and rec_p.id = rec_line.period_id
2068+ and (
2069+ rec_p.date_start > %(period_start)s
2070+ or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
2071+ )
2072+ )
2073+ order by
2074+ m.name, l.id
2075+ ''', {
2076+ 'account_id': req_account.id,
2077+ 'period_number': report.period_id.number,
2078+ 'period_start': report.period_id.date_start,
2079+ 'instance': tuple(all_instance_ids),
2080+ })
2081+ for account_line in self.cr.fetchall():
2082+ if req_account.id in chq_account and company.revaluation_default_account:
2083+ line_rate = fx_rates_by_id.get(account_line[10],'')
2084+ line_amount = account_line[5] / fx_rates_by_id.get(account_line[10], 1)
2085+ else:
2086+ line_rate = account_line[6]
2087+ line_amount = account_line[7]
2088+
2089+ ct_line_rate = ct_fx_rates_by_id.get(account_line[10],'')
2090+ ct_line_amount = account_line[5] / ct_fx_rates_by_id.get(account_line[10], 1)
2091+
2092+ self.append_line([
2093+ (account_line[0], 'line_account'),
2094+ (account_line[1], 'line_text'),
2095+ (account_line[2], 'line_text'),
2096+ (self.to_datetime(account_line[3]), 'line_date'),
2097+ (account_line[4], 'line_curr'),
2098+ (account_line[5], 'line_amount'),
2099+ (line_rate, 'line_rate'),
2100+ (line_amount, 'line_amount'),
2101+ (ct_line_rate, 'line_rate'),
2102+ (ct_line_amount, 'line_amount'),
2103+ (account_line[8], 'line_info'),
2104+ (account_line[9], 'line_text'),
2105+ ('', 'field_comment', True),
2106+ ('', 'hq_comment', True),
2107+ ])
2108+ line += 1
2109+ account_sum += round(line_amount, 2)
2110+ ct_account_sum += round(ct_line_amount, 2)
2111+ else:
2112+ # sum reconciled later
2113+ self.cr.execute('''
2114+ select
2115+ sum(coalesce(l.debit, 0) - coalesce(l.credit, 0)),
2116+ sum(coalesce(l.amount_currency, 0)),
2117+ l.currency_id
2118+ from
2119+ account_move_line l
2120+ inner join account_account a on a.id = l.account_id
2121+ inner join account_period p on p.id = l.period_id
2122+ inner join account_move m on l.move_id = m.id
2123+ inner join res_currency cur on cur.id = l.currency_id
2124+ inner join account_move_reconcile rec on rec.id = l.reconcile_id
2125+ inner join account_journal journal on journal.id = l.journal_id
2126+ where
2127+ l.account_id = %(account_id)s
2128+ and p.number not in (0, 16)
2129+ and journal.type != 'revaluation'
2130+ and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
2131+ and m.state='posted'
2132+ and m.instance_id in %(instance)s
2133+ and
2134+ exists(
2135+ select rec_line.id from account_move_line rec_line, account_period rec_p
2136+ where
2137+ rec_line.reconcile_id = l.reconcile_id
2138+ and rec_p.id = rec_line.period_id
2139+ and (
2140+ rec_p.date_start > %(period_start)s
2141+ or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
2142+ )
2143+ )
2144+ group by l.currency_id
2145+ ''', {
2146+ 'account_id': req_account.id,
2147+ 'period_number': report.period_id.number,
2148+ 'period_start': report.period_id.date_start,
2149+ 'instance': tuple(all_instance_ids),
2150+ })
2151+ total_later = 0
2152+ ct_total_later = 0
2153+ for later_rec in self.cr.fetchall():
2154+ if req_account.id in chq_account and company.revaluation_default_account:
2155+ total_later += later_rec[1] / fx_rates_by_id.get(later_rec[2], 1)
2156+ else:
2157+ total_later += later_rec[0]
2158+ ct_total_later += later_rec[1] / ct_fx_rates_by_id.get(later_rec[2], 1)
2159+ account_sum += round(total_later, 2)
2160+ ct_account_sum += round(ct_total_later, 2)
2161+ self.append_line(
2162+ [(_('Total of entries reconciled in later periods >>>'), 'line_selection')] +
2163+ [('', 'default_header_style')] * 6 +
2164+ [(total_later, 'line_amount')] +
2165+ [('', 'default_header_style')] +
2166+ [(ct_total_later, 'line_amount')] +
2167+ [('', 'default_header_style')] * 2 +
2168+ [('', 'field_comment', True), ('', 'hq_comment', True)]
2169+ )
2170+ line += 1
2171+
2172+ if req_account.code == '15640':
2173+ ct_account_sum = ''
2174+
2175+ self.append_line(
2176+ [('', 'header_1st_info_title')] +
2177+ [('', 'default_header_style')] * 6 +
2178+ [(account_sum, 'line_total')] +
2179+ [('', 'default_header_style')] +
2180+ [(ct_account_sum, 'line_total')] +
2181+ [('', 'default_header_style')] * 2 +
2182+ [('', 'field_comment', True), ('', 'hq_comment', True)]
2183+ )
2184+ line += 1
2185+
2186+
2187+ self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
2188+ line += 1
2189+
2190+ nb_account_done += 1
2191+ if bk_id:
2192+ bk_obj.write(self.cr, self.uid, bk_id, {'percent': min(0.95, 0.5 + 0.45 * nb_account_done/total_account)})
2193+
2194+
2195+ self.append_line(
2196+ [('', 'end_doc_left')] +
2197+ [('---%s---' % _('END OF FIELD BALANCE SPECIFICATION REPORT'), 'end_doc')] +
2198+ [('', 'end_doc')] * 11 +
2199+ [('', 'end_doc_right')]
2200+ )
2201+ line += 1
2202+
2203+ if self.eoy:
2204+ sheet.print_area = 'A1:N%d' % line
2205+ else:
2206+ sheet.print_area = 'A1:L%d' % line
2207+ if bk_id:
2208+ bk_obj.write(self.cr, self.uid, bk_id, {'percent': 1.})
2209+
2210+XlsxReport('report.field_balance_spec_report', parser=field_balance_spec_parser, template='addons/vertical_integration/report/field_balance_spec_report_template.xlsx')
2211
2212=== added file 'bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx'
2213Binary files bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx and bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx differ
2214=== modified file 'bin/addons/vertical_integration/vertical_integration_wizard.xml'
2215--- bin/addons/vertical_integration/vertical_integration_wizard.xml 2023-06-06 08:31:15 +0000
2216+++ bin/addons/vertical_integration/vertical_integration_wizard.xml 2023-09-22 12:20:31 +0000
2217@@ -89,6 +89,44 @@
2218 action="action_hq_export_oca"
2219 id="menu_action_hq_export_oca" sequence="20"/>
2220
2221+
2222+ <record id="field_bal_spec_report_wizard" model="ir.ui.view">
2223+ <field name="name">FIELD BALANCE SPECIFICATION REPORT</field>
2224+ <field name="model">field.balance.spec.report</field>
2225+ <field name="type">form</field>
2226+ <field name="priority" eval="25" />
2227+ <field name="arch" type="xml">
2228+ <form string="FIELD BALANCE SPECIFICATION REPORT">
2229+ <field name="instance_id" />
2230+ <field name="period_id" />
2231+ <field name="selection"/>
2232+ <group colspan="2" col="4">
2233+ <field name="has_one_table" invisible="1" />
2234+ <field name="eoy" attrs="{'readonly': [('has_one_table', '=', False)]}"/>
2235+ </group>
2236+ <group colspan="6" col="4">
2237+ <label string="" colspan="2"/>
2238+ <button special="cancel" string="Cancel" colspan="1" icon="gtk-cancel"/>
2239+ <button icon="terp-camera_test" string="Print" name="button_create_report" type="object" default_focus="1" colspan="1"/>
2240+ </group>
2241+ </form>
2242+ </field>
2243+ </record>
2244+
2245+ <record id="action_field_bal_spec_report" model="ir.actions.act_window">
2246+ <field name="name">Field Balance Specification Report</field>
2247+ <field name="type">ir.actions.act_window</field>
2248+ <field name="res_model">field.balance.spec.report</field>
2249+ <field name="view_type">form</field>
2250+ <field name="view_mode">form</field>
2251+ <field name="view_id" ref="field_bal_spec_report_wizard"/>
2252+ <field name="target">new</field>
2253+ </record>
2254+
2255+ <menuitem parent="account.final_accounting_reports"
2256+ action="action_field_bal_spec_report"
2257+ id="menu_action_field_bal_spec_report" sequence="200"/>
2258+
2259 <!-- OCB export -->
2260
2261 <record id="ocb_export_wizard" model="ir.ui.view">

Subscribers

People subscribed via source and target branches