如何获取从不同公司获取的值的 LookUp？

发布于 2024-11-02 16:07:58 字数 1059 浏览 0 评论 0原文

我正在尝试在处理跨公司任务时获取公司名称。

我使用以下代码来获取当前公司作为发票公司的公司名称。

 CrossCompanyPostingRules    crossCompanyPostingRulesLoc;
    int i;
    Container Comp;
    dataArea dataArea1;
    companyID company;
;


company = curExt();

    while select dataArea1  where dataArea1.id != curExt()
    {
        comp += [dataArea1.id];
    }

    for(i=1;i<=conlen(comp);i++)
    {
       com = conpeek(comp,i);
       element.company(com,company);
    }

void company(companyID name,companyID company)
{
      CompanyName companyNameLoc;
       LedgerEmSysParameters_EMS    ledgerEmSysParameters_EMSLoc;
      ;

      changeCompany(name)
      {
      select ledgerEmSysParameters_EMSLoc;
      if(ledgerEmSysParameters_EMSLoc.Invoicecompany == company)
          {
            changecompany(company)
            {
                companyNameLoc.Name = name;
                companyNameLoc.insert();
            }
          }

      }

}

在上面的代码中，我将其存储在表中，但我不需要使用表。相反，我需要使用 companyInfo 表并将记录过滤到查找中。

原文

Am trying to fetch company name while am dealing with a cross company task.

I used the following code to get the company name which has the current comapny as invoice company.

 CrossCompanyPostingRules    crossCompanyPostingRulesLoc;
    int i;
    Container Comp;
    dataArea dataArea1;
    companyID company;
;


company = curExt();

    while select dataArea1  where dataArea1.id != curExt()
    {
        comp += [dataArea1.id];
    }

    for(i=1;i<=conlen(comp);i++)
    {
       com = conpeek(comp,i);
       element.company(com,company);
    }

void company(companyID name,companyID company)
{
      CompanyName companyNameLoc;
       LedgerEmSysParameters_EMS    ledgerEmSysParameters_EMSLoc;
      ;

      changeCompany(name)
      {
      select ledgerEmSysParameters_EMSLoc;
      if(ledgerEmSysParameters_EMSLoc.Invoicecompany == company)
          {
            changecompany(company)
            {
                companyNameLoc.Name = name;
                companyNameLoc.insert();
            }
          }

      }

}

in the above code am storing it in a table but i need not want to use table. Rather than that i need to use companyInfo table and filter out the records into the lookup.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

氛圍 2024-11-09 16:07:58

我希望您能够执行以下操作：

select crosscompany DataAreaId, InvoiceCompany from ledgerEmSysParameters_EMSLoc
    group by DataAreaId, InvoiceCompany
    where ledgerEmSysParameters_EMSLoc.DataAreaId       != curExt()
       && ledgerEmSysParameters_EMSLoc.InvoiceCompany   == curExt();

仅在查询中执行此操作并创建查找表单如果需要的话。

I would expect you to be able to do something like this:

select crosscompany DataAreaId, InvoiceCompany from ledgerEmSysParameters_EMSLoc
    group by DataAreaId, InvoiceCompany
    where ledgerEmSysParameters_EMSLoc.DataAreaId       != curExt()
       && ledgerEmSysParameters_EMSLoc.InvoiceCompany   == curExt();

Only do it in a query and create a lookup form if needed.

回复收藏 0 原文

~没有更多了~