Microsoft Dynamics NAV (Archived)

Nav 2009 SP1 version W1 6 - Import G/L Journal from Excel

(0) Share

Report

Posted on by Fah777

http://www.dynamics.is/?p=77

above link contains a report that we’d like to have within our NAV 2009 system.

Could you please guide us as how to go about it?

waiting for you'll prompt response will be highly appreciated

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Fah777 54 on at

Like (0)

Report

and also I want's to know, is this purchase module or manual designed one

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

On the bottom of that post, there is a link for the object, you just need to import that object into your database and run it. It is a custom report you can change the object number accordingly.

http://www.dynamics.is/?attachment_id=82

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

As Suresh suggested there is attachment download available in the link itself

This utility can be used for transaction which are getting posted using G/L Journal. If you are posting Purchase transaction using G/L Journal then you can use this

Was this reply helpful? Yes No
Fah777 54 on at

Like (0)

Report

Thanks, can you tell me how to import? I'm not expert in NAV

import purpose is that require administrator or super user?

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

Download the ZIP file . UNZIP the same

Open the NAV 2009 Go to Tools--Object designer

Click on File--> Import--> Select the object you want to import.

Hope you are super user or Administrator

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Check This Link

msdn.microsoft.com/.../hh168275(v=nav.70).aspx

Was this reply helpful? Yes No
Fah777 54 on at

Like (0)

Report

Thanks for your all help and guide

Was this reply helpful? Yes No
Fah777 54 on at

Like (0)

Report

Thank you all for your help. I tried the above and it installed correctly. How do I enable that in the menu? I have no way of accessing it. If I go into >>Object Designer >>Reports and locate the line, when I click run it gives a " You do not have permission.." message. I am logged in as a superuser.

P.S. Sorry for taking so long to follow up, we had some server issues in the company and didn't want to try anything out until it was sorted out.

Was this reply helpful? Yes No
TonyMatt 510 on at

Like (0)

Report

You need to check your licence with your partner to see whether you have any free report no available to use. Then you need to renumber the report to the available no Or get the partner to assign the report no to your licence. Upload the new licence/restart nav services and then you will be able to use the report.

To enable the report in your menus --> Go to Menu Suite, find the suite that you use (mostly the ID with the highest no) -> Click on Design -> Choose the required menu on the left side --> right click and add --> enter the type as report --> Add the report no --> Ok and esc --> compile the menu suite

You can follow the below link with snapshots:

community.dynamics.com/.../how-do-i-add-reports-to-menus

If this helps, please mark it as resolved.

Regards,

Cecil

Was this reply helpful? Yes No