setup

Multiple Currencies in your Free Purchase Order Software

We’ve had a few requests for a blog post that explains how Currency Conversion (multiple currencies) works in the Free Version of SpendMap, that is, what happens in SpendMap when you place Purchase Orders in currencies other than your own (landed) currency.

In a nutshell, when you set up a new supplier, you can tell SpendMap the currency to use (i.e. the currency the supplier’s Purchase Orders and invoices will be in), and then SpendMap will convert those orders to your local/landed currency for internal reporting purposes.

Here’s how it works…

Step 1 – Your Default/Local/Landed Currency

First things first, you need to set up your local/landed currency.  That’s the currency SpendMap will use for internal reporting.  We’ll use United States Dollars (USD) for this example.

Step 2 – Your Supplier’s Currency

Next, tell SpendMap which currency to use for each supplier.  Let’s say that a Buyer in the USA is ordering something from a supplier in Canada to make the most of the strong US dollar…

Step 3 – Purchase Orders in Your Supplier’s Currency

Now, when you process Purchase Orders for that supplier, the orders will be in the supplier’s currency (Canadian dollars in this example)…

Step 4 – Currency Conversion (Reporting in Landed Currency)

In most cases, orders that are placed in your Supplier’s currency will be converted to your local/landed currency for reporting purposes, so that you can “compare apples to apples”.  For example, your budget reporting, inventory valuation, spend by supplier, and similar reports that might include purchases in many different currencies, will be converted to your local/landed currency for easy comparison.

For example, here’s the Spend by Supplier Report, showing that we just spent US $730.20 (not $1,000) with our friendly Canadian supplier…

I say “in most cases” because there are a few exceptions where you still might want to see your supplier’s currency, in which case SpendMap will ask you whether you want to use your supplier’s currencies or your landed currency.  The PO Listing Report is a good example.

Step 5 – Update Exchange Rates

Since exchange rates between currencies fluctuate all the time, you should update the Rate Field (the exchange rate) for each currency code in SpendMap from time to time.  You can do this manually in the Tax and Exchange Rate Master File, or check out this blog post to learn how to automatically update the exchange rates from Yahoo! Finance.

Codes or Descriptions in your Free Purchase Order Software?

Throughout SpendMap, when creating Purchase Orders and working in other areas of the system, you will select master file “codes”, such as GL account codes, item codes (part numbers), supplier codes, etc.

For example, your GL account code for “office supplies” might be “0-663-1”, or something like that, which might not be very meaningful to your SpendMap users.

If you use meaningful codes that make sense to your users, don’t bother reading the rest of this post and just get back to saving your company money or whatever you were doing.

But if your master file codes don’t have meaning to your users, here are some tips to make SpendMap more intuitive for them…

Display Description Instead of Code

Did you know that you can set up SpendMap to display the description rather than the code on screens throughout the system?  Here where you can do that…
– PURCHASING > Setup system > Master file settings > Master file code/description display options

Alternate Between Code and Description

Regardless of whether or not you’re displaying the code or description per above, you can alternate between the code and description at any time using the <F2> key on your keyboard, or you can hover your mouse over a field, like this…

Sorting Look-Up Lists

Drop-down lists can also be sorted either by code or description, using…
– PURCHASING > Setup system > Master file settings > Additional sort options for master file lookups

Budget threshold warning in your Free Purchase Order Software

We added a new feature in v14 of SpendMap that can help you stick to your budget by proactively warning you when you’re running out of money.

In Cost Center History/Budget Settings, you can establish the “budget threshold”.  For example, you might want to be warned once you’re down to, say, 20% of the budget remaining (i.e. 80% budget consumed).

While entering new POs, the hyperlink that shows the total value of the order at the top of the Purchase Order Header Screen will change from green to yellow when the budget threshold has been reached.  Then the hyperlink will eventually change to red when there’s nothing left in the budget.

Budget warning on Purchase Order screen

TIP: Click through that hyperlink to see the full budget details.

On a related note, you can also prohibit/stop the processing of Purchase Orders and other documents that will exceed the budget, using the related options in Cost Center History/Budget Settings…

Budget settings in free Purchase Order Software

How to display ONLY those items from the supplier on your Purchase Order

There is a new feature in version 14 of SpendMap that you can use to limit the items that your staff can select while entering Purchase Orders, such that they will only be able to select the standard items that you have set up for that supplier in advance.  That is, you can prohibit the use of non-standard items/suppliers.

Just use the new setting in PO Entry Settings, which you can find here…
– PURCHASING > Setup system> Purchase Order settings > PO entry settings

Listing only-items-for-supplier in PO Software

Alternatively, without this formal restriction, users can also search for items by supplier while entering new POs.

Finally, if you forgo the restriction and allow your staff to select non-standard items/suppliers but still want to know when it’s happening, you can use the setting “Log if non-standard supplier is chosen”, in System Alert Log Settings…
– PURCHASING > Setup system > System alert log settings

Is your free Purchase Order Software a bit too loud?

After all that New Year’s fun, you might want to turn the volume down a bit in your free Purchase Order software.

To disable the warning/notification sounds in SpendMap, just use the Workstation Setting for “Audible Prompts (beeping)“, in here…
– PURCHASING > Setup system > Workstation configuration settings

In v12.65 it is setting #4 but in v14 (coming soon) we moved it to #12.

No-Sound

 

Can’t see your free Purchase Order Software?

The free version of SpendMap can show you where the money is going.  But only if you can read the screens!

If you would like to make the screens a bit bigger in your free Purchase Order Software System, try using setting #10 (Font/Screen Scaling Factor) in here…
– PURCHASING > Setup system > Workstation configuration settings

Visibility and free Purchase Order Software

Upgraded e-mail features in your free Purchase Order Software

We made two fairly significant improvements to the e-mail features in the Free Version of SpendMap (including v12.65)…mail-GREEN

1) Encrypted E-Mail

SpendMap now supports encrypted (SSL/TLS) connections to the mail server.  Better security aside, we have been finding that more and more e-mail providers (like Google’s Gmail) no longer support unencrypted connections.  If you previously had trouble getting SpendMap to work with your e-mail system, please try again after upgrading.

Note the new “Secure Connection” setting under the Server Name or IP Address field, in…
– PURCHASING > Setup system > e-mail settings

Please note that to send e-mail, SpendMap now requires the Microsoft .NET Framework v4.0 or above to be installed on the PC (available since 2010).

We normally don’t make changes to published versions of SpendMap but we made an exception in this case due to recent changes at Google and the increasing number of requests for this feature.

2) Free, Built-In E-mail Service

The free version of SpendMap now includes a free, built-in e-mail service, which you can use instead of configuring the system to use your own e-mail server or ISP.

Just enter “SpendMap” in the Server Name or IP Address field in E-mail Settings to use this free service (don’t worry about the other SMTP settings as they will be ignored when using the built-in e-mail service).  The Online Help for the Server Name or IP Address field has additional details.

For new downloads of the free version of SpendMap, the Evaluation Copy is preconfigured to use this new e-mail service.  If you already have SpendMap installed, your settings will not change automatically but you can manually change the Server Name or IP Address field per above if you want to use this free service.

How to include your account number for the supplier on the PO form in your free PO software system

Chaim works in the security solutions industry in New Jersey and was asking how to include an account number for the supplier on the PO form…

When I place an order, our suppliers would like to know our account number. In the Supplier information there are fields to enter Phone, Fax, but not our Account Number.  The Account Number should appear on the PO.

Great question, Chaim!

Most people use the Comment 1 field for that. You can enter the supplier’s account number in the [Miscellaneous] folder of the Supplier Master File, and it will carry forward to the PO Header for each new PO for that supplier and will be available to print on the PO form…

supplier account number on Purchase Order

If you like, you can rename the field from “Comment 1” to “Account Number”, which will update the field title in the Supplier Master File, as well as on the PO Header screen and the PO form itself.  Just go in here…
– PURCHASING > Setup system> Purchase order settings > PO printing settings > Text-Based Field Positions and Field Settings > Standard

…and change the Title of field #21, then exit and re-run SpendMap.

History of sent e-mail messages in your Free Purchase Order Software

Jose works in the irrigation services industry in Dubai, United Arab Emirates, and was asking how to see a history of e-mail messages that were sent from SpendMap…

I couldn’t confirm whether the PO, RFQ was sent to the recipient….How do I know the PO and RFQ are being sent successfully?

There are two options for sending e-mail from SpendMap, 1) MAPI and 2) SMTP.

If you would like e-mails that are sent from SpendMap to show in your Outlook Sent Box, then use the MAPI option (using the two fields at the top of the E-mail Setting Screen).  TIP: In most cases, you do NOT need to enter any of the other MAPI-related settings further down the screen.

If, however, you prefer the SMTP option, you can enable the Sent E-mail Log, using the setting called “Maintain a log of sent e-mail messages” (also in E-mail Settings), and you will see a history of the outgoing e-mail messages in…
– PURCHASING > Utility > e-mail and internal messaging > e-mail log > Log of sent e-mail messages

Email Logs in free PO Software

TIP: It would be unusual for SpendMap users to verify that each and every e-mail was sent successfully (e.g. by checking Outlook or using the Sent E-mail Log), since you will be notified if an e-mail could NOT be sent.  If SpendMap cannot connect to Outlook or your SMTP server to send a message, you will see a “failed e-mail” icon in the Main Menu of SpendMap, and the failed message will show in the E-mail Error Log, in here…
– PURCHASING > Utility > e-mail and internal messaging > e-mail log > Local/Server e-mail error log

Or, if SpendMap is able to pass the message to the outgoing mail server but the message fails for some other reason (e.g. bad e-mail address), the mail server will send an “undeliverable mail” message back to the sender.

Terms and Conditions on PO Form (Ts and Cs)

Jody works in the hospitality industry in California and was asking how to include terms and conditions (Ts and Cs) on her PO form in the free version of SpendMap.

There are actually two options when it comes to terms and conditions on your Purchase Order form…

Short Terms Text

If you just need a few lines of text, try using the Short Terms Text in PO Printing Settings, which will be included on the face of the PO form, at the bottom, next to your signature line.  Here is where you can find the setting, and what it looks like…
– PURCHASING > Setup system> Purchase order settings > PO printing settings > Settings

Short terms and conditions on PO form

Long Terms Page

If you need more than just a few lines of text, the other option would be to use the full Terms and Conditions Page that will automatically accompany each PO that is printed or e-mailed to your suppliers .  You can configure the Terms Page using the [Setup Your Terms Page] button on that same PO Printing Settings screen.

When you click the [Setup Your Terms Page] button, you will be brought to a screen where you can either 1) enter lots and lots of text for your Terms Page, or 2) if you already have an existing Terms Page, you can scan it and upload it into SpendMap as an image file.

Finally, don’t forget to enable the Terms Page for one or more copies of the PO (likely only the Supplier’s copy) using the applicable check-box on the main PO Printing Settings screen…

PO Printing Settings