Topic: How to correct wrong sales account for an item - completed transaction
I just discovered that a sales item was set up using the wrong sales account. There are now about 30 completed transactions (sales invoice - payment received and applied) with this item posting to the wrong sales account.
What is the best way to fix this?
I have already corrected the wrong sales account in the item.
I could make a bunch of journal entries to correct them, but I think that would still leave the errors in any sales reports, etc.
Can I directly edit the 0_gl_trans table to correct the posted account #? Are there other tables that would have to be manually corrected? Is this a can of worms?