Archives
Contributors
Auto Deferred Revenue Recognition ?
by Kitti Upariphutthiphong - 07:01 - 18 Apr 2020
Follow-Ups
-
Re: Auto Deferred Revenue Recognition ?
Thank you all again,I kinda like the account_spread_cost_revenue as it is quite small and intuitive to work directly from invoice. I have done a small enhancement that makes it cover the required case.Thanks!On Tue, Apr 21, 2020 at 4:17 PM <luc.demeyer@noviat.com> wrote:
Kitti,
In some cases the account_asset_managment module with methods number of end can also do the job.
Luc
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Tuesday, 21 April 2020 09:47
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Thank you all for your advice, I did find that https://github.com/OCA/account-financial-tools/tree/12.0/account_spread_cost_revenue is the more polished version of account_cost_spread.
Thank you Ostien for writing a good module and also good README too!
Still one point I like to add.
In this module, it does start with
- Invoice line account = Revenue
then, if use spread, the journal entry is automatically changed according to the spread.
- Dr: Account Receivable, Cr: Prepaid Revenue
And in the spread table will create journal entry
- Dr: Prepaid Revenue, Cr: Revenue
But in our case, we think following is more correct, accounting wise.
- Invoice line account = Prepaid Revenue -> at this point, may not yet know the target recognized account too.
- Dr: Account Receivable, Cr: Prepaid Revenue -> keep invoice line and move line the same, esp required for v13
And for spread table,
- Dr: Prepaid Revenue, Cr: Revenue
May be both case is possible. So I will try to propose the later case as a configurable option as enhancement. WDYT?
Thanks,
Kitti U.
On Mon, Apr 20, 2020 at 11:17 PM Frédéric Clementi <frederic.clementi@camptocamp.com> wrote:
With Alexis refactoring the cutoff modules will handle any dates. He should finish the module for v13 soon.
Don't reproduce the dependency on account assets, this is horrible for many reasons (see my comment here: https://github.com/odoo/odoo/pull/43198)
account_cost_spread is the closest to the Enterprise module as it does spreading.
camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
Frédéric Clementi
Odoo Consultant
Business Solutions
Le lun. 20 avr. 2020 à 15:12, André Schenkels <a.schenkels@ictstudio.eu> a écrit :
Isn't there a module account_cost_spread? This should do the trick.
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Monday, April 20, 2020 1:41:43 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Hi again,
I have played around with "account_cutoff_prepaid", and look into "account_perpaid_management".
Seem to me that, for account_cutoff_perpaid, it is working as its name, where, Invoice Line will record "Expense", which has "start" and "end" date specify its multi year. At the end of year, user can "cutoff" the "future portion of the expense" into next year.
In my case, I would need the Invoice Line as "Prepaid Expense", and at the end of year, recognize the past portion of prepaid expense into "Expense". This seems more inline with account_prepaid_management.
Stephance mentioned that, this one is using account_asset_management as sample. However, making this into OCA module is somewhat duplicated with account_asset_management.
So, I want to propose to enhance for Deferred Expense/Revenue into account_asset_management.
From what I saw in EE, Odoo S.A. also reuse the same Asset model, and make another 2 menus, Deferred Expense and Deferred Revenue, which make good sense to me. Except we already have something else already.
WDYT?
Kitti U.
On Sun, Apr 19, 2020 at 3:52 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you very much Stephane, Pedro, I will take a look at both.
Wish you guys stay safe too!
On Sat, Apr 18, 2020 at 3:42 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
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 - 01:40 - 21 Apr 2020 -
RE: Auto Deferred Revenue Recognition ?
Kitti,
In some cases the account_asset_managment module with methods number of end can also do the job.
Luc
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Tuesday, 21 April 2020 09:47
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Thank you all for your advice, I did find that https://github.com/OCA/account-financial-tools/tree/12.0/account_spread_cost_revenue is the more polished version of account_cost_spread.
Thank you Ostien for writing a good module and also good README too!
Still one point I like to add.
In this module, it does start with
- Invoice line account = Revenue
then, if use spread, the journal entry is automatically changed according to the spread.
- Dr: Account Receivable, Cr: Prepaid Revenue
And in the spread table will create journal entry
- Dr: Prepaid Revenue, Cr: Revenue
But in our case, we think following is more correct, accounting wise.
- Invoice line account = Prepaid Revenue -> at this point, may not yet know the target recognized account too.
- Dr: Account Receivable, Cr: Prepaid Revenue -> keep invoice line and move line the same, esp required for v13
And for spread table,
- Dr: Prepaid Revenue, Cr: Revenue
May be both case is possible. So I will try to propose the later case as a configurable option as enhancement. WDYT?
Thanks,
Kitti U.
On Mon, Apr 20, 2020 at 11:17 PM Frédéric Clementi <frederic.clementi@camptocamp.com> wrote:
With Alexis refactoring the cutoff modules will handle any dates. He should finish the module for v13 soon.
Don't reproduce the dependency on account assets, this is horrible for many reasons (see my comment here: https://github.com/odoo/odoo/pull/43198)
account_cost_spread is the closest to the Enterprise module as it does spreading.
camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS
Frédéric Clementi
Odoo Consultant
Business Solutions
Le lun. 20 avr. 2020 à 15:12, André Schenkels <a.schenkels@ictstudio.eu> a écrit :
Isn't there a module account_cost_spread? This should do the trick.
Verzonden vanuit Outlook Mobile
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Monday, April 20, 2020 1:41:43 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Hi again,
I have played around with "account_cutoff_prepaid", and look into "account_perpaid_management".
Seem to me that, for account_cutoff_perpaid, it is working as its name, where, Invoice Line will record "Expense", which has "start" and "end" date specify its multi year. At the end of year, user can "cutoff" the "future portion of the expense" into next year.
In my case, I would need the Invoice Line as "Prepaid Expense", and at the end of year, recognize the past portion of prepaid expense into "Expense". This seems more inline with account_prepaid_management.
Stephance mentioned that, this one is using account_asset_management as sample. However, making this into OCA module is somewhat duplicated with account_asset_management.
So, I want to propose to enhance for Deferred Expense/Revenue into account_asset_management.
From what I saw in EE, Odoo S.A. also reuse the same Asset model, and make another 2 menus, Deferred Expense and Deferred Revenue, which make good sense to me. Except we already have something else already.
WDYT?
Kitti U.
On Sun, Apr 19, 2020 at 3:52 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you very much Stephane, Pedro, I will take a look at both.
Wish you guys stay safe too!
On Sat, Apr 18, 2020 at 3:42 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Luc De Meyer. - 11:16 - 21 Apr 2020 -
Re: Auto Deferred Revenue Recognition ?
Thank you all for your advice, I did find that https://github.com/OCA/account-financial-tools/tree/12.0/account_spread_cost_revenue is the more polished version of account_cost_spread.Thank you Ostien for writing a good module and also good README too!Still one point I like to add.In this module, it does start with- Invoice line account = Revenuethen, if use spread, the journal entry is automatically changed according to the spread.- Dr: Account Receivable, Cr: Prepaid RevenueAnd in the spread table will create journal entry- Dr: Prepaid Revenue, Cr: RevenueBut in our case, we think following is more correct, accounting wise.- Invoice line account = Prepaid Revenue -> at this point, may not yet know the target recognized account too.- Dr: Account Receivable, Cr: Prepaid Revenue -> keep invoice line and move line the same, esp required for v13And for spread table,- Dr: Prepaid Revenue, Cr: RevenueMay be both case is possible. So I will try to propose the later case as a configurable option as enhancement. WDYT?Thanks,Kitti U.On Mon, Apr 20, 2020 at 11:17 PM Frédéric Clementi <frederic.clementi@camptocamp.com> wrote:With Alexis refactoring the cutoff modules will handle any dates. He should finish the module for v13 soon.Don't reproduce the dependency on account assets, this is horrible for many reasons (see my comment here: https://github.com/odoo/odoo/pull/43198)account_cost_spread is the closest to the Enterprise module as it does spreading.
camptocamp
INNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSFrédéric ClementiOdoo ConsultantBusiness SolutionsLe lun. 20 avr. 2020 à 15:12, André Schenkels <a.schenkels@ictstudio.eu> a écrit :Isn't there a module account_cost_spread? This should do the trick.
Verzonden vanuit Outlook Mobile
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Monday, April 20, 2020 1:41:43 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Hi again,
I have played around with "account_cutoff_prepaid", and look into "account_perpaid_management".
Seem to me that, for account_cutoff_perpaid, it is working as its name, where, Invoice Line will record "Expense", which has "start" and "end" date specify its multi year. At the end of year, user can "cutoff" the "future portion of the expense" into next year.
In my case, I would need the Invoice Line as "Prepaid Expense", and at the end of year, recognize the past portion of prepaid expense into "Expense". This seems more inline with account_prepaid_management.
Stephance mentioned that, this one is using account_asset_management as sample. However, making this into OCA module is somewhat duplicated with account_asset_management.
So, I want to propose to enhance for Deferred Expense/Revenue into account_asset_management.
From what I saw in EE, Odoo S.A. also reuse the same Asset model, and make another 2 menus, Deferred Expense and Deferred Revenue, which make good sense to me. Except we already have something else already.
WDYT?Kitti U.
On Sun, Apr 19, 2020 at 3:52 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you very much Stephane, Pedro, I will take a look at both.
Wish you guys stay safe too!
On Sat, Apr 18, 2020 at 3:42 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
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 - 09:46 - 21 Apr 2020 -
Re: Auto Deferred Revenue Recognition ?
With Alexis refactoring the cutoff modules will handle any dates. He should finish the module for v13 soon.Don't reproduce the dependency on account assets, this is horrible for many reasons (see my comment here: https://github.com/odoo/odoo/pull/43198)account_cost_spread is the closest to the Enterprise module as it does spreading.camptocamp
INNOVATIVE SOLUTIONSBY OPEN SOURCE EXPERTSFrédéric ClementiOdoo ConsultantBusiness SolutionsLe lun. 20 avr. 2020 à 15:12, André Schenkels <a.schenkels@ictstudio.eu> a écrit :Isn't there a module account_cost_spread? This should do the trick.
Verzonden vanuit Outlook Mobile
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Monday, April 20, 2020 1:41:43 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Hi again,
I have played around with "account_cutoff_prepaid", and look into "account_perpaid_management".
Seem to me that, for account_cutoff_perpaid, it is working as its name, where, Invoice Line will record "Expense", which has "start" and "end" date specify its multi year. At the end of year, user can "cutoff" the "future portion of the expense" into next year.
In my case, I would need the Invoice Line as "Prepaid Expense", and at the end of year, recognize the past portion of prepaid expense into "Expense". This seems more inline with account_prepaid_management.
Stephance mentioned that, this one is using account_asset_management as sample. However, making this into OCA module is somewhat duplicated with account_asset_management.
So, I want to propose to enhance for Deferred Expense/Revenue into account_asset_management.
From what I saw in EE, Odoo S.A. also reuse the same Asset model, and make another 2 menus, Deferred Expense and Deferred Revenue, which make good sense to me. Except we already have something else already.
WDYT?Kitti U.
On Sun, Apr 19, 2020 at 3:52 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you very much Stephane, Pedro, I will take a look at both.
Wish you guys stay safe too!
On Sat, Apr 18, 2020 at 3:42 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Frédéric Clementi - 06:16 - 20 Apr 2020 -
Re: Auto Deferred Revenue Recognition ?
Isn't there a module account_cost_spread? This should do the trick.
Verzonden vanuit Outlook Mobile
From: Kitti Upariphutthiphong <kittiu@ecosoft.co.th>
Sent: Monday, April 20, 2020 1:41:43 PM
To: Contributors <contributors@odoo-community.org>
Subject: Re: Auto Deferred Revenue Recognition ?Hi again,
I have played around with "account_cutoff_prepaid", and look into "account_perpaid_management".
Seem to me that, for account_cutoff_perpaid, it is working as its name, where, Invoice Line will record "Expense", which has "start" and "end" date specify its multi year. At the end of year, user can "cutoff" the "future portion of the expense" into next year.
In my case, I would need the Invoice Line as "Prepaid Expense", and at the end of year, recognize the past portion of prepaid expense into "Expense". This seems more inline with account_prepaid_management.
Stephance mentioned that, this one is using account_asset_management as sample. However, making this into OCA module is somewhat duplicated with account_asset_management.
So, I want to propose to enhance for Deferred Expense/Revenue into account_asset_management.
From what I saw in EE, Odoo S.A. also reuse the same Asset model, and make another 2 menus, Deferred Expense and Deferred Revenue, which make good sense to me. Except we already have something else already.
WDYT?Kitti U.
On Sun, Apr 19, 2020 at 3:52 PM Kitti Upariphutthiphong <kittiu@ecosoft.co.th> wrote:
Thank you very much Stephane, Pedro, I will take a look at both.
Wish you guys stay safe too!
On Sat, Apr 18, 2020 at 3:42 PM Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> wrote:
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by André Schenkels - 03:11 - 20 Apr 2020