K3 The handling of "document duplication" when ERP receivable and payable Checkout

Source: Internet
Author: User
/*
the Prompt for "duplicate documents" should be handled when the bill is payable. */-

Backup Data-	select * into T_rp_contactbal_bak from  T_rp_contactbal where fyear=2010 and Fperiod >9 and Frp=0
--	FRP  1-receivable   0-payable to  
Delete from T_rp_contactbal where fyear=2010 and Fperiod>9 and Frp=0

Delete from T_rp_contactbal where fyear=2010 and fperiod>9 and Frp=0                                                                                                                                                                                                                                                  

--	inserts into T_RP_ Contactbal SELECT * from T_rp_contactbal_bak

--drop table T_rp_contactbal_bak

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.