budget

himali

Dear All
Greetings!

i made a budget in nav9 classic using following information

1. budget name: test
2. show as lines: ACT ( global dimension)
3. show as colum: period quaterly


but when i export this budget in excel i got the budget in different format like

in first colum: g/L account list, in second colum: ACT code, in third, fourth and fith colum...period but i need the format

in first colum: ACT code, second colum: ACT description, third colum: G/L Account no., and period and rest of the information as we request in budget entry table.

please find the attached budget format which i exported from nav. i need ACT info in the place of G/L list, likewise, G/L list in the place of ACT.

Export Filters
Budget Name TEST-BUD

G/L Account No. Name Act Code 01-01-09 01-02-09 01-03-09
10000 ASSETS
11000 Cash & Near Cash
11005 Cash at Bank
11015 Petty Cash
14000 Accunt Receivable
14010 Accured Interest Receivable
14015 Contribution Receivable
14020 Staff Receivable - Salary Adv
14045 Staff Receivable - Travel Adv
14050 Staff Receivable - Other
14080 Misc Accounts Receivable
14085 Staff Tecv - Telephone Charges
14100 Accrued Interest Receivable
16000 Operating fund
16005 Advance to Field office


is it possible if yes, please let me know how to do it.

thank you