We created a new subaccount to have sales orders split out into a new bucket for additional analysis. Everything is flowing correctly going forward, but I would like to go back and reclass existing transactions (sales and materials) to get to the proper subaccount for historical comparison. I can get to the sales numbers by running the sales order report and filtering to what is needed. The part I am struggling with is how do I get to the materials cost to complete my bulk reclass entry? I am not finding a way the 2 are connected by a reference number or some way I can get the data into a spreadsheet to identify the entry needed. I would love if anyone has an idea of how I can make this happen!
Best answer by srengdahl
View original