EBS Intercompany Financial Reconciliation 通常涵盖两个层面——GL余额级靠ICP段匹配应收/应付和子模块明细级AGIS/IC Invoicing AR↔AP匹配。下面给你一份可直接落地的Excel/BI模板字段定义及EBS标准并发程序说明。一、Intercompany Reconciliation 报告模板推荐字段结构这是按月末关账用的公司间往来对账明细模板适用于按 COA 的 Company Segment Intercompany(Trading Partner) Segment 抽取 GL 日记账或 SLA 分录后做双向匹配。 Sheet 1 — IC Reconciliation Summary按法人对汇总列名说明数据来源示例Provider Ledger提供方账簿GL_LEDGERS.LEDGER_NAMEProvider LE提供方法人实体XLE_LE_BASICINFO_VProvider Company Seg提供方公司段值GL_CODE_COMBINATIONS.SEGMENT1Receiver LE接收方法人实体XLE_LE_BASICINFO_VReceiver Company Seg接收方公司段值(ICP段值应Provider Company)GCC.Segment_ICPAccounting Period会计期间GL_PERIODS.PERIOD_NAMECurrency本位币或附加重算币种GL_BALANCES.CURRENCY_CODEIC Receivable Balance (Provider Dr)提供方IC应收/借项余额GL日记账IC科目 Dr NetIC Payable Balance (Receiver Cr)接收方IC应付/贷项余额GL日记账IC科目 Cr NetDifference​IC Receivable - IC Payable应为0计算列StatusMatched / Unmatched / VarianceIF(Diff0,OK,Review) Sheet 2 — IC Journal Lines Detail可下钻明细列名说明LE / Ledger法人/账簿JE Batch / Header / Line #GL_JE_BATCHES / HEADERS / LINESJE Date / GL Period过账日期、期间Account CCID (含ICP段)GL_CODE_COMBINATIONS_KFVICP Segment ValueTrading Partner CompanyDr / Cr Amount (LC)本位币借贷Transaction Currency / Amount原币AGIS/AR/AP来源Source (AR/AP/AGIS/Manual)GL_JE_SOURCESSubledger Ref (Trx Number/Inv#)RA_CUSTOMER_TRX_ALL.TRX_NUMBER 或 AP_INVOICES_ALL.INVOICE_NUMXLA AE Header IDXLA_AE_HEADERS.AE_HEADER_ID可链接SLA溯源Match KeyProviderLEReceiverLEPeriodInvRef用于双向匹配 Sheet 3 — AGIS / IC Invoicing Subledger Match可选用于匹配 AGIS Transaction 或 IC Invoice 两边是否均已过账字段说明Trans TypeAGIS / IC Invoicing (Internal SO→AR/AP)Batch / Transaction NoFUN_TRX_HEADERS_ALL.TRX_NUMBER 或 OM Order NoInitiator LE / OU借方LERecipient LE / OU贷方LEInitiated Amount / CurrencyFUN_TRX_LINES_ALL.ENTERED_AMOUNTInitiator GL Posted Y/NCreate Accounting状态Recipient GL Posted Y/NCreate Accounting状态AR Invoice# (Initiator)RA_CUSTOMER_TRX_ALL.TRX_NUMBERAP Invoice# (Recipient)AP_INVOICES_ALL.INVOICE_NUMVariance Flag未过账 / 金额不等需人工排查二、EBS 标准程序说明可直接用不用完全自建EBS R12 自带 Intercompany Reconciliation 支持无需100%从零开发AGIS Reconciliation提交并发请求 →Intercompany Reconciliation Data Extract Program参数Transacting/ Trading Ledger、LE、GL Period、Additional Currency/Rate输出 XML Publisher 报告含Reconciliation Period Summary按LE Pair汇总IC应收vs应付余额及差异Summary by Source按Journal Source展开Journal Lines Report可drill到GL/SLA/AR/AP源单据IC Invoicing物料驱动对账标准报表Intercompany Invoice Reconciliation ReportXMLP或基于RA_CUSTOMER_TRX_ALLAP_INVOICES_ALL用 ICP Supplier Site 关联做自定义SQL三、架构师实施建议COA必须有ICP段若无Trading Partner Segment只能靠AP Supplier Site标识内部公司匹配难度大幅增加唯一IC往来科目建议每对LE设独立IC应收/应付CCID或用第三平衡段简化自动对账逻辑先跑 Create AccountingAR/AP/INV/AGIS 均走SLA未过账的分录不会出现在GL对账中差异根因排查顺序期间错配 → 汇率不同 → 一方未过账 → 手工GL调整未走IC科目 → 取消/贷项未同步