AR加密箱导入是出现“Receipt number already exists

纵横四海

AR加密箱导入是出现“Receipt number already exists for this customer and amount”，查看加密箱的接口表AR_PAYMENTS_INTERFACE_ALL，发现这些数据已经能够找到，但是就是不能在发票中找到。
FIX：TAR 4417705.995 - CANNOT IMPORT LOCKBOX DATA (AR)
ACTION PLAN
============
1)
I see that the 11 receipts shown (RECEIPT_NUMBER FS0504300001 to FS0504300010) all got impor
ted today.
Could you confirm this?

2) This means, the lockbox import in general is possible but it fails for the 15 receipts mentioned only. Is that correct?


3)
I'm a bit confused about AR_PAYMENTS_INTERFACE_ALL.
I would expect to see records with error code AR_PLB_DUP_PMT (Receipt number already exists for this
customer and amount) in there, but there are none.

Could you please re-check? Was your previous select statement run from the correct instance?

4)
What version of file arlvdp.lpc are you on?

5)
Please go to AR > Receipts > Batches > View > Find
> Enter Batch Type: "Manual Quick"
> Enter GL dates: 30-APR-05
> click: Find Button

Do you see the batch with the 15 receipts?

If s

6)
Please click "ost Quick Cash" button

7) Please upload me out-file and log-file of this request (ARCAPB)

[此贴子已经被作者于2005-5-3 12:10:13编辑过]

纵横四海

1)
I see that the 11 receipts shown (RECEIPT_NUMBER FS0504300001 to FS0504300010) all got impor
ted today.
Could you confirm this?
--we can import data via process lockbox,the 11 receipts has imported by process lockbox.I confirm this.2) This means, the lockbox import in general is possible but it fails for the 15 receipts mentioned only. Is that correct?
---
yes3)
I'm a bit confused about AR_PAYMENTS_INTERFACE_ALL.
I would expect to see records with error code AR_PLB_DUP_PMT (Receipt number already exists for this
customer and amount) in there, but there are none.Could you please re-check? Was your previous select statement run from the correct instance?ok,it is correct4)
What version of file arlvdp.lpc are you on?i donnot know how to check the version of arlvdp.lpc,what is arlvdp.lpc5)
Please go to AR > Receipts > Batches > View > Find
> Enter Batch Type: "Manual Quick"
> Enter GL dates: 30-APR-05
> click: Find ButtonDo you see the batch with the 15 receipts?yes,I can see the receipts from FS0504300011 to FS0504300025If s
6)
Please click "ost Quick Cash" buttoni pressed it7) Please upload me out-file and log-file of this request (ARCAPB)eosplease reference the log file and out put file.

yyanjob

沙发，路过

zhuhgjava

我也出现这样的问题。后来才知道。通过加密箱向EBS系统导数据的时候，在验证的环节里，如果验证数据不符合EBS系统的业务逻辑需要，就会卡在加密箱接口表里。如果符合，就会直接生成AR收款数据。然后加密箱接口表会自动清理已成功导入EBS系统的收款数据。

纵横四海

zhuhgjava 发表于 2011/8/22 12:08
我也出现这样的问题。后来才知道。通过加密箱向EBS系统导数据的时候，在验证的环节里，如果验证数据不符合E ...

很久之前的帖子，居然还有人看。看来积累还是有价值的哦。