Balance Sheet and Income Statement

(0) Share

Report

Posted on by Krazzy4

1,710

Can someone suggest how the balance sheet and income statement be created from the financial management menu - Navision v4.0?? I have seen some tutorials but it is little confusing.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

mmv 11,471 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Hi,

Account Schedules is a form with Matrix, which is used for configuring the Balance Sheet, Trial Balance, Income Statement, PL Analysis etc.

Best Regards,

MMV

Was this reply helpful? Yes No
Krazzy4 1,710 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

I have the Account Schedules in Analysis & Reporting folder. I think Account Schedules is a form.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Hi,

If you don't have the Account Schedule, you need to have a customized report. The Balance Sheet data will be purely from G/L Entry table.

Best Regards,

MMV

Was this reply helpful? Yes No
Krazzy4 1,710 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Thanks again for answers. I understood what to do. Can I have the following report format and is there any specific table id or multiple table id could be used to create the report:

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Check this :" Cash Flow Statement in Dynamics NAV - PaulsenConsult"

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Yes. Krazzy

You need to create 'Balance Sheet' and 'Income Statement' as there are no standard report because layout or format of those statements change from country to country or depending on statutes.

So using Account Schedules, you can design or pick the required GL Accounts to be used.

Was this reply helpful? Yes No
Krazzy4 1,710 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

I am really thankful to everyone for the answers. I think a balance sheet and income statement report should be created as I did not find any option for them in the financial management menu - Navision v4.0. For creating the report I may need to know the specific table id rather than form id. Actually I have to create the reports basically balance sheet where the standard accounting format should be included like fixed assets, liabilities etc with the total and individual amounts row-column wise. Same for the income statement report. It would be helpful if someone posts a tutorial or link from scratch to create those report specially for Navision v4.0 and no resources are actually found for that version.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Hi,

Account Schedule is available in NAV 4.0 (form id : 104).

Best Regards,

MMV

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Balance Sheet and Income Statement

Or go to www.cbsi-corp.com/.../07

This link is available

Go to "NAV2013_07_FinancialManagementAdvanced pdf file"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Balance Sheet and Income Statement

There is some problem while you click on this link directly..

Instead try to type the weblink from picture above.

Was this reply helpful? Yes No