Skip to Content
This question has been flagged
4 Replies
24172 Views
Avatar
Marty Langen

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.

Avatar
Discard
Avatar
Ray Carnes
Best Answer

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:

image description

AFTER a payment of $250, the invoice report would look like this:

image description

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

Avatar
Discard
Marty Langen
Author

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?

Marty Langen
Author

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?

Marty Langen
Author

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?

Ray Carnes

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!

Niyas Raphy (Walnut IT)

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

Avatar
Mohamed
Best Answer



Hi guys , did any one try this on odoo 10. To show partial payment on invoice pdf

Avatar
Discard
Avatar
Mister One
Best Answer

How to do this on Odoo 8 ?

Avatar
Discard
Avatar
Jose Koenig
Best Answer

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.

Avatar
Discard
Jose Koenig

This might be a reload from attachment setting once I figure out from cryptic solution.