Announcements
how can we import a subsidiary ledger of supplier or customer in dynamics gp-2013
*This post is locked for comments
Well Zufli, glad to have lots of interesting questions today ...
I guess you are new to GP, right ?
Would you please explain a bit regarding your question, are you saying that you want to create new customers or vendors in Dynamics GP which are already on an Excel Sheet ?
Hi Zulfi,
To import open Payable and Receivable I would recommend macro in GP. If you have data in excel importing the data through macro in GP is very easy. And next option is using integration manager or econnect. Please check the following link which describe how to record a macro and import data from excel onto GP.
www.trideapartners.com/.../importing-data-into-dynamics-gp-via-macros-without-integration-manager
yeah right iam new to dynamics..and thx for every bit of help you people are offering to me.
here i want to import a subsidiary ledger of a customer from dynamics Gp to Excel.
or in other way you can say that exporting subsidiary ledger from dynamics GP to Excel...
As iam not being able to find a way to do this................
thx babu...for introducing to a new dimension ...........
I think you wanted to export fro GP payable transactions. On smartlist please use payable transactions and press excel on top to export the data to excel. please add filter current transactions not equal to zero.
yes i want to export the ledger directly into excel from dynamics....
the way you suggested will show me purchases not paid yet .
but i want to export ledger of supplier from dynamics into excel....
i used this way..........inquiry>purchasing>transaction by vendor>selected vendor id
it gives me detail of all the transaction with that vendor.....i think this is the ledger in dynamics
i want to export this into excel.
No Zulfi,
payable transactions will show invoices and payments made to the supplier which you can export to excel without any filter conditions.
thx babu
saying true that here we can export directly into excel.
but is there any way of exporting from the following route into excel
inquiry>purchasing>transaction by vendor>selected vendor id
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.
Hi Zulfi please verify so that it will get closed.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
Shravan Attelli 1
