Training & Consulting Services

Integrate FileMaker Pro and QuickBooks

Quickbooks Plug-In Offers Quick Integration with FileMaker Pro.

Many of my clients use QuickBooks to manage their accounting, so it’s important for me to have a cost-effective database solution that integrates with QuickBooks without involving a lot of extra steps. With the FM Books Connector, you can easily bring the two applications together to work seamlessly as one.

FM Books Connector is a plug-in from Productive Computing that gives you control of QuickBooks via a two-way real-time integration. With it, you can Add, Edit, Delete, or Query virtually any QuickBooks data from FileMaker Pro.

One of the advantages of FM Books Connector is you don’t have to learn or know QuickBooks eXtensible Markup Language (qbXML) to use it. Similar to XML, it’s the core language for electronic exchange, creation, and management of accounting and other business data from QuickBooks.

Like most Filemaker Pro developers, I hate reading manuals. If a product isn’t somewhat self-explanatory, I tend to move on quickly. When I first downloaded and experimented with FM Books Connector, I was surprised by how quickly I was able to begin posting invoices from the supplied demo file.

I decided to take a closer look, so from the demo, I started to review the scripts, which are easy to read and well-commented. It all looked pretty simple, but I was still a little hesitant because in my experience after I try to replicate the fields and scripts to my own solution, it usually doesn’t work the same.

I spent about two hours importing scripts and updating field names with my live data. To my surprise, I had successful results!

Getting Started
When you download a demo of FM Books Connector, you also receive a folder containing:
• Plug-in, which you place in your FileMaker extension folder
• FileMaker demo file, which is an unlocked FileMaker Pro database with live examples and working scripts you can use for your own experimentation.
• Functions Guide that gives listings of external functions and expected parameters.
• Developer’s Guide, a helpful guide filled with instructions, code, and links to video tutorials at http://www.fmbooksconnector.com

In the FileMaker demo file, you’ll find several examples that show you:
• How to post a new customer to QuickBooks
• How to pull customers into FileMaker Pro
• How to update a customer in QuickBooks
• How to post an invoice to QuickBooks
• How to pull invoices into FileMaker Pro
• How to pull a customer balance into FileMaker Pro

The demo plug-in is a full working version. You can use it up to 30 days with 2-hour sessions of posting, programming, and testing before it times out.

Now that I had copied predefined scripts from the example, I started to venture off into areas not covered in the demo. With little to no knowledge of the plug-in, I began to build my own scripts, but when I posted a check for the first time, I received an error message. The message was clearly defined, but I didn’t know what was wrong. Rather than consulting the manual, I called Productive Computing. Not only did Productive Computing answer the phone, when I described my error message, they quickly gave me an explanation of the error and how to resolve it.

Posting error messages
There are some important things to know to help you troubleshoot and understand what QuickBooks requires to successfully post an invoice:
• Make sure your customer/vendor exists in QuickBooks
• You can post and validate records using either the ListID or FullName. The ListID usually refers to a QuickBooks record ID and the FullName refers to the actual QuickBooks displayed name.
• Make sure your invoice detail includes an existing quantity.
• Make sure your invoice items code exists and matches exactly in the QuickBooks items table.
• Your script code is case sensitive.
• FM Books Connector plug-in requires the person doing the posting to have the plug-in installed and QuickBooks open to post.
When you add and test the script to post data to QuickBooks, you’ll get helpful error codes if your data didn’t post successfully. There’s also a special function that exposes the XML generated behind the scenes for advanced programmers who understand and want to troubleshoot the XML.

The “Check for Errors” script is the same for all scripts and required before you can do anything else. It checks that you’ve installed the FM Books Connector plug-in correctly and the data you are posting is valid and complete according to QuickBooks.

FM Books Connector

Take it for a test drive
After experimenting with the code Productive Computing supplies, you’ll probably want to start branching out on your own. I can walk you through an example of how to duplicate and modify existing scripts to create new scripts for Creating/Editing Vendors and Posting Checks.

For my example of modified scripts, I used one FileMaker Pro database with the following table listings.
• Interface – All global data for generating XML coding pasted or posted to QuickBooks.
• Contacts – One file containing customers and vendors.
• Transaction – Check header data, to include check number, check date, check amount, Vendor (Pay to the order of), and memo.
• TransactionDtl – Detailed lines showing items included on the check.

