Downloading the Xero/MYOB Invoice PDF

Whether you’re using Xero or MYOB AccountRight for your business accounting software there are times when you would prefer to send your customer the Invoice that Xero and MYOB generate natively. For example if you have added an online Payment option to your Xero Organisation you might prefer to send the customer the Xero generated Invoice with the “View and pay online now” link in the PDF for customers to click and pay online with a credit card. Similarly if you’re using MYOB AccountRight you might to send your customer the invoice using one of the MYOB M-Powered layout forms.

For our fmAccounting Link (Xero Edition) solution we’ve already given users the ability to:

  • get the Online URL for an Invoice and include that in an email etc that they send to clients so they can choose the “View and pay online now” option
  • download the Xero Invoice PDF into a FileMaker container field and then save that to the desktop etc or include that in an email to the customer in place of a FileMaker layout based Invoice

We’ve been working on creating a similar feature for our fmAccounting Link (MYOB AccountRight Edition) solution and it will be included in the next update. Like the Xero solution it will allow users to click a button to download the MYOB PDF invoice into a FileMaker container field and then save that to the desktop or include that in an email to the customer. We currently have the ability to download all the Form Templates setup in your MYOB Company File:

and then specify the Printed Form for each Customer in the fmAccounting Link (MYOB AccountRight Edition) file:

 

This is then used as the default when you request the MYOB Invoice PDF, however you can specify a different form template to be used by passing a parameter with the request for the Invoice PDF. Here’s a quick video that demonstrates creating an Invoice and then requesting the PDF from MYOB:

fmAccounting Link (MYOB AccountRight Edition) Now Supports Jobs

We’ve just finished an update to fmAccounting Link (MYOB AccountRight Edition) which now includes examples for working with Jobs, one of the most requested features from our customers. fmAccounting Link shows you how you can use FileMaker to:

  • download Jobs from MYOB to FileMaker (all Jobs or filtered by Start Date)
  • create Jobs in FileMaker and upload them to MYOB
  • update a single Job from MYOB
  • enter a Job against an Invoice Line Item or a General Journal Item
  • download a Job Budget from MYOB to FileMaker and send an updated version back to MYOB

This is a free update for all existing customers. You can view the full release notes on our version history page. If there are other features you would like to see in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know.

New fmAccounting Link (Xero Edition) Videos

We’ve just uploaded a couple of new videos demonstrating how you can work with Prepayments and Overpayments using fmAccounting Link (Xero Edition). In each video we cover:

  • creating a new Prepayment and Overpayment from a Customer
  • allocating the Prepayment/Overpayment to an Invoice
  • refunding the balance of the Prepayment/Overpayment

You can watch these videos on the Videos page or here are the direct links:

Prepayments in fmAccounting Link

Overpayments in fmAccounting Link

fmAccounting Link (Xero Edition) – Prepayments Update

Our first update to fmAccounting Link (Xero Edition) for 2017 is now out the door – this release includes a number of minor enhancements as well as a new endpoint example: Prepayments. We’ve had a number of requests for Prepayments so we’re happy to release this free update to all our existing customers.

The fmAccounting Link (Xero Edition) file has examples for:

  • downloading Prepayments from Xero (all Prepayments or between 2 dates)
  • creating a Prepayment in FileMaker and pushing to Xero
  • allocating Invoices to a Prepayment in FileMaker and pushing to Xero
  • creating a Refund for a Prepayment in FileMaker and pushing to Xero

Further details on fmAccounting Link (Xero Edition) including the full list of examples are available on the fmAccounting Link (Xero Edition) product page. If there’s any examples that we don’t currently have that you would like to see please get in touch and let us know – we’re already working on the next round of enhancements and examples based on customer feedback.

fmAccounting Link (MYOB AccountRight Edition) Updates – my.MYOB Login and General Journals

We’ve been busy working on some updates to fmAccounting Link (MYOB AccountRight Edition) over the past few weeks. fmAccounting Link (MYOB AccountRight Edition) was a popular item during our recent End Of Year sale and we’ve had some great feedback from customers about features they would like to see in future releases.

