News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) New Budget Upload

Microsoft Dynamics NAV (Archived)

New Budget Upload

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Can you upload budget information with the budgets split out over cost centres???

So, I have a total budget of say £4500 for G/L Account 123456, split across 3 cost centres like below:

eg. G/L Account 123456 - Food, with £1000 in cost centre 00000, £1500 in cost centre 00001, 2000 in cost centre 00003 and so on.

When I export budget to excel and split this out I get an error when trying to upload, saying - you cannot import the same information twice, the combination G/L Account No. - Dimensions - Date must be unique.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

MS Dynamics NAV 55 on at

Like (0)

Report

RE: New Budget Upload

First of All you need to select Cost Center in "Show as Columns", now run export to excel and fill data then import.

Make sure same G/L Account No., Cost Center Value and Date can not be available in multiple row.
Community Member Microsoft Employee on at

Like (0)

Report

RE: New Budget Upload

How exactly you tried to export and split the budget?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans