| Purpose |
| Questions and Answers |
| Multi Currency Automatic Payment Questions |
| Question 1: What is the Document Type assigned to losses? |
| Question 2: Does the system create a gain or loss when paying a domestic voucher in an alternate currency? |
| Question 3: Does the system create a gain or loss when paying foreign vouchers in a domestic currency? |
| Question 4: At which stage in the payment process is a gain or loss created? |
| Question 5: When is the conversion method defined in the General Accounting Constants used when calculating gains or losses |
| Question 6: Is it possible to record the gain and loss to the expense account instead of a single variant account? |
| Question 7: How does the system account for the difference between the exchange rate used when writing a payment and the daily exchange rate? |
| Question 9: When entering a voucher using a monetary bank account, does the bank account currency code need to be the same currency code as the voucher currency? |
| Question 10: How can you determine if a payment will be written in the alternate currency? |
| Question 11: How can I process alternate currency payments using the Speed Payment Entry Program, P0411SV? |
| Question 12: Why does the Manual Payment Journal Review (R04311) fail to display GL Distribution information for K batches? |
| Question 13: I have a domestic voucher in USD. I need to pay in another currency which is the bank's monetary currency. What is the best way to pay this Voucher? |
| Question 14: Is it possible for R04572 to print a currency code other than $ (Dollars)? |
| Unrealized Currency Gains and Losses (R04425) |
| Question 1: What is the purpose of the XJDE0003 version of the A/P Unrealized Gain/Loss Report (R04425)? |
| Question 2: Is it possible to prevent a user from submitting the A/P Unrealized Gain/Loss Report twice, causing duplicate records? |
| Question 3: Can the A/P Unrealized Gain/Loss Report (R04425) be run in a multi-threaded job queue? |
| Question 4: Why is a user unable to view the processing options for the A/P Unrealized Gain/Loss Report (R04425)? |
| Question 5: Is it possible to run the A/P Unrealized Gain/Loss Report (R04425) in proof mode? |
| Question 6: Does the system check if a gain or loss has already been generated for a voucher within a period? |
| Question 7: If the AP Unrealized Gain/Loss Report (R04425) was ran before a voucher was voided, is it possible to run it again to reverse the JX? |
| Question 8 : When running Unrealized Gains and Losses (R04425) how does the system determine which exchange rate to use? |
This document provides answers to frequently asked questions regarding multi currency automatic payments.
Answer 1: Gains and losses are assigned the same Document Type (DCT) of PG.
Answer 2: No, this scenario does not yield a realized gain or loss.
Answer 3: The system may calculate a gain or loss if there is a difference in the exchange rate between the time the voucher was created and the time the payment is created.
Answer 4: The gain or loss record is created when the payment is generated. A gain/loss record is added to the Accounts Payable Matching Document Detail table (F0414).
Answer 5: The conversion method specified in the General Accounting Constants (P0000) is used when a method is not specified in the Work with Currency Exchange Rates (P0015A) application.
Answer 6: The gains and losses that are computed when creating a payment are going to the account defined in AAI items PG and PL. The ability to capture these records in the expense account is currently unavailable, unless you associate the expense account to the PG or PL AAIs.
Answer 7: The system is unable to calculate a second gain or loss on a payment by payment basis. Therefore, the Currency Exchange Rates (F0015) needs to be current prior to writing a payment.
Answer 8: The system is unable to calculate a second gain or loss on a payment by payment basis. Therefore, you need to make sure that the exchange rate table (F0015) is current before you write the payment. You can call the bank or look on the banks website the day you create the payment file to get the daily exchange rate and update the exchange rate table accordingly. Depending on how you have set up the processing option effective date on the currency tab of the Work with Payment Group (P04571), the system will either pick up the GL payment date or the specified date to determine which exchange rate to use. This will then create a correct realized gain or loss.
Answer 9: No, if a voucher is assigned a monetary bank account, the bank account currency code does not have to be the same as the transaction currency code of the voucher when you process payments in an alternate currency. See question/answer number 1 above.
Answer 10: The R04570 output will not show the payment amount in the alternate currency, however, the currency code in the header will indicate that the payment is to be made in a third currency. The amount is converted when the payment is written.
Answer 11: You cannot use the A/P Speed Voucher Entry (Speed Payment Entry) program (P0411SV) to enter manual payments in an alternate currency. This program does not calculate currency amounts or gains and losses.
Answer 12: The Manual Payment Journal Review (R04311) is designed to work for Manual Payment batches only (Batch Type M and W). Although most of the information is displayed for Automatic Payment batches, the report is unable to search the General Ledger (F0911) for the correct information because it was designed to specifically search for Manual Payment batches.
There is not one specific report for Automatic Payment batches that contains all of the information provided for Manual Payments through the Manual Payment Journal Review (R04311). However, there are several reports that are printed during the Automatic Payment Process, including the AP Payment Register (R04576) and Create Payment Control Groups (R04570) that show the payment information. If coupled with the Post (R09801) report or the Payment Register (R09313), this should encompass all data for Auto Payments that is displayed in the Manual Payments Journal Review (R04311).
Answer 13: Since your bank in monetary in another currency, best option is to void the voucher, post the void. Re-enter voucher in foreign currency with USD as base and other currency as the transaction currency. You now can pay this voucher in the foreign monetary curency.
Answer 14: The print program R04572 is hard-coded to print $ (Dollars). EnterpriseOne provides many other print programs that are country specific (for example R04572U1 for the United Kingdom, P04572C for Canada, etc). A list of available print programs can be found in UDC table 04/PP. Some of these programs print a county specific currency symbol, whilst other do not print a currency symbol as this is part of the check stock (preprinted on the check itself).
Answer 1: This version of the A/P Unrealized Gain/Loss Report (R04425) is for reporting purposes only; it will not create additional entries for gains and losses.
Answer 2: The AP Unrealized Gain/Loss report (R04425) was designed to be submitted multiple times.
Answer 3: Yes, the A/P Unrealized Gain/Loss Report (R04425) can be run in a multithreaded job queue, even though it creates JE records in the General Ledger (F0911). However, the final decision to run the report in this manner is up to to each individual company based on their business rules and processes. It is recommended to always run the A/P Unrealized Gain/Loss Report in proof mode first. After any issues are corrected, run the UBE report again to create the necessary journal entries.
Answer 4: Processing Option Security defined within Security Workbench (P00950), can secure access to the processing options of a report. Verify the User/Role has security that allows them to access the processing options for the A/P Unrealized Gain/Loss Report (R04425).
Answer 5: The UBE does not have a proof or final processing option. However, setting Processing Option 3: Create Journal Entries to blank (do not create journal entries) acts as a proof mode and can be run multiple times within a given fiscal period.
Answer 6: Each time the A/P Unrealized Gain/Loss Report (R04425) is run, it calculates unrealized gains/losses if Processing Option 3: Create Journal Entries is set to:
The system does not flag the voucher record to indicate that an unrealized gain or loss has already been created for a fiscal period. It is recommended to run the UBE in proof mode first: processing option 3 Create Journal Entries is set to blank.
Answer 7: The AP Unrealized Gain/Loss (R04425) does not pick up voided vouchers. For a JX created on a voucher that is later voided, you can either void the JX or create an Adjustment in Work with Journal Entries (P0911).
Answer 8: The exchange rate defaults from the Currency Exchange Rates table (F0015). The effective date (EFT) determines when the exchange rate is in effect.
Answer 9: Reversing JX for Unrealized Gain Loss amount only get generated upon posting (R09801) the batch to the General Ledger.