Resources


This page is a compilation of links for downloads and resources that I typically find myself looking up.  Anything marked with a λ will require a login to either CustomerSource or PartnerSource.  If you have questions about accessing CustomerSource or PartnerSource, take a look at this post by David Musgrave and Scott Stephenson.

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 recources

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

Miscellaneous

128 Responses to “Resources”

  1. Thomas Shooter Reply May 13, 2013 at 7:09 pm

    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.

  2. Zafar Haider Khan Reply March 28, 2013 at 12:06 pm

    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?

  3. Zafar Haider Khan Reply March 21, 2013 at 4:43 pm

    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.

    • Victoria Yudin Reply March 22, 2013 at 3:49 am

      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

  4. Zafar Haider Khan Reply March 21, 2013 at 10:53 am

    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.

    • Victoria Yudin Reply March 21, 2013 at 10:58 am

      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

  5. Sreejith Reply March 10, 2013 at 2:08 am

    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.

  6. Elizabeth Reply July 23, 2012 at 1:10 am

    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.

    • Victoria Yudin Reply July 23, 2012 at 6:27 am

      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

      • Elizabeth Reply July 24, 2012 at 3:35 am

        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.

  7. JoAnn Cass Reply March 1, 2012 at 11:29 am

    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

  8. Jason Reply December 14, 2011 at 2:27 pm

    Victoria,
    Do you have any App recommendations for Customer/Vendor portals and Online Bill Pay for customers that tie in with GP?

    Thank you

  9. Patricia Reply October 24, 2011 at 7:12 pm

    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,

  10. Belraj Reply September 19, 2011 at 5:02 am

    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

    • Victoria Yudin Reply September 19, 2011 at 6:16 am

      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

  11. Renjan Mathew Varughese Reply September 13, 2011 at 4:45 am

    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

    • Victoria Yudin Reply September 19, 2011 at 6:23 am

      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

  12. Kevin Reply July 19, 2011 at 4:16 pm

    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.

    • Victoria Yudin Reply July 20, 2011 at 4:53 am

      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

      • Kevin Reply July 20, 2011 at 8:41 am

        Hi Victoria,

        i checked and only 1 rate type is selected.

        Kevin

        • Victoria Yudin Reply July 20, 2011 at 11:36 am

          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

          • Kevin Reply July 20, 2011 at 2:53 pm

            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

            • Victoria Yudin Reply July 20, 2011 at 4:27 pm

              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

            • Priyanki Reply January 10, 2012 at 6:52 pm

              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

  13. marry Reply May 31, 2011 at 2:30 am

    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

  14. Pooja Shah Reply May 9, 2011 at 8:49 am

    Hi Victoria,

    I wanted to know the purpose of ‘Report Processing Status’ window in GP 2010. I have never used it before.

    Thanks,
    Pooja

  15. Rod Reply April 5, 2011 at 10:22 am

    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.

    • Victoria Yudin Reply April 5, 2011 at 2:35 pm

      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

  16. Pam Mcelhany Reply March 1, 2011 at 7:18 pm

    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.

    • Victoria Yudin Reply March 2, 2011 at 4:02 am

      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

  17. tanuja Reply February 19, 2011 at 5:19 am

    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

  18. Mike Shellito Reply February 17, 2011 at 11:20 pm

    Is there a way to pull a customer list with the shipping address?

  19. Lancaster Reply November 22, 2010 at 7:06 pm

    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

    • Victoria Yudin Reply November 23, 2010 at 4:51 am

      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

  20. Teresa Reply November 11, 2010 at 7:02 pm

    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!

    • Victoria Yudin Reply November 12, 2010 at 5:12 am

      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

      • Teresa (Imma Learnin GP) Reply November 15, 2010 at 5:39 pm

        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!

        • Victoria Yudin Reply November 16, 2010 at 5:25 am

          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

  21. Teresa M Reply October 12, 2010 at 3:26 pm

    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!!!

  22. Yolanda Reply September 27, 2010 at 2:32 pm

    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.

  23. Farooq Reply September 16, 2010 at 2:28 pm

    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

    • Farooq Reply September 16, 2010 at 2:29 pm

      Sorry GP 10

      • Victoria Yudin Reply September 16, 2010 at 5:38 pm

        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

        • Farooq Reply September 16, 2010 at 5:59 pm

          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

          • Victoria Yudin Reply September 17, 2010 at 7:41 am

            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

  24. Kristie Reply May 3, 2010 at 9:18 pm

    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?

    • Victoria Yudin Reply May 4, 2010 at 3:42 am

      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

      • Kristie Reply May 5, 2010 at 10:55 am

        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

  25. Julie Rupp Reply April 8, 2010 at 1:46 pm

    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?

    • Victoria Yudin Reply April 8, 2010 at 1:58 pm

      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:

      1. Do you have any 3rd party products or customizations? (Specifically dealing with any payables functionality.)
      2. If you look at the apply information on one of the checks with the issue in GP, is it all there? In other words, is the issue occuring when the check batch is being generated or when it is being printed?

      -Victoria

      • Julie Rupp Reply April 8, 2010 at 2:03 pm

        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.

  26. Gustavo Ballesteros Reply January 15, 2010 at 9:15 pm

    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

    • Victoria Yudin Reply January 18, 2010 at 10:31 am

      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: http://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

  27. JoAnn Cass Reply January 13, 2010 at 10:49 am

    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

  28. Gustavo Reply January 12, 2010 at 9:12 pm

    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

  29. Gustavo Reply January 12, 2010 at 8:59 pm

    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

    • Victoria Yudin Reply January 13, 2010 at 5:02 am

      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

  30. Gustavo Reply January 11, 2010 at 2:03 pm

    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

    • Victoria Yudin Reply January 11, 2010 at 2:13 pm

      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

  31. Gustavo Reply January 8, 2010 at 7:11 pm

    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

    • Victoria Yudin Reply January 9, 2010 at 1:58 am

      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

  32. Gustavo Reply January 7, 2010 at 7:11 pm

    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

    • Victoria Yudin Reply January 8, 2010 at 6:30 am

      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

  33. Stu Reply November 6, 2009 at 12:56 pm

    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

  34. Ethan Reply November 3, 2009 at 1:44 pm

    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?

    • Victoria Yudin Reply November 4, 2009 at 6:49 am

      Hi Ethan,

      I am not quite sure what you’re asking – can you please explain in more detail?

      -Victoria

      • Ethan Reply November 4, 2009 at 9:47 am

        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.

        • Victoria Yudin Reply November 4, 2009 at 11:13 am

          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

  35. JoAnn Cass Reply August 20, 2009 at 2:19 pm

    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

    • Victoria Yudin Reply August 20, 2009 at 4:24 pm

      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

      • JoAnn Cass Reply August 26, 2009 at 12:31 pm

        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

        • Victoria Yudin Reply August 26, 2009 at 1:36 pm

          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

  36. Farooque Reply July 27, 2009 at 6:20 pm

    Hi Victoria,

    Which Company offers the Functional GP classes in Orange County for Great Plains.

    Thanks

    Farooque.

  37. Matt Reply June 11, 2009 at 1:18 pm

    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

    • Victoria Yudin Reply June 12, 2009 at 7:19 am

      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

      • matt Reply June 12, 2009 at 9:38 am

        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…

        • Victoria Yudin Reply June 12, 2009 at 10:35 am

          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

  38. Farooque Reply June 9, 2009 at 5:09 pm

    Victoria,

    Do you have any articles on Creating Business Alerts in Great Plains 10.

    Farooque.

    • Victoria Yudin Reply June 11, 2009 at 5:31 am

      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

  39. Shane Revlett Reply May 21, 2009 at 5:09 pm

    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

    • Victoria Yudin Reply May 22, 2009 at 4:17 am

      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

  40. Victoria Yudin Reply March 29, 2009 at 6:35 pm

    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

  41. V Reply March 29, 2009 at 11:00 am

    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

  42. V Reply March 28, 2009 at 4:44 pm

    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)

  43. V Reply March 6, 2009 at 4:07 pm

    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

    • Victoria Yudin Reply March 7, 2009 at 9:44 am

      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

  44. Stu Reply February 6, 2009 at 11:42 am

    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

    • Victoria Yudin Reply February 6, 2009 at 1:18 pm

      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

Trackbacks/Pingbacks

  1. It’s here! - Victoria Yudin - May 4, 2010

    [...] of the links above are on my Resources page along with links for other GP versions and related products. I will also be updating the following [...]
  2. Service Pack 4 for Dynamics GP 10 - Victoria Yudin - August 25, 2009

    [...] additional Dynamics GP downloads and other resources, please visit my Resources page. Posted in Dynamics GP, GP 10.0 Tagged: Dynamics GP, GP 10.0, service pack [...]
  3. Dynamics GP Integration Manager versions - Victoria Yudin - January 28, 2009

    [...] list.  If you’re looking for other GP, FRx or SQL versions and lists, please check out the Resources page. Posted in Dynamics GP   Tagged: Integration Manager, version    [...]

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,001 other followers

%d bloggers like this: