Closing Statement

Savitha

Hi,

I am closing the accounting period by selecting all the dimensions.
As specified in the document, i am able to see all the entries grouped by account no. and dimension but the P&L Account has only 1 entry without any dimension. Is there any way that the profit is shown based on the dimension?

ssingla

For analysing Profit and Loss you should use Income Statement Account. AFAIK accounting will require consolidated entry in Profit & Loss Account (Balance Sheet Account)

Savitha

I think i was not very clear..
ok let me explain with an example.
Location is a global dimension, I want the separate profit or loss amount based on the location.
Eg:Loc1 is a dimension,Loc2 is another dimension value.
I want separate entries for Profit & Loss account attached with these dimensions.
Is this possible?

alsol

There are different possibilities:

1. you can run any financial statement or chart of accounts and set a flowfilter for the appropriate dimension. This gives you the P&L statement just for the selected dimension value.

2. If you have the Dimension Analysis in your licence, you can create an Analysis View and select the dimensions you would like to use for this Analysis (up to 4 different dimensions).

Then you have to update this view and run Financial Management -> General Ledger -> Analysis and Reporting -> Analysis by Dimension. Then select G/L Account as Lines and your Location dimension as columns and Navision shows a P&L statement per Location.

I hope this helps.

AdamRoue

I am presuming it is the actual posting of the retained profit here, you can close by dimension but the balancing entry to the defined retained earnings account is not split by dimension.

ssingla

I am presuming it is the actual posting of the retained profit here, you can close by dimension but the balancing entry to the defined retained earnings account is not split by dimension.

Correct. The system will not post the retained earning account dimension wise. Customization needs to be done to acheive this.

hant

ssingla wrote:

I am presuming it is the actual posting of the retained profit here, you can close by dimension but the balancing entry to the defined retained earnings account is not split by dimension.

Correct. The system will not post the retained earning account dimension wise. Customization needs to be done to acheive this.

Hi,

I am facing the same problem. My client need the closing transaction to be posted to Retained earning acct. seperately by dimension (Location). Could you please provide more detail about the customization? What do we need to customize?

Thanks and regards,

hant

hant

Hi all,

Does anyone can help me about this?

thanks,

hant

ssingla

You need to modify report 94 Close Income Statement in which a variable TotalAmount is defined and you need to modify the calculation of the same.