can you filter table for closing entry?

navisionerinnavisionerin Posts: 126Member
Hello! I am doing something which includes excluding all closing entries from GL Entry table. Can someone help me, please?

Answers

  • vaprogvaprog Posts: 948Member
    A closing date is sorted in between the date it is closing and the next day.
    It is not possible to exclude any arbitrary closing date with a filter expression. You must either choose your filter range in a way that does not include closing dates, or else filter out closing dates in code.
    At the end of your filter range you need to specify the date as closing date or else closing dates are excluded. E.g
    SETRANGE("Posting Date",CALCDATE('<-Y>',WORKDATE),CLOSINGDATE(CALCDATE('<+Y>',WORKDATE)))
    
    includes closing dates at the end of the year,
    SETRANGE("Posting Date",CALCDATE('<-Y>',WORKDATE),CALCDATE('<+Y>',WORKDATE))
    
    does not.
    If you have any entries with closing dates in the middle of the year, then those entries are included with both filters.
  • navisionerinnavisionerin Posts: 126Member
    thank you @vaprog. is there a way to check the table whether or not closing entries exist?
Sign In or Register to comment.