search

snipe / snipe-it

A free open source IT asset/license management system
https://snipeitapp.com
GNU Affero General Public License v3.0
11.06k stars 3.18k forks source link

Selectable currency per-asset #1444

Closed RobMSeagate closed 5 years ago

RobMSeagate commented 8 years ago

Feature request:

Can the currency type be a user-selectable field? We can set the default, but it seems to be a global setting. Can this be selectable? We are using this globally and buy in multiple currencies, so having the asset reflect the purchase price and currency would make the data very clear and concise.

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/28846199-selectable-currency-per-asset?utm_campaign=plugin&utm_content=tracker%2F505106&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F505106&utm_medium=issues&utm_source=github).
ddreier commented 8 years ago

This isn't 100% of what you're asking for, but you can set the currency for each location. Then each asset "in" that location will use that currency.

It's also important to note that we're just talking about the symbol. Snipe-IT doesn't do any exchange rate calculations.

vabue commented 8 years ago

In my situation some of assets I buy in USD, some in UAH. Exchange rate is floating. So I just use $ for purchase price.

RobMSeagate commented 8 years ago

In my case we buy in the UK, USA, Malaysia and Singapore and have finance teams who want the price paid tracked against each asset, which is 'owned' locally in that region so exchange rate fluctuations aren't a big concern.

@ddreier Thanks for the location tip! That does take me a big step forward and is something I can do immediately. Thank you.

lokesh-sg commented 8 years ago

Even I am still awaiting for this feature. Would be great if we get this feature ASAP.

Thanks.

knspradeep commented 7 years ago

is this feauture is added in snipe-IT v3.6.3

snazy2000 commented 6 years ago

Any update on this FR? :)

lea-mink commented 6 years ago

Still no update on this FR ?

snipe commented 6 years ago

@lea-mink Don't do that. Seriously. If there was an update, you'd have seen it here. We are constantly pushing new features, and the request list is long. Don't be an ass because we haven't gotten to this one yet.

lea-mink commented 6 years ago

I'm so sorry, I'm not english fluent and begginer on GitHub, the message did not go well... I just wanted to know if you are working on. Your work is amazing.

sofute commented 6 years ago

Having our company in Switzerland, this feature would be handy. We purchase at least in three currency all the time.

corne99 commented 6 years ago

Hi. I also need the currency for each individual asset. I buy in one country but in different currencies. Thanx

stale[bot] commented 6 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

lokesh-sg commented 6 years ago

Yes we need that.

