AR date is inconsistent with Ship confirm date

SOB:323 SO#302144

 

Payment term: 29 ETA;

Sales order date: 13-apr-2010

Ship confirm date: 28-apr-2010

AR date: 13-apr-2010

 

 

select * from wsh.wsh_new_deliveries where delivery_id=12263514

--result:Initial_pickup_date:13-apr-2010;

 

 

UPDATE ar.ra_customer_trx_all
   SET trx_date = TRUNC(SYSDATE - 1),
   ship_date_actual = TRUNC(SYSDATE - 1)
WHERE customer_trx_id in (2811865);
 
alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI disable;

UPDATE ar.ra_cust_trx_line_gl_dist_all
   SET GL_DATE = TRUNC(SYSDATE - 1)
 where customer_trx_id in (2811865);

 

alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI ENABLE;

UPDATE ar.ar_payment_schedules_all
   SET trx_date = TRUNC(SYSDATE - 1),
   due_date = TRUNC(SYSDATE + 29)
 where customer_trx_id in (2811865);