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

 

 

 

 

Resolution:

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
papostedqty=’500′
,PAUnpostedTotalCostN=’5000′
,PAUnpostAccrRevN=’5000′
,PABilled_QtyN=’5000′
,PAApproved_Quantity=’5000′
,PAUnpostedQty=5000
where patu=1 and paprojnumber=’Project Number’

 

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