Solved

Quickbook integration questio

Posted on 2011-09-26
2
360 Views
Last Modified: 2012-05-12
We have a Fishbowl / Quickbook integration question.  We are putting it out to all that may have a lead on tracking down the answer.  Thank you in advance for any effort to resolution.
 
When a Sales Order is generated in Fishbowl and Payment is received in Fishbowl it is exported to Quickbooks as a Sales Receipt.  If the Sales Order was for $100 it shows up as a balance due under the account AND as an open balance on a Sales Receipt under the itemized listing of All Sales Transactions for same account.  When the deposit is made the $100 is cleared under the account, HOWEVER, it remains OPEN as a Sales Receipt and under Payments it does not show up as received.
 
Question: can we A) export everything to QB as an invoice, this appears to process payment in a cleaner fashion B) if not, how can we show payment received on the Sales Receipt.
 
Please let us know if there are any questions or comments.
 
Thanks again for any and all input.
0
Comment
Question by:Axis52401
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 94

Accepted Solution

by:
John Hurst earned 500 total points
ID: 36602458
A Sales Reciept is instead of an Invoice. They do not work together. A Sales Receipt is issued when Payment has been received for a cash or small value type of sale. So no matching takes place. See the Sales Receipt below and at the bottom, the bank deposit - all in the same document.

 QB-Sales-Receipt
So if Sales Receipt is correct, Fishbowl needs to correct the flow so that the money goes into the bank as part of the same transaction.

If you want an invoice (sale and later payment) then again Fishbowl needs to send an invoice over, not a sales receipt.

The two things do not go together.  ... Thinkpads_User
0
 
LVL 94

Expert Comment

by:John Hurst
ID: 36710539
Thank you. I was pleased to help you, and good luck going forward with your integration. ... Thinkpads_User
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question