Accounts Payable

Accounts Payable and Alternate Currencies

Alternate Currency AP Checks

Accounts payable checks can be issued against banks whose currency differs from the local currency for the financial enterprise. The banks must be set up in program SPBM, Bank Code Maintenance, with the appropriate alternate currency and the cash account assigned the same currency. For checks drawn on alternate currency banks, the alternate currency amounts are preserved all the way through posting to the general ledger and the local accounts are calculated by the system based on the alternate currency rates.

Some forms will display amounts for vouchers and payments from alternate currency banks in green.

To handle possible currency gain/loss postings, set up the CURR accounts payable general ledger posting type.

When accounts payable journals are posted to the general ledger, all of the alternate amounts are include, regardless of whether a given account has a matching alternate currency attached. During processing with program GLJP, GL Journal Transaction Posting, if the account being posted to has the same currency as the journal, the alternate amounts are posted. Otherwise the alternate amount is calculated from the local amount during the posting process.

 

APCC, Check Commitment Listing

Amounts on these reports are displayed in the currency assigned to the bank for the check batch.

APCK, Check Register Report

Modified for alternate currency changes. Added currency code and description to report.

APCL, Check Reconciliation Listing

New report that lists the checks printed for a bank and whether they have cleared. The report can be printed by date range or by check number range.

APCM, Check Maintenance

Banks change is restricted to banks with the same currency as the previous currency assigned to the check.

Added the ability to void missing checks, which are check numbers that are missing from the check sequence, and to enter the cleared date and amount.

APCT, Check Register Report by Date

Amounts on these reports are displayed in the currency assigned to the bank for the check batch.

APCU, Check Update Process

Amounts on this report are displayed in the currency assigned to the bank for the check batch.

Added Include Voids pop-list to the parameter form. . If you wish voided checks to be included on the report, set this pop-list to Yes. If you want to exclude voided checks from the report, set this pop-list to No.

APEM, AP Enterprise Maintenance

New Print Zero Checks flag. If the flag is set to on, when printing checks, vendor checks that totals zero will still be assigned a check number and printed. If this flag is set to off, if a vendor's check totals zero, the vendor's vouchers will be removed from the check run in program APPS, Payment Selection of Invoices by Range.

APII, Invoice Inquiry by Voucher

Added payment currency code to invoice information.

APMM, Manual Check Maintenance

Alternate Currency and Manual Checks

Manual checks are entered in the currency assigned to the bank from which payment is being made. When entering checks for a bank that has a currency that differs from the local financial enterprise currency, you can only select invoices with the same currency code as that assigned to the check.

*     For example, if the vendor has invoices entered for the USD currency code and the CAD currency code, there must be two manual checks entered, one for the USD invoices and one for the CAD invoices.

Check amounts and payment amounts should be entered in the bank's currency. If you are entering checks for a bank with a currency that is different than the financial enterprise's currency, the Local Equivalent field displays the amounts converted into the local currency.

If the bank entered is assigned the local currency and you are paying invoices with an alternate currency, enter the currency of the invoices being paid in the Invoice Currency field. The Conv Amount field is displayed for the entry of the check amount in the invoice currency and the Check Amount field is displayed for the entry of the check amount in the local currency.

APPI, Invoice Inquiry by Payment

Added payment currency field.

APPS, Payment Selection of Invoices by Range

The New Print Zero Checks flag in program APEM, AP Enterprise Maintenance, determines whether or not zero value checks will be assigned a check number and printed during the check run.

*     If the flag is set to on, when printing checks, vendor checks that totals zero will still be assigned a check number and printed.

*     If this flag is set to off, if a vendor's check totals zero, the vendor's vouchers will be removed from the check run in program APPS, Payment Selection of Invoices by Range.

To view possible negative checks on the standard selection screen, set the Query Possible Negative Checks flag to on. Negative checks are caused when the voucher count for a vendor is greater than the number of lines per check and the No Overflow Checks in Check Run flag is set to on in program SPBM, Bank Code Maintenance.

On the standard selection screen, to view vendors for which the selection will result in a zero payment, set the Query Zero Payments flag to on.

Credit memos are now displayed in red in this program during invoice selection.

Alternate Currencies and Computer Generated Checks

The bank assigned to the check batch determines the currency. Computer generated checks are printed the currency assigned to the batch. You can select vendor invoices for any currency.

The payment and discount amounts displayed in this program are displayed in the currency assigned to the bank.

 

APQC, Quick Check - Single Vendor

New program in which users select invoices and print a check for a single vendor. The check is printed in pdf format.

APRG, Recurring Invoice Generation

Added Currency field to the first page. Recurring voucher batches are restricted to a single currency. Recurring vouchers will only be queried and generated for banks that have the same currency as the one entered here.

APVC, Voided Check Maintenance

Voiding a check with an alternate currency may result in a posting to the gain/loss account assigned to the CURR posting type.

APVM, Voucher Entry/Maintenance

Alternate Currency and Voucher Entry

Voucher batches must be entered in a single currency, assigned to the batch on the first page. All voucher amounts for the batch and the vouchers assigned to the batch are entered and displayed in the assigned currency.

The bank for the voucher batch will have the same currency as the batch. Only banks with an account type of Company or Both can be entered for a voucher. The bank currency can not be different than the voucher currency. The currency codes for the invoice/voucher, purchase order, and bank are displayed in the program.

Vendor vouchers are entered in the same currency as the voucher batch, regardless of the currency assigned to the vendor in program VEMM, Vendor Master Maintenance.

The general ledger accounts to which the voucher amounts are distributed can be assigned a different currency than the voucher.

The purchase order information will be displayed in the currency assigned to the voucher batch, regardless of the currency in which it was entered.

 

APVP, Voucher Transactions Processing

Modified to handle alternate currency changes. Added batch currency to Posted Voucher Edit Listing. Added bank ID and currency to Prepaid Check Listing.