库存转总账找不到凭证处理SQL脚本

    xiaoxiao2021-03-26  28

    描述:库存转总账找不到凭证:记-03-2015-02-0571 总账 凭证中可以找到 select  c.AccountMode,l.Wh,  l.AAIStatus,l.IsToGL,l.VoucherDisplayNo,l.CreatedOn,l.ModifiedOn,l.SysVersion,h.ModifiedOn,h.OriginalEntityVersion,*  --update l set  l.AAIStatus = 1  from GL_Voucher v  left join AAI_TransVoucherToGLlog gl on gl.ToVoucher = v.ID left join AAI_TransEntryHead h on h.ID  = gl.FromTransEntryHead left join InvTrans_TransLine l on l.id = h.OriginalEntity_EntityID left join InvTrans_TransLineCost c on c.TransLine = l.ID where v.VoucherDisplayCode = '记-03-2015-02-0571' and l.Org  = 1001309143153869 --select r.Code, * from UBF_Job_DailyPattern d  --left join UBF_Job_Request r on r.ID = d.Request --where d.StartTime <= '2015-03-05 08:35:05.357' and d.EndTime >='2015-03-05 08:35:05.357' ----R-QueryUnCloseDocFor-1002008221271127 ----select * from Base_Organization_Trl o where o.ID = 1001309143153869
    转载请注明原文地址: https://ju.6miu.com/read-660891.html

    最新回复(0)