Urgent: 求救AR自動商業發票產生

Jiessie

我重新新建了訂單事務處理類型( in OM)及交易來源(in AR), 但是關鍵性的問題仍然沒有得到解決,具體問題請見附件"TEST0915".
拜託了!

ppccqq

test 0915在哪？

Jiessie

最初由 ppccqq 发布
[B]test 0915在哪？ [/B]

Sorry! 心急忘了傳上去了. 呵,呵!
現在傳上來了.  謝謝!

ppccqq

经METALINK上查证：
  
   
Oracle Receivables (including iReceivables & Trading Community) Technical Forum

         

Displayed below are the messages of the selected thread.


Thread Status: Closed

From: Kevin Lee 04-Feb-02 04:27
Subject: Autoinvoice problem


Autoinvoice problem

Delivery line within same delivery cannot grouped into single invoice. I have got one delivery (eg 1152) with multiple delivery lines which belonged to 2 sales orders. After change status in ship confirm deliveries and receivable interface for this delivery. I go to RA_INTERFACE_LINES_ALL and found that trx_number for delivery lines are different (1152 and 1152-1), ie, trx_number is assigned different number since they are belonged to different sales orders. After autoinvoice, it produces two invoices (1152 & 1152-1) which should belong to same delivery and also to same invoice (delivery number = invoice number)

setting:Profile option:WSH:Invoice Numbering Methodelivery Name

Regards,
Kevin Lee







--------------------------------------------------------------------------------

From: Oracle, Christine Rogers 05-Feb-02 21:12
Subject: Re : Autoinvoice problem


There have been several issues/bugs with this in the past. Please make sure you are using the latest minipack in both OM and AR.

11.5.AR.H - 1991140

Also, you may need to review the mandatory grouping rules and the optional rules you may or may not have setup.

If you are still having a problem with this, please log an iTAR with support.

Thank You,
Christine Rogers - Williams
AR Forum Analyst


--------------------------------------------------------------------------------



--------------------------------------------------------------------------------

Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.

ppccqq

我只能做到这一步了，还请哪位高手帮帮忙。

Jiessie

[QUOTE]最初由 ppccqq 发布
[B]经METALINK上查证：
Autoinvoice problem
Delivery line within same delivery cannot grouped into single invoice. I have got one delivery (eg 1152) with multiple delivery lines which belonged to 2 sales orders. After change status in ship confirm deliveries and receivable interface for this delivery. I go to RA_INTERFACE_LINES_ALL and found that trx_number for delivery lines are different (1152 and 1152-1), ie, trx_number is assigned different number since they are belonged to different sales orders. After autoinvoice, it produces two invoices (1152 & 1152-1) which should belong to same delivery and also to same invoice (delivery number = invoice number)
----------------------------------------------------------------------------------------------------

這正是我所遇到的頭痛問題,我也在metalink上查了相關的data,可是我還是不知怎麼解決, 感覺自己越來越暈了------
哪位大俠再幫幫忙,告訴如何解決?  TKS!

sally_ge

好久没有摸AR系统，实在是很生疏了。只能提醒一下，希望对Jiessie有点帮助。
注意将应收设置中的系统选项，事务处理和客户的标签下，清除接口表选项清除掉，这样可以使导完的有问题的订单行继续保留在接口表中。容易出现问题及时分析几个接口表中订单行的差异原因。

“自动开票”使用分组规则来确定创建发票、借项通知单和贷项通知单的方式。分组规则包含各种事务处理属性。对于相同事务处理，属性也必须相同。例如，如果事务处理编号是分组规则的一部分，且接口表中的两个记录具有不同的事务处理编号，则“自动开票”将创建两个事务处理。
应收款管理系统提供了两种不同类型的事务处理属性：必需和可选。您不能添加或删除必需的事务处理属性，但始终可以添加可选属性。
以下是表 RA_INTERFACE_LINES_ALL 的必备和可选属性的清单。
必备属性有
AGREEMENT_ID
COMMENTS
CONS_BILLING_NUMBER
CONVERSION_DATE
CONVERSION_RATE
CONVERSION_TYPE
CREDIT_METHOD_FOR_ACCT_RULE
CREDIT_METHOD_FOR_INSTALLMENTS
CURRENCY_CODE
CUSTOMER_BANK_ACCOUNT_ID
CUST_TRX_TYPE_ID
DOCUMENT_NUMBER
DOCUMENT_NUMBER_SEQUENCE_ID
GL_DATE
HEADER_ATTRIBUTE1-15
HEADER_ATTRIBUTE_CATEGORY
HEADER_GDF_ATTRIBUTE1-15
INITIAL_CUSTOMER_TRX_ID
INTERNAL_NOTES
INVOICING_RULE_ID
ORIG_SYSTEM_BILL_ADDRESS_ID
ORIG_SYSTEM_BILL_CONTACT_ID
ORIG_SYSTEM_BILL_CUSTOMER_ID
ORIG_SYSTEM_SHIP_ADDRESS_ID
ORIG_SYSTEM_SHIP_CONTACT_ID
ORIG_SYSTEM_SHIP_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_ID
ORIG_SYSTEM_BATCH_NAME
PREVIOUS_CUSTOMER_TRX_ID
PRIMARY_SALESREP_ID
PRINTING_OPTION
PURCHASE_ORDER
PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
REASON_CODE
RECEIPT_METHOD_ID
RELATED_CUSTOMER_TRX_ID
SET_OF_BOOKS_ID
TERM_ID
TERRITORY_ID
TRX_DATE
TRX_NUMBER
你说的SALES_ORDER ，及记录delivery信息的INTERFACE_LINE_ATTRIBUTE3 都是可选属性。不能起决定性作用
所以我怀疑很有可能你一个DELIVERY的发运下多个订单有些属性不一致导致会GROUP在不同发票中。出现问题后，查询
select 以上所有字段  from     ra_interface_lines_all inf

ppccqq

我怀疑是传到接口表时TRX_NUMBER就已经是两个号码了。

sally_ge

不知道，这个TRX_NUMBER是什么字段，在接口表中对应什么信息。反正我们公司上万条记录，没清除的全部该字段为空。它一定不是我举例中的发运的物料事务处理号，那个事务处理好像对应的是一个INTERFACE_LINE_ATTRIBUTEXXX的可选属性。具体哪个我自己也不记得了

Jiessie

的確在RA_INTERFACE_LINES中TRX_NUMBER就已經是兩個號碼了.