Find and Recode - Find by Item Code
Add an option to find all transactions by Item Code
Example: I recently had a client who put the wrong sales accounts on some of their inventory items but had been making sales transactions for 14 months without noticing. The P&L did not accurately reflect the sales of the actual inventory categories because of this.
There is currently no ability to find all the transactions by inventory item code to quickly recode the original transactions.
The work around is painful for 1000's of sales - Run a report on transactions by item code, save to excel, add a column for the new sales category and then build manual journals based on Date, Old Sales Category, New Sales Category to correct the sales during the period (in our case by month).
Sam Bonney
shared this idea
-
Justin Smart
commented
I agree. I don't understand why the Item Code field is not an option in the Find & Recode functionality. Manually correcting an Item Coding error on a bunch of paid invoices is painful & time consuming.
Seems like it would be any easy fix to include the Item Code field in the Find & Recode functionality. -
Renae Farrimond
commented
This feature would be great as I currently have to update a lot of transactions to include "item codes"
-
Robyn Moller
commented
This would save me hours of work - an inventory item has been set up incorrectly and now I have to manually find all the transactions to recode
-
Tom Brookes
commented
Hi,
This would be hugely helpful for our reporting. Currently our inventory items are imported from Linnworks but items sold import to Xero as new items. We need to find our sales invoices by item SKU and recode used items sold to used sales.