FileMaker Developer Spotlight — John Osborne at PhilosophyOfFileMaker.com

FileMaker Developer Spotlight — John Osborne at PhilosophyOfFileMaker.com

The active user community is one of the noteworthy benefits of developing with FileMaker. Whether you're working on a system of Macs, PCs, or a blended platform of desktop and mobile devices, the community support is the same. Professionals and citizen developers are all enthusiastic about what they're able to create and how they can help you succeed.

Today's example of this camaraderie is John Mark Osborne's site, "Philosophy of FileMaker."

Since John is a hobbyist chef, it isn't too surprising that he also cooked this site up from scratch. Instead of registering for a plug-and-play blog, he created a site about FileMaker that runs on FileMaker.

John's interest in philosophy is a key ingredient here. He explains that his college philosophy classes fascinated him, showing how philosophers put laser focus on a subject, examining it from all sides, considering things so thoroughly that people might be tempted to call it ridiculous — but useful. John points out:

"I have used the philosophical methodology throughout my database development career to reveal advantages and disadvantages in order to choose the best solution for the problem at hand."

He has committed to a similar approach for his FileMaker blog, never leaving out details or withholding trade secrets. This candor is clear, for example, in a post from mid-April. This scripting primer introduces FileMaker Pro scripting and the Script Workspace. Then John gives you a quick breakdown of script steps his years of experience have shown to be the good, bad, or ugly.

If you're interested in other details of FileMaker development, John's blog provides search and navigation tools that make it easy for you to tap into his expertise. Kudos to John for his great work.

 

Your interest in FileMaker custom apps might be greater than the time you actually have to spend on it. An excellent solution is to invest in a robust business software package that is developed on FileMaker. This provides a foundation for you to build smaller custom tools and reports, honed to your exact needs. aACE 5 is a highly recommended solution that integrates accounting, CRM, and ERP for your small or mid-sized business.

Get Answers to Questions on Sales Tax – Free Webinar on May 4th

Get Answers to Questions on Sales Tax – Free Webinar on May 4th

For over a decade, Avalara has been helping businesses of all sizes effectively manage the burden of sales taxes. This month they are hosting a free webinar: "The Definitive User's Guide to Sales and Use Tax."

On Thursday, May 4th, at 2:00 PM ET (11:00 AM PT), you can invest 60 minutes to learn some excellent tips about taxation. Or you can get helpful reminders about details you already know. This is an excellent way to improve how you handle taxes for your business's unique situation.

Avalara has organized this presentation by Aaron Wilson, a CPA and experienced expert in indirect taxes. To help you ensure your company is compliant with sales tax requirements, Aaron will discuss:

  • How to quickly access correct rates across 12,000+ tax jurisdictions
  • How to determine tax responsibility when you work with a drop shipping company
  • How to recognize the distinctions between sales tax and use tax
  • How to identify which states you owe sales tax in

Space is limited for this presentation so register now.

 

To further increase your business velocity, integrate sales tax automation with a 360-degree accounting/CRM/ERP suite. aACE 5 is a powerful and affordable solution that deploys on both Mac and PC.

5 Key Points for Selecting an ERP Solution

5 Key Points for Selecting an ERP Solution

We've got an opinion about where to find high-quality ERP solutions, but it's important for everyone involved in the decision to agree. This article from Manufacturing Business Technology gives excellent advice about how to reach the best decision for your company.

The author, Dave Lechleitner, highlights 5 key steps:

  1. Assess functionality needs: Go beyond pain-points with the current system and envision a plan for future growth.
  2. Open dialogue with vendors: Look for a strong partner instead of a sleek sales team.
  3. Understand the end game: Balance in savings from becoming a more responsive and competitive company.
  4. Explore support for the software: Know your IT team's abilities and the vendor's commitment to customer service.
  5. Research the vendor: Due diligence will help you find an ERP solution that supports your business strategy and scales with your growth.

 

As part of your research strategy, it can be valuable to find out what past clients say about the vendor and the software solution. Capterra gathers this information into a single site, making it easy for you to find high quality software. View the aACE Software profile to discover the proven benefits we can provide for your company's accounting, CRM, and ERP needs.

How Much Money Is Tied Up in ‘Average’ Warehousing Practices?

How Much Money Is Tied Up in ‘Average’ Warehousing Practices?

When it comes to American inventory management, there's a startling amount of lost opportunity. And all too often, those missed chances equate to lost profits. Hopefully your own inventory management team is on the ball, running the warehouse at a level above average. But better than just hope, you can find specific areas for improvement and work with your team to enhance your company.

