Solved

Act. Cost & Act. Sales... ?????

Forum|Forum|1 year ago
February 19, 2025
48 replies
133 views

On some reports I view, there seems to be a column for "Act. Cost", and in some transaction reports also a column for "Act. Sales ". At first I thought this was only on Detail Transaction reports but today I viewed a Bank report for Deposit Detail, and the Act. Cost column appears again. This doesn't make sense on a Deposit Report, but ...

I have searched through all the column options in the Display options for these reports and I don't see anything that looks like it would be for "Actual Cost" (I assume that is what the "Act." stands for.) Without knowing what is generating this on the report, I don't know how to delete it. I don't want to have to export every report I do to Excel so I can hide or delete this column. (The column so far is completely blank, no data appears.)

Can anyone tell me what display option is causing this to appear? If there is none, this has to be a fluke ... or undocumented feature coming to us directly from QB / Intuit. Any ideas how to get rid of this on reports?????? Help!!

Thanks in advance.

QuickBooks Enterprise Suite

Best answer by FishingForAnswers

@Deadwood Al Not seeing it on my end; could be a custom column someone added to your books.

Either way, you can remove columns from reports without knowing what it is tied to in the Columns listing.

You may notice a series of three vertical dots to the left and right of each column name.

Hover your mouse cursor over those three dots, then click and hold the left mouse button as if you were going to resize the column. Then, drag the cursor to the left until you have passed the next set of three vertical dots.

Release the left mouse button and the column will be removed from the report.

Reports only require that you have one column active, so you can remove basically as many columns as you need to in this way. Could even memorize the report if you don't want to have to do this every time.

FishingForAnswersAnswer

Level 4

@Deadwood Al Not seeing it on my end; could be a custom column someone added to your books.

Either way, you can remove columns from reports without knowing what it is tied to in the Columns listing.

You may notice a series of three vertical dots to the left and right of each column name.

Hover your mouse cursor over those three dots, then click and hold the left mouse button as if you were going to resize the column. Then, drag the cursor to the left until you have passed the next set of three vertical dots.

Release the left mouse button and the column will be removed from the report.

Reports only require that you have one column active, so you can remove basically as many columns as you need to in this way. Could even memorize the report if you don't want to have to do this every time.

G

gulfstar

Thanks! This is very helpful.

A

ARCH_B

We're experiencing the same issue as of yesterday 02/19/25. Not sure if connected but we had a QBs update we ran yesterday that wasn't as smooth as we've experienced in the past.

Now we have these "Act. Cost" and "Act. Sales Price" columns that are showing up on our memorized reports.

We typically have the two columns "Amount" and "Balance".

These are not checked any longer in the Modify Report options.

And I can't seem to understand where those two "Act..." column options are listed as an option to check.

Anyone have a solution? Or experiencing the same thing?

D

Deadwood AlAuthor

Well, we also did an update just recently, so I'm tempted to think the crack wizardry at QB / Intuit added at least one or two "undocumented features" into the update. I'm seeing these new columns showing up in a few reports, and they seem to have replaced a column for "Amount" that now is no longer appearing. I have also noticed that this Act. Cost column is showing up in both standard (provided) reports AND in memorized reports, so it appears that these crack wizards have developed near super-powers in wreaking havoc in report-land.

I believe it was user Fishing For Answers who told me that I could delete these unwanted columns by clicking on the three dots at the top-right of the unwanted column and while holding down the click while dragging the dots past the left side of that column you are telling the system to not display the column. That may help clean the report of the junk the wizards have given you, but you will have to re-add the data column you do want to show up there.

It would have been just peachy if the wizards had tested things before they sent it out to the world ... and I'm sure they would say "we did test it", to which my response would be "If you had experience out in the real world to know how actual real-world users actually use the system, your testing would be immensely better because you obviously don't know what to look for in your testing!"

J

JoyMas

It showed up on my memorized reports after I updated the required updates today. The amount of checks were no longer there and this extra column that I can't get rid of. This is crazy. Why did they mess up all my memorized reports? It is not in the options when I "Customize Reports" to remove this unnecessary column. Now I have to re-do all my memorized reports in order to get rid of this ridiculous, column that has nothing in it. If you are going to add something to our reports, at least let us be able to get rid of it. This is extremely frustrating. This is wasting my time to fix something we didn't ask for.

D

Deadwood AlAuthor

to JoyMas ....

There is a way to get rid of the columns (Act. Cost & Act. Sales Price) .... on the report display, at the top of the column where the column heading is, there are 3 vertical dots. Click & Hold on those 3 dots, and then drag them to the left just past the left edge of the column and the column will vanish from your report.

----- Don't thank me. FishingForAnswers is the one who gave that method to me, so he gets the credit.

