This page is a compilation of links for my resource pages and other downloads that I typically find myself looking up.
As the individual sections on this page have grown larger, I have started moving them off to their own pages. These individual pages can be accessed by clicking the links below or by hovering over Resources on the top navigation bar.
Microsoft Dynamics GP Resources
Dynamics GP
Includes general Dynamics GP links to lists of versions, support dates, IM versions and other generic Dynamics GP resources
GP 2018
Includes system requirements, documentation, support lifecycle information, and other useful links for Dynamics GP 2018
GP 2016
Includes system requirements, documentation, support lifecycle information, and other useful links for Dynamics GP 2016
GP 2015
Includes system requirements, documentation, support lifecycle information, and other useful links for Dynamics GP 2015
GP 2013
Includes system requirements, documentation, support lifecycle information, and other useful links for Dynamics GP 2013
GP 2010
Includes system requirements, documentation, support lifecycle information, and other useful links for Dynamics GP 2010
GP 10.0
Includes system requirements, documentation, service pack versions, support lifecycle information, and other useful links for Dynamics GP 10.0
GP 9.0 and older versions
Includes documentation, service pack versions, support lifecycle information, and other useful links for Dynamics GP 9.0 and older versions
Other Resources
Management Reporter & FRx
Includes service pack versions, download links and other useful information for FRx and Management Reporter
SQL Server
Includes service pack versions, support lifecycle information, edition comparison and other useful SQL Server links
Book Recommendations
- Crystal Reports: Crystal Reports Encyclopedia Volume 1: Professional XI Reports
- Dynamics GP 2013: Microsoft Dynamics GP 2013 Implementation by Victoria Yudin (yep, that’s me)
- Dynamics GP 2010: Microsoft Dynamics GP 2010 Implementation by Victoria Yudin (that’s me, too)
- Dynamics GP 2010: Microsoft Dynamics GP 2010 Cookbook by Mark Polino
- HTML code help: HTML Goodies (2nd Edition)
- Dynamics GP development: Developing Microsoft Dynamics GP Business Applications by Leslie Vail
Miscellaneous
- Adobe Acrobat product comparison
- Adobe Acrobat support dates
- CPU Benchmarks
- Crystal Reports documentation
- Crystal Reports service packs and versions
- Microsoft Product Lifecycle Search
- Microsoft Office suites comparison
- Microsoft Office Compatibility Pack
- RAM, Virtual Memory, Pagefile and all that stuff
- Windows 7 – installing GP – by David Musgrave
- Windows 7 edition comparison chart
- Windows Mobile versions comparison chart
- Windows 10 edition comparison
- Why can’t I run GP over a WAN? – by David Musgrave
New to Dynamics GP and amateur at SQL, your work has been very helpful.
Thank you
LikeLike
do you know a way to auto apply sales documents en masse without having to do this one customer account at a time? the staff doing our data entry didn’t realize that credit memos were not applying to invoices and our receivables aging analysis is out of whack due to all of the unapplied cash.
LikeLike
Hi Scotty,
I am not aware of any way to do this in GP out of the box. They will have to be cleaned up manually.
However, if the immediate issue is the aging and the fact that unapplied credits are not aging properly, you can change your Receivables module setup to have the unapplied credits age. Go to Microsoft Dynamics GP | Tools | Setup | Sales | Receivables — check the checkbox to Age Unapplied Credit Amounts. I believe you will want to run an aging after changing this setting to have the GP aging buckets automatically updated (if you are using the aging shown on GP windows).
-Victoria
LikeLike
Thanks for the suggestion. I really appreciate your blog!
LikeLike
one of my client wants to track NSF vs voids but doesn’T want to charge fees. THe NSF functionality obliges us to put an amount. Is there a way to circumvent the fee?
LikeLike
Hi Dominic,
I think you have 2 options: (1) use the VOID option instead and put a note on the transaction – this lets you have the option of reporting using the notes, if needed or (2) enter an amount for the NSF, it can be $0.01, then write off or credit the NSF debit memo that is created.
Hope that helps.
-Victoria
LikeLike
Hi Victoria,
In GP 10.0, I am using Average Perpetual as my inventory valuation method. It seems that the average cost is calculated based on the total inventory of an item across all site IDs. I would like it to calculate average cost independently across site IDs as I don’t want transactions in one site to affect average cost in another site. Do you know if this is possible in my current version of GP?
Thank you so much! Your blog has been extremely helpful to me and my team!
LikeLike
Hi Kyle,
Thanks for your kind words. Unfortunately, GP always calculates inventory cost regardless of site. This does not change in any version of GP that is currently out, so it’s not a limitation of your older version.
From what I have seen, companies needing to control the item costs better are using FIFO and turning on either lot or serial number tracking. That allows them to accurately link the proper cost layers to each sale, but does add additional steps to transaction entries in some cases.
-Victoria
LikeLike
Hi Victoria,
I have a client that wants to modify the AR Trial Balance in GP. They what to show only the current balance of an invoice that has a partial or short pay and not the Invoice and payment below. They are using the AR Trial Balance with Options . Do you have any advise or comments on the best way to address this modification. I was look for kb 912126, but cannot find it.
Thank you very much for considering my question.
LikeLike
Hi Tammy,
I can’t help with doing that in Report Writer. But I know I have created custom reports like that many times. You can use my Current Receivables Aging Detail code to create this as a SmartList or another report for your client.
-Victoria
LikeLike
Hi Victoria, I am having an issue with GP2015 SP2.
I have a users with 5 reminders that run smart lists. These take about 90 seconds on login.
This user also uses a few simple short cuts. Sales Transactions Entry, Item History etc.
After login, this user can use ANY of the short cuts with no delay. ( the first time ).
However, selecting a second shortcut ( even the one just opened ) it takes 90+ seconds to load. I have run a trace and it looks like the smart lists are running when selecting a shortcut. This makes no since to me. MS does not consider this a bug. They want $$ to trouble shoot performance issues. I have deleted the links and re-added them. No luck.
Has anyone else seen this? Thanks Gene
LikeLike
Hi Gene,
I have not seen anything like this behavior. I would recommend posting this on the Dynamics GP Community Forum to see if anyone else has seen this before.
-Victoria
LikeLike
Thank Victoria,
I’ll try that. Still digging in the sy01990 for now.
LikeLike
Hi Victoria – Not sure this is the right place to post this question. I have two customers setup in GP. They are affiliated. One customer wants to use a credit their account to offset an invoice on the other customer’s account. Is there a way to transfer a credit from one account another or link two customer accounts together? If not what do you suppose is the best way to handle this transaction?
Thanks for the help.
LikeLike
Hi Kevin,
There is a module called National Accounts that can be helpful for ‘related’ customers and lets you set up a ‘parent’ and ‘child’ customers. With that set up, you can apply payments and credits from the parent customer to invoices of the child customers. However, National Accounts will still not let you apply a credit from one ‘child’ to another.
To do that, I would typically create a credit memo for one customer and a debit memo for the other to basically ‘move’ the amount needed. For both the debit and credit memos one side will be the AR account, for the other side you can use a suspense account. When both are posted there will be a net 0 change to the GL and AR subledger.
Hope that helps.
-Victoria
LikeLike
Hi Victoria
I have noticed the transaction date on the MDA SmartList looks incorrect. I believe this is because of the view showing the GL trx date it appears to pick up the PL (or maybe SL if someone is using it) transaction date instead.
This means the summary enquiry balance and summarised SmartList downloads produce different totals.
Have you seen this before or has anyone else mentioned it? I assume the view needs fixing somehow.
Regards
Ian
LikeLike
Hi Ian,
Sorry, I have not seen this be an issue previously. Have you checked to make sure the data is correct in the DTA10100 table? Also, not sure what you mean by PL and SL?
-Victoria
LikeLike
Victoria, do you have any recommendations for a Dynamics GP reseller/partner?
LikeLike
Hi Darryl,
Sure! My company, Flexible Solutions, is a Dynamics GP reseller/partner. 🙂
-Victoria
LikeLike
Can you please send me your companies contact information?
LikeLike
Hi Darryl,
I will email you directly.
-Victoria
LikeLike
Hi Victoria
This is a fantastic resource thank you so much. I am looking for some code to link GL Tables to MDA tables ie DTA tables. I want to link each GL transaction to the appropriate DTA entries. You may already have it here on your site but I could not find it in a search. Many thanks Trish
LikeLike
Hi Trish,
I don’t have any MDA code posted, but I have created some MDA reports in the past. I believe you should be able to link the MDA tables to the GL tables on the following 3 fields: JRNENTRY, SEQNUMBR and TRXDATE. Hope that helps.
-Victoria
LikeLike
I’ve noticed that on the remittance for a check that it will also include the invoice and payment from a previous check. How do I keep that from happening?
LikeLike
Nicole,
You can uncheck the Print Previously Applied Documents on Remittance checkbox on the Payables Management Setup window.
-Victoria
LikeLike
Thank you!
LikeLike
Hi Victoria.
A new employee posted a whole series of invoices by checking the drop ship box instead of allocating (100 Plus). Any ideas of the best way to fix this as the Inventory has not been relieved and the System has posted to the drop ship account.
Any help you can provide is appreciated.
LikeLike
Hi Tom,
Looks like you’ve got some great advice from Leslie here:
https://community.dynamics.com/gp/f/32/t/106216.aspx#.UZH7GrUcdUR
-Victoria
LikeLike
Hi Victoria,
any idea if there is any tool/module which we can use to keep track of all the changes which has been made to all the open orders till it become historical?
LikeLike
Zafar,
Auditor possibly, I have not used it, so I cannot recommend it. Sometimes we create custom triggers and tables to keep track of changes that are fairly contained, but to track every field would take some work.
-Victoria
LikeLike
Hi Victoria,
Thank you so much.
LikeLike
Hi Victoria, it seems I am able to post only on this page.
Hi Victoria,
We are noticing for some time that whenever we transfer a sales order to invoice for dropship items then the system changes the cost to another value. We would like the system to get the cost as it was in the order (sop type =2). Kindly advise if it can be done through some GP setting.
LikeLike
Hi Zafar,
I am not aware of any setting to prevent this. Ultimately, the cost may be changed again once you actually post the invoice, so even though the order or invoice are showing a cost, it may not be the one that gets posted. But if you’re looking for this to be the same for reporting or inquiry purposes, that might require a customization.
-Victoria
LikeLike
Any idea from where the posted invoice gets the cost instead of getting it from the SOP10200 table
LikeLike
Zafar,
I would have to test this out to make sure, but I think that when you originally create an order, whether it is a drop ship or not, the item shows the current cost from the inventory module. For drop ships, once you have posted the associated vendor invoice and then transfer the order to the invoice, the cost on the invoice will be cost from the vendor invoice. For non-drop ships, the cost when the invoice is posted will be the cost of the inventory at the time of the invoice, which will be determined based on each item’s valuation method.
-Victoria
LikeLike
We had a similar requirement to maintain costs and use Vendor Price Management product from Trinity USA to accommodate (http://trinitypartner.com/modules/purchasing/)
Stu
LikeLike
Hi Stu,
Thank you so much.
LikeLike
Hi Victoria,
Thank you so much for your explanation. So if want the system to keep the items cost as it was entered in the order from SOP10200 table while posting the invoice then we need to do some customization through vba file?
LikeLike
Zafar,
Customization, yes. VBA? I don’t know. We do not typically work with VBA, and tend to recommend Dexterity customizations, but a lot may depend on available resources.
-Victoria
LikeLike
Hi Victoria,
Thank you so much.
LikeLike
Hi Victoria,(My apologies for posting this comment here as due to some reason my browser is not allowing me to post comments on Inventory Table page)
We want to remove some (more than 100) items from a price level.Is it safe to delete those items directly from Table IV00108? Please note that those items have no sales history for that price level.
LikeLike
Hi Zafar,
Sorry to hear about not being able to post on the Inventory Tables page. I am going to test that and see what’s going on – can I ask what browser you are using?
To answer your question, I think it should be fine to remove these from the IV00108 table, but I would also remove them from the IV00107 table to make sure you have no orphaned records.
Also, even if the price levels were on posted transactions deleting them after the fact would not cause any problems.
-Victoria
LikeLike
Hi Victoria,
Thank you so much. You are the best.
LikeLike
Dear Victoria,
Is there any option in GP 2010 to restrict users from selecting Site ids or part numbers. I want to stop some of my users from accessing items from perticular site id.
LikeLike
Sreejith,
I do not believe you can do this without a customization.
-Victoria
LikeLike
Hi Victoria
Not sure how to start a post, so click a reply to get to you.
A purhase receipt was interrupted when the network was disconnected. So the stock is partially updated, ie items in 1 purchase order is patially or half updated and another one was totally not updated. Item stock for these items do not have the purchase receipt number. Thus, sales cannot retrieve the stock to sell.
We have done checklinks and reconcile but no change. Smartlist cannot retrieve this particular receipt in the purchase module. The GL has been generated but not posted.
Please advise what else can be done to have it posted properly or how to void this transaction. Appreciate your reply.
LikeLike
Hi Elizabeth,
Since Check Links and Reconcile did not fix this, most likely it will need to be fixed in the tables. I would recommend contacting your Dynamics GP Partner or Dynamics GP Support so they can help you with this.
-Victoria
LikeLike
Oh dear, this is bad news. Our Support did not even mention that this can be fixed in the tables. We thought that was it and may have to live with this error in the system.
LikeLike
I’m trying to post manual payments and am getting the error message below. Can you tell me how to correct this so I can post payments?
Unhandled database exception:
A save operation on table ‘PM_Distribution_HIST’ has created a duplicate key.
Thanks,
JoAnn Cass
LikeLike
JoAnn,
There is a blog post by David Musgrave addressing duplicate key errors that might help: http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/12/05/identifying-duplicate-transactions.aspx.
-Victoria
LikeLike
Victoria,
Do you have any App recommendations for Customer/Vendor portals and Online Bill Pay for customers that tie in with GP?
Thank you
LikeLike
Hi Jason,
Not sure about customer/vendor portals, but for Online Bill Pay, take a look at Azox.
-Victoria
LikeLike
Hi Victory,
In GP 10.0 we created and printed a purchase check, when I try to post, GP shows a message “This batch is being edited by another user. Please try later”, but anybody has that batch. How can I fix this error?
Thanks,
LikeLike
Hi Patricia,
Have you tried the fix in KB Article 850436?
-Victoria
LikeLike
Yes, I tried the fix it deleting the table in that article, but the error continues.
Patricia.
LikeLike
Patricia,
Check batches are tricky. If it’s really stuck, you may need to work with GP support or your GP Partner to help with this – I would not feel comfortable helping with this without seeing it.
-Victoria
LikeLike
How can i modify posted/unposted “Journal Entry Numbers”.?by mistake i enter wrong journal entry number while doing yaer end closing.The wrong JV entry continued for some posted/unposted transactions.I want to clear it…Please help me…Victoria
LikeLike
Belraj,
In the General Ledger you cannot change posted journal entries. There may be some options involving deleting history or changing data directly in the database, however this is not something I would usually recommend, it is most likely better to leave them as they are. For unposted journal entries, you can delete them, change the next journal entry number in the GL setup and re-enter them. If these came from other modules in GP, you will lose the link between the subledger and GL that allows for drilldown, so you have to consider which is more important, the right journal entry number or the drilldown functionality.
-Victoria
LikeLike
Hi Victoria,
First of all, let me thank you for setting up such an informative site online.
I have a peculiar problem with one of our customer.
While printing the check, the system is also printing the applied vouchers on the check stub. But the problem is, if there are more than 12 applied vouchers, the system will pick only 12 and display it in the check stub which will end up showing a different amount in the check stub and another amount in the check.
Please help me to resolve this issue,
Best Regards,
Renjan
LikeLike
Renjan,
What should normally happen when there are more than 12 entries for the check stub is that after your check batch is printed instead of the Post Payables Checks window you will get a Process Payables Checks window, where you will have the option to print the Remittance Form – this should be printed on blank paper and will print the rest of the entries that were not able to fit on the check stub. The remittance form together with the check stub should add up to the total on the check. If this is not happening or you still have trouble with this (or if you are using a 3rd party product to print checks), you may want to consider getting some training on the check printing process from your GP Partner.
-Victoria
LikeLike
Hi Victoria,
I have an issue when i attempt to post. The multicurrency management report indicates the following error message:
The rate type id is missing
The exchange table ID is missing
I checked both the Rate Type and Exchange table and both are referencing the correct information. This is an interco company so i don’t know if that will affect it in any way. Not sure what else i can do. Any help is greatly appreciated. Thank you.
LikeLike
Kevin,
Sounds like there may be an issue with the Rate Types setup. Go to Tools | Setup | Financial | Rate Types, pull up your exchange rate table and make sure only one Rate Type is selected for it.
-Victoria
LikeLike
Hi Victoria,
i checked and only 1 rate type is selected.
Kevin
LikeLike
Hi Kevin,
Sorry, that is the only cause I have seen for the error you’re getting. I am not sure what to tell you without looking at the setup. You could try posting your question on the GP Community forum to see if others have some additional ideas for you. Or talk to GP support or your GP partner to see if they can connect to your system and help find the problem.
-Victoria
LikeLike
Victoria,
No problem i found a work around to fix the issue temporary. But i just encountered another issue. Entered in the payable in the interco company and now receiving the following error message:
Transaction is not balanced and cannot be saved
LikeLike
Kevin,
Is that exactly how the error message is worded in GP? Because that is not what I get if I put an unbalanced transaction in, so I am wondering if there may be a 3rd party product or customization involved?
-Victoria
LikeLike
Hi Kevin
I am just wondering if you could advice me the work around that you used to fix this issue with error in Edit list.
“The rate type ID is missing. The exchange table ID is missing.”
Thanks in advance
Priyanki
LikeLike
Hi Victoria,
I have an issue on void hostorical trx’s window, i cannot see purchasing Trx’s on void historical Trx’s window from 1/3/2011, can you advice me?
Thanks
marry
LikeLike
Marry,
Are you sure the transaction is historical? If so, make sure you are looking for it by the document number, not the date or the voucher number.
-Victoria
LikeLike
Hi Victoria,
I wanted to know the purpose of ‘Report Processing Status’ window in GP 2010. I have never used it before.
Thanks,
Pooja
LikeLike
Hi Pooja,
I am not sure what you’re referring to, when does this window come up for you?
-Victoria
LikeLike
Hi There;
Let me first thank you for putting up such fine site on the internet. I have been coming to this site almost every day for the past few weeks to find information on GP.
I am hopping that you could help me understand how data move from one table to another in Manufacturing–> 3rd Party –> MRP tables.
I am trying to query all my planned demands and supplies for all my products in order to develop a comprehensive report fo rboth planning and purchasing purposes.
Many thanks in advance.
LikeLike
Hi Rod,
Thank you for your kind words!
I do not work with Manufacturing, so I cannot help with those tables. As a first step, I would recommend taking a look at the SDK for additional information on this – there is a whole separate section for Manufacturing in there. Once you have some specific questions, maybe try posting them on the GP Customer Forum, I believe there are a few consultants that work with Manufacturing that read and answer questions there.
-Victoria
LikeLike
I am having a problem with credit memos not printing on my check stubs to which credit memos have been applied to specific invoices. It is only happening with a couple of vendors. Any ideas? I was also wondering if you knew a good way to get a report that shows which credit memos have been applied to invoices by vendor.
Thank you for your help with this.
LikeLike
Hi Pam,
With typical GP setup, credit memos will print on the next check printed after they have been applied. However, at the time of creating the check the users can change what shows up on a check stub for each individual check. I have not seen this working ‘selectively’, only for particular vendors, and cannot think of a setting in GP that can cause this. It’s module-wide setup, not vendor specific. Is it always the same vendors? What’s different about these vendors? Can you reproduce this in a test company/environment?
To see what invoices credit memos are applied to you can use my AP Apply information view.
-Victoria
LikeLike
Hi,
I am getting following error when I click on generate report in FRX .It is showing exporting page0.
Please can you help on this error.
Thanks & Regards,
Tanuja
LikeLike
Tanuja,
Have you tried printing report to the FRx Drilldown Viewer instead of exporting it?
-Victoria
LikeLike
Hi,
When I tried from FRx Drilldown Viewer, it was showing same error. When I tried with different user it was working fine.So i want to know this error is because of security or something wrong with my FRx Drilldown Viewer ?
Thanks & Regards,
Tanuja
LikeLike
Yes, if one user can do something and another cannot, that is most likely security. If there was something wrong with the application, it would typically not work for any user.
-Victoria
LikeLike
Hi,
Thanks I will check with my head office.
Thanks & Regards,
Tanuja
LikeLike
For FRx issue, check your printer mappings and make sure your users are not using dual monitors.
LikeLike
Is there a way to pull a customer list with the shipping address?
LikeLike
Hi Mike,
Check my blog a little later today (around 8:30am EST) and I will post a view for this.
-Victoria
LikeLike
Hi Victoria:
We just upgraded from GP9 to GP 10. Is there a way to set the GP settings to print seperate GL posting journals when posting a Sales Batch? I remember in GP 9 everything printed seperately when posting sales posting journals , the general ledger posting journals printed separately. Thanks
LikeLike
Hi Lancaster,
As far as I know there is no change to how the posting reports behave between GP 9.0 and GP 10.0. If you have not made any changes to the posting setup during or after your upgrade, the reports should behave the same way they did in 9.0. This is all controlled by the settings on the Posting Setup window (GP | Tools | Setup | Posting | Posting). Please be VERY careful when making changes on this window, this controls not only reports, but also the behavior of all transaction posting in GP.
-Victoria
LikeLike
Dearest Victoria:
I just inherited a machine that has GP10 installed with SQL 2005. There are three instances of SQL and I can tell which one is the GP instance. However, I am unable to log into GP with the “sa” password. I do have acces to SQL Management Studio. I ran a query to change the “sa” password and still was not able to log into GP. My question for you is: Do I need to reinstall the SQL 2005 GP instance or can I just reinstall GP and move forward? I’m trying to circumvent the need to reinstall SQL. Any help you can offer would be GRRRRRRRREEAT!! As always, I am your most thankful fan!
LikeLike
Hi Teresa,
I always consider reinstalling a last resort. You should be able to change the ‘sa’ password in SQL Server Management Studio. Here are instructions: http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/.
-Victoria
LikeLike
Dearest Victoria:
I gladly implemented your suggestions. Thanks soe the response. I was able to change the “sa” password but I am still unable to log into GP even after stopping and restarting the services. After entering my password, the GP screen just sits and I check the task manager, the process is not responding. I do not get an error message. I also took a look at the SQL error logs and didn’t notice anything particular except that some lines call for me to run the RECONFIGURE statement to install. I am unsure of what this means.
Is there anything else I can try? If not, what would you suggest as far as the Best Practices process for uninstalling and reinstalling GP? Can I still use the same instance or will I need to reinstall my GP instance within SQL 2005? As always, gratefully yours!
LikeLike
Teresa,
Reinstalling the GP application will not have any impact on being able to use the ‘sa’ password in GP. ‘sa’ is a SQL Server login, so while GP uses ‘sa’, it does not have any way of controlling or changing anything about ‘sa’. So my guess is that there is some other issue. It could be anything from a setting missing in SQL Server to a completely trashed installation and many things in-between. If this is just a test machine, you might want to consider simply starting from scratch. If there is room on the hard drive, install a new instance of SQL Server, then a new instance of GP. You don’t necessarily have to uninstall anything.
Something else to consider – if you’re not familiar with SQL Server and GP and are just learning, asking questions on a blog is perhaps not the best way to learn. You will pick up bits and pieces of information, sure, but it’s not really what you need and will most likely not be very helpful overall, especially when it looks like you’re stalled from the start. I would recommend getting some training or at the very least reading a manual. Or you might also be interested in my book on implementing GP.
-Victoria
LikeLike
Thanks Victoria! I think I’ll take your suggestion and reinstall my instance and GP. ALSO, I’m buying the book this weekend!! Thanks much.
LikeLike
Teresa,
Great, thanks!
-Victoria
LikeLike
Dearest Victoria:
I have a payables management issue that I need to pick your brain about. The PM subledger and GL used to balance. Now it doesn’t and the balance is growing. I’m in the process of troubleshooting why and the first thing I thought of were discounts. Is there anything else I should be thinking of before I begin the painstaking manual recon? Any help is most appreciated. Thanks!!!
LikeLike
Teresa,
I would take a look at the voided transactions. A lot of times they do not go into the period you think they should. If that doesn’t help, figure out what period and year you started to not reconcile – for that first month, see if you can find a transaction with the same amount as the difference. If you get lucky, it was just one transaction and you can find it easily.
For another idea, take a look at the Stefanie’s comment from October 6th on my blog post with a SQL view for Payables apply detail and GL distributions in Dynamics GP. Maybe you can do something similar.
-Victoria
LikeLike
Hi Victoria,
I would like to know if there is a table within Great Plains that will show me all of the checks that have been marked as cleared within the Bank Reconcilation module? We download a bank file using “Electronic Reconcile” which automatically marks the checks cleared in Great Plains. The last file I downloaded had 8,354 checks that were cleared and somehow an extra check number was manually marked in GP and I need to find that one and deselect it. I want to compare the checks that have been marked to the original download file. Any assistance that you can provide would be greatly appreciated.
LikeLike
Yolanda,
I believe all of this information is in the CM20200 table. My Bank Rec tables page might have some additional helpful information.
-Victoria
LikeLike
Vistoria,
Are the GP Service packs incremental updates ie. If i have to update from SP1 to SP4 do I have to go by one by one or I can directly apply SP4
Thanks a lot
Farooq
LikeLike
Sorry GP 10
LikeLike
Hi Farooq,
All service packs for the GP versions out today are cumulative (as opposed to incremental). So you do not need to go through multiple steps, you can go directly from SP 1 to SP 4.
-Victoria
LikeLike
Thanks Victoria, I appreciate it
also how would it work if I have a GP database with different account structure and needed to embed in our environment
Eg: Database DBD – GP10 SP1 – would integrate it to GP 10 SP4 environment, what would be the steps and would the GL accounts integrate properly
LikeLike
Farooq,
Just to be clear what you mean by ‘account structure’ – there is the account format which determines the GL account structure for every GP company and the account framework , which is selected when GP is initially installed and what determines the maximums for the account format. If you mean the account format is different, as long as the account framework is the same, that should not matter. However, if the you are asking about a different account framework, there is no easy way to do this.
Your options are:
1. Purchase the Reformatter tool from Corporate Renaissance.
2. Pay Microsoft Professional Services to do this for you.
3. Spend a LOT of time and effort (or consulting money) to have someone do this ‘manually’.
I would recommend option 2 above – they can help you with this entire project, including the steps to integrate the new database into your existing environment.
Here are a few recent forum posts on this topic you may find useful:
http://community.dynamics.com/forums/p/39749/71253.aspx#71253
http://community.dynamics.com/forums/p/36422/64138.aspx#64138
-Victoria
LikeLike
Victoria – hoping you can help because my queries in CustomerSource result in no hits (and maybe it’s because of the new format, not sure). Here’s my problem: We’re on GP9.0, I have a voided payables transaction in the PM80300 table, and yet, in the PM30200 table, the VOIDPDATE (for the exact same voucher number) is still showing as 1900-01-01 and the value in the VOIDED column of PM30200 is 0…and still, the transaction is in the PM80300 table and the amounts for the voided transaction were posted in the GL. (the batch was interrupted during posting, but resolved that – or so I thought).
When I do an inquiry on the supplier, the voucher still appears as HIST instead of *HIST. I ran checklinks and reconcile, and still, the voucher is not displaying as it should and it is also not reporting correctly in the aged trial balance, which is now off from my payables control account by exactly the amount of the voucher that “should be” voided. Have I hit a wall and need help from our partner and or Microsoft, or do you have ideas on what else I could do to resolve this issue?
LikeLike
Kristie,
Sounds like your void did not finish posting. I would verify that it’s not sitting in Batch Recovery, then run Check Links and Reconcile on the Purchasing series. If none of that works, you may need to get your GP Partner or Microsoft involved to help you clean this up in the SQL tables.
-Victoria
LikeLike
Thanks Victoria – looks like it’s time to reach out to Microsoft, because checklinks and reconcile did not do the trick. Thanks for your help, your site is a resource I will keep nearby.
-Kristie
LikeLike
I’m not sure if this is the correct place to ask a question but here’s my problem:
We have GP 9.0 and when we do a large check run we have to void a dozen or so because the remittance schedule doesn’t match the amount paid.
Example the check amount is for 14,734.05 but at the bottom of the check stub it only shows four line items for a total of 9,175.70. When the vendor is re-selected and the check is reprocessed, the correct check amount is still 14,734.05 and now all seven items show up in the remittance section with the correct total of 14,734.05.
This is intermittent since we first went on GP back in 2007 and only happens with checkruns over 150 checks.
Memory issue?
LikeLike
Julie,
Not necessary memory, but certainly resources of some sort. The short (and free) answer, of course, is smaller check runs. If this is something that you need to fix, it would most likely require a detailed inspection of your environment. I am curious about 2 things:
-Victoria
LikeLike
We use Mekorma software and SafePay.
I’ll have to check out the apply information versus the printed information. I didn’t think about that.
Now that they have voided and re-run the checks, I’ll have to wait until it happens again.
LikeLike
Hello Victoria
I started 2010 without closed 2009, I have transactions in Receivables, Inventory, Payables and G/L, now according, this is our first year in GP and we are learning it in the hard way. Do you know anybody that have a tool to run the end year process in this cases?
Thanks
LikeLike
Gustavo,
While some summary inquiries may not show correct numbers, there should be no major issues with not having closed 2009 prior to posting 2010 transactions. Most companies that we work with do this. You can perform the close for the modules you need to now. Take a look at this blog post for additional information and resources on the year end close for various modules: https://victoriayudin.com/2008/11/14/year-end-close-in-dynamics-gp/. If you are unclear on some of these concepts, I recommend getting your GP Partner involved to help you go through the close for the first time and answer any concerns you might have.
-Victoria
LikeLike
Victoria,
I was attempting to post a refund check and the batch created is now stuck. When I went to batch recovery I receive the following error message: A save operation on table ‘PM_Transaction_open’ has created a duplicate key. How do I find and clear this duplicate key so I can get the batch posted and the refund check cut?
Thanks,
Joann
LikeLike
JoAnn,
There is an automated solution for finding duplicates in payables tables. Here is the main page for automated solutions: https://mbs.microsoft.com/customersource/support/selfsupport/AutomatedSolutions.htm, navigate to your GP version, then look for Payables Management in the list.
-Victoria
LikeLike
I got a similar error
Can I just rebuild the PM Keys Master table to fix this in V10?
LikeLike
Jim,
I am not sure how rebuilding the PM Keys Master will help if you have a duplicate transaction. You can certainly try it, but I would not expect that to fix the issue.
-Victoria
LikeLike
Hi Victoria
Fisrt let me say thank you for all the wonderful help you give everyone.
I had the same error and recompiling the the PM Key Master Through the SQL tools in the GP menu corrected the issue for me.
Chad
LikeLike
Victoria
The GP help for Payroll Management Report Summary include a list of report to verify the 1099 forms that are not available under the Purchasing Analysis Reports, how can I download those reports?
Thanks
LikeLike
Victoria
I have an issue with 1099 forms,
I updated the Vendor information and run “Update 1009 Information” and run the “Reconcile” option under Utilities, but when I tried to print nothing is coming out
Thanks
LikeLike
Gustavo,
For 1099’s the answers are sometimes specific to your environment and very different depending on the GP version, as GP 10.0 introduced a lot of additional functionality in this area. All of this makes it very difficult to answer these kinds of questions in a blog comment. Since it looks like you have a number of questions and issues with 1099’s, I would recommend scheduling some time with your GP Partner to go through 1099 training and the questions that are coming up. You could face penalties if 1099’s are not filed properly, so it’s important to do this right.
-Victoria
LikeLike
Victoria
I was in the process to update the Tax rates and received this error
Microsoft DynamicsGP TaxEngine
“VB Error found: retrieving the com class factory for component with CLSID [8c3e4934-9fa4-9253-a29a05f99186} failed due to the following error 80040154”
Thanks
LikeLike
Gustavo,
I have not seen this error before with GP. I would recommend asking GP Support on this one or posting on the GP newsgroups to see if anyone has run into this error before.
-Victoria
LikeLike
Hello Victoria
I am working in the NSF transactions and I read the help and tried to run a test, however when I input the transaction for NSF the system prompt and error “Please specify a default NSF charge posting account before markink the cash receipt as NSF”
I couldnt find where I can set the default account for NSF charge
Could you help me?
Thanks
LikeLike
Gustavo,
The NSF posting account can be specified by going to Tools > Setup > Posting > Posting Accounts, choose the Sales series under Display to make it easier to find – it’s called ‘NSF Charges’.
-Victoria
LikeLike
Hello Victoria
Could you give me some information about how can I process a NSF checks? I want the transaction to affect Clients, G/L and Bank Reconciliation
Thanks
LikeLike
Gustavo,
GP has built-in functionality to enter NSF checks. To start you would go to Transactions > Sales > Posted Transactions. To get more help on how to use the NSF functionality, you can click F1 once on that window or consult the manual for the Receivables Management module.
-Victoria
LikeLike
Hi all – excellent resource this.
We are fairly new to GP. What suggestions do others have and what do organisations do to accommodate the process of package import? Is there a command line/script option? We had a number of customisations done and it is becoming unwieldy to have to visit all workstations when minor modifications and updates are made to these.
Any insight is greatly appreciated.
Regards
Stu
LikeLike
Stu,
David Musgrave has 2 great articles on this on his Developing for Dynamics GP blog:
-Victoria
LikeLike
Hi Victoria,
I am trying to convert business license information from great plains to another database. I am not able to find how the Social Security number is linked to any of the Business information. Can you help here?
LikeLike
Hi Ethan,
I am not quite sure what you’re asking – can you please explain in more detail?
-Victoria
LikeLike
GP has tables to track business license information, i.e. BL001 which holds the business name, license number and other info. In the UI of GP, it somehow links a FederID/SocSec from somewhere. I have not been able to find this column in any of the BL tables, so I am assuming that it is pulling this information from another table within GP. I have searched for answers online, but so far, you are the best resource out there on GP.
LikeLike
Ethan,
I am not familiar with a GP module called Business License or any tables in GP that start with BL. And if ‘BL001’ is truly the name of the table that does not sound like a GP one, since usually GP tables are something more like BL00101, with 7 or 8 characters. Is it possible this is a 3rd party product or a customization? If so, that might explain why you are not able to find anything on this and you would most likely need to go to the source of the product to get the details you are looking for. 😦
-Victoria
LikeLike
Hi Victoria
I have an invoice posted in GP version 9 that the expense and payable accounts both show the type as PURCH. The transaction is now in history and I am unable to cut a check for the invoice. How do I clear this or fix it so I can get a check cut?
Thanks,
JoAnn
LikeLike
Hi JoAnn,
This sounds to me like the invoice was possibly entered with a $0 total. If you zoom to the detail of the invoice, what is the Purchases Amount? What is the On Account amount?
-Victoria
LikeLike
I apologize for not responding sooner. The purchase amount shows $0 and the on account amount shows $0. Is there any way to void this transaction out now or do I repost the whole invoice?
Thanks,
JoAnn
LikeLike
JoAnn,
The On Account amount determines what goes into the Payables subledger and is what you owe the vendor. If the On Account amount is zero, then this transaction is not recording anything owed to the vendor. And if the only distributions are all of type Purch, then basically this transaction accomplished the same thing as a GL entry. I would be curious to know why it was entered this way – was it a mistake or on purpose?
In any case, there is no way to void this, since you can only void ‘credit’ payables transactions, however, if you wanted to reverse what this did you can enter a GL entry to reverse the GL distributions. To be able to pay the vendor for this invoice, you have to re-enter it correctly, with an On Account amount that is not zero.
Hope this helps.
-Victoria
LikeLike
Hi Victoria,
Which Company offers the Functional GP classes in Orange County for Great Plains.
Thanks
Farooque.
LikeLike
Farooque,
I believe there is an Orange County in at least 3 states, CA, FL and NY. Not sure which one you’re asking about, but here is a link to all Dynamics GP classes and exams offered by Microsoft: http://learning.microsoft.com/manager/Catalog.aspx?clang=en-US&dtype=Catalog&Sort=PublicationDateDescending&page=1&cats=%7b132be102-9975-4462-a895-ca5a6d643857%7d%3a%7b9279d462-dd42-4002-9c9b-503616c03bd1%7d. Hope that helps.
-Victoria
LikeLike
Thank you for the quick response. It was an error that the invoice was posted that way.
LikeLike
Hi Vistoria, I have a question for you regarding the GP Process Server. Is there any information you can share with me for setting this up? I understand from within GP how to specify the server but the actual setup and installation I am struggling with. I cannot seem to find any good docs for install on GP 10 process server. If you can help I would greatly appraciate it.
Best, Matt
LikeLike
Hi Matt,
There is a section in the GP System Administrator’s Guide on Distributed Process Server – this is the only documentation out there that I am aware of.
-Victoria
LikeLike
So do you know if a process server is installed just as a client then? This is pretty poor documentation in terms of the install itself. I cannot seem to find anything intuitive around where the installs live disk 1 disk 2 some sort of additional download…
LikeLike
Matt,
According to the GP Installation manual, yes, it is a client install. I would recommend 2 courses of action of you need more information: 1. Ask your GP Partner or GP Support. 2. Post your questions on one of the GP newsgroups where you are going to reach a much broader audience with varying experiences.
-Victoria
LikeLike
Victoria,
Do you have any articles on Creating Business Alerts in Great Plains 10.
Farooque.
LikeLike
Farooque,
I do not currently have any posts about creating Business Alerts. There are several chapters on Business Alerts in the Dynamics GP System Setup manual – that’s the only documentation I am familiar with.
-Victoria
LikeLike
Victoria,
I’m working on a Bill of Lading (BOL) to Invoice project for my company and needed some GP insight. Overall, we want to automate our invoicing process to automatically create an invoice from each BOL generated. Do you know of a way to handle this directly through GP or does it require a custom app (such as a 3rd party app)? Thanks in advance for any help.
-Shane
LikeLike
Shane,
For many companies that I have worked with a Bill of Lading is simply a report that gets printed either together with or right before the invoice. There is no GP ‘transaction’ that by itself is a Bill of Lading. So your sales process may be something like: Quote > Transfer to Order > Print Packing List > Print Picking Ticket (and/or Bill of Lading) > Transfer to Invoice. If you need something more complex, I would strongly encourage you to work closely with your GP Partner to develop a workflow specifically for your company. There are a lot of possibilities in Sales Order Processing and it usually takes some experience to navigate through all the options and setup to accomplish the desired results.
-Victoria
LikeLike
V,
I don’t think linking to the select statement as RT will accomplish what you’re trying to do – I would look to do it in the main select statement with a CASE that sums the transactions into different columns based on transaction dates. You might also need additional logic depending on other variables, like whether your last fiscal year is closed or not and whether you want this for the fiscal year or calendar year.
-Victoria
LikeLike
Hi Victoria,
The running total should be the running total of the functional currency column, as it stands at the end of the previous month. In my script it appears to the be the running total of the current month.
Regards
V
LikeLike
Hi Victoria,
I have created a script that shows the total currency amount and functional amount for each account based on the transactions in the GL20000 as of the month before the system date.
However the running total column is showing the wrong value.
Can you please cast your eye over the script below and see where I have gone wrong. Any help would be much appreciated.
Thank you
SELECT TOP (100) PERCENT CASE WHEN accSetup.PSTNGTYP = 0 THEN ‘BS’ ELSE ‘PL’ END AS PostingType, accNum.ACTNUMST, accSetup.ACTDESCR,
accTran.CURNCYID, SUM(accTran.ORDBTAMT – accTran.ORCRDAMT) AS CurrencyAmount, SUM(accTran.DEBITAMT – accTran.CRDTAMNT)
AS FunctionalAmt, SUM(accTran.DEBITAMT – accTran.CRDTAMNT) + COALESCE
((SELECT SUM(DEBITAMT – CRDTAMNT) AS Expr1
FROM dbo.GL20000 AS runningTotal
WHERE (accNum.ACTINDX = ACTINDX) AND (ASCII(CURNCYID) < ASCII(accTran.CURNCYID))
GROUP BY ACTINDX), 0) AS RT
FROM dbo.GL00100 AS accSetup INNER JOIN
dbo.GL00105 AS accNum ON accSetup.ACTINDX = accNum.ACTINDX INNER JOIN
dbo.GL20000 AS accTran ON accNum.ACTINDX = accTran.ACTINDX AND accTran.TRXDATE <= DATEADD(d, – 1, DATEADD(m, DATEDIFF(m, 0,
GETDATE()), 0))
GROUP BY accNum.ACTINDX, accTran.CURNCYID, accSetup.ACTDESCR, accNum.ACTNUMST, accSetup.PSTNGTYP
ORDER BY + ASCII(accTran.CURNCYID)
LikeLike
V,
What exactly should the running total be showing? Aren’t you already showing a running balance as of the end of the previous month?
-Victoria
LikeLike
Hi Victoria,
Can you please assist with a problem I have, I am o GP 9 and am trying to reconcile my AR to my GL using the HATB, I found that we have a large difference which I believe is due partially to the apply date of the Multicurrency cash receipts
Do you have a script that would help highlight these transactions and therefore explain my difference.
Any help on this issue would be much appreciated.
Regards
V
LikeLike
V,
Reconciling subledgers to the GL is not something very easy to write scripts for, so I do not have any available. There is functionality in GP 10.0 to help with this, although from what I have heard from users it’s not 100%. My recommendation is typically to verify the reports you’re running are the right ones, find the last month that reconciled and go month by month from there to see if you can find the issue(s). Your difference today could actually be a combination of many transactions, but the monthly difference, or the change in the monthly differences, may help tracking it down easier. There is also a product from Software Index called Reconciler that you might be interested in if this is an ongoing issue.
-Victoria
LikeLike
Hi all – useful and informative site – GP newbie
I want to be able to document any smartlists I create for version and change control. Exports seem to give me the basics but do not provide detail to any restrictions or calculated fields etc. Are there any tools available to extract full details of smartlists such that they could be recreated from scratch if necessary?
Thanks
LikeLike
Stu,
Thanks for the kind words!
For SmartLists, I have not seen the export/import options not restore everything that was in the SmartList, all the restrictions and calculated fields seem to stay there. I wasn’t sure what you meant by the ‘detail to any restrictions or calculated fields etc.’…? But one other option may be to do all the calculations, restrictions, etc. in a SQL view and then use that view instead of tables in SmartList Builder. This also addresses any limitations SLB might have in terms of calculations or restrictions. So you would store the code for creating the SQL view separately and you could also document anything you might want in there, I would still grab the XML export though, so I didn’t have to recreate any column name or formatting changes I’ve made. Hope that helps.
-Victoria
LikeLike