Home Button  Buy Button 

Topic:   Multiple currency

By: JohnPosted on: Nov 27 2017 at 07:01:26 PM
1. How do I put the currency on each item?
2. The invoice doesn't have a currency code.

By: SupportPosted on: Nov 28 2017 at 03:52:57 PM

In the current 'Enterprise' version the currency is only available for Purchasing (items from vendors). That is so that MiniMRP can calculate the build-cost of an assembly even if the components used to build that assembly come from different suppliers in different currencies.

MiniMRP doesn't do anything with currencies on Sales Orders/Invoices. A currency on sales would not affect any Build-Costs or Inventory Valuation report. MniMRP is primarily a manufacturing tool - not a sales/accounting tool.

When you create an invoice you can enter something into the comments box of the invoice telling your customer what currency the invoice is in.

However, Version 5 (due in a few months) will show a currency code on invoices as well in that customers can be setup with a default currency code that will be used on all sales to that customer. But, as mentioned above, it's not going to affect anything like work orders or stock valuation reports. It's just a label that appears on an invoice.

By: JohnPosted on: Nov 28 2017 at 04:06:49 PM
Thanks that's what I need.

By: StefanPosted on: Jun 6 2018 at 02:27:24 AM
Yes, thats a feature everyone needs I think as by legal terms, an invoice must show the currency.
When is Ver 5 going to be released?

By: SupportPosted on: Jun 12 2018 at 03:25:44 AM
v5. On the customer invoice the currency will appear on the customer order and invoice.

It will just be text like "Currency [USD]" at the bottom next to the order/invoice total.

When I say "Just Text" I mean that it won't actually do any math such as convert from one currency to another, deal with exchange rates etc.

Currently in v4 you can define a default currency for each of your suppliers. That will also be possible with Customers in v5. So each customer can have a default currency and whenever you create a new customer order it will show that customer's currency on the order and the invoice.

Also note in the picture above that the layout is more like the actual printed document.
The picture also shows that you can drag any 'tabbed' window out of the main window and position anywhere on your display. So in the above example the customer order is now in its own window. This allows you to actually see and work on multiple task windows side by side at the same time rather than having them all tabbed one on top of the other.

By: SupportPosted on: Jun 12 2018 at 04:00:48 AM
I forgot to answer the question about "When".

Sorry. This might be a long story. Just skip to the bottom if you're not interested in "Why".

It was not our intention to make a lot of 'visible' changes to the program. The reason for the version change from 4.2 to 5.0 (instead of just an update to 4.3) was because we wanted to make major breaking changes to the database, drivers, format, 64bit compatibility etc. Most users would never see these changes - MiniMRP would just 'work'. Basically such changes ensure that MiniMRP continues to work and be compatible with newer versions of Windows longer term.

MiniMRP already works with Microsoft databases, JET and MSSQL, but We really wanted to use the 'MySQL' database as MiniMRP's standard/default database. We created a small footprint, zero configuration, MySQL Server built right into the MiniMRP v5 deployment. It was our intention that even single user installs would use that small, fast, reliable database and then be able to share that data with other users, even remotely, if required.

But after much discussion with 0racIe, the owners of MySQL, we just can't do that. 0racIe want us to sell a full licence of MySQL server with each install of MiniMRP and even with the discounts they offered it would still quadruple the price of MiniMRP.

It took us months to get it all working and now we have to rewind, remove all the embedded MySQL code and deploy with MySQL as an option rather than the default.

So. When? I really don't like giving dates because they just seem to drift. So I'm not writing this in stone. We're now aiming for August 2018.

By: GuestPosted on: Jun 26 2018 at 02:26:52 PM
What about using the open source forked version of MySQL known as MariaDB

By: SupportPosted on: Jun 27 2018 at 04:18:05 AM
What about using the open source forked version of MySQL known as MariaDB

Unfortunately it's not that simple. MySQL is GPL licenced. MariaDB is LGPL licenced.

Any application that is "based on", "linked with" or "depends on" GPL/LGPL code must also be released with a GPL/LGPL licence. You can build your own applications for your own use or your company's use. But if you release/deploy/sell them to others then they must be released/deployed/sold under the same GPL/LGPL licence.

Our first v5 'release candidate' did contain MySQL's .Net Connector and 'Depend On' MariaDB. So MiniMRP could not function without 3rd party GPL/LGPL'd code.

That would mean we'd need to release MiniMRP with a GPL or LGPL licence (meaning we'd need to release the source code)

So, as mentioned in my previous post. MiniMRP will function perfectly well without MySQL/MariaDB but the option will be there if the user wishes to use it.

By: GuestPosted on: Jun 28 2018 at 01:02:21 PM
OK I get it now

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Multiple currency

Enter the numbers.

Your name here is optional