如何利用勤哲Excel服务器制作库存管理系统
一、系统框架:
整个系统分为四部分:基础数据,进货管理,出货管理,统计报表。其中商品的进出库采用先进先出的方法,出库价及成本价采用移动加权平均算法。
二、各模块功能说明:
基础数据:
基础数据的录入步骤:『仓库信息』->『仓库初始化』->『库存情况』->『商品表』,最后是『客户信息』和『供货商信息』。
in particular to concern to help needy people, with our work for the prosperity and well-being of the masses, with practical actions to win the trust and support of the masses. Second, we must conscientiously adhere to organizational principles. Every party member must keep in mind that he is a member of an organization, always and everywhere is to
进行仓库初始化时,只需新建一张『仓库初始化』表单,不需要手工录入任何数据,系统自动把当前的库存信息提取过来,直接保存即可。注意,仓库初始化表单只能填写一张,在保存第二张时,系统会给出相应提示。
『商品表』中的“当前库存数量”和“当前库存金额”不需手工录入或计算。当前库存数量等于该产品在各个仓库总的数量和。填写一种产品的『商品表』,该商品的信息在保存in particular to concern to help needy people, with our work for the prosperity and well-being of the masses, with practical actions to win the trust and support of the masses. Second, we must conscientiously adhere to organizational principles. Every party member must keep in mind that he is a member of an organization, always and everywhere is to
Excel服务器
的时候同时插入一条记录到相应的仓库的『库存情况』表中,同时也插入入库ID,入库ID
使用当前系统日期时间。
in particular to concern to help needy people, with our work for the prosperity and well-being of the masses, with practical actions to win the trust and support of the masses. Second, we must conscientiously adhere to organizational principles. Every party member must keep in mind that he is a member of an organization, always and everywhere is to
备注:
商品的进出库采用先进先出的方法。大致的解决思路如下:
(1)建立“库存情况”模板,保存商品的入库明细;
(2)整理好仓库信息后,进行仓库初始化,有几个仓库,就建立几张“库存情况”报表,
“库存情况”表。这时,各个仓库的库存情况明细表为空,明细表的并且一个仓库对应一个
信息不是靠手工录入的,是通过填写“商品表”和“入库单”时插入进来的。 (3)录入商品信息,插入明细信息到对应仓库的“库存情况”里。
(4)注意:录入入库单和出库单时,选择商品编号后,系统自动提取商品明细。入库单是从“商品表”里提数据的,而出库单是从“库存情况”里提数据的。
(5)入库ID填充的是当前的系统日期时间。
in particular to concern to help needy people, with our work for the prosperity and well-being of the masses, with practical actions to win the trust and support of the masses. Second, we must conscientiously adhere to organizational principles. Every party member must keep in mind that he is a member of an organization, always and everywhere is to