Account Schedule, how to add a new column?

brytboifreak
brytboifreak Member Posts: 9
edited 2007-08-30 in NAV/Navision Classic Client
Good day!

I want to add a column in Account Schedule that will display the percentage of the corresponding Net Change and Budget. Is it possible? TIA

This is the output:

ACID-TEST ANALYSIS________NC____ %___Budget___%___Variance%
Current Assets
101__Inventory_____________500__14%___400___15%___100
102__Accounts Receivable____100___3%____20_____1%____80
103__Securities____________1000__28%___700___27%___300
104__Liquid Assets_________2000__56%___1500___57%___500
105__Current Assets, Total__3600__100%__2620___100%__980

Where should I start?
](*,)

Answers

  • AdamRoue
    AdamRoue Member Posts: 1,283
    Sorry? % related to what, % of Budget to NC? % of Variance to Budget?
    The art of teaching is clarity and the art of learning is to listen
  • brytboifreak
    brytboifreak Member Posts: 9
    Nope AdamRoue, % of Inventory to Current Asset total, % of Acc rec to Current Asset total and so on.. i would like to show the percentage of every row values in NC or Budget against their corresponding total. Let's say i have an Inventory of 500 in NC and i would like to get the percentage of inventory in the Current Asset, Total which is 3600, and it will give me a 14% answer, doing this formula (101/105)*100. How am i going to create another column that will perform the formula and display in percentage form of every row value in NC or Budget against their corresponding total? TIA

    ACID-TEST ANALYSIS________NC____ %___Budget___%___Variance%
    Current Assets
    101__Inventory__________500__14%___400___15%___100
    102__Accounts Receivable____100___3%____20_____1%____80
    103__Securities____________1000__28%___700___27%___300
    104__Liquid Assets_________2000__56%___1500___57%___500
    105_Current Assets, Total__3600__100%__2620___100%__980

    ](*,)
  • AdamRoue
    AdamRoue Member Posts: 1,283
    Hi

    I have seen this before as you can see here:
    http://dynamicsusers.net/forums/p/4959/25174.aspx#25174

    It seems there is a localisation in the US to handle this in the totalling type to set the line as a base percentage. Otherwise at the end David Cox suggests a hidden row to be used as the base percentage.
    The art of teaching is clarity and the art of learning is to listen
  • brytboifreak
    brytboifreak Member Posts: 9
    Thanks Adam, :D I think this is a localization issue. Is there anyway I can solve this matter? Help Experts! :mrgreen:
  • fl
    fl Member Posts: 184
    If I undestand your question correctly, I must tell you that this is standard functionality of Navision. You can add this supplemental column in the column layout (administration, application setup, fin. mgt., general, column layout). There you can define that this column should be a formula. In the formula field you can make the required example. See Cronus database.

    Be carefully to choose the correct column layout, the one that is used in the account shedule your are talking about.
    Francois
    Consultant-Developper

    http://www.CreaChain.com
  • brytboifreak
    brytboifreak Member Posts: 9
    Thanks fl but I already tried that but I can't produce my desired output. I think I have to customize it in Code Unit 8. By the way I'm using Phil version 4.00 SP3. Is there an easier way to make this thing? TIA :?
    ](*,)

Categories