Change item cost on closed invoice

When intial items were entered in an quantities updated using transfer inventory in, the cost of 1 item was entered incorrectly $18,400 and should have been $18.40. Detail sales report and cost of goods is now way off. Tried issuing a return, return is done at new cost or doubles cost on return. Tried Void, but cost still shows up on reports. Item was sold on 3 separate invoices on 1st day and batch closed before realizing cost of goods was off $50K. Any suggestions?

Reply to
SG
Loading thread data ...

Did you try allowing edit of closed purchase orders

go to store operation manager program and open the configuration go to "options >> purchase order options >> Allow edit of closed purchase orders" mark this option

Reply to
Mahmoud Amin

That updates the cost but the item cost on the original transactions from the closed batch still show $18,340.

Reply to
SG

Also when I run a detailed sales report and add the cost and transaciton column sorted by the transaction column with everything collapsed. The cost amount from the returns trying to offset the original sale is add to total cost rather than deducting the return cost. Using version 2.0.0110. Is there a hotfix or other update that addresses this. I have read about grouping but everything for this item is qty 1 on the invoice and returns. The sales amount zeros out but the cost amount doubles.

Reply to
SG

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.