GP 10.0 Resources


Anything marked with a λ requires access to either CustomerSource or PartnerSource.  If you have questions about accessing CustomerSource or PartnerSource, check out this post by David Musgrave and Scott Stephenson.

Please note that some of the links below may not work anymore, as GP 10.0 is currently in Extended Support. If you find a link that’s dead, please let me know and I will either update it or remove it.

60 Responses to “GP 10.0 Resources”

  1. Hi Victoria:

    I think you have a wonderful blog and you have provided all sorts of helpful tips for me. I have a question. When drilling down from the Account Inquiry window, you can click the Journal Entry link to pull up the Journal. However, when drilling down to the Source Document, a totally different document is displayed and not the source document that created the transaction. This is so sporadic and doesn’t happen with all accounts. Any ideas on how to correct this?

    Like

  2. Hi Victoria,

    Which table would I be able to get the data for the screen, “Match Shipments to Invoice Inquiry Zoom”

    This is the Actual Landed cost applied to the items in the Invoice.

    help Highly appreciated.

    Thanks,

    Farman.

    Like

  3. Hi Victoria, I am hoping you can help me, In the past week we have come across two Accounts Payable error’s that I am unable to come up with a proper solution.

    Let me preface this by saying we do not use AR module (we do have license) the only modules we really user are Financial and AP.

    1)The same EFT banking information was entered for two different vendors. One vendor got paid twice while the other never received a check. THe AP clerk automatically voided the EFT (a month later when it was uncovered) even though payment was sent to wrong vendor, the correct vendor was invoiced in payables. This created a bank reconciliation nightmare, as we were unable to select that EFT as clearing since it was voided?

    2) Next similar issue, again payables is correct and this time a check was sent to the wrong vendor (lockbox) and it was cashed and this time reconciled. They sent us back a check. I need to reissue the check to the correct person which I can do a manual check but it will always be listed as open as the invoice was already applied.

    If you can provide any help to help me fix the AP and Bank REC I would appreciate it.

    Thanks so much!!
    Have a great day.

    Like

    • Hi Fran,

      While these two issues should not be too terribly difficult to fix, it would be really difficult to do so in blog comments. You’ve given a lot of information, but I would have probably a dozen questions on each of these issues and going back and forth on this without actually seeing it in GP or having all the information would be a very frustrating experience for everyone involved. The best way to get this resolved is to work with your GP Partner so that they can take a look at your system and help you come up with a solution, as well as explain it to you so that you can do this on your own in the future.

      -Victoria

      Like

  4. Hi Victoria,

    In order to release the PO to the vendor in GP we are printing a SSRS reports that are already build, instead of printing a a default GP report, the thing is that after the report is print it will not change the PO status to released, if you could kindly let me know what would be the best way to do this that would be great.

    Appreciate all your help.

    Farman

    Like

    • Hi Farman,

      One thing you could do is base your SSRS report on a stored procedure that includes code to update all the PO statuses, etc., when the report is printed. Keep in mind that if you are purchasing inventory items that track quantities there are also inventory tables that gt updated when you print a PO in GP.

      Another option is to use a product my company makes – GP Reports Viewer – to replace the PO’s in GP with your SSRS report. Our product will ensure that all the status and inventory updates that GP would process when you print a PO happen, it would also give you a way to replace any GP report with your own SSRS report.

      -Victoria

      Like

    • Hi Victoria,

      I am new to GP. Your blog is very helpful

      I am facing a problem in financial module. I wanted to track a document source. Following is the problem:

      We are using GP 10. In Financials > Transactions > General i see one journal entry with document no is 199261. In the source document field it is showing ‘GJ’ and in the reference is showing INVRCT-2012/013250′ The batch is showing ‘GLTRX015675′

      We wanted to know from which module this Journal is created and wanted to trace the source of this document. I suspect this came from inventory module, but i want to see the originating transaction.

      Appreciate your help
      Srinivas

      Like

  5. Hi Victoria! Just wanted to start off by telling you how helpful your blog site has been to my job. The fact that you can explain both the user side and technical side of GP is amazing. My question is our work has upgraded to GP 10 last year since we were planning on switching to Windows 7 which we’ve recently done, and I’m noticing that my GP 10 seems to be crashing more often; have you heard of this issue before? When I asked our IT support to look into it, they found a whole bunch of errors saying “the program Dynamics.exe version 10.0.324.0 stopped interacting with Windows and was closed”. Any insights? Thanks! Kathryn.

    Like

  6. Hi;
    Would anyone know which table the information in the “Edit MO Status” reside?
    Thanks
    Rod

    Like

  7. We use GP 10 and Accounting Receivable told me that in customer payment Summary window, most of customer year-to-day and Life-to-day data are not accurate. I run the utility sales reconcile for current customer, fiscal year and calendar year for these customers and nothing updated. Please give me some suggestion and thanks

    Like

    • Richard,

      If your Life to Date numbers are not correct, then there is an issue – those should always be right. Is it possible that they are changed manually or that an initial import of open balances was not performed properly when you implemented GP?

      Year-To Date and Last Year numbers are typically going to be off in most companies, as those are governed by your year end close and whether or not you even perform one in the AR subledger. Dynamics GP KB Article 851140 has some more detail on this.

      -Victoria

      Like

  8. Dear Victoria,

    I got following error in SOP line item transaction entry window.

    ” A Price cannot be found for Item xxxxx. Because the system is setup to require prices, you must remove the Item.”

    I am using extender pricing in GP10.
    Plaese guide me how to resolved it ?

    Thanks & Regards,
    Tanuja

    Like

    • Tanuja,

      I don’t work too much with Extended Pricing, so I am not sure if there is a separate setup for the pricing requirements there, however standard SOP setup has an option for ‘Price Not Required in Price List’. You can either check that to allow entering items without prices already set up onto Sales Transactions, or you can add the item pricing first, prior to entering the items on the SOP transactions.

      -Victoria

      Like

  9. Dear Victoria,

    How to get Profit and Loss statment report in GP?

    When I checked in fabricam, the report is there but inmy live company it is not showing ? Can we get this report from report writer or FRX or crystal report ?

    Please guide me which is easy way ?
    Also how can I get Income statement (Actual for single month) report ?

    Thanks & Regards,
    Tanuja

    Like

    • Tanuja,

      I prefer FRx for financial reporting. I would recommend getting some training for FRx either from your GP Partner or using ELearning on CustomerSource.

      -Victoria

      Like

      • Dear Victoria,

        I have this report in FRX also. But my manager wants this report from GP itself.

        I tried using advanced financial but it was not taking calculation like minus and multiply.

        Please can you guide me on this issue.

        Thanks & Regards,
        Tanuja

        Like

  10. Dear Victoria,

    I got following error, when I tried to post previous year JV in GL transaction.I don’t have access to server. So How can I give a permission? Is it possible thro GP itself ? Please guide me.

    “[Microsoft][ODBC SQL server][SQL server] create table permission denied in databse company_name”

    Thanks & Regards,
    Tanuja

    Like

    • Tanuja,

      Posting something in GP should not be looking to create a table. Not sure what exactly is going on, but this sounds like there is a more global issue. I would recommend talking to GP support or someone that can take a look at you GP installation and troubleshoot this for you.

      -Victoria

      Like

    • Dear Victoria,

      I have this report in FRX also. But my manager wants this report from GP itself.

      I tried using advanced financial but it was not taking calculation like minus and multiply.

      Please can you guide me on this issue.

      Thanks & Regards,
      Tanuja

      Like

  11. Hi Victoria,

    One of our Financial team members has asked me to turn on the automatic exection of “Average Days to Pay” calculation.

    I am told it was a scheduled job and it is no longer running.

    I have searched hi and low for info on the scheduling of Average Days To Pay and I have have not found a thing.

    They do not want to run this manually, so I need to come up with something for them.

    Also, if I can just run a stored proc as a mssql job, that would be great!

    I currently do this for Aging.

    Any help on this would be great.

    PS. I had a demo of Company Data Archive from Professional Advantage. It looks like it will do what I need. I have a test key and will try it next week in my test environment. Thanks for the tip!
    Gene

    Like

    • Hi Gene,

      Unless you have some kind of a customization for this, Average Days to Pay is built into GP and gets updated automatically each time an invoice is paid for a customer. I do not know of any way to turn it off or on.

      -Victoria

      Like

  12. Hi,

    In GP10, We are using multicurrency functionality. One of my checkbook is showing difeerence between current checkbook balance and current cash account balance in checkbook balance inquiry report. This difeerence is because of exchange rate.We are converting with current exchange rate.So we found difference in cash book account. How to resolved it? Please inform me what is the functionality behind this calculation.?

    Thanks & Regards,
    Tanuja

    Like

  13. GP10, Data Retention Schedule

    HI Victoria, Of all the info I have read about GP, yours is always the best! I am a DBA, our company uses CRM and GP with Scribe integration. I have been tasked with purging OLD/Useless data. That is, Customers that have not made a purchase for 7 years or more or have never made a purchase. So, round one was easy. If the customer had never made a purchase, I was pretty much able to create a PURGE group and update the CUSTCLAS to PURGE and bulk remove them. However, a few of these had a child that did make a purchase and checklinks showed me the error of my ways. So, I refined my purge group. All is well. The problem is, how do I purge customers with history! I obviously need to remove all history before I can remove the customer, but I have not found anything about this on-line, less 1 post by you where you suggested moving all of these customer cards into a single archive customer. I thought about this one, but our company wants to PURGE data for legal reasons. We only want 7 years of history. Any help on this subject would be great! I have to believe others are doing this in type retention scheduling? Be well and thanks for so much info you have provided me and others! Can’t wait to get your book! Gene

    Like

    • Hi Gene,

      Thank you very much for the kind words!

      I hear what you are saying about just getting rid of history…but in my experience, anyone that ever got rid of history, later wanted something from it. :-) So…that said, I think you have 2 options:

      1. Get Company Data Archive from Professional Advantage – this is a GP add-on that will let you move old data to another GP company out of yours. It can make life a lot easier if you are doing this regularly and can take the headache out of a lot of the details for you.
      2. In a test company (I am sure you are already using one) experiment with the Remove Transaction History utility in GP (Tools | Utilities | Sales | Remove Transaction History). The only date option is Post Date and unless this goes against most other naming conventions for dates in GP, I would assume this to be the date that a transaction was posted, but that may be ok as a ‘close enough’. This process, of course, is more manual, but might just do everything you need, since it sounds like you’ve already got a good grip on the data and what is happening.

      Hope this helps,
      -Victoria

      Like

      • Thanks Victoria,
        Company Data Archive from Professional Advantage looks interesting. I have requested a demo.

        I know what you mean about purging history.
        In fact, it was a hard sell on me, but with changes in state laws and data privacy and discover etc. It is something that must be done. We had to destory old backup tapes because we had legacy data with SSN# unencrypted, even though the backup was encrypted and password protected. We need to be compliant!

        Thanks again,
        I will play with Remove Transaction History as well and see if that resolves my issues as well. ( free option is always good! )

        Gene

        Like

  14. Hi Victoria,

    I am trying to decifer what accounts are included in GP10 Metrics Total Sales and Gross Profit. I have tried several combination of accounts and none seems to match the number in the Metrics window.

    I appreciate if you can help me with this.

    Jose

    Like

  15. hi Victoria,

    in GP 9.0, under Navigation>>Administration>>All Reports list. Do you happen to know if there is a way to get this listing of reports in SQL or maybe export to Excel? There does not seem to be a way to get around it?

    Jeff

    Like

    • Hi Jeff,

      I do not believe this is actually stored in SQL, it’s in the dictionary (.dic) files. The report lists gets created as a temp table when you open that list.

      -Victoria

      Like

      • Thanks Victoria!

        i was able to finally locate that temp table during runtime and got the listing i wanted.

        appreciate your response as always!

        Like

  16. Victoria,

    First, thank you for this resource. Your blog has been a tremenous help in the past.

    Currently I am confronted with adding a new machine to an existing installation. They are at 10.00.1237. Your table indicate that I need to apply service pack 3 after installing the base package, but I have not been able to locate service pack 3.

    What are my options?

    Thank you,
    Harry Berman

    Like

      • Thank you for the file location information. I applied the service packs to bring the system up to 10.00.1237 to match the existing installations but when I start GP it wants to update the database. What could cause this? Do I need to reinstall the service packs on the other machines?

        Thank you very much for your help,
        Harry Berman

        Like

        • Harry,

          I am guessing you’re not getting this message anywhere else? That would indicate the computer that you are on has the issue, not the other machines.

          SP 3 for GP 10 is not 10.00.1237 – that is a hot fix after SP 3. Here is a link to the entire list of versions including hotfixes: https://mbs.microsoft.com/downloads/customer/MDGP10_MSPVersionList.xls. ALL of your GP installations must match exactly, otherwise you will run into a problem.

          -Victoria

          Like

          • Victoria,

            You are correct the issue is only on the new machine. I applied all of the elements in the service pack/hot fix list to bring the new machine up to 10.00.1237 so all of the machines’ revision numbers match.

            Can I assume that this installation of GP includes some module left out of the other installations so a database upgrade should not affect the machines already sitting at 10.00.1237? Is there a way to determine why the system thinks database updates are in order?

            Thank you for your perseverance,
            Harry Berman
            Harry

            Like

            • Harry,

              Yes, you are probably right that this installation includes components or products not installed on other machines (or the server). However, I don’t think it’s safe to assume that running through the ‘upgrade’ will not affect anything else. I think it would be better to remove the unused components from the new installation so that they are not causing this issue. Compare your Dynamics.set file from an existing machine running GP without any issues to the Dynamics.set file on the newly installed machine. What is different?

              -Victoria

              Like

  17. Dearest Victoria:

    I just inherited a machine with GP10 installed. However noone knows the “sa” password. I’m new to the GP I hear that there is a SQL script that can be ran to reset the “sa” password. Does this ring a bell with you? I tried searching ParterSource but to no avail. Thanks in advance.

    Like

    • Teresa,

      Are you sure you mean the ‘sa’ password, which is the SQL Server system administrator? Not the ‘GP system’ password, which is specific to GP? If you are talking about the SQL Server ‘sa’ password, you should be able to reset that directly in SQL Server, as that has nothing to do with GP. If you’re talking about the GP system password, yes there is a way to both find it or reset it to blank, but I am not comfortable giving someone ways to get around passwords without knowing they are authorized to do this. I would advise that you talk to either GP support or your GP partner who should be able to verify you are authorized to do this and to help you with it.

      -Victoria

      Like

  18. Hi Victoria,

    I am getting this error while installing SP1 for GP, any ideas

    The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct update patch.

    Tried the knowledge base to reapir the installation and then try it but nothing happend.

    Thanks,

    F

    Like

    • F,

      It’s possible that you have a bad file, so you could try downloading the service pack again. I also recommend that ALL installations be performed when logged into Windows as the local/built-in administrator. If neither of those help, I would recommend posting this on the GP Customer forum or starting a support incident with GP Support.

      -Victoria

      Like

  19. Hi,

    Is there any way to push data into Purchase module – Return Transaction entry? I cannot find any e-connect nodes for Purchase Returns. Please help..

    Like

  20. We have Dynamic GP 10.0 for 6 users, Windows Server 2003 R2 and SQL Server 2008, all workstation was working fine, but from the last Friday one workstation is working very slowly, the GP login in that machine takes 10 minutes, the other application are normally running. Do you know what the problem is?

    Thansk,

    Patricia

    Azteca Distributors

    Like

    • Patricia,

      Unfortunately this could be caused by many different things. There is no one problem that would cause this for everyone. Click here for a link to a GP Knowledge Base article listing some things that should help you troubleshoot.

      -Victoria

      Like

Trackbacks/Pingbacks

  1. Dynamics GP build numbers and service packs | Victoria Yudin - February 6, 2011

    [...] GP 10.0 ResourcesAnything marked with a λ requires access to either CustomerSource or PartnerSource… [...]

    Like

  2. Dynamics GP build numbers and service packs « Victoria Yudin - September 11, 2010

    [...] GP 10.0 Resources [...]

    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,558 other followers

%d bloggers like this: