If when creating your A\R Receipt if the user happens to hit the ` key when they tab through the Check/Receipt No field and replace the system generated value of 000004431-00022 to ' and then post it.
The Receipt will post fine in A\R and appear as part of the deposit batch in Bank Rec but you cannot mark the entry as reconciled. Every time you hit the reconciled tick it gives you a message "The record has been modified by another program".
At this point Bank Rec is dead. Getting everybody out of Accpac, Restarting the Server or SQL don't make the problem go away, and Data Integrity - well that passes fine.
You need to go to the BKTRAND table find the relevant line and look at the field IDRMIT. This will have a value of ` in it instead of a normal reference number. Once you replace this with a normal number in SQL the system will let you clear the bank rec as normal.
I assume this is because it is recognising the `as a special character and between Accpac and SQL it's having a melt down.
Sage ERP 300 2012 PU3 - SQL Server 2012 R2
Lets see how long it takes them to fix this one..........
by: Kerry J. | over a year ago | Financial Management
Comments
Hi Kerry,
I suggest resolving this through support channels. That is, through Sage support directly. May need a hotfix.
PS - this idea was posted 28 Aug 2014
We have reported this to our solution provider to push through Sage as yes it is a bug in the system as you should not be able to make the system implode by doing this.
Don't hold your breath or ou will be really blue in the face before Saggy fixes anything
Oh and for the record this is on28/08/2014 as Saggy hides behind not having dates on this site
Hi Ian & William
I know a lot more about Accpac than the average end user and well understand what you are talking about. I was a consultant for 12 years.
Early on I used to put a lot of stuff into this forum and one of my posts actually made it into the product! I can't remember if it took 4 or 5 years. This was for something that was essentially only UI and report changes. Maybe a weeks worth of effort in total. This was heralded as a major new enhancement to the product.
There are that many things to fix they probably don't know where to start. They have also clearly in recent times ever used the product or talked to anybody who has tried to. In so many areas it's so mind numbingly difficult and frustrating to use you really can't put it into words.
Most of the development that has happened in the last 5 years has been of no use to your core user.
We want functionality and ease of use before some web service or cloud based rubbish.
Yes upgrades have become faster, easier and more seamless.
That's because there is basically nothing in them.
5.5 was really the last time any great amount of functionality was pushed in. Since then its been rewrites of bank rev and serialized inventory. Both of these still have holes you can drive a bus through and bank is still terrible in features and performance.
I could write all night but I'll stop here.
28-8-2014
Thank you Kerry
I notice Saggy is silent (as usual)
If Walmart ran their company like this how many customers would it retain?
How long does it take to get a report to work correctly?
How long does it take to get an error fixed
How long does it take to do anyhting?
In Saggy time "more than a year"
Ian Anderson
01/09/2014
Oh and I have not been an consultant but been an accpac user since 1996. Yes the old DOS version single currency days :) or should that be :( ?????