采购订单***行执行金额不允许超过订单价税合计
实际排查报错的分录信息,基本都是有一分钱的差异,判断是系统四舍五入的算法的问题;
提单处理的单号是R20171212-1080
金蝶在线客服,建议使用“采购付款平台”来处理这个问题,但是实际的操作中,还是会遇到同样的问题;
在采购付款平台中 操作时 ,这个付款的总金额 两边是没有差异的, 是因为付款单分录的 其中两行信息有金额差异, 基本差异都是一分钱; 造成了使用上的很大的不便(且每月都有这样的单据产生,请尽快出解决方案)
同时,客户反馈说之前也是提单反馈的问题拖了两个月才得到回复。如果不能及时处理,客户表明会投诉总部某研发人员。
系统也有Bug,在下面倒数第二行中的RApply应该是Rec才对。
From POOrderEntry Src
inner join POOrder Head on Src.FInterID=Head.FInterID
left join
( Select t1.FOrderInterID as FOrderInterID,t1.FOrderEntryID as FOrderEntryID, Sum(case when t2.FCurrencyID=t3.FCurrencyID then (t1.FApplyAmountFor-t1.FPayConMoneyAmountFor)
else (t1.FApplyAmount-t1.FPayConMoneyAmount)/Convert(decimal(23,10),t3.FExchangeRate) end) as FUnPayReqPayAmountFor,
Sum(t1.FAmount) as FReceiveAmount
From t_rp_PayApplyBillEntry t1
inner join t_rp_PayApplyBill t2 on t1.FBillID=t2.FBillID
inner join POOrder t3 on t1.FOrderInterID=t3.FInterID and t1.FOrderType=t3.FTranType
Where t1.FOrderInterID>0 and t1.FOrderEntryID>0 and t3.FInterID=1170
Group by t1.FOrderInterID,t1.FOrderEntryID ) RApply
On src.FInterID =RApply.FOrderInterID and src.FEntryID =RApply.FOrderEntryID
left join
( Select t1.FOrderInterID as FOrderInterID,t1.FOrderEntryID as FOrderEntryID, Sum(case when t2.FCurrencyID=t3.FCurrencyID then (t1.FReceiveAmountFor)
else (t1.FReceiveAmount)/Convert(decimal(23,10),t3.FExchangeRate) end) as FReceiveAmountFor,
Sum(t1.FReceiveAmount) as FReceiveAmount
From t_rp_ARBillOfSH t1
inner join t_RP_NewReceiveBill t2 on t1.FBillID=t2.FBillID
inner join POOrder t3 on t1.FOrderInterID=t3.FInterID and t1.FOrderType=t3.FTranType
Where t1.FOrderInterID>0 and t1.FOrderEntryID>0 and t3.FInterID=1170
Group by t1.FOrderInterID,t1.FOrderEntryID ) Rec
On src.FInterID =RApply.FOrderInterID and src.FEntryID =RApply.FOrderEntryID
where src.FInterID =1170
求问 怎么处理的最后
你重新提个单吧,附上客户的账套,看那个提单已经关闭了,没法继续走流程了
采购订单***行执行金额不允许超过订单价税合计
本文2024-09-16 15:37:04发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-3967.html