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

30 Responses to “Fun Stuff”

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

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

  2. This is the best Dynamics Blog EVER! Kudos

    Like this

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

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

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

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

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

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

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

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

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

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

      Like this

      • Hi Kyle,

        Thanks for your kind words! I have not to date created any views with the intercompany module, I will put that on the wish list to consider in the future.

        -Victoria

        Like this

  6. Thanks a lot Victoria.

    Like this

  7. Thanks a lot, Victoria! You are the best!

    Steve

    Like this

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

  8. Thanks so much Victoria!

    I didn’t expect you can response so quickly!

    Thank you.

    Steve

    Like this

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

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

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

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

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

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

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

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

    Like this

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

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

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

%d bloggers like this: