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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
|
# -*- coding:utf-8 -*-
#az Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo import api, fields, models, tools
class L10nInPaymentReport(models.AbstractModel):
_name = "l10n_in.payment.report"
_description = "Indian accounting payment report"
account_move_id = fields.Many2one('account.move', string="Account Move")
payment_id = fields.Many2one('account.payment', string='Payment')
currency_id = fields.Many2one('res.currency', string="Currency")
amount = fields.Float(string="Amount")
payment_amount = fields.Float(string="Payment Amount")
partner_id = fields.Many2one('res.partner', string="Customer")
payment_type = fields.Selection([('outbound', 'Send Money'), ('inbound', 'Receive Money')], string='Payment Type')
journal_id = fields.Many2one('account.journal', string="Journal")
company_id = fields.Many2one(related="journal_id.company_id", string="Company")
place_of_supply = fields.Char(string="Place of Supply")
supply_type = fields.Char(string="Supply Type")
l10n_in_tax_id = fields.Many2one('account.tax', string="Tax")
tax_rate = fields.Float(string="Rate")
igst_amount = fields.Float(compute="_compute_tax_amount", string="IGST amount")
cgst_amount = fields.Float(compute="_compute_tax_amount", string="CGST amount")
sgst_amount = fields.Float(compute="_compute_tax_amount", string="SGST amount")
cess_amount = fields.Float(compute="_compute_tax_amount", string="CESS amount")
gross_amount = fields.Float(compute="_compute_tax_amount", string="Gross advance")
def _compute_l10n_in_tax(self, taxes, price_unit, currency=None, quantity=1.0, product=None, partner=None):
"""common method to compute gst tax amount base on tax group"""
res = {'igst_amount': 0.0, 'sgst_amount': 0.0, 'cgst_amount': 0.0, 'cess_amount': 0.0}
AccountTaxRepartitionLine = self.env['account.tax.repartition.line']
tax_report_line_igst = self.env.ref('l10n_in.tax_report_line_igst', False)
tax_report_line_cgst = self.env.ref('l10n_in.tax_report_line_cgst', False)
tax_report_line_sgst = self.env.ref('l10n_in.tax_report_line_sgst', False)
tax_report_line_cess = self.env.ref('l10n_in.tax_report_line_cess', False)
filter_tax = taxes.filtered(lambda t: t.type_tax_use != 'none')
tax_compute = filter_tax.compute_all(price_unit, currency=currency, quantity=quantity, product=product, partner=partner)
for tax_data in tax_compute['taxes']:
tax_report_lines = AccountTaxRepartitionLine.browse(tax_data['tax_repartition_line_id']).mapped('tag_ids.tax_report_line_ids')
if tax_report_line_sgst in tax_report_lines:
res['sgst_amount'] += tax_data['amount']
if tax_report_line_cgst in tax_report_lines:
res['cgst_amount'] += tax_data['amount']
if tax_report_line_igst in tax_report_lines:
res['igst_amount'] += tax_data['amount']
if tax_report_line_cess in tax_report_lines:
res['cess_amount'] += tax_data['amount']
res.update(tax_compute)
return res
#TO BE OVERWRITTEN
@api.depends('currency_id')
def _compute_tax_amount(self):
"""Calculate tax amount base on default tax set in company"""
def _select(self):
return """SELECT aml.id AS id,
aml.move_id as account_move_id,
ap.id AS payment_id,
ap.payment_type,
tax.id as l10n_in_tax_id,
tax.amount AS tax_rate,
am.partner_id,
am.amount_total AS payment_amount,
am.journal_id,
aml.currency_id,
(CASE WHEN ps.l10n_in_tin IS NOT NULL
THEN concat(ps.l10n_in_tin,'-',ps.name)
WHEN p.id IS NULL and cps.l10n_in_tin IS NOT NULL
THEN concat(cps.l10n_in_tin,'-',cps.name)
ELSE ''
END) AS place_of_supply,
(CASE WHEN ps.id = cp.state_id or p.id IS NULL
THEN 'Intra State'
WHEN ps.id != cp.state_id and p.id IS NOT NULL
THEN 'Inter State'
END) AS supply_type"""
def _from(self):
return """FROM account_move_line aml
JOIN account_move am ON am.id = aml.move_id
JOIN account_payment ap ON ap.id = aml.payment_id
JOIN account_account AS ac ON ac.id = aml.account_id
JOIN account_journal AS aj ON aj.id = am.journal_id
JOIN res_company AS c ON c.id = aj.company_id
JOIN account_tax AS tax ON tax.id = (
CASE WHEN ap.payment_type = 'inbound'
THEN c.account_sale_tax_id
ELSE c.account_purchase_tax_id END)
JOIN res_partner p ON p.id = aml.partner_id
LEFT JOIN res_country_state ps ON ps.id = p.state_id
LEFT JOIN res_partner cp ON cp.id = COALESCE(aj.l10n_in_gstin_partner_id, c.partner_id)
LEFT JOIN res_country_state cps ON cps.id = cp.state_id
"""
def _where(self):
return """WHERE aml.payment_id IS NOT NULL
AND tax.tax_group_id in (SELECT res_id FROM ir_model_data WHERE module='l10n_in' AND name in ('igst_group','gst_group'))
AND ac.internal_type IN ('receivable', 'payable') AND am.state = 'posted'"""
def init(self):
tools.drop_view_if_exists(self.env.cr, self._table)
self.env.cr.execute("""CREATE or REPLACE VIEW %s AS (
%s %s %s)""" % (self._table, self._select(), self._from(), self._where()))
class AdvancesPaymentReport(models.Model):
_name = "l10n_in.advances.payment.report"
_inherit = 'l10n_in.payment.report'
_description = "Advances Payment Analysis"
_auto = False
date = fields.Date(string="Payment Date")
reconcile_amount = fields.Float(string="Reconcile amount in Payment month")
@api.depends('payment_amount', 'reconcile_amount', 'currency_id')
def _compute_tax_amount(self):
"""Calculate tax amount base on default tax set in company"""
account_move_line = self.env['account.move.line']
for record in self:
base_amount = record.payment_amount - record.reconcile_amount
taxes_data = self._compute_l10n_in_tax(
taxes=record.l10n_in_tax_id,
price_unit=base_amount,
currency=record.currency_id or None,
quantity=1,
partner=record.partner_id or None)
record.igst_amount = taxes_data['igst_amount']
record.cgst_amount = taxes_data['cgst_amount']
record.sgst_amount = taxes_data['sgst_amount']
record.cess_amount = taxes_data['cess_amount']
record.gross_amount = taxes_data['total_excluded']
def _select(self):
select_str = super(AdvancesPaymentReport, self)._select()
select_str += """,
am.date as date,
(SELECT sum(amount) FROM account_partial_reconcile AS apr
WHERE (apr.credit_move_id = aml.id OR apr.debit_move_id = aml.id)
AND (to_char(apr.max_date, 'MM-YYYY') = to_char(aml.date, 'MM-YYYY'))
) AS reconcile_amount,
(am.amount_total - (SELECT (CASE WHEN SUM(amount) IS NULL THEN 0 ELSE SUM(amount) END) FROM account_partial_reconcile AS apr
WHERE (apr.credit_move_id = aml.id OR apr.debit_move_id = aml.id)
AND (to_char(apr.max_date, 'MM-YYYY') = to_char(aml.date, 'MM-YYYY'))
)) AS amount"""
return select_str
class L10nInAdvancesPaymentAdjustmentReport(models.Model):
_name = "l10n_in.advances.payment.adjustment.report"
_inherit = 'l10n_in.payment.report'
_description = "Advances Payment Adjustment Analysis"
_auto = False
date = fields.Date('Reconcile Date')
@api.depends('amount', 'currency_id', 'partner_id')
def _compute_tax_amount(self):
account_move_line = self.env['account.move.line']
for record in self:
taxes_data = self._compute_l10n_in_tax(
taxes=record.l10n_in_tax_id,
price_unit=record.amount,
currency=record.currency_id or None,
quantity=1,
partner=record.partner_id or None)
record.igst_amount = taxes_data['igst_amount']
record.cgst_amount = taxes_data['cgst_amount']
record.sgst_amount = taxes_data['sgst_amount']
record.cess_amount = taxes_data['cess_amount']
record.gross_amount = taxes_data['total_excluded']
def _select(self):
select_str = super(L10nInAdvancesPaymentAdjustmentReport, self)._select()
select_str += """,
apr.max_date AS date,
apr.amount AS amount
"""
return select_str
def _from(self):
from_str = super(L10nInAdvancesPaymentAdjustmentReport, self)._from()
from_str += """
JOIN account_partial_reconcile apr ON apr.credit_move_id = aml.id OR apr.debit_move_id = aml.id
"""
return from_str
def _where(self):
where_str = super(L10nInAdvancesPaymentAdjustmentReport, self)._where()
where_str += """
AND (apr.max_date > aml.date)
"""
return where_str
|
