Solved

Microsoft Great Plains questions

Posted on 2013-02-01
9
1,429 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

696 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