Display Currency on invoices

SUGGESTED

Hi,

We are sometimes selling in CAD and sometimes in USD.

It is not based on a customer but more on a product.

Everything works fine "account wise" and we have a sales account in CAD and a sales account in USD.

But... we want to display on the invoices in what currency the invoice is... can't find a way to do it.

Checked in the forms settings, no "data field" exist for "currency" to included on a form... and in options can't find any "display amounts currency".

We are stuck... only solution is to manually type a note on invoices so the customer know if they must pay in CAD or in USD...

Help!

Thanks!

  • 0

    If you do not have the multicurrency module active in the program, then you only option is to put the note on as you are doing.  You can use a Service item code to put on standard text if you like.

    If you did have the multicurrency active, then you would need a customer for CAD and a customer for USD (eg. ABC Company - CAD and ABC Company - USD) if you sell to the same customer in both currencies.  A customer or vendor can only be one currency.  When you print a customer invoice in USD with this active, the USD is automatically put on the invoice but there is no designation for CAD in the internal forms.

  • 0 in reply to Richard S. Ridings

    Yeah... since the US product could be sold to any of our customer database, we would need to duplicate all our customers.

    What about your other suggestion "You can use a Service item code to put on standard text if you like."

    Would that allow us to automatically include "all amounts are in USD" when needed?

    Can you explain?

    Thanks!

  • 0 in reply to Jaky

    When you currently put your items on an invoice, the item description shows up in the Description column.

    If you set up a Service item called USD with the Item Description of "Invoice billed in USD - United States Dollars" or whatever text you prefer, it will automatically be put on the invoice by typing USD in the item code field.  Play with the universl sample file to see how it works before you test it in your file.

  • 0 in reply to Richard S. Ridings

    I wonder if newer version of Sage50 have allowed for the specification of the currency even when invoice in the home country. Customs always require to have the currency specified and when we ship overseas we always need to add manually CAD 

  • 0 in reply to Stefano Urbani
    SUGGESTED

    Hi Stefano:

    If you need to manually put in CAD, may I suggest setting up an inventory services code and adding it to your invoice when needed. I just needs to be created once and you can access it when you are making up your billing. Just put it on a separate line after the billing details.

    Hope this helps!