Category Archives: Great Plains

GP – The billing amount cannot be reduced to more than the previously billed amount

When you get the message “The billing amount cannot be reduced to more than the previously billed amount.”

GPbillingamountcannotbereduced

 

 

 

 

 

 

This means the values in the table – PA01101 field –  Posted_Project_Fee needs to be larger than the amount the invoice is trying to be reduced.  You can update with :

update company..pa01101 set

paposted_project_fee=’100000′
where custnmbr=’Customer’

OR

You can fix the invoice directly without modifying the PA01101 table by adjusting the table PA13201 fields PAPreviously_Billed and PAOrigPrevBill.  You can update with :

update company..pa13201 set
PAPreviously_Billed=’100000′
,paorigprevbill=’100000′
where PADocnumber20=’DocumentNumber’

 

 

 

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

 

 

 

 

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.