Monday, September 17, 2018

Bill Payment Using A Currency Different from the Vendor's and Company's Base Currency

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: US 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.

The following open enhancement exists 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)
1. Create a Clearing Account (type Bank) in the Vendors' base currency (eg. USD)
2. Navigate to Transactions > Purchases/Vendor > Enter Bills > List
---a. Click View next to the related Bill
---b. Click Make Payment
---c. Select the Clearing Account created in point 1
---d. Click Save
2. Navigate to Transactions > Bank > Transfer Funds 
---a. Set From Account = Canadian Bank Account
---b. Set To Account = The Clearing Account used in Point 2
---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

Note:
*In OneWorld, the bank accounts should belong to the same subsidiary.
*Also on OneWorld, bank accounts whose currency is the same as the subsidiary will be available to pay bills denominated in any currency. If a bank account has a different currency from the currency of the subsidiary, it will be available only for the bills with the same currency.

No comments:

Post a Comment