تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
4 الردود
25064 أدوات العرض
الصورة الرمزية
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.

الصورة الرمزية
إهمال
الصورة الرمزية
Ray Carnes
أفضل إجابة

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

الصورة الرمزية
إهمال
Marty Langen
الكاتب

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
الكاتب

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
الكاتب

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

الصورة الرمزية
Mohamed
أفضل إجابة



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

الصورة الرمزية
إهمال
الصورة الرمزية
Mister One
أفضل إجابة

How to do this on Odoo 8 ?

الصورة الرمزية
إهمال
الصورة الرمزية
Jose Koenig
أفضل إجابة

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.

الصورة الرمزية
إهمال
Jose Koenig

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