AR due data is incorrect due to sales order terms is wrong(It should be 90 days,not be 30days).
SOB:323 SO#302151/302152
AR:705755/705756/705757/705758
Datafix:
update ar.ra_customer_trx_all
set term_id = 1911
where customer_trx_id = 2814919;
update ar.ra_customer_trx_all
set term_id = 1911
where customer_trx_id = 2814919;
update ar.ar_payment_schedules_all
set term_id = 1911,
due_date = trunc(sysdate + 71)
where customer_trx_id = 2814920;
update ar.ra_customer_trx_all
set term_id = 1911
where customer_trx_id = 2814920;
update ar.ar_payment_schedules_all
set term_id = 1911,
due_date = trunc(sysdate + 71)
where customer_trx_id = 2814921;
update ar.ra_customer_trx_all
set term_id = 1911
where customer_trx_id = 2814921;
update ar.ar_payment_schedules_all
set term_id = 1911,
due_date = trunc(sysdate + 71)
where customer_trx_id = 2814930;
update ar.ra_customer_trx_all
set term_id = 1911
where customer_trx_id = 2814930;
阅读(1446) | 评论(0) | 转发(0) |