收付款单退款的逆操作脚本

by limingk 2015.7.9 19:24

注:脚本执行有风险,对于客户正式环境请在研发指导下执行。

3.0sp之前是没有收付款单退款的逆操作,如果客户确实有这样的需求,需要脚本处理

总体思路为

1.已经核销的先删除核销单:将核销单的来源和转回标识修改后手工删除核销单
select Source,IsExistReverse,* from AP_APApplyHead where DocNo in ('APP-1408003366')
--update AP_APApplyHead set Source=0,IsExistReverse=0 where DocNo in ('APP-1408003366')

2.转了暂付的删除暂付款:改标识后手工删除

select IsReversed,* from AP_apBillHead where DocNo='AP-3275'
--update AP_apBillHead  set IsReversed=0  where DocNo='AP-3275'

3.删除付款单:改标识后手工删除

select SrcType,IsReversed,* from AP_PayBillHead where DocNo='Py-1405000806'
--update AP_PayBillHead set IsReversed=0 where DocNo='Py-1405000806'
--update AP_PayBillLine set IsReversed=0,IsReversedUI=0 where PayBillHead=1001908244650243

4.删除操作日志

select * from AP_PaymentProcessLog where PayBillHead=1001908244650243
delete from AP_PaymentProcessLog where PayBillHead=1001908244650243

Tags:

F财务

评论 (6) -

Mwaffak Rabih 美国 wrote at 2016/6/17 19:47:58 #

great put up, very informative. I'm wondering why the other experts of this sector do not realize this. You should continue your writing. I'm confident, you've a huge readers' base already!

Mwaffak Rabih Dentist 美国 wrote at 2016/6/20 21:24:11 #

Oh my goodness! Impressive article dude! Many thanks, However I am experiencing difficulties with your RSS. I don't understand the reason why I can't join it. Is there anybody else getting the same RSS issues? Anyone that knows the solution will you kindly respond? Thanks!!

trolling motor battery 美国 wrote at 2016/6/26 21:35:00 #

Hello there! I could have sworn I've been to this blog before but after looking at some of the posts I realized it's new to me. Anyways, I'm definitely delighted I stumbled upon it and I'll be bookmarking it and checking back frequently!

Mwaffak Rabih Dentist 美国 wrote at 2016/6/28 14:55:14 #

I'm not sure exactly why but this blog is loading extremely slow for me. Is anyone else having this issue or is it a issue on my end? I'll check back later on and see if the problem still exists.

Mwaffak Rabih Dentist 美国 wrote at 2016/6/28 21:52:47 #

Have you ever thought about adding a little bit more than just your articles? I mean, what you say is valuable and all. However imagine if you added some great graphics or videos to give your posts more, "pop"! Your content is excellent but with pics and video clips, this website could undeniably be one of the best in its niche. Awesome blog!

best battery for trolling motor 美国 wrote at 2016/7/2 1:20:09 #

Wow that was unusual. I just wrote an extremely long comment but after I clicked submit my comment didn't appear. Grrrr... well I'm not writing all that over again. Anyway, just wanted to say superb blog!

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
653641 条评论
11 次评分
234065 次访问
访问统计开始于 2019年12月15日
平均日访问 5443 次
当前 89 人在线