incorrect cost price put in and item was sold

Aug 23, 2007 2 Replies

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,



You need to update the TransactionEntry table ..

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

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.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required