描述:库存转总账找不到凭证:记-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