Solved

Microsoft Great Plains questions

Posted on 2013-02-01
9
1,424 Views
Last Modified: 2013-02-25
We are using Microsoft Great Plains version 10.00.1238.000.

My user had the following questions.

Can we import a batch of invoices or journal entries into GP from excel? What is the format?
Can we get the address of the vendor printed on the check stub?

Thank you,

Justin
0
Comment
Question by:JustinGSEIWI
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
9 Comments
 
LVL 50

Expert Comment

by:jcimarron
ID: 38844479
JustinGSEIWI--I personally cannot answer those questions, but Great Plains has a built in tutorial
http://www.ehow.com/how_7866707_learn-great-plains-software.html

http://www.olemiss.edu/courses/accy310emet/gpstutor.pdf
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 38862587
Hi,

Yes, it is possible to import invoices or journal entries (or many other transactions) into Dynamics GP from Excel.  However, it requires an import tool, such as Integration Manager, eOne SmartConnect, or a custom .NET eConnect integration.  Those tools validate the data prior to import and ensure that all of the standard GP business logic is followed during the import.

There is no specific format for the source data file. As long as all of the necessary fields are present in the source data file, the import tool or application can map the source fields to the GP destination fields.

As for printing the vendor address on the check stub, I don't know for sure if that is possible.  My guess is that it is probably possible, but I haven't personally tried it, so I don't know if it is simple, or if it is tedious and involved.

Your Dynamics GP partner should be able to assist you with both of those topics if you wish to pursue them, or there are quite a few independent Dynamics GP consultants in the US if prefer that approach.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:JustinGSEIWI
ID: 38864019
Thank you.

I will look into getting one of the import tools.

As for the other question, I am still hoping someone may be able to answer it. We don't have GP support yet. we will eventually get it.

Justin
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:JustinGSEIWI
ID: 38881102
modus_operandi,

Can you call attention to this to have the last question answered?

"Can we get the address of the vendor printed on the check stub?"

Thanks,

Justin
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 38881625
Hi,

I inquired with a colleague, and she agreed that it should be possible to add the vendor address to the check stub.  The vendor address already appears on the check, so the fields are available.  It's just a matter of adding the same fields to the stub.  The only challenge might be formatting, as the stub is intended to display remittance info, so you'll have to set aside some space for the vendor address--the very top or bottom probably makes sense.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:JustinGSEIWI
ID: 38881712
I am not that familiar with GP. Can you tell me where to go to edit the formatting for the stub?

Thanks,

Justin
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 38881836
Hi Justin,

If you are not familiar with customizing reports using GP Report Writer, I do not recommend attempting to modify a check report.

There are quite a few considerations when modifying reports (dictionary locations, backups, dictionary locking, alternate report permissions, section formatting), so I recommend working with your GP partner or a certified GP consultant to assist you in making the change.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question