|
楼主 |
发表于 2007-10-1 10:50
|
显示全部楼层
<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><b><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">问题来啦…<span lang="EN-US"><p></p></span></span></b></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">1. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">在辅助项目里新增数据之后 <span style="COLOR: blue;">凭证录入</span> 里的各查询下拉列框无法将新增的数据显示列出来<span lang="EN-US">?<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span></span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">我的土办法是去属性里重新指定数据源<span lang="EN-US">,</span>这样太费事了<span lang="EN-US">,</span>其他的属性看不大懂<span lang="EN-US">,</span>没改成功<span lang="EN-US">,</span>望各位指点迷津<span lang="EN-US">.<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">2. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">公式简化<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">=IF(F4=0,"",IF(ISERROR(VLOOKUP(F4,</span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">辅助项目<span lang="EN-US">!A:C,3,FALSE)),"e...</span>出错啦<span lang="EN-US">!",VLOOKUP(F4,</span>辅助项目<span lang="EN-US">!A:C,3,FALSE)))<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">=IF(OR(LEFT(F4,4)="1001",LEFT(F4,4)="1002",LEFT(F4,4)="1009"),"</span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">现金流量<span lang="EN-US">",IF(OR(LEFT(F4,4)="1131",LEFT(F4,4)="1133"),"</span>客户<span lang="EN-US">",IF(OR(LEFT(F4,4)="2121",LEFT(F4,4)="2181"),"</span>供应商<span lang="EN-US">",IF(OR(LEFT(F4,4)="4101",LEFT(F4,4)="4105"),"</span>部门核算<span lang="EN-US">","e</span>…<span lang="EN-US">"))))<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">=IF(Q4<>"</span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">客户<span lang="EN-US">","",IF(ISERROR(VLOOKUP(V4,</span>辅助项目<span lang="EN-US">!H:I,2,FALSE)),"e...</span>出错啦<span lang="EN-US">!",VLOOKUP(V4,</span>辅助项目<span lang="EN-US">!H:I,2,FALSE)))<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span></span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">以上这些公式<span lang="EN-US">,</span>我自己看了都恶心<span lang="EN-US">,</span>但我就这个水平了<span lang="EN-US">,</span>还望高人点化<span lang="EN-US">,</span>谢谢<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">3. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">非末级会计科目提示问题<span lang="EN-US">,</span>我头脑中的一个大问号</span><span lang="EN-US" style="FONT-SIZE: 14pt; COLOR: red; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">?</span><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><p></p></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">4. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">由于核算的因素<span lang="EN-US">, </span><span style="COLOR: blue;">凭证录入</span>该表设计的很繁杂<span lang="EN-US">,</span>能不能将各列并在一起<span lang="EN-US">,</span>同时达到相同的效果<span lang="EN-US">?<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span>VBA</span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">小民就不会了<span lang="EN-US">,e</span>…<span lang="EN-US">,</span>用函数可以解决吗<span lang="EN-US">?<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">5. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">总账与明细账<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span></span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">这两个表我懒得做<span lang="EN-US">,</span>总账可以参照<span lang="EN-US">P&L</span>做<span lang="EN-US">,</span>明细账嘛<span lang="EN-US">,</span>可以在序时账里通过筛选的方式<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span></span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">我已在<span style="COLOR: blue;">用友序时</span>账<span lang="EN-US">K</span>列做出即时余额<span lang="EN-US">,</span>累计发生额就算了<span lang="EN-US">.<p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">6. </span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">为什么<span lang="EN-US">BS</span>不平<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><span style="mso-spacerun: yes;"> </span></span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">我只是随便录入个数据<span lang="EN-US">,</span>没有做月末结转<span lang="EN-US">,</span>当然不平啦<span lang="EN-US">,</span>这是不是问题的问题啦<span lang="EN-US">,</span>嘿嘿<span lang="EN-US">..<p></p></span></span></p><b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">OK,</span><span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">打包上发吧</span></b> |
|