Adding rows from dimensions does not show account descriptions

All replies

• 

  

  0

  Sign in to vote

  Hi Wipfli,
  
  This is a bug that has been written up and is being addressed by the development team.  Essentially, the data provider is pulling its descriptions from the GL40200 instead of the GL00100 which is the primary table for Account descriptions.  We do have a work-around for this but I suggest that you only run this on your test server as we have not confirmed if/how this will affect GP. 
  
  This script simply takes the descriptions from the GL00100 and places them into the GL40200. 

  update GL40200

  set gl40200.dscriptn = Substring(GL00100.actdescr,1,31)

  from GL40200

      Inner Join gl00100

  ON (gl40200.sgmntid = gl00100.actnumbr_2)

   

  • Proposed as answer by Daniel Sly Friday, January 29, 2010 7:01 PM
  • Marked as answer by Wipfli Wednesday, February 3, 2010 7:28 PM

  Friday, January 29, 2010 5:42 PM
• 

  

  0

  Sign in to vote

  Thanks for the response.  Is there a list of bugs available for us to see so that we know when we're running into one?

  Friday, January 29, 2010 9:43 PM
• 

  

  0

  Sign in to vote

  There is not a list at the moment but we will discuss this and see if we can start posting them out to this forum.

  Friday, January 29, 2010 10:35 PM
• 

  

  0

  Sign in to vote

  A list of known issues is provided in the Readme.rtf from the download page.
  
  Jill

  Wednesday, February 3, 2010 4:54 PM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks for pointing that out.  I didn't see this issue in particular in that document but it is still helpful to know.

  Wednesday, February 3, 2010 7:29 PM