Http://www.cnblogs.com/benio/archive/2012/07/07/2580203.html
AR transactions should is created on 6-jul-2010,in fact they were generated on 25-jun-2010. Because the ship_date_actual is on 25-jun-2010.
--------------------------------------------------------------------------------
--original date:trx_date=25-jun-2010,gl_date=25-jun-2010,due_date=25-jul-2010
--------------------------------------------------------------------------------SELECT * from AR. Ra_customer_trx_all WHERE Trx_number in (' 905911 ', ' 905912 ') and set_of_books_id=89
--trx_date,ship_date_actualselect * from AR. Ra_customer_trx_lines_all WHERE customer_trx_id in (9849489,9849490) SELECT * from AR. Ra_cust_trx_line_gl_dist_all WHERE customer_trx_id in (9849489,9849490)--gl_dateselect * from Ar.ar_payment_schedules _all WHERE customer_trx_id in (9849489,9849490)
--due_date Solution:-----------------------------------------------------------------------------
UPDATE AR. Ra_customer_trx_all
SET trx_date = TRUNC (SYSDATE-2)
WHERE Trx_number in (' 905911 ', ' 905912 ') and set_of_books_id = 89; ALTER TRIGGER Ra_cust_trx_line_gl_dist_bri DISABLE; UPDATE AR. Ra_cust_trx_line_gl_dist_all
SET gl_date = TRUNC (SYSDATE-2)
WHERE customer_trx_id in (9849489,9849490);
ALTER TRIGGER Ra_cust_trx_line_gl_dist_bri ENABLE; UPDATE Ar.ar_payment_schedules_all
SET trx_date = TRUNC (SYSDATE-2),
Gl_date = TRUNC (SYSDATE-2),
Due_date = TRUNC (sysdate + 28)
where customer_trx_id in (9849489,9849490); new collections ar_cash_receipts_all status Unapp-- Indicates that the ar_cash_receipt_history_all status is cleared, Current_record_flag is Y--means settlement, ar_payment_ Schedules_all amount_due_original is the negative amount of the receivable-the original amount of the payment Ar_payment_schedules_all amount_due_remaining A negative number for the amount of the payment--the ar_payment_schedules_all status op-Represents a valid plan reversal -- Stop payment ar_cash_receipts_all status changes to Stop ar_cash_receipt_history_all add a record with a status of reversed and Current_record_flag to Y. The Current_record_flag of the original record is set to the empty ar_payment_schedules_all state to Cl, and amount_due_remaining becomes 0 -- Reverse the receipt Ar_cash_receipts_all the status to Rev ar_cash_receipt_history_all adds a record with a status of reversed and Current_record_flag to Y. The Current_record_flag of the original record is set to the empty ar_payment_schedules_all status to CL, and amount_due_remaining changes to 0 verification. --Payment Cancellation ar_cash_receipts_all No change ar_cash_receipt_history_all no change ar_payment_schedules_all &nBsp;amount_due_remaining to the original remaining amount-the negative number of the logoff amount ar_receivable_applications_v write-off view adds a row Trx_number records that are written off for the collection, Amount_applied for cancellation amount, status op. --refund ar_cash_receipts_all No change ar_cash_receipt_history_all no change ar_payment_ Schedules_all amount_due_remaining to original remaining amount-the negative number of the logoff amount ar_receivable_applications_v add a row to the verification view Trx_ Number is the record for the refund, amount_applied is the cancellation amount, the status is op. --cancellation or refund Ar_payment_schedules_all Amount_due_ Remaining will revert Ar_receivable_applications_v's original logout or refund record will disappear if the cancellation or refund is the original amount, the ar_cash_receipts_all status is changed to App The ar_payment_schedules_all status changes to Cl, and amount_due_remaining becomes 0 --this view is useful for direct access to the collection of information ar_cash_ receipts_v Spit Bad, R12 the collection of the bug is too many ...
To Datafix AR DATE