關於drop shipping訂單流程請教。

llm_leon

ERP裡有三個組織： TYO, GCI, KYO
在TYO下開SO 1114811,在KYO下發貨。



已經操作至AR接口。
接下來不知道如何操作，只知道TYO的AR接口裡有數據。
感覺TYO應該開AP給GCI, AR給客戶
而GCI應該開AP給KYO,AR給TYO.
而KYO應該開AR給GCI.

參照網上的做法，
運行Create Intercompany AR Invoices，
Autoinvoice Master Program，
Create Intercompany AP Invoices，
Payables Open Interface Import。

可是結果是一張AR或AP都沒有產生。
請教下各位高手，接下來應該如何操作？

joey__peng

Create Intercompany AR Invoices    log里面是什么信息

llm_leon

Create Intercompany AR Invoices

Arguments
--------------------
Shipping/Procuring Operating Unit ... 90
Line Description ....................

Getting The IC_CURRENCY_CONVERSION_TYPE profile
convType is Corporate

Current system time is 18-MAY-2012 08:20:58

Mark inelligible records in mmt
Current system time is 18-MAY-2012 08:21:02

Start Processing Transaction Records
No transaction records is processed for Intercompany
===========================================================================

      0 shipment transaction(s) selected.
      0 shipment transaction(s) processed.
      0 shipment transaction(s) rejected.

Concurrent request completed successfully
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program INCIAR with request ID 9215622 to start at 18-MAY-2012 08:25:19 (ROUTINE=AFPSRS)


+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PRINT   -------------+


Printing output file.
               Request ID : 9215616        
         Number of copies : 0        
                  Printer : noprint

+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 18-MAY-2012 08:21:09

+---------------------------------------------------------------------------+

llm_leon

另外，請問下，是不是這種drop shipping的訂單，走的是不是一定是內部訂單？
我提交Create Intercompany AR Invoices ，是不是應該選擇GCI啊。（GCI和KYO兩個組織我都試過了，都不行。）
0 shipment transaction(s) selected.

llm_leon

研究後，有點進展了，原來是material transaction沒有產生會計分錄的原因。不知道什麼原因cost manager就是不處理。原來是有個cost manager concurrent被手工hold了。
解決了會計分錄問題後，能看到生成了很多intercompany logical　xxx交易信息。
可是現在問題又來了，AR都產生了，可是Create Intercompany AP Invoices後，AP卻產生不了。

llm_leon

+---------------------------------------------------------------------------+
Inventory: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

INCIAP module: Create Intercompany AP Invoices
+---------------------------------------------------------------------------+

Current system time is 22-MAY-2012 16:27:18

+---------------------------------------------------------------------------+

Create Intercompany AP Invoices

Arguments
--------------------
Selling/Receiving Operatiing Unit ... 82
Header Description ..................
Line Description ....................

Start Processing Transaction Records
Start Processing Invoice ID: 658857

                       InvoiceId ........ <658857>
        Previous InvoiceId ........ <-99>
                       Global CustTrx Id ..... <804385136>
Current system time is 22-MAY-2012 16:27:22
global->txnId is 26381972 global->itemId is 4163994

========================================================
Shipping / Procuring operating unit profile

        organization_id ..... 90 < GCI Operating Unit >
        legal_entity_id ..... 89 < GCI Legal Entity >
        set_of_books_id ..... 1005 < 揚明光學(開曼)(股) >
        chart_of_accts_id ... 50278
        currency_code ....... USD

------------------------------------
Selling / Receiving operating unit profile

        organization_id ..... 82 < TYO Operating Unit >
        legal_entity_id ..... 81 < TYO Legal Entity >
        set_of_books_id ..... 1001 < 揚明光學股份有限公司 >
        chart_of_accts_id ... 50275
        currency_code ....... TWD

