财务进销存管理息系统设计说明书.doc

勤哲EXCEL服务器财务进销存系统 系统流程图： 1 基础数据： 2 （1）基础信息： 2 （2）财务信息： 4 业务数据： 5 （1）进货业务： 5 （2）销售业务： 5 （3）库存业务： 6 （4）零售业务： 8 （5）借欠业务： 8 （6）代销业务： 8 （7）财务业务： 8 数据查询： 10 （1）销售查询： 10 （2）财务查询 10 （3）进货查询 11 （4）库存查询 11 （5）综合查询 11 （6）往来查询 11 系统流程图： 基础数据： （1）基础信息： 【商品信息】 录入一张【商品信息】表，这里对几点进行说明： 输入“商品全名”后，“拼音码”是自动生成的； “商品编号”是系统自动生成的，具体需要何种样式，都可以根据实际需要在“管理控制台”中更改。（本系统用到的表单中，如果有“编号”，都是通过系统自动生成的，十分便捷）。 “单位关系是指基本单位和辅助单位间的换算比例，数量关系是 　　基本单位量=单位关系*辅助单位量； 　　比如，某商品基本单位是个，辅助单位是件，单位关系是20，则有(1件)*(20个/件)=(20个) 应收应付款上限,即往来单位信用额度，往来单位能够欠款的最大限度，设置此额度后，开销售单时将会有一些提示。　　提现：即从银行提取现金； 　　存现：即将现金存入银行； 转账：本系统的转账是指从一个银行存款账户转入到另一个银行存款账户。若是存现业务，选择相应的银行账户，付款账户选择现金； 　　若是转账业务，账户选择转入的银行账户，付款账户选择转出的银行账户。? ? 收支必须单据才能保存。 to West rear, to County Shen Liqun report guerrillas breakout Hou of action situation, boat via Zhejiang wuxing daughter town Shi, six people has a NI surname spies (enemy) midway tuogu landing tipsters, away from small town three in Xu, was day Elves Li Taishan Department captured, five people all killed, broken corpse sank Yu River in the. On January 18, 1943, when the Japanese army militiamen arrested 53 people in Wuzhen, transferred to the tomb of the former Japanese military police command (in the Tai Jiang Yuan), the 28th in Shenyang North of jade bang massacred them. Hu Maosheng knife wounds woke up in the middle of them, crawling out from the dead, in the tomb of Gao Changhai residents, saved by bing. Such as Hu Maosheng, Gao Changhai is a witness to this tragedy. (B) in memory of massacre Xu Youyong yan tomb is the copper law. Copper originally was called Luo yan Tomb, because Eastern Han dynasty distinguished prose poems my father yan Tan bogey was buried in the towns water. Has a long history here, cultural atmosphere, and there are many old houses, and left many people with lofty ideals. Business flourished here, is the hub of four townships of agricultural and sideline products, wine culture has a long history. The outskirts of the town has left, Huang Chi, originally Yue wa