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’