Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Good morning,
We are running OpenERP 7 on our server. Our company collects a 50% deposit from all customers with the remainder due once the product is delivered.
On an invoice we would like there to be 2 additional lines.
One showing a total of all payments against that invoice And a final line showing the balance owing.
Any help would be of great assistance.
An example RML code block to do this is something like:
<blockTable colWidths="365.0,90.0,75.0" style="Table10">
<tr>
<td>
<para style="terp_default_8">
<font color="white">
</font>
</para>
</td>
<td>
<para style="terp_default_9">Payment(s):
</para>
</td>
<td>
<para style="terp_default_Right_9">
[[ formatLang(-(o.amount_total - o.residual), digits=2, currency_obj=o.currency_id) ]]
</para>
</td>
</tr>
<tr>
<td>
<para style="terp_default_8">
<font color="white">
</font>
</para>
</td>
<td>
<para style="terp_default_9">
<b>Total Due:</b>
</para>
</td>
<td>
<para style="terp_default_Right_9">
<b> [[ formatLang(o.residual, digits=2,currency_obj=o.currency_id) ]]</b>
</para>
</td>
</tr>
</blockTable>
PRIOR to any payments being made, the invoice report would look like this:
AFTER a payment of $250, the invoice report would look like this:
You also need to make sure the report is regenerated, not reloaded. For more information see https://accounts.openerp.com/forum/Help-1/question/9571
We have uploaded a modified account_print_invoice.rml file as suggested. We have also made sure that the file is being regenerated and not reloaded. But the changes are still NOT reflected when we print our invoice... any Ideas why this is happening?
Have any changes been made to this report in OpenOffice? http://help.openerp.com/question/9505/report-designer-with-openoffice-cancels-modifications/
Thank you for the input Ray. This is way over our head and we would not know where to begin with you latest suggestion. Do you know of anyone we could hire to complete this modification for us?
Thank you for the input Ray. This is way over our head and we would not know where to begin with you latest suggestion. Do you know of anyone we could hire to complete this modification for us?
In Canada, contact https://www.openerp.com/partners/directory/4554/Savoir-Faire+Linux and tell them Ray Carnes sent you - ask for Maxime and the price for friends of Ray!
While creating a invoice from sale order(in the case of down payment) it is not working properly. if you create a sale order with 1000usd and done down payment of 100usd, in the invoice it will show balance as zero. while it work properly if we generate a invoice for total amount
Hi guys , did any one try this on odoo 10. To show partial payment on invoice pdf
How to do this on Odoo 8 ?
I tried your sample code and I can see the idea. How can I get the Payments(s) line work? I see o.residual always set to zero, so I need to get the total payments from somewhere. Please help.
This might be a reload from attachment setting once I figure out from cryptic solution.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
