用友通卡
2016-3-6 0:0:0 wondial用友通卡
通卡
|
如果您的问题还没有解决,可以到 T+搜索>>上找一下
相关阅读
- 会计科目期初余额表2021-5-19 11:53:48
- 会计科目少了期初余额2021-5-19 11:49:46
- 企业清算期的相关会计处理2021-4-29 16:44:39
- 企业固定资产税务筹划2021-4-29 16:43:41
- 企业生产经营中的税务筹划——出口经营中的税务筹划2021-4-29 16:43:25
- 企业收料单的妙用2021-4-29 16:43:0
- 罚补增值税如何进行账务处理2021-4-29 16:40:3
- 登记会计账簿的基本要求2021-4-29 16:39:42
- 电信业务附带赠送业务的涉税处理2021-4-29 16:39:27
- 防伪税控发票过期不能抵税2021-4-29 16:38:59
最新信息
用友U8 在销售系统中根据上年退货单今年所开红字发票在存货系统的正常单据记帐中无法筛选出来。用友U8 在销售系统中根据上年退货单今年所开红字发票在存货系统的正常单据记帐中无法筛选出来。
问题原因:经检查发现上年结转过来未开发票的退货单,在rdrecord表中其相应记录的caccounter字段不为空所以今年据其所开红字发票在存货系统的正常单据记帐中筛选不出来,解决方法:执行下面的语句更新即可:update rdrecordset rdrecord.caccounter=nullfrom rdrecord join rdrecords on rdrecord.id=rdrecords.id where rdrecords.idlsid in select idlsid from dispatchlist join dispatchlists on dispatchlist.dlid=dispatchlists.dlid where ddate<‘2003-01-01‘ and breturnflag=‘1‘ and rdrecord.caccounter is not nulland rdrecords.idlsid not in select salebillvouchs.idlsid from ia_subsidiary join salebillvouch on salebillvouch.csbvcode=ia_subsidiary.cvoucode and salebillvouch.cvouchtype=ia_subsidiary.cvoutype join salebillvouchs on salebillvouchs.sbvid=salebillvouch.sbvid where cvoutype in‘26‘,‘27‘
解决方案:
问题原因:经检查发现上年结转过来未开发票的退货单,在rdrecord表中其相应记录的caccounter字段不为空所以今年据其所开红字发票在存货系统的正常单据记帐中筛选不出来,解决方法:执行下面的语句更新即可:update rdrecordset rdrecord.caccounter=nullfrom rdrecord join rdrecords on rdrecord.id=rdrecords.id where rdrecords.idlsid in select idlsid from dispatchlist join dispatchlists on dispatchlist.dlid=dispatchlists.dlid where ddate<‘2003-01-01‘ and breturnflag=‘1‘ and rdrecord.caccounter is not nulland rdrecords.idlsid not in select salebillvouchs.idlsid from ia_subsidiary join salebillvouch on salebillvouch.csbvcode=ia_subsidiary.cvoucode and salebillvouch.cvouchtype=ia_subsidiary.cvoutype join salebillvouchs on salebillvouchs.sbvid=salebillvouch.sbvid where cvoutype in‘26‘,‘27‘
www.kuaiji66.com 天龙瑞德