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
|
#!/usr/bin/python
# -*- encoding: utf-8 -*-
###########################################################################
# Module Writen to OpenERP, Open Source Management Solution
# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
# All Rights Reserved
###############Credits######################################################
# Coded by: Humberto Arocha <humberto@openerp.com.ve>
# María Gabriela Quilarque <gabrielaquilarque97@gmail.com>
# Javier Duran <javier@vauxoo.com>
# Planified by: Nhomar Hernandez
# Finance by: Helados Gilda, C.A. http://heladosgilda.com.ve
# Audited by: Humberto Arocha humberto@openerp.com.ve
#############################################################################
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
##############################################################################
from osv import osv
from osv import fields
from tools.translate import _
from tools import config
import time
import datetime
import decimal_precision as dp
class adjustment_book(osv.osv):
def _get_amount_total(self,cr,uid,ids,name,args,context=None):
res = {}
for adj in self.browse(cr,uid,ids,context):
res[adj.id] = {
'amount_total': 0.0,
'amount_untaxed_n_total' : 0.0,
'amount_with_vat_n_total': 0.0,
'amount_untaxed_i_total' : 0.0,
'amount_with_vat_i_total': 0.0,
'uncredit_fiscal_total' : 0.0,
'amount_with_vat_total' : 0.0,
'amount_base_total' : 0.0,
'amount_percent_total' : 0.0,
}
for line in adj.adjustment_ids:
res[adj.id]['amount_total'] += line.amount
res[adj.id]['amount_untaxed_n_total'] += line.amount_untaxed_n
res[adj.id]['amount_with_vat_n_total'] += line.amount_with_vat_n
res[adj.id]['amount_untaxed_i_total'] += line.amount_untaxed_i
res[adj.id]['amount_with_vat_i_total'] += line.amount_with_vat_i
res[adj.id]['uncredit_fiscal_total'] += line.uncredit_fiscal
res[adj.id]['amount_with_vat_total'] += line.amount_with_vat
res[adj.id]['amount_base_total'] += adj.vat_general_i+adj.vat_general_add_i+adj.vat_reduced_i+adj.vat_general_n+\
adj.vat_general_add_n+adj.vat_reduced_n+adj.no_grav+adj.sale_export
res[adj.id]['amount_percent_total'] += adj.vat_general_icf+adj.vat_general_add_icf+adj.vat_reduced_icf+adj.vat_general_ncf+\
adj.vat_general_add_ncf+adj.vat_reduced_ncf+adj.adjustment_cf+adj.sale_export_cf
return res
_name='adjustment.book'
_columns={
'name':fields.char('Description', size=256,required=True,help="Description of adjustment book"),
'period_id':fields.many2one('account.period','Period',required=True,help="Period of adjustment book"),
'adjustment_ids': fields.one2many('adjustment.book.line','adjustment_id','Adjustment Book Line'),
'note': fields.text('Note',required=True),
'type': fields.selection([
('sale','Sale'),
('purchase', 'Purchase'),
],'Type', select=True, required=True, help="Type of adjustment book: Sale or Purchase"),
'amount_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Total Withholding VAT',readonly=True,help="Amount Total for adjustment book of invoice"),
'amount_untaxed_n_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Untaxed National',readonly=True,help="Amount Total Untaxed for adjustment book of nacional operations"),
'amount_with_vat_n_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withheld National',readonly=True,help="Amount Total Withheld for adjustment book of national operations"),
'amount_untaxed_i_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Untaxed International',readonly=True,help="Amount Total Untaxed for adjustment book of internacional operations"),
'amount_with_vat_i_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withheld International',readonly=True,help="Amount Total Withheld for adjustment book of international operations"),
'uncredit_fiscal_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Sin derecho a credito fiscal',readonly=True,help="Sin derecho a credito fiscal"),
'amount_with_vat_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Amount Withholding VAT Total',readonly=True,help="Amount Total Withholding VAT for adjustment book"),
'no_grav': fields.float('Compras/Ventas no Gravadas y/o SDCF', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas no gravadas y/o sin derecho a credito fiscal/ Ventas Internas no grabadas"),
'vat_general_i': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'), help="Importaciones gravadas por alicuota general"),
'vat_general_add_i': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota general mas alicuota adicional"),
'vat_reduced_i': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota reducida"),
'vat_general_n': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'),help="Compras gravadas por alicuota general/Ventas internas gravadas por alicuota general"),
'vat_general_add_n': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas internas gravadas por alicuota general mas alicuota adicional"),
'vat_reduced_n': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas Internas gravadas por alicuota reducida"),
'vat_general_icf': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'), help="Importaciones gravadas por alicuota general"),
'vat_general_add_icf': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota general mas alicuota adicional"),
'vat_reduced_icf': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Importaciones gravadas por alicuota reducida"),
'vat_general_ncf': fields.float('Alicuota general', digits_compute= dp.get_precision('Fiscal Report'),help="Compras gravadas por alicuota general/Ventas internas gravadas por alicuota general"),
'vat_general_add_ncf': fields.float('Alicuota general + Alicuota adicional', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas internas gravadas por alicuota general mas alicuota adicional"),
'vat_reduced_ncf': fields.float('Alicuota Reducida', digits_compute= dp.get_precision('Fiscal Report'),help="Compras/Ventas Internas gravadas por alicuota reducida"),
'adjustment_cf': fields.float('Ajustes', digits_compute= dp.get_precision('Fiscal Report'),help="Ajustes a los creditos/debitos fiscales de los periodos anteriores"),
'amount_base_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Total Base Imponible',readonly=True,help="TOTAL COMPRAS DEL PERIODO/TOTAL VENTAS PARA EFECTOS DE DETERMINACION"),
'amount_percent_total':fields.function(_get_amount_total,multi='all',method=True,digits_compute= dp.get_precision('Fiscal Report'),string='Total % Fiscal',readonly=True,help="TOTALCREDITOS FISCALES DEL PERIODO/TOTAL DEBITOS FISCALES PARA EFECTOS DE DETERMINACION"),
'sale_export':fields.float('Ventas de Exportacion', digits_compute= dp.get_precision('Fiscal Report'),help="Ventas de Exportacion"),
'sale_export_cf':fields.float('Ventas de Exportacion', digits_compute= dp.get_precision('Fiscal Report'),help="Ventas de Exportacion"),
}
_sql_constraints = [
('period_id_type_uniq', 'unique (period_id,type)', 'The period and type combination must be unique!')
]
adjustment_book()
class adjustment_book_line(osv.osv):
_name='adjustment.book.line'
_columns={
'date_accounting': fields.date('Date Accounting', required=True,help="Date accounting for adjustment book"),
'date_admin': fields.date('Date Administrative',required=True, help="Date administrative for adjustment book"),
'vat':fields.char('Vat', size=10,required=True,help="Vat of partner for adjustment book"),
'partner':fields.char('Partner', size=256,required=True,help="Partner for adjustment book"),
'invoice_number':fields.char('Invoice Number', size=256,required=True,help="Invoice number for adjustment book"),
'control_number':fields.char('Invoice Control', size=256,required=True,help="Invoice control for adjustment book"),
'amount':fields.float('Amount Document at Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount document for adjustment book"),
'amount':fields.float('Amount Document at Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount document for adjustment book"),
'type_doc': fields.selection([
('F','Invoice'),
('ND', 'Debit Note'),
('NC', 'Credit Note'),
],'Document Type', select=True, required=True, help="Type of Document for adjustment book: -Invoice(F),-Debit Note(dn),-Credit Note(cn)"),
'doc_affected':fields.char('Affected Document', size=256,required=True,help="Affected Document for adjustment book"),
'uncredit_fiscal':fields.float('Sin derecho a Credito Fiscal',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Sin derechoa credito fiscal"),
'amount_untaxed_n': fields.float('Amount Untaxed',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount untaxed for national operations"),
'percent_with_vat_n': fields.float('% Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for national operations"),
'amount_with_vat_n': fields.float('Amount Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for national operations"),
'amount_untaxed_i': fields.float('Amount Untaxed',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount untaxed for international operations"),
'percent_with_vat_i': fields.float('% Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Percent(%) VAT for international operations"),
'amount_with_vat_i': fields.float('Amount Withholding VAT',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount withholding VAT for international operations"),
'amount_with_vat': fields.float('Amount Withholding VAT Total',digits_compute= dp.get_precision('Fiscal Report'),required=True,help="Amount withheld VAT total"),
'voucher': fields.char('Voucher Withholding VAT', size=256,required=True,help="Voucher Withholding VAT"),
'adjustment_id':fields.many2one('adjustment.book','Adjustment Book')
}
_rec_rame = 'partner'
adjustment_book_line()
|