Merge lp:~vauxoo/openerp-venezuela-localization/ovl70-fb-rev2-kty into lp:openerp-venezuela-localization
- ovl70-fb-rev2-kty
- Merge into trunk
Proposed by
Katherine Zaoral (Vauxoo)
Status: | Merged |
---|---|
Merged at revision: | 844 |
Proposed branch: | lp:~vauxoo/openerp-venezuela-localization/ovl70-fb-rev2-kty |
Merge into: | lp:openerp-venezuela-localization |
Diff against target: |
2313 lines (+984/-909) 8 files modified
l10n_ve_fiscal_book/__openerp__.py (+4/-1) l10n_ve_fiscal_book/model/fiscal_book.py (+199/-170) l10n_ve_fiscal_book/report/fiscal_book_purchase_report.rml (+287/-289) l10n_ve_fiscal_book/report/fiscal_book_sale_report.rml (+364/-439) l10n_ve_fiscal_book/security/fiscal_book_security.xml (+16/-0) l10n_ve_fiscal_book/security/ir.model.access.csv (+16/-0) l10n_ve_fiscal_book/view/fiscal_book.xml (+18/-10) l10n_ve_fiscal_book/workflow/fb_workflow.xml (+80/-0) |
To merge this branch: | bzr merge lp:~vauxoo/openerp-venezuela-localization/ovl70-fb-rev2-kty |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
hbto [Vauxoo] http://www.vauxoo.com | Approve | ||
Review via email:
|
Commit message
Description of the change
[IMP] Fourth revision Fiscal Book.
- Add workflow and security.
- adapted to article 78 (group non tax payer and fiscal printer lines).
- unify and optimized update book process.
- finish verion of book reports.
- more presentable views.
To post a comment you must log in.
Revision history for this message
![](/+icing/build/overlay/assets/skins/sam/images/close.gif)
hbto [Vauxoo] http://www.vauxoo.com (humbertoarocha) : | # |
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'l10n_ve_fiscal_book/__openerp__.py' | |||
2 | --- l10n_ve_fiscal_book/__openerp__.py 2013-04-30 19:55:43 +0000 | |||
3 | +++ l10n_ve_fiscal_book/__openerp__.py 2013-05-27 21:01:40 +0000 | |||
4 | @@ -59,7 +59,10 @@ | |||
5 | 59 | "wizard/fiscal_book_wizard_view.xml", | 59 | "wizard/fiscal_book_wizard_view.xml", |
6 | 60 | "view/adjustment_book.xml", | 60 | "view/adjustment_book.xml", |
7 | 61 | "view/fiscal_book.xml", | 61 | "view/fiscal_book.xml", |
9 | 62 | "report/fiscal_book_report.xml" | 62 | "report/fiscal_book_report.xml", |
10 | 63 | "workflow/fb_workflow.xml", | ||
11 | 64 | "security/fiscal_book_security.xml", | ||
12 | 65 | "security/ir.model.access.csv" | ||
13 | 63 | ], | 66 | ], |
14 | 64 | "active": False, | 67 | "active": False, |
15 | 65 | "installable": True, | 68 | "installable": True, |
16 | 66 | 69 | ||
17 | === modified file 'l10n_ve_fiscal_book/model/fiscal_book.py' | |||
18 | --- l10n_ve_fiscal_book/model/fiscal_book.py 2013-05-20 20:32:23 +0000 | |||
19 | +++ l10n_ve_fiscal_book/model/fiscal_book.py 2013-05-27 21:01:40 +0000 | |||
20 | @@ -194,8 +194,9 @@ | |||
21 | 194 | help="Book's Fiscal Period", | 194 | help="Book's Fiscal Period", |
22 | 195 | required=True), | 195 | required=True), |
23 | 196 | 'state': fields.selection([('draft', 'Getting Ready'), | 196 | 'state': fields.selection([('draft', 'Getting Ready'), |
26 | 197 | ('open', 'Approved by Manager'), | 197 | ('confirmed', 'Approved by Manager'), |
27 | 198 | ('done', 'Seniat Submitted')], | 198 | ('done', 'Seniat Submitted'), |
28 | 199 | ('cancel', 'Cancel')], | ||
29 | 199 | string='Status', required=True), | 200 | string='Status', required=True), |
30 | 200 | 'type': fields.selection([('sale', 'Sale Book'), | 201 | 'type': fields.selection([('sale', 'Sale Book'), |
31 | 201 | ('purchase', 'Purchase Book')], | 202 | ('purchase', 'Purchase Book')], |
32 | @@ -595,13 +596,11 @@ | |||
33 | 595 | taxes. """ | 596 | taxes. """ |
34 | 596 | context = context or {} | 597 | context = context or {} |
35 | 597 | for fb_brw in self.browse(cr, uid, ids, context=context): | 598 | for fb_brw in self.browse(cr, uid, ids, context=context): |
36 | 599 | self.clear_book(cr, uid, [fb_brw.id], context=context) | ||
37 | 598 | self.update_book_invoices(cr, uid, fb_brw.id, context=context) | 600 | self.update_book_invoices(cr, uid, fb_brw.id, context=context) |
38 | 599 | self.update_book_issue_invoices(cr, uid, fb_brw.id, context=context) | 601 | self.update_book_issue_invoices(cr, uid, fb_brw.id, context=context) |
39 | 600 | self.update_book_wh_iva_lines(cr, uid, fb_brw.id, context=context) | 602 | self.update_book_wh_iva_lines(cr, uid, fb_brw.id, context=context) |
40 | 601 | self.update_book_lines(cr, uid, fb_brw.id, context=context) | 603 | self.update_book_lines(cr, uid, fb_brw.id, context=context) |
41 | 602 | if fb_brw.article_number in ['77', '78']: | ||
42 | 603 | self.update_book_ntp_lines(cr, uid, fb_brw.id, context=context) | ||
43 | 604 | self.order_book_lines(cr, uid, fb_brw.id, context=context) | ||
44 | 605 | return True | 604 | return True |
45 | 606 | 605 | ||
46 | 607 | def update_book_invoices(self, cr, uid, fb_id, context=None): | 606 | def update_book_invoices(self, cr, uid, fb_id, context=None): |
47 | @@ -628,8 +627,8 @@ | |||
48 | 628 | return True | 627 | return True |
49 | 629 | 628 | ||
50 | 630 | def _get_issue_invoice_ids(self, cr, uid, fb_id, context=None): | 629 | def _get_issue_invoice_ids(self, cr, uid, fb_id, context=None): |
53 | 631 | """ It returns ids from not open or paid invoices regarding to the type and | 630 | """ It returns ids from not open or paid invoices regarding to the type |
54 | 632 | period of the fiscal book order by date invoiced. | 631 | and period of the fiscal book order by date invoiced. |
55 | 633 | @param fb_id: fiscal book id. | 632 | @param fb_id: fiscal book id. |
56 | 634 | """ | 633 | """ |
57 | 635 | context = context or {} | 634 | context = context or {} |
58 | @@ -647,7 +646,6 @@ | |||
59 | 647 | '&', '&', ('period_id', '=', fb_brw.period_id.id), ('type', 'in', inv_type), | 646 | '&', '&', ('period_id', '=', fb_brw.period_id.id), ('type', 'in', inv_type), |
60 | 648 | ('state', 'not in', inv_state)], | 647 | ('state', 'not in', inv_state)], |
61 | 649 | order='date_invoice asc', context=context) | 648 | order='date_invoice asc', context=context) |
62 | 650 | |||
63 | 651 | return issue_inv_ids | 649 | return issue_inv_ids |
64 | 652 | 650 | ||
65 | 653 | def update_book_issue_invoices(self, cr, uid, fb_id, context=None): | 651 | def update_book_issue_invoices(self, cr, uid, fb_id, context=None): |
66 | @@ -697,8 +695,15 @@ | |||
67 | 697 | """ | 695 | """ |
68 | 698 | context = context or {} | 696 | context = context or {} |
69 | 699 | iwdl_obj = self.pool.get('account.wh.iva.line') | 697 | iwdl_obj = self.pool.get('account.wh.iva.line') |
70 | 698 | fb_brw = self.browse(cr, uid, fb_id, context=context) | ||
71 | 700 | #~ Relate wh iva lines | 699 | #~ Relate wh iva lines |
72 | 701 | iwdl_ids = self._get_wh_iva_line_ids(cr, uid, fb_id, context=context) | 700 | iwdl_ids = self._get_wh_iva_line_ids(cr, uid, fb_id, context=context) |
73 | 701 | |||
74 | 702 | if fb_brw.type == "sale" \ | ||
75 | 703 | and fb_brw.company_id.partner_id.wh_iva_agent and iwdl_ids: | ||
76 | 704 | raise osv.except_osv(_("Error!"), | ||
77 | 705 | _("You have withholdings registred but you are not a withholding agent")) | ||
78 | 706 | |||
79 | 702 | iwdl_obj.write(cr, uid, iwdl_ids, {'fb_id': fb_id}, context=context) | 707 | iwdl_obj.write(cr, uid, iwdl_ids, {'fb_id': fb_id}, context=context) |
80 | 703 | #~ Unrelate wh iva lines (period book change, wh iva line have been | 708 | #~ Unrelate wh iva lines (period book change, wh iva line have been |
81 | 704 | #~ cancel or have change its period) | 709 | #~ cancel or have change its period) |
82 | @@ -711,12 +716,11 @@ | |||
83 | 711 | return True | 716 | return True |
84 | 712 | 717 | ||
85 | 713 | def _get_book_taxes_ids(self, cr, uid, fb_id, context=None): | 718 | def _get_book_taxes_ids(self, cr, uid, fb_id, context=None): |
87 | 714 | """ It returns account invoice taxes IDSs from the fiscal book | 719 | """ It returns account invoice taxes IDs from the fiscal book |
88 | 715 | invoices. | 720 | invoices. |
89 | 716 | @param fb_id: fiscal book id | 721 | @param fb_id: fiscal book id |
90 | 717 | """ | 722 | """ |
91 | 718 | context = context or {} | 723 | context = context or {} |
92 | 719 | inv_obj = self.pool.get('account.invoice') | ||
93 | 720 | ait_ids = [] | 724 | ait_ids = [] |
94 | 721 | for inv_brw in self.browse(cr, uid, fb_id, | 725 | for inv_brw in self.browse(cr, uid, fb_id, |
95 | 722 | context=context).invoice_ids: | 726 | context=context).invoice_ids: |
96 | @@ -724,18 +728,11 @@ | |||
97 | 724 | return ait_ids | 728 | return ait_ids |
98 | 725 | 729 | ||
99 | 726 | def update_book_taxes(self, cr, uid, fb_id, context=None): | 730 | def update_book_taxes(self, cr, uid, fb_id, context=None): |
101 | 727 | """ It relate/unrelate the invoices taxes from the period to the book. | 731 | """ It relate the invoices taxes from the period to the book. |
102 | 728 | @param fb_id: fiscal book id | 732 | @param fb_id: fiscal book id |
103 | 729 | """ | 733 | """ |
104 | 730 | context = context or {} | 734 | context = context or {} |
105 | 731 | fbt_obj = self.pool.get('fiscal.book.taxes') | ||
106 | 732 | fb_brw = self.browse(cr, uid, fb_id, context=context) | ||
107 | 733 | ait_ids = self._get_book_taxes_ids(cr, uid, fb_id, context=context) | 735 | ait_ids = self._get_book_taxes_ids(cr, uid, fb_id, context=context) |
108 | 734 | fbt_ids = fbt_obj.search(cr, uid, [('fb_id', '=', fb_id)], | ||
109 | 735 | context=context) | ||
110 | 736 | #~ Unrelate taxes | ||
111 | 737 | fbt_obj.unlink(cr, uid, fbt_ids, context=context) | ||
112 | 738 | #~ Relate taxes | ||
113 | 739 | data = map(lambda x: (0, 0, {'ait_id': x}), ait_ids) | 736 | data = map(lambda x: (0, 0, {'ait_id': x}), ait_ids) |
114 | 740 | self.write(cr, uid, fb_id, {'fbt_ids': data}, context=context) | 737 | self.write(cr, uid, fb_id, {'fbt_ids': data}, context=context) |
115 | 741 | return True | 738 | return True |
116 | @@ -786,31 +783,21 @@ | |||
117 | 786 | @param fb_id: book id. | 783 | @param fb_id: book id. |
118 | 787 | """ | 784 | """ |
119 | 788 | context = context or {} | 785 | context = context or {} |
120 | 786 | fbl_obj = self.pool.get('fiscal.book.line') | ||
121 | 789 | fb_brw = self.browse(cr, uid, fb_id, context=context) | 787 | fb_brw = self.browse(cr, uid, fb_id, context=context) |
122 | 790 | fbl_obj = self.pool.get('fiscal.book.line') | ||
123 | 791 | fbl_ids = [line_brw.id for line_brw in fb_brw.fbl_ids] | 788 | fbl_ids = [line_brw.id for line_brw in fb_brw.fbl_ids] |
124 | 792 | order_criteria = fb_brw.type == 'sale' \ | 789 | order_criteria = fb_brw.type == 'sale' \ |
126 | 793 | and 'accounting_date asc, fiscal_printer asc, z_report asc, invoice_number asc' \ | 790 | and 'accounting_date asc, invoice_number asc' \ |
127 | 794 | or 'emission_date asc, invoice_number asc' | 791 | or 'emission_date asc, invoice_number asc' |
130 | 795 | ordered_fbl_ids = fbl_obj.search(cr, uid, [('id', 'in', fbl_ids)], | 792 | ordered_fbl_ids = \ |
131 | 796 | order=order_criteria, context=context) | 793 | fbl_obj.search(cr, uid, [('id', 'in', fbl_ids)], |
132 | 794 | order=order_criteria, context=context) | ||
133 | 797 | 795 | ||
134 | 798 | for rank, fbl_id in enumerate(ordered_fbl_ids, 1): | 796 | for rank, fbl_id in enumerate(ordered_fbl_ids, 1): |
135 | 799 | fbl_obj.write(cr, uid, fbl_id, {'rank': rank}, context=context) | 797 | fbl_obj.write(cr, uid, fbl_id, {'rank': rank}, context=context) |
136 | 800 | 798 | ||
137 | 801 | ordered_ntp_ids = fbl_obj.browse(cr, uid, self.order_group_by_invoice_number( | ||
138 | 802 | cr, uid, [line_brw.id for line_brw in fb_brw.ntp_fbl_ids], | ||
139 | 803 | context=context), context=context) | ||
140 | 804 | |||
141 | 805 | for rank, line_brw in enumerate(ordered_ntp_ids, 1): | ||
142 | 806 | fbl_obj.write(cr, uid, line_brw.id, | ||
143 | 807 | {'rank': rank + (1000000 * line_brw.parent_id.rank)}, | ||
144 | 808 | context=context) | ||
145 | 809 | |||
146 | 810 | return True | 799 | return True |
147 | 811 | 800 | ||
148 | 812 | |||
149 | 813 | |||
150 | 814 | def _get_no_match_date_iwdl_ids(self, cr, uid, fb_id, context=None): | 801 | def _get_no_match_date_iwdl_ids(self, cr, uid, fb_id, context=None): |
151 | 815 | """ It returns a list of wh iva lines ids that have a invoice in the | 802 | """ It returns a list of wh iva lines ids that have a invoice in the |
152 | 816 | same book period but where the invoice date_invoice is different from | 803 | same book period but where the invoice date_invoice is different from |
153 | @@ -831,7 +818,8 @@ | |||
154 | 831 | return res | 818 | return res |
155 | 832 | 819 | ||
156 | 833 | def update_book_lines(self, cr, uid, fb_id, context=None): | 820 | def update_book_lines(self, cr, uid, fb_id, context=None): |
158 | 834 | """ It updates the fiscal book lines values. | 821 | """ It updates the fiscal book lines values. Cretate, order and rank |
159 | 822 | the book lines. Creates the book taxes too acorring to lines created. | ||
160 | 835 | @param fb_id: fiscal book id | 823 | @param fb_id: fiscal book id |
161 | 836 | """ | 824 | """ |
162 | 837 | context = context or {} | 825 | context = context or {} |
163 | @@ -840,10 +828,6 @@ | |||
164 | 840 | iwdl_obj = self.pool.get('account.wh.iva.line') | 828 | iwdl_obj = self.pool.get('account.wh.iva.line') |
165 | 841 | fbl_obj = self.pool.get('fiscal.book.line') | 829 | fbl_obj = self.pool.get('fiscal.book.line') |
166 | 842 | fb_brw = self.browse(cr, uid, fb_id, context=context) | 830 | fb_brw = self.browse(cr, uid, fb_id, context=context) |
167 | 843 | #~ delete book lines | ||
168 | 844 | fbl_ids = [fbl_brw.id for fbl_brw in self.browse( | ||
169 | 845 | cr, uid, fb_id, context=context).fbl_ids] | ||
170 | 846 | fbl_obj.unlink(cr, uid, fbl_ids, context=context) | ||
171 | 847 | 831 | ||
172 | 848 | #~ add book lines for withholding iva lines | 832 | #~ add book lines for withholding iva lines |
173 | 849 | if fb_brw.iwdl_ids: | 833 | if fb_brw.iwdl_ids: |
174 | @@ -853,17 +837,20 @@ | |||
175 | 853 | self._get_no_match_date_iwdl_ids(cr, uid, fb_id, | 837 | self._get_no_match_date_iwdl_ids(cr, uid, fb_id, |
176 | 854 | context=context) | 838 | context=context) |
177 | 855 | iwdl_ids = orphan_iwdl_ids + no_match_dt_iwdl_ids | 839 | iwdl_ids = orphan_iwdl_ids + no_match_dt_iwdl_ids |
178 | 840 | t_type = fb_brw.type == 'sale' and 'tp' or 'do' | ||
179 | 856 | for iwdl_brw in iwdl_obj.browse(cr, uid, iwdl_ids, | 841 | for iwdl_brw in iwdl_obj.browse(cr, uid, iwdl_ids, |
180 | 857 | context=context): | 842 | context=context): |
181 | 858 | values = { | 843 | values = { |
182 | 859 | 'iwdl_id': iwdl_brw.id, | 844 | 'iwdl_id': iwdl_brw.id, |
183 | 860 | 'rank': my_rank, | 845 | 'rank': my_rank, |
184 | 846 | 'type': t_type, | ||
185 | 861 | 'accounting_date': iwdl_brw.date_ret or False, | 847 | 'accounting_date': iwdl_brw.date_ret or False, |
186 | 862 | 'emission_date': iwdl_brw.date or iwdl_brw.date_ret or False, | 848 | 'emission_date': iwdl_brw.date or iwdl_brw.date_ret or False, |
187 | 863 | 'doc_type': self.get_doc_type(cr, uid, iwdl_id=iwdl_brw.id, | 849 | 'doc_type': self.get_doc_type(cr, uid, iwdl_id=iwdl_brw.id, |
188 | 864 | context=context), | 850 | context=context), |
189 | 865 | 'wh_number': iwdl_brw.retention_id.number or False, | 851 | 'wh_number': iwdl_brw.retention_id.number or False, |
190 | 866 | 'partner_name': iwdl_brw.retention_id.partner_id.name or False, | 852 | 'partner_name': iwdl_brw.retention_id.partner_id.name or False, |
191 | 853 | 'partner_vat': iwdl_brw.retention_id.partner_id.vat or False, | ||
192 | 867 | 'affected_invoice': iwdl_brw.invoice_id.fiscal_printer | 854 | 'affected_invoice': iwdl_brw.invoice_id.fiscal_printer |
193 | 868 | and iwdl_brw.invoice_id.invoice_printer | 855 | and iwdl_brw.invoice_id.invoice_printer |
194 | 869 | or (fb_brw.type == 'sale' | 856 | or (fb_brw.type == 'sale' |
195 | @@ -903,7 +890,7 @@ | |||
196 | 903 | 'credit_affected': inv_brw.parent_id and \ | 890 | 'credit_affected': inv_brw.parent_id and \ |
197 | 904 | inv_brw.parent_id.type in ['in_refund', 'out_refund'] \ | 891 | inv_brw.parent_id.type in ['in_refund', 'out_refund'] \ |
198 | 905 | and inv_brw.parent_id.number or False, | 892 | and inv_brw.parent_id.number or False, |
200 | 906 | 'ctrl_number': inv_brw.nro_ctrl or False, | 893 | 'ctrl_number': not inv_brw.fiscal_printer and inv_brw.nro_ctrl or False, |
201 | 907 | 'affected_invoice': (doc_type == "N/DE" or doc_type == "N/CR") \ | 894 | 'affected_invoice': (doc_type == "N/DE" or doc_type == "N/CR") \ |
202 | 908 | and (inv_brw.parent_id and inv_brw.parent_id.number or False) \ | 895 | and (inv_brw.parent_id and inv_brw.parent_id.number or False) \ |
203 | 909 | or False, | 896 | or False, |
204 | @@ -936,39 +923,51 @@ | |||
205 | 936 | self.write(cr, uid, fb_id, {'fbl_ids': data}, context=context) | 923 | self.write(cr, uid, fb_id, {'fbl_ids': data}, context=context) |
206 | 937 | self.link_book_lines_and_taxes(cr, uid, fb_id, context=context) | 924 | self.link_book_lines_and_taxes(cr, uid, fb_id, context=context) |
207 | 938 | 925 | ||
208 | 926 | if fb_brw.article_number in ['77', '78']: | ||
209 | 927 | self.update_book_ntp_lines(cr, uid, fb_brw.id, context=context) | ||
210 | 928 | else: | ||
211 | 929 | self.order_book_lines(cr, uid, fb_brw.id, context=context) | ||
212 | 930 | |||
213 | 939 | return True | 931 | return True |
214 | 940 | 932 | ||
220 | 941 | def get_grouped_lines_ids(self, cr, uid, fbl_groups_list, order_field, context=None): | 933 | def get_grouped_consecutive_lines_ids(self, cr, uid, lines_ids, context=None): |
221 | 942 | """ Extract book lines ids groups according to the given citeria. | 934 | """ Return a list of tuples that represent every line in the book. |
222 | 943 | @param fbl_groups_list: list of book lines ids. | 935 | If there is a group of consecutive no tax payer with fiscal printer |
223 | 944 | @param order_field: order criteria (emission_date, accounting_date), | 936 | billing lines, it will return a unique tuple that holds the information |
224 | 945 | fiscal_printer, z_report. | 937 | of the lines. The return tutple has this format |
225 | 938 | ('invoice_number'[0], 'invoice_number'[-1], [line_brw]) | ||
226 | 939 | - 'invoice_number'[0]: invoice number of the first line in the | ||
227 | 940 | group | ||
228 | 941 | - 'invoice_number'[-1]: invoice number of the last line in the | ||
229 | 942 | group | ||
230 | 943 | - [line_brw] list o browse records that weel be into the line. | ||
231 | 944 | @param line_ids: list of book lines ids. | ||
232 | 946 | """ | 945 | """ |
233 | 947 | context = context or {} | 946 | context = context or {} |
254 | 948 | fbl_obj = self.pool.get('fiscal.book.line') | 947 | lines_brws = self.pool.get('fiscal.book.line').browse( |
255 | 949 | groups_list = list() | 948 | cr, uid, lines_ids, context=context) |
256 | 950 | no_group_list = list() | 949 | res = list() |
257 | 951 | 950 | group_list = list() | |
258 | 952 | for group_ids in fbl_groups_list: | 951 | group_value = False |
259 | 953 | group_brw = fbl_obj.browse(cr, uid, group_ids, context=context) | 952 | |
260 | 954 | #~ extract set of values for the order condition | 953 | for line_brw in lines_brws: |
261 | 955 | group_values = list(set([ getattr(line_brw, order_field) | 954 | group_value = group_value or line_brw.type |
262 | 956 | for line_brw in group_brw ])) | 955 | if line_brw.type == group_value and group_value == 'ntp' \ |
263 | 957 | #~ initializing storable group variable. | 956 | and line_brw.fiscal_printer: |
264 | 958 | group_dict = {}.fromkeys(group_values) | 957 | group_list.append(line_brw) |
265 | 959 | for value in group_dict.keys(): | 958 | else: |
266 | 960 | group_dict[value] = list() | 959 | if group_list: |
267 | 961 | #~ separating items to the corresponding sub group. | 960 | res.append( (group_list[0].invoice_number, group_list[-1].invoice_number, group_value, group_list) ) |
268 | 962 | for line_brw in group_brw: | 961 | group_value = line_brw.type |
269 | 963 | group_dict[getattr(line_brw, order_field)].append(line_brw.id) | 962 | group_list = [line_brw] |
250 | 964 | |||
251 | 965 | for value in group_dict.keys(): | ||
252 | 966 | if len(group_dict[value]) > 1: | ||
253 | 967 | groups_list.append(group_dict[value]) | ||
270 | 968 | else: | 963 | else: |
274 | 969 | no_group_list.extend(group_dict[value]) | 964 | res.append( (line_brw.invoice_number, line_brw.invoice_number, group_value, [line_brw]) ) |
275 | 970 | 965 | group_value = False | |
276 | 971 | return groups_list, no_group_list | 966 | |
277 | 967 | if group_list: | ||
278 | 968 | res.append( (group_list[0].invoice_number, group_list[-1].invoice_number, group_value, group_list) ) | ||
279 | 969 | |||
280 | 970 | return res | ||
281 | 972 | 971 | ||
282 | 973 | def update_book_ntp_lines(self, cr, uid, fb_id, context=None): | 972 | def update_book_ntp_lines(self, cr, uid, fb_id, context=None): |
283 | 974 | """ It consolidate no tax payer book lines into one line considering | 973 | """ It consolidate no tax payer book lines into one line considering |
284 | @@ -981,74 +980,122 @@ | |||
285 | 981 | fbl_obj = self.pool.get('fiscal.book.line') | 980 | fbl_obj = self.pool.get('fiscal.book.line') |
286 | 982 | fb_brw = self.browse(cr, uid, fb_id, context=context) | 981 | fb_brw = self.browse(cr, uid, fb_id, context=context) |
287 | 983 | 982 | ||
325 | 984 | #~ delete old ntp book lines | 983 | #~ separating groups |
326 | 985 | ntp_fbl_ids = [fbl_brw.id for fbl_brw in self.browse( | 984 | lines_brws = fb_brw.fbl_ids |
327 | 986 | cr, uid, fb_id, context=context).ntp_fbl_ids] | 985 | order_dict = dict() |
328 | 987 | fbl_obj.unlink(cr, uid, ntp_fbl_ids, context=context) | 986 | date_values = list(set([ line_brw.emission_date for line_brw in lines_brws ])) |
329 | 988 | 987 | date_values.sort() | |
330 | 989 | #~ extracting mather ntp lines | 988 | order_dict = {}.fromkeys(date_values) |
331 | 990 | ntp_lines = [ fbl_brw.id for fbl_brw in fb_brw.fbl_ids | 989 | for date in date_values: |
332 | 991 | if fbl_brw.type == 'ntp' and fbl_brw.fiscal_printer] | 990 | date_records = [ line_brw |
333 | 992 | no_group_list = list() | 991 | for line_brw in lines_brws |
334 | 993 | groups_list = [[ fbl_id for fbl_id in ntp_lines ]] | 992 | if line_brw.emission_date == date ] |
335 | 994 | 993 | printers_values = list(set( [ line_brw.fiscal_printer for line_brw in date_records ] )) | |
336 | 995 | #~ define book groups cirteria | 994 | printers_values.sort() |
337 | 996 | #~ TODO: Be carefull with de date criteria order. | 995 | order_dict[date] = {}.fromkeys(printers_values) |
338 | 997 | order_criteria = ['emission_date', 'fiscal_printer', 'z_report'] | 996 | for printer in printers_values: |
339 | 998 | 997 | printer_records = [ line_brw | |
340 | 999 | for criteria in order_criteria: | 998 | for line_brw in date_records |
341 | 1000 | groups_list, tmp_no_group_list = \ | 999 | if line_brw.fiscal_printer == printer ] |
342 | 1001 | self.get_grouped_lines_ids(cr, uid, groups_list, criteria, | 1000 | z_report_values = list(set( [ line_brw.z_report for line_brw in printer_records ] )) |
343 | 1002 | context=context) | 1001 | z_report_values.sort() |
344 | 1003 | no_group_list.extend(tmp_no_group_list) | 1002 | order_dict[date][printer] = {}.fromkeys(z_report_values) |
345 | 1004 | #~ print criteria, groups_list, 'no group', no_group_list | 1003 | for z_report in z_report_values: |
346 | 1005 | 1004 | #~ this records needs to be order by invoice number | |
347 | 1006 | #~ print 'no_group_list:', no_group_list | 1005 | z_records = \ |
348 | 1007 | #~ print 'groups_list:', groups_list | 1006 | [ (line_brw.invoice_number, line_brw) |
349 | 1008 | 1007 | for line_brw in printer_records | |
350 | 1009 | groups_list = \ | 1008 | if line_brw.z_report == z_report ] |
351 | 1010 | [ self.order_group_by_invoice_number(cr, uid, group_ids, context=context) | 1009 | z_records.sort() |
352 | 1011 | for group_ids in groups_list ] | 1010 | z_records = [ item[1] for item in z_records] |
353 | 1012 | 1011 | #~ group by type of line | |
354 | 1013 | # re-write no group lines (set partner name and vat). | 1012 | order_dict[date][printer][z_report] = \ |
355 | 1014 | if no_group_list: | 1013 | self.get_grouped_consecutive_lines_ids( |
356 | 1015 | fbl_obj.write(cr, uid, no_group_list, | 1014 | cr, uid, [ item.id for item in z_records], |
357 | 1016 | {'partner_name': 'No Contribuyente', | 1015 | context=context) |
358 | 1017 | 'partner_vat': False}, context=context) | 1016 | |
359 | 1018 | 1017 | #~ import pprint | |
360 | 1019 | # re-write group info. | 1018 | #~ print 'order_dict' |
361 | 1020 | for group_ids in groups_list: | 1019 | #~ pprint.pprint(order_dict) |
362 | 1020 | |||
363 | 1021 | # agruping and ranking | ||
364 | 1022 | rank = 1 | ||
365 | 1023 | #~ order_dict[date][printer][z_report] = [ ('desde', 'hasta', 'tipot', list(line_brws)) ] | ||
366 | 1024 | ntp_groups_list = list() # format [ ( rank, invoice_number, [line_brws] ) ] | ||
367 | 1025 | ntp_no_group_list = list() # format [ ( rank, [line_brws] ) ] | ||
368 | 1026 | order_no_group_list = list() # format [ ( rank, line_id ) ] | ||
369 | 1027 | |||
370 | 1028 | order_dates = order_dict.keys() | ||
371 | 1029 | order_dates.sort() | ||
372 | 1030 | for date in order_dates: | ||
373 | 1031 | order_printers = order_dict[date].keys() | ||
374 | 1032 | order_printers.sort() | ||
375 | 1033 | for printer in order_printers: | ||
376 | 1034 | order_z_reports = order_dict[date][printer].keys() | ||
377 | 1035 | order_z_reports.sort() | ||
378 | 1036 | for z_report in order_z_reports: | ||
379 | 1037 | for line in order_dict[date][printer][z_report]: | ||
380 | 1038 | if line[2] == 'ntp': | ||
381 | 1039 | if line[0] == line[1] and len(line[3]) == 1: | ||
382 | 1040 | ntp_no_group_list.append( | ||
383 | 1041 | (rank, line[3][0].id)) | ||
384 | 1042 | elif line[0] != line[1] and len(line[3]) > 1: | ||
385 | 1043 | ntp_groups_list.append( | ||
386 | 1044 | (rank, | ||
387 | 1045 | 'Desde: '+line[0]+' ... Hasta: '+line[1], | ||
388 | 1046 | line[3])) | ||
389 | 1047 | else: | ||
390 | 1048 | raise osv.except_osv(_("Error!"), _("This is a no valid line. Be sure you have two or more invoices with the same invoice number")) | ||
391 | 1049 | elif line[2] != 'ntp': | ||
392 | 1050 | order_no_group_list.append( | ||
393 | 1051 | (rank, line[3][0].id)) | ||
394 | 1052 | rank+= 1 | ||
395 | 1053 | |||
396 | 1054 | #~ import pprint | ||
397 | 1055 | #~ print '\n ntp_no_group_list' | ||
398 | 1056 | #~ pprint.pprint(ntp_no_group_list) | ||
399 | 1057 | #~ print '\n ntp_groups_list' | ||
400 | 1058 | #~ pprint.pprint(ntp_groups_list) | ||
401 | 1059 | #~ print '\n order_no_group_list' | ||
402 | 1060 | #~ pprint.pprint(order_no_group_list) | ||
403 | 1061 | |||
404 | 1062 | #~ # rank lines that have nothing to do with ntp. | ||
405 | 1063 | for line in order_no_group_list: | ||
406 | 1064 | fbl_obj.write(cr, uid, line[1], {'rank': line[0]}, context=context) | ||
407 | 1065 | |||
408 | 1066 | #~ # rank ntp individual lines. | ||
409 | 1067 | for line in ntp_no_group_list: | ||
410 | 1068 | fbl_obj.write( | ||
411 | 1069 | cr, uid, line[1], | ||
412 | 1070 | {'rank': line[0], | ||
413 | 1071 | 'partner_name': 'No Contribuyente', | ||
414 | 1072 | 'partner_vat': False}, | ||
415 | 1073 | context=context) | ||
416 | 1074 | |||
417 | 1075 | #~ create consolidate line using ntp_groups_list list, move group lines | ||
418 | 1076 | #~ to no tax payer lines detail. | ||
419 | 1077 | for line_tuple in ntp_groups_list: | ||
420 | 1021 | consolidate_line_id = \ | 1078 | consolidate_line_id = \ |
422 | 1022 | self.create_consolidate_line(cr, uid, fb_id, group_ids, | 1079 | self.create_consolidate_line(cr, uid, fb_id, line_tuple, |
423 | 1023 | context=context) | 1080 | context=context) |
424 | 1081 | for rank, line_brw in enumerate(line_tuple[-1], 1): | ||
425 | 1082 | fbl_obj.write( | ||
426 | 1083 | cr, uid, line_brw.id, | ||
427 | 1084 | {'fb_id': False, | ||
428 | 1085 | 'ntp_fb_id': fb_id, | ||
429 | 1086 | 'parent_id': consolidate_line_id, | ||
430 | 1087 | 'rank': -1 }, | ||
431 | 1088 | context=context) | ||
432 | 1024 | 1089 | ||
433 | 1025 | # move group lines to no tax payer lines. | ||
434 | 1026 | fbl_obj.write(cr, uid, group_ids, | ||
435 | 1027 | {'fb_id': False, | ||
436 | 1028 | 'ntp_fb_id': fb_id, | ||
437 | 1029 | 'parent_id': consolidate_line_id }, | ||
438 | 1030 | context=context) | ||
439 | 1031 | return True | 1090 | return True |
440 | 1032 | 1091 | ||
457 | 1033 | def order_group_by_invoice_number(self, cr, uid, group_ids, context=None): | 1092 | def create_consolidate_line(self, cr, uid, fb_id, line_tuple, context=None): |
458 | 1034 | """ Return a list of order group items by asc invoice number. | 1093 | """ Create a new consolidate no tax payer line for a group of no tax |
443 | 1035 | @param group_ids: ids of the item that are in a same group | ||
444 | 1036 | """ | ||
445 | 1037 | context = context or {} | ||
446 | 1038 | fbl_obj = self.pool.get('fiscal.book.line') | ||
447 | 1039 | group_brws = fbl_obj.browse(cr, uid, group_ids, context=context) | ||
448 | 1040 | ordered_inv_nums = [ item.invoice_number for item in group_brws ] | ||
449 | 1041 | ordered_inv_nums.sort() | ||
450 | 1042 | return [ item.id | ||
451 | 1043 | for number in ordered_inv_nums | ||
452 | 1044 | for item in group_brws | ||
453 | 1045 | if item.invoice_number == number ] | ||
454 | 1046 | |||
455 | 1047 | def create_consolidate_line(self, cr, uid, fb_id, group_ids, context=None): | ||
456 | 1048 | """ Create a New consolidate no tax payer line for a group of no tax | ||
459 | 1049 | payer operations. | 1094 | payer operations. |
460 | 1050 | @param fb_id: fiscal book line id. | 1095 | @param fb_id: fiscal book line id. |
462 | 1051 | @param group_ids: lines ids to be consolidated. | 1096 | @param line_tuple: tuple with the information for construct the |
463 | 1097 | consolidate line (rank, [brws]). | ||
464 | 1098 | # format [ ( rank, invoice_number, [line_brws] ) ] | ||
465 | 1052 | """ | 1099 | """ |
466 | 1053 | context = context or {} | 1100 | context = context or {} |
467 | 1054 | fbl_obj = self.pool.get('fiscal.book.line') | 1101 | fbl_obj = self.pool.get('fiscal.book.line') |
468 | @@ -1057,33 +1104,28 @@ | |||
469 | 1057 | 'vat_general_base', 'vat_general_tax', | 1104 | 'vat_general_base', 'vat_general_tax', |
470 | 1058 | 'vat_additional_base', 'vat_additional_tax'] | 1105 | 'vat_additional_base', 'vat_additional_tax'] |
471 | 1059 | 1106 | ||
475 | 1060 | group_brws = fbl_obj.browse(cr, uid, group_ids, context=context) | 1107 | rank, invoice_number, child_brws = line_tuple |
476 | 1061 | first_item_brw = fbl_obj.browse(cr, uid, group_ids[0], context=context) | 1108 | child_ids = [ line_brw.id for line_brw in child_brws ] |
477 | 1062 | last_item_brw = fbl_obj.browse(cr, uid, group_ids[-1:], context=context)[0] | 1109 | first_item_brw = fbl_obj.browse(cr, uid, child_brws[0].id, |
478 | 1110 | context=context) | ||
479 | 1063 | # fill common value | 1111 | # fill common value |
480 | 1064 | values = { | 1112 | values = { |
481 | 1113 | 'rank': rank, | ||
482 | 1114 | 'invoice_number': invoice_number, | ||
483 | 1115 | 'child_ids': [(6, 0, child_ids)], | ||
484 | 1065 | 'fb_id': first_item_brw.fb_id.id, | 1116 | 'fb_id': first_item_brw.fb_id.id, |
489 | 1066 | 'invoice_id': False, | 1117 | 'partner_name': 'No Contribuyente', |
486 | 1067 | 'parent_id': False, | ||
487 | 1068 | 'child_ids': [(6, 0, group_ids)], | ||
488 | 1069 | 'rank': first_item_brw.id, | ||
490 | 1070 | 'emission_date': first_item_brw.emission_date, | 1118 | 'emission_date': first_item_brw.emission_date, |
491 | 1071 | 'accounting_date': first_item_brw.accounting_date, | 1119 | 'accounting_date': first_item_brw.accounting_date, |
492 | 1072 | 'doc_type': first_item_brw.doc_type, | 1120 | 'doc_type': first_item_brw.doc_type, |
493 | 1073 | 'partner_name': 'No Contribuyente', | ||
494 | 1074 | 'partner_vat': False, | ||
495 | 1075 | 'invoice_number': 'Desde: ' \ | ||
496 | 1076 | + str(first_item_brw.invoice_number) \ | ||
497 | 1077 | + ' ... Hasta: ' + str(last_item_brw.invoice_number), | ||
498 | 1078 | 'debit_affected': False, | ||
499 | 1079 | 'credit_affected': False, | ||
500 | 1080 | 'type': first_item_brw.type, | 1121 | 'type': first_item_brw.type, |
501 | 1081 | 'fiscal_printer': first_item_brw.fiscal_printer, | 1122 | 'fiscal_printer': first_item_brw.fiscal_printer, |
502 | 1082 | 'z_report': first_item_brw.z_report, | 1123 | 'z_report': first_item_brw.z_report, |
503 | 1083 | } | 1124 | } |
504 | 1084 | # fill totalization values | 1125 | # fill totalization values |
505 | 1085 | for col in float_colums: | 1126 | for col in float_colums: |
507 | 1086 | values[col] = sum([ getattr(brw, col) for brw in group_brws ]) | 1127 | values[col] = \ |
508 | 1128 | sum([ getattr(line_brw, col) for line_brw in child_brws ]) | ||
509 | 1087 | 1129 | ||
510 | 1088 | return fbl_obj.create(cr, uid, values, context=context) | 1130 | return fbl_obj.create(cr, uid, values, context=context) |
511 | 1089 | 1131 | ||
512 | @@ -1202,6 +1244,9 @@ | |||
513 | 1202 | sum( [ data[optype + '_' + ttax + "_vat_base_sum"] | 1244 | sum( [ data[optype + '_' + ttax + "_vat_base_sum"] |
514 | 1203 | for ttax in ["general", "additional", "reduced"] ] ) | 1245 | for ttax in ["general", "additional", "reduced"] ] ) |
515 | 1204 | 1246 | ||
516 | 1247 | data['imex_vat_base_sum'] += \ | ||
517 | 1248 | data['imex_exempt_vat_sum'] + data['imex_sdcf_vat_sum'] | ||
518 | 1249 | |||
519 | 1205 | #~ sale book domestic fields transformations (ntp and tp sums) | 1250 | #~ sale book domestic fields transformations (ntp and tp sums) |
520 | 1206 | if fb_brw.type == 'sale': | 1251 | if fb_brw.type == 'sale': |
521 | 1207 | 1252 | ||
522 | @@ -1294,44 +1339,31 @@ | |||
523 | 1294 | book line and update the fields of sum taxes in the book. | 1339 | book line and update the fields of sum taxes in the book. |
524 | 1295 | @param fb_id: the id of the current fiscal book """ | 1340 | @param fb_id: the id of the current fiscal book """ |
525 | 1296 | context = context or {} | 1341 | context = context or {} |
526 | 1297 | fbt_obj = self.pool.get('fiscal.book.taxes') | ||
527 | 1298 | fbl_obj = self.pool.get('fiscal.book.line') | 1342 | fbl_obj = self.pool.get('fiscal.book.line') |
528 | 1299 | #~ delete book taxes | ||
529 | 1300 | fbt_ids = fbt_obj.search(cr, uid, [('fb_id', '=', fb_id)], | ||
530 | 1301 | context=context) | ||
531 | 1302 | fbt_obj.unlink(cr, uid, fbt_ids, context=context) | ||
532 | 1303 | #~ write book taxes | 1343 | #~ write book taxes |
533 | 1304 | data = [] | 1344 | data = [] |
534 | 1305 | for fbl in self.browse(cr, uid, fb_id, context=context).fbl_ids: | 1345 | for fbl in self.browse(cr, uid, fb_id, context=context).fbl_ids: |
535 | 1306 | if fbl.invoice_id: | 1346 | if fbl.invoice_id: |
538 | 1307 | total_w_iva_amount = fbl.invoice_id.amount_untaxed | 1347 | amount_field_data = \ |
539 | 1308 | sdcf_tax_amount = exent_tax_amount = amount_withheld = 0.0 | 1348 | { 'total_with_iva': fbl.invoice_id.amount_untaxed, |
540 | 1349 | 'vat_sdcf': 0.0, 'vat_exempt': 0.0 } | ||
541 | 1309 | taxes = fbl.type in ['im','ex'] \ | 1350 | taxes = fbl.type in ['im','ex'] \ |
544 | 1310 | and fbl.invoice_id.imex_tax_line \ | 1351 | and fbl.invoice_id.imex_tax_line \ |
545 | 1311 | or fbl.invoice_id.tax_line | 1352 | or fbl.invoice_id.tax_line |
546 | 1312 | for ait in taxes: | 1353 | for ait in taxes: |
547 | 1313 | if ait.tax_id: | 1354 | if ait.tax_id: |
548 | 1314 | data.append((0, 0, {'fb_id': fb_id, | 1355 | data.append((0, 0, {'fb_id': fb_id, |
549 | 1315 | 'fbl_id': fbl.id, | 1356 | 'fbl_id': fbl.id, |
550 | 1316 | 'ait_id': ait.id})) | 1357 | 'ait_id': ait.id})) |
553 | 1317 | 1358 | amount_field_data['total_with_iva'] += ait.tax_amount | |
552 | 1318 | total_w_iva_amount += ait.tax_amount | ||
554 | 1319 | if ait.tax_id.appl_type == 'sdcf': | 1359 | if ait.tax_id.appl_type == 'sdcf': |
556 | 1320 | sdcf_tax_amount += ait.base_amount | 1360 | amount_field_data['vat_sdcf'] += ait.base_amount |
557 | 1321 | if ait.tax_id.appl_type == 'exento': | 1361 | if ait.tax_id.appl_type == 'exento': |
559 | 1322 | exent_tax_amount += ait.base_amount | 1362 | amount_field_data['vat_exempt'] += ait.base_amount |
560 | 1323 | else: | 1363 | else: |
561 | 1324 | data.append((0, 0, {'fb_id': | 1364 | data.append((0, 0, {'fb_id': |
562 | 1325 | fb_id, 'fbl_id': False, 'ait_id': ait.id})) | 1365 | fb_id, 'fbl_id': False, 'ait_id': ait.id})) |
572 | 1326 | fbl_obj.write( | 1366 | fbl_obj.write(cr, uid, fbl.id, amount_field_data, context=context) |
564 | 1327 | cr, uid, fbl.id, {'total_with_iva': total_w_iva_amount}, | ||
565 | 1328 | context=context) | ||
566 | 1329 | fbl_obj.write( | ||
567 | 1330 | cr, uid, fbl.id, {'vat_sdcf': sdcf_tax_amount}, | ||
568 | 1331 | context=context) | ||
569 | 1332 | fbl_obj.write( | ||
570 | 1333 | cr, uid, fbl.id, {'vat_exempt': exent_tax_amount}, | ||
571 | 1334 | context=context) | ||
573 | 1335 | 1367 | ||
574 | 1336 | if data: | 1368 | if data: |
575 | 1337 | self.write(cr, uid, fb_id, {'fbt_ids': data}, context=context) | 1369 | self.write(cr, uid, fb_id, {'fbt_ids': data}, context=context) |
576 | @@ -1384,22 +1416,19 @@ | |||
577 | 1384 | return True | 1416 | return True |
578 | 1385 | 1417 | ||
579 | 1386 | def clear_book_lines(self, cr, uid, ids, context=None): | 1418 | def clear_book_lines(self, cr, uid, ids, context=None): |
581 | 1387 | """ It delete all book lines loaded in the book. """ | 1419 | """ It delete all book lines loaded in the book """ |
582 | 1388 | context = context or {} | 1420 | context = context or {} |
583 | 1389 | fbl_obj = self.pool.get("fiscal.book.line") | 1421 | fbl_obj = self.pool.get("fiscal.book.line") |
584 | 1390 | for fb_id in ids: | 1422 | for fb_id in ids: |
585 | 1391 | fbl_brws = self.browse(cr, uid, fb_id, context=context).fbl_ids | 1423 | fbl_brws = self.browse(cr, uid, fb_id, context=context).fbl_ids |
586 | 1392 | fbl_ids = [fbl.id for fbl in fbl_brws] | 1424 | fbl_ids = [fbl.id for fbl in fbl_brws] |
587 | 1393 | fbl_obj.unlink(cr, uid, fbl_ids, context=context) | 1425 | fbl_obj.unlink(cr, uid, fbl_ids, context=context) |
588 | 1394 | ntp_fbl_brws = self.browse(cr, uid, fb_id, context=context).fbl_ids | ||
589 | 1395 | ntp_fbl_ids = [fbl.id for fbl in ntp_fbl_brws] | ||
590 | 1396 | fbl_obj.unlink(cr, uid, ntp_fbl_ids, context=context) | ||
591 | 1397 | self.clear_book_taxes_amount_fields(cr, uid, fb_id, | 1426 | self.clear_book_taxes_amount_fields(cr, uid, fb_id, |
592 | 1398 | context=context) | 1427 | context=context) |
593 | 1399 | return True | 1428 | return True |
594 | 1400 | 1429 | ||
595 | 1401 | def clear_book_taxes(self, cr, uid, ids, context=None): | 1430 | def clear_book_taxes(self, cr, uid, ids, context=None): |
597 | 1402 | """ It delete all book taxes loaded in the book. """ | 1431 | """ It delete all book taxes loaded in the book """ |
598 | 1403 | context = context or {} | 1432 | context = context or {} |
599 | 1404 | fbt_obj = self.pool.get("fiscal.book.taxes") | 1433 | fbt_obj = self.pool.get("fiscal.book.taxes") |
600 | 1405 | for fb_id in ids: | 1434 | for fb_id in ids: |
601 | 1406 | 1435 | ||
602 | === modified file 'l10n_ve_fiscal_book/report/fiscal_book_purchase_report.rml' | |||
603 | --- l10n_ve_fiscal_book/report/fiscal_book_purchase_report.rml 2013-05-20 18:33:19 +0000 | |||
604 | +++ l10n_ve_fiscal_book/report/fiscal_book_purchase_report.rml 2013-05-27 21:01:40 +0000 | |||
605 | @@ -1,21 +1,301 @@ | |||
606 | 1 | <?xml version="1.0"?> | 1 | <?xml version="1.0"?> |
608 | 2 | <document filename="test.pdf" invariant="1"> | 2 | <document filename="book.pdf" invariant="1"> |
609 | 3 | <!-- | 3 | <!-- |
610 | 4 | info: http://www.dpandi.com/paper/ | 4 | info: http://www.dpandi.com/paper/ |
611 | 5 | Royal Size ( 20 x 25 inches ) | 5 | Royal Size ( 20 x 25 inches ) |
612 | 6 | A2 Size ( 420 x 594 mm - 16.5 x 23.4 inches ) | 6 | A2 Size ( 420 x 594 mm - 16.5 x 23.4 inches ) |
613 | 7 | A3 Size ( 297 x 420 mm - 11.7 x 16.5 inches ) | 7 | A3 Size ( 297 x 420 mm - 11.7 x 16.5 inches ) |
614 | 8 | --> | 8 | --> |
616 | 9 | <template pageSize="(59.4cm, 42.0cm)" title="Test" author="Katherine Zaoral" allowSplitting="20" showBoundary="0"> | 9 | <template pageSize="(59.4cm, 42.0cm)" title="Fiscal Book" author="Katherine Zaoral" allowSplitting="20" showBoundary="0"> |
617 | 10 | <pageTemplate id="first"> | 10 | <pageTemplate id="first"> |
618 | 11 | <pageGraphics> | 11 | <pageGraphics> |
619 | 12 | |||
620 | 13 | <!-- PAGE HEADER --> | ||
621 | 14 | <place x="2cm" y="36.7cm" width="59.4cm" height="3.33cm"> | ||
622 | 15 | <!-- REPORT HEADER --> | ||
623 | 16 | <blockTable colWidths="28.81cm,11.08cm,15.51cm" style="HEADER-REPORT-TABLE"> | ||
624 | 17 | <tr> | ||
625 | 18 | [[ setLang(my_fb.company_id.partner_id.lang) ]] | ||
626 | 19 | <td> | ||
627 | 20 | <para style="HEADERDOC">[[ company.partner_id.name ]] [[ company.partner_id.vat[2:] ]]</para> | ||
628 | 21 | <para style="HEADERDOC">[[ my_fb.get_partner_addr ]]</para> | ||
629 | 22 | </td> | ||
630 | 23 | <td> | ||
631 | 24 | <para style="HEADERDOC">Libro: Compras </para> | ||
632 | 25 | <para style="HEADERDOC">[[ my_fb.get_month_year ]]</para> | ||
633 | 26 | <para style="HEADERDOC">[[ 'Desde: %s'%formatLang( my_fb.period_id.date_start, date=True) ]]</para> | ||
634 | 27 | <para style="HEADERDOC">[[ 'Hasta: %s'%formatLang( my_fb.period_id.date_stop, date=True) ]]</para> | ||
635 | 28 | </td> | ||
636 | 29 | <td> | ||
637 | 30 | <para style="HEADERDOC" fontName="Times-Roman">Según Articulo 76 del Reglamento de la Ley del IVA No. 5.363 del 12 de Julio de 1999</para> | ||
638 | 31 | <para style="POPINFO">[[ my_fb.state == 'draft' and 'GETTING READY' or my_fb.state == 'confirmed' and 'APPROVED BY MANAGER' or my_fb.state == 'done' and '' ]]</para> | ||
639 | 32 | </td> | ||
640 | 33 | </tr> | ||
641 | 34 | </blockTable> | ||
642 | 35 | <spacer length="0.5cm"/> | ||
643 | 36 | </place> | ||
644 | 37 | |||
645 | 38 | <place x="8.34cm" y="34.3cm" width="59.4cm" height="3.33cm"> | ||
646 | 39 | <!-- PURCHASE BOOK HEADERS --> | ||
647 | 40 | <section> | ||
648 | 41 | <blockTable colWidths="379.0, 37.0, 310.0, 485.0" style="HEADER-BOOK-TABLE" blockAlignment="LEFT"> | ||
649 | 42 | <tr> | ||
650 | 43 | <td> | ||
651 | 44 | <blockTable colWidths="379.0" style="HEADER-BOOK-TABLE"> | ||
652 | 45 | <tr> | ||
653 | 46 | <td vAlign="MIDDLE"><para style="HEADER">DATOS DE LA FACTURA O/Y DOCUMENTO</para></td> | ||
654 | 47 | </tr> | ||
655 | 48 | <tr> | ||
656 | 49 | <td> | ||
657 | 50 | <blockTable colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 130.0, 25.0, 63.0" style="HEADER-BOOK-TABLE"> | ||
658 | 51 | <tr> | ||
659 | 52 | <td vAlign="MIDDLE"><para style="HEADER">Linea</para></td> | ||
660 | 53 | <td vAlign="MIDDLE"><para style="HEADER">T. Doc.</para></td> | ||
661 | 54 | <td vAlign="MIDDLE"><para style="HEADER">Fecha Doc.</para></td> | ||
662 | 55 | <td vAlign="MIDDLE"><para style="HEADER">Numero Control</para></td> | ||
663 | 56 | <td vAlign="MIDDLE"><para style="HEADER">Numero de Documento</para></td> | ||
664 | 57 | <td vAlign="MIDDLE"><para style="HEADER">Factura Afectada</para></td> | ||
665 | 58 | <td vAlign="MIDDLE"><para style="HEADER">Razon Social</para></td> | ||
666 | 59 | <td vAlign="MIDDLE"><para style="HEADER">RIF</para></td> | ||
667 | 60 | <td vAlign="MIDDLE"><para style="HEADER">Liquidación de Aduana</para> | ||
668 | 61 | <section> | ||
669 | 62 | <blockTable colWidths="23.0, 40.0" style="HEADER-BOOK-TABLE"> | ||
670 | 63 | <tr> | ||
671 | 64 | <td><para style="HEADER">Fecha Nac.</para></td> | ||
672 | 65 | <td><para style="HEADER">Declaración</para></td> | ||
673 | 66 | </tr> | ||
674 | 67 | </blockTable> | ||
675 | 68 | </section> | ||
676 | 69 | </td> | ||
677 | 70 | </tr> | ||
678 | 71 | </blockTable> | ||
679 | 72 | </td> | ||
680 | 73 | </tr> | ||
681 | 74 | </blockTable> | ||
682 | 75 | </td> | ||
683 | 76 | <td> | ||
684 | 77 | <blockTable colWidths="37.0" style="HEADER-BOOK-TABLE"> | ||
685 | 78 | <tr> | ||
686 | 79 | <td vAlign="MIDDLE"><para style="HEADER">TOTALES</para></td> | ||
687 | 80 | </tr> | ||
688 | 81 | <tr> | ||
689 | 82 | <td> | ||
690 | 83 | <blockTable colWidths="37.0" style="HEADER-BOOK-TABLE" rowHeights="12"> | ||
691 | 84 | <tr> | ||
692 | 85 | <td vAlign="MIDDLE"><para style="HEADER">Total con IVA</para></td> | ||
693 | 86 | </tr> | ||
694 | 87 | </blockTable> | ||
695 | 88 | </td> | ||
696 | 89 | </tr> | ||
697 | 90 | </blockTable> | ||
698 | 91 | </td> | ||
699 | 92 | <td> | ||
700 | 93 | <blockTable colWidths="310.0" style="HEADER-BOOK-TABLE"> | ||
701 | 94 | <tr> | ||
702 | 95 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES DE IMPORTACIONES</para></td> | ||
703 | 96 | </tr> | ||
704 | 97 | <tr> | ||
705 | 98 | <td> | ||
706 | 99 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="HEADER-BOOK-TABLE"> | ||
707 | 100 | <tr> | ||
708 | 101 | <td> | ||
709 | 102 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
710 | 103 | <tr> | ||
711 | 104 | <td><para style="HEADER">No Gravado</para></td> | ||
712 | 105 | </tr> | ||
713 | 106 | <tr> | ||
714 | 107 | <td> | ||
715 | 108 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE"> | ||
716 | 109 | <tr> | ||
717 | 110 | <td><para style="HEADER">SDCF</para></td> | ||
718 | 111 | <td><para style="HEADER">Exento</para></td> | ||
719 | 112 | </tr> | ||
720 | 113 | </blockTable> | ||
721 | 114 | </td> | ||
722 | 115 | </tr> | ||
723 | 116 | </blockTable> | ||
724 | 117 | </td> | ||
725 | 118 | <td> | ||
726 | 119 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
727 | 120 | <tr> | ||
728 | 121 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota General</para></td> | ||
729 | 122 | </tr> | ||
730 | 123 | <tr> | ||
731 | 124 | <td> | ||
732 | 125 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
733 | 126 | <tr> | ||
734 | 127 | <td><para style="HEADER">Base Imponible</para></td> | ||
735 | 128 | <td><para style="HEADER">AlÃcuota</para></td> | ||
736 | 129 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
737 | 130 | </tr> | ||
738 | 131 | </blockTable> | ||
739 | 132 | </td> | ||
740 | 133 | </tr> | ||
741 | 134 | </blockTable> | ||
742 | 135 | </td> | ||
743 | 136 | <td> | ||
744 | 137 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
745 | 138 | <tr> | ||
746 | 139 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Reducida</para></td> | ||
747 | 140 | </tr> | ||
748 | 141 | <tr> | ||
749 | 142 | <td> | ||
750 | 143 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
751 | 144 | <tr> | ||
752 | 145 | <td><para style="HEADER">Base Imponible</para></td> | ||
753 | 146 | <td><para style="HEADER">AlÃcuota</para></td> | ||
754 | 147 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
755 | 148 | </tr> | ||
756 | 149 | </blockTable> | ||
757 | 150 | </td> | ||
758 | 151 | </tr> | ||
759 | 152 | </blockTable> | ||
760 | 153 | </td> | ||
761 | 154 | <td> | ||
762 | 155 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
763 | 156 | <tr> | ||
764 | 157 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Adicional</para></td> | ||
765 | 158 | </tr> | ||
766 | 159 | <tr> | ||
767 | 160 | <td> | ||
768 | 161 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
769 | 162 | <tr> | ||
770 | 163 | <td><para style="HEADER">Base Imponible</para></td> | ||
771 | 164 | <td><para style="HEADER">AlÃcuota</para></td> | ||
772 | 165 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
773 | 166 | </tr> | ||
774 | 167 | </blockTable> | ||
775 | 168 | </td> | ||
776 | 169 | </tr> | ||
777 | 170 | </blockTable> | ||
778 | 171 | </td> | ||
779 | 172 | </tr> | ||
780 | 173 | </blockTable> | ||
781 | 174 | </td> | ||
782 | 175 | </tr> | ||
783 | 176 | </blockTable> | ||
784 | 177 | </td> | ||
785 | 178 | <td> | ||
786 | 179 | <blockTable colWidths="485.0" style="HEADER-BOOK-TABLE"> | ||
787 | 180 | <tr> | ||
788 | 181 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES EN EL MERCADO INTERNO</para></td> | ||
789 | 182 | </tr> | ||
790 | 183 | <tr> | ||
791 | 184 | <td> | ||
792 | 185 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0, 175.0" style="HEADER-BOOK-TABLE"> | ||
793 | 186 | <tr> | ||
794 | 187 | <td> | ||
795 | 188 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
796 | 189 | <tr> | ||
797 | 190 | <td><para style="HEADER">No Gravado</para></td> | ||
798 | 191 | </tr> | ||
799 | 192 | <tr> | ||
800 | 193 | <td> | ||
801 | 194 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE"> | ||
802 | 195 | <tr> | ||
803 | 196 | <td><para style="HEADER">SDCF</para></td> | ||
804 | 197 | <td><para style="HEADER">Exento</para></td> | ||
805 | 198 | </tr> | ||
806 | 199 | </blockTable> | ||
807 | 200 | </td> | ||
808 | 201 | </tr> | ||
809 | 202 | </blockTable> | ||
810 | 203 | </td> | ||
811 | 204 | <td> | ||
812 | 205 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
813 | 206 | <tr> | ||
814 | 207 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota General</para></td> | ||
815 | 208 | </tr> | ||
816 | 209 | <tr> | ||
817 | 210 | <td> | ||
818 | 211 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
819 | 212 | <tr> | ||
820 | 213 | <td><para style="HEADER">Base Imponible</para></td> | ||
821 | 214 | <td><para style="HEADER">AlÃcuota</para></td> | ||
822 | 215 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
823 | 216 | </tr> | ||
824 | 217 | </blockTable> | ||
825 | 218 | </td> | ||
826 | 219 | </tr> | ||
827 | 220 | </blockTable> | ||
828 | 221 | </td> | ||
829 | 222 | <td> | ||
830 | 223 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
831 | 224 | <tr> | ||
832 | 225 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Reducida</para></td> | ||
833 | 226 | </tr> | ||
834 | 227 | <tr> | ||
835 | 228 | <td> | ||
836 | 229 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
837 | 230 | <tr> | ||
838 | 231 | <td><para style="HEADER">Base Imponible</para></td> | ||
839 | 232 | <td><para style="HEADER">AlÃcuota</para></td> | ||
840 | 233 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
841 | 234 | </tr> | ||
842 | 235 | </blockTable> | ||
843 | 236 | </td> | ||
844 | 237 | </tr> | ||
845 | 238 | </blockTable> | ||
846 | 239 | </td> | ||
847 | 240 | <td> | ||
848 | 241 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
849 | 242 | <tr> | ||
850 | 243 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Adicional</para></td> | ||
851 | 244 | </tr> | ||
852 | 245 | <tr> | ||
853 | 246 | <td> | ||
854 | 247 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
855 | 248 | <tr> | ||
856 | 249 | <td><para style="HEADER">Base Imponible</para></td> | ||
857 | 250 | <td><para style="HEADER">AlÃcuota</para></td> | ||
858 | 251 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
859 | 252 | </tr> | ||
860 | 253 | </blockTable> | ||
861 | 254 | </td> | ||
862 | 255 | </tr> | ||
863 | 256 | </blockTable> | ||
864 | 257 | </td> | ||
865 | 258 | <td> | ||
866 | 259 | <blockTable colWidths="175.0" style="HEADER-BOOK-TABLE"> | ||
867 | 260 | <tr> | ||
868 | 261 | <td><para style="HEADER">Retenciones</para></td> | ||
869 | 262 | </tr> | ||
870 | 263 | <tr> | ||
871 | 264 | <td> | ||
872 | 265 | <blockTable colWidths="35.0, 35.0, 35.0, 35.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
873 | 266 | <tr> | ||
874 | 267 | <td><para style="HEADER">Fecha Factura Afect.</para></td> | ||
875 | 268 | <td><para style="HEADER">Nro Retención</para></td> | ||
876 | 269 | <td><para style="HEADER">Débito Fiscal Base</para></td> | ||
877 | 270 | <td><para style="HEADER">Retención %</para></td> | ||
878 | 271 | <td><para style="HEADER">Monto Retenido</para></td> | ||
879 | 272 | </tr> | ||
880 | 273 | </blockTable> | ||
881 | 274 | </td> | ||
882 | 275 | </tr> | ||
883 | 276 | </blockTable> | ||
884 | 277 | </td> | ||
885 | 278 | </tr> | ||
886 | 279 | </blockTable> | ||
887 | 280 | </td> | ||
888 | 281 | </tr> | ||
889 | 282 | </blockTable> | ||
890 | 283 | </td> | ||
891 | 284 | </tr> | ||
892 | 285 | </blockTable> | ||
893 | 286 | </section> | ||
894 | 287 | </place> | ||
895 | 288 | |||
896 | 289 | <!-- PAGE FOOTER --> | ||
897 | 12 | <setFont name="Times-Roman" size="10"/> | 290 | <setFont name="Times-Roman" size="10"/> |
898 | 13 | <drawString x="2.5cm" y="2.5cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString> | 291 | <drawString x="2.5cm" y="2.5cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString> |
899 | 14 | <drawString x="55cm" y="2.5cm">Pagina <pageNumber/></drawString> | 292 | <drawString x="55cm" y="2.5cm">Pagina <pageNumber/></drawString> |
900 | 15 | <lineMode width="0.7"/> | 293 | <lineMode width="0.7"/> |
901 | 294 | <setFont name="Times-Roman" size="8"/> | ||
902 | 295 | <drawString x="25cm" y="2.5cm"> Printed in Report Lab using OpenERP</drawString> | ||
903 | 16 | <lines>2.0cm 3.0cm 57.4cm 3.0cm</lines> | 296 | <lines>2.0cm 3.0cm 57.4cm 3.0cm</lines> |
904 | 17 | </pageGraphics> | 297 | </pageGraphics> |
906 | 18 | <frame id="first" x1="2.0cm" y1="2.0cm" width="55.4cm" height="38.0cm"/> | 298 | <frame id="first" x1="2.0cm" y1="3.5cm" width="55.4cm" height="33.7cm"/> |
907 | 19 | </pageTemplate> | 299 | </pageTemplate> |
908 | 20 | </template> | 300 | </template> |
909 | 21 | 301 | ||
910 | @@ -68,6 +348,7 @@ | |||
911 | 68 | <paraStyle name="CONTENIDOLEFT" fontName="Times-Roman" fontSize="4.5" leading="4.7" alignment="LEFT"/> | 348 | <paraStyle name="CONTENIDOLEFT" fontName="Times-Roman" fontSize="4.5" leading="4.7" alignment="LEFT"/> |
912 | 69 | <paraStyle name="HEADERLEFT" fontName="Times-Roman" fontSize="4.0" leading="6" alignment="LEFT"/> | 349 | <paraStyle name="HEADERLEFT" fontName="Times-Roman" fontSize="4.0" leading="6" alignment="LEFT"/> |
913 | 70 | <paraStyle name="CONTENIDOLEFT_BOLD" fontName="Times-Bold" fontSize="7.0" leading="6" alignment="LEFT"/> | 350 | <paraStyle name="CONTENIDOLEFT_BOLD" fontName="Times-Bold" fontSize="7.0" leading="6" alignment="LEFT"/> |
914 | 351 | <paraStyle name="POPINFO" fontName="Times-Bold" fontSize="18.0" textColor="red" leading="6" alignment="LEFT"/> | ||
915 | 71 | 352 | ||
916 | 72 | </stylesheet> | 353 | </stylesheet> |
917 | 73 | <images/> | 354 | <images/> |
918 | @@ -78,276 +359,6 @@ | |||
919 | 78 | <section> | 359 | <section> |
920 | 79 | <para>[[repeatIn( objects ,'my_fb')]]</para> | 360 | <para>[[repeatIn( objects ,'my_fb')]]</para> |
921 | 80 | 361 | ||
922 | 81 | <!-- REPORT HEADER --> | ||
923 | 82 | <blockTable colWidths="28.81cm,11.08cm,15.51cm" style="HEADER-REPORT-TABLE"> | ||
924 | 83 | <tr> | ||
925 | 84 | [[ setLang(my_fb.company_id.partner_id.lang) ]] | ||
926 | 85 | <td> | ||
927 | 86 | <para style="HEADERDOC">[[ company.partner_id.name ]] [[ company.partner_id.vat[2:] ]]</para> | ||
928 | 87 | <para style="HEADERDOC">[[ my_fb.get_partner_addr ]]</para> | ||
929 | 88 | </td> | ||
930 | 89 | <td> | ||
931 | 90 | <para style="HEADERDOC">Libro: Compras </para> | ||
932 | 91 | <para style="HEADERDOC">[[ my_fb.get_month_year ]]</para> | ||
933 | 92 | <para style="HEADERDOC">[[ 'Desde: %s'%formatLang( my_fb.period_id.date_start, date=True) ]]</para> | ||
934 | 93 | <para style="HEADERDOC">[[ 'Hasta: %s'%formatLang( my_fb.period_id.date_stop, date=True) ]]</para> | ||
935 | 94 | </td> | ||
936 | 95 | <td> | ||
937 | 96 | <para style="HEADERDOC" fontName="Times-Roman">Según Articulo 76 del Reglamento de la Ley del IVA No. 5.363 del 12 de Julio de 1999</para> | ||
938 | 97 | </td> | ||
939 | 98 | </tr> | ||
940 | 99 | </blockTable> | ||
941 | 100 | <spacer length="10mm"/> | ||
942 | 101 | |||
943 | 102 | <!-- PURCHASE BOOK HEADERS --> | ||
944 | 103 | <section> | ||
945 | 104 | <blockTable colWidths="379.0, 37.0, 310.0, 485.0" style="HEADER-BOOK-TABLE" blockAlignment="LEFT"> | ||
946 | 105 | <tr> | ||
947 | 106 | <td> | ||
948 | 107 | <blockTable colWidths="379.0" style="HEADER-BOOK-TABLE"> | ||
949 | 108 | <tr> | ||
950 | 109 | <td vAlign="MIDDLE"><para style="HEADER">DATOS DE LA FACTURA O/Y DOCUMENTO</para></td> | ||
951 | 110 | </tr> | ||
952 | 111 | <tr> | ||
953 | 112 | <td> | ||
954 | 113 | <blockTable colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 130.0, 25.0, 63.0" style="HEADER-BOOK-TABLE"> | ||
955 | 114 | <tr> | ||
956 | 115 | <td vAlign="MIDDLE"><para style="HEADER">Linea</para></td> | ||
957 | 116 | <td vAlign="MIDDLE"><para style="HEADER">T. Doc.</para></td> | ||
958 | 117 | <td vAlign="MIDDLE"><para style="HEADER">Fecha Doc.</para></td> | ||
959 | 118 | <td vAlign="MIDDLE"><para style="HEADER">Numero Control</para></td> | ||
960 | 119 | <td vAlign="MIDDLE"><para style="HEADER">Numero de Documento</para></td> | ||
961 | 120 | <td vAlign="MIDDLE"><para style="HEADER">Factura Afectada</para></td> | ||
962 | 121 | <td vAlign="MIDDLE"><para style="HEADER">Razon Social</para></td> | ||
963 | 122 | <td vAlign="MIDDLE"><para style="HEADER">RIF</para></td> | ||
964 | 123 | <td vAlign="MIDDLE"><para style="HEADER">Liquidación de Aduana</para> | ||
965 | 124 | <section> | ||
966 | 125 | <blockTable colWidths="23.0, 40.0" style="HEADER-BOOK-TABLE"> | ||
967 | 126 | <tr> | ||
968 | 127 | <td><para style="HEADER">Fecha Nac.</para></td> | ||
969 | 128 | <td><para style="HEADER">Declaración</para></td> | ||
970 | 129 | </tr> | ||
971 | 130 | </blockTable> | ||
972 | 131 | </section> | ||
973 | 132 | </td> | ||
974 | 133 | </tr> | ||
975 | 134 | </blockTable> | ||
976 | 135 | </td> | ||
977 | 136 | </tr> | ||
978 | 137 | </blockTable> | ||
979 | 138 | </td> | ||
980 | 139 | <td> | ||
981 | 140 | <blockTable colWidths="37.0" style="HEADER-BOOK-TABLE"> | ||
982 | 141 | <tr> | ||
983 | 142 | <td vAlign="MIDDLE"><para style="HEADER">TOTALES</para></td> | ||
984 | 143 | </tr> | ||
985 | 144 | <tr> | ||
986 | 145 | <td> | ||
987 | 146 | <blockTable colWidths="37.0" style="HEADER-BOOK-TABLE" rowHeights="12"> | ||
988 | 147 | <tr> | ||
989 | 148 | <td vAlign="MIDDLE"><para style="HEADER">Total con IVA</para></td> | ||
990 | 149 | </tr> | ||
991 | 150 | </blockTable> | ||
992 | 151 | </td> | ||
993 | 152 | </tr> | ||
994 | 153 | </blockTable> | ||
995 | 154 | </td> | ||
996 | 155 | <td> | ||
997 | 156 | <blockTable colWidths="310.0" style="HEADER-BOOK-TABLE"> | ||
998 | 157 | <tr> | ||
999 | 158 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES DE IMPORTACIONES</para></td> | ||
1000 | 159 | </tr> | ||
1001 | 160 | <tr> | ||
1002 | 161 | <td> | ||
1003 | 162 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="HEADER-BOOK-TABLE"> | ||
1004 | 163 | <tr> | ||
1005 | 164 | <td> | ||
1006 | 165 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
1007 | 166 | <tr> | ||
1008 | 167 | <td><para style="HEADER">No Gravado</para></td> | ||
1009 | 168 | </tr> | ||
1010 | 169 | <tr> | ||
1011 | 170 | <td> | ||
1012 | 171 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE"> | ||
1013 | 172 | <tr> | ||
1014 | 173 | <td><para style="HEADER">SDCF</para></td> | ||
1015 | 174 | <td><para style="HEADER">Exento</para></td> | ||
1016 | 175 | </tr> | ||
1017 | 176 | </blockTable> | ||
1018 | 177 | </td> | ||
1019 | 178 | </tr> | ||
1020 | 179 | </blockTable> | ||
1021 | 180 | </td> | ||
1022 | 181 | <td> | ||
1023 | 182 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1024 | 183 | <tr> | ||
1025 | 184 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota General</para></td> | ||
1026 | 185 | </tr> | ||
1027 | 186 | <tr> | ||
1028 | 187 | <td> | ||
1029 | 188 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1030 | 189 | <tr> | ||
1031 | 190 | <td><para style="HEADER">Base Imponible</para></td> | ||
1032 | 191 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1033 | 192 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1034 | 193 | </tr> | ||
1035 | 194 | </blockTable> | ||
1036 | 195 | </td> | ||
1037 | 196 | </tr> | ||
1038 | 197 | </blockTable> | ||
1039 | 198 | </td> | ||
1040 | 199 | <td> | ||
1041 | 200 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1042 | 201 | <tr> | ||
1043 | 202 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1044 | 203 | </tr> | ||
1045 | 204 | <tr> | ||
1046 | 205 | <td> | ||
1047 | 206 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1048 | 207 | <tr> | ||
1049 | 208 | <td><para style="HEADER">Base Imponible</para></td> | ||
1050 | 209 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1051 | 210 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1052 | 211 | </tr> | ||
1053 | 212 | </blockTable> | ||
1054 | 213 | </td> | ||
1055 | 214 | </tr> | ||
1056 | 215 | </blockTable> | ||
1057 | 216 | </td> | ||
1058 | 217 | <td> | ||
1059 | 218 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1060 | 219 | <tr> | ||
1061 | 220 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1062 | 221 | </tr> | ||
1063 | 222 | <tr> | ||
1064 | 223 | <td> | ||
1065 | 224 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1066 | 225 | <tr> | ||
1067 | 226 | <td><para style="HEADER">Base Imponible</para></td> | ||
1068 | 227 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1069 | 228 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1070 | 229 | </tr> | ||
1071 | 230 | </blockTable> | ||
1072 | 231 | </td> | ||
1073 | 232 | </tr> | ||
1074 | 233 | </blockTable> | ||
1075 | 234 | </td> | ||
1076 | 235 | </tr> | ||
1077 | 236 | </blockTable> | ||
1078 | 237 | </td> | ||
1079 | 238 | </tr> | ||
1080 | 239 | </blockTable> | ||
1081 | 240 | </td> | ||
1082 | 241 | <td> | ||
1083 | 242 | <blockTable colWidths="485.0" style="HEADER-BOOK-TABLE"> | ||
1084 | 243 | <tr> | ||
1085 | 244 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES EN EL MERCADO INTERNO</para></td> | ||
1086 | 245 | </tr> | ||
1087 | 246 | <tr> | ||
1088 | 247 | <td> | ||
1089 | 248 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0, 175.0" style="HEADER-BOOK-TABLE"> | ||
1090 | 249 | <tr> | ||
1091 | 250 | <td> | ||
1092 | 251 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
1093 | 252 | <tr> | ||
1094 | 253 | <td><para style="HEADER">No Gravado</para></td> | ||
1095 | 254 | </tr> | ||
1096 | 255 | <tr> | ||
1097 | 256 | <td> | ||
1098 | 257 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE"> | ||
1099 | 258 | <tr> | ||
1100 | 259 | <td><para style="HEADER">SDCF</para></td> | ||
1101 | 260 | <td><para style="HEADER">Exento</para></td> | ||
1102 | 261 | </tr> | ||
1103 | 262 | </blockTable> | ||
1104 | 263 | </td> | ||
1105 | 264 | </tr> | ||
1106 | 265 | </blockTable> | ||
1107 | 266 | </td> | ||
1108 | 267 | <td> | ||
1109 | 268 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1110 | 269 | <tr> | ||
1111 | 270 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota General</para></td> | ||
1112 | 271 | </tr> | ||
1113 | 272 | <tr> | ||
1114 | 273 | <td> | ||
1115 | 274 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1116 | 275 | <tr> | ||
1117 | 276 | <td><para style="HEADER">Base Imponible</para></td> | ||
1118 | 277 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1119 | 278 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1120 | 279 | </tr> | ||
1121 | 280 | </blockTable> | ||
1122 | 281 | </td> | ||
1123 | 282 | </tr> | ||
1124 | 283 | </blockTable> | ||
1125 | 284 | </td> | ||
1126 | 285 | <td> | ||
1127 | 286 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1128 | 287 | <tr> | ||
1129 | 288 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1130 | 289 | </tr> | ||
1131 | 290 | <tr> | ||
1132 | 291 | <td> | ||
1133 | 292 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1134 | 293 | <tr> | ||
1135 | 294 | <td><para style="HEADER">Base Imponible</para></td> | ||
1136 | 295 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1137 | 296 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1138 | 297 | </tr> | ||
1139 | 298 | </blockTable> | ||
1140 | 299 | </td> | ||
1141 | 300 | </tr> | ||
1142 | 301 | </blockTable> | ||
1143 | 302 | </td> | ||
1144 | 303 | <td> | ||
1145 | 304 | <blockTable colWidths="90.0" style="HEADER-BOOK-TABLE"> | ||
1146 | 305 | <tr> | ||
1147 | 306 | <td><para style="HEADER">Compras o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1148 | 307 | </tr> | ||
1149 | 308 | <tr> | ||
1150 | 309 | <td> | ||
1151 | 310 | <blockTable colWidths="35.0, 20.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1152 | 311 | <tr> | ||
1153 | 312 | <td><para style="HEADER">Base Imponible</para></td> | ||
1154 | 313 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1155 | 314 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1156 | 315 | </tr> | ||
1157 | 316 | </blockTable> | ||
1158 | 317 | </td> | ||
1159 | 318 | </tr> | ||
1160 | 319 | </blockTable> | ||
1161 | 320 | </td> | ||
1162 | 321 | <td> | ||
1163 | 322 | <blockTable colWidths="175.0" style="HEADER-BOOK-TABLE"> | ||
1164 | 323 | <tr> | ||
1165 | 324 | <td><para style="HEADER">Retenciones</para></td> | ||
1166 | 325 | </tr> | ||
1167 | 326 | <tr> | ||
1168 | 327 | <td> | ||
1169 | 328 | <blockTable colWidths="35.0, 35.0, 35.0, 35.0, 35.0" style="HEADER-BOOK-TABLE"> | ||
1170 | 329 | <tr> | ||
1171 | 330 | <td><para style="HEADER">Fecha Factura Afect.</para></td> | ||
1172 | 331 | <td><para style="HEADER">Nro Retención</para></td> | ||
1173 | 332 | <td><para style="HEADER">Débito Fiscal Base</para></td> | ||
1174 | 333 | <td><para style="HEADER">Retención %</para></td> | ||
1175 | 334 | <td><para style="HEADER">Monto Retenido</para></td> | ||
1176 | 335 | </tr> | ||
1177 | 336 | </blockTable> | ||
1178 | 337 | </td> | ||
1179 | 338 | </tr> | ||
1180 | 339 | </blockTable> | ||
1181 | 340 | </td> | ||
1182 | 341 | </tr> | ||
1183 | 342 | </blockTable> | ||
1184 | 343 | </td> | ||
1185 | 344 | </tr> | ||
1186 | 345 | </blockTable> | ||
1187 | 346 | </td> | ||
1188 | 347 | </tr> | ||
1189 | 348 | </blockTable> | ||
1190 | 349 | </section> | ||
1191 | 350 | |||
1192 | 351 | <!-- PURCHASE BOOK LINES --> | 362 | <!-- PURCHASE BOOK LINES --> |
1193 | 352 | <section> | 363 | <section> |
1194 | 353 | <para>[[repeatIn( my_fb.fbl_ids,'my_fbl')]]</para> | 364 | <para>[[repeatIn( my_fb.fbl_ids,'my_fbl')]]</para> |
1195 | @@ -477,7 +488,7 @@ | |||
1196 | 477 | <blockTable colWidths="70mm,40mm" style="SUMMARY-TABLE" repeatRows="2"> | 488 | <blockTable colWidths="70mm,40mm" style="SUMMARY-TABLE" repeatRows="2"> |
1197 | 478 | <tr> | 489 | <tr> |
1198 | 479 | <td><para style="HEADER">[['RESUMEN RETENCIONES']]</para></td> | 490 | <td><para style="HEADER">[['RESUMEN RETENCIONES']]</para></td> |
1200 | 480 | <td><para style="HEADER">RET. DEBITO FISCAL</para></td> | 491 | <td><para style="HEADER">RET. CRÉDITO FISCAL</para></td> |
1201 | 481 | </tr> | 492 | </tr> |
1202 | 482 | <tr> | 493 | <tr> |
1203 | 483 | <td><para style="CONTENIDOLEFT">[['RETENCIONES PERIODOS ANTERIORES']]</para></td> | 494 | <td><para style="CONTENIDOLEFT">[['RETENCIONES PERIODOS ANTERIORES']]</para></td> |
1204 | @@ -502,7 +513,7 @@ | |||
1205 | 502 | <tr> | 513 | <tr> |
1206 | 503 | <td><para style="HEADER">RESUMEN</para></td> | 514 | <td><para style="HEADER">RESUMEN</para></td> |
1207 | 504 | <td><para style="HEADER">BASE IMPONIBLE</para></td> | 515 | <td><para style="HEADER">BASE IMPONIBLE</para></td> |
1209 | 505 | <td><para style="HEADER">DEBITO FISCAL</para></td> | 516 | <td><para style="HEADER">CRÉDITO FISCAL</para></td> |
1210 | 506 | </tr> | 517 | </tr> |
1211 | 507 | <tr> | 518 | <tr> |
1212 | 508 | <td><para style="HEADERLEFT">IMPORTACIONES NO GRAVADAS Y/O SIN DERECHO A CREDITO FISCAL</para></td> | 519 | <td><para style="HEADERLEFT">IMPORTACIONES NO GRAVADAS Y/O SIN DERECHO A CREDITO FISCAL</para></td> |
1213 | @@ -546,26 +557,13 @@ | |||
1214 | 546 | <td><para style="HEADER">[[ formatLang(my_fb.do_reduced_vat_tax_sum or 0.0) ]]</para></td> | 557 | <td><para style="HEADER">[[ formatLang(my_fb.do_reduced_vat_tax_sum or 0.0) ]]</para></td> |
1215 | 547 | </tr> | 558 | </tr> |
1216 | 548 | <tr> | 559 | <tr> |
1218 | 549 | <td><para style="CONTENIDOLEFT_BOLD">TOTAL VENTAS Y DEBITOS FISCAL PARA EFECTOS DE DETERMINACION</para></td> | 560 | <td><para style="CONTENIDOLEFT_BOLD">TOTAL COMPRAS Y CRÉDITOS FISCAL PARA EFECTOS DE DETERMINACION</para></td> |
1219 | 550 | <td><para style="HEADER">[[ formatLang(my_fb.get_total_tax_credit_debit_base_sum or 0.0) ]]</para></td> | 561 | <td><para style="HEADER">[[ formatLang(my_fb.get_total_tax_credit_debit_base_sum or 0.0) ]]</para></td> |
1220 | 551 | <td><para style="HEADER">[[ formatLang(my_fb.get_total_tax_credit_debit_tax_sum or 0.0) ]]</para></td> | 562 | <td><para style="HEADER">[[ formatLang(my_fb.get_total_tax_credit_debit_tax_sum or 0.0) ]]</para></td> |
1221 | 552 | </tr> | 563 | </tr> |
1222 | 553 | </blockTable> | 564 | </blockTable> |
1223 | 554 | </section> | 565 | </section> |
1224 | 555 | 566 | ||
1225 | 556 | <!-- | ||
1226 | 557 | <blockTable colWidths="110.0" style="INTERNALTABLE"> | ||
1227 | 558 | <tr> | ||
1228 | 559 | <td vAlign="MIDDLE"> | ||
1229 | 560 | <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable') ]]</para> | ||
1230 | 561 | <nextPage/> | ||
1231 | 562 | OJO AQUI el next page estaba comentado. | ||
1232 | 563 | </td> | ||
1233 | 564 | </tr> | ||
1234 | 565 | </blockTable> | ||
1235 | 566 | |||
1236 | 567 | --> | ||
1237 | 568 | |||
1238 | 569 | </section> | 567 | </section> |
1239 | 570 | </story> | 568 | </story> |
1240 | 571 | </document> | 569 | </document> |
1241 | 572 | 570 | ||
1242 | === modified file 'l10n_ve_fiscal_book/report/fiscal_book_sale_report.rml' | |||
1243 | --- l10n_ve_fiscal_book/report/fiscal_book_sale_report.rml 2013-05-20 18:33:19 +0000 | |||
1244 | +++ l10n_ve_fiscal_book/report/fiscal_book_sale_report.rml 2013-05-27 21:01:40 +0000 | |||
1245 | @@ -1,21 +1,376 @@ | |||
1246 | 1 | <?xml version="1.0"?> | 1 | <?xml version="1.0"?> |
1248 | 2 | <document filename="test.pdf" invariant="1"> | 2 | <document filename="book.pdf" invariant="1"> |
1249 | 3 | <!-- | 3 | <!-- |
1250 | 4 | info: http://www.dpandi.com/paper/ | 4 | info: http://www.dpandi.com/paper/ |
1251 | 5 | Royal Size ( 20 x 25 inches ) | 5 | Royal Size ( 20 x 25 inches ) |
1252 | 6 | A2 Size ( 420 x 594 mm - 16.5 x 23.4 inches ) | 6 | A2 Size ( 420 x 594 mm - 16.5 x 23.4 inches ) |
1253 | 7 | A3 Size ( 297 x 420 mm - 11.7 x 16.5 inches ) | 7 | A3 Size ( 297 x 420 mm - 11.7 x 16.5 inches ) |
1254 | 8 | --> | 8 | --> |
1256 | 9 | <template pageSize="(59.4cm, 42.0cm)" title="Test" author="Katherine Zaoral" allowSplitting="20" showBoundary="0"> | 9 | <template pageSize="(59.4cm, 42.0cm)" title="Fiscal Book" author="Katherine Zaoral" allowSplitting="20" showBoundary="0"> |
1257 | 10 | <pageTemplate id="first"> | 10 | <pageTemplate id="first"> |
1258 | 11 | <pageGraphics> | 11 | <pageGraphics> |
1259 | 12 | |||
1260 | 13 | <!-- PAGE HEADER --> | ||
1261 | 14 | <place x="2cm" y="36.7cm" width="59.4cm" height="3.33cm"> | ||
1262 | 15 | <!-- REPORT HEADER --> | ||
1263 | 16 | <blockTable colWidths="28.81cm, 11.08cm, 15.51cm" style="HEADER-REPORT-TABLE"> | ||
1264 | 17 | <tr> | ||
1265 | 18 | [[ setLang(my_fb.company_id.partner_id.lang) ]] | ||
1266 | 19 | <td> | ||
1267 | 20 | <para style="HEADERDOC">[[ my_fb.company_id.partner_id.name ]] [[ my_fb.company_id.partner_id.vat[2:] ]]</para> | ||
1268 | 21 | <para style="HEADERDOC">[[ my_fb.get_partner_addr ]]</para> | ||
1269 | 22 | </td> | ||
1270 | 23 | <td> | ||
1271 | 24 | <para styleda="HEADERDOC">Libro: Ventas </para> | ||
1272 | 25 | <para style="HEADERDOC">[[ my_fb.get_month_year ]]</para> | ||
1273 | 26 | <para style="HEADERDOC">[[ 'Desde: %s'%formatLang( my_fb.period_id.date_start, date=True) ]]</para> | ||
1274 | 27 | <para style="HEADERDOC">[[ 'Hasta: %s'%formatLang( my_fb.period_id.date_stop, date=True) ]]</para> | ||
1275 | 28 | </td> | ||
1276 | 29 | <td> | ||
1277 | 30 | <para style="HEADERDOC" fontName="Times-Roman">Según Articulo 76 del Reglamento de la Ley del IVA No. 5.363 del 12 de Julio de 1999</para> | ||
1278 | 31 | <para style="POPINFO">[[ my_fb.state == 'draft' and 'GETTING READY' or my_fb.state == 'confirmed' and 'APPROVED BY MANAGER' or my_fb.state == 'done' and '' ]]</para> | ||
1279 | 32 | </td> | ||
1280 | 33 | </tr> | ||
1281 | 34 | </blockTable> | ||
1282 | 35 | <spacer length="0.5cm"/> | ||
1283 | 36 | </place> | ||
1284 | 37 | |||
1285 | 38 | <place x="6.6cm" y="34.5cm" width="59.4cm" height="3.33cm"> | ||
1286 | 39 | <!-- SALE BOOK HEADERS --> | ||
1287 | 40 | <blockTable colWidths="375.0, 37.0, 103.0, 795.0" style="NEW-HEADER" blockAlignment="LEFT"> | ||
1288 | 41 | <tr> | ||
1289 | 42 | <td> | ||
1290 | 43 | <blockTable colWidths="375.0" style="NEW-HEADER"> | ||
1291 | 44 | <tr> | ||
1292 | 45 | <td vAlign="MIDDLE"><para style="HEADER">DATOS DE LA FACTURA O/Y DOCUMENTO</para></td> | ||
1293 | 46 | </tr> | ||
1294 | 47 | <tr> | ||
1295 | 48 | <td> | ||
1296 | 49 | <blockTable colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 72.0, 23.0, 130.0, 25.0" style="NEW-HEADER" rowHeights="18"> | ||
1297 | 50 | <tr> | ||
1298 | 51 | <td vAlign="MIDDLE"><para style="HEADER">Linea</para></td> | ||
1299 | 52 | <td vAlign="MIDDLE"><para style="HEADER">T. Doc.</para></td> | ||
1300 | 53 | <td vAlign="MIDDLE"><para style="HEADER">Fecha Doc.</para></td> | ||
1301 | 54 | <td vAlign="MIDDLE"><para style="HEADER">Numero Control</para></td> | ||
1302 | 55 | <td vAlign="MIDDLE"><para style="HEADER">Numero de Documento</para></td> | ||
1303 | 56 | |||
1304 | 57 | <td> | ||
1305 | 58 | <blockTable colWidths="72.0" style="NEW-HEADER"> | ||
1306 | 59 | <tr> | ||
1307 | 60 | <td vAlign="MIDDLE"><para style="HEADER">Impresora Fiscal</para></td> | ||
1308 | 61 | </tr> | ||
1309 | 62 | <tr> | ||
1310 | 63 | <td> | ||
1311 | 64 | <blockTable colWidths="36.0, 36.0" style="NEW-HEADER" rowHeights="12"> | ||
1312 | 65 | <tr> | ||
1313 | 66 | <td vAlign="MIDDLE"><para style="HEADER">Numero Impresora</para></td> | ||
1314 | 67 | <td vAlign="MIDDLE"><para style="HEADER">Reporte Z</para></td> | ||
1315 | 68 | </tr> | ||
1316 | 69 | </blockTable> | ||
1317 | 70 | </td> | ||
1318 | 71 | </tr> | ||
1319 | 72 | </blockTable> | ||
1320 | 73 | </td> | ||
1321 | 74 | |||
1322 | 75 | <td vAlign="MIDDLE"><para style="HEADER">Factura Afectada</para></td> | ||
1323 | 76 | <td vAlign="MIDDLE"><para style="HEADER">Razon Social</para></td> | ||
1324 | 77 | <td vAlign="MIDDLE"><para style="HEADER">RIF</para></td> | ||
1325 | 78 | </tr> | ||
1326 | 79 | </blockTable> | ||
1327 | 80 | </td> | ||
1328 | 81 | </tr> | ||
1329 | 82 | </blockTable> | ||
1330 | 83 | </td> | ||
1331 | 84 | <td> | ||
1332 | 85 | <blockTable colWidths="37.0" style="NEW-HEADER"> | ||
1333 | 86 | <tr> | ||
1334 | 87 | <td vAlign="MIDDLE"><para style="HEADER">TOTALES</para></td> | ||
1335 | 88 | </tr> | ||
1336 | 89 | <tr> | ||
1337 | 90 | <td> | ||
1338 | 91 | <blockTable colWidths="37.0" style="NEW-HEADER" rowHeights="18"> | ||
1339 | 92 | <tr> | ||
1340 | 93 | <td vAlign="MIDDLE"><para style="HEADER">Total con IVA</para></td> | ||
1341 | 94 | </tr> | ||
1342 | 95 | </blockTable> | ||
1343 | 96 | </td> | ||
1344 | 97 | </tr> | ||
1345 | 98 | </blockTable> | ||
1346 | 99 | </td> | ||
1347 | 100 | <td> | ||
1348 | 101 | <blockTable colWidths="103.0" style="NEW-HEADER"> | ||
1349 | 102 | <tr> | ||
1350 | 103 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES DE EXPORTACION</para></td> | ||
1351 | 104 | </tr> | ||
1352 | 105 | <tr> | ||
1353 | 106 | <td> | ||
1354 | 107 | <blockTable colWidths="63.0, 40.0" style="NEW-HEADER" rowHeights="18"> | ||
1355 | 108 | <tr> | ||
1356 | 109 | <td> | ||
1357 | 110 | <blockTable colWidths="63.0" style="NEW-HEADER"> | ||
1358 | 111 | <tr> | ||
1359 | 112 | <td vAlign="MIDDLE"><para style="HEADER">Datos Generales de Aduana</para></td> | ||
1360 | 113 | </tr> | ||
1361 | 114 | <tr> | ||
1362 | 115 | <td> | ||
1363 | 116 | <blockTable colWidths="23.0, 40.0" style="NEW-HEADER" rowHeights="12"> | ||
1364 | 117 | <tr> | ||
1365 | 118 | <td><para style="HEADER">Fecha</para></td> | ||
1366 | 119 | <td><para style="HEADER">Declaración</para></td> | ||
1367 | 120 | </tr> | ||
1368 | 121 | </blockTable> | ||
1369 | 122 | </td> | ||
1370 | 123 | </tr> | ||
1371 | 124 | </blockTable> | ||
1372 | 125 | </td> | ||
1373 | 126 | <td> | ||
1374 | 127 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
1375 | 128 | <tr> | ||
1376 | 129 | <td><para style="HEADER">No Gravado</para></td> | ||
1377 | 130 | </tr> | ||
1378 | 131 | <tr> | ||
1379 | 132 | <td> | ||
1380 | 133 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE" rowHeights="12"> | ||
1381 | 134 | <tr> | ||
1382 | 135 | <td><para style="HEADER">SDCF</para></td> | ||
1383 | 136 | <td><para style="HEADER">Exento</para></td> | ||
1384 | 137 | </tr> | ||
1385 | 138 | </blockTable> | ||
1386 | 139 | </td> | ||
1387 | 140 | </tr> | ||
1388 | 141 | </blockTable> | ||
1389 | 142 | </td> | ||
1390 | 143 | </tr> | ||
1391 | 144 | </blockTable> | ||
1392 | 145 | </td> | ||
1393 | 146 | </tr> | ||
1394 | 147 | </blockTable> | ||
1395 | 148 | </td> | ||
1396 | 149 | <td> | ||
1397 | 150 | <blockTable colWidths="795.0" style="NEW-HEADER"> | ||
1398 | 151 | <tr> | ||
1399 | 152 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES EN EL MERCADO INTERNO</para></td> | ||
1400 | 153 | </tr> | ||
1401 | 154 | <tr> | ||
1402 | 155 | <td> | ||
1403 | 156 | <blockTable colWidths="310.0, 310.0, 175.0" style="NEW-HEADER"> | ||
1404 | 157 | <tr> | ||
1405 | 158 | <td> | ||
1406 | 159 | <blockTable colWidths="310.0" style="NEW-HEADER"> | ||
1407 | 160 | <tr> | ||
1408 | 161 | <td vAlign="MIDDLE"><para style="HEADER">Contribuyente</para></td> | ||
1409 | 162 | </tr> | ||
1410 | 163 | <tr> | ||
1411 | 164 | <td> | ||
1412 | 165 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="NEW-HEADER"> | ||
1413 | 166 | <tr> | ||
1414 | 167 | <td> | ||
1415 | 168 | <blockTable colWidths="40.0" style="NEW-HEADER"> | ||
1416 | 169 | <tr> | ||
1417 | 170 | <td><para style="HEADER">No Gravado</para></td> | ||
1418 | 171 | </tr> | ||
1419 | 172 | <tr> | ||
1420 | 173 | <td> | ||
1421 | 174 | <blockTable colWidths="20.0, 20.0" style="NEW-HEADER"> | ||
1422 | 175 | <tr> | ||
1423 | 176 | <td><para style="HEADER">SDCF</para></td> | ||
1424 | 177 | <td><para style="HEADER">Exento</para></td> | ||
1425 | 178 | </tr> | ||
1426 | 179 | </blockTable> | ||
1427 | 180 | </td> | ||
1428 | 181 | </tr> | ||
1429 | 182 | </blockTable> | ||
1430 | 183 | </td> | ||
1431 | 184 | <td> | ||
1432 | 185 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1433 | 186 | <tr> | ||
1434 | 187 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota General</para></td> | ||
1435 | 188 | </tr> | ||
1436 | 189 | <tr> | ||
1437 | 190 | <td> | ||
1438 | 191 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1439 | 192 | <tr> | ||
1440 | 193 | <td><para style="HEADER">Base Imponible</para></td> | ||
1441 | 194 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1442 | 195 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1443 | 196 | </tr> | ||
1444 | 197 | </blockTable> | ||
1445 | 198 | </td> | ||
1446 | 199 | </tr> | ||
1447 | 200 | </blockTable> | ||
1448 | 201 | </td> | ||
1449 | 202 | <td> | ||
1450 | 203 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1451 | 204 | <tr> | ||
1452 | 205 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1453 | 206 | </tr> | ||
1454 | 207 | <tr> | ||
1455 | 208 | <td> | ||
1456 | 209 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1457 | 210 | <tr> | ||
1458 | 211 | <td><para style="HEADER">Base Imponible</para></td> | ||
1459 | 212 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1460 | 213 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1461 | 214 | </tr> | ||
1462 | 215 | </blockTable> | ||
1463 | 216 | </td> | ||
1464 | 217 | </tr> | ||
1465 | 218 | </blockTable> | ||
1466 | 219 | </td> | ||
1467 | 220 | <td> | ||
1468 | 221 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1469 | 222 | <tr> | ||
1470 | 223 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1471 | 224 | </tr> | ||
1472 | 225 | <tr> | ||
1473 | 226 | <td> | ||
1474 | 227 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1475 | 228 | <tr> | ||
1476 | 229 | <td><para style="HEADER">Base Imponible</para></td> | ||
1477 | 230 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1478 | 231 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1479 | 232 | </tr> | ||
1480 | 233 | </blockTable> | ||
1481 | 234 | </td> | ||
1482 | 235 | </tr> | ||
1483 | 236 | </blockTable> | ||
1484 | 237 | </td> | ||
1485 | 238 | </tr> | ||
1486 | 239 | </blockTable> | ||
1487 | 240 | </td> | ||
1488 | 241 | </tr> | ||
1489 | 242 | </blockTable> | ||
1490 | 243 | </td> | ||
1491 | 244 | |||
1492 | 245 | <td> | ||
1493 | 246 | <blockTable colWidths="310.0" style="NEW-HEADER"> | ||
1494 | 247 | <tr> | ||
1495 | 248 | <td vAlign="MIDDLE"><para style="HEADER">No Contribuyente</para></td> | ||
1496 | 249 | </tr> | ||
1497 | 250 | <tr> | ||
1498 | 251 | <td> | ||
1499 | 252 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="NEW-HEADER"> | ||
1500 | 253 | <tr> | ||
1501 | 254 | <td> | ||
1502 | 255 | <blockTable colWidths="40.0" style="NEW-HEADER"> | ||
1503 | 256 | <tr> | ||
1504 | 257 | <td><para style="HEADER">No Gravado</para></td> | ||
1505 | 258 | </tr> | ||
1506 | 259 | <tr> | ||
1507 | 260 | <td> | ||
1508 | 261 | <blockTable colWidths="20.0, 20.0" style="NEW-HEADER"> | ||
1509 | 262 | <tr> | ||
1510 | 263 | <td><para style="HEADER">SDCF</para></td> | ||
1511 | 264 | <td><para style="HEADER">Exento</para></td> | ||
1512 | 265 | </tr> | ||
1513 | 266 | </blockTable> | ||
1514 | 267 | </td> | ||
1515 | 268 | </tr> | ||
1516 | 269 | </blockTable> | ||
1517 | 270 | </td> | ||
1518 | 271 | <td> | ||
1519 | 272 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1520 | 273 | <tr> | ||
1521 | 274 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota General</para></td> | ||
1522 | 275 | </tr> | ||
1523 | 276 | <tr> | ||
1524 | 277 | <td> | ||
1525 | 278 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1526 | 279 | <tr> | ||
1527 | 280 | <td><para style="HEADER">Base Imponible</para></td> | ||
1528 | 281 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1529 | 282 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1530 | 283 | </tr> | ||
1531 | 284 | </blockTable> | ||
1532 | 285 | </td> | ||
1533 | 286 | </tr> | ||
1534 | 287 | </blockTable> | ||
1535 | 288 | </td> | ||
1536 | 289 | <td> | ||
1537 | 290 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1538 | 291 | <tr> | ||
1539 | 292 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1540 | 293 | </tr> | ||
1541 | 294 | <tr> | ||
1542 | 295 | <td> | ||
1543 | 296 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1544 | 297 | <tr> | ||
1545 | 298 | <td><para style="HEADER">Base Imponible</para></td> | ||
1546 | 299 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1547 | 300 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1548 | 301 | </tr> | ||
1549 | 302 | </blockTable> | ||
1550 | 303 | </td> | ||
1551 | 304 | </tr> | ||
1552 | 305 | </blockTable> | ||
1553 | 306 | </td> | ||
1554 | 307 | <td> | ||
1555 | 308 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1556 | 309 | <tr> | ||
1557 | 310 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1558 | 311 | </tr> | ||
1559 | 312 | <tr> | ||
1560 | 313 | <td> | ||
1561 | 314 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1562 | 315 | <tr> | ||
1563 | 316 | <td><para style="HEADER">Base Imponible</para></td> | ||
1564 | 317 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1565 | 318 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1566 | 319 | </tr> | ||
1567 | 320 | </blockTable> | ||
1568 | 321 | </td> | ||
1569 | 322 | </tr> | ||
1570 | 323 | </blockTable> | ||
1571 | 324 | </td> | ||
1572 | 325 | </tr> | ||
1573 | 326 | </blockTable> | ||
1574 | 327 | </td> | ||
1575 | 328 | </tr> | ||
1576 | 329 | </blockTable> | ||
1577 | 330 | </td> | ||
1578 | 331 | |||
1579 | 332 | <td> | ||
1580 | 333 | <blockTable colWidths="175.0" style="NEW-HEADER"> | ||
1581 | 334 | <tr> | ||
1582 | 335 | <td><para style="HEADER">Retenciones</para></td> | ||
1583 | 336 | </tr> | ||
1584 | 337 | <tr> | ||
1585 | 338 | <td> | ||
1586 | 339 | <blockTable colWidths="35.0, 35.0, 35.0, 35.0, 35.0" style="NEW-HEADER" rowHeights="12.0"> | ||
1587 | 340 | <tr> | ||
1588 | 341 | <td><para style="HEADER">Fecha de Factura Afectada</para></td> | ||
1589 | 342 | <td><para style="HEADER">Nro Retención</para></td> | ||
1590 | 343 | <td><para style="HEADER">Débito Fiscal Base</para></td> | ||
1591 | 344 | <td><para style="HEADER">Retención %</para></td> | ||
1592 | 345 | <td><para style="HEADER">Monto Retenido</para></td> | ||
1593 | 346 | </tr> | ||
1594 | 347 | </blockTable> | ||
1595 | 348 | </td> | ||
1596 | 349 | </tr> | ||
1597 | 350 | </blockTable> | ||
1598 | 351 | </td> | ||
1599 | 352 | </tr> | ||
1600 | 353 | </blockTable> | ||
1601 | 354 | </td> | ||
1602 | 355 | </tr> | ||
1603 | 356 | </blockTable> | ||
1604 | 357 | </td> | ||
1605 | 358 | </tr> | ||
1606 | 359 | </blockTable> | ||
1607 | 360 | |||
1608 | 361 | </place> | ||
1609 | 362 | |||
1610 | 363 | <!-- PAGE FOOTER --> | ||
1611 | 12 | <setFont name="Times-Roman" size="10"/> | 364 | <setFont name="Times-Roman" size="10"/> |
1612 | 13 | <drawString x="2.5cm" y="2.5cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString> | 365 | <drawString x="2.5cm" y="2.5cm"> [[ formatLang(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),date_time = True) ]]</drawString> |
1613 | 14 | <drawString x="55cm" y="2.5cm">Pagina <pageNumber/></drawString> | 366 | <drawString x="55cm" y="2.5cm">Pagina <pageNumber/></drawString> |
1614 | 15 | <lineMode width="0.7"/> | 367 | <lineMode width="0.7"/> |
1615 | 368 | <setFont name="Times-Roman" size="8"/> | ||
1616 | 369 | <drawString x="25cm" y="2.5cm"> Printed in Report Lab using OpenERP</drawString> | ||
1617 | 16 | <lines>2.0cm 3.0cm 57.4cm 3.0cm</lines> | 370 | <lines>2.0cm 3.0cm 57.4cm 3.0cm</lines> |
1618 | 371 | |||
1619 | 17 | </pageGraphics> | 372 | </pageGraphics> |
1621 | 18 | <frame id="first" x1="2.0cm" y1="2.0cm" width="55.4cm" height="38.0cm"/> | 373 | <frame id="first" x1="2.0cm" y1="3.5cm" width="55.4cm" height="33.7cm"/> |
1622 | 19 | </pageTemplate> | 374 | </pageTemplate> |
1623 | 20 | </template> | 375 | </template> |
1624 | 21 | 376 | ||
1625 | @@ -131,6 +486,7 @@ | |||
1626 | 131 | <paraStyle name="Index" fontName="Times-Roman"/> | 486 | <paraStyle name="Index" fontName="Times-Roman"/> |
1627 | 132 | <paraStyle name="Table Contents" fontName="Times-Roman"/> | 487 | <paraStyle name="Table Contents" fontName="Times-Roman"/> |
1628 | 133 | <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/> | 488 | <paraStyle name="Table Heading" fontName="Times-Roman" alignment="CENTER"/> |
1629 | 489 | <paraStyle name="POPINFO" fontName="Times-Bold" fontSize="18.0" textColor="red" leading="6" alignment="LEFT"/> | ||
1630 | 134 | 490 | ||
1631 | 135 | <blockTableStyle id="NEW-HEADER"> | 491 | <blockTableStyle id="NEW-HEADER"> |
1632 | 136 | <lineStyle kind="GRID" colorName="black"/> | 492 | <lineStyle kind="GRID" colorName="black"/> |
1633 | @@ -162,412 +518,13 @@ | |||
1634 | 162 | <section> | 518 | <section> |
1635 | 163 | <para>[[repeatIn( objects ,'my_fb')]]</para> | 519 | <para>[[repeatIn( objects ,'my_fb')]]</para> |
1636 | 164 | 520 | ||
1637 | 165 | <!-- REPORT HEADER --> | ||
1638 | 166 | <blockTable colWidths="28.81cm,11.08cm,15.51cm" style="HEADER-REPORT-TABLE"> | ||
1639 | 167 | <tr> | ||
1640 | 168 | [[ setLang(my_fb.company_id.partner_id.lang) ]] | ||
1641 | 169 | <td> | ||
1642 | 170 | <para style="HEADERDOC">[[ company.partner_id.name ]] [[ company.partner_id.vat[2:] ]]</para> | ||
1643 | 171 | <para style="HEADERDOC">[[ my_fb.get_partner_addr ]]</para> | ||
1644 | 172 | </td> | ||
1645 | 173 | <td> | ||
1646 | 174 | <para styleda="HEADERDOC">Libro: Ventas </para> | ||
1647 | 175 | <para style="HEADERDOC">[[ my_fb.get_month_year ]]</para> | ||
1648 | 176 | <para style="HEADERDOC">[[ 'Desde: %s'%formatLang( my_fb.period_id.date_start, date=True) ]]</para> | ||
1649 | 177 | <para style="HEADERDOC">[[ 'Hasta: %s'%formatLang( my_fb.period_id.date_stop, date=True) ]]</para> | ||
1650 | 178 | </td> | ||
1651 | 179 | <td> | ||
1652 | 180 | <para style="HEADERDOC" fontName="Times-Roman">Según Articulo 76 del Reglamento de la Ley del IVA No. 5.363 del 12 de Julio de 1999</para> | ||
1653 | 181 | </td> | ||
1654 | 182 | </tr> | ||
1655 | 183 | </blockTable> | ||
1656 | 184 | <spacer length="10mm"/> | ||
1657 | 185 | |||
1658 | 186 | <!-- SALE BOOK HEADERS --> | ||
1659 | 187 | <section> | ||
1660 | 188 | <blockTable colWidths="375.0, 37.0, 373.0, 795.0" style="NEW-HEADER" blockAlignment="LEFT"> | ||
1661 | 189 | <tr> | ||
1662 | 190 | <td> | ||
1663 | 191 | <blockTable colWidths="375.0" style="NEW-HEADER"> | ||
1664 | 192 | <tr> | ||
1665 | 193 | <td vAlign="MIDDLE"><para style="HEADER">DATOS DE LA FACTURA O/Y DOCUMENTO</para></td> | ||
1666 | 194 | </tr> | ||
1667 | 195 | <tr> | ||
1668 | 196 | <td> | ||
1669 | 197 | <blockTable colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 72.0, 23.0, 130.0, 25.0" style="NEW-HEADER" rowHeights="18"> | ||
1670 | 198 | <tr> | ||
1671 | 199 | <td vAlign="MIDDLE"><para style="HEADER">Linea</para></td> | ||
1672 | 200 | <td vAlign="MIDDLE"><para style="HEADER">T. Doc.</para></td> | ||
1673 | 201 | <td vAlign="MIDDLE"><para style="HEADER">Fecha Doc.</para></td> | ||
1674 | 202 | <td vAlign="MIDDLE"><para style="HEADER">Numero Control</para></td> | ||
1675 | 203 | <td vAlign="MIDDLE"><para style="HEADER">Numero de Documento</para></td> | ||
1676 | 204 | |||
1677 | 205 | <td> | ||
1678 | 206 | <blockTable colWidths="72.0" style="NEW-HEADER"> | ||
1679 | 207 | <tr> | ||
1680 | 208 | <td vAlign="MIDDLE"><para style="HEADER">Impresora Fiscal</para></td> | ||
1681 | 209 | </tr> | ||
1682 | 210 | <tr> | ||
1683 | 211 | <td> | ||
1684 | 212 | <blockTable colWidths="36.0, 36.0" style="NEW-HEADER" rowHeights="12"> | ||
1685 | 213 | <tr> | ||
1686 | 214 | <td vAlign="MIDDLE"><para style="HEADER">Numero Impresora</para></td> | ||
1687 | 215 | <td vAlign="MIDDLE"><para style="HEADER">Reporte Z</para></td> | ||
1688 | 216 | </tr> | ||
1689 | 217 | </blockTable> | ||
1690 | 218 | </td> | ||
1691 | 219 | </tr> | ||
1692 | 220 | </blockTable> | ||
1693 | 221 | </td> | ||
1694 | 222 | |||
1695 | 223 | <td vAlign="MIDDLE"><para style="HEADER">Factura Afectada</para></td> | ||
1696 | 224 | <td vAlign="MIDDLE"><para style="HEADER">Razon Social</para></td> | ||
1697 | 225 | <td vAlign="MIDDLE"><para style="HEADER">RIF</para></td> | ||
1698 | 226 | </tr> | ||
1699 | 227 | </blockTable> | ||
1700 | 228 | </td> | ||
1701 | 229 | </tr> | ||
1702 | 230 | </blockTable> | ||
1703 | 231 | </td> | ||
1704 | 232 | <td> | ||
1705 | 233 | <blockTable colWidths="37.0" style="NEW-HEADER"> | ||
1706 | 234 | <tr> | ||
1707 | 235 | <td vAlign="MIDDLE"><para style="HEADER">TOTALES</para></td> | ||
1708 | 236 | </tr> | ||
1709 | 237 | <tr> | ||
1710 | 238 | <td> | ||
1711 | 239 | <blockTable colWidths="37.0" style="NEW-HEADER" rowHeights="18"> | ||
1712 | 240 | <tr> | ||
1713 | 241 | <td vAlign="MIDDLE"><para style="HEADER">Total con IVA</para></td> | ||
1714 | 242 | </tr> | ||
1715 | 243 | </blockTable> | ||
1716 | 244 | </td> | ||
1717 | 245 | </tr> | ||
1718 | 246 | </blockTable> | ||
1719 | 247 | </td> | ||
1720 | 248 | <td> | ||
1721 | 249 | <blockTable colWidths="373.0" style="NEW-HEADER"> | ||
1722 | 250 | <tr> | ||
1723 | 251 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES DE EXPORTACION</para></td> | ||
1724 | 252 | </tr> | ||
1725 | 253 | <tr> | ||
1726 | 254 | <td> | ||
1727 | 255 | <blockTable colWidths="63.0, 40.0, 90.0, 90.0, 90.0" style="NEW-HEADER" rowHeights="18"> | ||
1728 | 256 | <tr> | ||
1729 | 257 | <td> | ||
1730 | 258 | <blockTable colWidths="63.0" style="NEW-HEADER"> | ||
1731 | 259 | <tr> | ||
1732 | 260 | <td vAlign="MIDDLE"><para style="HEADER">Datos Generales de Aduana</para></td> | ||
1733 | 261 | </tr> | ||
1734 | 262 | <tr> | ||
1735 | 263 | <td> | ||
1736 | 264 | <blockTable colWidths="23.0, 40.0" style="NEW-HEADER" rowHeights="12"> | ||
1737 | 265 | <tr> | ||
1738 | 266 | <td><para style="HEADER">Fecha</para></td> | ||
1739 | 267 | <td><para style="HEADER">Declaración</para></td> | ||
1740 | 268 | </tr> | ||
1741 | 269 | </blockTable> | ||
1742 | 270 | </td> | ||
1743 | 271 | </tr> | ||
1744 | 272 | </blockTable> | ||
1745 | 273 | </td> | ||
1746 | 274 | <td> | ||
1747 | 275 | <blockTable colWidths="40.0" style="HEADER-BOOK-TABLE"> | ||
1748 | 276 | <tr> | ||
1749 | 277 | <td><para style="HEADER">No Gravado</para></td> | ||
1750 | 278 | </tr> | ||
1751 | 279 | <tr> | ||
1752 | 280 | <td> | ||
1753 | 281 | <blockTable colWidths="20.0, 20.0" style="HEADER-BOOK-TABLE" rowHeights="12"> | ||
1754 | 282 | <tr> | ||
1755 | 283 | <td><para style="HEADER">SDCF</para></td> | ||
1756 | 284 | <td><para style="HEADER">Exento</para></td> | ||
1757 | 285 | </tr> | ||
1758 | 286 | </blockTable> | ||
1759 | 287 | </td> | ||
1760 | 288 | </tr> | ||
1761 | 289 | </blockTable> | ||
1762 | 290 | </td> | ||
1763 | 291 | <td> | ||
1764 | 292 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1765 | 293 | <tr> | ||
1766 | 294 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota General</para></td> | ||
1767 | 295 | </tr> | ||
1768 | 296 | <tr> | ||
1769 | 297 | <td> | ||
1770 | 298 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER" rowHeights="12"> | ||
1771 | 299 | <tr> | ||
1772 | 300 | <td><para style="HEADER">Base Imponible</para></td> | ||
1773 | 301 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1774 | 302 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1775 | 303 | </tr> | ||
1776 | 304 | </blockTable> | ||
1777 | 305 | </td> | ||
1778 | 306 | </tr> | ||
1779 | 307 | </blockTable> | ||
1780 | 308 | </td> | ||
1781 | 309 | <td> | ||
1782 | 310 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1783 | 311 | <tr> | ||
1784 | 312 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1785 | 313 | </tr> | ||
1786 | 314 | <tr> | ||
1787 | 315 | <td> | ||
1788 | 316 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER" rowHeights="12"> | ||
1789 | 317 | <tr> | ||
1790 | 318 | <td><para style="HEADER">Base Imponible</para></td> | ||
1791 | 319 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1792 | 320 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1793 | 321 | </tr> | ||
1794 | 322 | </blockTable> | ||
1795 | 323 | </td> | ||
1796 | 324 | </tr> | ||
1797 | 325 | </blockTable> | ||
1798 | 326 | </td> | ||
1799 | 327 | <td> | ||
1800 | 328 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1801 | 329 | <tr> | ||
1802 | 330 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1803 | 331 | </tr> | ||
1804 | 332 | <tr> | ||
1805 | 333 | <td> | ||
1806 | 334 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER" rowHeights="12"> | ||
1807 | 335 | <tr> | ||
1808 | 336 | <td><para style="HEADER">Base Imponible</para></td> | ||
1809 | 337 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1810 | 338 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1811 | 339 | </tr> | ||
1812 | 340 | </blockTable> | ||
1813 | 341 | </td> | ||
1814 | 342 | </tr> | ||
1815 | 343 | </blockTable> | ||
1816 | 344 | </td> | ||
1817 | 345 | </tr> | ||
1818 | 346 | </blockTable> | ||
1819 | 347 | </td> | ||
1820 | 348 | </tr> | ||
1821 | 349 | </blockTable> | ||
1822 | 350 | </td> | ||
1823 | 351 | <td> | ||
1824 | 352 | <blockTable colWidths="795.0" style="NEW-HEADER"> | ||
1825 | 353 | <tr> | ||
1826 | 354 | <td vAlign="MIDDLE"><para style="HEADER">OPERACIONES EN EL MERCADO INTERNO</para></td> | ||
1827 | 355 | </tr> | ||
1828 | 356 | <tr> | ||
1829 | 357 | <td> | ||
1830 | 358 | <blockTable colWidths="310.0, 310.0, 175.0" style="NEW-HEADER"> | ||
1831 | 359 | <tr> | ||
1832 | 360 | <td> | ||
1833 | 361 | <blockTable colWidths="310.0" style="NEW-HEADER"> | ||
1834 | 362 | <tr> | ||
1835 | 363 | <td vAlign="MIDDLE"><para style="HEADER">Contribuyente</para></td> | ||
1836 | 364 | </tr> | ||
1837 | 365 | <tr> | ||
1838 | 366 | <td> | ||
1839 | 367 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="NEW-HEADER"> | ||
1840 | 368 | <tr> | ||
1841 | 369 | <td> | ||
1842 | 370 | <blockTable colWidths="40.0" style="NEW-HEADER"> | ||
1843 | 371 | <tr> | ||
1844 | 372 | <td><para style="HEADER">No Gravado</para></td> | ||
1845 | 373 | </tr> | ||
1846 | 374 | <tr> | ||
1847 | 375 | <td> | ||
1848 | 376 | <blockTable colWidths="20.0, 20.0" style="NEW-HEADER"> | ||
1849 | 377 | <tr> | ||
1850 | 378 | <td><para style="HEADER">SDCF</para></td> | ||
1851 | 379 | <td><para style="HEADER">Exento</para></td> | ||
1852 | 380 | </tr> | ||
1853 | 381 | </blockTable> | ||
1854 | 382 | </td> | ||
1855 | 383 | </tr> | ||
1856 | 384 | </blockTable> | ||
1857 | 385 | </td> | ||
1858 | 386 | <td> | ||
1859 | 387 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1860 | 388 | <tr> | ||
1861 | 389 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota General</para></td> | ||
1862 | 390 | </tr> | ||
1863 | 391 | <tr> | ||
1864 | 392 | <td> | ||
1865 | 393 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1866 | 394 | <tr> | ||
1867 | 395 | <td><para style="HEADER">Base Imponible</para></td> | ||
1868 | 396 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1869 | 397 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1870 | 398 | </tr> | ||
1871 | 399 | </blockTable> | ||
1872 | 400 | </td> | ||
1873 | 401 | </tr> | ||
1874 | 402 | </blockTable> | ||
1875 | 403 | </td> | ||
1876 | 404 | <td> | ||
1877 | 405 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1878 | 406 | <tr> | ||
1879 | 407 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1880 | 408 | </tr> | ||
1881 | 409 | <tr> | ||
1882 | 410 | <td> | ||
1883 | 411 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1884 | 412 | <tr> | ||
1885 | 413 | <td><para style="HEADER">Base Imponible</para></td> | ||
1886 | 414 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1887 | 415 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1888 | 416 | </tr> | ||
1889 | 417 | </blockTable> | ||
1890 | 418 | </td> | ||
1891 | 419 | </tr> | ||
1892 | 420 | </blockTable> | ||
1893 | 421 | </td> | ||
1894 | 422 | <td> | ||
1895 | 423 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1896 | 424 | <tr> | ||
1897 | 425 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1898 | 426 | </tr> | ||
1899 | 427 | <tr> | ||
1900 | 428 | <td> | ||
1901 | 429 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1902 | 430 | <tr> | ||
1903 | 431 | <td><para style="HEADER">Base Imponible</para></td> | ||
1904 | 432 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1905 | 433 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1906 | 434 | </tr> | ||
1907 | 435 | </blockTable> | ||
1908 | 436 | </td> | ||
1909 | 437 | </tr> | ||
1910 | 438 | </blockTable> | ||
1911 | 439 | </td> | ||
1912 | 440 | </tr> | ||
1913 | 441 | </blockTable> | ||
1914 | 442 | </td> | ||
1915 | 443 | </tr> | ||
1916 | 444 | </blockTable> | ||
1917 | 445 | </td> | ||
1918 | 446 | |||
1919 | 447 | <td> | ||
1920 | 448 | <blockTable colWidths="310.0" style="NEW-HEADER"> | ||
1921 | 449 | <tr> | ||
1922 | 450 | <td vAlign="MIDDLE"><para style="HEADER">No Contribuyente</para></td> | ||
1923 | 451 | </tr> | ||
1924 | 452 | <tr> | ||
1925 | 453 | <td> | ||
1926 | 454 | <blockTable colWidths="40.0, 90.0, 90.0, 90.0" style="NEW-HEADER"> | ||
1927 | 455 | <tr> | ||
1928 | 456 | <td> | ||
1929 | 457 | <blockTable colWidths="40.0" style="NEW-HEADER"> | ||
1930 | 458 | <tr> | ||
1931 | 459 | <td><para style="HEADER">No Gravado</para></td> | ||
1932 | 460 | </tr> | ||
1933 | 461 | <tr> | ||
1934 | 462 | <td> | ||
1935 | 463 | <blockTable colWidths="20.0, 20.0" style="NEW-HEADER"> | ||
1936 | 464 | <tr> | ||
1937 | 465 | <td><para style="HEADER">SDCF</para></td> | ||
1938 | 466 | <td><para style="HEADER">Exento</para></td> | ||
1939 | 467 | </tr> | ||
1940 | 468 | </blockTable> | ||
1941 | 469 | </td> | ||
1942 | 470 | </tr> | ||
1943 | 471 | </blockTable> | ||
1944 | 472 | </td> | ||
1945 | 473 | <td> | ||
1946 | 474 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1947 | 475 | <tr> | ||
1948 | 476 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota General</para></td> | ||
1949 | 477 | </tr> | ||
1950 | 478 | <tr> | ||
1951 | 479 | <td> | ||
1952 | 480 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1953 | 481 | <tr> | ||
1954 | 482 | <td><para style="HEADER">Base Imponible</para></td> | ||
1955 | 483 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1956 | 484 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1957 | 485 | </tr> | ||
1958 | 486 | </blockTable> | ||
1959 | 487 | </td> | ||
1960 | 488 | </tr> | ||
1961 | 489 | </blockTable> | ||
1962 | 490 | </td> | ||
1963 | 491 | <td> | ||
1964 | 492 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1965 | 493 | <tr> | ||
1966 | 494 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Reducida</para></td> | ||
1967 | 495 | </tr> | ||
1968 | 496 | <tr> | ||
1969 | 497 | <td> | ||
1970 | 498 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1971 | 499 | <tr> | ||
1972 | 500 | <td><para style="HEADER">Base Imponible</para></td> | ||
1973 | 501 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1974 | 502 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1975 | 503 | </tr> | ||
1976 | 504 | </blockTable> | ||
1977 | 505 | </td> | ||
1978 | 506 | </tr> | ||
1979 | 507 | </blockTable> | ||
1980 | 508 | </td> | ||
1981 | 509 | <td> | ||
1982 | 510 | <blockTable colWidths="90.0" style="NEW-HEADER"> | ||
1983 | 511 | <tr> | ||
1984 | 512 | <td><para style="HEADER">Ventas o Servicios Gravados AlÃcuota Adicional</para></td> | ||
1985 | 513 | </tr> | ||
1986 | 514 | <tr> | ||
1987 | 515 | <td> | ||
1988 | 516 | <blockTable colWidths="35.0, 20.0, 35.0" style="NEW-HEADER"> | ||
1989 | 517 | <tr> | ||
1990 | 518 | <td><para style="HEADER">Base Imponible</para></td> | ||
1991 | 519 | <td><para style="HEADER">AlÃcuota</para></td> | ||
1992 | 520 | <td><para style="HEADER">Débito Fiscal</para></td> | ||
1993 | 521 | </tr> | ||
1994 | 522 | </blockTable> | ||
1995 | 523 | </td> | ||
1996 | 524 | </tr> | ||
1997 | 525 | </blockTable> | ||
1998 | 526 | </td> | ||
1999 | 527 | </tr> | ||
2000 | 528 | </blockTable> | ||
2001 | 529 | </td> | ||
2002 | 530 | </tr> | ||
2003 | 531 | </blockTable> | ||
2004 | 532 | </td> | ||
2005 | 533 | |||
2006 | 534 | <td> | ||
2007 | 535 | <blockTable colWidths="175.0" style="NEW-HEADER"> | ||
2008 | 536 | <tr> | ||
2009 | 537 | <td><para style="HEADER">Retenciones</para></td> | ||
2010 | 538 | </tr> | ||
2011 | 539 | <tr> | ||
2012 | 540 | <td> | ||
2013 | 541 | <blockTable colWidths="35.0, 35.0, 35.0, 35.0, 35.0" style="NEW-HEADER" rowHeights="12.0"> | ||
2014 | 542 | <tr> | ||
2015 | 543 | <td><para style="HEADER">Fecha de Factura Afectada</para></td> | ||
2016 | 544 | <td><para style="HEADER">Nro Retención</para></td> | ||
2017 | 545 | <td><para style="HEADER">Débito Fiscal Base</para></td> | ||
2018 | 546 | <td><para style="HEADER">Retención %</para></td> | ||
2019 | 547 | <td><para style="HEADER">Monto Retenido</para></td> | ||
2020 | 548 | </tr> | ||
2021 | 549 | </blockTable> | ||
2022 | 550 | </td> | ||
2023 | 551 | </tr> | ||
2024 | 552 | </blockTable> | ||
2025 | 553 | </td> | ||
2026 | 554 | </tr> | ||
2027 | 555 | </blockTable> | ||
2028 | 556 | </td> | ||
2029 | 557 | </tr> | ||
2030 | 558 | </blockTable> | ||
2031 | 559 | </td> | ||
2032 | 560 | </tr> | ||
2033 | 561 | </blockTable> | ||
2034 | 562 | </section> | ||
2035 | 563 | |||
2036 | 564 | <!-- SALE BOOK LINES --> | 521 | <!-- SALE BOOK LINES --> |
2037 | 565 | <section> | 522 | <section> |
2038 | 566 | <para>[[repeatIn( my_fb.fbl_ids,'my_fbl')]]</para> | 523 | <para>[[repeatIn( my_fb.fbl_ids,'my_fbl')]]</para> |
2040 | 567 | <blockTable style="NEW-CONTENIDOTABLE-LINES" blockAlignment="LEFT" | 524 | <blockTable style="NEW-CONTENIDOTABLE-LINES" |
2041 | 568 | colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 36.0, 23.0, 130.0, 25.0, | 525 | colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 36.0, 23.0, 130.0, 25.0, |
2042 | 569 | 37.0, | 526 | 37.0, |
2044 | 570 | 23.0, 40.0, 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 527 | 23.0, 40.0, 20.0, 20.0, |
2045 | 571 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 528 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, |
2046 | 572 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 529 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, |
2047 | 573 | 35.0, 35.0, 35.0, 35.0, 35.0"> | 530 | 35.0, 35.0, 35.0, 35.0, 35.0"> |
2048 | @@ -590,15 +547,6 @@ | |||
2049 | 590 | <td vAlign="MIDDLE"><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.custom_statement # Declaracion ]]</para></td> | 547 | <td vAlign="MIDDLE"><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.custom_statement # Declaracion ]]</para></td> |
2050 | 591 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_sdcf # SDCF ]]</para></td> | 548 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_sdcf # SDCF ]]</para></td> |
2051 | 592 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_exempt # Exento ]]</para></td> | 549 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_exempt # Exento ]]</para></td> |
2052 | 593 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_general_base # General | Base Imponible ]]</para></td> | ||
2053 | 594 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and '12%' # General | AlÃcuota ]]</para></td> | ||
2054 | 595 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_general_tax # General | Débito Fiscal ]]</para></td> | ||
2055 | 596 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_reduced_base # Reducido | Base Imponible ]]</para></td> | ||
2056 | 597 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and '8%' # Reducido | AlÃcuota ]]</para></td> | ||
2057 | 598 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_reduced_tax # Reducido | Débito Fiscal ]]</para></td> | ||
2058 | 599 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_additional_base # Adicional | Base Imponible ]]</para></td> | ||
2059 | 600 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and '22%' # Adicional | AlÃcuota ]]</para></td> | ||
2060 | 601 | <td><para style="HEADER">[[ my_fbl.type in ['ex'] and my_fbl.vat_additional_tax # Adicional | Débito Fiscal ]]</para></td> | ||
2061 | 602 | <!-- Ventas Internas / Contribuyentes --> | 550 | <!-- Ventas Internas / Contribuyentes --> |
2062 | 603 | <td><para style="HEADER">[[ my_fbl.type in ['tp'] and my_fbl.vat_sdcf # SDCF ]]</para></td> | 551 | <td><para style="HEADER">[[ my_fbl.type in ['tp'] and my_fbl.vat_sdcf # SDCF ]]</para></td> |
2063 | 604 | <td><para style="HEADER">[[ my_fbl.type in ['tp'] and my_fbl.vat_exempt # Exento ]]</para></td> | 552 | <td><para style="HEADER">[[ my_fbl.type in ['tp'] and my_fbl.vat_exempt # Exento ]]</para></td> |
2064 | @@ -635,10 +583,10 @@ | |||
2065 | 635 | 583 | ||
2066 | 636 | <!-- TOTALS SALE PARCIALES --> | 584 | <!-- TOTALS SALE PARCIALES --> |
2067 | 637 | <section> | 585 | <section> |
2070 | 638 | <blockTable style="NEW-CONTENIDOTABLE-LINES" blockAlignment="LEFT" | 586 | <blockTable style="NEW-CONTENIDOTABLE-LINES" |
2071 | 639 | colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 36.0, 36.0, 23.0, 130.0, 25.0, | 587 | colWidths="15.0, 15.0, 23.0, 36.0, 36.0, 36.0, 36.0, 23.0, 130.0, 25.0, |
2072 | 640 | 37.0, | 588 | 37.0, |
2074 | 641 | 23.0, 40.0, 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 589 | 23.0, 40.0, 20.0, 20.0, |
2075 | 642 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 590 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, |
2076 | 643 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, | 591 | 20.0, 20.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, 35.0, 20.0, 35.0, |
2077 | 644 | 35.0, 35.0, 35.0, 35.0, 35.0"> | 592 | 35.0, 35.0, 35.0, 35.0, 35.0"> |
2078 | @@ -650,7 +598,6 @@ | |||
2079 | 650 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero Control ]]</para></td> | 598 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero Control ]]</para></td> |
2080 | 651 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero de Doc ]]</para></td> | 599 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero de Doc ]]</para></td> |
2081 | 652 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero Impresora ]]</para></td> | 600 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero Impresora ]]</para></td> |
2082 | 653 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Numero de Factura de impresora ]]</para></td> | ||
2083 | 654 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Reporte Z ]]</para></td> | 601 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Reporte Z ]]</para></td> |
2084 | 655 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Factura Afectada ]]</para></td> | 602 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Factura Afectada ]]</para></td> |
2085 | 656 | <td vAlign="MIDDLE"><para style="HEADER">[[ 'TOTALES' # Razon Social ]]</para></td> | 603 | <td vAlign="MIDDLE"><para style="HEADER">[[ 'TOTALES' # Razon Social ]]</para></td> |
2086 | @@ -662,15 +609,6 @@ | |||
2087 | 662 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Declaracion ]]</para></td> | 609 | <td vAlign="MIDDLE"><para style="HEADER">[[ '' # Declaracion ]]</para></td> |
2088 | 663 | <td><para style="HEADER">[[ my_fb.imex_sdcf_vat_sum # SDCF ]]</para></td> | 610 | <td><para style="HEADER">[[ my_fb.imex_sdcf_vat_sum # SDCF ]]</para></td> |
2089 | 664 | <td><para style="HEADER">[[ my_fb.imex_exempt_vat_sum # Exento ]]</para></td> | 611 | <td><para style="HEADER">[[ my_fb.imex_exempt_vat_sum # Exento ]]</para></td> |
2090 | 665 | <td><para style="HEADER">[[ my_fb.imex_general_vat_base_sum # General | Base Imponible ]]</para></td> | ||
2091 | 666 | <td><para style="HEADER">[[ '' # General | AlÃcuota ]]</para></td> | ||
2092 | 667 | <td><para style="HEADER">[[ my_fb.imex_general_vat_tax_sum # General | Débito Fiscal ]]</para></td> | ||
2093 | 668 | <td><para style="HEADER">[[ my_fb.imex_reduced_vat_base_sum # Reducido | Base Imponible ]]</para></td> | ||
2094 | 669 | <td><para style="HEADER">[[ '' # Reducido | AlÃcuota ]]</para></td> | ||
2095 | 670 | <td><para style="HEADER">[[ my_fb.imex_reduced_vat_tax_sum # Reducido | Débito Fiscal ]]</para></td> | ||
2096 | 671 | <td><para style="HEADER">[[ my_fb.imex_additional_vat_base_sum # Adicional | Base Imponible ]]</para></td> | ||
2097 | 672 | <td><para style="HEADER">[[ '' # Adicional | AlÃcuota ]]</para></td> | ||
2098 | 673 | <td><para style="HEADER">[[ my_fb.imex_additional_vat_tax_sum # Adicional | Débito Fiscal ]]</para></td> | ||
2099 | 674 | <!-- Ventas Internas / Contribuyentes --> | 612 | <!-- Ventas Internas / Contribuyentes --> |
2100 | 675 | <td><para style="HEADER">[[ my_fb.tp_sdcf_vat_sum # SDCF ]]</para></td> | 613 | <td><para style="HEADER">[[ my_fb.tp_sdcf_vat_sum # SDCF ]]</para></td> |
2101 | 676 | <td><para style="HEADER">[[ my_fb.tp_exempt_vat_sum # Exento ]]</para></td> | 614 | <td><para style="HEADER">[[ my_fb.tp_exempt_vat_sum # Exento ]]</para></td> |
2102 | @@ -772,19 +710,6 @@ | |||
2103 | 772 | </blockTable> | 710 | </blockTable> |
2104 | 773 | </section> | 711 | </section> |
2105 | 774 | 712 | ||
2106 | 775 | <!-- | ||
2107 | 776 | <blockTable colWidths="110.0" style="INTERNALTABLE"> | ||
2108 | 777 | <tr> | ||
2109 | 778 | <td vAlign="MIDDLE"> | ||
2110 | 779 | <para>[[ validation(data['form']) and '.' or removeParentNode('blockTable') ]]</para> | ||
2111 | 780 | <nextPage/> | ||
2112 | 781 | OJO AQUI el next page estaba comentado. | ||
2113 | 782 | </td> | ||
2114 | 783 | </tr> | ||
2115 | 784 | </blockTable> | ||
2116 | 785 | |||
2117 | 786 | --> | ||
2118 | 787 | |||
2119 | 788 | <spacer length='5mm'/> | 713 | <spacer length='5mm'/> |
2120 | 789 | <!-- ************ AJUSTMENT BOOK ************--> | 714 | <!-- ************ AJUSTMENT BOOK ************--> |
2121 | 790 | <!-- | 715 | <!-- |
2122 | 791 | 716 | ||
2123 | === added directory 'l10n_ve_fiscal_book/security' | |||
2124 | === added file 'l10n_ve_fiscal_book/security/fiscal_book_security.xml' | |||
2125 | --- l10n_ve_fiscal_book/security/fiscal_book_security.xml 1970-01-01 00:00:00 +0000 | |||
2126 | +++ l10n_ve_fiscal_book/security/fiscal_book_security.xml 2013-05-27 21:01:40 +0000 | |||
2127 | @@ -0,0 +1,16 @@ | |||
2128 | 1 | <?xml version='1.0' encoding='UTF-8'?> | ||
2129 | 2 | <openerp> | ||
2130 | 3 | <data noupdate="1"> | ||
2131 | 4 | |||
2132 | 5 | <record id="group_account_fiscal_book_manager" model="res.groups"> | ||
2133 | 6 | <field name="name">Fiscal Book / Manager</field> | ||
2134 | 7 | </record> | ||
2135 | 8 | <record id="group_account_fiscal_book_power_user" model="res.groups"> | ||
2136 | 9 | <field name="name">Fiscal Book / Power User</field> | ||
2137 | 10 | </record> | ||
2138 | 11 | <record id="group_account_fiscal_book_user" model="res.groups"> | ||
2139 | 12 | <field name="name">Fiscal Book / User</field> | ||
2140 | 13 | </record> | ||
2141 | 14 | |||
2142 | 15 | </data> | ||
2143 | 16 | </openerp> | ||
2144 | 0 | 17 | ||
2145 | === added file 'l10n_ve_fiscal_book/security/ir.model.access.csv' | |||
2146 | --- l10n_ve_fiscal_book/security/ir.model.access.csv 1970-01-01 00:00:00 +0000 | |||
2147 | +++ l10n_ve_fiscal_book/security/ir.model.access.csv 2013-05-27 21:01:40 +0000 | |||
2148 | @@ -0,0 +1,16 @@ | |||
2149 | 1 | "id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink" | ||
2150 | 2 | "access_fb_fiscal_book_user","fb.fiscal.book.user","model_fiscal_book","l10n_ve_fiscal_book.group_account_fiscal_book_user","1","0","0","0" | ||
2151 | 3 | "access_fb_fiscal_book_line_user","fb.fiscal.book.lines.user","model_fiscal_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_user","1","0","0","0" | ||
2152 | 4 | "access_fb_fiscal_book_taxes_user","fb.fiscal.book.taxes.user","model_fiscal_book_taxes","l10n_ve_fiscal_book.group_account_fiscal_book_user","1","0","0","0" | ||
2153 | 5 | "access_fb_fiscal_book_taxes_summary_user","fb.fiscal.book.taxes.summary.user","model_fiscal_book_taxes_summary","l10n_ve_fiscal_book.group_account_fiscal_book_user","1","0","0","0" | ||
2154 | 6 | "access_fb_adjustment_book_line_user","fb.adjustment.book.line.user","model_adjustment_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_user","1","0","0","0" | ||
2155 | 7 | "access_fb_fiscal_book_power_user","fb.fiscal.book.power.user","model_fiscal_book","l10n_ve_fiscal_book.group_account_fiscal_book_power_user","1","0","0","0" | ||
2156 | 8 | "access_fb_fiscal_book_line_power_user","fb.fiscal.book.lines.power.user","model_fiscal_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_power_user","1","0","0","0" | ||
2157 | 9 | "access_fb_fiscal_book_taxes_power_user","fb.fiscal.book.taxes.power.user","model_fiscal_book_taxes","l10n_ve_fiscal_book.group_account_fiscal_book_power_user","1","0","0","0" | ||
2158 | 10 | "access_fb_fiscal_book_taxes_summary_power_user","fb.fiscal.book.taxes.summary.power.user","model_fiscal_book_taxes_summary","l10n_ve_fiscal_book.group_account_fiscal_book_power_user","1","0","0","0" | ||
2159 | 11 | "access_fb_adjustment_book_line_power_user","fb.adjustment.book.line.power.user","model_adjustment_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_power_user","1","0","0","0" | ||
2160 | 12 | "access_fb_fiscal_book_manager","fb.fiscal.book.manager","model_fiscal_book","l10n_ve_fiscal_book.group_account_fiscal_book_manager","1","1","1","1" | ||
2161 | 13 | "access_fb_fiscal_book_line_manager","fb.fiscal.book.lines.manager","model_fiscal_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_manager","1","1","1","1" | ||
2162 | 14 | "access_fb_fiscal_book_taxes_manager","fb.fiscal.book.taxes.manager","model_fiscal_book_taxes","l10n_ve_fiscal_book.group_account_fiscal_book_manager","1","1","1","1" | ||
2163 | 15 | "access_fb_fiscal_book_taxes_summary_manager","fb.fiscal.book.taxes.summary.manager","model_fiscal_book_taxes_summary","l10n_ve_fiscal_book.group_account_fiscal_book_manager","1","1","1","1" | ||
2164 | 16 | "access_fb_adjustment_book_line_manager","fb.adjustment.book.line.manager","model_adjustment_book_line","l10n_ve_fiscal_book.group_account_fiscal_book_manager","1","1","1","1" | ||
2165 | 0 | 17 | ||
2166 | === modified file 'l10n_ve_fiscal_book/view/fiscal_book.xml' | |||
2167 | --- l10n_ve_fiscal_book/view/fiscal_book.xml 2013-05-23 04:34:03 +0000 | |||
2168 | +++ l10n_ve_fiscal_book/view/fiscal_book.xml 2013-05-27 21:01:40 +0000 | |||
2169 | @@ -75,10 +75,14 @@ | |||
2170 | 75 | <field name="arch" type="xml"> | 75 | <field name="arch" type="xml"> |
2171 | 76 | <form string="Fiscal Sale Book" version="7.0"> | 76 | <form string="Fiscal Sale Book" version="7.0"> |
2172 | 77 | <header> | 77 | <header> |
2177 | 78 | <button name="update_book" type="object" string="Update Book" class="oe_highlight"/> | 78 | <button name="update_book" type="object" string="Update Book" states="draft" class="oe_highlight"/> |
2178 | 79 | <button name="clear_book" type="object" string="Clear Book" class="oe_highlight"/> | 79 | <button name="clear_book" type="object" string="Clear Book" states="draft" class="oe_highlight"/> |
2179 | 80 | <button name="%(fiscal_book_wizard_act)d" type="action" string="Print Book" class="oe_highlight"/> | 80 | <button name="%(fiscal_book_wizard_act)d" type="action" string="Print Book" states="draft,confirmed,done" class="oe_highlight"/> |
2180 | 81 | <field name="state" widget="statusbar" statusbar_visible="draft,open,done" statusbar_colors="{"draft":"blue","open":"green","done":"red"}"/> | 81 | <button name="act_confirm" string="Confirm" states="draft" icon="gtk-go-forward"/> |
2181 | 82 | <button name="act_done" string="Done" states="confirmed" icon="gtk-execute"/> | ||
2182 | 83 | <button name="act_cancel" string="Cancel" states="confirmed,done" icon="gtk-cancel"/> | ||
2183 | 84 | <button name="act_draft" colspan="2" string="Set to draft" states="cancel" icon="gtk-go-forward"/> | ||
2184 | 85 | <field name="state" widget="statusbar" statusbar_visible="draft,confirmed,done" statusbar_colors="{"draft":"blue","confirmed":"green","done":"red"}"/> | ||
2185 | 82 | </header> | 86 | </header> |
2186 | 83 | <group> | 87 | <group> |
2187 | 84 | <field name="name"/> | 88 | <field name="name"/> |
2188 | @@ -99,12 +103,12 @@ | |||
2189 | 99 | <field name="affected_invoice"/> | 103 | <field name="affected_invoice"/> |
2190 | 100 | <field name="partner_name"/> | 104 | <field name="partner_name"/> |
2191 | 101 | <field name="partner_vat"/> | 105 | <field name="partner_vat"/> |
2192 | 102 | <field name="total_with_iva" sum=""/> | ||
2193 | 103 | <field name="type"/> | 106 | <field name="type"/> |
2194 | 104 | <field name="custom_statement"/> | 107 | <field name="custom_statement"/> |
2195 | 105 | <field name="imex_date"/> | 108 | <field name="imex_date"/> |
2196 | 106 | <field name="fiscal_printer"/> | 109 | <field name="fiscal_printer"/> |
2197 | 107 | <field name="z_report"/> | 110 | <field name="z_report"/> |
2198 | 111 | <field name="total_with_iva" sum=""/> | ||
2199 | 108 | <field name="vat_sdcf"/> | 112 | <field name="vat_sdcf"/> |
2200 | 109 | <field name="vat_exempt"/> | 113 | <field name="vat_exempt"/> |
2201 | 110 | <field name="vat_general_base"/> | 114 | <field name="vat_general_base"/> |
2202 | @@ -268,10 +272,14 @@ | |||
2203 | 268 | <field name="arch" type="xml"> | 272 | <field name="arch" type="xml"> |
2204 | 269 | <form string="Fiscal Purchase Book" version="7.0"> | 273 | <form string="Fiscal Purchase Book" version="7.0"> |
2205 | 270 | <header> | 274 | <header> |
2210 | 271 | <button name="update_book" type="object" string="Update Book" class="oe_highlight"/> | 275 | <button name="update_book" type="object" string="Update Book" states="draft" class="oe_highlight"/> |
2211 | 272 | <button name="clear_book" type="object" string="Clear Book" class="oe_highlight"/> | 276 | <button name="clear_book" type="object" string="Clear Book" states="draft" class="oe_highlight"/> |
2212 | 273 | <button name="%(fiscal_book_wizard_act)d" type="action" string="Print Book" class="oe_highlight"/> | 277 | <button name="%(fiscal_book_wizard_act)d" type="action" string="Print Book" states="draft,confirmed,done" class="oe_highlight"/> |
2213 | 274 | <field name="state" widget="statusbar" statusbar_visible="draft,open,done" statusbar_colors="{"draft":"blue","open":"green","done":"red"}"/> | 278 | <button name="act_confirm" string="Confirm" states="draft" icon="gtk-go-forward"/> |
2214 | 279 | <button name="act_done" string="Done" states="confirmed" icon="gtk-execute"/> | ||
2215 | 280 | <button name="act_cancel" string="Cancel" states="confirmed,done" icon="gtk-cancel"/> | ||
2216 | 281 | <button name="act_draft" colspan="2" string="Set to draft" states="cancel" icon="gtk-go-forward"/> | ||
2217 | 282 | <field name="state" widget="statusbar" statusbar_visible="draft,confirmed,done" statusbar_colors="{"draft":"blue","confirmed":"green","done":"red"}"/> | ||
2218 | 275 | </header> | 283 | </header> |
2219 | 276 | <group> | 284 | <group> |
2220 | 277 | <field name="name"/> | 285 | <field name="name"/> |
2221 | @@ -412,4 +420,4 @@ | |||
2222 | 412 | <menuitem name="Fiscal Purchase Book" id="menu_fiscal_purchase_book" parent="menu_fr_main" action="action_fiscal_purchase_book"/> | 420 | <menuitem name="Fiscal Purchase Book" id="menu_fiscal_purchase_book" parent="menu_fr_main" action="action_fiscal_purchase_book"/> |
2223 | 413 | 421 | ||
2224 | 414 | </data> | 422 | </data> |
2225 | 415 | </openerp> | ||
2226 | 416 | \ No newline at end of file | 423 | \ No newline at end of file |
2227 | 424 | </openerp> | ||
2228 | 417 | 425 | ||
2229 | === added directory 'l10n_ve_fiscal_book/workflow' | |||
2230 | === added file 'l10n_ve_fiscal_book/workflow/fb_workflow.xml' | |||
2231 | --- l10n_ve_fiscal_book/workflow/fb_workflow.xml 1970-01-01 00:00:00 +0000 | |||
2232 | +++ l10n_ve_fiscal_book/workflow/fb_workflow.xml 2013-05-27 21:01:40 +0000 | |||
2233 | @@ -0,0 +1,80 @@ | |||
2234 | 1 | <?xml version='1.0' encoding='UTF-8'?> | ||
2235 | 2 | <openerp> | ||
2236 | 3 | <data> | ||
2237 | 4 | |||
2238 | 5 | <record id="fb_wkf" model="workflow"> | ||
2239 | 6 | <field name="name">Fiscal Book Workflow</field> | ||
2240 | 7 | <field name="osv">fiscal.book</field> | ||
2241 | 8 | <field name="on_create">True</field> | ||
2242 | 9 | </record> | ||
2243 | 10 | |||
2244 | 11 | <!-- | ||
2245 | 12 | Activity | ||
2246 | 13 | --> | ||
2247 | 14 | |||
2248 | 15 | <record id="act_draft" model="workflow.activity"> | ||
2249 | 16 | <field name="wkf_id" ref="fb_wkf"/> | ||
2250 | 17 | <field name="name">draft</field> | ||
2251 | 18 | <field name="kind">function</field> | ||
2252 | 19 | <field name="action">write({'state':'draft'})</field> | ||
2253 | 20 | <field name="flow_start">True</field> | ||
2254 | 21 | </record> | ||
2255 | 22 | |||
2256 | 23 | <record id="act_confirmed" model="workflow.activity"> | ||
2257 | 24 | <field name="wkf_id" ref="fb_wkf"/> | ||
2258 | 25 | <field name="name">confirmed</field> | ||
2259 | 26 | <field name="kind">function</field> | ||
2260 | 27 | <field name="action">update_book() | ||
2261 | 28 | write({'state':'confirmed'})</field> | ||
2262 | 29 | </record> | ||
2263 | 30 | |||
2264 | 31 | <record id="act_done" model="workflow.activity"> | ||
2265 | 32 | <field name="wkf_id" ref="fb_wkf"/> | ||
2266 | 33 | <field name="name">done</field> | ||
2267 | 34 | <field name="kind">function</field> | ||
2268 | 35 | <field name="action">write({'state':'done'})</field> | ||
2269 | 36 | </record> | ||
2270 | 37 | |||
2271 | 38 | <record id="act_cancel" model="workflow.activity"> | ||
2272 | 39 | <field name="wkf_id" ref="fb_wkf"/> | ||
2273 | 40 | <field name="name">cancel</field> | ||
2274 | 41 | <field name="kind">function</field> | ||
2275 | 42 | <field name="action">write({'state':'cancel'})</field> | ||
2276 | 43 | </record> | ||
2277 | 44 | |||
2278 | 45 | <!-- | ||
2279 | 46 | Transitions | ||
2280 | 47 | --> | ||
2281 | 48 | |||
2282 | 49 | <record id="trans_draft_confirmed" model="workflow.transition"> | ||
2283 | 50 | <field name="act_from" ref="act_draft"/> | ||
2284 | 51 | <field name="act_to" ref="act_confirmed"/> | ||
2285 | 52 | <field name="signal">act_confirm</field> | ||
2286 | 53 | </record> | ||
2287 | 54 | |||
2288 | 55 | <record id="trans_confirmed_done" model="workflow.transition"> | ||
2289 | 56 | <field name="act_from" ref="act_confirmed"/> | ||
2290 | 57 | <field name="act_to" ref="act_done"/> | ||
2291 | 58 | <field name="signal">act_done</field> | ||
2292 | 59 | </record> | ||
2293 | 60 | |||
2294 | 61 | <record id="trans_confirmed_cancel" model="workflow.transition"> | ||
2295 | 62 | <field name="act_from" ref="act_confirmed"/> | ||
2296 | 63 | <field name="act_to" ref="act_cancel"/> | ||
2297 | 64 | <field name="signal">act_cancel</field> | ||
2298 | 65 | </record> | ||
2299 | 66 | |||
2300 | 67 | <record id="trans_done_cancel" model="workflow.transition"> | ||
2301 | 68 | <field name="act_from" ref="act_done"/> | ||
2302 | 69 | <field name="act_to" ref="act_cancel"/> | ||
2303 | 70 | <field name="signal">act_cancel</field> | ||
2304 | 71 | </record> | ||
2305 | 72 | |||
2306 | 73 | <record id="trans_cancel_draft" model="workflow.transition"> | ||
2307 | 74 | <field name="act_from" ref="act_cancel"/> | ||
2308 | 75 | <field name="act_to" ref="act_draft"/> | ||
2309 | 76 | <field name="signal">act_draft</field> | ||
2310 | 77 | </record> | ||
2311 | 78 | |||
2312 | 79 | </data> | ||
2313 | 80 | </openerp> |