35
Hi all, I ran into the following problem: my screen shows 3 budget files in Budget Selection window, but one of them doesn't have Budget ID (although has Description and Year). Not sure what happenned, but somehow the ID was erased. I can't delete the file and it interferes with reports I'm trying to run in Management Reporter (it gives me a message about internal error). How can I delete this budget? Thanks for your help! Elvira
*This post is locked for comments
Hi Elvira,
You can update the BUDGETID field in the Budget Master table (GL00200).
Run the script below to check the DEX_ROW_ID:
SELECT DEX_ROW_ID, * from GL00200 where BUDGETID = ''
Then run the script below to update:
UPDATE GL00200 set BUDGETID = 'XXX' where DEX_ROW_ID = Y
**where XXX is the Budget ID and Y is the DEX_ROW_ID from the first script result.
Kind Regards,
Tristan
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#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
Share
Report
All responses (
Answers (