Changing an Item Cost after it has been sold

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Changing an Item Cost after it has been sold daser007 03-10-2007  RE: Changing an Item Cost after it has been sold Akber Alwan 03-10-2007  RE: Changing an Item Cost after it has been sold NcS 03-11-2007
Posted by daser007 on March 10, 2007, 12:10 am Please log in for more thread options Hello there, I am a new RMS user and thanks to this group I am starting to get good at using it. There's something I couldn't find and couldn't figure out... How can you change the cost of an item that has already been sold? I would like to be able to go thru the costs report at the end of the day and correct mistakes. Let's say I discover an item that cost me $4 but it shows a cost of $0 in the report because we failed to include a cost when creating the item. How can I have the report show the updated cost after I change it in the item detail so at the end I have an accurate profit margin figure at the end of the day. Any help is greatly appreciated. Thanks, David Posted by Akber Alwani on March 10, 2007, 5:19 am Please log in for more thread options Dear David, first of all you can't do so as it is already said and reocmmended that you must setup your system before you start performing the transaction. BUT you can do this by going back -end query and update the data manually. but this is not recommended but somehow possible let me know if you need me to write that script out. "daser007@gmail.com" wrote: > Hello there, > > I am a new RMS user and thanks to this group I am starting to get good > at using it. > > There's something I couldn't find and couldn't figure out... How can > you change the cost of an item that has already been sold? > > I would like to be able to go thru the costs report at the end of the > day and correct mistakes. Let's say I discover an item that cost me $4 > but it shows a cost of $0 in the report because we failed to include > a cost when creating the item. > > How can I have the report show the updated cost after I change it in > the item detail so at the end I have an accurate profit margin figure > at the end of the day. > > Any help is greatly appreciated. > > Thanks, > > David > > Posted by NcS on March 11, 2007, 9:17 am Please log in for more thread options 1) Return Item at old(bad) cost. 2) Change item cost to new(good) cost. 3) Sell Item. Note: net sale is zero and cogs is adjusted. Also depending on deep you want change to occur the return/sale might need same customer/cashire/salesrep etc. maybe the 'pain' of correcting will prevent future occurances. Don't you check total received amt with Supplier Invoice? Good luck! "Akber Alwani" wrote: > Dear David, first of all you can't do so as it is already said and > reocmmended that you must setup your system before you start performing the > transaction. BUT you can do this by going back -end query and update the data > manually. but this is not recommended but somehow possible let me know if you > need me to write that script out. > "daser007@gmail.com" wrote: > > > Hello there, > > > > I am a new RMS user and thanks to this group I am starting to get good > > at using it. > > > > There's something I couldn't find and couldn't figure out... How can > > you change the cost of an item that has already been sold? > > > > I would like to be able to go thru the costs report at the end of the > > day and correct mistakes. Let's say I discover an item that cost me $4 > > but it shows a cost of $0 in the report because we failed to include > > a cost when creating the item. > > > > How can I have the report show the updated cost after I change it in > > the item detail so at the end I have an accurate profit margin figure > > at the end of the day. > > > > Any help is greatly appreciated. > > > > Thanks, > > > > David > > > > Similar Threads Posted incorrect cost price put in and item was sold August 23, 2007, 4:25 pm On POS (not RMS) Instructions for Changing Noninventory Item Price, Cost, and Volume June 3, 2008, 4:42 pm On POS (not RMS) Instructions for Changing Noniventory Item, Price, Cost, and Volume July 18, 2008, 4:33 pm On POS (not RMS) Instructions for Changing Noninventory Item, Price, Cost, and Volume July 20, 2008, 8:46 pm On POS (not RMS) Instructions for Changing Noninventory Item, Price, Cost and Volume August 25, 2008, 2:18 pm On POS (not RMS) Instructions for Changing Noninventory Item, Price, Cost, and Volume September 2, 2008, 3:31 pm SQL Script to set item cost to highest cost for that item on any PO September 25, 2007, 11:08 am Automatically update price levels when changing cost March 3, 2006, 11:46 am copy item cost to supplier cost field November 1, 2006, 1:37 pm How can i update item cost based on Supplier cost and MPQ. August 13, 2008, 3:23 pm