End of Day Transfer

[zendary]

Hi All, My first post,

I have Quickbooks, QuickPOS Terminal, QuickPOS Admin 2004.

I am trying to do and E.O.D. I can do the first past from Terminal, then I shut it down, (as always), then I can POST from Admin, all with no problems. As soon as I try to TRANSFER, it freezes. At first it seemd to be doing something, but then nothing. If I click with mouse in the TRANSFER box, I get a message saying to "swith to", which I have tried to no avail.

The weird thing is that I can TRANSFER everything except the "Customer Balances". As soon as I try to TRANSFER them, the pc freezes. I have no problems with anything else.

All the programs are stored on a pc running WinXP, 1gb memory, and P4 2ghz. I am using single user mode. The pc runs fine. My company file is huge, 1gb, and in nealry 4 years I have never done anything to.

Any ideas, or solutions will be so appreciated as I am very stuck and need to get this done.

Thanks for the help in advance....Cheers.

[zendary]

I must admit I thought someone else may have had the same problem and would have an answer by now.

I have been through every forum I can find with no luck. I have been in touch with Quicken, @ $4.90 a minute for help to no avail. I cannot believe a world wide company cannot offer any answers!!

After reading many forums, trying updates/patches and a few other things I am at a complete loss to understand how this can be. It also seems that it is not a very happy Quicken community out there. I was surprised, almost shocked at some of the things people were saying.

Maybe I will try to back up and head over to MYOB. Any thoughts anyone?

Hopefully someone will answer my distress and the world will be at peace again. Thanks once again.

[Joey]

I'd love to try to help you but I cannot imagine what kind of "balances" you're trying to Transfer from the POS system into QuickBooks??

[zendary]

May have been wording things wrong.

At the end of day from QuickPOS terminal, all info goes over to QuickPOS admin. In QuickPOS admin I do a "POST", then "TRANSFER". All the info whilst doing the transfer goes through, except "customer balances".

Hope this helps clarify. Please feel free to contact me if anyone thinks they can help.

Cheers!!

[gibbo]

The Quicken POS in Australia is one that was developed here four or five years ago. It uses (still) an IIF based import/export between QuickBooks and the POS. They actually developed an sdk that can export transactions as well as lists as an IIF file. This allows the POS to automate the import of list information from QuickBooks and the sales information back into QuickBooks.
It uses the QuickBooks data file as the Inventory management database and imports every single transaction (or a summary transaction containing every item sold for the day).
It has been sold on the basis of being a great way to integrate POS with Quickbooks - which in my opinion it is not! QuickBooks simply does not have a satisfactory inventory management system.
The issues being raised have to do with the importing into the POS database of the exported IIF files. The Balances are simply the debtor balance for each Customer. It is the only way that the POS knows what Customers owe as it does not maintain this itself - it simply exports the day's transactions and then clears the database.
I have not been involved with QuickPOS for several years and am now a little rusty, and this is not an issue I have run across before, so I am at a loss to offer any real solution. paying Reckon $4.90 a minute to solve this was always going to be a waste of time. They can assist with simple issues, but they are not really in a position to work through complex ones.
My thoughts are that the problem has not always existed - so the question to ask is what changed to cause it. We have used the same tools to develop applications, so I have an understanding of the process and what is being done.
Can you think back to when this first occurred and what was done to the PC around that time? Also look at the Customer list and see if there is anything out of the ordinary in the information in the list. The cause has to either be in the data being extracted from QuickBooks, or in the ability of the dll to extract the data.

[zendary]

Hi John,

thanks for your reply. Makes understanding this a little better. I have tried to think if anything has changed and nothing comes to mind. It just seems like one day it was working, and the next not.

I have had a look at the file size, 1.5gb, and have never stop/started the company file in over 4 years. Maybe I should do this. I am not sure how to go about this but after reading some forums, I made a backup of the company file, tried to do a condense, but the data never verifys, hence it will not allow me to do this.

If you or anyone knows how I can stop my company as of now, start a new one without losing all my info it would be appreciated.

I am still at a bit of a loss to find out why I can't transfer my customer balances, so things are getting critical now as i need to finalise things.

John, do you know if I can import/export the info to POS via the iif files as you were talking about.

Cheers for your help too. I really appreciate it!!

[zendary]

Hi all,

well, I did an E.O.D today and everything worked!! I have not done anything different. Now I am at a real loss to understand why!!

I think I will end the company file and start afresh. So for anyone who has advice on how to stop the company file as of today, and start a new one tomorrow, I would appreciate your help.

I have tried to condense to no avail. Everytime I try to verify, it says there are errors. Even after a rebuild it never allows me to do the condense. Therefore if anyone can offer a better or another way I would be greatful.

Cheers........

[gibbo]

The version of QuickBooks we have in Australia does not have the latest database that is now in the US version and we have found there have been serious issues with data corruption when used with QuickPOS. It is simply not designed to handle the volume of transactions being thrown at it, and the IIF format of import allows 'illegal' transactions to be imported, which is not good.
If you cannot correct your errors, I would suggest you definitely consider starting a new file on July first. The underlying database was not designed for 1.5 gigs of data - we have seen problems with QuickPOS from 400 megs. Continuing to use your current file is simply not safe!

[zendary]

Thanks for your reply Gibbo.

I think I always try to be a positive person regarding these matters, but I must admit that this has left a bad taste. I am happy that ever program has a few bugs and glitches, but after reading through these forums there seems to be a lot of problems and I think Quickbooks should be taking notice.

Maybe some of the things that are definitely caused by end user error, however, Quicken should take the time to address these. If I had a global company and read what problems were being disussed in these forums, I would take steps to rectify the issues. After all, no customers, no sales!!

I think I will be ending my copany file. At the moment I have downloaded copies of MYOB Premier and MYOB Retail Manager and am trying to transfer all my data over. If everything works, even at a cost of $2500 to change, that's where I am headed.

If there are any Quicken people reading my dilema, please reply and persuade me otherwise.

On a positive note, I am not bitter or wanting to rant and rave, just thought this would have been a bit easier, even though I fully understand the complexitites of the program.

Cheers for all the help, and don't get mad, visual the problem and try to solve it.

Cheers all.

[gibbo]

We are also working extensively with MYOB and while I have gained respect for it as an accounting programme, the underlying database is not really designed for large data file size either. Both QuickBooks and MYOB do have versions that they claim are for "enterprise" companies - but the fact is that neither really can claim that.
By the way, Retail manager is based on an Access database, which while adequate for normal use, is certainly not a database heavyweight - and their integration to MYOB is terrible.
By the way, we are working with accounting integration into Pubs, Supermarkets, Service Stations and about to go into Newsagents. We recommend that users leave the detail in the Point of sale and transfer summary information only into the accounting program. This then means that the accounting can be done in either QuickBooks or MYOB without any worries, as the transactions coming across are minimised. We are working with a number of large POS developers, offering accounting integration to their customers through our programme. At the end of the day they simply declare the money and banking, the POS reconciles sales with the money and exports the info as a summary. Our programme then picks it up and with one button press puts it (with stock purchases as bills) into the accounting programme.