Sometimes a vendor is paid from GBP account and so...
# administration
p
Sometimes a vendor is paid from GBP account and sometimes it is paid with USD account. However, when making the prepayment, only the CAD account may be selected. How can we create a vendor prepayment from either bank account within that Entity for that vendor and be able to apply it to the vendor bill?
m
The advance paid account is set up with currency ?
p
No
j
Is the USD account classified as a bank account?
l
What is the currency of the bank account selected in the Vendor Prepayment?
p
@j theyre all bank accounts
@Luis thats actually not the restriction, I can select CAD currency first then choose any of the banks be it the USD bank or CAD bank. But if the vendor bill is USD, I cant apply this prepayment to it since prepayment is in CAD but bill is USD, even tho the bank may be the USD bank in prepay
This means that I cant use that prepayment until the time a CAD bill comes around
edited the currencies btw^ (since prepayments are mostly recorded in CAD)
m
Strange i made a test Bill in USD on German Sub ( Primary EUR) By bill payment I can pay with USD bank Account of the German Sub By vendor prepayment I select USD in currency and I can select USD bank account
p
You made the prepayment in same currency as the bill, that is exactly whats not the case. The prepayment is done much before a bill comes in. So thats made in CAD, but the bill later comes in USD or GBP and then we can't apply Try making a prepayment in EUR and applying to the bill you made
m
I redid the test without prepayment, when I want to pay an invoice in dollars for my German subsidiary, I can only pay in dollars and nothing else. I can’t select currency EUR to pays Bill in USD As with an vendor prepayment, it is normal not to be able to apply CAD to a USD invoice.
p
And thats precisely the question - how to handle these, since now the prepayments are stuck not being able to be applied Any workaround ideas welcome
m
I'm not sure if you can use an clearing account or something else that works for paying bills but not for VPs. create a JE to cancel the VP when you have the bill and recreate the VP with the correct currency
r
Do you have GBP set up as an available currency on the vendor record? That could be part of the issue. (e: nvm I see the other thread now, so that's not it.) That said, while I've never used Vendor Prepayments, I do know on Customer Payments and Vendor Payments you can only pay with a currency that matches the currency on the invoice/bill or the primary currency of the sub the doc is on. I'm guessing the same applies to VPs. Examples: • EUR sub, GBP Inv - can only pay the invoice using a GBP or EUR account • USD sub, INR Inv - can only pay the invoice using INR or USD account • CAD sub, EUR inv - can only pay the invoice using EUR or CAD account • and so on Unfortunately NS doesn't currently possess the "triangulation" or whatever you'd call it to deal with a third currency. Third currency being one that doesn't match the original doc or the sub default currency.