Microsoft Dynamics GP (Archived)

importing of a subsidiary leger in excel....dynamics gp 2013

(0) Share

Report

Posted on by zulfi721

6,825

how can we import a subsidiary ledger of supplier or customer in dynamics gp-2013

*This post is locked for comments

All responses (18)

Answers (0)

zulfi721 6,825 on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

thx babu for the help
Suggested answer

babubaskaran@outloo... on at

Like (1)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

Hi Zulfi,

If you are the administrator and has SA password you can deploy the SSRS yourself. Please refer the following link from Ian explaining deployment. Please select Report Server Mode as Native and enter the SQL Server name on Report Server URL and Report Manager URL and follow the deployment. The 2nd link from Microsoft how to install and set up Microsoft SQL Server Reporting Services for use with Microsoft Dynamics GP reports.

community.dynamics.com/.../how-to-deploy-ssrs-reports-in-microsoft-dynamics-gp-2010-r2.aspx

www.microsoft.com/.../details.aspx
zulfi721 6,825 on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

HERE IS THE 2ND SCREEN SHORT FOR YOU.........AFTER HITTING OK
zulfi721 6,825 on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

Thx Frank....

its good to see you on board........

Here is the screen shot.....
Suggested answer

babubaskaran@outloo... on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

I agree with Frank please try to use SSRS for this purpose.
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

You need to use the SSRS version of the Aged Trial Balance. As Mikescal indicated, these reports may or may not be deployed in your system. If they are, you'll find them here in the Navigation Pane under the Purchasing Module. SSRS reports are easily exported to Excel. The SmartList won't give you what you're looking for because it's just a list of transactions, with no summarization by vendor.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

I would recommend Smartlist. The Excel export is much cleaner. If you are just looking for a list of transactions there's a standard Smartlist that you can export to Excel and filter on vendor. GP also comes out of the box with a number of SSRS and Excel reports. Your partner may or may not have deployed them for you as a part of the implementation. T
zulfi721 6,825 on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

BABU,

not as per the requirement.....
babubaskaran@outloo... on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

Hi Zulfi please verify so that it will get closed.
Suggested answer

babubaskaran@outloo... on at

Like (0)

Report

RE: importing of a subsidiary leger in excel....dynamics gp 2013

Hi Zulfi,

on this enquiry window please press print button which will take you to report destination in there file format select as comma-delimited file then press ok. this will create CSV file which you can open in excel but format wont be great you might have to format it.