Fun Stuff


 

  • “My mind now expects to take in information the way the Net distributes it: in a swiftly moving stream of particles. Once I was a scuba diver in the sea of words. Now I zip along the surface like a guy on a Jet Ski.”  –Nicholas Carr, American writer and editor, Atlantic Monthly, July 1, 2008
  • “The good news about computers is that they do what you tell them to do. The bad news is that they do what you tell them to do.”  –Ted Nelson  
  • “Imagine if every Thursday your shoes exploded if you tied them the usual way. This happens to us all the time with computers, and nobody thinks of complaining.”  — Jef Raskin
  • When you should have run check links a long time ago: check-links-6767

    

— Last updated 01.30.2009

47 Responses to “Fun Stuff”

  1. Greg Blanc Reply November 8, 2021 at 8:12 pm

    Hello Victoria, Appreciate your input. Try to run a report that will show me profit or margin by sales transaction, assuming there is a link to purchase order?

    Like

    • Victoria Yudin Reply November 9, 2021 at 10:25 am

      Hi Greg,

      There is no simple report or answer for this because there are a myriad of different ways to enter data into GP and many of them will change the answer to your question/request. Also, I would not assume links to anything without specific knowledge of how/where data is being entered. Sorry not to have a quick or easy answer for you.

      -Victoria

      Like

  2. Bob Harrison Reply December 8, 2020 at 6:09 pm

    Great Site. I spend a lot of time trying to figure out which table is used for something. Then after running a trace and searching awhile, I remember, “Hey, what is that site that list all of the tables, etc. in GP?” Then I go here and find my answer. Finally bookmarked it.
    Sometimes I can be a bit slow at making things easy for me!!!

    Like

  3. funkyp55 Reply July 30, 2019 at 10:41 am

    Still an active site? Have an urgent GP 9 question.

    Like

  4. Paul Topham Reply July 30, 2019 at 10:41 am

    Is this forum still active? Have a GP 9 question (I know…)

    Like

  5. Nikolai Jones Reply August 5, 2016 at 4:48 pm

    Hi Victoria,
    What would you recommend to solve a reconciling difference between the Receivables Management Module of GP and the Receivables GL Account of GP. The differences are primarily made up of receipts posted through the sales module of GP as well as invoices and Credit Memos posted through the SOP Sales Module of GP.

    The receipt transactions were re-allocated from the default credit account (Receivables GL A/C) to other accounts such as Deferred Income etc, the debit went to Bank.

    The invoice transactions showed that credit entries were made to the Receivables GL A/C and the debit also went to the default account (Receivables GL A/C.

    Please note the above was determined by running the “Reconcile to GL” feature in the Financial Module of GP.

    Regards

    Like

    • Victoria Yudin Reply August 6, 2016 at 7:14 am

      Hi Nikolai,

      Based on your description is sounds like you have changed (or re-classed) your General Ledger entries to change the GL account number of entries coming from the AR subledger to something other than Accounts Receivable. Normally this is only done to fix a reconciliation issue and, as you can see, the reverse is also true, doing so will cause a reconciliation issue.

      At this point, if the re-class entries/changes were done incorrectly, they can be reversed with another GL entry so that the GL can match the AR subledger. If it is felt that they were not done incorrectly, then I would recommend a much more in-depth discussion about the specifics of these transactions with your accountant and/or GP partner to help figure out the best resolution for your particular situation.

      -Victoria

      Like

  6. Tim Reply July 26, 2016 at 6:27 pm

    Hi Victoria,
    I’m a long-time finance/accounting professional that will be asked to used Great Plains (new role) in a very detailed way (SQL, queries, database management, etc…) for the first time. Do you have any crash courses you would recommend and/or useful “1st timer” links on your site?
    I appreciate the help and love the site,
    Tim

    Like

    • Victoria Yudin Reply July 27, 2016 at 7:25 am

      Hi Tim,

      First of all, thank you for your kind words.

      Unfortunately, there is no good tutorial for this kind of stuff that I am aware of. Much of what I know today has been acquired from experience over the last 20+ years of doing this myself and struggling to find the answers. While there is a lot of stuff you can find online, none of it is comprehensive, you will mostly find help with specific issues, one at a time. The other thing you really have to watch out for online is bad advice – there is just as much of it out there as good advice and sometimes you get what you pay for. 🙂

      My typical recommendations when I get asked this question:

      • Find a good resource (or maybe even more than one) that you can get training from, some upfront to start you on your way, and then on an as needed basis as new requests/issues come up. Often your Dynamics GP Partner will have someone available for this. If not, there are a few people you can find online, including me, that offer that as a service. It is often worth the $$ to get good training/advice in a timely manner.
      • Document everything. Something might seem completely simple and basic today and you’ll think, ‘if this comes up again, I will totally remember how to do this’. Do yourself a favor and document it anyway, you’ll be glad you did.
      • Anytime anyone recommends changing something directly in SQL, make sure you are 100% comfortable with the source, you feel 100% certain what the change will do and all of its implications and/or do some testing first.

      Good luck with the new role,
      -Victoria

      Like

  7. John Juno Reply January 8, 2015 at 8:37 am

    Hi, on the SALES > Summary screen (for a customer) it shows a balance (from rm00103 custblnc) it also shows a unposted amount (unpstdsa). BUT, all the sales documents are posted and applied. This did occur after a batch went to Batch recovery, and the batch went away after recovery. Anyway, we really just found it by accident and were now trying to fix it. I ran Check Links and it reported no errors. On-line research has not hit any gold so I thought I would ask you, for possible suggestions. My only remianing thought is to “hammer” rm00103 to be correct. Thanks in advance and thanks since 2012.

    Like

  8. John Signoretti Reply December 1, 2014 at 10:25 am

    Hi Victoria,
    Have something to dust off the cobwebs for you. My non-profit is running Microsoft FRx. I have a Windows 8 workstation that we are looking to run it on, and other than a post from you, there is a zero success rate.
    Any suggestions on getting the app and reports to run.?
    John

    Like

    • Victoria Yudin Reply December 1, 2014 at 2:17 pm

      Hi John,

      My tips for getting FRx to work on Windows 8:

      • Install FRx while logged into Windows as the local built-in administrator. This makes a big difference, I have tested installing as other users and had problems.
      • Install to somewhere other than Program Files.
      • Make sure you’re using the latest version (6.7) and service pack (12) of FRx.

      Hope that helps.
      -Victoria

      Like

  9. Katharine Hart-Watkins Reply April 17, 2014 at 8:24 pm

    Hi,
    Mysteriously we have records deleted from our IV00102 table yet the master items are intact in IV00101. How is it possible to delete a record even though there are constraints and dependencies on the table.??

    Like

    • Victoria Yudin Reply April 18, 2014 at 9:58 am

      Hi Katherine,

      What exactly do you think was deleted? Do you have a backup you can look at and compare the IV00102 table from there to the current IV00102 table to see what the differences are? Is there anyone making changes directly in SQL?

      -Victoria

      Like

  10. Dan Reply November 13, 2013 at 11:37 pm

    Your awesome Victoria,

    I’m very new to GP and find your knowledge and willingness to share absolutely fantastic. Just a quick question, how do I find out which tables and which links are used in the default out of the box smartlists in GP 10. Because I did not create these in builder I can’t open them to see how they are constructed. Any help would be much appreciated.

    thanks in advance

    Like

    • Victoria Yudin Reply November 14, 2013 at 6:00 am

      Hi Dan,

      In the latest release of GP (GP 2013 SP 2) there is a new tool called SmartList Designer that can help you see the code behind some of the existing SmartLists. There is also some old documentation that exists that can help to some degree. However, I don’t know if there is one definitive place to get all of this information consistently. If you have a specific SmartList you want to know about, let me know which one and I will try to help.

      -Victoria

      Like

  11. Ken Reply February 1, 2013 at 3:47 pm

    This is the best Dynamics Blog EVER! Kudos

    Like

  12. Thargelia Romero Reply August 28, 2012 at 4:03 pm

    Hi Victoria,
    Thanks for such a great site. I was wondering if you have ever seem AP invoices with credit applied that exceed the value of the original invoice and all of the transactions are in history.

    Like

    • Victoria Yudin Reply August 30, 2012 at 4:48 am

      Hi Thargelia,

      I have seen this before. No way to track down the cause unless someone remembers crashing out of GP or getting an error while entering or posting transactions. Unfortunately, there is no generic ‘fix’, you will need to have someone examine your tables and determine the best way to clean this up depending on what is in them. I would recommend working with your GP Partner or GP Support to help you fix this.

      -Victoria

      Like

  13. TinTin Reply June 26, 2012 at 2:22 pm

    Hi Victoria,

    I am just posting to let you know that your site is amazing and your information is invaluable. Your expertise has made my day several times and greatly improved my knowledge about GP for my student work term.

    Thank you for the gift

    Like

  14. Francisco Reply March 14, 2012 at 6:58 pm

    Hi Victoria,

    Thank you so much your website is amazing. However I am having an issue trying to match the GL to the Sub-ledger in the sales module. I’ve been using the GL20000 table to pull the data from the SOP 30300 and SOP30200 but the numbers do not tie. I’ve also taken into consideration the manual GL journal entries. Your help would be much appreciated.

    Thank you,
    Francisco Cha

    Like

    • Victoria Yudin Reply March 15, 2012 at 9:08 am

      Hi Francisco,

      There is no direct link between GL20000 and SOP30200 or SOP30200. Can you provide some more detail on exactly what you are trying to do?

      -Victoria

      Like

      • Francisco Reply March 15, 2012 at 2:10 pm

        Hi Victoria,

        I am trying to reconcile the GL to the Subledger detail using both SOP30200 and SOP 30300. I understand that SOP30300 has the detail data and the SOP30200 contains the header data. I was wondering if I was missing any other tables that would help with this reconciliation.

        Thank you,
        Francisco Cha

        Like

        • Victoria Yudin Reply March 15, 2012 at 2:19 pm

          Hi Francisco,

          Sorry, but you have just repeated what you asked before, so let me rephrase my question. What numbers in SOP are you trying to reconcile to what accounts in the GL?? SOP is a subset of RM, so you might actually be better off looking in RM tables, but again, if you could explain in business or accounting terms what you are trying to accomplish that might help me understand it and give you better advice.

          -Victoria

          Like

          • Francisco Cha Reply March 15, 2012 at 5:16 pm

            Hi Victoria,

            I’m sorry but my background is not in accounting. However a colleague was able to better describe my intentions:

            “I am attempting to link an individual sale (invoice) to its related return and credit transactions (if there are any returns or credits that exist). Once I have linked these transactions to the individual sale, I need to tie out the transactions from the GP sub-ledgers to the related journal entry created in the GL20000 table. So, for each GL journal entry, I want to be able to directly link the GL JE to the sub-ledger detail. For each sub-ledger detail, I want to be able tie to all related sub-ledger transactions. The sales are easy to match to the GL; but the returns and credits are elusive. Do you have any thoughts on which sub-ledger tables I should use and which fields to join on? “

            Like

            • Victoria Yudin Reply March 16, 2012 at 5:48 am

              Francisco,

              Thanks for the additional detail, that does help me. I am seeing 2 different questions here:

              1. How to tie entries in GL20000 to the subledger transactions they originated from. As you are seeing this is not always an easy task and may be more complicated (or not always possible, even) based on exactly how your transactions are entered into GP and your specific posting settings. However, in general, the GL20000 table stores the originating source (ORGNTSRC), series (SERIES), control number (ORCTRNUM) and type (ORTRXTYP) for all entries that came from a subledger. For each unique combination of these you would need to link back to the appropriate subledger tables, and they might be different in each case. If you have a question about a particular transaction, please give me the values for all 4 of the fields I listed above and I will try to help.
              2. How to see “related” sales transactions in the GL. By “related” in this case it looks like you want to see all credit memos and returns for a particular invoice, although I would recommend asking for a precise definition of this from the people asking you for this report. This, again, may or may not be possible based on how you are entering transactions in GP. To make this type of reporting possible you need to find something that “relates” these transactions consistently. In some cases it may be easy, for example, if the credit memos or returns are applied to the proper invoice. If that is the case, you can use my AR Apply Detail view to find related sales transactions and use that together with your GL data. However, if the “related” transactions are not always applied to each other, you will first need to understand how your users are entering this data and make sure they are consistently entering something that you can use as a link.

              -Victoria

              Like

    • kyle Reply May 16, 2012 at 2:11 pm

      Victoria, you have some great AP payment/apply sql queries on your website, have you done anything (incorporated) the intercompany module with these?

      Like

  15. Steve Reply October 14, 2011 at 12:24 pm

    Thanks a lot Victoria.

    Like

  16. Steve Reply September 28, 2011 at 5:03 pm

    Thanks a lot, Victoria! You are the best!

    Steve

    Like

    • Steve Reply October 13, 2011 at 1:03 pm

      Hi Victoria,

      I have to bug you again.

      When we print picking ticket, there is an option called”include kit components” is defaulted checked. We don’t want it being checked at all. Is there a way we can deselect this option, so we don’t have to deselect it every time when we print a picking ticket?

      Thanks a lot,
      Steve

      Like

  17. Steve Reply September 27, 2011 at 12:34 pm

    Thanks so much Victoria!

    I didn’t expect you can response so quickly!

    Thank you.

    Steve

    Like

  18. Steve Reply September 27, 2011 at 11:25 am

    Hello Victoria,
    Our company works with GP 9.0. I have two questions here:

    1. Can I do a financial check link in test company when users are using real company?
    2. Can I do a SQL backup when users are using GP?

    Thanks a lot,
    Steve

    Like

    • Victoria Yudin Reply September 27, 2011 at 11:51 am

      Hi Steve,

      1. Yes. The only check links series that affects more than the company you’re in is the System series. All others are company specific.
      2. Yes. Making a backup directly in SQL simply takes a snapshot at that point in time. There should be no issue doing this while users are in GP, however, depending on resources, your users may experience a performance hit during the backup.

      None of this is version specific, so these answers would be the same for GP 10.0 and GP 2010.
      -Victoria

      Like

      • Steve Reply September 28, 2011 at 3:38 pm

        Hello Victoria,
        We have an sales batch, which doesn’t have transactions, but it is with a batch total of $150.

        Why did this happen and how to fix it?

        Thanks,
        Steve

        Like

        • Victoria Yudin Reply September 28, 2011 at 4:54 pm

          Hi Steve,

          This can happen when transactions are moved between batches and is usually nothing to be concerned about. If you have confirmed that the batch does not actually have any transactions (by going into the transaction window and searching or by looking at the related tables in SQL) then you can simply delete the batch in GP.

          -Victoria

          Like

  19. Benoit (Ben) Lalonde Reply September 25, 2011 at 8:59 am

    Hello Victoria,

    Our company works with GP and I am being told by I.T.”s that on the “Sales transaction entry” we cannot change the following;

    1) Order entry form changed to landscape form portrait

    2) Add additional line of information to appear on order for each product

    3) and have the option for French or English descriptions for specific language clients

    Is this true?

    Thanks in advance

    Note: we just recently updated to the latest version of GP

    Like

    • Victoria Yudin Reply September 25, 2011 at 10:35 am

      Hi Ben,

      I think this is all possible, however, I don’t know how easy it would be using GP’s Report Writer. For these kinds of changes, I would typically recommend working with Crystal Reports or SSRS.

      -Victoria

      Like

  20. Vaidy Reply November 22, 2010 at 4:44 pm

    I just thought I would browse thru’ the Fun Stuff and out of all I liked, this one is awesomely satirical: When you should have run Check Links a long time ago. And I just wonder what I would do if I face anything like that in my consulting career. Scary.

    Like

  21. Lauren Reply June 18, 2010 at 2:57 pm

    I am going to have to steal the “no soup for you” line and hide it somewhere in GP. Very, very clever.

    Like

  22. Tammy Reply April 9, 2009 at 6:34 pm

    Hi Victoria,

    I found the blog you posted about using credit cards to pay vendors and it is perfect for what we are wanting to do with our new implementation. I have also seen several of your post on the newsgroups and have been very impressed with your knowledge of GP. I have been a GP user for over 9 years and a GP consultant for over 2. I hope to be as smart as you one day.

    Thanks for all your advice and help.

    Like

  23. Gerry Fassett Reply January 2, 2009 at 11:39 am

    Happy New Year. Thanks for your tips on the SBF board. I am now switching my thinking back to GP for the conversions. Should be a good year for that task.

    Like

Leave a comment