However, you need to check reports very closely, because it appears that QB's crack design team has fubar'd many reports: standard reports and memorized reports. What I've seen so far is that many times when either or both of the "surprise columns from QuickBooks" (Act. Cost and/or Act. Sales Price") appear on a report, there is some column that used to be on the report that is no longer present, so just removing the one or two "surprise" columns won't fix the report. You need to examine the report to see if it still displays the data you expected to see. And I have yet to discern any consistency in what reports are infected with this "surprise" problem ... sometimes I have been missing a column that used to be in the report, sometimes it is just removing the "surprise" columns. Sometimes it is a memorized report, sometimes a standard report.

Not only are there "surprise" columns, sometimes it is a "surprise" as to which reports are infected.

Everyone who has responded to this in the past AND all that respond in the future should ALSO go to HELP, and under the "Submit Feedback Online", please submit a Bug Report to describe this problem. QB will not respond when only one or two people complain or submit ideas. But if enough of us do bombard them with Bug Reports and complaints, they just might be tempted to try to figure out how to undo their FUBAR.

AmericanRV

New Member

This started happening to my company file Tuesday (2/25/25). All of a sudden there are new ghost columns in my memorized reports and the ones I need were removed (so far I've seen columns added for "Debit" - not the standard one built into QB - "Cost", "Act. Cost", "Sales Price" & "Act. Sales Price". All of these are invisible to me as far as the column options go, and each column has no information in it. I'd like to note that a QB update was installed 5 days ago, but I didn't start using it until yesterday. We use QB Premier Plus desktop and are currently on version R13_46.

I am NOT HAPPY over this, it's playing havoc with my accounts and my productivity. Yesterday I had to file tax reports with the state and it was a nightmare. I have a set of reports I run each month and they make the reporting fast and fairly painless. But when I started to run them, all except one had been changed. As far as I can tell, QB removed the last 3 columns on my reports and replaced them with three of the above. It added a "Sales Price" and a "Debit" column in reports they have no relevance to. But it got even worse from there. I tried to add MY columns back in and I could add one, maybe two, but never the three QB had removed. That makes my data unusable because I'm not getting the figures I need. Worse, even if I did manage to get one of my columns added back in, on each report QB would always keep one of its own useless columns and allow me one of my own. Because of this issue, I spent a several hours gathering data so I could file a state tax report, which normally takes me half an hour, tops.

The suggestion for how to make the phantom columns "disappear" helped if I removed one column, but where QB had added more than one it didn't work. at all In fact, that seemed to make it worse. Not only did they NOT disappear, they multiplied. Submitting a "suggestion" form to QB is a joke of an answer.

Whatever that update did, it broke the program. This is happening to too many of us to be a fluke - it's a programming error at QuickBooks. Wouldn't it be better if Intuit actually fixed whatever they broke? I'm sure I'm not the only user who considers this an emergency situation that QuickBooks needs to address RIGHT NOW. This isn't acceptable, by any means.

AmericanRV

New Member

I just stumbled onto something, test it out and see if it works for any of you. It definitely does NOT fix the issue here but ...

I went into my Memorized Report List and right-clicked on a few of the changed ones - and MY reports came up!

A big hassle for sure, but until they manage to fix what they broke, this could work. 🙂

C

Cindylou57

I am having the exact same problem and under the filter option there is nothing to uncheck this option. Is this the problem from an update? The act cost and act sales price appears on all my memorized reports but never did before. (I also am assuming act means actual)

L

lsk70

I am having the same problem. I actually figured out the "click and drag the column" to delete it before reading these posts but as everyone has said, that is not an acceptable answer on how to fix this problem. We always feel like we have to install the update but maybe we shouldn't unless they tell us what changes are included in the update. I would have left it alone had I known!

D

Deadwood AlAuthor

The "click and drag" was not described as a "solution" to the problem ... it only removes the Act Cost or Act (whatever) columns from appearing on the report where you click & drag. It does NOT restore any columns that you originally had that had been deleted by the upgrade, nor do any other reports that were infected have those columns removed: you need to do this on each and every report you find that is wrong, and you have to re-add whatever columns you originally had in those reports.

As for QB to "tell us what changes are included in the update." Surely you don't think QB would tell us that "this update contains a serious flaw that will impact several random reports, both standard and memorized, by adding in columns that you won't find listed in the display options selections, and occasionally deleting columns that should be in the reports or that you may have added to memorized customized reports. Please be aware that this update will drastically mess up your reports and cause you to spend significant amounts of time trying to fix the issues cause by this update."

The problem is not just that they don't tell us in the same way that many other software companies do, the problem is that this update wasn't thoroughly tested before released. I'm willing to bet that there are some employees who are now former employees, and QB is trying to figure out how on earth to solve this massive FUBAR.

D

dawnaclark

This notification popped up this afternoon addressing the memorized reports issue:

https://quickbooks.intuit.com/learn-support/en-us/help-article/damaged-data/memorized-report-open-opens-different-report/L8tiT8fYd_US_en_US

J

JohnCastellana

Wow. Wow. Wow.

QuickBooks is just walking around in the dark. This affected many of my memorized reports and obviously has a significant impact on many people and they are just tossing our canned responses ; "...Verify and Rebuild."

D

Deadwood AlAuthor

First, QB did make available a patch update that supposedly included a "critical fix" for the report problem. The fix must be intended simply to replace the code that caused the false options (Act Cost and similar) from appearing and removing valid column selections. It would likely be worthwhile to install the update ... I did.

Secondly, and disappointingly, QB indicates in the narrative ("Fix memorized reports that open with unexpected results") that their solution to their FUBAR is to "recreate the memorized reports you need". Judges, lets give QB a failing grade on this one. Too bad they didn't come out with a method to replace the memorized report group with the report group from the save immediately prior to the update that corrupted the memorized reports. This might not have been perfect and it might have taken some time, but so does "recreate the memorized reports you need"!!!! Perhaps the grade should be an F-minus!

T

trdspec

All of my custom report went from Amount to Act.Cost as well.

As Act.Cost isn't an item you can uncheck under display, you have to drag it like your resizing all the way to the left to get rid of it.

Then add Amount back in and Memorize as a new report.

It's a real pain as I have to delete all the Memorized reports on my Icon Bar and add them back linking to the new reports.

As far as upgrades go this was a downgrade.

Next upgrade I won't be so quick to use after this disaster.

D

davolz

Same thing happened to me. Upgraded yesterday, and today my memorized and the standard General Ledger Reports no longer show the Amount or the Balance columns. Gee whiz, this is why I am paying $1,200 more for Quickbooks 2024 Pro version plus Enhanced Payroll? And the instructions as indicated above, left-hand mouse click, dragging to the left to remove the column does work, however, you also need to add in an extra column after the Amount or the Balance column, in order to see the column that you are trying to put back into the report. Hopefully Intuit will pay attention, but I am not hopeful, as mostly, all I have seen over the past 20 years of using Quickbooks, is a lower and lower level of service, year-on-year. If I did this to my clients I would be out of business. I've attached a (sanitized) pdf file so folks can see these two errant columns Act. Cost & Act. Sales.

C

cecxcx

Same thing happened to us. When will this be fix?

J

JaneDave_I

QuickBooks Team

You have to make sure you've updated to the latest release of your QuickBooks Desktop version, cecxcx. I'll share additional information regarding this concern.

Before we begin, it's important to check if you have the latest version of your QuickBooks Desktop to experience all the product improvements and fixed issues that are being addressed in the newer version.

To get the latest edition, you can follow the steps below:

Go to Help and select Update QuickBooks Desktop.
Select Update Now, then Get Updates.
Close and reopen QuickBooks to reinstall.

Moreover, we can also perform some basic troubleshooting steps by verifying and rebuilding your data in QBDT to determine whether a corrupted data system is causing the error you are encountering.

However, if the issue still persists, you can get in touch with our QuickBooks Support team to further investigate the issue you're encountering right now. They have advanced tools and can provide real-time assistance through screen-sharing.

Once resolved, you can also check this page if you wish to learn how to resolve file export Excel common errors in QBDT: Fix export to Excel issues in QuickBooks Desktop.

I've outlined the key steps for updating and troubleshooting QuickBooks Desktop. Please know that you can always revisit this thread if you have further questions with your memorized reports in QBDT. We're always here to help.

K

KSOldster

I tend to wait to install new updates, hoping that the bugs will be worked out by the time I install the new software. That practice didn't help this time, so it's just now affecting my work.

Some of my Memorized Reports were easy to adjust, but in most cases, the "Memorized" reports popped up with weird useless columns and even some margin arrows stuck within columns which effectively cover the data. I finally decided to just give up and start from scratch. I went back to the Reports tab, chose Report Center and found the default report that looks most like what I needed. Then I seemed able to add my own columns and change my titles and print my report. Only tried this on two reports so far, so keeping my fingers crossed that this will work across the board.

Bottom line: Kiss your Memorized Reports goodbye. I know it's a real pain here at end of quarter, when we're trying to file State and Fed reports. But we've gotta get the reporting done. Meanwhile, QB fouled up the Memorized Reports program and they're telling their support staff to blame the users. Sorry QB, but you guys messed this one up Royally.

Sign up

Login with SSO

Let's get you signed in

Login with SSO