Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Generic accounting reports based on mis? #206

Open
Martronic-SA opened this issue Jul 3, 2019 · 10 comments
Open

Generic accounting reports based on mis? #206

Martronic-SA opened this issue Jul 3, 2019 · 10 comments
Labels
enhancement no stale Use this label to prevent the automated stale action from closing this PR/Issue.

Comments

@Martronic-SA
Copy link
Contributor

Is there existing modules or any plan to create a module that would install two basic reports, the Profit & Loss and Bilan based on the default type of account (like the module accout_reports does)?
Thanks

@sbidoul
Copy link
Member

sbidoul commented Jul 3, 2019

I not aware of such a plan, although I've had this on the back on my mind for a while.

It should be a relatively simple data module with expressions such as -balp[('user_type_id', '=', ref('...').id)]

@Martronic-SA
Copy link
Contributor Author

@sbidoul Exactly what I was thinkig.
Any idea for the name of the module? (account_mis_reports ?)
the reports to create? (P&L, BS, Cash flow?)
in which folder to add it (here or in account-financial-reporting?)

@sbidoul
Copy link
Member

sbidoul commented Jul 3, 2019

Any idea for the name of the module?

mis_builder_account_generic_report ?

account-financial-reporting would be a natural place I guess.

Or they could go in https://github.com/OCA/account-financial-reporting/tree/12.0/account_financial_report, although adding mis_builder as a dependency of that module might be controversial.

@sbidoul
Copy link
Member

sbidoul commented Jul 3, 2019

the reports to create? (P&L, BS, Cash flow?)

P&L and BS definitely.
Cash flow I don't know myself how generic it can be.
A flat trial balance is also easy to add with 5 subkpis (bali[], crd[], deb[], balp[], bale[]) and account detail expansion enabled:

(a grouped trial balance using account groups is not possible with mis builder at the moment).

@pedrobaeza
Copy link
Member

pedrobaeza commented Jul 3, 2019

But is this something that someone is going to use in practice instead of their localized P&L? If not, better to provide that templates as demo data of the main module.

@Martronic-SA
Copy link
Contributor Author

Martronic-SA commented Jul 3, 2019

We have clients with many sub companies in the world and they are happy to have one common P&L / BS report even if it's not as precise as the localized ones, but at least they are sure to have everything and not an account that is not showing up because of a missing tag or something like that...
They ca also use the "generic" report as base for comparisions with localized P&L and BS.

@Martronic-SA
Copy link
Contributor Author

Here is the first release : #207

@github-actions
Copy link

github-actions bot commented Feb 6, 2022

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.

@github-actions github-actions bot added the stale PR/Issue without recent activity, it'll be soon closed automatically. label Feb 6, 2022
@sbidoul sbidoul added no stale Use this label to prevent the automated stale action from closing this PR/Issue. and removed stale PR/Issue without recent activity, it'll be soon closed automatically. labels Mar 14, 2022
@sbidoul sbidoul reopened this Mar 14, 2022
@MarcoCalcagni
Copy link
Contributor

Is there existing modules or any plan to create a module that would install two basic reports, the Profit & Loss and Bilan based on the default type of account (like the module accout_reports does)? Thanks

Hi, sorry for so late but you can have a look to this module in the Italian localisation. https://github.com/OCA/l10n-italy/tree/14.0/l10n_it_mis_reports_pl_bs

is in the Italian repo because the report is on the Italian chart of accounts .

@norlinhenrik
Copy link
Contributor

I have made generic accounting reports (PL & BS) based on mis_builder, for 14.0 and 17.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement no stale Use this label to prevent the automated stale action from closing this PR/Issue.
Projects
None yet
Development

No branches or pull requests

5 participants