We’ve just released an updated version of fmAccounting Link  – v1.0.8. As well as the usual bug fixes we’ve added examples for working with the General Journals API endpoint – you can now download, create and update General Journals from FileMaker using fmAccounting Link. We’ve also added support for users that have linked their MYOB Company File User ID to their my.MYOB login – typically this is set using either of the following dialogs in AccountRight:

We couldn’t find anything about working with linked my.MYOB logins in the API documentation and after raising a ticket with MYOB developer support we were informed about the changes you need to make when working with linked my.MYOB accounts. We’ve added a new checkbox to the MYOB Company screen that allows you to flag that you’ll be using a linked my.MYOB login:

which handles the required changes automatically. For existing customers using older versions of fmAccounting Link you can simply disable a single script step to handle working with linked my.MYOB logins – see our FAQ page for details.

We’ve started working on adding examples for working with the JOBS API endpoint and hope to have this completed in the next few weeks. If there are features you would like to se in the core fmAccounting Link (MYOB AccountRight Edition) file please get in touch and let us know. You can view the full release notes on our version history page.

FileMaker Inc. Releases Xero eBook

filemaker-xero-ebook

FileMaker Inc. have put together a number of resources outlining the benefits of Xero integration with a FileMaker custom app, focussing on how to eliminate duplicate data entry between FileMaker and Xero and centralise your Customer, Inventory and Invoice data whilst protecting your Xero financial data. I’m pleased to report that our recent Xero Webinar and our fmAccounting Link (Xero Edition) solution are both featured.

You can access the eBook and other resources from the FileMaker Inc website. If you would like to discuss integrating Xero with your FileMaker business app please get in touch.

Coming Soon – fmEcommerce Link (WooCommerce Edition)

Earlier this year we published a series of articles about FileMaker and eCommerce Integration, highlighting our use of External SQL Data Sources (ESS) to make our online store orders visible in our internal FileMaker CRM. We’ve been using this method of integration successfully for many years and it has saved us countless hours by not having to manually re-enter online orders in our main FileMaker business app and our accounting software (Xero).

That was until recently when we started getting this error message every time we navigated to the online orders layouts:odbc-error

Suddenly we could no longer see our online order records! Everything was still working on the website and orders were still being submitted successfully (we receive an email for each order) so we started troubleshooting this to try and get to the bottom of it. After many frustrating hours we still could not establish the ODBC connection to our server, so we made contact with our web host and opened a ticket explaining our issue and describing how this had previously worked fine for many years. We were then informed that they had disabled remote MySQL access for security reasons and there were no exceptions – talk about a great way to annoy your customers by switching off access and not informing your customers about this!

It was still possible to connect but you had to create an SSH tunnel first – we then wasted another couple of days setting up the SSH tunnel which would work but then drop out, and we had issues with automating this so it could run when the server wasn’t logged in. After many days of frustration and lost productivity I decided to abandon the SSH tunnel efforts as it was proving too unreliable and too look at other options. Databuzz specialises in FileMaker integration and having recently written an article on working with eCommerce APIs and Webhooks I revisited my article and knew what needed to be done.

Our website stores are built with WooCommerce, a popular plugin for WordPress that powers over 39% of all online stores. WooCommerce offer both a push and pull API so you can have new orders automatically pushed to a server, and also download new orders on demand (e.g. get all new Orders today). The push option is the more complicated of the two options as it requires FileMaker Server, Customer Web Publishing, PHP pages and Webhooks to be setup, so we decided to focus initially on the WooCommerce REST API as that allows us to query WooCommerce for any new Orders and download the data directly into FileMaker. This can be run regardless of whether the file is hosted with FileMaker Server or just using FileMaker Pro, and we can also setup server side schedules to run each night and download new data. The REST API also allows us to push data from FileMaker to WooCommerce, such as Product updates, which is something customers have requested in the past.

Fast forward a few months and we are in the final stages of development and testing of our latest product – fmEcommerce Link (WooCommerce Edition):

preview-home

fmEcommerce Link is our solution to connecting FileMaker to WooCommerce when you can’t make a direct ESS/ODBC connection – you use the fmEcommerce Link file to query your WooCommerce store for new orders, product inventory changes, new customers and also to push data back to WooCommerce such as new Products. You can link the fmEcommerce Link file to your existing FileMaker solution to push orders from WooCommerce into your main FileMaker business app, or recreate the same functionality inside your FileMaker business app as the fmEcommerce Link will be 100% unlocked for you to explore.

