Note Encumbrance Management is enabled and all Purchase Order Documents that receive this error come from Business Portal Requisition Management.
In versions prior to Microsoft Dynamics GP 10.0 RTM, users would not receive the error and could get by the missing integration by encumbering the Purchase Order documents that came from Business Portal Requisition Management in either the Mass Encumbrance window or by running Encumbrance Routine Maintenance. Even though they were able to complete the receiving process there were no checks against the budget using these steps. The Mass Encumbrance window and Encumbrance Routine Maintenance would populate the Encumbrance Management tables for the Purchase Order documents so that processing against the purchase order could continue.
In Microsoft Dynamics GP 10.0 RTM and later versions, new columns have been added to the POP10100 table. Due to the addition of these columns these steps no longer allow users to continue the receiving process. When you use either the Mass Encumbrance window or the Encumbrance Routine Maintenance window to encumber the Purchase Orders, the system will encumber the Purchase Order documents allowing you to move forward with printing. However when you try to enter a shipment receipt the following error message:
In Microsoft Dynamics GP 10.0 RTM and later versions, new columns exist in the POP10100 table for the additional workflow functionality. Those columns are Workflow_Approval_Status and Workflow_Priority. These columns have a default value of 0 when Purchase Order documents are brought in from Requisition Management. The default values for a purchase order created through the Purchase Order Entry window are 9 and 2 respectively. The Requisition Management default values of 0 are not valid and this results in Encumbrance Management being unable to handle the transaction correctly.
- Manually update the tables via SQL to show the Workflow_Approval_Status field as a value of 9 and the Workflow_Priority field as a value of 2 in the POP10100.
- If manual updates are not suitable for your business you can look at creating a SQL trigger to automatically populate the data for you. If assistance is needed in creating this type of trigger please contact support and we can forward your request to Professional Services for a quote. This type of service is considered consulting and there would be a charge for creating a SQL trigger. If you want to pursue this option, contact Customer Service. To do this, telephone 888-477-7877, or visit the following Microsoft Web site:
In addition, when you look at the purchase order in the Mass encumbrance window, it displays as Pre-budget. If you encounter this situation, in addition to updating the values mentioned above, you will need to also update the ENCBSTAT field in the ENC10110 table for the purchase order to 2 (pre-encumbrance). Use the Mass Encumbrance window to Encumber and then reprint the Purchase Order.
Article ID: 2709819 - Last Review: 17 May 2012 - Revision: 1