Capterra Blogs writer Andrew Marder has gathered information on ten of the most troubling aspects of modern inventory management. These statistics paint a picture of U.S. businesses not appreciating how much benefit could accrue from high quality warehouse tools and processes.

1. The equivalent of 7% of the national GDP is tied up in business inventories, accounts receivable, and accounts payable - approximately $1.1 trillion in cash.

2. Inventory as a percentage of sales is on the rise from its 2011 low. U.S. retailers are carrying an average $1.43 in inventory for every $1 in sales.

3. Nearly half of American companies don't have a robust inventory management system in place. 46% of SMBs use a manual method or simply don’t track inventory.

4. Companies are holding on to more stuff, in spite of increasingly efficient shipping and manufacturing networks. A measurement of the amount of inventory on hand, based on average sales per day – called Days Inventory Outstanding – rose more than 8% from 2009 to 2014.

5. Enabling some of these inefficiencies, we see that warehouse space is much cheaper than other building types: an average cost per square foot of $5.08.

6. In a 2013 survey looking ahead to this year and next, Motorola found that 54% of businesses planned to increase the number of inventory SKUs they stock.

7. Retailers are shifting the balance of inventory more toward stores, as seen even in 2015 with 15% of Target’s online purchases marked for pick up in-store.

8. To take advantage of mobile devices for increased speed and operational efficiency, 67% of warehouses plan to increase use of these devices for managing inventory.

9. Improved inventory tracking has benefits beyond dollar savings. Measured in 2010, barcodes on medication reduced errors at an academic medical center by 41.4%.

10. Inventory and warehouse management is growing in relevance. The Bureau of Labor Statistics shows that from 2008 to 2015 the number of warehouses in the U.S. rose 9%.

 

Technologies such as barcodes and RFID tags are examples of how inventory management can be enhanced. Two other high-ROI approaches are to create custom applications for your specific warehousing needs and to integrate your inventory system with your accounting, CRM, and ERP software. aACE is a highly recommended solution that brings the benefits of FileMaker development and robust integration to work for you.

The Inventory Tightrope: Keep Your Balance with FileMaker Custom Apps

The Inventory Tightrope: Keep Your Balance with FileMaker Custom Apps

The ideal warehouse situation is a perfectly balanced inventory, where your stock levels are always just right. Never a surplus and never a shortage. You might think this warehousing zen-state is fictional, just like Goldilocks who made the 'just right' balancing point so famous. And while there's no superpower or mystical kung-fu that can create the perfect balance for you, there is some pretty smart tech to help out. The free FileMaker Inventory Management ebook is one such asset.

In a smart inventory process, the warehouse is less a location filled with static objects, more a dynamic element in your business. Your storage tells a story; it describes your cash flow. Hopefully each purchase on your shelves is at a temporary resting point on the way to a profitable transaction with your customers. In this view, your warehouse is vital for customer satisfaction. The FileMaker ebook highlights how inventory forecasting can be a powerful tool for fulfilling customer expectations. Likewise, it points out how the right inventory tracking methods can help you identify pricing imbalances.

Another piece of valuable information found in the Inventory Management ebook is the comparison of various types of tools you can use for monitoring your supply chain. FileMaker provides an easy summary of the benefits and drawbacks of solutions that are old-tech, low-tech, package-tech, tech-from-scratch, and just-right tech:

Pen and Paper — It's hard to imagine where these items fit into modern inventory management. But they're available when nothing else is.

Spreadsheets — A more plausible solution when you're starting out. Spreadsheets excel when your company and your inventory are small. The software is cheap, familiar, and easy to use. Plus if you spend the time, you can create some fairly sophisticated calculations. The drawbacks however are significant. Tracking your stock via spreadsheet can be done when you're starting out, but most growing companies quickly reach the point of diminishing returns. Data that is error-prone, stale, and isolated can only help so much.

Packaged Software — For companies not focused on software, the realization that spreadsheets aren't working anymore often defaults to this channel. Companies ranging from light manufacturing to wholesale distributors to professional services may immediately begin looking for an inventory management system to buy. This can be a helpful interim measure, quickly putting a secure, scalable system into place. And with some extra effort, the package might even integrate with other company systems (i.e., accounting, CRM, ERP). Troubles arise when you realize that the software is one-size-fits-all...sort of. After all the time and effort to deploy it, companies often discover they purchased features they don't really need, while the functionality that actually is provided forces them to become business contortionists, rearranging the processes to fit the tool.

