Wednesday, January 16, 2013

Year-End Purchase Order Process and Encumbrance

We've been using the new encumbrance feature provided by DAX 2012 to create commitments at time of purchase order confirmation. It works quite well compared with our previous method, which was to use product receipts to represent commitments. However, we've ran into an issue that has greatly complicated our year-end process.

When closing a fiscal period, the outstanding purchase order encumbrance is relieved from the budget on closing of the current fiscal period and added back on opening of the next fiscal period. Pretty straight forward, right?

Well, when the encumbrance is reversed, the original transaction is reversed as per the reverse transaction functionality in AX. This means that if your account structures have changed throughout the year for whatever reason, you will not be able to reverse the transactions without reverting the account structure. 

So, you perform the year-end process for the purchase orders under the original accounting structure and then the new accounting structure. Everything should be good, right?

But what about purchase orders that were committed under the original accounting structure and then amended and committed under the new accounting structure. You now have two transactions under different accounting structures that are trying to be reversed under a single accounting structure. As expected, the year-end process fails and you're stuck.

Microsoft has released a hotfix (http://support.microsoft.com/kb/2579432) to address similar issues in other areas. With any luck, we'll get something similar for purchase order year-end processing.

More information on the purchase order year-end process can be found at:
http://technet.microsoft.com/en-us/library/hh209300.aspx


No comments:

Post a Comment