Filetr On Closing DAte

Comments

• Options

  Albertvh Member Posts: 516

  2008-10-10

  Hi
  See the online help for CLOSINGDATE
  
  Albert

  0
• Options

  girish.joshi Member Posts: 407

  2009-04-29

  That doesn't seem to help. The online help for CLOSINGDATE says that it will return a CLOSINGDATE value given any particular date.
  
  The question was whether or not it was possible to set a filter on G/L Entries that are posted with closing date. Does anyone know if this is possible?

  0
• Options

  themave Member Posts: 1,058

  2009-04-29

  in my system closing dates start with a "C"
  
  so closing enteries for Dec 31, 2008 in are C123108
  
  I can filter on that date and it works to show only closing entries.
  
  now you can't use a wildcard and filter on C*
  
  that gives an error of C* is not a valid date
  
  one more thought, the source code for closing entries is CLSINCOME
  
  so you can filter on that and see all closing enteries for any date.

  1
• Options

  girish.joshi Member Posts: 407

  2009-04-30

  So far this is what I can do:
  
  Given a single date, I can check if it is a closing date by comparing it to the normal version's date
  
  Given a closing date, I can filter for all other closing dates with the same value
  
  
  What I can't do:
  
  Filter for all closing dates.

  0
• Options

  girish.joshi Member Posts: 407

  2009-04-30

  themave,
  
  Great idea about the source code. That will work for me in this case - all of the closing date entries I'm interested in were created through the close income statement process.
  
  But still what about situations where the closing dates were created through the gen. journal?

  0