Great Plains: You are not allowed to have negative Actual Quantity

When trying to put negative time in Great Plains project accounting in the Timesheet Entry screen, you get the following error:  “You are not allowed to have negative Actual Quantity”.GP-ActualNegative






This is caused in our environment because we import time directly into Great Plains tables, but are not updating the ‘PA Budget Master File’ table (PA01301).

I reset the values in the budget table to arbitrary positive numbers:

update  bccon..pa01301 set
where patu=1 and paprojnumber=’Project Number’


This solution fixes more than just the Actual Quantity.  The field for the Actual Quantity is PAUnpostedQty.