Software Tips & Tricks

Who can add to Master Files on-the-fly in your Free Purchase Order Software?

Did you know that, by default, all users in your Free Purchase Order Software will be able to add suppliers, items, account codes and other Master File information “on-the-fly” as they work on Purchase Orders and other transactions in the system?

That’s right, while creating a new Purchase Order, if you type in a new supplier code, part number, account code, etc. that doesn’t already exist in the respective Master File, SpendMap will prompt you to add the information to the Master File right there-and-then, so you don’t have to stop what you’re working on in your PO Work Area.

Of course, you may not want everyone doing that, so you can turn this feature on or off, using the setting called “Allow adding of codes on-the-fly?”, which you can find in the [Permissions] folder/tab of the User Master File.

on-the-fly

Purge Database While Importing data into your Free Purchase Order Software

Seth works at a seniors’ community in California and wanted to know if he could start over and delete/purge all records in a Master File before importing new information/data…

“I wanted to know if it is possible to delete the entire cost center database (I am attempting to re-upload the database). It has plenty of old data that will take a long time to delete one by one.”

Sure thing Seth, just go to the [Permissions] folder of the User Master File and select the 4th check-box called “Allow purging of master files when importing?”.

Then, the next time you import, SpendMap will ask you if you want to purge/delete all existing records before importing, for a complete refresh…

Purge Table Before Importing Data into PO Software

Request for Quotation (RFQ) Module in Pro Version of SpendMap

Are you looking for an easier way to manage price quotes from your suppliers?  Tired of all the phone calls, emails and spreadsheets?

The Request for Quotation Module in the Pro Version of SpendMap makes it easy to get up-to-date pricing and encourages competition between your suppliers so that you get the best possible deal.

Check out our new video tutorial, below.  Or better yet, take a free test drive of our Pro Version and see for yourself.

Part Numbers on the PO Form in your Free Purchase Order Software

Paul works in the coach (bus) industry in Canada and was asking how to include his item codes (part numbers) on his PO form in the Free Version of SpendMap because there is no column for “Item Code” on the default PO form layout that ships with the system.

As it turns out, there are five (5) PO form layouts that you can choose from in the Free Version of SpendMap; layouts 4 and 5 include a column for your internal item code.  You can switch form layouts using the [Change PO Layout Option] button in here…
– PURCHASING > Setup system> Purchase order settings > PO printing settings > Settings .

Internal Item Codes vs. Supplier Item Codes

Please note, however, that we left the Item Code off most of the form layouts on purpose because typically your suppliers won’t be interested in your internal part numbers.

Their part numbers (i.e. the “Supplier’s Item Code”) will already appear in round brackets in the description of the line items on the PO form for the supplier’s reference.  Note that this only appears when you actually process your new POs (but not when you preview your draft POs in your PO Work Area).

You can enter suppliers’ item codes for an unlimited number of suppliers, in the [Supplier] folder of the Item Master File.

And here’s another blog post that explains the difference between your internal part numbers and your supplier’s part numbers.

item and supplier part numbers

Approving Supplier Invoices the Easy Way

Are you looking for an easier way to approve your suppliers’ invoices for payment?  Tired of all the paperwork, phone calls and emails?

SpendMap’s Invoice Approval and A/P Interface Module really simplifies the process.

Check out our new video tutorial, below.  Or better yet, take a free test drive of our Pro Version and see for yourself.

Manual PO Numbers in your Free Purchase Order Software

By default, the Free Version of SpendMap will automatically assign incrementing PO numbers to each new Purchase Order that you enter in the system.  You can set up your “Next PO number” during the Setup Wizard that runs automatically when you log into your Live System for the first time.

But if you prefer to enter your PO numbers manually for each new order, just select the following menu in SpendMap…
– PURCHASING > Setup system > Incrementing document number sets > POs

Then modify PO Number Set A as follows.  From that point on, whenever you enter a new PO in your PO Work Area, the PO Number will be blank and you can enter it manually for each order.

Time-Based and Overall Budgets in your Free Purchase Order Software

Hanna is the Purchasing Manager at a construction company in California and asked about setting up budgets for her departments and jobs…

“When a department buys something, like a computer or office supplies for example, it goes against their monthly budget but when we buy something for one of our jobs, the budget can span several months in some cases.”

No problem Hanna, you can track both “time-based” and “overall” budgets in SpendMap.

For your time-based budgets, you would typically allocate funds by month, quarter or year but when you allocate an overall budget to a project or a job, that budget will be available for the life of the project, regardless of how long that takes.

Theoretically an individual Cost Center (department, project, job, etc.) could have both time-based budgets and an overall budgets but that’s pretty unusual.  Typically it’s one or the other.

You can enter both time-based and overall budgets in the Cost Center Master File…

Budgets in Purchase Order Software

Adding Fields to Excel Reports in your Free Purchase Order Software

Colton works in the agriculture industry and called to ask if he could add additional fields/columns to the PO Listing Report spreadsheet.

By default, that particular report/spreadsheet includes only the supplier code/ID for each Purchase Order but not the supplier name or other contact information.

So, we showed him how he can add any field from the Supplier Master File and within seconds, he had modified his spreadsheet to show the missing information.

Want to see how he did it?  Check out this video tutorial for all the details…

Pop-Up Calculator in your Free Purchase Order Software

Hey Spend-Mappers,

Did you know that the Free Version of SpendMap includes a convenient pop-up calculator?

Just right-mouse click on any numeric field in SpendMap and select “Calculator” from the menu…

pop-up-calculator