如何通过sql查看每期的余额和收发明细
select FQTY,a.FOUTSTOCKQTY,a.FCURRENTINQTY,a.FCURRENTINAMOUNT,a.FCURRENTOUTAMOUNT,FYEAR,FPERIOD
from T_HS_BALANCE_H a
inner join T_HS_StockDimension b on a.FDIMEENTRYID=b.FENTRYID
inner join T_BD_MATERIAL c on b.FMASTERID=c.FMASTERID
inner join T_HS_OUTACCTG d on a.FID=d.FID
inner join T_HS_CALDIMENSIONS f on a.FDIMENSIONID=f.FDIMENSIONID
and f.FACCTSYSTEMID='1' and f.FFINORGID='100014' where c.FUSEORGID='100014'
and fnumber='PBL0215' and FENDINITKEY=0
如何通过sql查看每期的余额和收发明细
select FQTY,a.FOUTSTOCKQTY,a.FCURRENTINQTY,a.FCURRENTINAMOUNT,a.FCURRENTOUTAMOUNT,FYEAR,FPERIOD from T_HS_BALANCE_H a inner j...
点击下载文档
上一篇：发票云集成常见问题（十八）红冲规则下一篇：单据每行明细打印一个标签
本文2024-09-16 18:07:16发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-20078.html
相关文章
您需要登录后才可以发表评论， 登录登录 或者 注册
最新文档
热门文章
