web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Overflow Under Type Co...
Microsoft Dynamics NAV (Archived)

Overflow Under Type Conversion of Text to Code In Account Schedule

(0) ShareShare
ReportReport
Posted on by DynamicsBoy 520

Hello everyone,

Can you help me to solve my problem?

I wanted to create a consolidation report in account schedule. But, I got stuck when I can't insert the totaling value on the line. I just thinking to longer the totaling limitation in account schedule lines. I try to find the solution in the NAV forum, but I didn't get any answered about my problem.

Thanks for anyone who care about my problem.

*This post is locked for comments

I have the same question (0)
  • DynamicsBoy Profile Picture
    DynamicsBoy 520 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    Dear Mohana,

    Thank you.. You helping me.. :)

    Regards,

    DynamicsBoy

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,941 Super User 2025 Season 2 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    You can start with increasing the parameter length of CheckFormula function but its dificult to identify where else it is used.

    you may get same error in some other place also where length was used 80

    read this blog before starting

    dynamicsuser.net/.../increasing-field-lengths-in-navision.aspx

  • DynamicsBoy Profile Picture
    DynamicsBoy 520 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    Dear Mohana,

    Thanks for your replies.. Yup, you are right.. The maximum only 80 chars, but do you know another way to expand the chars?

    Thanks,

    DynamicsBoy

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,941 Super User 2025 Season 2 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    the maximum value is 80 chars in the totaling field with formula type but you are adding 87 Chars to 80 Chars field.

    You need to reduce the formula to 80 chars

  • DynamicsBoy Profile Picture
    DynamicsBoy 520 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    Dear Mohana,

    Sorry for taking to long for replying your posting. I've captured the error code and message when I debug the process.

    Here is an error messages:

    Here is where the code of process get stuck:

    ParenthesesLevel := 0;

    FOR i := 1 TO STRLEN(Formula) DO BEGIN

      IF Formula[i] = '(' THEN

        ParenthesesLevel := ParenthesesLevel + 1

      ELSE

        IF Formula[i] = ')' THEN

          ParenthesesLevel := ParenthesesLevel - 1;

      IF ParenthesesLevel < 0 THEN

        ERROR(Text001,i);

      IF Formula[i] IN ['+','-','*','/','^'] THEN BEGIN

        IF HasOperator THEN

          ERROR(Text002,i)

        ELSE

          HasOperator := TRUE;

        IF i = STRLEN(Formula) THEN

          ERROR(Text003,i)

        ELSE

          IF Formula[i+1] = ')' THEN

            ERROR(Text003,i);

      END ELSE

        HasOperator := FALSE;

    END;

    IF ParenthesesLevel > 0 THEN

      ERROR(Text004)

    ELSE

      IF ParenthesesLevel < 0 THEN

        ERROR(Text005);

    By the way, I got a temporary solution for my problem using workaround. I filter the source table view for account schedule page. I make a value range from 0..900000000, it mean when the matrix overview and report of account schedule created, it's only show that range.

    It's give me a chance to make a subtotaling row for amount that I should calculate in real totaling field where placed on 0..900000000 range. But I think it's would be used for only a couple of times, because sometimes when they create a new g/l accounts or make something around that, it should be difficult to correct the amount in account schedule.

    Thank you for answered my problem.


    Regards,

    DynamicsBoy

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,941 Super User 2025 Season 2 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    Can you show us the code please?

  • DynamicsBoy Profile Picture
    DynamicsBoy 520 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    Dear Mohana,

    Not assigning, but try to change the value of limitation code in the totaling field account schedule. As I know, the maximum value is 80 chars in the totaling field with formula types. I have already debug the process, but I don't understand what kind of code that I should to changed, because actually I'm not a programmer or developer.

    Thank you for answered my question.

    DynamicsBoy

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,941 Super User 2025 Season 2 on at
    RE: Overflow Under Type Conversion of Text to Code In Account Schedule

    You are tring to assign text type variable/field to Code type variable/field in your code.

    Check the code and correct..

    You can check with Debugger also..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans