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
=== added directory 'bin/.update'
=== modified file 'bin/addons/account/account.py'
--- bin/addons/account/account.py 2023-06-26 14:31:43 +0000
+++ bin/addons/account/account.py 2023-09-22 12:20:31 +0000
@@ -307,7 +307,7 @@
307 ('liquidity','Liquidity'),307 ('liquidity','Liquidity'),
308 ('consolidation', 'Consolidation'),308 ('consolidation', 'Consolidation'),
309 ('closed', 'Closed'),309 ('closed', 'Closed'),
310 ], 'Internal Type', required=True, help="This type is used to differentiate types with "\310 ], 'Internal Type', required=True, select=1, help="This type is used to differentiate types with "\
311 "special effects in OpenERP: view can not have entries, consolidation are accounts that "\311 "special effects in OpenERP: view can not have entries, consolidation are accounts that "\
312 "can have children accounts for multi-company consolidations, payable/receivable are for "\312 "can have children accounts for multi-company consolidations, payable/receivable are for "\
313 "partners accounts (for debit/credit computations), closed for depreciated accounts."),313 "partners accounts (for debit/credit computations), closed for depreciated accounts."),
@@ -657,7 +657,7 @@
657 _columns = {657 _columns = {
658 'name': fields.char('Journal Name', size=64, required=True),658 'name': fields.char('Journal Name', size=64, required=True),
659 '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."),659 '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."),
660 '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,660 '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,
661 help="Select 'Sale' for Sale journal to be used at the time of making invoice."\661 help="Select 'Sale' for Sale journal to be used at the time of making invoice."\
662 " Select 'Purchase' for Purchase Journal to be used at the time of approving purchase order."\662 " Select 'Purchase' for Purchase Journal to be used at the time of approving purchase order."\
663 " Select 'Cash' to be used at the time of making payment."\663 " Select 'Cash' to be used at the time of making payment."\
664664
=== modified file 'bin/addons/account_journal/account_journal.py'
--- bin/addons/account_journal/account_journal.py 2022-02-04 17:25:05 +0000
+++ bin/addons/account_journal/account_journal.py 2023-09-22 12:20:31 +0000
@@ -98,7 +98,7 @@
98 return res98 return res
9999
100 _columns = {100 _columns = {
101 'type': fields.selection(get_journal_type, 'Type', size=32, required=True),101 'type': fields.selection(get_journal_type, 'Type', size=32, required=True, select=1),
102 '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."),102 '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."),
103 'bank_journal_id': fields.many2one('account.journal', _("Corresponding bank journal"),103 'bank_journal_id': fields.many2one('account.journal', _("Corresponding bank journal"),
104 domain="[('type', '=', 'bank'), ('currency', '=', currency), ('is_active', '=', True)]"),104 domain="[('type', '=', 'bank'), ('currency', '=', currency), ('is_active', '=', True)]"),
105105
=== modified file 'bin/addons/msf_profile/data/patches.xml'
--- bin/addons/msf_profile/data/patches.xml 2023-09-15 13:58:07 +0000
+++ bin/addons/msf_profile/data/patches.xml 2023-09-22 12:20:31 +0000
@@ -980,9 +980,16 @@
980 <field name="method">us_11810_fix_company_logo</field>980 <field name="method">us_11810_fix_company_logo</field>
981 </record>981 </record>
982982
983 <!-- UF31.0 -->983 <!-- UF30.1 -->
984 <record id="us_11956_fix_po_line_reception_destination" model="patch.scripts">984 <record id="us_11956_fix_po_line_reception_destination" model="patch.scripts">
985 <field name="method">us_11956_fix_po_line_reception_destination</field>985 <field name="method">us_11956_fix_po_line_reception_destination</field>
986 </record>986 </record>
987
988 <!-- UF31.0 -->
989 <record id="us_11026_oca_liquidity_migration_journal" model="patch.scripts">
990 <field name="method">us_11026_oca_liquidity_migration_journal</field>
991 </record>
992
993
987 </data>994 </data>
988</openerp>995</openerp>
989996
=== added file 'bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql'
--- bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql 1970-01-01 00:00:00 +0000
+++ bin/addons/msf_profile/data/us_11026_migration_items_to_liquidity_journals.sql 2023-09-22 12:20:31 +0000
@@ -0,0 +1,520 @@
1update 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');
2update 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');
3update 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');
4update 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');
5update 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');
6update 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');
7update 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');
8update 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');
9update 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');
10update 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');
11update 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');
12update 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');
13update 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');
14update 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');
15update 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');
16update 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');
17update 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');
18update 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');
19update 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');
20update 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');
21update 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');
22update 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');
23update 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');
24update 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');
25update 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');
26update 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');
27update 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');
28update 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');
29update 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');
30update 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');
31update 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');
32update 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');
33update 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');
34update 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');
35update 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');
36update 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');
37update 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');
38update 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');
39update 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');
40update 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');
41update 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');
42update 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');
43update 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');
44update 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');
45update 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');
46update 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');
47update 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');
48update 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');
49update 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');
50update 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');
51update 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');
52update 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');
53update 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');
54update 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');
55update 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');
56update 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');
57update 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');
58update 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');
59update 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');
60update 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');
61update 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');
62update 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');
63update 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');
64update 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');
65update 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');
66update 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');
67update 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');
68update 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');
69update 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');
70update 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');
71update 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');
72update 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');
73update 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');
74update 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');
75update 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');
76update 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');
77update 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');
78update 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');
79update 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');
80update 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');
81update 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');
82update 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');
83update 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');
84update 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');
85update 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');
86update 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');
87update 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');
88update 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');
89update 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');
90update 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');
91update 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');
92update 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');
93update 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');
94update 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');
95update 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');
96update 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');
97update 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');
98update 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');
99update 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');
100update 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');
101update 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');
102update 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');
103update 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');
104update 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');
105update 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');
106update 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');
107update 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');
108update 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');
109update 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');
110update 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');
111update 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');
112update 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');
113update 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');
114update 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');
115update 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');
116update 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');
117update 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');
118update 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');
119update 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');
120update 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');
121update 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');
122update 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');
123update 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');
124update 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');
125update 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');
126update 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');
127update 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');
128update 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');
129update 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');
130update 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');
131update 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');
132update 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');
133update 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');
134update 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');
135update 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');
136update 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');
137update 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');
138update 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');
139update 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');
140update 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');
141update 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');
142update 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');
143update 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');
144update 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');
145update 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');
146update 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');
147update 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');
148update 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');
149update 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');
150update 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');
151update 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');
152update 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');
153update 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');
154update 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');
155update 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');
156update 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');
157update 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');
158update 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');
159update 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');
160update 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');
161update 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');
162update 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');
163update 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');
164update 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');
165update 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');
166update 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');
167update 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');
168update 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');
169update 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');
170update 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');
171update 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');
172update 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');
173update 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');
174update 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');
175update 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');
176update 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');
177update 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');
178update 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');
179update 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');
180update 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');
181update 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');
182update 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');
183update 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');
184update 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');
185update 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');
186update 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');
187update 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');
188update 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');
189update 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');
190update 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');
191update 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');
192update 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');
193update 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');
194update 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');
195update 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');
196update 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');
197update 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');
198update 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');
199update 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');
200update 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');
201update 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');
202update 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');
203update 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');
204update 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');
205update 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');
206update 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');
207update 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');
208update 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');
209update 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');
210update 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');
211update 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');
212update 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');
213update 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');
214update 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');
215update 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');
216update 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');
217update 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');
218update 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');
219update 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');
220update 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');
221update 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');
222update 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');
223update 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');
224update 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');
225update 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');
226update 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');
227update 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');
228update 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');
229update 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');
230update 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');
231update 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');
232update 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');
233update 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');
234update 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');
235update 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');
236update 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');
237update 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');
238update 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');
239update 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');
240update 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');
241update 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');
242update 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');
243update 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');
244update 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');
245update 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');
246update 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');
247update 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');
248update 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');
249update 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');
250update 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');
251update 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');
252update 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');
253update 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');
254update 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');
255update 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');
256update 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');
257update 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');
258update 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');
259update 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');
260update 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');
261update 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');
262update 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');
263update 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');
264update 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');
265update 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');
266update 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');
267update 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');
268update 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');
269update 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');
270update 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');
271update 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');
272update 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');
273update 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');
274update 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');
275update 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');
276update 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');
277update 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');
278update 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');
279update 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');
280update 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');
281update 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');
282update 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');
283update 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');
284update 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');
285update 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');
286update 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');
287update 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');
288update 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');
289update 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');
290update 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');
291update 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');
292update 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');
293update 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');
294update 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');
295update 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');
296update 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');
297update 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');
298update 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');
299update 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');
300update 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');
301update 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');
302update 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');
303update 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');
304update 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');
305update 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');
306update 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');
307update 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');
308update 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');
309update 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');
310update 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');
311update 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');
312update 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');
313update 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');
314update 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');
315update 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');
316update 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');
317update 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');
318update 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');
319update 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');
320update 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');
321update 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');
322update 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');
323update 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');
324update 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');
325update 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');
326update 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');
327update 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');
328update 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');
329update 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');
330update 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');
331update 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');
332update 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');
333update 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');
334update 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');
335update 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');
336update 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');
337update 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');
338update 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');
339update 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');
340update 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');
341update 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');
342update 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');
343update 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');
344update 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');
345update 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');
346update 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');
347update 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');
348update 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');
349update 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');
350update 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');
351update 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');
352update 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');
353update 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');
354update 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');
355update 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');
356update 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');
357update 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');
358update 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');
359update 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');
360update 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');
361update 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');
362update 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');
363update 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');
364update 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');
365update 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');
366update 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');
367update 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');
368update 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');
369update 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');
370update 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');
371update 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');
372update 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');
373update 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');
374update 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');
375update 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');
376update 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');
377update 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');
378update 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');
379update 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');
380update 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');
381update 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');
382update 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');
383update 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');
384update 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');
385update 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');
386update 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');
387update 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');
388update 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');
389update 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');
390update 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');
391update 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');
392update 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');
393update 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');
394update 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');
395update 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');
396update 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');
397update 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');
398update 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');
399update 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');
400update 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');
401update 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');
402update 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');
403update 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');
404update 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');
405update 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');
406update 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');
407update 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');
408update 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');
409update 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');
410update 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');
411update 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');
412update 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');
413update 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');
414update 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');
415update 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');
416update 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');
417update 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');
418update 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');
419update 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');
420update 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');
421update 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');
422update 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');
423update 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');
424update 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');
425update 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');
426update 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');
427update 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');
428update 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');
429update 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');
430update 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');
431update 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');
432update 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');
433update 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');
434update 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');
435update 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');
436update 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');
437update 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');
438update 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');
439update 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');
440update 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');
441update 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');
442update 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');
443update 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');
444update 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');
445update 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');
446update 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');
447update 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');
448update 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');
449update 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');
450update 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');
451update 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');
452update 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');
453update 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');
454update 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');
455update 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');
456update 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');
457update 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');
458update 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');
459update 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');
460update 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');
461update 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');
462update 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');
463update 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');
464update 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');
465update 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');
466update 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');
467update 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');
468update 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');
469update 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');
470update 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');
471update 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');
472update 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');
473update 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');
474update 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');
475update 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');
476update 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');
477update 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');
478update 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');
479update 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');
480update 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');
481update 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');
482update 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');
483update 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');
484update 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');
485update 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');
486update 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');
487update 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');
488update 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');
489update 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');
490update 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');
491update 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');
492update 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');
493update 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');
494update 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');
495update 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');
496update 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');
497update 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');
498update 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');
499update 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');
500update 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');
501update 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');
502update 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');
503update 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');
504update 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');
505update 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');
506update 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');
507update 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');
508update 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');
509update 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');
510update 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');
511update 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');
512update 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');
513update 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');
514update 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');
515update 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');
516update 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');
517update 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');
518update 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');
519update 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');
520update 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');
0521
=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
--- bin/addons/msf_profile/i18n/fr_MF.po 2023-08-16 09:21:58 +0000
+++ bin/addons/msf_profile/i18n/fr_MF.po 2023-09-22 12:20:31 +0000
@@ -4744,8 +4744,9 @@
4744msgid "Back Order"4744msgid "Back Order"
4745msgstr "Livraison en attente"4745msgstr "Livraison en attente"
47464746
4747#. module: finance4747#. module: finance, vertical_integration
4748#: report:cash.request.export:04748#: report:cash.request.export:0
4749#: code:addons/vertical_integration/report/field_balance_spec_report.py:329
4749msgid "Month:"4750msgid "Month:"
4750msgstr "Mois :"4751msgstr "Mois :"
47514752
@@ -5733,6 +5734,7 @@
5733#. module: vertical_integration5734#. module: vertical_integration
5734#: field:ocb.export.wizard,selection:05735#: field:ocb.export.wizard,selection:0
5735#: field:wizard.hq.report.oca,selection:05736#: field:wizard.hq.report.oca,selection:0
5737#: field:field.balance.spec.report,selection:0
5736msgid "Select"5738msgid "Select"
5737msgstr "Sélectionner"5739msgstr "Sélectionner"
57385740
@@ -16379,7 +16381,7 @@
16379msgid "Salesman"16381msgid "Salesman"
16380msgstr "Responsable"16382msgstr "Responsable"
1638116383
16382#. modules: msf_instance, finance, register_accounting16384#. modules: msf_instance, finance, register_accounting, vertical_integration
16383#: field:cash.request,prop_instance_id:016385#: field:cash.request,prop_instance_id:0
16384#: field:cash.request.liquidity,instance_id:016386#: field:cash.request.liquidity,instance_id:0
16385#: field:cash.request.liquidity.bank,instance_id:016387#: field:cash.request.liquidity.bank,instance_id:0
@@ -16388,6 +16390,7 @@
16388#: field:msf_instance.setup,instance_id:016390#: field:msf_instance.setup,instance_id:0
16389#: report:addons/register_accounting/report/liquidity_position_xls.mako:31516391#: report:addons/register_accounting/report/liquidity_position_xls.mako:315
16390#: report:addons/register_accounting/report/liquidity_position_xls.mako:46716392#: report:addons/register_accounting/report/liquidity_position_xls.mako:467
16393#: code:addons/vertical_integration/report/field_balance_spec_report.py:589
16391msgid "Proprietary instance"16394msgid "Proprietary instance"
16392msgstr "Instance propriétaire"16395msgstr "Instance propriétaire"
1639316396
@@ -23927,9 +23930,10 @@
23927msgid "Select this if you want to keep track of deletion on any record of the object of this rule"23930msgid "Select this if you want to keep track of deletion on any record of the object of this rule"
23928msgstr "Sélectionner si vous voulez suivre l'annulation de tout enregistrement au sujet de cette règle"23931msgstr "Sélectionner si vous voulez suivre l'annulation de tout enregistrement au sujet de cette règle"
2392923932
23930#. modules: base, res_currency_tables23933#. modules: base, res_currency_tables, vertical_integration
23931#: field:warning.import.currencies.lines,rate:023934#: field:warning.import.currencies.lines,rate:0
23932#: field:res.currency.rate,rate:023935#: field:res.currency.rate,rate:0
23936#: code:addons/vertical_integration/report/field_balance_spec_report.py:777
23933msgid "Rate"23937msgid "Rate"
23934msgstr "Taux"23938msgstr "Taux"
2393523939
@@ -25355,6 +25359,7 @@
25355#: field:free.allocation.wizard,period_id:025359#: field:free.allocation.wizard,period_id:0
25356#: selection:integrity.finance.wizard,filter:025360#: selection:integrity.finance.wizard,filter:0
25357#: report:addons/account/report/export_cv.mako:13325361#: report:addons/account/report/export_cv.mako:133
25362#: field:field.balance.spec.report,period_id:0
25358#, python-format25363#, python-format
25359msgid "Period"25364msgid "Period"
25360msgstr "Période"25365msgstr "Période"
@@ -28394,7 +28399,7 @@
28394msgid "XML Identifier"28399msgid "XML Identifier"
28395msgstr "Identifiant XML"28400msgstr "Identifiant XML"
2839628401
28397#. modules: msf_budget, account, stock_move_tracking, product, sale, stock_forecast, purchase_allocation_report, order_types, account_override28402#. modules: msf_budget, account, stock_move_tracking, product, sale, stock_forecast, purchase_allocation_report, order_types, account_override, vertical_integration
28398#: view:account.aged.trial.balance:028403#: view:account.aged.trial.balance:0
28399#: view:account.analytic.Journal.report:028404#: view:account.analytic.Journal.report:0
28400#: view:account.analytic.balance:028405#: view:account.analytic.balance:0
@@ -28412,6 +28417,7 @@
28412#: view:stock.forecast:028417#: view:stock.forecast:0
28413#: view:stock.move.tracking:028418#: view:stock.move.tracking:0
28414#: view:integrity.finance.wizard:028419#: view:integrity.finance.wizard:0
28420#: view:field.balance.spec.report:0
28415msgid "Print"28421msgid "Print"
28416msgstr "Imprimer"28422msgstr "Imprimer"
2841728423
@@ -40042,7 +40048,7 @@
40042msgid "audittrail.log.sequence"40048msgid "audittrail.log.sequence"
40043msgstr "audittrail.log.sequence"40049msgstr "audittrail.log.sequence"
4004440050
40045#. modules: msf_doc_import, register_accounting, account_mcdb, analytic_distribution, account40051#. modules: msf_doc_import, register_accounting, account_mcdb, analytic_distribution, account, vertical_integration
40046#: view:account.mcdb:040052#: view:account.mcdb:0
40047#: field:analytic.distribution.wizard,document_date:040053#: field:analytic.distribution.wizard,document_date:0
40048#: field:msf.doc.import.accounting.lines,document_date:040054#: field:msf.doc.import.accounting.lines,document_date:0
@@ -40050,6 +40056,7 @@
40050#: field:account.direct.invoice.wizard,document_date:040056#: field:account.direct.invoice.wizard,document_date:0
40051#: report:addons/account/report/free_allocation_report.mako:17240057#: report:addons/account/report/free_allocation_report.mako:172
40052#: field:free.allocation.wizard,document_date_from:040058#: field:free.allocation.wizard,document_date_from:0
40059#: code:addons/vertical_integration/report/field_balance_spec_report.py:96
40053msgid "Document date"40060msgid "Document date"
40054msgstr "Date du document"40061msgstr "Date du document"
4005540062
@@ -47852,7 +47859,7 @@
47852msgid "Bangladesh"47859msgid "Bangladesh"
47853msgstr "Bengladesh"47860msgstr "Bengladesh"
4785447861
47855#. modules: account, msf_instance, finance, register_accounting47862#. modules: account, msf_instance, finance, register_accounting, vertical_integration
47856#: field:account.analytic.journal,name:047863#: field:account.analytic.journal,name:0
47857#: report:account.general.journal:047864#: report:account.general.journal:0
47858#: field:account.journal,name:047865#: field:account.journal,name:0
@@ -47865,6 +47872,7 @@
47865#: field:account.journal.fake,name:047872#: field:account.journal.fake,name:0
47866#: report:addons/register_accounting/report/liquidity_position_xls.mako:32147873#: report:addons/register_accounting/report/liquidity_position_xls.mako:321
47867#: report:addons/register_accounting/report/liquidity_position_xls.mako:47347874#: report:addons/register_accounting/report/liquidity_position_xls.mako:473
47875#: code:addons/vertical_integration/report/field_balance_spec_report.py:588
47868msgid "Journal Name"47876msgid "Journal Name"
47869msgstr "Nom du Journal"47877msgstr "Nom du Journal"
4787047878
@@ -64102,8 +64110,9 @@
64102msgid "Nothing to import"64110msgid "Nothing to import"
64103msgstr "Rien à importer"64111msgstr "Rien à importer"
6410464112
64105#. module: account_mcdb64113#. module: account_mcdb, vertical_integration
64106#: selection:account.mcdb,currency_choice:064114#: selection:account.mcdb,currency_choice:0
64115#: code:addons/vertical_integration/report/field_balance_spec_report.py:94
64107msgid "Booking"64116msgid "Booking"
64108msgstr "Enregistrement"64117msgstr "Enregistrement"
6410964118
@@ -66668,6 +66677,7 @@
66668#: field:ocp.matching.export.wizard,instance_id:066677#: field:ocp.matching.export.wizard,instance_id:0
66669#: field:wizard.hq.report.oca,instance_id:066678#: field:wizard.hq.report.oca,instance_id:0
66670#: field:wizard.hq.report.ocg,instance_id:066679#: field:wizard.hq.report.ocg,instance_id:0
66680#: field:field.balance.spec.report,instance_id:0
66671msgid "Top proprietary instance"66681msgid "Top proprietary instance"
66672msgstr "Instance propriétaire parente"66682msgstr "Instance propriétaire parente"
6667366683
@@ -91134,7 +91144,7 @@
91134msgid "This is the list of all your pack types."91144msgid "This is the list of all your pack types."
91135msgstr "Ceci est la liste de tous vos types de colis."91145msgstr "Ceci est la liste de tous vos types de colis."
9113691146
91137#. modules: account, account_mcdb, register_accounting, account_corrections, msf_doc_import, analytic_distribution91147#. modules: account, account_mcdb, register_accounting, account_corrections, msf_doc_import, analytic_distribution, vertical_integration
91138#: field:account.invoice.refund,date:091148#: field:account.invoice.refund,date:0
91139#: selection:account.journal.column,field:091149#: selection:account.journal.column,field:0
91140#: field:account.move.line,date:091150#: field:account.move.line,date:0
@@ -91148,6 +91158,8 @@
91148#: report:addons/account/report/free_allocation_report.mako:17391158#: report:addons/account/report/free_allocation_report.mako:173
91149#: field:free.allocation.wizard,posting_date_from:091159#: field:free.allocation.wizard,posting_date_from:0
91150#: report:addons/account/report/invoice_excel_export.mako:7891160#: report:addons/account/report/invoice_excel_export.mako:78
91161#: code:addons/vertical_integration/report/field_balance_spec_report.py:100
91162#, python-format
91151msgid "Posting date"91163msgid "Posting date"
91152msgstr "Date de Comptabilisation"91164msgstr "Date de Comptabilisation"
9115391165
@@ -97521,6 +97533,7 @@
97521#: view:select.actual.ship.date.wizard:097533#: view:select.actual.ship.date.wizard:0
97522#: view:non.conform.inpipe:097534#: view:non.conform.inpipe:0
97523#: view:warning.pick.partial.process.sign.wizard:097535#: view:warning.pick.partial.process.sign.wizard:0
97536#: view:field.balance.spec.report:0
97524#, python-format97537#, python-format
97525msgid "Cancel"97538msgid "Cancel"
97526msgstr "Annuler"97539msgstr "Annuler"
@@ -97629,11 +97642,13 @@
97629msgid "Bank Account No"97642msgid "Bank Account No"
97630msgstr "N° de Compte Bancaire"97643msgstr "N° de Compte Bancaire"
9763197644
97632#. modules: res_currency_functional, base, res_currency_tables97645#. modules: res_currency_functional, base, res_currency_tables, vertical_integration
97633#: view:res.currency:097646#: view:res.currency:0
97634#: field:res.currency,rate_ids:097647#: field:res.currency,rate_ids:0
97635#: view:res.currency:097648#: view:res.currency:0
97636#: view:res.currency.table:097649#: view:res.currency.table:0
97650#: code:addons/vertical_integration/report/field_balance_spec_report.py:281
97651#: code:addons/vertical_integration/report/field_balance_spec_report.py:283
97637msgid "Rates"97652msgid "Rates"
97638msgstr "Taux"97653msgstr "Taux"
9763997654
@@ -101632,7 +101647,7 @@
101632msgid "Linked Information"101647msgid "Linked Information"
101633msgstr "Information liée"101648msgstr "Information liée"
101634101649
101635#. module: account101650#. module: account, vertical_integration
101636#: report:account.third_party_ledger:0101651#: report:account.third_party_ledger:0
101637#: report:account.third_party_ledger_other:0101652#: report:account.third_party_ledger_other:0
101638#: report:addons/account/report/account_partner_ledger.mako:310101653#: report:addons/account/report/account_partner_ledger.mako:310
@@ -101641,6 +101656,7 @@
101641#: report:account.employee_ledger:0101656#: report:account.employee_ledger:0
101642#: report:account.employee_ledger_other:0101657#: report:account.employee_ledger_other:0
101643#: report:addons/account/report/account_employee_ledger.mako:312101658#: report:addons/account/report/account_employee_ledger.mako:312
101659#: code:addons/vertical_integration/report/field_balance_spec_report.py:794
101644msgid "Reconcile Number"101660msgid "Reconcile Number"
101645msgstr "Numéro de lettrage"101661msgstr "Numéro de lettrage"
101646101662
@@ -121443,10 +121459,255 @@
121443msgid "Partial process warning if signature"121459msgid "Partial process warning if signature"
121444msgstr "Avertissement si traitement partiel et signature"121460msgstr "Avertissement si traitement partiel et signature"
121445121461
121462#. module: vertical_integration
121463#: code:addons/vertical_integration/report/field_balance_spec_report.py:656
121464#: code:addons/vertical_integration/report/field_balance_spec_report.py:778
121465#, python-format
121466msgid "%s Amount"
121467msgstr "Montant en %s"
121468
121469#. module: vertical_integration
121470#: code:addons/vertical_integration/report/field_balance_spec_report.py:594
121471#, python-format
121472msgid "%s Amount with Current Period Rate"
121473msgstr "Montant en %s avec le Taux de la Période"
121474
121475#. module: vertical_integration
121476#: code:addons/vertical_integration/report/field_balance_spec_report.py:781
121477#, python-format
121478msgid "%s Amount with Current Period Rate"
121479msgstr "Montant en %s avec le Taux de la Période"
121480
121481#. module: vertical_integration
121482#: code:addons/vertical_integration/report/field_balance_spec_report.py:431
121483#: code:addons/vertical_integration/report/field_balance_spec_report.py:596
121484#: code:addons/vertical_integration/report/field_balance_spec_report.py:793
121485#, python-format
121486msgid "%s Amount with Year End Rate Currency Table"
121487msgstr "Montant en %s avec le Taux de fin d'année"
121488
121489#. module: vertical_integration
121490#: code:addons/vertical_integration/report/field_balance_spec_report.py:427
121491#, python-format
121492msgid "Balance accounts"
121493msgstr "Comptes de Bilan"
121494
121495#. module: vertical_integration
121496#: code:addons/vertical_integration/report/field_balance_spec_report.py:309
121497#, python-format
121498msgid "Country Program"
121499msgstr "Programme Pays"
121500
121501#. module: vertical_integration
121502#: code:addons/vertical_integration/report/field_balance_spec_report.py:591
121503#: code:addons/vertical_integration/report/field_balance_spec_report.py:788
121504#, python-format
121505msgid "Curr"
121506msgstr "Dev."
121507
121508#. module: vertical_integration
121509#: code:addons/vertical_integration/report/field_balance_spec_report.py:592
121510#: code:addons/vertical_integration/report/field_balance_spec_report.py:789
121511#, python-format
121512msgid "Currency Amount"
121513msgstr "Montant en devise"
121514
121515#. module: vertical_integration
121516#: code:addons/vertical_integration/report/field_balance_spec_report.py:282
121517#, python-format
121518msgid "Current period"
121519msgstr "Cette periode"
121520
121521#. module: vertical_integration
121522#: code:addons/vertical_integration/report/field_balance_spec_report.py:331
121523#, python-format
121524msgid "Date of review"
121525msgstr "Date de revue"
121526
121527#. module: vertical_integration
121528#: code:addons/vertical_integration/report/field_balance_spec_report.py:311
121529#, python-format
121530msgid "Date of the report"
121531msgstr "Date du rapport"
121532
121533#. module: vertical_integration
121534#: code:addons/vertical_integration/report/field_balance_spec_report.py:785
121535#, python-format
121536msgid "Description of the entry"
121537msgstr "Description de l'écriture"
121538
121539#. module: vertical_integration
121540#: selection:field.balance.spec.report,selection:0
121541msgid "Details of entries reconciled in later period"
121542msgstr "Détail des écritures lettrées dans une période ultérieure"
121543
121544#. module: vertical_integration
121545#: code:addons/vertical_integration/report/field_balance_spec_report.py:1062
121546#, python-format
121547msgid "END OF FIELD BALANCE SPECIFICATION REPORT"
121548msgstr "FIN DU RAPPORT BALANCE SPÉCIFICATION TERRAIN - UNIFIELD"
121549
121550#. module: vertical_integration
121551#: code:addons/vertical_integration/report/field_balance_spec_report.py:284
121552#: field:field.balance.spec.report,eoy:0
121553#, python-format
121554msgid "End of Year"
121555msgstr "Fin d'Année"
121556
121557#. module: vertical_integration
121558#: view:field.balance.spec.report:0
121559#: model:ir.actions.report.xml,name:vertical_integration.field_balance_spec_report
121560msgid "FIELD BALANCE SPECIFICATION REPORT"
121561msgstr "RAPPORT BALANCE SPÉCIFICAITON TERRAIN"
121562
121563#. module: vertical_integration
121564#: model:ir.actions.report.xml,name:vertical_integration.field_balance
121565msgid "FIELD BALANCE SPECIFICATION REPORT FROM UNIFIELD"
121566msgstr "RAPPORT BALANCE SPÉCIFICAITON TERRAIN - UNIFIELD"
121567
121568#. module: vertical_integration
121569#: model:ir.actions.act_window,name:vertical_integration.action_field_bal_spec_report
121570#: model:ir.ui.menu,name:vertical_integration.menu_action_field_bal_spec_report
121571msgid "Field Balance Specification Report"
121572msgstr "Rapport Balance Spécification Terrain"
121573
121574#. module: vertical_integration
121575#: code:addons/vertical_integration/report/field_balance_spec_report.py:182
121576#, python-format
121577msgid "Field Balance Specification Report From UniField"
121578msgstr "Rapport Balance Spécification Terrain - UniField"
121579
121580#. module: vertical_integration
121581#: code:addons/vertical_integration/report/field_balance_spec_report.py:59
121582#, python-format
121583msgid "Balance Specification"
121584msgstr "Balance Spécification"
121585
121586#. module: vertical_integration
121587#: help:field.balance.spec.report,eoy:0
121588msgid "Field is disabled if no valid currency table"
121589msgstr "Le champ est désactivé si aucune Table de Devises n'est active"
121590
121591#. module: vertical_integration
121592#: code:addons/vertical_integration/report/field_balance_spec_report.py:433
121593#: code:addons/vertical_integration/report/field_balance_spec_report.py:599
121594#: code:addons/vertical_integration/report/field_balance_spec_report.py:661
121595#: code:addons/vertical_integration/report/field_balance_spec_report.py:796
121596#, python-format
121597msgid "Field's Comments"
121598msgstr "Commentaires Terrain"
121599
121600#. module: vertical_integration
121601#: code:addons/vertical_integration/report/field_balance_spec_report.py:348
121602#, python-format
121603msgid "Finco Name:"
121604msgstr "Nom Finco :"
121605
121606#. module: vertical_integration
121607#: code:addons/vertical_integration/report/field_balance_spec_report.py:433
121608#: code:addons/vertical_integration/report/field_balance_spec_report.py:600
121609#: code:addons/vertical_integration/report/field_balance_spec_report.py:662
121610#: code:addons/vertical_integration/report/field_balance_spec_report.py:797
121611#, python-format
121612msgid "HQ Comments"
121613msgstr "Commentaires HQ"
121614
121615#. module: vertical_integration
121616#: code:addons/vertical_integration/report/field_balance_spec_report.py:386
121617#, python-format
121618msgid "HQ reviewer Name:"
121619msgstr "Nom du réviseur HQ :"
121620
121621#. module: vertical_integration
121622#: code:addons/vertical_integration/report/field_balance_spec_report.py:367
121623#, python-format
121624msgid "HoM Name:"
121625msgstr "Nom HoM :"
121626
121627#. module: vertical_integration
121628#: code:addons/vertical_integration/report/field_balance_spec_report.py:590
121629#, python-format
121630msgid "Journal Status"
121631msgstr "Statut du journal"
121632
121633#. module: vertical_integration
121634#: code:addons/vertical_integration/report/field_balance_spec_report.py:765
121635#: code:addons/vertical_integration/report/field_balance_spec_report.py:886
121636#, python-format
121637msgid "List of entries reconciled in later periods >>>"
121638msgstr "Liste des écritures lettrées dans des périodes ultérieures >>>"
121639
121640#. module: vertical_integration
121641#: code:addons/vertical_integration/report/field_balance_spec_report.py:593
121642#: code:addons/vertical_integration/report/field_balance_spec_report.py:780
121643#, python-format
121644msgid "Period Rate"
121645msgstr "Taux de la Période"
121646
121647#. module: vertical_integration
121648#: code:addons/vertical_integration/report/field_balance_spec_report.py:786
121649#, python-format
121650msgid "Reference of the entry"
121651msgstr "Référence de l'écriture"
121652
121653#. module: vertical_integration
121654#: code:addons/vertical_integration/report/field_balance_spec_report.py:314
121655#, python-format
121656msgid "Report exported from"
121657msgstr "Instance d'export"
121658
121659#. module: vertical_integration
121660#: code:addons/vertical_integration/report/field_balance_spec_report.py:659
121661#, python-format
121662msgid "Subaccount Number"
121663msgstr "Numéro Sous-Compte"
121664
121665#. module: vertical_integration
121666#: selection:field.balance.spec.report,selection:0
121667msgid "Total of entries reconciled in later period"
121668msgstr "Total des écritures lettrées dans une période ultérieure"
121669
121670#. module: vertical_integration
121671#: code:addons/vertical_integration/report/field_balance_spec_report.py:767
121672#: code:addons/vertical_integration/report/field_balance_spec_report.py:1030
121673#, python-format
121674msgid "Total of entries reconciled in later periods >>>"
121675msgstr "Total des écritures lettrées dans des périodes ultérieures >>>"
121676
121677#. module: vertical_integration
121678#: code:addons/vertical_integration/report/field_balance_spec_report.py:429
121679#, python-format
121680msgid "UniField Balance in %s"
121681msgstr "Balance UniField %s"
121682
121683#. module: vertical_integration
121684#: code:addons/vertical_integration/report/field_balance_spec_report.py:595
121685#: code:addons/vertical_integration/report/field_balance_spec_report.py:792
121686#, python-format
121687msgid "Year End Rate Currency Table"
121688msgstr "Taux fin d'année"
121689
121690#. module: vertical_integration
121691#: code:addons/vertical_integration/report/field_balance_spec_report.py:198
121692#, python-format
121693msgid "page"
121694msgstr "page"
121695
121696#. module: vertical_integration
121697#: code:addons/vertical_integration/report/field_balance_spec_report.py:200
121698#, python-format
121699msgid "Posting Rate"
121700msgstr "Taux de comptabilisation"
121701
121702#. module: vertical_integration
121703#: code:addons/vertical_integration/report/field_balance_spec_report.py:210
121704#, python-format
121705msgid "Booking Rate"
121706msgstr "Taux d'enregistrement"
121707
121446#. module: product_attributes121708#. module: product_attributes
121447#: code:addons/product_attributes/report/hq_product_mml_nonconform.py:53121709#: code:addons/product_attributes/report/hq_product_mml_nonconform.py:53
121448#: code:addons/product_attributes/report/product_mml_nonconform.py:67121710#: code:addons/product_attributes/report/product_mml_nonconform.py:67
121449#, python-format121711#, python-format
121450msgid "In-Pipe Quantity included"121712msgid "In-Pipe Quantity included"
121451msgstr "Quantité en attente incluse"121713msgstr "Quantité en attente incluse"
121452
121453121714
=== modified file 'bin/addons/msf_profile/msf_profile.py'
--- bin/addons/msf_profile/msf_profile.py 2023-09-15 13:58:07 +0000
+++ bin/addons/msf_profile/msf_profile.py 2023-09-22 12:20:31 +0000
@@ -57,7 +57,17 @@
57 'model': lambda *a: 'patch.scripts',57 'model': lambda *a: 'patch.scripts',
58 }58 }
5959
60 # UF31.060
61 def us_11026_oca_liquidity_migration_journal(self, cr, uid, *a, **b):
62 entity_obj = self.pool.get('sync.client.entity')
63 if entity_obj and entity_obj.get_entity(cr, uid).oc == 'oca':
64 sql_file = opj('msf_profile', 'data', 'us_11026_migration_items_to_liquidity_journals.sql')
65 fp = tools.file_open(sql_file, 'r')
66 cr.execute(fp.read())
67 fp.close()
68 return True
69
70 # UF30.1
61 def us_11956_fix_po_line_reception_destination(self, cr, uid, *a, **b):71 def us_11956_fix_po_line_reception_destination(self, cr, uid, *a, **b):
62 '''72 '''
63 Set the Reception Destination to Cross Docking for all PO line by Nomenclature (no product) if they are linked73 Set the Reception Destination to Cross Docking for all PO line by Nomenclature (no product) if they are linked
6474
=== modified file 'bin/addons/register_accounting/report/report_liquidity_position.py'
--- bin/addons/register_accounting/report/report_liquidity_position.py 2022-03-01 10:07:54 +0000
+++ bin/addons/register_accounting/report/report_liquidity_position.py 2023-09-22 12:20:31 +0000
@@ -115,7 +115,6 @@
115 self.func_currency = func_curr.name115 self.func_currency = func_curr.name
116 self.func_currency_id = func_curr.id116 self.func_currency_id = func_curr.id
117 for reg in regs:117 for reg in regs:
118
119 journal = reg.journal_id118 journal = reg.journal_id
120 currency = journal.currency119 currency = journal.currency
121120
122121
=== modified file 'bin/addons/spreadsheet_xml/xlsx_write.py'
--- bin/addons/spreadsheet_xml/xlsx_write.py 2023-05-26 13:44:43 +0000
+++ bin/addons/spreadsheet_xml/xlsx_write.py 2023-09-22 12:20:31 +0000
@@ -138,10 +138,16 @@
138 str_date = value138 str_date = value
139 return datetime.datetime.strptime(str_date, "%Y-%m-%d %H:%M:%S")139 return datetime.datetime.strptime(str_date, "%Y-%m-%d %H:%M:%S")
140140
141 def cell_ro(self, value, style=None, unlock=None):141 def cell_ro(self, value, style=None, unlock=None, copy_style=None):
142 new_cell = WriteOnlyCell(self.workbook.active, value=value)142 new_cell = WriteOnlyCell(self.workbook.active, value=value)
143 if style:143 if style:
144 new_cell.style = style144 new_cell.style = style
145 elif copy_style:
146 copied_style_name = '%s_style' % copy_style
147 if copied_style_name in self.workbook.named_styles:
148 new_cell.style = copied_style_name
149 else:
150 new_cell.style = self.create_style_from_template(copied_style_name, copy_style)
145 if unlock:151 if unlock:
146 new_cell.protection = Protection(locked=False)152 new_cell.protection = Protection(locked=False)
147 return new_cell153 return new_cell
148154
=== modified file 'bin/addons/vertical_integration/account_report.xml'
--- bin/addons/vertical_integration/account_report.xml 2023-06-06 08:31:15 +0000
+++ bin/addons/vertical_integration/account_report.xml 2023-09-22 12:20:31 +0000
@@ -19,6 +19,17 @@
19 auto="False"19 auto="False"
20 menu="False"/>20 menu="False"/>
2121
22 <report
23 id="field_balance_spec_report"
24 string="FIELD BALANCE SPECIFICATION REPORT"
25 model="field.balance.spec.parser"
26 name="field_balance_spec_report"
27 report_type="openpyxl"
28 auto="False"
29 target_filename="${_('Balance Specification')}"
30 menu="False"
31 />
32
2233
23 <!-- Sequence for Finance export -->34 <!-- Sequence for Finance export -->
2435
2536
=== modified file 'bin/addons/vertical_integration/report/__init__.py'
--- bin/addons/vertical_integration/report/__init__.py 2023-06-06 08:31:15 +0000
+++ bin/addons/vertical_integration/report/__init__.py 2023-09-22 12:20:31 +0000
@@ -3,3 +3,4 @@
3import hq_report_ocb3import hq_report_ocb
4import hq_report_ocp4import hq_report_ocp
5import hq_report_ocp_matching5import hq_report_ocp_matching
6import field_balance_spec_report
67
=== added file 'bin/addons/vertical_integration/report/field_balance_spec_report.py'
--- bin/addons/vertical_integration/report/field_balance_spec_report.py 1970-01-01 00:00:00 +0000
+++ bin/addons/vertical_integration/report/field_balance_spec_report.py 2023-09-22 12:20:31 +0000
@@ -0,0 +1,1090 @@
1# -*- coding: utf-8 -*-
2from osv import fields, osv
3from tools.translate import _
4from datetime import datetime
5from spreadsheet_xml.xlsx_write import XlsxReport
6from spreadsheet_xml.xlsx_write import XlsxReportParser
7from openpyxl.drawing import image
8from openpyxl.worksheet.header_footer import HeaderFooterItem
9import tools
10from PIL import Image as PILImage
11from dateutil.relativedelta import relativedelta
12import re
13from base import currency_date
14
15class field_balance_spec_report(osv.osv_memory):
16 _name = "field.balance.spec.report"
17
18
19 def _get_has_multi_table(self, cr, uid, ids, name, arg=None, context=None):
20 nb = self.pool.get('res.currency.table').search(cr, uid, [('sate', '=', 'valid')], count=True)
21 ret = {}
22 for _id in ids:
23 ret[_id] = nb > 1
24 return ret
25
26
27 _columns = {
28 'instance_id': fields.many2one('msf.instance', 'Top proprietary instance', required=True, domain=[('level', '=', 'coordo'), ('state', '=', 'active'), ('instance_to_display_ids','=',True)]),
29 'period_id': fields.many2one('account.period', 'Period', required=True, domain=[('state', 'in', ['draft', 'field-closed', 'mission-closed']), ('number', 'not in', [0, 16])]),
30 'selection': fields.selection([('total', 'Total of entries reconciled in later period'),
31 ('details', 'Details of entries reconciled in later period')],
32 string="Select", required=True),
33 'eoy': fields.boolean('End of Year', help='Field is disabled if no valid currency table'),
34 'has_one_table': fields.boolean('Has a single valid currency table', readonly=1),
35 }
36
37 def _get_instance(self, cr, uid, *a, **b):
38 instance = self.pool.get('res.company')._get_instance_record(cr, uid)
39 if instance.level == 'coordo':
40 return instance.id
41 return False
42
43 def _get_has_currency_table(self, cr, uid, *a, **b):
44 return self.pool.get('res.currency.table').search_exists(cr, uid, [('state', '=', 'valid')])
45
46 _defaults = {
47 'selection': lambda *a: 'details',
48 'instance_id': lambda self, cr, uid, *a, **b: self._get_instance(cr, uid, *a, **b),
49 'has_one_table': lambda self, cr, uid, *a, **b: self._get_has_currency_table(cr, uid, *a, **b),
50 }
51
52 def button_create_report(self, cr, uid, ids, context=None):
53 if context is None:
54 context = {}
55
56 if isinstance(ids, (int, long)):
57 ids = [ids]
58
59 report = self.browse(cr, uid, ids[0], context=context)
60 filename = '%s %s %s' % (report.instance_id.instance, report.period_id.name, 'Balance Specification')
61 background_id = self.pool.get('memory.background.report').create(cr, uid, {
62 'file_name': filename,
63 'report_name': 'field_balance_spec_report',
64 }, context=context)
65 context['background_id'] = background_id
66 context['background_time'] = 3
67
68 return {
69 'type': 'ir.actions.report.xml',
70 'report_name': 'field_balance_spec_report',
71 'datas': {'ids': ids, 'target_filename': filename, 'context': context},
72 'context': context,
73 }
74
75field_balance_spec_report()
76
77
78class field_balance_spec_parser(XlsxReportParser):
79 _name = "field.balance.spec.parser"
80
81 def append_line(self, data):
82 if not self.eoy:
83 del(data[9])
84 del(data[8])
85 self.workbook.active.append([self.cell_ro(x[0], x[1], unlock=len(x)>2 and x[2]) for x in data])
86
87 def generate(self, context=None):
88
89 bk_id = self.context.get('background_id')
90 bk_obj = self.pool.get('memory.background.report')
91
92 company = self.pool.get('res.users').browse(self.cr, self.uid, self.uid, fields_to_fetch=['company_id'], context=context).company_id
93
94 if currency_date.get_date_type(self, self.cr) == 'document':
95 date_used = 'document_date'
96 date_used_label = _('Document date')
97 rate_title_main = _('Booking Rate')
98 else:
99 date_used = 'date'
100 date_used_label = _('Posting date')
101 rate_title_main = _('Posting Rate')
102
103 report = self.pool.get('field.balance.spec.report').browse(self.cr, self.uid, self.ids[0], context=context)
104
105
106 self.eoy = report.eoy
107 all_instance_ids = [report.instance_id.id] + [x.id for x in report.instance_id.child_ids]
108
109 self.cr.execute('''
110 select
111 distinct cur.id, cur.name
112 from
113 account_move_line l, account_move m, res_currency cur, account_account a, account_period p
114 where
115 cur.id = l.currency_id
116 and a.id = l.account_id
117 and l.date <= %(last_date)s
118 and p.id = l.period_id
119 and p.number not in (0, 16)
120 and m.id = l.move_id
121 and m.state='posted'
122 and m.instance_id in %(instance)s
123 and (a.reconcile = 't' or a.type = 'liquidity')
124 and l.reconcile_id is null
125 group by
126 cur.id, cur.name
127 order by
128 cur.name
129 ''', {'last_date': report.period_id.date_stop, 'instance': tuple(all_instance_ids)} )
130
131 list_curr = ['EUR', 'USD']
132 curr_id = {}
133 for x in self.cr.fetchall():
134 if x[1] not in ('EUR', 'USD'):
135 list_curr.append(x[1])
136 curr_id[x[0]] = x[1]
137
138 if bk_id:
139 bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.1})
140
141 fx_rates = {}
142 fx_rates_by_id = {}
143 self.cr.execute('''
144 select cur.name,
145 (select rate.rate
146 from res_currency_rate rate
147 where rate.currency_id = cur.id and rate.name <= %s
148 order by
149 rate.name desc
150 limit 1
151 ) as fx_rate,
152 cur.id
153 from res_currency cur
154 where currency_table_id is null and cur.name in %s
155 ''', (report.period_id.date_start, tuple(list_curr) ))
156 for x in self.cr.fetchall():
157 fx_rates[x[0]] = x[1]
158 fx_rates_by_id[x[2]] = x[1]
159
160 ct_fx_rates = {}
161 ct_fx_rates_by_id = {}
162 if report.eoy:
163 self.cr.execute('''
164 select cur.name,
165 (select rate.rate
166 from res_currency_rate rate
167 where rate.currency_id = cur.id
168 order by
169 rate.name desc
170 limit 1
171 ) as fx_rate,
172 cur.reference_currency_id
173 from res_currency cur, res_currency_table t
174 where
175 cur.currency_table_id = t.id
176 and t.state = 'valid'
177 and cur.name in %s
178 ''', (tuple(list_curr), ))
179 for x in self.cr.fetchall():
180 ct_fx_rates[x[0]] = x[1]
181 ct_fx_rates_by_id[x[2]] = x[1]
182
183 rates = {}
184 ct_rates = {}
185 for n, cur in enumerate(list_curr[1:]):
186 rates[n] = {'name': cur, 'value': fx_rates[cur]}
187 if report.eoy:
188 ct_rates[n] = {'name': cur, 'value': ct_fx_rates[cur]}
189
190 page_title = _('Field Balance Specification Report From UniField')
191
192 sheet = self.workbook.active
193 sheet.sheet_view.zoomScale = 75
194 sheet.protection.formatCells = False
195 #sheet.protection.formatRows = False
196 #sheet.protection.formatColumns = False
197 sheet.protection.autoFilter = False
198 sheet.protection.sheet = True
199 sheet.sheet_view.showGridLines = True
200 sheet.page_setup.orientation = 'landscape'
201 sheet.page_setup.fitToPage = True
202 sheet.page_setup.fitToHeight = False
203 sheet.page_setup.paperSize = 9 # A4
204
205 footer = HeaderFooterItem()
206 footer.left.text = "%s, %s, %s, %s &[Page]/&N" % (page_title, report.instance_id.mission, report.period_id.name, _('page'))
207 footer.left.size = 8
208 sheet.oddFooter = footer
209 sheet.evenFooter = footer
210 sheet.page_margins.left = 0.2
211 sheet.page_margins.right = 0.2
212 sheet.page_margins.top = 0.2
213 sheet.page_margins.bottom = 1
214 sheet.freeze_panes = 'C9'
215
216 self.duplicate_column_dimensions()
217 self.duplicate_row_dimensions(range(1, 9))
218 if self.eoy:
219 sheet.column_dimensions['N'].width = sheet.column_dimensions['L'].width
220 sheet.column_dimensions['M'].width = sheet.column_dimensions['K'].width
221 sheet.column_dimensions['L'].width = sheet.column_dimensions['J'].width
222 sheet.column_dimensions['K'].width = sheet.column_dimensions['I'].width
223 sheet.column_dimensions['J'].width = sheet.column_dimensions['H'].width
224 sheet.column_dimensions['I'].width = sheet.column_dimensions['G'].width
225
226 pil_img = PILImage.open(tools.file_open('addons/msf_doc_import/report/images/msf-logo.png', 'rb'))
227 img = image.Image(pil_img)
228 orig_width = img.width
229 orig_height = img.height
230 img.width = 100.
231 img.height = orig_height * (img.width/orig_width)
232
233 sheet.add_image(img, 'A1')
234
235
236 self.create_style_from_template('logo_style', 'A1')
237 self.create_style_from_template('title_cell1_style', 'B1')
238 self.create_style_from_template('title_style', 'I1')
239 self.create_style_from_template('first_field_comment', 'K1')
240 self.create_style_from_template('first_hq_comment', 'L1')
241 self.create_style_from_template('rate_style', 'G1')
242 self.create_style_from_template('current_period_style', 'H1')
243 self.create_style_from_template('func_curr_name', 'G2')
244 self.create_style_from_template('func_curr_value', 'H2')
245 self.create_style_from_template('header_full_date', 'D3')
246 self.create_style_from_template('header_month_date', 'B4')
247 self.create_style_from_template('end_doc', 'B37')
248 self.create_style_from_template('end_doc_left', 'A37')
249 self.create_style_from_template('end_doc_right', 'L37')
250
251 self.create_style_from_template('default_header_style', 'B3')
252 self.create_style_from_template('header_1st_info_title', 'A3')
253 self.create_style_from_template('header_other_info_title', 'C3')
254 self.create_style_from_template('cur_name', 'G3')
255 self.create_style_from_template('cur_value', 'H3')
256 self.create_style_from_template('user_name', 'B5')
257 self.create_style_from_template('user_date', 'C5')
258
259 self.create_style_from_template('title_account', 'A18')
260 self.create_style_from_template('title_text', 'B18')
261 self.create_style_from_template('title_amount', 'F18')
262 self.create_style_from_template('title_info', 'I18')
263 self.create_style_from_template('title_hq_comment', 'L9')
264 self.create_style_from_template('line_account', 'A19')
265 self.create_style_from_template('line_rate', 'G19')
266 self.create_style_from_template('line_amount', 'H19')
267 self.create_style_from_template('line_text', 'B19')
268 self.create_style_from_template('line_date', 'D19')
269 self.create_style_from_template('line_total', 'H25')
270 self.create_style_from_template('line_curr', 'E15')
271 self.create_style_from_template('line_info', 'I24')
272 self.create_style_from_template('line_selection', 'A23')
273 self.create_style_from_template('field_comment', 'K10')
274 self.create_style_from_template('hq_comment', 'L10')
275
276
277
278 sheet.title = '%s %s' % (report.period_id.name, report.instance_id.code)
279 sheet.row_dimensions[1].height = 25
280
281
282 self.append_line([
283 ('', 'logo_style'),
284 (page_title, 'title_cell1_style'),
285 ('', 'title_style'),
286 ('', 'title_style'),
287 ('', 'title_style'),
288 ('', 'title_style'),
289 (_('Rates'), 'rate_style'),
290 (_('Current period'), 'current_period_style'),
291 (_('Rates'), 'rate_style'),
292 (_('End of Year'), 'current_period_style'),
293 ('', 'title_style'),
294 ('', 'title_style'),
295 ('', 'first_field_comment', True),
296 ('', 'first_hq_comment', True)
297 ])
298 sheet.merged_cells.ranges.append("B1:F1")
299
300 self.append_line(
301 [('', 'header_1st_info_title')] +
302 [('', 'default_header_style')] * 5 +
303 [
304 (company.currency_id.name, 'func_curr_name'),
305 (1, 'func_curr_value'),
306 (company.currency_id.name, 'func_curr_name'),
307 (1, 'func_curr_value'),
308 ] +
309 [('', 'default_header_style')] * 2 +
310 [
311 ('', 'field_comment', True),
312 ('', 'hq_comment', True),
313 ]
314 )
315
316 self.append_line([
317 (_('Country Program'), 'header_1st_info_title'),
318 (report.instance_id.mission or '', 'default_header_style'),
319 (_('Date of the report'), 'header_other_info_title'),
320 (datetime.now(), 'header_full_date'),
321 ('', 'default_header_style'),
322 (_('Report exported from'), 'header_other_info_title'),
323 ] + [
324 (rates.get(0, {}).get('name', ''), 'cur_name'),
325 (rates.get(0, {}).get('value', ''), 'cur_value'),
326 (ct_rates.get(0, {}).get('name', ''), 'cur_name'),
327 (ct_rates.get(0, {}).get('value', ''), 'cur_value')
328 ] +
329 [('', 'default_header_style')] * 2 +
330 [
331 ('', 'field_comment', True),
332 ('', 'hq_comment', True)
333 ],
334 )
335
336 self.append_line([
337 (_('Month:'), 'header_1st_info_title'),
338 (datetime.strptime(report.period_id.date_start, '%Y-%m-%d'), 'header_month_date'),
339 (_('Date of review'), 'header_other_info_title'),
340 ('', 'header_full_date'),
341 ('', 'default_header_style'),
342 (company.instance_id.instance, 'default_header_style'),
343 ] + [
344 (rates.get(1, {}).get('name', ''), 'cur_name'),
345 (rates.get(1, {}).get('value', ''), 'cur_value'),
346 (ct_rates.get(1, {}).get('name', ''), 'cur_name'),
347 (ct_rates.get(1, {}).get('value', ''), 'cur_value'),
348 ] + [('', 'default_header_style')] * 2 +
349 [
350 ('', 'field_comment', True),
351 ('', 'hq_comment', True)
352 ]
353 )
354
355 self.append_line([
356 (_('Finco Name:'), 'header_1st_info_title'),
357 ('', 'user_name', True),
358 ('', 'user_date', True),
359 ] +
360 [('', 'default_header_style')] * 3 +
361 [
362 (rates.get(2, {}).get('name', ''), 'cur_name'),
363 (rates.get(2, {}).get('value', ''), 'cur_value'),
364 (ct_rates.get(2, {}).get('name', ''), 'cur_name'),
365 (ct_rates.get(2, {}).get('value', ''), 'cur_value')
366 ] +
367 [('', 'default_header_style')] * 2 +
368 [
369 ('', 'field_comment', True),
370 ('', 'hq_comment', True)
371 ]
372 )
373
374 self.append_line([
375 (_('HoM Name:'), 'header_1st_info_title'),
376 ('', 'user_name', True),
377 ('', 'user_date', True),
378 ] +
379 [('', 'default_header_style')] * 3 +
380 [
381 (rates.get(3, {}).get('name', ''), 'cur_name'),
382 (rates.get(3, {}).get('value', ''), 'cur_value'),
383 (ct_rates.get(3, {}).get('name', ''), 'cur_name'),
384 (ct_rates.get(3, {}).get('value', ''), 'cur_value')
385 ] +
386 [('', 'default_header_style')] * 2 +
387 [
388 ('', 'field_comment', True),
389 ('', 'hq_comment', True)
390 ]
391 )
392
393 self.append_line([
394 (_('HQ reviewer Name:'), 'header_1st_info_title'),
395 ('', 'user_name', True),
396 ('', 'user_date', True),
397 ] +
398 [('', 'default_header_style')] * 3 +
399 [
400 (rates.get(4, {}).get('name', ''), 'cur_name'),
401 (rates.get(4, {}).get('value', ''), 'cur_value'),
402 (ct_rates.get(4, {}).get('name', ''), 'cur_name'),
403 (ct_rates.get(4, {}).get('value', ''), 'cur_value')
404 ] +
405 [('', 'default_header_style')] * 2 +
406 [
407 ('', 'field_comment', True),
408 ('', 'hq_comment', True)
409 ]
410 )
411 rate_idx = 5
412 line = 8
413 while rates.get(rate_idx):
414 self.append_line(
415 [('', 'header_1st_info_title')] +
416 [('', 'default_header_style')] * 5 +
417 [
418 (rates.get(rate_idx, {}).get('name', ''), 'cur_name'),
419 (rates.get(rate_idx, {}).get('value', ''), 'cur_value'),
420 (ct_rates.get(rate_idx, {}).get('name', ''), 'cur_name'),
421 (ct_rates.get(rate_idx, {}).get('value', ''), 'cur_value')
422 ] +
423 [('', 'default_header_style')] * 2 +
424 [
425 ('', 'field_comment', True),
426 ('', 'hq_comment', True)
427 ]
428 )
429 rate_idx += 1
430 line += 1
431
432 self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
433 line += 1
434 self.append_line(
435 [(_('Balance accounts'), 'title_account')] +
436 [('', 'title_text')] * 6 +
437 [(_('UniField Balance in %s') % (company.currency_id.name,) , 'title_amount')] +
438 [('', 'title_text')] +
439 [(_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount')] +
440 [('', 'title_text')] * 2 +
441 [(_("Field's Comments"), 'title_text'), (_("HQ Comments"), 'title_hq_comment')]
442 )
443
444 line += 1
445
446 register_details = {}
447 # sum of liquidity accounts
448 liq_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('type', '=', 'liquidity'), ('reconcile', '=', False)], context=context)
449 for liq_account in self.pool.get('account.account').browse(self.cr, self.uid, liq_account_ids, fields_to_fetch=['code', 'name'], context=context):
450 self.cr.execute('''
451 select
452 l.currency_id, sum(coalesce(amount_currency,0)), j.id
453 from
454 account_move_line l, account_move m, account_period p, account_journal j
455 where
456 l.move_id = m.id
457 and l.period_id = p.id
458 and j.id = l.journal_id
459 and l.instance_id in %(instance)s
460 -- and m.state = 'posted'
461 and p.number not in (0, 16)
462 and l.account_id = %(account_id)s
463 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
464 and j.type in ('bank', 'cash')
465 group by
466 l.currency_id, j.id
467 ''', {
468 'instance': tuple(all_instance_ids),
469 'period_start': report.period_id.date_start,
470 'period_number': report.period_id.number,
471 'account_id': liq_account.id,
472 }
473 )
474 liq_sum = 0
475 ct_sum = 0
476 # total entry encoding
477 for liq in self.cr.fetchall():
478 register_details[liq[2]] = liq[1]
479 liq_sum += liq[1] / fx_rates_by_id.get(liq[0], 1)
480 ct_sum += liq[1] / ct_fx_rates_by_id.get(liq[0], 1)
481
482 self.append_line(
483 [('%s %s' % (liq_account.code, liq_account.name), 'line_account')] +
484 [('', 'line_text')] * 6 +
485 [(round(liq_sum, 2), 'line_amount')] +
486 [('', 'line_text')] +
487 [(round(ct_sum, 2), 'line_amount')] +
488 [('', 'line_text')] * 2 +
489 [('', 'field_comment', True), ('', 'hq_comment', True)]
490 )
491 line += 1
492
493 if bk_id:
494 bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.2})
495
496 # sum of reconciliable accounts
497 ctx_with_date = context.copy()
498 ctx_with_date['date'] = (datetime.strptime(report.period_id.date_stop, '%Y-%m-%d') + relativedelta(days=1)).strftime('%Y-%m-%d')
499 inactive_accounts = {}
500
501 req_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('code', '!=', '15640')], context=context)
502 special_account_id = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('code','=', '15640')], context=context)
503
504 all_account_ids = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True)], context=context) # list ordered by code
505 chq_account = self.pool.get('account.account').search(self.cr, self.uid, [('reconcile', '=', True), ('type', '=', 'liquidity')], context=context)
506
507 list_sum = {}
508 ct_list_sum = {}
509 for list_accounts in [req_account_ids, special_account_id]:
510 if not list_accounts:
511 continue
512 if list_accounts == special_account_id:
513 req_cond = ''
514 # req_cond = 'and l.employee_id is not null'
515 else:
516 req_cond = ''' and (
517 l.reconcile_id is null
518 or exists(
519 select rec_line.id from account_move_line rec_line, account_period rec_p
520 where
521 rec_line.reconcile_id = l.reconcile_id
522 and rec_p.id = rec_line.period_id
523 and (
524 rec_p.date_start > %(period_start)s
525 or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
526 )
527 )
528 )
529 '''
530 self.cr.execute('''
531 select
532 sum(coalesce(l.debit,0) - coalesce(l.credit,0)),
533 l.account_id,
534 sum(coalesce(amount_currency,0)),
535 l.currency_id
536 from
537 account_move_line l
538 inner join account_period p on p.id = l.period_id
539 inner join account_move m on l.move_id = m.id
540 inner join account_journal j on j.id = l.journal_id
541 where
542 l.account_id in %(account_id)s
543 and j.type != 'revaluation'
544 and p.number not in (0, 16)
545 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
546 and m.state='posted'
547 and m.instance_id in %(instance)s
548 ''' + req_cond + '''
549 group by
550 l.account_id, l.currency_id
551 ''', {
552 'account_id': tuple(list_accounts),
553 'period_number': report.period_id.number,
554 'period_start': report.period_id.date_start,
555 'instance': tuple(all_instance_ids),
556 })
557 for ssum in self.cr.fetchall():
558 list_sum.setdefault(ssum[1], 0)
559 ct_list_sum.setdefault(ssum[1], 0)
560 if ssum[1] in chq_account and company.revaluation_default_account:
561 list_sum[ssum[1]] += ssum[2] / fx_rates_by_id.get(ssum[3], 1)
562 else:
563 list_sum[ssum[1]] += ssum[0]
564 ct_list_sum[ssum[1]] += ssum[2] / ct_fx_rates_by_id.get(ssum[3], 1)
565
566 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):
567 if not req_account.filter_active and not list_sum.get(req_account.id):
568 inactive_accounts[req_account.id] = True
569 continue
570
571 if req_account.id in special_account_id:
572 ct_amount = ''
573 else:
574 ct_amount = round(ct_list_sum.get(req_account.id) or 0, 2)
575 self.append_line(
576 [('%s %s' % (req_account.code, req_account.name), 'line_account')] +
577 [('', 'line_text')] * 6 +
578 [(round(list_sum.get(req_account.id) or 0, 2), 'line_amount')] +
579 [('', 'line_text')] +
580 [(ct_amount, 'line_amount')] +
581 [('', 'line_text')] * 2 +
582 [('', 'field_comment', True), ('', 'hq_comment', True)]
583 )
584 line += 1
585
586 self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
587 line += 1
588
589 year = datetime.strptime(report.period_id.date_start, '%Y-%m-%d').year
590 for j_type in ['cash', 'bank']:
591 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)
592 first_line = True
593 account_sum = 0
594 ct_account_sum = 0
595 for journal in self.pool.get('account.journal').browse(self.cr, self.uid, j_ids, context=context):
596 if first_line:
597 self.append_line(
598 [
599 ('%s - %s' % (journal.default_debit_account_id.code, journal.default_debit_account_id.name), 'title_account'),
600 (_('Journal Name'), 'title_text'),
601 (_('Proprietary instance'), 'title_text'),
602 (_('Journal Status'), 'title_text'),
603 (_('Curr'), 'title_info'),
604 (_('Currency Amount'), 'title_amount'),
605 (_('Period Rate'), 'title_amount'),
606 (_('%s Amount with Current Period Rate') % company.currency_id.name, 'title_amount'),
607 (_('Year End Rate Currency Table'), 'title_amount'),
608 (_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount'),
609 ('', 'title_text'),
610 ('', 'title_text'),
611 (_("Field's Comments"), 'title_text'),
612 (_("HQ Comments"), 'title_hq_comment'),
613 ]
614 )
615 line += 1
616 first_line = False
617 self.append_line([
618 (journal.code, 'line_account'),
619 (journal.name, 'line_text'),
620 (journal.instance_id.instance, 'line_text'),
621 (not journal.is_active and _('Inactive') or '', 'line_text'),
622 (journal.currency.name, 'line_curr'),
623 (register_details.get(journal.id, 0), 'line_amount'),
624 (fx_rates_by_id.get(journal.currency.id, 0), 'line_rate'),
625 (register_details.get(journal.id,0) / fx_rates_by_id.get(journal.currency.id, 1), 'line_amount'),
626 (ct_fx_rates_by_id.get(journal.currency.id, 0), 'line_rate'),
627 (register_details.get(journal.id,0) / ct_fx_rates_by_id.get(journal.currency.id, 1), 'line_amount'),
628 ('', 'line_text'),
629 ('', 'line_text'),
630 ('', 'field_comment', True),
631 ('', 'hq_comment', True),
632 ])
633 line += 1
634 account_sum += round(register_details.get(journal.id,0) / fx_rates_by_id.get(journal.currency.id, 1), 2)
635 if report.eoy:
636 ct_account_sum += round(register_details.get(journal.id,0) / ct_fx_rates_by_id.get(journal.currency.id, 1), 2)
637
638 self.append_line(
639 [('', 'header_1st_info_title')] +
640 [('', 'default_header_style')] * 6 +
641 [(account_sum, 'line_total')] +
642 [('', 'default_header_style'), (ct_account_sum if report.eoy else '', 'line_total')] +
643 [('', 'default_header_style')] * 2 +
644 [('', 'field_comment', True), ('', 'hq_comment', True)]
645 )
646 line += 1
647
648
649 self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
650 line += 1
651
652 if bk_id:
653 bk_obj.write(self.cr, self.uid, bk_id, {'percent': 0.5})
654
655 # details of reconciliable accounts
656 total_account = float(len(all_account_ids))
657 nb_account_done = 0
658 for req_account in self.pool.get('account.account').browse(self.cr, self.uid, all_account_ids, fields_to_fetch=['code', 'name'], context=context):
659 if req_account.id in inactive_accounts:
660 continue
661 account_sum = 0
662 ct_account_sum = 0
663 if req_account.code == '15640':
664 self.append_line(
665 [('%s - %s' % (req_account.code, req_account.name), 'title_account')] +
666 [('', 'title_text')] * 6 +
667 [
668 (_('%s Amount') % (company.currency_id.name, ), 'title_amount'),
669 ('', 'title_text'),
670 ('', 'title_text'),
671 (_('Subaccount Number'), 'title_info'),
672 ('', 'title_text'),
673 (_("Field's Comments"), 'title_text'),
674 (_("HQ Comments"), 'title_hq_comment'),
675 ]
676 )
677 line += 1
678 # unreconciled or partial rec
679 self.cr.execute('''
680 select name, sum(balance), identification_id from
681 (
682 select
683 coalesce(res.name, l.partner_txt, '') as name,
684 sum(coalesce(l.debit, 0) - coalesce(l.credit, 0)) as balance,
685 emp.identification_id as identification_id
686 from
687 account_move_line l
688 inner join account_account a on a.id = l.account_id
689 inner join account_period p on p.id = l.period_id
690 inner join account_move m on l.move_id = m.id
691 inner join account_journal j on j.id = l.journal_id
692 left join hr_employee emp on l.employee_id = emp.id
693 left join resource_resource res on res.id = emp.resource_id
694 where
695 l.account_id = %(account_id)s
696 and j.type != 'revaluation'
697 and p.number not in (0, 16)
698 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
699 and m.state='posted'
700 and m.instance_id in %(instance)s
701 group by emp.id, coalesce(res.name, partner_txt, ''), emp.identification_id, res.active
702 having
703 res.active = 't' or abs(sum(coalesce(l.debit, 0) - coalesce(l.credit, 0))) > 0.001
704
705 UNION
706 select res.name as name, 0 as balance, emp.identification_id as identification_id
707 from
708 hr_employee emp, resource_resource res
709 where
710 res.id = emp.resource_id
711 and emp.employee_type='ex'
712 and res.active='t'
713 ) as EMP_ALL
714 group by
715 name, identification_id
716 order by
717 EMP_ALL.identification_id NULLS FIRST
718 ''', {
719 'account_id': req_account.id,
720 'period_number': report.period_id.number,
721 'period_start': report.period_id.date_start,
722 'instance': tuple(all_instance_ids),
723 })
724 partner_txt_lines = {}
725 all_lines = []
726 for emp in self.cr.fetchall():
727 line_amount = emp[1]
728 if emp[0] and not emp[2]:
729 # extract identification_id from partner_txt
730 if abs(line_amount) > 0.001:
731 m = re.search('([0-9]+)\s*$', emp[0])
732 if m:
733 if m.group(1) not in partner_txt_lines:
734 partner_txt_lines[m.group(1)] = {'name': emp[0], 'amount': line_amount}
735 else:
736 partner_txt_lines[m.group(1)]['amount'] += line_amount
737 continue
738 elif partner_txt_lines.get(emp[2]):
739 # add amount on partner_txt to existing employee_id line
740 line_amount += partner_txt_lines[emp[2]]['amount']
741 del partner_txt_lines[emp[2]]
742 if abs(line_amount) <= 0.001:
743 continue
744
745 emp_id = emp[2]
746 if emp_id:
747 try:
748 emp_id = int(emp[2])
749 except:
750 pass
751 all_lines.append([emp[0], line_amount, emp_id])
752
753 # partner_txt lines not linked to employee_id line
754 for emp_id in partner_txt_lines:
755 if abs(partner_txt_lines[emp_id]['amount']) > 0.001:
756 all_lines.append(partner_txt_lines[emp_id])
757
758 for emp in sorted(all_lines, key=lambda x: x[2]):
759 self.append_line(
760 [(emp[0], 'line_account')] +
761 [('', 'line_text')] * 6 +
762 [
763 (round(emp[1], 2), 'line_amount'),
764 ('', 'line_text'),
765 ('', 'line_text'),
766 ('%s'%emp[2], 'line_info'),
767 ('', 'line_text'),
768 ('', 'field_comment', True),
769 ('', 'hq_comment', True),
770 ]
771 )
772 line += 1
773 account_sum += round(emp[1], 2)
774
775
776 if report.selection == 'details':
777 title_sum = _('List of entries reconciled in later periods >>>')
778 else:
779 title_sum = _('Total of entries reconciled in later periods >>>')
780
781 self.append_line(
782 [(title_sum, 'line_selection')] +
783 [('', 'default_header_style')] * 11 +
784 [('', 'field_comment', True), ('', 'hq_comment', True)]
785 )
786 line += 1
787
788 else:
789 rate_title = rate_title_main
790 amount_title = _('%s Amount') % (company.currency_id.name, )
791 if req_account.id in chq_account and company.revaluation_default_account:
792 rate_title = _('Period Rate')
793 amount_title = _('%s Amount with Current Period Rate') % (company.currency_id.name, )
794
795 self.append_line([
796 ('%s - %s' % (req_account.code, req_account.name), 'title_account'),
797 (_('Description of the entry'), 'title_text'),
798 (_('Reference of the entry'), 'title_text'),
799 (date_used_label, 'title_text'),
800 (_('Curr'), 'title_info'),
801 (_('Currency Amount'), 'title_amount'),
802 (rate_title, 'title_amount'),
803 (amount_title, 'title_amount'),
804 (_('Year End Rate Currency Table'), 'title_amount'),
805 (_('%s Amount with Year End Rate Currency Table') % (company.currency_id.name, ), 'title_amount'),
806 (_('Reconcile Number'), 'title_info'),
807 (_('Third Party'), 'title_info'),
808 (_("Field's Comments"), 'title_text'),
809 (_("HQ Comments"), 'title_hq_comment'),
810 ])
811
812 line += 1
813
814 # unreconciled or partial rec
815 self.cr.execute('''
816 select
817 m.name, l.name, l.ref, l.''' + date_used + ''', cur.name, coalesce(l.amount_currency, 0),
818 (select
819 rate.rate
820 from
821 res_currency_rate rate
822 where
823 rate.currency_id = l.currency_id
824 and currency_table_id is null
825 and rate.name <= coalesce(l.source_date, l.''' + date_used + ''')
826 order by
827 rate.name desc
828 limit 1
829 ) as fx_rate,
830 coalesce(l.debit, 0) - coalesce(l.credit, 0),
831 partial.name,
832 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),
833 (
834 select sum(amount_currency) from account_move_line where reconcile_partial_id is not null and reconcile_partial_id = partial.id
835 ),
836 cur.id
837 from
838 account_move_line l
839 inner join account_account a on a.id = l.account_id
840 inner join account_period p on p.id = l.period_id
841 inner join account_move m on l.move_id = m.id
842 inner join res_currency cur on cur.id = l.currency_id
843 inner join account_journal journal on journal.id = l.journal_id
844 left join account_move_reconcile partial on partial.id = l.reconcile_partial_id
845 left join res_partner partner on partner.id = l.partner_id
846 left join hr_employee emp on emp.id = l.employee_id
847 left join account_journal j on j.id = l.transfer_journal_id
848 where
849 l.account_id = %(account_id)s
850 and p.number not in (0, 16)
851 and journal.type != 'revaluation'
852 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
853 and m.state='posted'
854 and m.instance_id in %(instance)s
855 and l.reconcile_id is null
856 order by
857 m.name, l.id
858 ''', {
859 'account_id': req_account.id,
860 'period_number': report.period_id.number,
861 'period_start': report.period_id.date_start,
862 'instance': tuple(all_instance_ids),
863 })
864
865 for account_line in self.cr.fetchall():
866 if req_account.id in chq_account and company.revaluation_default_account:
867 line_rate = fx_rates_by_id.get(account_line[11],'')
868 line_amount = account_line[5] / fx_rates_by_id.get(account_line[11], 1)
869 else:
870 line_rate = account_line[6]
871 line_amount = account_line[7]
872
873 ct_line_rate = ct_fx_rates_by_id.get(account_line[11],'')
874 ct_line_amount = account_line[5] / ct_fx_rates_by_id.get(account_line[11], 1)
875
876 self.append_line([
877 (account_line[0], 'line_account'),
878 (account_line[1], 'line_text'),
879 (account_line[2], 'line_text'),
880 (self.to_datetime(account_line[3]), 'line_date'),
881 (account_line[4], 'line_curr'),
882 (account_line[5], 'line_amount'),
883 (line_rate, 'line_rate'),
884 (line_amount, 'line_amount'),
885 (ct_line_rate, 'line_rate'),
886 (ct_line_amount, 'line_amount'),
887 (account_line[8] and '%s (%.02lf)' % (account_line[8], account_line[10]) or '', 'line_info'),
888 (account_line[9], 'line_text'),
889 ('', 'field_comment', True),
890 ('', 'hq_comment', True),
891 ])
892 line += 1
893 account_sum += round(line_amount, 2)
894 ct_account_sum += round(ct_line_amount, 2)
895
896 if report.selection == 'details':
897 self.append_line(
898 [(_('List of entries reconciled in later periods >>>'), 'line_selection')] +
899 [('', 'default_header_style')] * 11 +
900 [('', 'field_comment', True), ('', 'hq_comment', True)]
901 )
902 line += 1
903
904 # reconciled later
905 self.cr.execute('''
906 select
907 m.name, l.name, l.ref, l.date, cur.name, coalesce(l.amount_currency, 0),
908 (select
909 rate.rate
910 from
911 res_currency_rate rate
912 where
913 rate.currency_id = l.currency_id
914 and currency_table_id is null
915 and rate.name <= coalesce(l.source_date, l.''' + date_used + ''')
916 order by
917 rate.name desc
918 limit 1
919 ) as fx_rate,
920 coalesce(l.debit, 0) - coalesce(l.credit, 0),
921 rec.name,
922 coalesce(partner.name, j.code, emp.name_resource||' '||emp.identification_id),
923 cur.id
924 from
925 account_move_line l
926 inner join account_account a on a.id = l.account_id
927 inner join account_period p on p.id = l.period_id
928 inner join account_move m on l.move_id = m.id
929 inner join res_currency cur on cur.id = l.currency_id
930 inner join account_move_reconcile rec on rec.id = l.reconcile_id
931 inner join account_journal journal on journal.id = l.journal_id
932 left join res_partner partner on partner.id = l.partner_id
933 left join hr_employee emp on emp.id = l.employee_id
934 left join account_journal j on j.id = l.transfer_journal_id
935 where
936 l.account_id = %(account_id)s
937 and journal.type != 'revaluation'
938 and p.number not in (0, 16)
939 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
940 and m.state='posted'
941 and m.instance_id in %(instance)s
942 and
943 exists(
944 select rec_line.id from account_move_line rec_line, account_period rec_p
945 where
946 rec_line.reconcile_id = l.reconcile_id
947 and rec_p.id = rec_line.period_id
948 and (
949 rec_p.date_start > %(period_start)s
950 or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
951 )
952 )
953 order by
954 m.name, l.id
955 ''', {
956 'account_id': req_account.id,
957 'period_number': report.period_id.number,
958 'period_start': report.period_id.date_start,
959 'instance': tuple(all_instance_ids),
960 })
961 for account_line in self.cr.fetchall():
962 if req_account.id in chq_account and company.revaluation_default_account:
963 line_rate = fx_rates_by_id.get(account_line[10],'')
964 line_amount = account_line[5] / fx_rates_by_id.get(account_line[10], 1)
965 else:
966 line_rate = account_line[6]
967 line_amount = account_line[7]
968
969 ct_line_rate = ct_fx_rates_by_id.get(account_line[10],'')
970 ct_line_amount = account_line[5] / ct_fx_rates_by_id.get(account_line[10], 1)
971
972 self.append_line([
973 (account_line[0], 'line_account'),
974 (account_line[1], 'line_text'),
975 (account_line[2], 'line_text'),
976 (self.to_datetime(account_line[3]), 'line_date'),
977 (account_line[4], 'line_curr'),
978 (account_line[5], 'line_amount'),
979 (line_rate, 'line_rate'),
980 (line_amount, 'line_amount'),
981 (ct_line_rate, 'line_rate'),
982 (ct_line_amount, 'line_amount'),
983 (account_line[8], 'line_info'),
984 (account_line[9], 'line_text'),
985 ('', 'field_comment', True),
986 ('', 'hq_comment', True),
987 ])
988 line += 1
989 account_sum += round(line_amount, 2)
990 ct_account_sum += round(ct_line_amount, 2)
991 else:
992 # sum reconciled later
993 self.cr.execute('''
994 select
995 sum(coalesce(l.debit, 0) - coalesce(l.credit, 0)),
996 sum(coalesce(l.amount_currency, 0)),
997 l.currency_id
998 from
999 account_move_line l
1000 inner join account_account a on a.id = l.account_id
1001 inner join account_period p on p.id = l.period_id
1002 inner join account_move m on l.move_id = m.id
1003 inner join res_currency cur on cur.id = l.currency_id
1004 inner join account_move_reconcile rec on rec.id = l.reconcile_id
1005 inner join account_journal journal on journal.id = l.journal_id
1006 where
1007 l.account_id = %(account_id)s
1008 and p.number not in (0, 16)
1009 and journal.type != 'revaluation'
1010 and ( p.date_start < %(period_start)s or p.date_start = %(period_start)s and p.number <= %(period_number)s)
1011 and m.state='posted'
1012 and m.instance_id in %(instance)s
1013 and
1014 exists(
1015 select rec_line.id from account_move_line rec_line, account_period rec_p
1016 where
1017 rec_line.reconcile_id = l.reconcile_id
1018 and rec_p.id = rec_line.period_id
1019 and (
1020 rec_p.date_start > %(period_start)s
1021 or rec_p.date_start = %(period_start)s and rec_p.number > %(period_number)s
1022 )
1023 )
1024 group by l.currency_id
1025 ''', {
1026 'account_id': req_account.id,
1027 'period_number': report.period_id.number,
1028 'period_start': report.period_id.date_start,
1029 'instance': tuple(all_instance_ids),
1030 })
1031 total_later = 0
1032 ct_total_later = 0
1033 for later_rec in self.cr.fetchall():
1034 if req_account.id in chq_account and company.revaluation_default_account:
1035 total_later += later_rec[1] / fx_rates_by_id.get(later_rec[2], 1)
1036 else:
1037 total_later += later_rec[0]
1038 ct_total_later += later_rec[1] / ct_fx_rates_by_id.get(later_rec[2], 1)
1039 account_sum += round(total_later, 2)
1040 ct_account_sum += round(ct_total_later, 2)
1041 self.append_line(
1042 [(_('Total of entries reconciled in later periods >>>'), 'line_selection')] +
1043 [('', 'default_header_style')] * 6 +
1044 [(total_later, 'line_amount')] +
1045 [('', 'default_header_style')] +
1046 [(ct_total_later, 'line_amount')] +
1047 [('', 'default_header_style')] * 2 +
1048 [('', 'field_comment', True), ('', 'hq_comment', True)]
1049 )
1050 line += 1
1051
1052 if req_account.code == '15640':
1053 ct_account_sum = ''
1054
1055 self.append_line(
1056 [('', 'header_1st_info_title')] +
1057 [('', 'default_header_style')] * 6 +
1058 [(account_sum, 'line_total')] +
1059 [('', 'default_header_style')] +
1060 [(ct_account_sum, 'line_total')] +
1061 [('', 'default_header_style')] * 2 +
1062 [('', 'field_comment', True), ('', 'hq_comment', True)]
1063 )
1064 line += 1
1065
1066
1067 self.append_line([('', 'header_1st_info_title')] + [('', 'default_header_style')] * 11 + [('', 'field_comment', True), ('', 'hq_comment', True)])
1068 line += 1
1069
1070 nb_account_done += 1
1071 if bk_id:
1072 bk_obj.write(self.cr, self.uid, bk_id, {'percent': min(0.95, 0.5 + 0.45 * nb_account_done/total_account)})
1073
1074
1075 self.append_line(
1076 [('', 'end_doc_left')] +
1077 [('---%s---' % _('END OF FIELD BALANCE SPECIFICATION REPORT'), 'end_doc')] +
1078 [('', 'end_doc')] * 11 +
1079 [('', 'end_doc_right')]
1080 )
1081 line += 1
1082
1083 if self.eoy:
1084 sheet.print_area = 'A1:N%d' % line
1085 else:
1086 sheet.print_area = 'A1:L%d' % line
1087 if bk_id:
1088 bk_obj.write(self.cr, self.uid, bk_id, {'percent': 1.})
1089
1090XlsxReport('report.field_balance_spec_report', parser=field_balance_spec_parser, template='addons/vertical_integration/report/field_balance_spec_report_template.xlsx')
01091
=== added file 'bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx'
1Binary files bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx and bin/addons/vertical_integration/report/field_balance_spec_report_template.xlsx differ1092Binary 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
=== modified file 'bin/addons/vertical_integration/vertical_integration_wizard.xml'
--- bin/addons/vertical_integration/vertical_integration_wizard.xml 2023-06-06 08:31:15 +0000
+++ bin/addons/vertical_integration/vertical_integration_wizard.xml 2023-09-22 12:20:31 +0000
@@ -89,6 +89,44 @@
89 action="action_hq_export_oca"89 action="action_hq_export_oca"
90 id="menu_action_hq_export_oca" sequence="20"/>90 id="menu_action_hq_export_oca" sequence="20"/>
9191
92
93 <record id="field_bal_spec_report_wizard" model="ir.ui.view">
94 <field name="name">FIELD BALANCE SPECIFICATION REPORT</field>
95 <field name="model">field.balance.spec.report</field>
96 <field name="type">form</field>
97 <field name="priority" eval="25" />
98 <field name="arch" type="xml">
99 <form string="FIELD BALANCE SPECIFICATION REPORT">
100 <field name="instance_id" />
101 <field name="period_id" />
102 <field name="selection"/>
103 <group colspan="2" col="4">
104 <field name="has_one_table" invisible="1" />
105 <field name="eoy" attrs="{'readonly': [('has_one_table', '=', False)]}"/>
106 </group>
107 <group colspan="6" col="4">
108 <label string="" colspan="2"/>
109 <button special="cancel" string="Cancel" colspan="1" icon="gtk-cancel"/>
110 <button icon="terp-camera_test" string="Print" name="button_create_report" type="object" default_focus="1" colspan="1"/>
111 </group>
112 </form>
113 </field>
114 </record>
115
116 <record id="action_field_bal_spec_report" model="ir.actions.act_window">
117 <field name="name">Field Balance Specification Report</field>
118 <field name="type">ir.actions.act_window</field>
119 <field name="res_model">field.balance.spec.report</field>
120 <field name="view_type">form</field>
121 <field name="view_mode">form</field>
122 <field name="view_id" ref="field_bal_spec_report_wizard"/>
123 <field name="target">new</field>
124 </record>
125
126 <menuitem parent="account.final_accounting_reports"
127 action="action_field_bal_spec_report"
128 id="menu_action_field_bal_spec_report" sequence="200"/>
129
92 <!-- OCB export -->130 <!-- OCB export -->
93131
94 <record id="ocb_export_wizard" model="ir.ui.view">132 <record id="ocb_export_wizard" model="ir.ui.view">

Subscribers

People subscribed via source and target branches