产品出入库及盘点系统

产品出入库及盘点系统入库明细出库明细查询表库存盘点表盘盈明细表盘亏明细表参数表使用说明使用说明1参数表需要先录入产品的名称规格型号等相关信息2入库明细和出库明细有出入库时分别在对应的表中录入即可3查询表输入产品编码即可查出对应的信息4库存盘点表需要输入上期库存若无可不输和盘点数量5盘盈盘亏明细表均为自动显示无需录入6表中蓝色底纹的单元格请勿改动入库明细表日期产品编码类别产品名称产品规格存放位置单位数量入库人1116A-001低资易耗品Name1SF-011货架件5甲1216A-002低资易耗品Name2SF-021货架个10甲1316A-003低资易耗品Name3SF-031货架套6甲1418A-004低资易耗品Name4SF-041货架箱90甲1518B-001加工件Name5JGJ-012货架件49甲1618B-002加工件Name6JGJ-022货架个58甲1718B-003加工件Name7JGJ-032货架个128甲1818B-004加工件Name8JGJ-043货架套240甲1918B-005加工件Name9JGJ-053货架个49甲11018C-001备品备件Name10BJ-014货架件83甲11118C-002备品备件Name11BJ-024货架件29甲11218C-003备品备件Name12BJ-034货架件48甲返回出库明细表日期产品编码类别产品名称产品规格存放位置单位数量出库人2818A-001低资易耗品Name1SF-011货架件1乙2918A-002低资易耗品Name2SF-021货架个6乙21018A-003低资易耗品Name3SF-031货架套25乙21118A-004低资易耗品Name4SF-041货架箱2乙返回物料编码B-001类别加工件上期结存26产品名称Name5本期入库49产品规格JGJ-01本期出库0存放位置2货架本期理论结存75单位件实盘库存95返回库存盘点表辅助列物料编码类别产品名称产品规格存放位置单位上期结存本期入库本期出库本期理论结存实盘库存盘点结果盈3A-001低资易耗品Name1SF-011货架件3251365014盈4A-002低资易耗品Name2SF-021货架个65106698516盈5A-003低资易耗品Name3SF-031货架套29625103525A-004低资易耗品Name4SF-041货架箱359021231230盈7B-001加工件Name5JGJ-012货架件26490759520亏8B-002加工件Name6JGJ-022货架个7258013078-52盈9B-003加工件Name7JGJ-032货架个62128019020010盈10B-004加工件Name8JGJ-043货架套7524003153161B-005加工件Name9JGJ-053货架个3549084840盈12C-001备品备件Name10BJ-014货架件083083852亏13C-002备品备件Name11BJ-024货架件02902927-2盈14C-003备品备件Name12BJ-034货架件048048502000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回盘盈统计明细表物料编码类别产品名称产品规格存放位置单位上期结存本期入库本期出库实盘库存本期理论结存盘点结果盈3A-001低资易耗品Name1SF-011货架件3251365014盈4A-002低资易耗品Name2SF-021货架个65106698516盈5A-003低资易耗品Name3SF-031货架套29625103525盈7B-001加工件Name5JGJ-012货架件26490759520盈9B-003加工件Name7JGJ-032货架个62128019020010盈10B-004加工件Name8JGJ-043货架套7524003153161盈12C-001备品备件Name10BJ-014货架件083083852盈14C-003备品备件Name12BJ-034货架件048048502返回盘亏统计明细表物料编码类别产品名称产品规格存放位置单位上期结存本期入库本期出库实盘库存本期理论结存盘点结果亏8B-002加工件Name6JGJ-022货架个7258013078-52亏13C-002备品备件Name11BJ-024货架件02902927-2返回产品编码类别产品名称产品规格存放位置单位A-001低资易耗品Name1SF-011货架件A-002低资易耗品Name2SF-021货架个A-003低资易耗品Name3SF-031货架套A-004低资易耗品Name4SF-041货架箱B-001加工件Name5JGJ-012货架件B-002加工件Name6JGJ-022货架个B-003加工件Name7JGJ-032货架个B-004加工件Name8JGJ-043货架套B-005加工件Name9JGJ-053货架个C-001备品备件Name10BJ-014货架件C-002备品备件Name11BJ-024货架件C-003备品备件Name12BJ-034货架件返回1需要先在基本资料表中录入各种物料的编码名称规格货架及单位2然后在入库明细按照所列内容录入日期编码数量入库人其他可以自动显示即可若需要增加记录的项目在后面自行添加即可3在出库明细中按照所列内容录入日期编码数量出库人其他可以自动显示即可若需要增加记录的项目在后面自行添加即可4产品库存表中需列出所有的产品编码并填入期初库存类别产品名称产品规格存放位置单位自动生成入库数量出库数量及库存数量可自动计算5产品查询需要输入物料编码可查询所有信息6库存表只需输入物料编码及上期库存其他项自动生成7需要盘点时需要判定时输入实盘库存盘点结果自动生成并将盘盈盘亏的物料自动汇总到盘盈统计明细表及盘亏统计明细表8所有蓝色底纹单元格的内容是有公式自动生成无需录入返回