Setting up Bank Account for a specific customer - (including on Sales invoice)

(0) Share

Report

Posted on by J5D

Hi All,

Being a newbie to Navision 2016, I wanted to find out if I set up a new bank account for example we already have a GBP bank account which we pretty much use for all our customers but I want to set up a USD bank account and assign this account specifically to one customer itself. (showing the USD bank account details on the invoice also)

Is this possible and if so what sets do I need to take in order to do this?

Your help would be appreciated.

Thanks

J5D

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

Go to Customer Card and there is an action to create Bank Account for that customer and then setup that Bank Account on the Customer Card in the Payment Tab "Preferred Bank Account Code"

Was this reply helpful? Yes No
Suggested answer

The Simpsoid 625 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

That field is for the customer's bank account(s) and is used (as stated in help) for "the customer bank account that will be used by default when you process refunds to the customer". To use that would mean entering J5D's company bank details against each customer - or at least those not using the same currency as his local currency. And even then if J5D processed a refund he'd end up paying the money back into his own company's account.

J5D, the way we have managed your issue in my company is to name our bank accounts with the same code as the currency e.g. we have USD and EUR accounts to match the currency codes for our international customers then I've added some code into the Invoice, Statement and Order Confirmation reports to pick up the details for those affected customers and our main bank for those trading in the same currency as we do (GBP). A better way would actually be to add a new field on the Customer card with a lookup to your company bank accounts and then refer to that in the report layouts because if someone was silly enough to either rename a currency or one of our bank accounts then my method would break down. I can be pretty confident that's not going to happen in practice however.

Was this reply helpful? Yes No
J5D 70 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

Hi Suresh,

I believe this is only for the customers bank account which not what I want. In fact I wanted to specify our USD payment details on the sales invoice instead of GBP bank account details, but have not had any luck doing so for this specific customer even though I've changed the 'Payment receipt bank account no.' to the USD bank account I've created.

Any help here would be amazing!

Was this reply helpful? Yes No
Verified answer

RobertasR 5,004 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

Hi J5D,

this is a requirement I hear very often from my customers, however standard NAV only allows you to set up 1 bank account details for printing on invoices - this is set on the Company Information. For this specific requirement you need development to either:

- amend existing invoice to pick different bank accounts for different currency

- create new invoice report (could be a copy of existing one) and amend bank details to USD on the report. Then assign this report as Invoice report in the Customer Document Layouts.

Hope this helps,

Robertas

Was this reply helpful? Yes No
J5D 70 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

Hi Robertas,

Now that is a shame, I didn't think a newish system would have such a issue as this is quite normal for most companies nowadays. But saying that, I am baffled as I did add a new account to a different company we have in our test system and it seemed to have worked there but not in the actual system I want it to.

I'll prop the question to our IT department to see what they can figure out, cheers Robertas.

Was this reply helpful? Yes No
Verified answer

RobertasR 5,004 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

It might be possible you already have the development from your NAV partner, but it needs 'switching on'. Worth talking to IT, see what they say

Robertas

Was this reply helpful? Yes No
J5D 70 on at

Like (0)

Report

RE: Setting up Bank Account for a specific customer - (including on Sales invoice)

Thanks Robertas

Was this reply helpful? Yes No