Start J Development Code

        Getting the OPM processFlag
        ItemId is 4163994 global->itemId = 4163994
        txnId is 26381972 global->txnId = 26381972

        Getting Transaction flow information
        OPM Item Flag = 0
        Not OPM Org
        After getting transaction flow header id
        transaction flow header id is 5826
        logicalTrxTypeCode is 5
        Getting newAccountingFlag
        NewAccountingFlag is Y
        global->trxFlowHeaderId is 5826
        global->logicalTrxTypeCode is 5

trxFlowHeaderId = 5826

shipOrgId = 90, sellOrgId = 82

-------------------------------
trx_number ........ 32323-90
customer_trx_id ... 658857
currency_code ..... USD

conversion_type ... Corporate
conversion_date ... 2012/05/17

Processing invoice line, ID = 1026452
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5826
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026452 headerId = 46000 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 258.000000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026452

Invoice Line ID: 1026452 Status: SUCCESS

Processing invoice line, ID = 1026453
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5826
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026453 headerId = 46000 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 86.000000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026453

Invoice Line ID: 1026453 Status: SUCCESS

Processing invoice line, ID = 1026455
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5826
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026455 headerId = 46000 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 172.000000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026455

Invoice Line ID: 1026455 Status: SUCCESS

End of Processing Invoice ID: 658857

===================================== End of Transaction ======================================

Start Processing Transaction Records
Start Processing Invoice ID: 658858

                       InvoiceId ........ <658858>
        Previous InvoiceId ........ <-266261328>
                       Global CustTrx Id ..... <658857>
No. of Tax Summary  Rows Inserted <1>
No. of Tax Line Rows Deleted <3>
Current system time is 22-MAY-2012 16:27:22
global->txnId is 26383442 global->itemId is 4163994

Start J Development Code

        Getting the OPM processFlag
        ItemId is 4163994 global->itemId = 4163994
        txnId is 26383442 global->txnId = 26383442

        Getting Transaction flow information
        OPM Item Flag = 0
        Not OPM Org
        After getting transaction flow header id
        transaction flow header id is 5826
        logicalTrxTypeCode is 5
        Getting newAccountingFlag
        NewAccountingFlag is Y
        global->trxFlowHeaderId is 5826
        global->logicalTrxTypeCode is 5

trxFlowHeaderId = 5826

shipOrgId = 90, sellOrgId = 82

-------------------------------
trx_number ........ 32324-90
customer_trx_id ... 658858
currency_code ..... USD

conversion_type ... Corporate
conversion_date ... 2012/05/18

Processing invoice line, ID = 1026454
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5826
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026454 headerId = 46001 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 172.000000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026454

Invoice Line ID: 1026454 Status: SUCCESS

End of Processing Invoice ID: 658858

===================================== End of Transaction ======================================

Start Processing Transaction Records
Start Processing Invoice ID: 658859

                       InvoiceId ........ <658859>
        Previous InvoiceId ........ <46000>
                       Global CustTrx Id ..... <658858>
No. of Tax Summary  Rows Inserted <1>
No. of Tax Line Rows Deleted <1>
Current system time is 22-MAY-2012 16:27:22
global->txnId is 26369534 global->itemId is 7054074

Start J Development Code

        Getting the OPM processFlag
        ItemId is 7054074 global->itemId = 7054074
        txnId is 26369534 global->txnId = 26369534

        Getting Transaction flow information
        OPM Item Flag = 0
        Not OPM Org
        After getting transaction flow header id
        transaction flow header id is 5824
        logicalTrxTypeCode is 5
        Getting newAccountingFlag
        NewAccountingFlag is Y
        global->trxFlowHeaderId is 5824
        global->logicalTrxTypeCode is 5

trxFlowHeaderId = 5824

shipOrgId = 90, sellOrgId = 82

-------------------------------
trx_number ........ 32322-90
customer_trx_id ... 658859
currency_code ..... USD

conversion_type ... Corporate
conversion_date ... 2012/03/28

