Fun Stuff

Chuck Norris on fishing:
New Check Links record:
Dramatic Look
Google it with Bing
PC World’s The 20 Dumbest Questions on Yahoo Answers
Office 2010: The Movie teaser
No one likes peas:
I’m a PC and I’m 4 and a half!
Hmmmm….not sure Google’s suggestions are up to par today
“The only thing worse than being talked about is not being talked about.” – Oscar Wilde
“I am so clever that sometimes I don’t understand a single word of what I am saying.” – Oscar Wilde
Now if I could just find a ladder to get off this desk

No Fishing Allowed!
What are you sinking about?
The Matrix Runs on Windows
No soup for you!

“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:

– Last updated 01.30.2009

28 Responses to “Fun Stuff”

Ken Reply February 1, 2013 at 3:47 pm

This is the best Dynamics Blog EVER! Kudos
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.
- 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
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
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
- 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
  - 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
    - 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
      - 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? “
        
        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:
        
        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.
        
        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
        
        Francisco Cha Reply March 16, 2012 at 9:17 pm
        
        Thanks much. I will try and string it together I will let you know how it goes.
        
        Francisco
- 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?
  - Victoria Yudin Reply May 17, 2012 at 9:16 am
    
    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
Steve Reply October 14, 2011 at 12:24 pm

Thanks a lot Victoria.
Steve Reply September 28, 2011 at 5:03 pm

Thanks a lot, Victoria! You are the best!

Steve
- 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
  - Victoria Yudin Reply October 14, 2011 at 7:34 am
    
    Hi Steve,
    
    I don’t believe that is possible without a customizations. Of course, if you were using our GP Reports Viewer to print your SOP reports, that would not be an issue.
    
    -Victoria
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
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
- Victoria Yudin Reply September 27, 2011 at 11:51 am
  Hi Steve,
  
  Yes. The only check links series that affects more than the company you’re in is the System series. All others are company specific.
  
  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
  - 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
    - 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
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
- 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
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.
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.
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.
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.