Here’s some screenshots showing data that we have downloaded from our test WooCommerce site:

preview-order-details

preview-orders-list

preview-products-list

I’ll be posting some videos demonstrating the core functionality of fmEcommerce Link over the coming days and would love to hear any feedback from existing FileMaker/WooCommerce users about any features you would like to see in the product – just leave a comment below.

fmAccounting Link (Xero Edition) Updates – Reports and Invoice Attachments

We love hearing back from our customers about new features/examples they would like to see in the core fmAccounting Link (Xero Edition) file. We recently had some requests for examples showing how to upload files/attachments from FileMaker to an Invoice and the ability to download a Report from Xero to FileMaker.

We’ve had the Files API on our list of future enhancements as well as the Reports endpoint for a while, so we took this opportunity to dive in and get some of the basic functionality for these developed so our customers can start using them now.

For the Reports endpoint we’ve started with the Trial Balance report – we’ve created a new Reports module in the fmAccounting Link file that we will add to over time with additional reports that are available via the Xero API. The Trial Balance report lets you specify the date to run the report as at, and then the report is downloaded into the fmAccounting Link (Xero Edition) file and looks like this:

trial-balance-report

For the Invoice Attachments we’ve added a new TAB to the Invoice details layout allowing you to select a file to upload to Xero and attach it to the current Invoice:

invoice-attachments

You can upload up to 10 attachments (each up to 3mb in size) per invoice, once the invoice has been created in Xero. To keep things simple we’re not storing the selected file in a container field – we’re just storing the path to the file (you can change this behaviour in your version of the fmAccounting Link file). You can upload the common file formats, such as PDF, JPG, Word, Excel and PNG files, and you can specify for each attachment whether to include that in the Online Invoice so that the attachment appears when a user clicks on the online invoice link. A full list of file types that you can upload is available on the Xero website.

One limitation of the Attachments API at the moment is that you cannot currently delete an attachment in Xero from FileMaker – you will need to login to Xero to delete any attachments that have been uploaded to an Invoice.

We’re working on the Prepayments endpoint next and should have that finished in December, and then we’ll start adding more of the Reports that are available via the Xero API. If there’s any examples that we don’t currently have that you would like to see please get in touch and let us know. Further details on fmAccounting Link (Xero Edition) including the full list of examples are available on the fmAccounting Link (Xero Edition) product page.

FileMaker and Xero Integration Webinar Recording

FileMaker and Xero Integration Webinar

Are you using FileMaker to run your business and also Xero for your accounting software? Would you like to see how they can be integrated together so you can streamline your workflow and protect your sensitive Xero data at the same time?

Join Andrew Duncan from Databuzz and David Borgnis, Business Development Manager, APAC at FileMaker Inc. for an informative and explorative 60 minute presentation. The webinar details are:

Date: Thursday, 3 November, 2016
Time: 12 noon (AEST)
Duration: 60 minutes
Register now

Integrating FileMaker and Xero allows you to remove double data entry and human errors saving your company significant time, money and hassle by automating the exchange of data between FileMaker and Xero. Xero was recently named the most-loved accounting software for a second year in a row, beating MYOB and Intuit Quickbooks, scoring five stars across seven criteria. It was named the preferred accounting software of Australian accountants – as you can see from the chart below it was by a significant margin:

afr-chart-1-1_800x480_acf_cropped

In the webinar will demonstrate:

  • how to setup the authentication between FileMaker and Xero without giving your staff direct access to Xero
  • how to download data from Xero into FileMaker (Chart of Accounts, Tax Rates, Inventory Items etc)
  • how to push a Sales Invoice from FileMaker to Xero (and create a Contact in Xero at the same time)
  • how to push a Payment for a Sales Invoice from FileMaker to Xero

We hope you can join us for the webinar – if you have anything you would like addressed in the webinar please leave a comment below. For further details on fmAccounting Link (Xero Edition), our FileMaker solution for integrating with Xero please visit the fmAccounting Link (Xero Edition) product page.

Update: thanks to everyone who was able to attend the webinar. If you weren’t able to make the live webinar the recording is now available here.