Sales Receipts putting items in the wrong account.

tlh121018 · ‎January 04, 2019

I created Sales Receipts with product/service that were previously mapped to Sales. I've changed the product/service item to map to Commission Income but the previously created Sales Receipts are still showing up in Sales instead of Commission Income even after I edit them and re-enter the item. If I create a brand new Receipts, it maps correctly. I do not want to have to go back and delete then re-enter all the Sales Receipts. Is there an easy fix for this?

MarshallA · ‎January 04, 2019

Hello,

Yes you can fix this easily. First, go to the item and change the item mapping back to Sales. Save and close the item. Now go back and edit it again and change it to Commission but BEFORE you save it, make sure to check the box that says Also update this account in historical transactions. Save and close the item screen. Now it should show correctly on all historical transactions.

View solution in original post

MarshallA · ‎January 04, 2019

Hello,

Yes you can fix this easily. First, go to the item and change the item mapping back to Sales. Save and close the item. Now go back and edit it again and change it to Commission but BEFORE you save it, make sure to check the box that says Also update this account in historical transactions. Save and close the item screen. Now it should show correctly on all historical transactions.

tlh121018 · ‎January 05, 2019

Thank you, MJA66-87! That fixed it.

MarshallA · ‎January 05, 2019

Most welcome. :-)

anonymous1234 · ‎February 26, 2020

I have the same issue, but when I am editing the product and services for the item I want to map to a new account, I don't see the box to check for "Also update this account in historical transactions."

Is this feature no longer available in quickbooks online? Please advise.

Thank you!

MirriamM · ‎February 26, 2020

Welcome to the thread, anonymous1234.

When editing Products and Services items, the "Also update this account in historical transactions" function is only for non-inventory and service items.

On the other hand, if you're trying to edit mapping for Inventory items, then you won't be able to see this option. Since these items are considered to track on different income accounts.

To learn more about Products and Services items, check these helpful articles:

If there's anything else I can do for you concerning QuickBooks, get back to me by commenting below. I'm always around to help. Enjoy the rest of your day.

Topics

Training

Community

Resources

Sales Receipts putting items in the wrong account.