When you get the message “The billing amount cannot be reduced to more than the previously billed amount.”
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
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
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”.
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.