To Datafix AR DATE

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.