Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Encumbrance Management

Posted on by 108

I have a customer who turned off encumbrance management over a year ago and want to turn it back on.  The issues are:

1. They have no budget for 1998 and 1999 and cannot add one because they are historical year - not really interested in opening all the years just to add these budgets which have no meaning.

2. The reason it was closed was because of years of corrupt data and nothing worked for reports.

Is there a way to enable this without going back 20+ years?  If so, how?  It's ridiculous that we cannot start this as f a specific year.

Any help would be greatly appreciated.

Thanks,

Deb Bergman.

Categories:
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Encumbrance Management

    Hi Deb, 

    Are you receiving a specific error when you try to create a budget for 1998 and 1999?  I am able to create budgets in historical years, with closed fiscal periods without issue in my system so I am curious what message you are receiving if you just pop in a dummy budget for those years.  

    Another option to consider, is that generally users would run the 'Remove Completed Purchase Orders' process frequently to move their Closed POs to history.  If they were routinely running this or even just running it once a year then any POs from those old years would not be considered for encumbrance and you would not have to set up a budget for those old years.  The only reason that we would need to track them in Encumbrance is because they have not been moved to history so they could potentially be turned into a Change Order and we would need to have a record in the Encumbrance tables created in case they did that. 

    Purchasing >> Routines >> Remove Completed Purchase Orders

    "Use the Remove Completed Purchase Orders window to move closed or canceled purchase orders to history if you are keeping purchase order history. If you aren't keeping purchase order history, the purchase orders will be removed from the system."

    This is something that should be ran anyway from time to time to maintain good performance and maybe it is, but they have some older POs that are stuck out there that need to be addressed. 

    You could pick whatever year you want, but this example would look for any POs that are not in history that have a required date lower than the year 2000 so you knew which POs the Encumbrance utility is picking up. 

    select * from POP10100 where REQDATE < '01/01/2000'

    The PO's that get moved to history to the POP30100 table should be ignored when you are enabling encumbrance. 

    I hope this helps! 

    Isaac Olson

    Microsoft Support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans