Items attached to a large number of transactions cant be processed

Hi there, @adeniying.

Welcome to the community page. I'm here to provide you with information about why you're seeing an error while processing a transaction in QuickBooks Online (QBO).

Currently, there's an investigation happening into this error, and our engineers are now working on it. I also recommend contacting our QBO live support so they can add you to the affected list of users. This way, you'll also receive updates about the investigation.

Here's how:

1. Head to this link: Contact Us.
2. Select QuickBooks Online product and click Continue.
3. Select Contact Us and choose a way to connect with us:

• Start a chat with a support expert.
• Get a callback from the next available expert.

Additionally, you can also consider checking out our free invoice templates in QuickBooks Online. You can use this to personalize your invoice templates to your customers.

You're always welcome to reply here in this thread if you have additional concerns about invoices in QuickBooks Online. I'd be glad to assist you.

We are experiencing the same issue since July 5th, 2024. The support suggested two workaround methods, unfortunately, both of them cannot work for us. Do you have a timeline on when this is going to be fixed?

Hello, @CF_Quan. I'll provide some information about the status of the investigation. 

The case is still ongoing at the moment. The next status update is scheduled for July 12, 2024. If you'd like to included in the list of affected users and receive updates on the resolution, I'd suggest contacting our Customer Care Support team. Here's how:

1. Log in to your QuickBooks Online (QBO) account.
2. Click the Help (?) icon and select Contact Us.
3. Type in your concern
4. Choose a way to connect with us:

• Start a chat with an expert.
• Get a callback from the next available support.

To help you manage your reports efficiently inside QBO, check out this guide: Run reports in QuickBooks Online.

Please let us know if you have other QBO related concerns. Our team is always here to help. Have a good one.

Hello ShangY,

Thanks for the reply, and I'm in the list of affected users.

Today is the 12th and I haven't received any updates.

Hi, our customer has been facing this issue since July 8, 2024, and we still have not received a resolution. It has now been a week, and we urgently need this issue resolved.

I see the importance of resolving this issue promptly, as this is already causing interruptions with your business flow, @cecxcx. However, the best action we can take is to contact our support team.

Rest assured that our product engineer is fully aware of the situation and is working actively to resolve it as quickly as possible. In the meantime, I encourage you to reach out to our customer care team. They can add you to the list of affected users, ensuring you'll be notified via email once a solution is in place. To contact them, here's how:

1. Log in to your QuickBooks Online (QBO) account.
2. Click Help (?).
3. Please choose how you want to connect with us.

Please know that our support hours for Simple Start, Essentials, and Plus users are from Monday to Friday, 6 AM to 6 PM PT, and Saturday, 6 AM to 3 PM PT. For our Advanced users, they can contact us any time, any day.

See this article for reference: QuickBooks Online Support.

Additionally, you can check this article to learn more about processing customer-based payments in QBO: Record invoice payments in QuickBooks Online.

I appreciate your patience as we're working on a fix for this issue. If you have other questions or clarifications, feel free to post them in the comments below. I'll make sure to help you out anytime.

Hi,

This issue is now creating a huge backlog as we are unable to capture new or edit transactions related to the following functions:

1. Invoice

2. Sales Receipt

3. Bill

4. Cheque

Please let us know the current status.

Best regards.

Hello, dperez01.galaxi. Thanks for chiming in on the thread. We recognize how the transaction issue has impacted your workflow, and I'm here to ensure you get the urgent help you need.

Our engineers are actively investigating the issue (INV-107756) and working to resolve it. To stay up-to-date, I recommend contacting our support team to be added to the list of affected users. You'll then be notified by email once the fix is available.

Here's how to reach them:

1. Log in to QuickBooks Online.
2. Click on the Help (?) button and select the Search tab.
3. Choose a way to connect with us.

Our support hours are as follows:

• Plus, Essentials, Simple Start: Monday to Friday, 6 AM to 6 PM PT, and Saturday, 6 AM to 3 PM PT.
• Advanced: 24/7.

In the meantime, you can add another product or service item and then create a new transaction with it.

If you need more guidance on tracking bills and recording payments, check out this article: Enter and manage bills and bill payments in QuickBooks Online.

We're committed to providing you with a seamless transaction experience. Should you require any further assistance, please don't hesitate to reply to this thread. It will be our pleasure to assist you in any way we can. We wish you all the best.

Hello @jeanbiverly_ 

1. Our ERP provider helped us created a new item, so we are able to post new Invoices to QuickBooks Online.

2. Though, at the same time, like dperez01.galaxi@ described, existing transactions, which are attached to the existing affected product/service item, are not able to be edited AT ALL.

3. We can't wait from one Friday after another Friday, just to wait for the same answer!

4. Where's your CEO who just fired 10% of your staff, and where's the AI he promised?

5. He should come and fix this himself.

Hello,

I just received the e-mail from your engineer team and it's very concerning, see below:

    "We are working to make improvements in our backend so that this does not continue to occur in the                future, but for now this item will not be usable. Please create a new item to replace the original item and

      use that new item going forward. 
     

      There will be no further updates to this investigation, thank you."

Our ERP system uses a single item as a place holder to process all transactions that are inventory related. This particular product/service item bears no value and its quantity changes ONLY when an invoice or credit memo is processed.

1. The quantity decreases when an invoice is processed and increases when an credit memo is processed. 2. The quantity is not changed when a goods receipt is process.

3. The quantity is not changed when a vendor credit is process.

4. The quantity is not changed when an Inventory Adjustment is process.

5. Therefore, the quantity of this place holder product will be negative, since we invoice more than we credit.

6. Apparently, this error is not letting me to do Inventory adjustment to this product/service item, and this negative quantity is preventing me from closing the book for the fiscal year, which ends on 07/31/24.

7. Our ERP system provider helped us created a new item code, so that new transactions would be recorded, but for me to close the book, the quantity of the original item code must be equal or greater than 0.

Looking to hearing back from you, soon!

Best Regards,

Quan

Hello there, CF. We'll share details to help you get through this and create an inventory adjustment so you can proceed to close your books inside QuickBooks Online (QBO).

Before anything else, we'd like to ask if you performed some basic browser troubleshooting. If not, we recommend doing so to ensure the browser is free from temporary internet files that can affect the program's behavior and to help you create an inventory adjustment to close your books inside QBO. You'll want to access your company file using an incognito or private browser. You can use these shortcut keys:

• Chrome: Ctrl+Shift+N
• Firefox: Ctrl+Shift+P
• Safari: Command+Shift+N

Once you're in, perform the inventory adjustment. If it works and you can save the changes and closing books, proceed to clear your browser's cache. Refer to this article for the steps: Clear cache and cookies to fix issues when using QuickBooks Online.

If the issue persists, we recommend contacting our Customer Care Team for further investigation. Please see this page for more details: QuickBooks Online Support.

On the other hand, here's an article to help you manage inventory items and prevent low item quantities in the future when using the program: Set up low stock alerts in QuickBooks Online.

The Community team is always ready to assist with handling inventory items or closing books inside QuickBooks. Feel free to visit us anytime so we can get back to you as soon as possible.

Hello @Kurt_M 

If you read through the conversation, you'll see that I'm unable to adjust the quantity of the product is due to the error: Items attached to a large number of transactions cant be processed. It's not thing to do with my cache and cookies. I've called your support team and so far they can't do anything about it.

I need to adjust the quantity of the product to close the book, because QBO doesn't allow me to close the book when any product/services has a negative quantity.

When is this going to be improved on your back end?

Thanks

Hello there, CF_Quan.

The reason this error is displaying is that there are one or more items on the sales form that are tied to a very large number of transactions. The error message you're seeing has determined that the program is working as designed.

