Search the Community

Both good points. Even in a situation where the site is cached for logged out users, the TTL would be set to a low value, likely to an hour or less, so they would still see almost all of the most recent content. Then, after that period of time, the cache expires and the next hit generates a fresh copy. It would go a long way to dealing with all of the bot activity that the site sees. Every hit from one of those bots is processed like any other, which generates multiple database queries. Serving them a static file would be tremendously more efficient. In any case, I'll know more once the move is complete, and I've had time to work on the server/software configuration for a little while. There's a reasonable chance we'll be able to get away without the caching layer at all.

Hello all, We've had some (very few, but more than zero) issues where database tables have crashed during times of heavy load on the server. These load spikes are usually related to other sites that I'm responsible for that happen to share resources with the ATX Community. These haven't been significant issues, and in fact have been very easy to resolve when they arise, but it does cause brief downtime on the Forum. So, in the interest of constant improvement, I would like to move the ATX Community to its own server (VPS) with its own dedicated resources. There are other server configuration changes/challenges that I'll tackle at the same time. Because this is the only forum I maintain, I am less experienced with performance tuning for this software than, say, more standard website content management systems. All that to say, I am expecting it to be a slightly bumpy transition but with improved speed and stability in the long term. There might be as much as one or two days of downtime followed by intermittent hiccups until everything is smoothed out. I'm aiming for mid-May to get this work done, but there is no hurry on my end. If there are business reasons to put it off longer, please speak up! Thanks!

@Abby Normal Any chance you can give me a primer on how to stop and start the database? In my defense, it has been 3 years. Tom Longview, TX

Oddly, I can't find the ATX Database Repair batch files for 2022 or 2023. In the past you could edit the batch file for the most recent year, and change the year in the script, but I'm left wondering if ATX has another database repair method now.

Tom, I did an advanced search on this forum for "database" specifically posted by Joe. See if any of these helps: https://www.atxcommunity.com/search/?&q=database&quick=1&author=Abby Normal&search_and_or=or&sortby=relevancy The link is safe to click. It will take you only to the search results within this site.

I use Backblaze. It's fast, works well and it's reasonably priced. But I've heard that a database like ATX might be unusable when using an online backup because of the way both databases and online backups work. Some online service have a separate database backup option.

ATX has had memory leaks ever since the program was rewritten with a shareware database called "Raven" back in 2011, sometimes referred to as the "2012 Debacle".

I use LibreOffice and have for over 10 years, used to use OpenOffice but when they announced it would no longer be updated I made the switch. They are both open source programs and based upon an old Sun Microsystem program. I just use the Writer and Calc programs which open Word and Excel files but it has a database and other programs included. Years ago on an MS Office upgrade they wouldn't allow you to open certain file types - LibreOffice would do it so I made the switch. Also, Libre will open .numbers files I believe in case a client is using Apple. LibreOffice does everything I want except customized labels on pie-charts. I like to be able to manually move the label and it use a line to direct to the wedge - Libre doesn't allow that. I find it FAR superior to Google Sheets but my wife uses Sheets and says it's better than it used to be.

Are you looking online, or do you have the actual document? Around here, a lot of the older records (and yes, in many towns 1999 counts as "older" for records) the online database transactions are recorded with dates and names but no prices.

IRS can do the matching after the return is filed (assuming they have the manpower to do so). But going back to Sara, how are WE supposed to know when we are preparing the return? Will our software be pre-loaded to disallow the e-filing because they have the same database as the IRS? Maybe so, but that's asking a lot of the tax software.

We really need an IRS site to look up the Name Control in their computers. It's stupid that they make us guess what they have. I had several trusts I couldn't efile for name control rejection for years, and finally the IRS fixed the name in their computers and we were finally able to efile. I kept putting the reason for paper filing as the IRS has an error in the name control database, and I guess someone finally took a look and fixed it.

This Corp was established last year. LLC filing as a C Corp. Got a letter from the IRS about 2 months ago that the return electronically filed last year could not be processed because the 8832 was not included with initial return. Had the client re-submit the 8832. Trying to file the 7004 for 2022 and I get this error that I think is related to the 8832 not being processed yet by the service. F7004-904-01Federal Extension Form 7004, the tax year ending date ('TaxPeriodEndDt' specified in the Return Header) must match the data in the e-file database unless one of the checkboxes in Line 5b - "Initial Return", "Final Return" or "Consolidated return to be filed" is checked. Is there some way to fix this? Client needs to make a 10K estimate payment. Can I have them mail in the 7004 with a check and hope it all works out by the time I file the return? Thanks Tom Longview, TX

