怎样让电脑自动用先进先出法计算出每次出库的单价?

ss6601

<P><FONT size=3>条件<FONT face="Times New Roman">:</FONT></FONT></P>
<P><FONT face="Times New Roman"><FONT size=3>1.</FONT>       </FONT><FONT size=3>现我有一个仓库不断累积更换的进销表<FONT face="Times New Roman">(</FONT>每次更新<FONT face="Times New Roman">,</FONT>月份内有可能会直接更正之前入的数据<FONT face="Times New Roman">),</FONT></FONT></P>
<P><FONT face="Times New Roman"><FONT size=3>2.</FONT>       </FONT><FONT size=3>每次入库单价已知</FONT></P>
<P><FONT face="Times New Roman"><FONT size=3>3.</FONT>       </FONT><FONT size=3>格式基本如下<FONT face="Times New Roman">:</FONT></FONT></P>
<TABLE cellSpacing=0 cellPadding=0 border=1>

<TR>
<TD vAlign=top width=79>
<P>日期</P></TD>
<TD vAlign=top width=96>
<P>入库数量</P></TD>
<TD vAlign=top width=124>
<P>单价</P></TD>
<TD vAlign=top width=127>
<P>出库数量</P></TD>
<TD vAlign=top width=71>
<P>单价</P></TD>
<TD vAlign=top width=56>
<P>结存</P></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="1" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-1</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P>
<P><FONT face="Times New Roman"></FONT></P>

</TD>
<TD vAlign=top width=124>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=127>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P><FONT face="Times New Roman">100</FONT></P></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="2" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-2</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P><FONT face="Times New Roman">100</FONT></P></TD>
<TD vAlign=top width=124>
<P><FONT face="Times New Roman">20</FONT></P></TD>
<TD vAlign=top width=127>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="3" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-3</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P><FONT face="Times New Roman">200</FONT></P></TD>
<TD vAlign=top width=124>
<P><FONT face="Times New Roman">19</FONT></P></TD>
<TD vAlign=top width=127>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="3" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-3</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=124>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=127>
<P><FONT face="Times New Roman">150</FONT></P></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="3" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-3</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P><FONT face="Times New Roman">50</FONT></P></TD>
<TD vAlign=top width=124>
<P><FONT face="Times New Roman">21</FONT></P></TD>
<TD vAlign=top width=127>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD></TR>
<TR>
<TD vAlign=top width=79>
<P><st1:chsdate w:st="on" IsROCDate="False" IsLunarDate="False" Day="5" Month="6" Year="2004"><FONT face="Times New Roman">2004-6-5</FONT></st1:chsdate></P></TD>
<TD vAlign=top width=96>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=124>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=127>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=71>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD>
<TD vAlign=top width=56>
<P>
<P><FONT face="Times New Roman"></FONT></P>
<p></TD></TR></TABLE>
<P>
<P><FONT face="Times New Roman" size=3></FONT></P>
<p>
<P><FONT size=3>问题<FONT face="Times New Roman">:</FONT>怎样用最简单的方法让电脑自动用先进先出法计算出每次出库的单价<FONT face="Times New Roman">?(</FONT>最好此表按日期重新排序后计算结果不会出错<FONT face="Times New Roman">.</FONT></FONT></P>
<P>
<P><FONT face="Times New Roman" size=3></FONT></P>
<p>
<P><FONT size=3>初步构思用领用前的结存数倒推应用的单价</FONT></P>
<P><FONT size=3></FONT></P>
<P><FONT size=3></FONT></P>
<P><FONT size=3>请各位帮忙想想办法,多谢!</FONT></P>
<P><FONT size=3></FONT></P>
<P><FONT size=3>我的邮箱是<a href="http://club.excelhome.net/mailtss6601@163.com" target="_blank" >ss6601@163.com</A></FONT></P>

[此贴子已经被作者于2004-6-18 15:51:30编辑过]

wjd74

在保证没有先使用，后补单，发生退货时，该批货未曾使用的情况下，用数据库（access）存放数据库资料，同时运用自动编号（access的一种数据格式）、货物编码、进货价格可实现先进先出，否则会很麻烦，因为我做过。

ss6601

<P>用ACCESS做也可以,请教具体怎样做?至于你说"发生退货时，该批货未曾使用的情况下"我认为退货不要紧,我当领用算了.</P>

zaqzaq

<P>发出存货的计算方法:先进后进先出法</P>
<P> BKjO55MZ.rar (99.03 KB, 下载次数: 408)

2004-6-28 23:07 上传

点击文件名下载附件
怎样让电脑自动用先进先出法计算出每次出库的单价?

</P>