The following steps will allow you to update an invoice Description.
- Find the invoice range that needs to be updated by Cyce Batch ID
- Confirm the incorrect invoice_Description_Id. You will need to know what they use under the ar_invoice description
- Update the invoices with correct Invoice_description_id
select * into ar_invoice_100204 from ar_invoice where invoice_number > 726230 and Invoice_Number < 731991 and invoice_description_id = 11
update AR_Invoice set invoice_description_id = 2 where invoice_number > 726230 and Invoice_Number < 731991 and invoice_description_id = 11
select * from ar_invoice where invoice_description_id = 11 order by invoice_date desc
