Monday, March 10, 2014

Dynamics GP - You are not allowed to have negative Actual Quantity - Project Accounting, Timesheets, eConnect, Smartconnect

Cause:
When you integrate or enter a timesheet into GP, and then delete it, the PAUNPOSTEDQTY and PAUNPOSTACCRREVN go into negative.
When you attempt to integrate the transactions gaain, you get the error about negative actual quantity.

To resolve this error, you must set the PAUNPOSTEDQTY and PAUNPOSTACCRREVN to 0 wherever they are < 0

Solution:
I have set the following script to run prior to my timesheet integratoins to ensure timesheets will always integrate

---------------------------------------------------------------------------------------------
update  pa01301 set
PAUnpostAccrRevN=0
,PAUnpostedQty=0
where patu=1 and PAUnpostedQty < 0 and paprojnumber='myproject '
-------------------------------------------------------------------------------------------------

Original Post that pointed us in the right direction
http://www.brianwilliams.pro/great-plains-you-are-not-allowed-to-have-negative-actual-quantity/

No comments:

Post a Comment