POS transfer error: unprocessed transactions at End Of Day

  • 2
  • Question
  • Updated 5 years ago
  • Answered

After transferring the product list and performing End of day on the POS terminal, when trying to POST on the POS administrator computer we get the following error:


I cant seem to figure out what this "unprocessed transaction" is? We have done end of day successfully and transferred the product list, so I'm not sure what is wrong.

When we then try and post it works but un-ticks the transfer customer balances option.

The reckon user manual does not provide an answer.

Please, help!

Thanks!

Kylie.

Photo of Kimberly Agars

Kimberly Agars

  • 120 Points 100 badge 2x thumb

Posted 5 years ago

  • 2
Photo of Kevin Silberberg

Kevin Silberberg, Accredited Partner

  • 2,170 Points 2k badge 2x thumb
I have received this error message before. The cause seemed to relate to one or more unprocessed end-of-day files. Each and every end-of-day file must be uploaded to Reckon Accounts. This is the function, "Post Transactions to Accounts" as specified in the last paragraph of the error message.
Photo of Kimberly Agars

Kimberly Agars

  • 120 Points 100 badge 2x thumb

Hi Kevin, thanks for getting back to us so promptly.

Do you know where I might find this unprocessed end of day file?

We post our end of day files on a daily basis. When we are posting there is only 1 end of day transaction file ever found. And that is the one we post.

We only have one terminal with POS on it, and one other computer with the POS admin on it.

Thanks,

Kylie

Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,976 Points 50k badge 2x thumb
Are you sure you don't have transactions on hold? 
Photo of Kimberly Agars

Kimberly Agars

  • 120 Points 100 badge 2x thumb

Hi Kevin,

Do you mean a sales transaction on hold in POS? I was under the understanding that sales transactions could only be held for one day, and it wont let you do end of day if there is something on hold.

Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 52,976 Points 50k badge 2x thumb
Indeed Kim that's correct. So you aren't trying to do an intra day transfer then? 
Photo of Kimberly Agars

Kimberly Agars

  • 120 Points 100 badge 2x thumb

Hi Kevin,

Not sure what a intra day transfer is so not sure if were doing it or not.

We have transferred from administrator to pos to try and get customer balances etc across during the day before but other than that we only transfer for end of day.

Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Hi Kimberly,

You can only transfer quantities when there are no transactions active on the POS terminals and all the EOD files are posted. Otherwises the balances are out.

So..... Stop doing transactions on the POS terminals, then run a EOD on EACH POS terminal you have, then in the POS Admin, POST the EOD files into Quickbooks,

NOW you can do a transfer and transfer the balances. You don't need to transfer the balances every day, as the POS terminals keep track of the stock. You only really need to do this when you 'add' more stock.
Photo of Kimberly Agars

Kimberly Agars

  • 120 Points 100 badge 2x thumb

Hi Andrew, thanks for the advice.

We only did the transfer in the middle of the day once, only because of the initial problem - when posting the error comes up and POS doesn't transfer the quantities or more importantly, the customer balances.

We really need to find out what this "unprocessed transaction" is on POS and stop this error occurring when we post.  We have so many customers coming in to pay off lay-bys and we have to go onto reckon to check the amount because the customer account balances on POS are not correct.

I'm hoping someone has seen the above error message before and might know how to fix this?

Cheers,


Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Did you try the above? You can only transfer customer balances and quantities on hand from quickbooks to POS, when there are NO active transactions on the POS terminals (ie a end of day has been ran) and all the end of day (EOD) files have been posted into quickbooks.
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,704 Points 10k badge 2x thumb
Hi Kimberly

Here are some things that you can check.
  • ensure that you do a Z Report  - "Reset the Sales Information (Z Report)" after the print reports screen in the end-of-day process.
  • Once you have hit the "Finish" button on the end of day, immediately "File > Exit" to shut down POS then post and transfer.  A common mistake is to do an end of day, then do a "No Sale" to open the cash drawer. 
If this does not cure the problem, go into POS Administrator and press the Delete Button on the icon bar.



This brings up the Delete a Terminal screen.  Even though this is a one till setup, at some stage a second till has been created.
If you have this situation, the name of your current till will be printing on all dockets.  Do a backup from POS administrator, then select the inactive till and delete it..

Hopefully this should cure your problem.  Please post your results.


Graham Boast
Reckon Accredited Consultant
graham@reckonhelp.com.au
www.reckonhelp.com.au/remotesupport.htm
Photo of Ashley Cooper

Ashley Cooper

  • 248 Points 100 badge 2x thumb
This reply was created from a merged topic originally titled When I perform a transfer at EOD, I get 'can't transfer quantities on-hand for e....

