incorrect cost price put in and item was sold


J

Jeremy Olson

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,
 
Ad

Advertisements

C

cod

Jeremy said:
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??
You need to update the TransactionEntry table ..

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

cod
 
Ad

Advertisements

J

Jason

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top