New client with a duplex. He has done his own taxes for years (first mistake) and doesn't think he ever took depreciation on the rental portion of the building. He made extensive renovations to the rental property in 2022 and those will be depreciated properly. The proper thing to do, maybe I think, is to file Form 3115 and claim the missed depreciation for the rental all in 2022. The issue of how to do that now gets tricky. The town does not have any useful information on the online assessor's database about split between land value and building value. The client may have a bill from the last year or so showing the current land/bldg value split. But he bought the property in the mid-70's, and there is no way to know if that % value split is roughly the same or wildly different. And all of this for a whopping $45,000 purchase price back in the 70's, for a duplex. Opinions? Figure half-and-half land/bldg value on the half of the duplex? That would mean a one-time correction of $11,250 for depreciation plus something trackable for the future instead of papers from a half-century ago gone for good. Or just ignore the whole thing under the heading of not inadvertently double-dipping on depreciation expense?

Don't hold your breath. The company overhauled the entire program using the Raven database in 2013 for the 2012 tax year, so the company has had 10 years to fix this.

No, 2011 was the last year ATX was a compiled spreadsheet. The 2012 ATX Program was rewritten using a poorly selected shareware database called "Raven".

If clicking on Browse doesn't show your database, you'll need to reinstall or run the database repair batch file. Does ATX even have the 2022 batch file up yet?

When I got a red error preventing me from efiling a database provider, ATX tech help just told me that IRS had changed its biz codes. 519100 still shows up online as a valid code but ATX wouldn't accept it; 999000 fixed that -- but, oy, it just doesn't smell right.

After all these years they must still be using the "Raven" shareware database. By now one would think the program would have been rewritten with something more robust and stable?

I forgot to add, that you run the Admin Console program on each computer to locate the new database on the server.

Yes. ATX is a database and the server must have the ATX software installed to make the database available to other users (AFAIK). And the other users will might need to point to the new database if the location is not identical.

Lawyer elected a calendar year on the SS-4 for a Decedent's Estate 1041 rather than a fiscal year. Knowledgebase has the following info: e-file Rejection: F7004-904-01 - "Form 7004, the tax year ending date ("TaxPeriodEndDate" specified in..." in an 1120, 1120S or 1041 return. Full Rejection Text "Form 7004, the tax year ending date ("TaxPeriodEndDate" specified in the "ReturnHeader") must match the data in the e-file database unless one of the checkboxes in Line 5b - "Initial Return", "Final Return" or "Consolidated return to be filed" is checked." Resolution This can occur when your client is filing as a calendar-year filer, but the IRS has their Employer Identification Number (EIN) on-file as a fiscal year filer, or vice versa. Check your input to confirm that the fiscal year end date is correct. If it is, contact the IRS at 1-866-860-4259. Confirm the fiscal year date they have on record matches what you have on file. The fiscal year is correct for the decedent, the SS-4 incorrectly shows a calendar year. Should line 5b Initial return be checked as that is for a short year in order to e-file the extension and if so will any other complications arise when the return is finally submitted or is there another way to correct this issue?

Yes, just scroll down a full screen (in ATX). Under Conversions From Traditional, SEP, or SIMPLE.... 2 lines more has a checkbox to Check box if qualified charitable distribution (QCD) and enter qualified charitable distribution amount. Over the years I am constantly finding how many screens have so much more to see if one just scrolls up or down. For such a relatively inexpensive program (despite some faults and less than stellar support), I really think ATX has so many features, more than I know how to manage even after 26 years with it. It pays to just browse around sometimes, something I'm trying to instill in the office admin at church with the membership database.

Still taxable. Papers means nothing... you must report your gains and pay taxes on them if any. Remember that I don't know where my bank has the database of my transactions by block chain is open to anyone who wants to see my transactions and any profits I made. So the fact that the IRS has said to the crypto exchanges that they don't have to report to the IRS, it doesn't mean that we don't have to report gains and it doesn't mean that the records are not available to everyone.

I noticed a lot of changes, many due to increased security protocols. Medlin (on the general forum) mentioned something about database structure for Drake, too.

Does AICPA keep a public database? Does the IRS keep a public PTIN database?