Processing invoice line, ID = 1026451
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5824
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026451 headerId = 46002 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 1090.530000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026451

Invoice Line ID: 1026451 Status: SUCCESS

End of Processing Invoice ID: 658859

===================================== End of Transaction ======================================

Start Processing Transaction Records
Start Processing Invoice ID: 658860

                       InvoiceId ........ <658860>
        Previous InvoiceId ........ <46001>
                       Global CustTrx Id ..... <658859>
No. of Tax Summary  Rows Inserted <1>
No. of Tax Line Rows Deleted <1>
Current system time is 22-MAY-2012 16:27:22
global->txnId is 26369493 global->itemId is 7054074

Start J Development Code

        Getting the OPM processFlag
        ItemId is 7054074 global->itemId = 7054074
        txnId is 26369493 global->txnId = 26369493

        Getting Transaction flow information
        OPM Item Flag = 0
        Not OPM Org
        After getting transaction flow header id
        transaction flow header id is 5824
        logicalTrxTypeCode is 5
        Getting newAccountingFlag
        NewAccountingFlag is Y
        global->trxFlowHeaderId is 5824
        global->logicalTrxTypeCode is 5

trxFlowHeaderId = 5824

shipOrgId = 90, sellOrgId = 82

-------------------------------
trx_number ........ 32321-90
customer_trx_id ... 658860
currency_code ..... USD

conversion_type ... Corporate
conversion_date ... 2012/03/29

Processing invoice line, ID = 1026449
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5824
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026449 headerId = 46003 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 1090.530000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026449

Invoice Line ID: 1026449 Status: SUCCESS

Processing invoice line, ID = 1026450
Get if OM is installed
ap.lineType is 1
shipOrgId is 90 sellOrgId is 82
newAccountingFlag = 1
trxFlowHeaderId is 5824
Getting intercompany_cogs_account_id
l_gl_ccid is 2409
l_gl_ccid is 2409
invoiceLnId = 1026450 headerId = 46003 orgId = 82
setOfBooksId = 1001, vdrSiteId = 129
taxCount is 1
... Getting tax code
temp_tax_rate is 0.000000 tax_rate is -99.000000  
tax_rate is -99.000000  
taxcount = 1 taxccid = 1801 taxcode = 零稅 taxRate = -99.000000
freightccid = -1 ccid = 2409
... Creating invoice line
taxCount > 0, getting the tax rate from AP_TAX_CODES_ALL
tax rate = 0.000000
extended amount = 1090.530000
tax amount = 0.000000
... Creating tax line
....... Creating offset tax line
...
End of Processing Inovice Line ID: 1026450

Invoice Line ID: 1026450 Status: SUCCESS

End of Processing Invoice ID: 658860

===================================== End of Transaction ======================================

No. of Tax Summary Rows Inserted <1>
No. of Tax Line Rows Deleted <2>
===========================================================================

      4 Invoice Selected
      4 invoice(s) processed.
      0 Invoice Rejected


Current system time is 22-MAY-2012 16:27:22
Concurrent request completed successfully
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

+------------- 1) PRINT   -------------+


Printing output file.
               Request ID : 9216526        
         Number of copies : 0        
                  Printer : noprint

+--------------------------------------+


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 22-MAY-2012 16:27:22

+---------------------------------------------------------------------------+

llm_leon

======================================

No. of Tax Summary Rows Inserted <1>
No. of Tax Line Rows Deleted <2>
===========================================================================

      4 Invoice Selected
      4 invoice(s) processed.
      0 Invoice Rejected

不知道是不是意思著成功了，可是在ap interface裡沒有數據，導入AP接口自然也沒有數據。
各位高手們，幫忙看看啊。

llm_leon

問題解決了。
metalink查到：

The table that is populated by INCIAP is AP_EXPENSE_REPORT_HEADERS&LINES         Import program should be APXXTR (Expense Report Import) and not APXIIMPT (Payables Open Interface Import).