From: stale[bot] notifications@github.com Sent: 21 August 2018 12:31 To: snipe/snipe-it snipe-it@noreply.github.com Cc: lokesh-sg lokeshg@arubanetworks.com; Comment comment@noreply.github.com Subject: Re: [snipe/snipe-it] Selectable currency per-asset (#1444)

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/snipe/snipe-it/issues/1444#issuecomment-414628671, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMaxncroqiUU-NHaTs30AAGxWWOdHiV4ks5uS-FZgaJpZM4GuuqI.

stale[bot] commented 6 years ago

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

sofute commented 6 years ago

I may add that currency conversion would be nice to have. But not as important as just be able to select currency per asset.

snipe commented 6 years ago

A currency converter seems a bit out of scope, and if we allowed currency per asset, I'm not sure how we would make totals on the list all page make any sense.

sofute commented 6 years ago

Forget about the conversion it's easy to do afterwards. For the total I guess you could group asset per currency. Up to the user to make the grand total.

stale[bot] commented 6 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

lokesh-sg commented 6 years ago

Yes

Lokesh G ~Sent from my handheld. Excuse me for typos

From: stale[bot] notifications@github.com Sent: Sunday, October 21, 2018 12:33:56 PM To: snipe/snipe-it Cc: lokesh-sg; Comment Subject: Re: [snipe/snipe-it] Selectable currency per-asset (#1444)

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/snipe/snipe-it/issues/1444#issuecomment-431644418, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMaxnVS0z8OQe4xA9x24LC9VoURBC2y7ks5unBxcgaJpZM4GuuqI.

stale[bot] commented 6 years ago

Okay, it looks like this issue or feature request might still be important. We'll re-open it for now. Thank you for letting us know!

snazy2000 commented 6 years ago

Yes

Sent from Yahoo Mail for iPhone

On Sunday, October 21, 2018, 8:03 am, stale[bot] notifications@github.com wrote:

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

stale[bot] commented 5 years ago

Is this still relevant? We haven't heard from anyone in a bit. If so, please comment with any updates or additional detail. This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Don't take it personally, we just need to keep a handle on things. Thank you for your contributions!

stale[bot] commented 5 years ago

This issue has been automatically closed because it has not had recent activity. If you believe this is still an issue, please confirm that this issue is still happening in the most recent version of Snipe-IT and reply to this thread to re-open it.

darius-ramanauskas commented 5 years ago

Please implement this!

dirceubb commented 3 years ago

This Feature is relevant for us. Please add currency per asset.

dirceubb commented 3 years ago

The same is needed for licenses, consumables, accesories and components Please

astec-mw commented 3 years ago

This is quite relevant for us. We purchase assets in multiple currencies. Please reopen this. Thanks!

innowintay commented 3 years ago

@snipe This is still a valid/relevant issue. Can this be reopened?

snipe commented 3 years ago

This is unlikely to be a feature we'd work on or accept if I'm honest here. How would we handle the table totals if we've got multiple currencies listed? It lends itself to be enormously confusing

dirceubb commented 3 years ago

This is unlikely to be a feature we'd work on or accept if I'm honest here. How would we handle the table totals if we've got multiple currencies listed? It lends itself to be enormously confusing

It doesn't have to be complex, just let us select the currency (USD, MXN, EURO) for each asset, license, etc. I don't think it's necessary to add complexity like automatically converting the currencies.

snipe commented 3 years ago

Okay, but we provide totals at the bottom of most table listings. Which currency do we use there? If I have 3 assets, each bought in a different currency, how will that total make any sense?

P-Vamshi-Seshasayan commented 2 years ago

Probably separate totals for each currency would be fine. +1 for the Feature request.

pepsijosh commented 2 years ago

Same for us as well, I think just to be able to edit the currency field instead of it being greyed out would be fine or a drop down with the currencies we want to use/have displayed. As others have said I don't think a conversion is necessary, we just need to have the asset show the currency it was purchased in.

sniper9191 commented 2 years ago

Okay, but we provide totals at the bottom of most table listings. Which currency do we use there? If I have 3 assets, each bought in a different currency, how will that total make any sense?

I think it is really important to be able to specify currency at the 'asset' level. Doing it at a 'location' level is overly simplistic and is not reflective of real world practices and scenarios.

However, I also understand the problem that this creates, should we need to display the total value of multi-currency assets. I think this can be easily addressed via a 'fixed exchange rate' against the 'default currency' that has been set.

This is how I think it can work -

For instance, my default currency is USD. And I add another currency, 'Galactic Credits', that has exchange rate of 2:1 against USD I have Asset1 that costs USD 500 I have Asset2 that costs Galactic Credits 1000 When tabulating the total value of assets 1 and 2, it would be (500 + 1000/2) = USD 1000

The formula is straight forward and uses the exchange rate property that is set for each currency. By setting the exchange rate against the default currency, it makes conversion much simpler as well. In fact, the exchange rate for each currency can be changed by the admin at any time, such that the tabulated total value will be changed accordingly.

The method only supports 1 exchange rate per currency, which itself is not reflective of real world scenarios, but I believe is a significant improvement nonetheless.

If I were to be pedantic, I could create multiple instances of the same currency with various exchange rates, i.e. -

And I will use the suitable option when selecting the currency for the asset - e.g. an asset purchased using galactic credits in 2022H1 vs 2022H2. Usually accounting departments are concerned with exchange rate at time of purchase, and this is able to capture that.

NakedHammer commented 1 year ago

It would be great for the currency to be selectable, but even having the value set to the currency of the selected company would avoid a lot of confusion. Please ad this feature.

grigchr commented 1 year ago

We would also like to have the option to select currency per asset. If there's three totals at the bottom of the list, for 3 different currencies it's OK by me.

If someone wants to have only one total, they can do the conversion themselves to their selected currency as it is done now. So the new feature would only add complexity if the user desires it. Existing workflows with only one currency per location would still work

AdaptiivTaylor commented 3 months ago

Okay, but we provide totals at the bottom of most table listings. Which currency do we use there? If I have 3 assets, each bought in a different currency, how will that total make any sense?

I think it is really important to be able to specify currency at the 'asset' level. Doing it at a 'location' level is overly simplistic and is not reflective of real world practices and scenarios.

However, I also understand the problem that this creates, should we need to display the total value of multi-currency assets. I think this can be easily addressed via a 'fixed exchange rate' against the 'default currency' that has been set.

This is how I think it can work -

* Each SnipeIT instance has its own default currency

* Any other currency that is added into SnipeIT, has a **fixed/static** exchange rate set against the default curency

* Individual assets have their cost shown in the currency of that asset

* Aggregated assets have their total cost shown in the default currency (assuming these assets have a mix of different currencies), by using the 'exchange rate against default currency' conversion

For instance, my default currency is USD. And I add another currency, 'Galactic Credits', that has exchange rate of 2:1 against USD I have Asset1 that costs USD 500 I have Asset2 that costs Galactic Credits 1000 When tabulating the total value of assets 1 and 2, it would be (500 + 1000/2) = USD 1000

The formula is straight forward and uses the exchange rate property that is set for each currency. By setting the exchange rate against the default currency, it makes conversion much simpler as well. In fact, the exchange rate for each currency can be changed by the admin at any time, such that the tabulated total value will be changed accordingly.

The method only supports 1 exchange rate per currency, which itself is not reflective of real world scenarios, but I believe is a significant improvement nonetheless.

If I were to be pedantic, I could create multiple instances of the same currency with various exchange rates, i.e. -

* Galactic Credits (2022-H1); 2:1 against default currency

* Galactic Credits (2022-H2); 2.25:1 against default currency

And I will use the suitable option when selecting the currency for the asset - e.g. an asset purchased using galactic credits in 2022H1 vs 2022H2. Usually accounting departments are concerned with exchange rate at time of purchase, and this is able to capture that.

This is a great idea and great way to handle multiple currencies in a totals format. For example, I need to track licenses in both CAD and USD. We are located in canada though, so to even have a rough estimate of $xxx USD + $xxx CAD = $xxxx CAD would be extremely useful.