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.”

 

 

 

 

 

 

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’