incorrect cost price put in and item was sold

i have a customer that had an item that was supposed to be $450.00 and they put it in at 45,000.00 for the cost. they sold the item and now thier reports are comming up 45,000.00 short. how can i go back in and change the cost for that sale to the correct price, so the reports come out correct??

thanks,

Reply to
Jeremy Olson
Loading thread data ...

You need to update the TransactionEntry table ..

I have the release 1.3xx .. and the cost it's only in TransactionEntry table..

cod

Reply to
cod

That is not accurate. It needs to be corrected in other places also. For example, the BATCH table will need the CostOfGoodsSold field to be updated. There are others also. I don't recommend making this change in the database.

Reply to
Jason

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.