Software from Scratch — For software companies, this may seem like the natural route. If your job is to create technical tools for people, you might as well create them for yourself. The up-side of this is that you get exactly what you need. However, as every company that develops software can tell you, creating a digital tool from scratch is a lengthy process and requires significant resources. It can become very tricky to balance your perfect internal app with your profit margins from external clients.

Custom App on Robust Platform — The best of both worlds is often found in the niche between two well-known options. For inventory management tools, this golden mean is a FileMaker custom application. Using an existing, easy-to-learn code platform, you can craft a tool designed around your precise business needs. And results are available at lower costs and shorter time-frames. Your targeted app can be deployed in many settings and integrated with existing software. It's reliable and secure. For small and mid-sized businesses who want a great balance of centralized information and agile tools, this is often the ideal solution.

The FileMaker ebook goes on demonstrate this conclusion, sharing case studies and testimonials of successful businesses from around the world. Beyond that, they provide an overview of how to begin creating the just-right tool that can help your warehouse operate at just-right levels of inventory. While a personalized app crafted by an in-house citizen developer might not be right for every company, there is a growing number of business owners and inventory management professionals who are leveraging this approach.

 

One of the most highly rated FileMaker solutions for inventory management, as well as other business operations needs, is aACE. This robust yet affordable suite offers a compelling alternative for businesses dependent on open-source solutions like xTuple, browser-based solutions like NetSuite, or client/server solutions like QuickBooks, Dynamics, and Sage. aACE 5 offers on-site and cloud-based hosting, cross-platform support for Mac and Windows, plus easy customization. To jump-start your custom app development, you can start from this powerful framework that integrates your business from quote-to-cash.

Tax Like a Pro — Use Avalara’s 5 Registration Best Practices

Tax Like a Pro — Use Avalara’s 5 Registration Best Practices

Running your own business can be both exciting and nerve-wracking. However one of your least glamorous responsibilities is being an informal representative for the state treasury. Collecting sales tax for the states where you do business isn't something that most entrepreneurs look forward to or prepare for. Luckily, there are specialists who can help you make sure this aspect of your business is also successful.

Avalara has years of experience working on taxation details with small and mid-sized businesses. Last year Avalara Director of Government Affairs Scott Peterson identified five of the most common problems a company faces when trying to start things off right. Use this advice to make sure your sales tax registrations are in order. Then you can focus on the challenges that are more interesting and rewarding.

Pitfall #1: Not registering in the right states - This is an obvious problem, but the solution may not be as clear. To avoid penalties, fines, and audits, you have to know what the right states are. To identify those states, you have to understand nexus - the relationships that require you to collect sales tax. The easiest nexus to identify is where your business offices are located, but several other factors can trigger this obligation. For more details on this key factor, Avalara has provided a number of articles, videos, and whitepapers.

Pitfall #2: Registering in the wrong states - A philosophy of 'better safe than sorry' may not be the best method for sales tax registrations. Each registration costs money and requires you to spend time reporting, even if you haven't collected any sales tax for that state. Clearly those resources would be better invested in more profitable activities.

Pitfall #3: Assumptions about Streamlined Sales Tax (SST) - State governments have realized that it's in their best interest to help businesses collect sales tax. At the start of the new millennium, the SST was organized to simplify registration, reporting, and expenses. Currently there are 24 states fully participating in the SST. If you do business in most of these states, taking advantage of the program can be very helpful. However, if you only have nexus in a few of these states, the benefits for registering this way may not outweigh the costs.

Pitfall #4: Using incorrect NAICS codes - When you register, you specify your company type using codes from the North American Industry Classification System. For example, there are different codes for light manufacturing, wholesale distributors, and professional services companies. The code you select is vital because updates about tax requirements are distributed according to this classification. If you have an incorrect code, you might miss updates that state governments will hold you accountable for.

Pitfall #5: Not de-registering properly - While registering has been streamlined, the process for de-registering when you no longer have nexus is more intricate. Most states have a formal process for notifying the proper departments that you are no longer obligated to collect sales tax. And some states have time constraints on how long you must continue reporting after you cancel your registration.

 

To assist with these various challenges — plus the complexities of calculating, collecting, filing, and remitting sales tax — Avalara offers powerful and affordable sales tax automation software. Leveraging these tools can free up additional resources for your core business activity.