When I perform a transfer at EOD on the POS terminal 1, I get a message 'cannot transfer quantities on-hand for existing products' then a message that errors were encountered later on in the process. It still seems to transfer the information but I am concerned that prices etc. may not be transferring properly. It doesn't happen on terminal 2 or on the backup laptop. Any ideas how to fix this? I have looked for incomplete transactions, there is nothing held otherwise I wouldn't be able to do the EOD.

When I close the til at EOD, the process I follow is:
EOD on POS > Restore company on POS Admin > Post on POS Admin> Transfer on POS Admin

Am I doing this right? TIA
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hey Ashley, give these suggestions a try and let me know how you go! ^Mirko
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
The restore company step is a bit worrying, why are you doing this Ashley?
Photo of Ashley Cooper

Ashley Cooper

  • 248 Points 100 badge 2x thumb
Thanks Mirko and Andrew,

The steps above haven't resolved the issue. Andrew, I have been doing this as it was the way I was told to do the EOD but it's my first experience with Reckon and so I'm not sure what the correct way would be? The lady who showed me what to do has left the company, and I think she did the EOD through trial and error. We have price changes daily so backup the POS tills from a file of a main computer at the end of each day.

Is there a different way I should be doing it?
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
Hi Ashley,

What version of Quickpos are you using?

A backup is a bit different to a restore. Which are you doing?

If you are changing prices daily, then the process would be as follows

You can adjust the prices before you start this process in reckon Accounts so they are ready for the transfer.

- Run a End of Day (EOD) on POS machine., doing a Z Report as you are going. Once you click the finish button, don't do anything else on the POS system. No "No Sale", no nothing.
- Open up the POS Admin and do POST and post the EOD files into Reckon Accounts
- Adjust prices etc if you haven't already done them.
- Then do a Transfer and transfer the products over etc.
- Done, you can now start to use the POS machines again.
Photo of Ashley Cooper

Ashley Cooper

  • 248 Points 100 badge 2x thumb
Hi Andrew,

We use Quickpos 2013 (16.0.8). I wasn't clear in my explanation of the process I follow at the EOD, sorry, but am doing what you have said which makes me feel better!

I still get the error message though that the terminal has unprocessed transactions then goes on to say that there were errors during the transfer. I am unable to print out the report. Any further ideas?

Thanks for your help with this
Photo of Andrew

Andrew

  • 22,222 Points 20k badge 2x thumb
"unprocessed transactions" means someone has done something on the POS clients. You are doing the reset during the EOD and you're not doing a no sale etc to open the cash draw? Also check that you don't have any 'stale' terminals in the POS admin as pointed out above in this thread.

The unprocessed transactions isn't a issue, its a warning that until everything is 'settled' the transfer amounts could be out etc. ie you have 10 widgets for sale in reckon accounts and transfer this value to the front, but you haven't posted the EOD that had a sale of 4 widgets. Meaning the real stock on hand is 6.

You could also run a EOD on each, then go file exit the POS client. Then from the POS admin, do a database repair. Then post the files, then do a transfer. THEN finally open the POS clients up again.

When you say report, what report are you referring to?
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,704 Points 10k badge 2x thumb
Hi Ashley

Andrew's process for the end of day is correct, and if you are doing that and still have an error message, then I suspect that your end of day file is aborting on processing.

To find out for sure, open the QBImport.log file located in the C:\Users\Public\Documents\Intuit\QuickBooks\ImportErrors folder and scroll down to the last lines of the file.  Here is a successful transfer I have done but I suspect your log will point to an error .



If the file is aborting during processing, then it needs to be fixed.  Steps are:
  • move the transaction file (QBPst - xxxxxx - 001.pos) to another location (the location of the import file is shown on the 2nd line of the log
  • open the file in excel to examine it (DONT save when closing) - you can print it out and just enter the transactions into Reckon.  The transactions take a little understanding to read but they are readable.  Each transaction starts with a TRNS line and finished with an ENDTRNS
  • If there are too many transactions to manually rekey, you will need to send me the file for fixing.  If it is a simple error, and they usually are, I will charge you $80 to fix it and reimport. 
  • Often, files that abort will partially process, and you may have multiple occurrences of the same transaction in your Reckon file (one for each attempt to post).  The duplicates will need to be removed from the file.  (As an aside, my favourite story about this is a client who posted 99 transactions 22 times - yes 2079 duplicate transactions to delete.  He ended up restoring an old backup then paying his bookkeeper for another 2 days to reprocess the end of quarter stuff she had already done.)
Let me know how you go


Graham Boast 0409317366
Reckon Accredited Consultant
graham@reckonhelp.com.au
http://reckonhelp.com.au/remotesupport.htm
Photo of Leanne

Leanne

  • 180 Points 100 badge 2x thumb
Hi Graeme, I have a situation whereby the EOD report is SOMETIMES not printing. I have located where all these data files are going to and can restore them, however am unsure how I go about getting them to reprint - is there a method that is used?

This conversation is no longer open for comments or replies.