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

139 Responses to “Resources”

  1. 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

    Like

  2. Darryl Schroeder Reply August 6, 2014 at 5:43 pm

    Victoria, do you have any recommendations for a Dynamics GP reseller/partner?

    Like

  3. 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

    Like

    • 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

      Like

  4. 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?

    Like

  5. 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.

    Like

  6. 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?

    Like

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

    Like

  8. 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.

    Like

    • 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

      Like

  9. 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.

    Like

  10. 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.

    Like

    • 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

      Like

      • 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.

        Like

  11. 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

    Like

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

    Thank you

    Like

  13. 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,

    Like

  14. 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

    Like

    • 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

      Like

  15. 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

    Like

    • 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

      Like

  16. 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.

    Like

    • 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

      Like

      • Hi Victoria,

        i checked and only 1 rate type is selected.

        Kevin

        Like

        • 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

          Like

          • 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

            Like

            • 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

              Like

            • 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

              Like

  17. 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

    Like

  18. Hi Victoria,

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

    Thanks,
    Pooja

    Like

  19. 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.

    Like

    • 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

      Like

  20. 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.

    Like

    • 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

      Like

  21. 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

    Like

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

    Like

  23. 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

    Like

    • 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

      Like

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

    Like

    • 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

      Like

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

        Like

        • 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

          Like

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

    Like

  26. 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.

    Like

  27. 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

    Like

    • Sorry GP 10

      Like

      • 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

        Like

        • 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

          Like

          • 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

            Like

  28. 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?

    Like

    • 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

      Like

      • 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

        Like

  29. 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?

    Like

    • 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

      Like

      • 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.

        Like

  30. 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

    Like

    • 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

      Like

  31. 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

    Like

  32. 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

    Like

  33. 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

    Like

    • 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

      Like

  34. 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

    Like

    • 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

      Like

  35. 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

    Like

    • 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

      Like

  36. 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

    Like

    • 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

      Like

  37. 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

    Like

  38. 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?

    Like

    • Hi Ethan,

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

      -Victoria

      Like

      • 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.

        Like

        • 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

          Like

  39. 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

    Like

    • 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

      Like

      • 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

        Like

        • 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

          Like

  40. Hi Victoria,

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

    Thanks

    Farooque.

    Like

  41. 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

    Like

    • 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

      Like

      • 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…

        Like

        • 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

          Like

  42. Victoria,

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

    Farooque.

    Like

    • 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

      Like

  43. 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

    Like

    • 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

      Like

  44. 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

    Like

  45. 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

    Like

  46. 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)

    Like

  47. 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

    Like

    • 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

      Like

  48. 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

    Like

    • 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

      Like

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 […]

    Like

  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 […]

    Like

  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    […]

    Like

Leave a Reply

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

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,640 other followers

%d bloggers like this: