按部门设置自动日记帐科目-项目案例
<P>某项目实现按部门设置自动日记帐科目,供大家参考:</P><FONT face=仿宋_GB2312><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">科目设置原则:</SPAN><SPAN lang=EN-US style="COLOR: blue"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门包、直材进生产成本。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门低、辅、维修进制造费用。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">2</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)非</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头部门,杂项领用均进制造费用(与物料类别无关)。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">2</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头的部门,杂项领用均进销售费用(与物料类别无关)。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">4</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头的部门,杂项领用均进管理费用(与物料类别无关)。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">测试案例</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">:</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><FONT color=#c43c57>测试目标:出库操作包装直材、低值维修、天然气物料出库,分部门记入不同科目。</FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">物料出库(包装、直材),出库类型</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"> MIS</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">,对应自动日记帐</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">STKZX</FONT></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">物料</SPAN><SPAN lang=EN-US><SPAN style="mso-spacerun: yes"><FONT face="Times New Roman"> </FONT></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">产品分析元</SPAN><SPAN lang=EN-US><SPAN style="mso-spacerun: yes"><FONT face="Times New Roman"> </FONT></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出库数量</SPAN><SPAN lang=EN-US><SPAN style="mso-spacerun: yes"><FONT face="Times New Roman"> </FONT></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出库单价</SPAN><FONT face="Times New Roman"> </FONT><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出库部门</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">Z0006</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">STD</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>907<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>60.68<SPAN style="mso-spacerun: yes"> </SPAN>311<SPAN style="mso-spacerun: yes"> </SPAN>410103</FONT></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><FONT face="Times New Roman" color=#c43c57>B0001<SPAN style="mso-spacerun: yes"> </SPAN>802<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN>311<SPAN style="mso-spacerun: yes"> </SPAN>410105</FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">Z0006</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">STD</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>907<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>60.68<SPAN style="mso-spacerun: yes"> </SPAN>320<SPAN style="mso-spacerun: yes"> </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410524</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">B0001<SPAN style="mso-spacerun: yes"> </SPAN>802<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>320<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410524</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">D0001</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">PMP</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>DZ<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>5<SPAN style="mso-spacerun: yes"> </SPAN>301<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410524</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">F0001</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">PMP</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>DZ<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN>68.38<SPAN style="mso-spacerun: yes"> </SPAN>101<SPAN style="mso-spacerun: yes"> </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">550225</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US><FONT face="Times New Roman">C10001</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">PMP</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">)</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"> WX<SPAN style="mso-spacerun: yes"> </SPAN>1<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>1.32<SPAN style="mso-spacerun: yes"> </SPAN>200<SPAN style="mso-spacerun: yes"> </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">550123</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#c43c57><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"></SPAN></FONT> </P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><FONT color=#941ae6>自动日记帐设置:</FONT></SPAN></P><FONT color=#c43c57><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">4</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(复制第</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行):</SPAN><FONT face="Times New Roman"> </FONT><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门包、直材出库</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">,</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">记生产成本</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=2><FONT color=#941ae6><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: red; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">[F:SMD]CCE2</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>= '311' and (left$([F:STJ]ITMREF,1)= 'B' or left$([F:STJ]ITMREF,1)= 'Z')<o:p></o:p></SPAN></FONT></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">5</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(复制第</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行):</SPAN><FONT face="Times New Roman"> </FONT><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门低、辅、维修进制造费用</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=2><FONT color=#941ae6><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: red; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">[F:SMD]CCE2</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"> ='311' and (left$([F:STJ]ITMREF,1)= 'F' or left$([F:STJ]ITMREF,1)= 'C'<SPAN style="mso-spacerun: yes"> </SPAN>or left$([F:STJ]ITMREF,1)= 'D'<SPAN style="mso-spacerun: yes"> </SPAN>)<o:p></o:p></SPAN></FONT></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">6</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(复制第</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行):<SPAN style="COLOR: blue">非</SPAN></SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">311</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">部门</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头部门,杂项领用均进制造费用</SPAN><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><o:p></o:p></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><FONT size=2><FONT color=#941ae6>left$([F:SMD]CCE2,1) ='3'<SPAN style="mso-spacerun: yes"> </SPAN>& [F:SMD]CCE2<SPAN style="mso-spacerun: yes"> </SPAN><> '311'<o:p></o:p></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">7</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(复制第</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行):</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">2</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头的部门,杂项领用均进销售费用。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><FONT size=2><FONT color=#941ae6>left$([F:SMD]CCE2,1) ='2'<o:p></o:p></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">8</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">(复制第</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行):</SPAN><SPAN lang=EN-US style="COLOR: blue"><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开头的部门,杂项领用均进管理费用。</SPAN><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-SIZE: 8.5pt; FONT-FAMILY: 'MS Sans Serif'; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><FONT size=2><FONT color=#941ae6>left$([F:SMD]CCE2,1) ='1'<o:p></o:p></FONT></FONT></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p><FONT face="Times New Roman" color=#941ae6> </FONT></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT color=#941ae6><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">注意检查修改公式中</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">CCE1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">CCE2</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">CCE3</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">CCE4</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">为</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">SMD</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">表</SPAN></FONT></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"></SPAN></FONT> </P><P><FONT style="BACKGROUND-COLOR: #ffffff">运行结果:</FONT></P><FONT color=#000000><FONT style="BACKGROUND-COLOR: #ffffff"><SPAN lang=EN-US style="BACKGROUND: yellow; FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'; mso-highlight: yellow"><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410103 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">生产成本</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">-</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">直接材料</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>60.68<SPAN style="mso-spacerun: yes"> </SPAN>311<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410105 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">生产成本</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">-</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">包装物</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN>311<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">410524 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">制造费</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">-</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">物料消耗</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN>320<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>5<SPAN style="mso-spacerun: yes"> </SPAN>301<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>60.68<SPAN style="mso-spacerun: yes"> </SPAN>320<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">550123 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">销售费</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">-</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">物料消耗</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>1.32<SPAN style="mso-spacerun: yes"> </SPAN>200<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">550225 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">管理费</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">-</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">物料消耗</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>68.38<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>101 <o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">121110 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">存货</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">- </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">原材料直接材料</SPAN><SPAN style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"> <SPAN lang=EN-US>60.68<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>311<o:p></o:p></SPAN></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>60.68<SPAN style="mso-spacerun: yes"> </SPAN>320<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">121111 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">存货</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">- </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">包装物</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>311<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt 52.5pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>0.29<SPAN style="mso-spacerun: yes"> </SPAN>320<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">121113</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">存货</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">- </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">原材料备品备件</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>1.32<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>200<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">121114</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">存货</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">- </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">原材料辅助材料</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN>68.38 <SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>101<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">121112 : </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">存货</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">- </SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'">低值易耗</SPAN><SPAN lang=EN-US style="FONT-FAMILY: 'MS Sans Serif'; mso-bidi-font-size: 10.5pt; mso-font-kerning: 0pt; mso-bidi-font-family: 'MS Sans Serif'"><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>5 <SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>301<o:p></o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"></SPAN></FONT></FONT></P><P><FONT style="BACKGROUND-COLOR: #eeeeee"></FONT></SPAN></FONT> </P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT face=仿宋_GB2312><SPAN style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"></SPAN></FONT><SPAN lang=EN-US style="COLOR: blue"><o:p></o:p></SPAN></P><P> </P>页:
[1]