← Back to team overview

openerp-expert-accounting team mailing list archive

  1. openerp-expert-accounting team
  2. Mailing list archive
  3. Message #02171

Re: account_constraints check date in fiscal year

  Thread Previous • Date Previous • • Thread Next 
Hi

Just to amplify the third point below (highlighted)
Most companies are /*obliged */to produce comparative Movement Of Funds Statements (This Year compared to Last Year) 

To create such a statement, data is required from 3 years

 * Current Year
 * Last Year
 * Previous Year (Year Before Last)

Limiting the range of years to current year +/- 1 is not sufficient.
Nobody with any practical bookkeeping experience and a basic understanding of accounting principles is going to want to restrict the accounting period to which a transaction is posted to the nominal 'date' of the transaction. This causes distortions and violation of fundamental accounting principles relating to the matching revenue and expenditure.
Real world distortions arise frequently, especially at year end and with respect to capital expenditure and retentions. The transactions which are raised in order to normalise taxation expense are frequently complex in terms of involving multiple periods. 


Robin St.Clair
On 01/04/2014 20:48, INVITU wrote:

Dear all

What I understood is the following :
- some people want to check Date in periods (no entries with date outside of each period and of course there won't be any entries out of fiscal years) - some people wants to enter entries out of period (bank moves at end of period may have a date out of period) but in the fiscal year (some entries can be out of period, but stay in the fiscal year...) - *some people (i/e accounting experts) want to enter entries out of fiscal year but in that case, I suggest not to be "too much out" (+ or - 1 fiscalyear)* 

Best regards
Cordialement
--------------------------------
INVITU
Computer & Network Engineering
BP 32 - 98713 Papeete - French Polynesia
Tél: +689 46 11 99
contact@xxxxxxxxxx
www.invitu.com

*/P/*Please consider the environment before printing this e-mail!

Le 01/04/2014 08:44, Ferdinand Gassauer a écrit :

On 2014-04-01 16:12, Bidoul, Stéphane wrote:
Thank you all for the feedback and Frédéric for the detailed explanation on the functional background for this constraint.
I'll consider preparing a merge proposal to make the check optional depending on a flag on the journal (Check Date in Fiscal Year, similar to the existing Check Date in Period). 
May be I miss something
if "Check Date in Period" is successful "Check Date in Fiscal Year" must be successful too !? 



Best regards,

-sbi
On Mon, Mar 31, 2014 at 10:33 AM, Frédéric Clementi <frederic.clementi@xxxxxxxxxxxxxx <mailto:frederic.clementi@xxxxxxxxxxxxxx>> wrote: 

    @ Robin @DP ...

    Posting invoices/expenses to a prior period is still allowed
    what we want to block is to do this on a previous *fiscal year*.

    However, legally, you are correct there is not issue removing
    this constraint since this is the period which is important not
    the date.

    But, saying that, I do not count the number of times customers
    called us complaining about financial reports because they
    printed report by date and then by fiscal year and noticed
    differences.

    I have also been asked many times why webkit financial reports
    do not compute initial balance when date filters are used...

    It is a fact : Most of OpenERP finance users are not accounting
    specialist. Users expect adequation between date and fiscalyear
    (even period sometimes).

    OpenERP is great for its flexibility but for accounting purposes
    most people dare to make mistake and want a work frame.







    Cordialement,*



    *

    *camptocamp*

    INNOVATIVE SOLUTIONS
    BY OPEN SOURCE EXPERTS
    *Frédéric Clementi*
    Project Manager
    Business Solutions
    +41 21 619 10 41
    **
    www.camptocamp.com <http://www.camptocamp.com/>



    2014-03-31 9:35 GMT+02:00 Lorenzo Battistini
    <lorenzo.battistini@xxxxxxxxxxx
    <mailto:lorenzo.battistini@xxxxxxxxxxx>>:

        On 03/28/2014 05:17 PM, Bidoul, Stéphane wrote:

            Hi experts!

            In module account_constraints, there is a check that the
            date of the move is in the same fiscal year as the period.

            Here in Belgium I meet accountants saying that, while
            exceptional, it is perfectly valid to enter a supplier
            invoice with a date in previous fiscal year while
            forcing the period in current fiscal year.

            How would you recommend dealing with this situation?
            Should account_constraints be split in more granular
            modules implementing subsets of constraints so we can
            chose the one that are applicable in our regions?


        Hello Stéphane,
        otherwise, you could make the constraints optional, based on
        company or user group settings.

        Regards
-- Lorenzo Battistini 
        Tel (CH): +41 91 210 23 40 <tel:%2B41%2091%20210%2023%2040>
        Tel (IT): +39 011 198 25481 <tel:%2B39%20011%20198%2025481>
        http://www.agilebg.com



        _______________________________________________
        Mailing list:
        https://launchpad.net/~openerp-expert-accounting
        <https://launchpad.net/%7Eopenerp-expert-accounting>
        Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
        <mailto:openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx>
        Unsubscribe :
        https://launchpad.net/~openerp-expert-accounting
        <https://launchpad.net/%7Eopenerp-expert-accounting>
        More help   : https://help.launchpad.net/ListHelp



    _______________________________________________
    Mailing list: https://launchpad.net/~openerp-expert-accounting
    <https://launchpad.net/%7Eopenerp-expert-accounting>
    Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
    <mailto:openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~openerp-expert-accounting
    <https://launchpad.net/%7Eopenerp-expert-accounting>
    More help   : https://help.launchpad.net/ListHelp




_______________________________________________
Mailing list:https://launchpad.net/~openerp-expert-accounting
Post to     :openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
Unsubscribe :https://launchpad.net/~openerp-expert-accounting
More help   :https://help.launchpad.net/ListHelp



--
Ferdinand


_______________________________________________
Mailing list:https://launchpad.net/~openerp-expert-accounting
Post to     :openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
Unsubscribe :https://launchpad.net/~openerp-expert-accounting
More help   :https://help.launchpad.net/ListHelp




_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-accounting
Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-expert-accounting
More help   : https://help.launchpad.net/ListHelp

Follow ups

References

  Thread Previous • Date Previous • • Thread Next