-
-
Notifications
You must be signed in to change notification settings - Fork 597
/
print_journal_by_period.yml
107 lines (103 loc) · 4.64 KB
/
print_journal_by_period.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
-
In order to test the Excel General Ledger webkit wizard I will print report on all the journals
-
!python {model: account.account}: |
ctx = {}
fiscalyear_id = ref('account.data_fiscalyear')
wizard = self.pool['account.print.journal.xls']
period_ids = wizard.fy_period_ids(cr, uid, fiscalyear_id)
data_dict = {'chart_account_id': ref('account.chart0'),
'journal_ids': self.pool['account.journal'].search(cr, uid, []),
'fiscalyear_id': fiscalyear_id,
'period_from': period_ids[0],
'period_to': period_ids[-1],
}
ctx.update({'model': 'account.account',
'active_ids': [ref('account.chart0')],
'active_id': ref('account.chart0')})
from openerp.tools import test_reports
test_reports.try_report_action(
cr, uid,
'account_journal_report_xls.action_print_journal_by_period_xls',
wiz_data=data_dict,
context=ctx,
wiz_buttons='print_report',
our_module='account_journal_report_xls')
-
In order to test the Excel General Ledger webkit wizard I will print report with entries sorted by date
-
!python {model: account.account}: |
ctx = {}
fiscalyear_id = ref('account.data_fiscalyear')
wizard = self.pool['account.print.journal.xls']
period_ids = wizard.fy_period_ids(cr, uid, fiscalyear_id)
data_dict = {'chart_account_id': ref('account.chart0'),
'journal_ids': self.pool['account.journal'].search(cr, uid, []),
'sort_selection': 'l.date',
'fiscalyear_id': fiscalyear_id,
'period_from': period_ids[0],
'period_to': period_ids[-1],
}
ctx.update({'model': 'account.account',
'active_ids': [ref('account.chart0')],
'active_id': ref('account.chart0')})
from openerp.tools import test_reports
test_reports.try_report_action(
cr, uid,
'account_journal_report_xls.action_print_journal_by_period_xls',
wiz_data=data_dict,
context=ctx,
wiz_buttons='print_report',
our_module='account_journal_report_xls')
-
In order to test the Excel General Ledger webkit wizard I will print report without grouped entries
-
!python {model: account.account}: |
ctx = {}
fiscalyear_id = ref('account.data_fiscalyear')
wizard = self.pool['account.print.journal.xls']
period_ids = wizard.fy_period_ids(cr, uid, fiscalyear_id)
data_dict = {'chart_account_id': ref('account.chart0'),
'journal_ids': self.pool['account.journal'].search(cr, uid, []),
'group_entries': False,
'fiscalyear_id': fiscalyear_id,
'period_from': period_ids[0],
'period_to': period_ids[-1],
}
ctx.update({'model': 'account.account',
'active_ids': [ref('account.chart0')],
'active_id': ref('account.chart0')})
from openerp.tools import test_reports
test_reports.try_report_action(
cr, uid,
'account_journal_report_xls.action_print_journal_by_period_xls',
wiz_data=data_dict,
context=ctx,
wiz_buttons='print_report',
our_module='account_journal_report_xls')
-
In order to test the Excel General Ledger webkit wizard I will print report with currency
-
!python {model: account.account}: |
ctx = {}
fiscalyear_id = ref('account.data_fiscalyear')
wizard = self.pool['account.print.journal.xls']
period_ids = wizard.fy_period_ids(cr, uid, fiscalyear_id)
data_dict = {'chart_account_id': ref('account.chart0'),
'journal_ids': self.pool['account.journal'].search(cr, uid, []),
'amount_currency': False,
'fiscalyear_id': fiscalyear_id,
'period_from': period_ids[0],
'period_to': period_ids[-1],
}
ctx.update({'model': 'account.account',
'active_ids': [ref('account.chart0')],
'active_id': ref('account.chart0')})
from openerp.tools import test_reports
test_reports.try_report_action(
cr, uid,
'account_journal_report_xls.action_print_journal_by_period_xls',
wiz_data=data_dict,
context=ctx,
wiz_buttons='print_report',
our_module='account_journal_report_xls')