In making Vendor Payments, users are able to only select Bank Accounts having the same currency as the Vendor or the Company's base currency. To illustrate
Vendor A's Currency: CAD Dollars
User's Base Currency: US Dollars
Users may only pay from US Dollar bank account.
Other bank currencies are restricted from the list of available bank accounts.
There is already an enhancement request asking for:
Enhancement 229321: Transactions > Purchases/Vendors > Pay Bills > Select a bank account > Please allow access to other transactions with currencies different from the currency of the bank selected
Following are two suggested Alternate Solution that can be used in the above noted scenario when wanting to pay using a Canadian Currency Bank Account.
*Basically user will need to first pay the vendor in US dollars and then make a fund transfer from the Canadian bank account to the US bank account. Below are the steps:
Alternate Solution 1:
1. Navigate to Transactions > Purchases/Vendor > Enter Bills > List
a. Click View next to the related Bill
b. Click Make Payment
c. Select a US Bank Account with US dollars currency
d. Click Save
2. Navigate to Transactions > Bank > Transfer Funds
a. Set From Account = Canadian Bank Account
b. Set To Account = US Bank Account
c. Enter the amount paid in US Dollars in the Currency = US Dollars > Amount field
NetSuite will convert the amount to CAD.
NetSuite will use the Exchange Rate to get the CAD amount and enter the value in the Currency = CAD> Amount field
d. Click Save
Alternate Solution 2: (use if you do not want to affect the actual bank account)
I. Create a new bank account (clearing account)(in currency set in the bill)
- List>Accounting>Account>New
- Set the account name and number
- Sub account of : Cash on hand
- Then save
II. Transfer fund from the payment bank account to the new bank (clearing) account created
- Transactions>Bank> Transfer fund
- Fill up the necessary fields
- The save
III. Pay the bill using the (clearing) account
- Open the bill
- Click Make Payment
- Select the bank account to use ( new account created)
- Ensure the bill to be paid has been checked/selected
- Then save