X3产品中公式中表关系利用问题,尝试应用了一下,请大家谈谈体会
<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'">问题提出：</SPAN></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'">企业仓库物资出库，通常领用部门不同，领用物资记入不同科目。</SPAN></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'">即需要根据存货单据上的部门（需要在库存单据上设部门分析元）设置科目。</SPAN></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'">查找库存单</SPAN><SPAN lang=EN-US>STOJOU</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">表，虽然有</SPAN><SPAN lang=EN-US>CCE1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US>CCE2</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。。字段，但并没有实际填入的部门数据。</SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><?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 style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">而实际输入的分析元数据存在</SPAN><SPAN lang=EN-US>SMTVD</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（存货交易明细表）的</SPAN><SPAN lang=EN-US>CCE1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US>CCE2</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。。字段中。</SPAN></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'">因此，在</SPAN><SPAN lang=EN-US>STOJOU</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US>SMTVD</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">建立关系后，直接引用</SPAN><SPAN lang=EN-US>SMTVD</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的</SPAN><SPAN lang=EN-US>CCE1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US>CCE2</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。。字段数据即可。</SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p> </o:p></SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US>ADONIX</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">系统在建立表、索引的基础上自动建立表连接，直接引用</SPAN><SPAN lang=EN-US>SMTVD</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的</SPAN><SPAN lang=EN-US>CCE1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN lang=EN-US>CCE2</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">。。即可。</SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p> </o:p></SPAN></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'">例：杂项出库，挂接自动日记帐，</SPAN><SPAN lang=EN-US>STKIS</SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US><o:p> </o:p></SPAN></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'">根据库存领用部门设分录行：在条件栏输入公式即可：</SPAN></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'">行</SPAN><SPAN lang=EN-US>10</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（复制第</SPAN><SPAN lang=EN-US>1</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">行）：</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>200</SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">，</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'">D</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'">F</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'">C</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: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出库条件</SPAN></P><P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><FONT size=2><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>= '200' and (left$([F:STJ]ITMREF,1)= 'D' or left$([F:STJ]ITMREF,1)= 'F'<SPAN style="mso-spacerun: yes"> </SPAN>or<SPAN style="mso-spacerun: yes"> </SPAN>left$([F:STJ]ITMREF,1)= 'C')<o:p></o:p></SPAN></FONT></P>页:
[1]