请问发票怎么和发运关联

liuqiong

我现在需要通过发票找到其对应的接收数据，
我查看了发票中的分配，好像只是关联到了订单，并没有关联到每个订单所对应的接收（如果该订单有多条接收的话）。我搜索了一下，网上有人说，Ap_invoice_distributions_all的rcv_transaction_id对应Rcv_Transactions中相应字段，通过这个字段可以关联发票和接收，但是在我们系统中rcv_transaction_id是空的，Ap_invoice_distributions_all表中所有数据的rcv_transaction_id字段均为空。不知道还有没有别的字段可以关联到接收？或者别的途径可以将发票及相应接收关联起来？
麻烦高手指教，谢谢！

下载狂

看看这个吧：
AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is
manually entered or system-generated. There is one row for each invoice
distribution. A distribution must be associated with an invoice. An invoice
can have multiple distributions.
Examples of when your Oracle Payables application automatically creates rows
in this table include the following:
7 You choose a distribution set at the invoice header level.
7 You match an invoice line to a purchase order or receipt. The system uses
information from the matched purchase order or receipt to create the
distributions.
7 You match a credit or debit memo to an invoice.
7 You generate charge distributions (tax, freight, misc.) from allocation
rules.
7 You apply a prepayment or unapply a prepayment.
7 Payables automatically withholds tax.
7 Payables creates an interest invoice.
When you account for an invoice, the Payables Accounting Process creates
accounting events, accounting entry headers and accounting entry lines for
those distributions that have accounting dates included in the selected
accounting date range. The Transfer to General Ledger process can then
transfer the accounting entries to General Ledger as journal entries. Values
for POSTED_FLAG are Y for accounted distributions or N for unaccounted
distributions.
Invoice distributions can be interfaced over/from Oracle Assets or Oracle
Projects. Your Oracle Payables application sets the ASSETS_ADDITION_FLAG to U
for distributions not tested by Oracle Assets; Oracle Assets then adjusts this
flag after it tests a distribution for assignment as an asset. To avoid the
same invoice distribution being interfaced to Oracle Project and Oracle
Assets, you must interface any project-related invoice distribution to Oracle
Projects before you can interface it to Oracle Assets. If a project-related
invoice distribution is charged to a capital project in Oracle Projects,
Oracle Projects sets the ASSETS_ADDITION_FLAG to P when the PA_ADDITION_FLAG
is set to Y, Z, or T. Oracle Assets only picks up invoice distributions with
the ASSET_ADDITION_FLAG set to U, and if project-related, with the
PA_ADDITION_FLAG set to Y, Z, or T. PA_ADDITION_FLAG tracks the status of
project-related supplier invoice distributions and expense report
distributions. For supplier invoice distributions entered via Oracle
Payables, the PA_ADDITION_FLAG is set to N if the distribution is
project-related, otherwise it is set to E, and it is updated by Oracle
Projects when the distribution is processed by the Oracle Projects Interface
Supplier Invoice process. Oracle Projects sets the PA_ADDITION_FLAG to Y or Z
after the item is successfully processed, or may be set to a rejection code if
the line is rejected during transfer to Oracle Projects. See Payables Lookup
Listing for all the errors. You must correct the rejection reason and try to
retransfer the line. For supplier invoice adjustment distributions interfaced
from Oracle Projects to Oracle Payables (which must net to zero with another
distribution), the value for the PA_ADDITION_FLAG is set to T.
This table corresponds to the Distributions window.

ccpwufan

try this view apps.xla_ap_inv_ael_sl_v

apps.xla_ap_inv_ael_sl_v invsl
apps.ap_invoice_distributions aid

invsl.source_id=aid.invoice_distribution_id

please setup org before use this view

DBMS_application_info.set_client_info(org id)

liuqiong

谢谢大家的回复，我查了很多资料，也问了很多人，好像没有别的途径可以将发票及相应接收关联起来
再次感谢大家的回复

sphinx2008

能不能层层关联呢，先关联订单 再关联到接收

flymud

我们以前遇到过同样的问题，后来也仔细分析过，这个和匹配方式还是有关系的。
如果是按照定单匹配的，这个是对应不起来的，只能通过累计，来大概计算出开票数量和接收数量的大概关系。
如果是按照接收单匹配，则是可以具体到某一接收单号的。

cnana

学习了

isean

同意7楼