I understand that you have already created a new item, but it's the only workaround we can take or duplicate existing items and then create transactions with them.

We are working to make improvements in our backend so that this does not continue to occur in the future. For now, I'd recommend sending feedback to our product development team. We want to let you know that we value and appreciate all feedback and suggestions related to our products.

Here's how:

1. Go to the Gear or Settings icon and select Feedback.
2. Enter your comments or product suggestions.
3. Click Next to submit feedback.

Our Product Development team will receive your feedback directly to enhance your overall experience with the QBO. The dedicated platform enables our developers to prioritize requested features and improvements based on customer input. You can track all suggestions submitted through this channel: QuickBooks Online Feature Requests.

I'll be adding these articles that will guide you in personalizing your sales forms and using the new layout for your transaction:

• Customize invoices, estimates, and sales receipts in QuickBooks Online
• See what’s new with estimates and invoices in QuickBooks Online

If you have additional questions, feel free to come back here. I'll be willing to lend a hand. Keep safe.

Hello @JoesemM ,

You are still not getting my point. We created a new item so that new transactions will push through. But, for me to close the book, I need to adjust the quantity on the original product. By duplicating existing item or creating a new item will not solve the problem. I need to mark the quantity for the original product as 0 tomorrow so I can close the book.

Thanks.

I am having the same exact issue as this. 

@JoesemM @Kurt_M @jeanbiverly_ 

RE: INV-107756/ case# 15121389829

When are you going to fix the error where all transactions are locked if an item is attached to a large number of transactions? I mean, it makes sense that there's a limit, but I should have the ability to reverse the last transaction that triggers the error.

Suppose the limit is 10 transactions per item, and anything beyond that is considered a large number of transactions. I should at least have the option to edit the 10th transaction, or I should not have been given permission to commit the 10th transaction at all.

Now, I can't close my books because the prerequisite for closing the books for the accounting year is to not have any items with a negative quantity.

I've sent multiple feedbacks. Nothing came back or had been improved yet.

@JoesemM @Kurt_M 

Hi,

It's been 4 months. Any update? I can't close my book and I need to.

Same with me. Quickbooks support and dev team is incompetent. They are telling me there is no fix for this. Considering moving to A2X. Everyone should consider that as well. An accounting software that has this level of problems is not something you can rely on

I can see that you're looking to resolve the issue for a locked transactions especially when items are linked to a large number of transactions to successfully close your books, dlaspisa1. I'm here to help you address this, CF_Quan, dlaspisa1 so we can work together to find a solution.

To prevent this issue from recurring, consider creating invoices in smaller amounts or breaking them down into individual items to avoid issues and complications.

In the meantime, since QuickBooks Online (QBO) currently lack prompts indicating the limitations of transaction creation, I suggest sending feedback to our product team to highlight how this feature could benefit your business. To do so, follow the steps outlined below:

1. Go to the Gear icon, then Feedback.
2. Enter your comments or product suggestions. Then select Next to submit feedback.

If you've been submitting request for the same feature you'd like to see, you can easily track updates on feature requests through the QuickBooks Online Feature Requests website. Additionally, you can also cast your vote for the feature that matter most to your from the platform.

Once everything is up and running smoothly, you can learn how to efficiently track your inventory by generating and customizing inventory reports to obtain the most relevant data for your needs. I've added this article for reference: Customize Reports in QuickBooks Online.

Please get back to us if you have any other questions about inventory or adjusting products in QuickBooks We're always here to help.

@MariaSoledadG 

Hi Maria,

We are really talking about different things. No transaction that's related to the item is unable to be processed at all, and you are telling me to create Invoices to bring back the balance??????

It's time to consider other options.

@dlaspisa1 

I inactivated the problematic item since I won't use that item code again and all I need to do is bring its quantity back to >= 0 and close my book. By inactivating the item, I can close my book now.

I don't know how complex your issues are.

Just want to share BR