Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
NAV Budget problems RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    3
    Sign in to vote
    When I try to open Budgets in Financial Management, NAV crashed and I get message:
    "The sum of values in the Amount field cannot be calculated because the filter contains question marks (?), asterisks (*), or 'at' symbols (@). Filters: ... Teble: G/L Budget Entry"
    I use NAV2009R2 classic client.
    Sunday, July 14, 2013 2:59 PM

Answers

  • Question
    Sign in to vote
    43
    Sign in to vote
    Open this form using other language and delete G/L Account Filter in header. After that, you can open form with English again.
    Sunday, July 14, 2013 3:02 PM
  • Question
    Sign in to vote
    43
    Sign in to vote
    In other language, probably sign "*" is not prohibited. You enter this sign at filter, but in English you cannot. Don't use this signs in filter.
    If you want GL account series, dont use "1*"; instead that you can use "1.."
    Sunday, July 14, 2013 3:04 PM

All replies

  • Question
    Sign in to vote
    35
    Sign in to vote
    Have you at any place this signs (?, *, @)? In your message, you put "..." instead filter.
    • Proposed as answer by Imssa Goriz Wednesday, August 21, 2013 7:46 AM
    Sunday, July 14, 2013 3:00 PM
  • Question
    Sign in to vote
    2
    Sign in to vote
    Yes, I have '*' in G/L Account No. filter. I already deleted all budget entries through table, but I get error again.
    Sunday, July 14, 2013 3:01 PM
  • Question
    Sign in to vote
    36
    Sign in to vote
    Entries are not a problem. Filter is problem. Have you any other language in NAV? If you have, try to open budget with some other language.
    Sunday, July 14, 2013 3:01 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, I have. I am unable to open budget now. But, when I try with English, I get the same message again.
    Sunday, July 14, 2013 3:02 PM
  • Question
    Sign in to vote
    43
    Sign in to vote
    Open this form using other language and delete G/L Account Filter in header. After that, you can open form with English again.
    Sunday, July 14, 2013 3:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks, now it works. But where is a problem?
    Sunday, July 14, 2013 3:03 PM
  • Question
    Sign in to vote
    43
    Sign in to vote
    In other language, probably sign "*" is not prohibited. You enter this sign at filter, but in English you cannot. Don't use this signs in filter.
    If you want GL account series, dont use "1*"; instead that you can use "1.."
    Sunday, July 14, 2013 3:04 PM