Hi,

Please, add to views "Currency Name" and "Simbol"(cur.cursymbol, cur.description AS cur_description) to put in invoices and orders the type of currency used.

I has to add to select:
cur.cursymbol, cur.description AS cur_description

and to FROM:
LEFT JOIN c_currency cur ON o.c_currency_id = cur.c_currency_id

To get they in my reports

Regards

There are 83 wrong table direct references in columns, most of this from this ticket, but there are also some older.

Check this query:

This is causing that reports like "Order Detail" fail with postgresql syntax errors on console

Issue reported by Max Sánchez in spanish forums:

https://groups.google.com/d/msg/idempiere-es/Uplwn5Q6NeQ/XjDdq2Q_3K0J
___________

After the updates to the database some days ago, the view c_order_linetax_vt has an error, it doesn't show the tax fields translated, which is stopping the sales and purchase order from being printed correclty as the taxes lines doesn't appear.

When I check directly the view on the database, all the items in the order appear as many times as enabled languages without including english, besides to include a tax line, which must also appears as many times as enabled languages, but this just appears once and just for english language (the column ad_language is en_US). This is why at the moment of printing the document, the tax line is not shown as the select just print the language being used.
___________

https://bitbucket.org/idempiere/idempiere/commits/01ae9b55efe3
https://bitbucket.org/idempiere/idempiere/commits/08dda45617d1
https://bitbucket.org/idempiere/idempiere/commits/8e9ec64a664d