Using Productive Computing supplied scripts on how to post a Customer and Invoice, I simply duplicated and modified the “Push Customer to QB” script to create a new script called “Push Vendor to QB.” I also duplicated and modified the “Edit Customer to QB” to create a new script called “Edit Vendor to QB.”

If your VendorListID already exists in QuickBooks, you only have to present the VendorListID and VendorEditSequence to update your vendor record to QuickBooks.

I then created a third script in which I combined my Add Vendor script and my Edit Vendor script into one script called New/Update Vendor that checks to see if the vendor is in QuickBooks by checking if the VendorListID is present. If the VendorListID doesn’t exist, FileMaker Pro pushes the new Vendor to QuickBooks and returns a Vendor List ID.

Additionally, I duplicated the Push Invoice to QB script from the FM Books Connector database. You can modify a couple of lines in the script to create a new script for posting checks to QuickBooks. The script first checks the transaction record to see if the check payee has previously posted to QuickBooks. If the payee has not yet been posted, the script will first post the vendor and then post the check.

Before FileMaker Pro can post your check to QuickBooks, it requires you to have created the vendor. Use the VendorListID to check for the List ID before attempting to post the check. If the vendor doesn’t exist in QuickBooks, the Push Vendor and Post Check script uses an if statement to ensure the vendor is added first. After you add the vendor, you can now post your checks. If your payee/vendor already exists in QuickBooks, you only have to present the VendorListID and post your check. You can duplicate and modify the Get Customer Edit Sequence script to create a new script called Get Vendor Edit Sequence. This script checks the vendor edit sequence before updating the record to make sure the information you want to post is the most current data.

Rather than reinventing the wheel and rebuilding all the scripts and fields required for integration with QuickBooks, you may be wondering if you can save time by using Productive Computing’s supplied file. The answer is yes; however, if you use the file provided, be sure to deactivate the open script, which is programmed to delete all data each time the user restarts.

After building and installing my new scripts, I began to test posting my data to my clients’ live QuickBooks database. Although everything didn’t go 100 percent smoothly (but what does?), I now had a clear understanding of how to troubleshoot my errors, and felt confident that if I needed further assistance, Productive Computing was just a phone call away.

I was so impressed, I even started to read the manual.

Pros:
• Do not need to learn qbXML to use
• View account real-time accounting activity
• Affordable one-time cost
• Easy registration
• Offers resale program for FileMaker developers
• Does not require fields to be formatted for QuickBooks to accept
• Productive Computing offers superior customer service

Cons:
• Only works on a PC; plans for a Mac version will be implemented if Intuit releases the qbXML SDK that is compatible with the Macintosh version of QuickBooks
• You must have administrative access to set up the plug-in for the first time

Great things to know…
The Intuit Developer Network is free to join and can be beneficial for gaining new customers who are currently using QuickBooks and may need assistance integrating with FileMaker Pro.

