Skip to Content
This question has been flagged
4 Replies
25105 Rodiniai
Portretas
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.

Portretas
Atmesti
Portretas
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

Portretas
Atmesti
Marty Langen
Autorius

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
Autorius

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
Autorius

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 Software Solutions)

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

Portretas
Mohamed
Best Answer



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

Portretas
Atmesti
Portretas
Mister One
Best Answer

How to do this on Odoo 8 ?

Portretas
Atmesti
Portretas
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.

Portretas
Atmesti
Jose Koenig

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