Anything marked with a λ requires access to either CustomerSource or PartnerSource. If you have questions about accessing CustomerSource or PartnerSource, check out this post by David Musgrave and Scott Stephenson.
Please note that some of the links below may not work anymore, as GP 10.0 is currently in Extended Support. If you find a link that’s dead, please let me know and I will either update it or remove it.
- GP 10.0 System Requirements λ
- GP 10.0 System Requirements for Web Applications λ
- GP 10.0 Printer Compatibility λ
- Updating to GP 10.0 λ
- GP 10.0 Installation Documentation λ
- GP 10.0 User Guides λ
- GP 10.0 Service Packs and Hotfixes λ
- GP 10.0 Product Releases λ
- GP 10.0 Service Pack Version List in PDF (updated for SP 5)
- GP 10.0 Complete Version List in Excel λ
- GP 10.0 Developer Documentation λ
- GP 10.0 Automated Solutions λ
- Microsoft Dynamics GP Application Level Security Series – by David Musgrave
- SmartList Builder Templates for GP 10.0 λ
- New Extender Functionality in GP 10.0 SP 4 λ
- GP 10.0 Modified Reports λ
- Dynamics GP Support Lifecycle – support dates for GP 6.0 through GP 2010
- Other Dynamics GP Links
Victoria Yudin 
Hi Victoria:
We have a problem for a Received Payment. I can search it by Customer, but it doesn’t show up when search by document number. My guess is the system was interrupted while posting the cash receipt.
Right now, the AR aging is correct, the invoice was paid (doesn’t show up on AR aging), but when I run commission report, this payment wan’t there.
I can’t void the payment since it doesn’t show up searching by document number. Could you shed some light on it?
Thanks,
Jan
LikeLike
Hi Jan,
This is likely something that cannot be solved without someone looking at your data directly. If you’re not able to resolve it, I would recommend asking your GP Partner for help.
-Victoria
LikeLike
Hi Victoria,
We are still using this version and cuurently we have 2.5TB of data since 2008. Is theres a way i could create a new company database and migrate only the specific tables from the old DB to the newly created database; then use this new database as my current one and live the old Database as an archive.
I know there is a Company Data Archive tool for GP, but this is too expensive and we are afraid it might corrupt the current Database.
LikeLike
Hi Noel,
You can create a new company and copy some of the setup tables, but no transaction tables, as they are all tied into many others. Then you can import open transactions/balances. To do this right requires a lot of planning and I would recommend working with a knowledgeable GP consultant if you decide to do this.
In the long run, this may actually end up costing more than purchasing the Company Data Archive product.
-Victoria
LikeLike
Dear Victoria,
From where I can download Professional Services Tools for Microsoft Dynamics GP 10. 0
Thanks,
Tanuja
LikeLike
Tanuja,
You will need to ask your Dynamics GP partner for it, I don’t believe it is available directly.
-Victoria
LikeLike
Hello,
I’m on my last hope posting to this board. After applying SP 5 to GP 10 ( i know it’s a super old version, but it works for what we need at the moment), we randomly have failures using the Integration manager to insert/update customer records. The insert generally have no problems, but occasionally the update records have been coming back with a “You must provide a Customer ID” error.
I have tracked this down to it throwing the error when it is trying to update the address record of the customer. Sometimes, the integration macro doesn’t populate the Customer ID field and that obviously needs to be populated in order to have a record to update.
I’ve gone as far as taking a bunch of failed update records and manually creating an import list matching it to the mappings in the integration, and that has worked, so I’m not quite sure where to look next.
This seemed to have started happening around the application of SP 5.
Hoping someone out there has some guidance.
Thanks,
John
LikeLike
John,
What is the source of your integration? What type of file or connection?
-Victoria
LikeLike
Hi Victoria,
It is a tab delimited text file.
LikeLike
John,
That should be the “safest” option. One things I have seen in the past is when special characters get into either the ID’s in GP or into your source data for the integration so that the ID’s are not actually the same. This is sometimes very difficult to track down because it’s not easily visible unless you start testing the data.
Another idea might be to confirm that you have the latest IM service pack installed for GP 10.0 – you can find it here: https://mbs.microsoft.com/customersource/northamerica/GP/downloads/service-packs/Integration_Manager_10_downloads_for_MicrosoftDynamics10
-Victoria
LikeLike
Unfortunately I don’t have access to that resource, as I don’t have a CustomerSource account.
As for Special Characters, that was one of my thoughts as well, but as I took a number of previously failed records from various source files and pasted them into a manually created source file, the integration worked fine for those tests.
I find that when the integration does fail, it typically fails at the initial (first) record in the source file, which is determined by the sort order on the import.
I’m pretty certain that I have all SP’s installed as I queried my versions against your list here: https://victoriayudin.files.wordpress.com/2010/09/gp-10-service-packs-with-sp-5.pdf
and my versions are greater then what you have listed.
GP: 10.00.1868
Dexterity: 10.0.332
IM: 10.00.1617
LikeLike
Hi John,
It sounds like you’ve checked what you can – the only thing you can do at this point is see if you can determine a pattern of when it fails. Perhaps it is tied to a user or group of users, machine, or even time of day.
If that does not help, you will likely need someone to work with you on it, maybe your GP partner or Microsoft support, to see if they can help narrow down the issue.
Sorry not to be of more help.
-Victoria
LikeLike
Hi Victoria, is there a way to change a customer from Balance Forward to Open Item, it gives an error that there aer unposted transactions
LikeLike
Hi Mike,
ARE there unposted transactions for the customer? I would actually not be surprised if it would not let you do this unless there were no open transactions for that customer.
-Victoria
LikeLike
Victoria ,
Hi im hoping you can help me.
I have GP10 and I have a user xxx who im not able to delete
I initially received the error “A get/change operation on table ‘SY_Current_Activity’ failed the record was already locked”
then i get
“A get change operation on table ‘SY_END_ROUTINES_CHECK_MSTR’ failed accessing SQL data”error.
when i check the activity table im not seeing this user in the table.
LikeLike
Omar,
As a start you can try getting everyone out of GP and restarting the SQL Server services. That will clear any record locks.
However, I have seen cases where for various reasons you just cannot delete users in the GP application. In that case you can delete the user directly in SQL from each database. Once you’ve done that you can typically delete the user from GP with no issues.
-Victoria
LikeLike
Victoria,
tried that and still cant delete the user.
we have 3 different GP10 servers with 1 shared database and that user has access to about 8 companies in GP10. I only want to take that user out of 2 companies. But these two companies are not accessed from this particular server where i unable to delete the user from. the user would normally use the other server to access these companies in GP10 and i guess it was a user error and they used that server to access the two companies
LikeLike
Omar,
In that case, it is likely best to get support for this either from Microsoft or your Dynamics GP Partner. I have always been always to fix this type of issue in SQL, but without seeing what is happening and what you’re trying to do, it’s very difficult to help.
-Victoria
LikeLike
Hey there! I’m having an odd problem with Integration Manager and sales transactions. I am testing an integration with one customer, and a sales transaction with 9 line items. The thing works great … except that it uploads 9 invoices. Not 1 for each line item, 9 duplicate invoices which are all correct. I have no idea where the issue lies. Anyone encountered this before? Thanks for reading!
LikeLike
Andrew,
Usually you need a header file with one record per invoice and a detail file with a line for each line item to accomplish an import like this. Then the trick is to link them properly. Not sure if this is something that can easily be solved in a blog comment without looking at your integration setup. But at the very least, start with making sure you have 2 source files, like I have described, and check the link between them.
-Victoria
LikeLike
Hi Victoria:
I think you have a wonderful blog and you have provided all sorts of helpful tips for me. I have a question. When drilling down from the Account Inquiry window, you can click the Journal Entry link to pull up the Journal. However, when drilling down to the Source Document, a totally different document is displayed and not the source document that created the transaction. This is so sporadic and doesn’t happen with all accounts. Any ideas on how to correct this?
LikeLike
Hi Supermario,
This only happens once in a while? Or it always happens for some accounts? Can you reproduce it at will?
-Victoria
LikeLike
I know that it only happens for certain accounts. And yes, I can generate this at will.
LikeLike
If you can recreate this at will and it’s only happening for certain accounts, you may want to talk to your GP Partner or GP support to see if they can help you figure out what’s going on. This is certainly not a known issue and without seeing it or knowing anything at all about your GP environment, I am not sure how to even begin to troubleshoot this.
-Victoria
LikeLike
Thanks Victoria! Turns out it was that stupid .ini file that needed to be changed. I forget the line item, but it needed to be changed from True to False. ARRRGGHHHHHH.
LikeLike
Hi Victoria,
Which table would I be able to get the data for the screen, “Match Shipments to Invoice Inquiry Zoom”
This is the Actual Landed cost applied to the items in the Invoice.
help Highly appreciated.
Thanks,
Farman.
LikeLike
Farman,
According to the Support Debugging Tool, the following tables are used on that window:
-Victoria
LikeLike
Hi Victoria, I am hoping you can help me, In the past week we have come across two Accounts Payable error’s that I am unable to come up with a proper solution.
Let me preface this by saying we do not use AR module (we do have license) the only modules we really user are Financial and AP.
1)The same EFT banking information was entered for two different vendors. One vendor got paid twice while the other never received a check. THe AP clerk automatically voided the EFT (a month later when it was uncovered) even though payment was sent to wrong vendor, the correct vendor was invoiced in payables. This created a bank reconciliation nightmare, as we were unable to select that EFT as clearing since it was voided?
2) Next similar issue, again payables is correct and this time a check was sent to the wrong vendor (lockbox) and it was cashed and this time reconciled. They sent us back a check. I need to reissue the check to the correct person which I can do a manual check but it will always be listed as open as the invoice was already applied.
If you can provide any help to help me fix the AP and Bank REC I would appreciate it.
Thanks so much!!
Have a great day.
LikeLike
Hi Fran,
While these two issues should not be too terribly difficult to fix, it would be really difficult to do so in blog comments. You’ve given a lot of information, but I would have probably a dozen questions on each of these issues and going back and forth on this without actually seeing it in GP or having all the information would be a very frustrating experience for everyone involved. The best way to get this resolved is to work with your GP Partner so that they can take a look at your system and help you come up with a solution, as well as explain it to you so that you can do this on your own in the future.
-Victoria
LikeLike
Hi Victoria,
In order to release the PO to the vendor in GP we are printing a SSRS reports that are already build, instead of printing a a default GP report, the thing is that after the report is print it will not change the PO status to released, if you could kindly let me know what would be the best way to do this that would be great.
Appreciate all your help.
Farman
LikeLike
Hi Farman,
One thing you could do is base your SSRS report on a stored procedure that includes code to update all the PO statuses, etc., when the report is printed. Keep in mind that if you are purchasing inventory items that track quantities there are also inventory tables that gt updated when you print a PO in GP.
Another option is to use a product my company makes – GP Reports Viewer – to replace the PO’s in GP with your SSRS report. Our product will ensure that all the status and inventory updates that GP would process when you print a PO happen, it would also give you a way to replace any GP report with your own SSRS report.
-Victoria
LikeLike
Thanks a Lot, I will check and let you know. Appreciate all the help.
Farman
LikeLike
Hi Victoria,
I am new to GP. Your blog is very helpful
I am facing a problem in financial module. I wanted to track a document source. Following is the problem:
We are using GP 10. In Financials > Transactions > General i see one journal entry with document no is 199261. In the source document field it is showing ‘GJ’ and in the reference is showing INVRCT-2012/013250′ The batch is showing ‘GLTRX015675’
We wanted to know from which module this Journal is created and wanted to trace the source of this document. I suspect this came from inventory module, but i want to see the originating transaction.
Appreciate your help
Srinivas
LikeLike
Hi Srinivas,
Looks like you have also posted your question on the GP Community Forum, I posted an answer there. https://community.dynamics.com/product/gp/f/32/t/82652.aspx
-Victoria
LikeLike
Victoria
Yes. I also posted on GP Community form.
Thanks for your help.
Srinivas
LikeLike
Hi Victoria! Just wanted to start off by telling you how helpful your blog site has been to my job. The fact that you can explain both the user side and technical side of GP is amazing. My question is our work has upgraded to GP 10 last year since we were planning on switching to Windows 7 which we’ve recently done, and I’m noticing that my GP 10 seems to be crashing more often; have you heard of this issue before? When I asked our IT support to look into it, they found a whole bunch of errors saying “the program Dynamics.exe version 10.0.324.0 stopped interacting with Windows and was closed”. Any insights? Thanks! Kathryn.
LikeLike
Hi;
Would anyone know which table the information in the “Edit MO Status” reside?
Thanks
Rod
LikeLike
We use GP 10 and Accounting Receivable told me that in customer payment Summary window, most of customer year-to-day and Life-to-day data are not accurate. I run the utility sales reconcile for current customer, fiscal year and calendar year for these customers and nothing updated. Please give me some suggestion and thanks
LikeLike
Richard,
If your Life to Date numbers are not correct, then there is an issue – those should always be right. Is it possible that they are changed manually or that an initial import of open balances was not performed properly when you implemented GP?
Year-To Date and Last Year numbers are typically going to be off in most companies, as those are governed by your year end close and whether or not you even perform one in the AR subledger. Dynamics GP KB Article 851140 has some more detail on this.
-Victoria
LikeLike
Dear Victoria,
I got following error in SOP line item transaction entry window.
” A Price cannot be found for Item xxxxx. Because the system is setup to require prices, you must remove the Item.”
I am using extender pricing in GP10.
Plaese guide me how to resolved it ?
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
I don’t work too much with Extended Pricing, so I am not sure if there is a separate setup for the pricing requirements there, however standard SOP setup has an option for ‘Price Not Required in Price List’. You can either check that to allow entering items without prices already set up onto Sales Transactions, or you can add the item pricing first, prior to entering the items on the SOP transactions.
-Victoria
LikeLike
Dear Victoria,
Thanks I will try.
Tanuja
LikeLike
Dear Victoria,
How to get Profit and Loss statment report in GP?
When I checked in fabricam, the report is there but inmy live company it is not showing ? Can we get this report from report writer or FRX or crystal report ?
Please guide me which is easy way ?
Also how can I get Income statement (Actual for single month) report ?
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
I prefer FRx for financial reporting. I would recommend getting some training for FRx either from your GP Partner or using ELearning on CustomerSource.
-Victoria
LikeLike
Dear Victoria,
I have this report in FRX also. But my manager wants this report from GP itself.
I tried using advanced financial but it was not taking calculation like minus and multiply.
Please can you guide me on this issue.
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
I do not work with AFA. If you absolutely have to do this in AFA, then I would recommend getting some training on it from your GP Partner or Microsoft.
-Victoria
LikeLike
Dear Victoria,
I got following error, when I tried to post previous year JV in GL transaction.I don’t have access to server. So How can I give a permission? Is it possible thro GP itself ? Please guide me.
“[Microsoft][ODBC SQL server][SQL server] create table permission denied in databse company_name”
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
Posting something in GP should not be looking to create a table. Not sure what exactly is going on, but this sounds like there is a more global issue. I would recommend talking to GP support or someone that can take a look at you GP installation and troubleshoot this for you.
-Victoria
LikeLike
Dear Victoria,
Thanks I will check with them.
Regards,
Tanuja
LikeLike
Dear Victoria,
I have this report in FRX also. But my manager wants this report from GP itself.
I tried using advanced financial but it was not taking calculation like minus and multiply.
Please can you guide me on this issue.
Thanks & Regards,
Tanuja
LikeLike
Hi Victoria,
One of our Financial team members has asked me to turn on the automatic exection of “Average Days to Pay” calculation.
I am told it was a scheduled job and it is no longer running.
I have searched hi and low for info on the scheduling of Average Days To Pay and I have have not found a thing.
They do not want to run this manually, so I need to come up with something for them.
Also, if I can just run a stored proc as a mssql job, that would be great!
I currently do this for Aging.
Any help on this would be great.
PS. I had a demo of Company Data Archive from Professional Advantage. It looks like it will do what I need. I have a test key and will try it next week in my test environment. Thanks for the tip!
Gene
LikeLike
Hi Gene,
Unless you have some kind of a customization for this, Average Days to Pay is built into GP and gets updated automatically each time an invoice is paid for a customer. I do not know of any way to turn it off or on.
-Victoria
LikeLike
Hi,
In GP10, We are using multicurrency functionality. One of my checkbook is showing difeerence between current checkbook balance and current cash account balance in checkbook balance inquiry report. This difeerence is because of exchange rate.We are converting with current exchange rate.So we found difference in cash book account. How to resolved it? Please inform me what is the functionality behind this calculation.?
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
I recommend posting your questions on the GP community forum, you will have more people reading them that may have experienced a similar situation.
-Victoria
LikeLike
GP10, Data Retention Schedule
HI Victoria, Of all the info I have read about GP, yours is always the best! I am a DBA, our company uses CRM and GP with Scribe integration. I have been tasked with purging OLD/Useless data. That is, Customers that have not made a purchase for 7 years or more or have never made a purchase. So, round one was easy. If the customer had never made a purchase, I was pretty much able to create a PURGE group and update the CUSTCLAS to PURGE and bulk remove them. However, a few of these had a child that did make a purchase and checklinks showed me the error of my ways. So, I refined my purge group. All is well. The problem is, how do I purge customers with history! I obviously need to remove all history before I can remove the customer, but I have not found anything about this on-line, less 1 post by you where you suggested moving all of these customer cards into a single archive customer. I thought about this one, but our company wants to PURGE data for legal reasons. We only want 7 years of history. Any help on this subject would be great! I have to believe others are doing this in type retention scheduling? Be well and thanks for so much info you have provided me and others! Can’t wait to get your book! Gene
LikeLike
Hi Gene,
Thank you very much for the kind words!
I hear what you are saying about just getting rid of history…but in my experience, anyone that ever got rid of history, later wanted something from it. 🙂 So…that said, I think you have 2 options:
Hope this helps,
-Victoria
LikeLike
Thanks Victoria,
Company Data Archive from Professional Advantage looks interesting. I have requested a demo.
I know what you mean about purging history.
In fact, it was a hard sell on me, but with changes in state laws and data privacy and discover etc. It is something that must be done. We had to destory old backup tapes because we had legacy data with SSN# unencrypted, even though the backup was encrypted and password protected. We need to be compliant!
Thanks again,
I will play with Remove Transaction History as well and see if that resolves my issues as well. ( free option is always good! )
Gene
LikeLike
Hi Victoria,
I am trying to decifer what accounts are included in GP10 Metrics Total Sales and Gross Profit. I have tried several combination of accounts and none seems to match the number in the Metrics window.
I appreciate if you can help me with this.
Jose
LikeLike
Hi Jose,
There is a KB article that lists out the details for the metrics: https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb$en-us$918263. This states it is for GP 9.0, but I think for the most part there will not be too many differences in GP 10.0.
-Victoria
LikeLike
Thank you vey much!!! it helps a lot!
LikeLike
hi Victoria,
in GP 9.0, under Navigation>>Administration>>All Reports list. Do you happen to know if there is a way to get this listing of reports in SQL or maybe export to Excel? There does not seem to be a way to get around it?
Jeff
LikeLike
Hi Jeff,
I do not believe this is actually stored in SQL, it’s in the dictionary (.dic) files. The report lists gets created as a temp table when you open that list.
-Victoria
LikeLike
Thanks Victoria!
i was able to finally locate that temp table during runtime and got the listing i wanted.
appreciate your response as always!
LikeLike
Victoria,
First, thank you for this resource. Your blog has been a tremenous help in the past.
Currently I am confronted with adding a new machine to an existing installation. They are at 10.00.1237. Your table indicate that I need to apply service pack 3 after installing the base package, but I have not been able to locate service pack 3.
What are my options?
Thank you,
Harry Berman
LikeLike
Hi Harry,
You should be able to find Service Pack 3 here: https://mbs.microsoft.com/customersource/downloads/servicepacks/MDGP10_Previouspatches.htm.
-Victoria
LikeLike
Thank you for the file location information. I applied the service packs to bring the system up to 10.00.1237 to match the existing installations but when I start GP it wants to update the database. What could cause this? Do I need to reinstall the service packs on the other machines?
Thank you very much for your help,
Harry Berman
LikeLike
Harry,
I am guessing you’re not getting this message anywhere else? That would indicate the computer that you are on has the issue, not the other machines.
SP 3 for GP 10 is not 10.00.1237 – that is a hot fix after SP 3. Here is a link to the entire list of versions including hotfixes: https://mbs.microsoft.com/downloads/customer/MDGP10_MSPVersionList.xls. ALL of your GP installations must match exactly, otherwise you will run into a problem.
-Victoria
LikeLike
Victoria,
You are correct the issue is only on the new machine. I applied all of the elements in the service pack/hot fix list to bring the new machine up to 10.00.1237 so all of the machines’ revision numbers match.
Can I assume that this installation of GP includes some module left out of the other installations so a database upgrade should not affect the machines already sitting at 10.00.1237? Is there a way to determine why the system thinks database updates are in order?
Thank you for your perseverance,
Harry Berman
Harry
LikeLike
Harry,
Yes, you are probably right that this installation includes components or products not installed on other machines (or the server). However, I don’t think it’s safe to assume that running through the ‘upgrade’ will not affect anything else. I think it would be better to remove the unused components from the new installation so that they are not causing this issue. Compare your Dynamics.set file from an existing machine running GP without any issues to the Dynamics.set file on the newly installed machine. What is different?
-Victoria
LikeLike
Dearest Victoria:
I just inherited a machine with GP10 installed. However noone knows the “sa” password. I’m new to the GP I hear that there is a SQL script that can be ran to reset the “sa” password. Does this ring a bell with you? I tried searching ParterSource but to no avail. Thanks in advance.
LikeLike
Teresa,
Are you sure you mean the ‘sa’ password, which is the SQL Server system administrator? Not the ‘GP system’ password, which is specific to GP? If you are talking about the SQL Server ‘sa’ password, you should be able to reset that directly in SQL Server, as that has nothing to do with GP. If you’re talking about the GP system password, yes there is a way to both find it or reset it to blank, but I am not comfortable giving someone ways to get around passwords without knowing they are authorized to do this. I would advise that you talk to either GP support or your GP partner who should be able to verify you are authorized to do this and to help you with it.
-Victoria
LikeLike
Hi Victoria,
I am getting this error while installing SP1 for GP, any ideas
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct update patch.
Tried the knowledge base to reapir the installation and then try it but nothing happend.
Thanks,
F
LikeLike
F,
It’s possible that you have a bad file, so you could try downloading the service pack again. I also recommend that ALL installations be performed when logged into Windows as the local/built-in administrator. If neither of those help, I would recommend posting this on the GP Customer forum or starting a support incident with GP Support.
-Victoria
LikeLike
Hi,
Is there any way to push data into Purchase module – Return Transaction entry? I cannot find any e-connect nodes for Purchase Returns. Please help..
LikeLike
Divya,
I do not believe there is an eConnect schema for Purchase Returns.
-Victoria
LikeLike
Thanks Victoria , Is there any other way to push data into it?
LikeLike
You could create your own import into the SQL tables to accomplish this.
-Victoria
LikeLike
We have Dynamic GP 10.0 for 6 users, Windows Server 2003 R2 and SQL Server 2008, all workstation was working fine, but from the last Friday one workstation is working very slowly, the GP login in that machine takes 10 minutes, the other application are normally running. Do you know what the problem is?
Thansk,
Patricia
Azteca Distributors
LikeLike
Patricia,
Unfortunately this could be caused by many different things. There is no one problem that would cause this for everyone. Click here for a link to a GP Knowledge Base article listing some things that should help you troubleshoot.
-Victoria
LikeLike