前提:目前该发票未完成;
update ra_customer_trx_lines_all
set extended_amount=1794.87,
revenue_amount=1794.87
where customer_trx_line_id=412765;
set extended_amount=1794.87,
revenue_amount=1794.87
where customer_trx_line_id=412765;
alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI disable;
update ra_cust_trx_line_gl_dist_all
set acctd_amount=1794.87
where cust_trx_line_gl_dist_id=479231;
update ra_cust_trx_line_gl_dist_all
set acctd_amount=2850
where cust_trx_line_gl_dist_id=479430;
set acctd_amount=2850
where cust_trx_line_gl_dist_id=479430;
alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI enable;