BOFC: MJE+Carry over

[Former Member]

Hello BOFC experts

Could anybody tell about the best practice in use MJE + carry over. For example, i created MJE in 2009.12, then in 2010.01 i am running the consolidation (in definition indicated that openning balance = 2009.12). After that i have result of my MJE in F00 flow, but F99 not calculated. and i don't understand how i can reverse this MJE in 2010.01.

Thanks

[Former Member · Accepted solution]

Dear Pavel,

as a general rule, it is recommended to have your manual journal entries being automatically reported from prior years to current period (from opening to closing).

In a statutory consolidation process based on flows, previous years MJE should not impact the movements of the period, except indirect calculation like FX impact or change in scope applied on MJE amount (which are usually calculated by the system).

If for a given reason you have to reverse previous years restatements, you should book a new journal entry in the current period that offsets required amounts (through reclassification flow).

Regarding your issue (F00 not carried over to F99), you should chek your category scenario. It is usually related to two mistakes :

- in the accounts families section, you should chek that carry-over flow is activated for MJE context for the family that contains the accounts for which the F99 is not correctly calculated

- in the flows behavior, you should chek that when displaying the carry-over flow property, the F00 flow of the related family displays F99 in the table (and not a blank cell).

Hope this helps.

Regards

[Former Member · Accepted solution]

Dear Sébastien

Thank you for your answer, but problem don't solved.

Category Scenario settings are the same as you described: field "carry over flow" marked for all positions in Account families and in Flow behavior for F00 indicated flow F99 as carry over flow for all Account families.

When i am posting the MJE, flow F99 is automatically calculated as the sum of all flows, but when i am carrying over this MJE to the next year, F99 don't calculated.

[Former Member · Accepted solution]

Dear Pavel,

when you checked the carry-over contexts in the account families, did you click on the button called carry-over flow in the upper section or did you select the given account family, and then check the lower tab called carry-over ?

The upper button is used for defining the defaut behaviour of the carry-over contexts (applied to each new creation of a family, but not to existing ones).

The lower tab displays the "real" contexts in which the carry-over is activated for the selected family. It is here where you can change the contexts after a family has been created.

Regards.

[Former Member · Accepted solution]

Sébastien,

actually, i'm checking the lower section of Flow Behavior.

In MJE flow F99 calculated automatically! but after calculation of openning balance it doesn't work. I thought it might be a place, where the user can customize carry over flow for opening balance. just for the transferred balance

Regards, Pavel

[Former Member · Accepted solution]

Pavel,

the transfer of previous closing to opening balance is controlled in the flow behaviour section. However to activate the carry over of opening to closing flow you need to check the account families (as mentioned in previous post) in addition to flow behaviour. That is why I am insisting to make sure it is not related to a customization issue.

You mentioned that opening flow was calculated correctly. Where you able to retrieve a general leger detailing the flows of the period ? Could the opening flow be offset by an other flow (eg: F98, for outgoing entities) which leads to have no amount on F99 ?

Regards.

[Former Member · Accepted solution]

Sébastien,

More detail on the example:

Manual entry to reclassify debt

2009.12 -

Audit id = "AJE01"

Flow= "Net change"

Dt Long-term receivables 100

Cr Short-term receivables 100

Closing balance manual posting is calculated automatically based on Flow Behavior for the flow of "Net change"

2010.12 - the sum for the reclassification has changed and is 150

Opening balance has been posting the last year for 100

I believe there are 2 options:

1. Reverse posting on the previous year flow "Reclassification" and create a new one for $ 150. In other words - create 2 entries

2. Create a posting on the delta 50 (150-100).

But to those options work, the Openning balance of the current period should give effect to the closing balance immediately after the transfer. Mine is not working. this problem

Regards, Pavel

[Former Member · Accepted solution]

Dear Pavel,

could you make a test by booking a manual journal entry in the current period (same entity, audit-id, account as your MJE that is not working, but any flow), and see if at consolidated level the amount is correctly carried-over to F99.

Regards