Account Schedule, how to add a new column?

brytboifreak

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?
](*,)

AdamRoue

Sorry? % related to what, % of Budget to NC? % of Variance to Budget?

brytboifreak

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

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.

brytboifreak

Thanks Adam, I think this is a localization issue. Is there anyway I can solve this matter? Help Experts!

fl

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.

brytboifreak

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 :?
](*,)