Skip to Content

Contributors

Re: Problem with fiscal year starting on 1 October to 30 September and Odoo BI Report

Just for the finding record, OCA has a solution which is based on date_range. Which requires to work model by model.

On Wed, May 26, 2021 at 10:01 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Dear community,

For the fiscal year that starts from October and ending September. So, on the Odoo BI view, we expect to see that 2021 / Q1 means 1 October to 31 December.

I think this is not possible in Odoo, as it only use "Date" to interpret the report, right?

To achieve the expected result, I can only think of adding fiscalyear_id, and quarter as computed stored field in every models needed, which is very inefficient.

Anyone have better way to achieve this?

Many thanks,
Kitti U.




_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


by Kitti Upariphutthiphong - 05:05 - 29 May 2021

Reference

  • Problem with fiscal year starting on 1 October to 30 September and Odoo BI Report
    Dear community,

    For the fiscal year that starts from October and ending September. So, on the Odoo BI view, we expect to see that 2021 / Q1 means 1 October to 31 December.

    I think this is not possible in Odoo, as it only use "Date" to interpret the report, right?

    To achieve the expected result, I can only think of adding fiscalyear_id, and quarter as computed stored field in every models needed, which is very inefficient.

    Anyone have better way to achieve this?

    Many thanks,
    Kitti U.





    by Kitti Upariphutthiphong - 05:01 - 26 May 2021