account: cash statements using a static list of values not related to currency

[Niels Huylebroeck]

Possibly the best solution is to store a list of values on the "res.currency" of which bills/coins you have for that currency.
This way any cash statement openings can look at the currency and retrieve the values.

[Kenneth Andresen (kandresen)]

This issue does indeed affect my market too as I am in a tourist sector where three different currencies are commonly used. (EURO, USD, and MXN). MXN have [1000, 500, 200, 100, 50, 20, 10, 5, 2, 1], though the 1000 bills are very often not accepted, so starting at 500 would often be preferred.

If that could be done as simple as going to the localization specification page ( Settings --> Translations --> Languages ) or similar, then it would be great!

[Kenneth Andresen (kandresen)]

Thinking of it, this may need to be cash-register specific as if a holding company might have child companies with different policies according to what is being sold - i.e. one focusing on luxury jewelry and another on cheaper jewelry.

[Kenneth Andresen (kandresen)]

I am noticing that the "point_of_sales" module have an interesting override of the default values for the cash registers.

    def _get_cash_open_box_lines(self, cr, uid, context=None):
        res = super(account_cash_statement,self)._get_cash_open_box_lines(cr, uid, context)
        curr = [0.01, 0.02, 0.05, 0.10, 0.20, 0.50]
        for rs in curr:
            dct = {
                'pieces': rs,
                'number': 0
            }
            res.append(dct)
        res.sort()
        return res

The problem with these curr settings are that they depend upon the bills and coins of each currency, so I think as the original poster the best choice is to set the curr array according to the currency of the journal or the default currency of the company.

[Niels Huylebroeck (red15)]

This feature was implemented in v7 by adding the used coins/bills on the Journal (only visible when 'Cash Control' is checked on).

Kudos for this approach because it solves problems of different branches in Europe using EUR currency but not always using 0.01EUR and 0.02EUR as for example in The Netherlands and Finland.

This way it allows you to define per journal (which can become a Cash Register when POS is installed) which coins are used.