tomdchi Posted December 20, 2008 Author Share Posted December 20, 2008 Here is the latest list of known issues. Database Issues: There is a problem with how WHMCS deletes transactions that does not work well with QuickBooks. When an invoice is deleted in WHMCS the item on that invoice and any transactions for that invoice are not deleted automatically from tblinvoiceitems and tblaccounts. This will pose a problem for any accounting program because if there are transactions or products assigned to an invoice then there should be an invoice to tie them together. If you have any of entries in the database that correspond to an invoice that does not exist then they will have to be deleted. Transactions can be deleted within WHMCS but products that were line items on a deleted invoice must be deleted manually from tblinvoiceitems. Items with No Products Version 1.0 of Rapid ACH QBWC has an issue with items in tblinvoiceitems that are not associated with a product. This can be late fees or any manually entered invoice line item. There is a temporary fix in place for now that requires adding items into the QB item list. When QBWC encounters an item in tblinvoiceitems it will attempt to assign it a product number in the WHMCS-MISC-# format. If this item is not already in the item list then errors will be produced. Included in the .zip file is misc.iif. Upload this file to QB before you start QBWC. Go to File->Utilities->Import->IIF Files to import. This will import WHMCS-MISC-1 through WHMCS-MISC-81 into your item list. When QBWC downloads and finds an item with no product then it will be assigned one of these numbers. If you need more than what is included in the file then simply edit the file and add more. Just change the number at the end of WHMCS-MISC-#. This issue will be fixed in the next release. Invoice Numbers-Fixed, Your invoice numbers will be downloaded and assigned to the proper invoice. This only applies to invoice numbers, not paid invoice numbers. Tax In the misc.iif file there is the item “Tax”. This is the item that QBWC will look for when applying tax to an invoice. After upload of misc.iff go to the items list and edit this item with your tax agencies information. At this time only the item “Tax” can be used with taxes. This will be fixed in the future to match whatever is being used in WHMCS. Tax must be enabled in QB for taxes to function properly. Note-you must have the item Tax in your item list even if you do not collect taxes. Invoice Modification & Deletion Limitation You can modify anything on an invoice after it has been downloaded into QB and QBWC will record the modification. If you want to delete items from an invoice then you must delete them manually from QB. Invoice deletions are not automatic. The same goes for invoices line items themselves. If an invoice needs to be deleted and it has already been downloaded into QB then it must be deleted from QB manually. First QBWC Download- Memory errors may occur if the initial download of transactions is very large. If possible disable php memory limits for the first download. Batch processing will be included soon to solve this. Also, check the error.log to make sure that json is not being loaded twice. If it is you’re your php.ini needs to have it commented out. Check the Zend section and put a ; at the beginning of any line that has json in it. There is a bug in the program with respect to domain registrations You may get an error when downloading invoices that have a registration on it. Error detail is recorded in quickbooks db, quickbooks_gueue, status column with a "e". This error will look like: There is an invalid reference to QuickBooks Item "WHMCS-D-854-R-D" in the Invoice line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.', '2008-12-18 22:43:15', '2008-12-19 01:41:59'); The problem has been identified and is being fixed now. The vast majority of errors will be caused by your database having records that are not uniform. If you have any invoices that were deleted in the past and did not also at that time delete the items that were contained in that invoice AND any transactions that were on that invoice then you will get errors. There are two files in the zip that you can run to remove any invoice or payment records that do not have a invoice (back up db first!) It has been reported that html in the product descriptions will cause errors. There is no fix for this at this time except the removal of the html code. Invoices imported from other software into WHMCS may cause problems if they do not have the same database records. i.e, invoice line items in tblinvoiceitems, payments in tblaccounts. QuickBooks validation requires that if a invoice has a payment then it must have invoice line items to go with the payment. QuickBooks has a max of 41 characters for the client name. If it is more than that then you will get errors. 0 Quote Link to comment Share on other sites More sharing options...
merlinpa1969 Posted December 20, 2008 Share Posted December 20, 2008 these are the errors we ran into in order 1.duplicate names ( offered a solution hoping to see if it works ) 2. Html in product descriptions ( this will cause an error that QB cant read it ) 3. Usernames with non standard characters 4 Username company or address to long the above are issues with quickbooks itself 5. old orders that we imported from other billing system ( we had to create a generic item name and change the line items in the existng invoices ) 6. cancelled invoices that have 00-00-00 due dates 7 the domain reg issue ( outlined above ) the first download is a learning experience ( will not have nearly the issues if you have always used whmcs ) 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted December 20, 2008 Share Posted December 20, 2008 Goodness - I'll have to give this another shot in the morning. Too much to digest tonight. Thank you. 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted December 20, 2008 Share Posted December 20, 2008 The best way to view your error is to look into the quickbooks db in the quickbooks_queue table status column, status code “e” and the ident will show which client record it is having trouble with. QuickBooks has a max of 41 characters for the client name. If it is more than that or you have any special characters then you will get errors. Client entries must be valid. While WHMCS will let you enter whatever you like for the email and phone number fields, QuickBooks will not. Unfortunately, that doesn't give me any more info than the Connector is. There are several rows that have an e for a status, so I've got no idea which record is killing the update. All I know is that it keeps failing with the error quoted above. 0 Quote Link to comment Share on other sites More sharing options...
merlinpa1969 Posted December 20, 2008 Share Posted December 20, 2008 close QB close web connect and start it again its like my wife purrs like a kitten if you get it right but just one little slip and the #$tch comes out 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted December 20, 2008 Share Posted December 20, 2008 Love the analogy, but unfortunately, still giving me the XML error. 0 Quote Link to comment Share on other sites More sharing options...
merlinpa1969 Posted December 20, 2008 Share Posted December 20, 2008 Ok I had that problem lastnight, I just had to restart them both,..... Im importing over 15000 lines first time so I am expecting a few snags have it down to 23 errors, still trying to sort them out 0 Quote Link to comment Share on other sites More sharing options...
DIYWebHosting Posted December 20, 2008 Share Posted December 20, 2008 Will your QuickBooks import script play nice with WHMCS' new multiple tax level feature (for Canadian taxes)? 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted December 24, 2008 Author Share Posted December 24, 2008 Will your QuickBooks import script play nice with WHMCS' new multiple tax level feature (for Canadian taxes)? Currently I don't think it will work with the available version as it looks for either "Tax" or "Non". A new release will be available in the next couple of weeks that should support it. 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted January 6, 2009 Share Posted January 6, 2009 Any new releases of this yet? 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted January 8, 2009 Author Share Posted January 8, 2009 Any new releases of this yet? There will be soon. A fix is in place for the duplicate client name issue. It will append the client name with the client id when it downloads to quickbooks. Also in testing now is a fix for the domain registration bug. So far it seems to work fine. 0 Quote Link to comment Share on other sites More sharing options...
merlinpa1969 Posted January 8, 2009 Share Posted January 8, 2009 the only other issue we have seen is that sometimes a payment causes an error and there is no way of knowing what invoice the error was for 0 Quote Link to comment Share on other sites More sharing options...
merlinpa1969 Posted January 8, 2009 Share Posted January 8, 2009 the naming issue has been tested and works properly, waiting to see if the domain name issue is fixed 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted January 21, 2009 Author Share Posted January 21, 2009 New version is available. Now a full Admin Addon Module! A release version is expected in the next day or so. 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted January 21, 2009 Share Posted January 21, 2009 And how exactly are we supposed to download this new version? I ordered it from your site in the hopes that it will fix some of the errors I'm having with the old version, but I don't have anywhere to actually download it. 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted January 21, 2009 Author Share Posted January 21, 2009 Its under "My Products and Services" in the client area. The template included with the licensing addon is a bit confusing when it comes to downloading a product. I need to see if I can simplify it. Make sure you read the updated docs too. There is new info on errors. Tom 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted January 21, 2009 Share Posted January 21, 2009 There is nowhere to actually download the product, though, after clicking the link. I see two entries there from my prior signups at your website, but I can't actually download the files for either of them after clicking the icon. The "Download:" line is just blank. 0 Quote Link to comment Share on other sites More sharing options...
tomdchi Posted January 21, 2009 Author Share Posted January 21, 2009 Didn't we have this same proble before? I don't know what is wrong but when I login as client the download is there. I will send it to you in a suppor ticket. 0 Quote Link to comment Share on other sites More sharing options...
kcackler Posted January 21, 2009 Share Posted January 21, 2009 I think we did - Now when I log in, it's available...Before it wasn't (I don't use WHMCS as a download system, so maybe this is the way it's supposed to operate?) 0 Quote Link to comment Share on other sites More sharing options...
ctaborda Posted March 3, 2009 Share Posted March 3, 2009 I'm interested in this product, I would buy the owned version. I'd like to test it out first, but I can't a manual or anything. A pdf or guide available? Edit: I found it. 0 Quote Link to comment Share on other sites More sharing options...
medblue Posted March 10, 2009 Share Posted March 10, 2009 What is the status of this? Is this Addon ready to be used? Is it still only available as a trial? 0 Quote Link to comment Share on other sites More sharing options...
Seb Posted March 16, 2009 Share Posted March 16, 2009 The order option seems to have disappeared from the rapidach website as well? 0 Quote Link to comment Share on other sites More sharing options...
medblue Posted March 16, 2009 Share Posted March 16, 2009 Yes, very disappointing. I'm still very interested in this Addon. Hopefully there will be an update. 0 Quote Link to comment Share on other sites More sharing options...
wsa Posted March 24, 2009 Share Posted March 24, 2009 when i click on it this what I got /whmcs.php Error, Not found. rapidach.com 72.88.172.211 0 Quote Link to comment Share on other sites More sharing options...
openmind Posted March 25, 2009 Share Posted March 25, 2009 You know after chatting with my accountant, I've found a simple way to enter invoices into QB. I've been adding invoices on a per customer basis and then selecting the products sold etc. Now he has pointed out that credit crontrol is already built into WHMCS for chasing late payers so what's the point in breaking down to customer level? So I now have three customers, World, EU and UK and enter the invoice in bulk. I have a script that tells me the total sales for the above customer groups for each product line in my system which is what I use to enter sales. Instead of entering 500+ invoices per month, I now enter about 15 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.