AP模組 Payment 於Create Accounting 產生APP-SQLAP-10710錯誤

civilhunter

您好!
依照您提供的解決方式，已經分別完成前兩步驟 :
--1.将状态回复到初期状态
UPDATE ap_checks_all a
SET A.STATUS_LOOKUP_CODE = 'ISSUED' ,
A.MATURITY_EXCHANGE_RATE = ''
where  A.CHECK_ID = 67870

--2.删除历史记录
delete ap_payment_history_all a
where a.check_id = 67870

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

3.按正确的方法重新做
==> 外币信用证到期，USER做的时候没先选择汇率，即改变了状态，故产生问题.

請問接下來的步驟，是否先選擇匯率呢?
可否告知該怎樣正確執行後續的步驟呢?
謝謝您!

feixiang007

关注！

jhua_lu

Cannot Account for maturity of 華南商銀竹南支存 bank account's check num
ber 692435101 because the maturity is in a foreign currency and no exchange rate
has been provided
Cannot Account for maturity of 華南商銀竹南支存 bank account's check num
ber 6924352 because the maturity is in a foreign currency and no exchange rate h
Cannot Account for maturity of 華南商銀竹南支存 bank account's check num
ber 6924347 because the maturity is in a foreign currency and no exchange rate h
Finished accounting all the events created. Submitting Accounting Entry Report..

我沒有操作過，那個是以前他們有發生的解決方法，看以上的信息，應該當初匯率有問題，另外是不是check　id 要下這個？
我也有些不明白，為什么立帳，怎么會與付款的表有什么關系

[ 本帖最后由 jhua_lu 于 2009-6-2 11:54 编辑 ]

civilhunter

當我依照您提供的方法做前兩個步驟之後，
Payment Actions 的 Create Accounting就變為反白，不能再點選，如下圖所示 :

只是此時該如何或是該由那邊再設定匯率呢?

另外關於check id ，可以由 下列方式取得 :
select check_id
   from ap.ap_checks_all
where check_number = '692435101'

civilhunter

本問題已經解決!!

感謝 Richard 大大先前的Post

問題原因是因為 Payments設定使用User自定的匯率，
結果 " 到期日匯率 " 採用 "央行匯率 " ，
所以就產生匯率的問題 ，

經採用Richard 大大先前的Post說明，
先執行autoRate 這個請求，
再執行Payable Accounting Process請求

然後再執行拋轉到總帳的請求，便可以順利轉到GL ..

但因為使用 AutoRate，而不是採用User自定的匯率，因此總帳的資料有一些匯差，需要再自行調整

xxzhaobb

civilhunter 发表于 2009-6-3 18:45
本問題已經解決!!

感謝 Richard 大大先前的Post

学习了。

Autorate 这个请求。 是创建汇率的。

AutoRate ProgramAutoRate uses exchange rate information in the GL Daily Rates table to enter exchange rates for any foreign currency invoices or payments that have no exchange rates. AutoRate cannot update exchange rates unless you have first defined exchange rates in the GL Daily Rates table that match the invoice or payment currency, rate date, and rate type. See: Entering Daily Rates.

If a foreign currency invoice has no exchange rate, Approval applies a No Rate hold to the invoice, which prevents payment and posting of the invoice. After AutoRate enters an exchange rate for the invoice, the next time you run Approval, the system will remove the No Rate hold. Payables will not post foreign currency payments that have no exchange rates. After AutoRate enters an exchange rate for a payment, AutoRate creates payment distributions. The payment distributions include credits to the Asset Accounts as well as any discount distributions.

The AutoRate program does not produce any output; however, if the AutoRate program creates invalid payment distributions for a foreign currency payment, Payables automatically prints the Undistributed Payments Report.