【问】分店数据上传后,很多采购收货单总部查询不到 | ||
【适用版本】商锐9 | 【模块】采购管理 | 【点击数】61 |
【知识编号】P2016022500007 | ||
【问题描述】分店数据上传后,很多采购收货单总部查询不到 |
可以执行下面语句,门店上传数据到总店,
use hbposev9_Branch
go
–采购收货单
update t_pm_sheet_master set com_flag = ‘0’ where trans_no = ‘PI’
go
update t_fm_recpay_flow set com_flag = ‘0’ where voucher_no like ‘PI%’
go
–采购退货单
update t_pm_sheet_master set com_flag = ‘0’ where trans_no = ‘RO’
go
update t_fm_recpay_flow set com_flag = ‘0’ where voucher_no like ‘RO%’
go
–扣补单
update t_pm_sheet_master set com_flag = ‘0’ where trans_no = ‘KB’
go
update t_fm_recpay_flow set com_flag = ‘0’ where voucher_no like ‘KB%’
go
门店执行后,全部数据传输,总部导入,