Even greater time and money savings are possible when you integrate sales tax software with your accounting, ERP, and CRM tools. One of the most powerful combinations is to team up Avalara's AvaTax with aACE 5 business operations software. aACE 5 is built on FileMaker so it can deploy both on-premises and in the cloud to run on Mac and PC devices. It helps manage transactions, inventory, and customer interactions. And it's built to integrate with quality tools like AvaTax in order to maximize your business velocity.

"We have been using aACE for 8+ years and going with their advanced integrated software was our best decision ever." - Claire Wade, Manager, Skip Gambert & Associates
Is It Time for Your SMB to Invest in Marketing Automation?

Is It Time for Your SMB to Invest in Marketing Automation?

How nice would it be to have a generous marketing budget so you can explore technology tools without worry? Most small and mid-sized businesses don't have that luxury though. Instead smaller companies have to be very careful and very smart about what tools to invest in and when. Marketing automation tools are no exception.

To help you decide if the time is right for your company to get the advantages that come with automation, let's walk through some factors that Larry Alton shared on CIO.com last year.

Defining Terms

You know what marketing is, but might not realize what parts of a marketing process can be automated. The basic, most economical automation tools focus on simple, repetitive tasks, such as responding immediately to emails or publishing social media posts according to a schedule. The functionality grows from there as more complex, more expensive packages provide more sophisticated operations. Lead scoring and segmentation, A/B testing, product databases and coupon codes, social media monitoring — all these tasks can be programmed for automation. And ongoing research in machine learning might add more to this list.

Potential Drawbacks of Automation

The most apparent difficulties from automation hinge on becoming dependent on the tool. When it is so easy to send out emails to a client segment, you might be tempted to overuse the feature, annoying customers instead of enticing them. Likewise, the tone and feel of your customer interactions might gradually shift to a robotic, less engaged mode. These are examples of how an easy tool can affect your work. Just like relying on a hammer makes more and more challenges look like nails, with simple email and social media outreach, it may seem like every campaign is merely a reason to schedule another automated messaging crossfire.

Besides the mindsets that can crop up in your marketing team, the paradigms of the marketing tool vendor might also be troublesome. Their pricing can be an obvious hurdle; however, a more dangerous obstacle might be their attitude about processes. Often the big-name CRM vendors will offer an excellent toolset — as long as you change your workflow to match theirs. For some companies this might not be a problem, but when your team is already working well, it's worthwhile to shop around for a marketing automation suite that can adapt to support you.

You probably noticed that these difficulties might better be described as "dangers of not being mindful with your tools." Any power tool can have side effects if the person using it isn't careful. And marketing automation is definitely a power tool, as the benefits show:

Rewards of Leveraging Automation

When you invest in a CRM package or other marketing automation resource, you can look forward to some important advantages:

Leveling the Playing Field — Your dollars will obtain the same benefits that larger competitors obtain from their marketing tools. A small company might not be able to field as many salespeople, but your CRM software can give you just as much insight into the right people for your sales staff to contact. You can reach out to them the same way a national enterprise would, tracking their interactions as well.

Reduced Human Resource Demands — Automation's biggest selling point is how it enables fewer staff to achieve larger results. This might translate into savings, where a certain job role can be handled by the software, allowing you to convert that position into something else the company needs. Or the benefit might come by way of profits, where the software helps your staff be more efficient and effective in converting leads into clients.

Education and Ideation — Deploying new tools often brings you into contact with new people and new ideas. Whether it's the software vendor directly or the active community of developers as with FileMaker products, you have a chance to benefit from their experience at no additional charge. Along the same lines, as you learn the strategy behind the software design you may be able to extract insights for improving your business processes.

Scalability — Because a marketing automation suite operates primarily in a digital framework, a high quality system can easily grow with your company. Computerized customer management can track 5000 contacts as easily as 50. Each year as your business increases, the software will continue to provide helpful insights for your team and regular contact for your customers.

 

The bottom line isn't a surprise. As with any business investment, an entrepreneur needs to be smart. Marketing automation can be very useful to balance out competitive weaknesses. However, it shouldn't become a crutch. No software should eclipse the ingenuity, warmth, and competence that your skilled staff can provide. With creativity in niche targeting and locally-focused optimization, you should never feel stuck and never settle for a glossy package that doesn't provide what you need.

Ideally your CRM tool will do more than just manage customer relationships. For example, when it is integrated with ERP software, your business velocity increases that much more — insights from the warehouse can be routed to the client, rather than waiting for this email or that conference call. Likewise, when your accounting system communicates directly with the marketing tools, you can instantly know how budgets are progressing and what additional resources you have to invest. aACE 5 provides a fully integrated business software suite, with all the acumen and agility that entails:

"In addition to implementing aACE and using it for the past five years, aACE has helped us grow our business, allowing us to quickly change our business processes as our customer base has changed, thus increasing our ability to get solutions to the marketplace quickly and efficiently." — Bryan Anderson, All Solutions 360 LLC
TMI and Too Much Collaboration — When More Tools Are Less Effective

TMI and Too Much Collaboration — When More Tools Are Less Effective

For businesses looking to improve their operations, there's currently a lot of focus on collaboration applications and services. But even the best digital collaboration tools might not actually be the best tool for you.

The Wall Street Journal has published and re-posted Jay Greene's article about the diminishing returns of collaboration tools. Titled online, "Beware Collaboration-Tool Overload," Greene's report asks some valuable questions about software designed for sharing. From startups to tech giants, there are a host of apps that support chat sites, video conferencing, and cooperative document editing.

What about the end-users? Greene notes that the research shows workers often find it hard to get on board for new tools. If the app doesn't offer a distinct benefit for what they are trying to accomplish, then it's just one more chore to take care of. Savvy workplace managers are quick to observe and respond to this paradigm. They have moved to simplify the toolsets, so likewise, the tool providers are adapting.

Greene takes an example from the J. Walter Thompson advertising agency. The company provided a plethora of tools in effort to maximize efficiency. However, the employees quickly recognized that not everyone in the company was using every single tool provided. But the entire team was using email. This relative reliability meant that email became the de facto collaboration tool. And this quickly turned into email overload. The agency's decision was to prune back the diversified toolset. By focusing personnel's attention on a single useful app, they were able to move forward.

Craig Le Clair, an analyst with Forrester Research Inc., is another source that Greene quotes in his insightful write-up. Le Clair highlights how each new tool requires switching to a new window and new interface conventions. Each new tool requires new login credentials. Each new tool might be intended for specialized purposes, but even that becomes more mental overhead which the end-user must manage.

For smaller companies, is this lesson relevant? You might be able to get better results than any collaboration software or email by simply walking across the room to a colleague.

But while dynamic collaboration on documents might not be a priority, there are still ways that a simplified toolset can bring your business excellent returns on efficiency. A unified business suite for your accounting, ERP, and CRM tasks can eliminate the headaches from spreadsheet proliferation and poor software integration. It's even better when that business suite runs smoothly on the PCs in the office and the iPads in the warehouse.

aACE 5 is a cross-platform business operations solution that helps you take the WSJ's lesson about simplified software right into the heart of your company. From quote-to-cash, aACE can streamline your workflows, maximize your efficiencies, and accelerate your business velocity.

"Any SME who wants tight control, instant up-to-date information over all aspects of their business without the need to plough through acres of data, and optimal automation of all sales and functions, irrespective of Mac or Windows platforms. In short, I have no hesitation in fully recommending aACE as a truly great enterprise solution. We are truly proud to be part of the aACE family." — Peter Osborne, CEO, Special EFX Ltd.
Leverage the World’s Top FileMaker Experts for Your Business Success

Leverage the World’s Top FileMaker Experts for Your Business Success

The energetic FileMaker community is something we've noted before, and the best opportunity to experience this enthusiasm and support is DevCon. This year the event is in Phoenix, AZ on July 24-27.

You'll have the chance to join over 1,500 other FileMaker developers at all different skill levels, each seeking to learn and share. This broad sample of the community comes from around the globe, but they're unified in a vision of how FileMaker can improve business processes.

The conference itself will include focus sessions, special interest meetings, face-to-face consultations, and chances to network with FileMaker staff and other experienced developers. You'll pick up tips and best practices, learn how to maximize the value of FileMaker in your company, and get up to speed on new tools and plug-ins — all to help you more efficiently develop robust FileMaker solutions.

Monday, July 24: Training Day — Professional developers will help you progress from your current skill level to more advanced programming tasks. Most sessions are hands-on, while the project management track is a focused discussion of agile development and experienced troubleshooting.

Tuesday and Wednesday, July 25 & 26: Take part in over 14 hours of conference sessions, organized according to your level of expertise and your focus on innovation or business application. These presentations will be followed with a pool party on Tuesday and the FileMaker Excellence Awards ceremony on Wednesday.

Thursday, July 27: FBA Day — After the partner keynote, members of the FileMaker Business Alliance will be able to attend specialized presentations, while everyone is invited to training on best practices to help businesses thrive.

Register early to take advantage of limited-time discounts.