Discussion Forum: Thread 166105

 Author: Teup View Messages Posted By Teup
 Posted: Feb 22, 2014 10:08
 Subject: Need EUR-USD rate as a macro in invoice
 Viewed: 93 times
 Topic: Suggestions
 Status:Discarded
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6603)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
Hi guys,

I really need the dollar-euro exchange rate at the moment of order placement
as a macro in the invoice.

I use the invoice generator as a generator of a list of data that I use as input
for my administration software. I have all I need, except for the exchange rate
at the moment the order was placed. I am aware there is a macro
that generates the amount in Euro, but only when the buyer has selected Euro
as their preferred currency. I need that, and/or the exhcange rate, to be available
to me always. I bet I'm not the only one, right? Or did I miss a tag that's
already there?

Thanks!
 Author: paulvdb View Messages Posted By paulvdb
 Posted: Feb 22, 2014 11:07
 Subject: Re: Need EUR-USD rate as a macro in invoice
 Viewed: 28 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

paulvdb (7146)

Location:  Netherlands, Overijssel
Member Since Contact Type Status
Nov 14, 2007 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Paul's Dutch Brick Store
In Suggestions, Teup writes:
  Hi guys,

I really need the dollar-euro exchange rate at the moment of order placement
as a macro in the invoice.

I use the invoice generator as a generator of a list of data that I use as input
for my administration software. I have all I need, except for the exchange rate
at the moment the order was placed. I am aware there is a DISPGRANDTOTAL macro
that generates the amount in Euro, but only when the buyer has selected Euro
as their preferred currency. I need that, and/or the exhcange rate, to be available
to me always. I bet I'm not the only one, right? Or did I miss a tag that's
already there?

Thanks!

The tag BASEGRANDTOTAL gives the amount in your store's currency. The tag
DISPGRANDTOTAL gives the amount in the currency that the buyer selected at checkout.
 Author: maxx3001 View Messages Posted By maxx3001
 Posted: Feb 22, 2014 11:13
 Subject: Re: Need EUR-USD rate as a macro in invoice
 Viewed: 32 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

maxx3001 (2564)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
Nov 28, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 3001: A Brick Oddity
In Suggestions, Teup writes:
  Hi guys,

I really need the dollar-euro exchange rate at the moment of order placement
as a macro in the invoice.

I use the invoice generator as a generator of a list of data that I use as input
for my administration software. I have all I need, except for the exchange rate
at the moment the order was placed. I am aware there is a macro
that generates the amount in Euro, but only when the buyer has selected Euro
as their preferred currency. I need that, and/or the exhcange rate, to be available
to me always. I bet I'm not the only one, right? Or did I miss a tag that's
already there?

Thanks!

Just divide the euro ammount by the dollar ammount?

Maxx
 Author: Teup View Messages Posted By Teup
 Posted: Feb 22, 2014 18:20
 Subject: Re: Need EUR-USD rate as a macro in invoice
 Viewed: 37 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6603)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
Thanks for the suggestions. It feels a bit drastic to go and change my store's
currency - I kind of like my store the way it is. Retrieving the Euro total manually
and calculating the exchange rate from there would work, however as a daily routine
it's a bit tedious to get the invoice data, then go back, check the order
details, and manually copy the Euro total from there. It's not a big deal,
but if selling on Bricklink becomes a way of life it gets annoying after a while
and more error prone (well, if you're me, anyway). But you're right,
so far these are the best solutions.

As I see it, this is a really simple little something they could add without
much trouble. Just a DOLLARTOEURO tag or something like that. Or EUROTOTAL
so my administration software can calculate it from there. I think that'd
be handy for a bunch of other sellers too, and it doesn't change a thing
for people who don't find it useful
 Author: tomte View Messages Posted By tomte
 Posted: May 18, 2014 12:03
 Subject: Re: Need EUR-USD rate as a macro in invoice
 Viewed: 22 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

tomte (81980)

Location:  Germany, Bayern
Member Since Contact Type Status
Oct 20, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brick Takeover
Hi

actually right now I don't need this but it would be a good feature to have.