53 replies
  1. LorenaBlairmip
    LorenaBlairmip says:

    How to choose the right online dating service for you

    So it might seem hypocritical that the idea of online dating makes me so awkward, i wish to cover my ears and start loudly chanting adam4adam login whenever someone suggests it.

    the top thing that freaks me out is making a concerted effort into figuring what I want in a dude, And then putting it out to a lot of strangers. the job seems clunky. I generally don know what I want until I meet a person that I want. I also much prefer the improvisation and magic of that first spark when you meet someone new, When you least predicting it. Like at the grocer’s, Or children portrait reunion.

    But I realize I need to challenge my judgments of online dating service personals. She basically helps people become pros at online dating services.

    Is internet dating, states. Just a tool to meet people lateral side of your social circles. It just a way to see what else is out there. Explained my reluctance and discomfort and asked Davis if there were particular sites that would help me ease into this situation.

    Site is good for anyone because it varies based on age, How you apply the tool, Who you seeking to meet, kinds of relationship you looking for and what your personality is like, she says. A personal opinion thing. Things were starting to feel overwhelming again. Just as my instinct to coat my ears began to creep up, Davis suggested I start by looking into niche dating sites. which, I be reaching a smaller community of people specific interests.

    That didn sound bad in fact, It made fully feel. If there was a site for folks who like Marina Abromovic and the British Office, I probably be on there, With the genuine goal of meeting others like me.

    So I started to digging into the world of niche online dating services and came up with some surprising finds.

    Here are my favourite three:

    farming City folk just don get it! At least that what the trademarked tag line to FarmersOnly claims. This site is for real country folk hunting for love.

    ledgers What your favourite book? Is a safe albeit humdrum icebreaker. It also happens to be the main theme Alikewise is based on. Meet people based on their favourite literature so long as it not Anime porn.

  2. movie online
    movie online says:

    Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a bit, but other than that, this is excellent blog. A fantastic read. I will certainly be back. Antonia Murvyn Ernesto

  3. Anonymous
    Anonymous says:

    Ну и еще новый, театр неважный
    множитель – сроки выполнения.
    Всех причин надо думать нежизненно, равно
    эта состояние содержит манеж толкать(ся) включая на Москве, жанр и
    прочих мегаполисах. Но недурно толковать, будто в
    этом случае, обычно, имеет точку замечаться высокий уровень
    особенности опуса и еще оснащение гарантий.

    Например, цена исполнения непростой дипломной работы по программной инженерии в
    силах дорастать сорок тыс. руб.. Стоимость дипломной занятия на милосердном колледже подле несрочных сроках (а) также трафаретных требованиях сбоку 10000 рублей.
    Курсовые службы как водится являть собой больше большими равно сложными,
    чем дипломные, вследствие этого равным образом влетают меньше.
    Однако хоть на донышке определять, задавшись эдаким параметром, несть среднестатистическая цена дипломной (а) также многокурсовой вещи.
    Обычно средняя стоимость курсовой деятельность оформляет 2-пятого тыс.
    рублев с целью трудов бессчетно экономике, юриспруденции, психологии, праву, штатскому делу и других сходных дисциплин.

    Проведя анализ многообразных фирм, предоставляющих
    написание дипломных вещей в заказ, разрешается
    официально одобрить, кое-что малая ставка дипломной службы
    оформляет восьмой тысяч рублев, посредственная
    ну – 15 тыщ. Таким бо иконой позволяется посчитать себестоимость многокурсовой
    труда, преступив получи страничку заказа курсовых работ другими
    словами для страничку оценки
    заказа. Весь контент многокурсовой произведения,
    помимо добавят детали (иллюстрации, формулы, таблицы, диаграммы да т.д.) обязан быть выровнен по части ширине.

  4. dizi
    dizi says:

    great points altogether, you just received a new reader. What could you suggest about your put up that you just made a few days ago? Any sure? Trixy Jesse Ingham

  5. CBD oil for sale
    CBD oil for sale says:

    Thank you a lot for sharing this with all folks you really understand what you’re talking approximately!
    Bookmarked. Kindly also talk over with my site =). We
    may have a link trade contract between us

  6. CBD for dogs
    CBD for dogs says:

    Have you ever considered publishing an e-book or guest authoring on other blogs?
    I have a blog based on the same information you discuss and
    would really like to have you share some stories/information. I know my audience would appreciate your work.
    If you are even remotely interested, feel free to send me an email.

    Look at my homepage … CBD for dogs

  7. buy CBD
    buy CBD says:

    Magnificent beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog web
    site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept

  8. CBD for dogs
    CBD for dogs says:

    I’m extremely impressed with your writing skills
    as well as with the layout on your weblog. Is this a paid theme or did you modify it yourself?

    Either way keep up the nice quality writing, it’s rare to see a great blog like this one today.

    Feel free to visit my homepage; CBD for dogs

  9. cbd gummies for pain
    cbd gummies for pain says:

    Just want to say your article is as astonishing.
    The clearness to your put up is simply nice and i could assume you are knowledgeable in this subject.
    Fine with your permission allow me to clutch your feed to keep
    updated with impending post. Thank you one million and please carry on the enjoyable work.

  10. cbd for dogs
    cbd for dogs says:

    Hi, i feel that i saw you visited my site so i got here
    to return the want?.I’m trying to in finding issues to
    improve my web site!I suppose its ok to make use of a few of your ideas!!

  11. best CBD gummies
    best CBD gummies says:

    My partner and I stumbled over here coming from a different
    web address and thought I should check things out. I like what
    I see so i am just following you. Look forward to finding out about
    your web page repeatedly.

  12. gummies
    gummies says:

    I do trust all of the ideas you have introduced for your post.
    They are very convincing and will definitely work.
    Still, the posts are too quick for beginners.

    May you please lengthen them a little from subsequent time?

    Thank you for the post.

  13. https://www.facebook.com/pages/category/Health---Wellness-Website/Vital-flow-reviews-102135748499657/
    https://www.facebook.com/pages/category/Health---Wellness-Website/Vital-flow-reviews-102135748499657/ says:

    This video is presenting does vital flow work but also try to cover the
    following subject:https://www.facebook.com/pages/category/Health—Wellness-Website/Vital-flow-reviews-102135748499657/

    -vital flow for prostate

    -vitalflow prostate really works

    -vitalflow prostate support reviews

    One thing I noticed when I was researching info
    on does vital flow work was the absence of appropriate details.

    Does vital flow work nevertheless is an subject that I know
    something about. This video therefore should be relevant and
    of interest to you.

    ~~~~~~~~~~~~~~~~~~~~~

    Follow our video clips about does vital flow work as well as other comparable topics
    on

    Hi there! Someone in my Myspace group shared this site with us so I came to give it
    a look. I’m definitely loving the information. I’m book-marking and will be tweeting this to my followers!

    Exceptional blog and brilliant design.

  14. EN HIZLI SAÇ UZATMA
    EN HIZLI SAÇ UZATMA says:

    Thanks for any other great post. The place else may just anyone get that
    type of information in such a perfect approach of writing?
    I’ve a presentation next week, and I am on the search for such info.

  15. Lean belly 3x supplement side effects
    Lean belly 3x supplement side effects says:

    I don’t even understand how I ended up right here, but I assumed this
    post used to be good. I do not understand who you might be however definitely you are going
    to a famous blogger in the event you aren’t already.
    Cheers!
    Appreciate it, An abundance of posts.

    You said it adequately..

    You mentioned that fantastically.
    How long do I have to use this product before I
    see results?
    Remember, it’s critical to give Lean Belly 3X an honest chance to work by taking it as recommended for at
    least 60 days. Like all Beyond 40 products, Lean Belly 3X is made with the highest quality ingredients, but
    no product will work miracles overnight.

    My web-site: Lean belly 3x supplement side effects

  16. Tanmbw
    Tanmbw says:

    structure News UK

    We are highly responsible journalists with many years experience in news reporting. stated, Despite all efforts to achieve accuracy we can make no warranty or statement as to the accuracy or fitness for purpose of any material on this web site. This is to help you are aware of how the Youth Justice System works, What and who is moving.private eye Stories: The True Crime Library is a whole resource for news, Stories and journals featuring detective stories.General marketplace listings: marketplace Blog Housing, Investment Forclosure News Mortgages homes for sale, renting, business Businesses.insurance plans: russian brides photos News and reviews for low cost policies.CK Claims compensation for injuries Solicitors: UK personal injury specialists covering locations including Manchester, Sheffield and consequently Doncaster.death records: Find death records for lost loved ones, Cemetery awareness, Obituaries and the most all online. Extensive legal data including details of policy, And re-training advice.Legal advice on the distinction between ABH and GBH: This useful guide contributed by the criminal defence solicitors firm Lawtons examines the differences between ABH (Actual physical Harm) and then GBH (Grievous real Harm) when it comes to UK law. It looks at the respective legal explanations for each, The potential sentences and what you should do if accused of such crimes.Louisiana Divorce attorney: A Louisiana law firm who has proeffieceint attorneys in the areas of car and truck accidents, injuries, maritime law, an elderly care facility abuse, medical malpractice and divorce.hillcrest divorce: list : Certified family law pc professional for divorce, Alimony, your sons or daughters, custody, And division of property operating in San Diego California.Spine Injury legal: If you or a loved one is suffering from a spinal cord injury, It is crucial to consult with an experienced personal injury lawyer as soon as possible.Texas mesothelioma cancer Lawyer: How can a mesothelioma lawyer in Texas help you? Get referred to the best doctors and treatment centers and get monetary compensation for all the necessary bills.A homeless man who trashed a hotel where he was being housed in reaction to Covid 19 was ordered to pay 300Brother sister with glass then claims self defence.

  17. Psychic Soulmate Sketch Reviews
    Psychic Soulmate Sketch Reviews says:

    to learn about psychic soulmate sketch reviews, visit: https://sites.google.com/view/soulmate-sketch-review-reading/home

    This video is presenting psychic soulmate sketch reviews valuable
    information but also try to cover the following subject:
    -psychic soulmate sketch and description
    -soulmate sketch reading
    -psychic soulmate sketch reviews

    Youtube is the very best website to go when searching for videos about psychic soulmate sketch reviews.

    Psychic soulmate sketch reviews is undoubtedly
    something that intrigues you and a lot of people so I made this
    video .
    _________________________
    If you would like to learn even more concerning psychic soulmate
    sketch and description I suggest you to look into our
    various other video clips :
    ~~~~~~~~~~~~~~~~~~~~~
    Now that you have actually watched my YT video regarding psychic
    soulmate sketch reviews has it helped?
    Please ‘like’ the vid to assist other people looking for psychic soulmate sketch and
    description or soulmate sketch reading :
    )

    Ahaa, its nice conversation concerning this piece of writing at this place at
    this website, I have read all that, so now me also commenting here.

  18. delta 8 thc
    delta 8 thc says:

    Hello, i think that i saw you visited my web site so i came to “return the favor”.I’m trying to find things to enhance my site!I suppose its ok to use some
    of your ideas!!

    My blog post: delta 8 thc

  19. delta 8 thc
    delta 8 thc says:

    I just like the helpful info you supply for your articles.
    I will bookmark your blog and check again here frequently.
    I’m slightly sure I will be told plenty of new stuff right right here!
    Best of luck for the following!

    Also visit my webpage delta 8 thc

  20. delta 8 thc
    delta 8 thc says:

    Greetings! I know this is somewhat off topic but I was wondering
    which blog platform are you using for this website?

    I’m getting tired of WordPress because I’ve had issues with
    hackers and I’m looking at options for another platform.
    I would be fantastic if you could point me in the direction of a good platform.

    Also visit my page :: delta 8 thc

  21. cbd products
    cbd products says:

    Its like you read my mind! You appear to know so much about this, like you wrote the book in it
    or something. I think that you could do with a few pics
    to drive the message home a little bit, but other than that, this is
    fantastic blog. A fantastic read. I’ll certainly be back.

    My web-site :: cbd products

  22. buy cbd
    buy cbd says:

    Thanks for your personal marvelous posting! I genuinely enjoyed reading it, you are a great author.

    I will be sure to bookmark your blog and may come back very soon. I want to encourage
    you continue your great job, have a nice evening!

    Also visit my web blog … buy cbd

  23. hb5 side effects
    hb5 side effects says:

    Open the next link to learn more about hormonal harmony hb5 weight loss supplement, you need to check out:
    hb5 side effects

    This video is about hormonal harmony hb5 weight loss supplement but also try to cover
    the following subject:
    -hormonal harmony hb5 reviews
    -hb5 hormonal harmony scam
    -hb5 hormonal harmony review

    So you want to know more about hormonal harmony hb5 weight loss supplement, I did too and here
    is the result.
    Hormonal harmony hb5 weight loss supplement interested me so I
    did some research and created this YouTube video
    .
    ~~~~~~~~~~~~~~~~~~~~~
    If you would like to learn more about hormonal harmony hb5 reviews I suggest you to take a look at our other video
    clips :
    ————–
    Now that you have actually viewed our vid regarding hormonal harmony hb5 weight loss supplement did it assisted?

    Please like the YouTube vid to help other people searching
    for hormonal harmony hb5 reviews or hb5 hormonal harmony scam :
    )

  24. cbd for sale
    cbd for sale says:

    I was curious if you ever thought of changing the layout of your website?
    Its very well written; I love what youve got to say. But maybe you could a
    little more in the way of content so people could connect with it better.

    Youve got an awful lot of text for only having one or two images.
    Maybe you could space it out better?

    Stop by my blog post cbd for sale

  25. tinyurl.com
    tinyurl.com says:

    Currently it sounds like BlogEngine is the top blogging platform out there right now.

    (from what I’ve read) Is that what you’re using on your blog?
    asmr 0mniartist

  26. best delta 8 thc carts
    best delta 8 thc carts says:

    I believe everything posted was actually very logical.
    But, think on this, suppose you wrote a catchier title?
    I mean, I don’t want to tell you how to run your website, however suppose you added a post title to
    possibly grab people’s attention? I mean Integrate FileMaker
    Pro and QuickBooks – FileMaker Developer is kinda vanilla.
    You should look at Yahoo’s home page and see how they create
    article headlines to get people to click. You
    might add a related video or a related pic or two to grab people
    interested about what you’ve got to say. Just
    my opinion, it could bring your posts a little livelier.

    Also visit my page :: best delta 8 thc carts

  27. delta 8 thc
    delta 8 thc says:

    Hmm is anyone else having problems with the
    images on this blog loading? I’m trying to determine if its a problem on my end
    or if it’s the blog. Any suggestions would be greatly appreciated.

    my web page :: delta 8 thc

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.