purchase order table Inquiry 'HELP'

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

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

Subject Author Date purchase order table Inquiry 'HELP' Trinidave 10-29-2009  Re: purchase order table Inquiry 'HELP' Ryan 10-30-2009
Posted by Trinidave on October 29, 2009, 2:04 pm Please log in for more thread options Hello here is my problem. I did some dummy transaction on the database that I entered my Purchase orders (PO) in, After entering all of my PO's I then when to Administrator- database-delete transaction, thinking as the prompt says that it would delete all of my sales transaction. This was done so I would start my business with a transaction free database. but the end result has now become a nightmare, that deleted all of my PO's. Does anyone has any ideas on how to retrieve the lost PO's. I have a back up of the PO's how do I go about getting those PO's back to the database. tried to bulk insert using sql, the PO's come up but the entries are not in order, NB>sql table purchaseorder and purchaseorderentry >thanks Posted by Ryan on October 30, 2009, 10:28 am Please log in for more thread options Trinidave, Yes Delete Transaction will remove anything that is linked to sales, ie Transaction, TransactionEntry, Journal, PurchaseOrder, PurchaseOrderEntry, Order, OrderEntry, TenderEntry and there are a number of others as well. At least you have a backup, which means you can get back to where you need to be. Possibly the easiest way to do things would be to turn on identity insert for PurchaseOrder and PurchaseOrderEntry on the "Clean" database. You should then be able to run a script that well select from the backup database and inert into the "Clean" database. Just make sure you turn IdentityInsert back off on the "Clean" database when you are done. -- Thank you, Ryan Sakry Program Manager Retail Information Technology Enterprises 320-230-2288 rsakry@rite.us http://www.rite.us > Hello here is my problem. I did some dummy transaction on the database > that I > entered my Purchase orders (PO) in, After entering all of my PO's I then > when > to Administrator- database-delete transaction, thinking as the prompt says > that it would delete all of my sales transaction. This was done so I would > start my business with a transaction free database. but the end result has > now become a nightmare, that deleted all of my PO's. Does anyone has any > ideas on how to retrieve the lost PO's. I have a back up of the PO's how > do I > go about getting those PO's back to the database. tried to bulk insert > using > sql, the PO's come up but the entries are not in order, > > NB>sql table purchaseorder and purchaseorderentry > >>thanks Similar Threads Posted Associate a purchase order with a work order or back order June 9, 2006, 3:18 pm Customer Properties:Purchase History should be Purchase/Order Hist July 18, 2006, 1:18 pm Error when trying to Create Purchase Order based on re-order information April 9, 2008, 3:56 pm Add Quantity On Order field to Purchase Order screen in RMS August 23, 2005, 7:28 am Purchase Order based on Re-Order Level not working March 21, 2006, 8:15 pm Is there a way to convert a work order to a purchase order in RMS? September 22, 2005, 8:49 am Purchase Order deleted - Item on Order ? May 3, 2006, 6:56 pm Purchase Order to Transfer Inventroy Out Order June 1, 2009, 10:47 am Work order to Purchase order October 4, 2005, 9:26 am PURCHASE ORDER PACK VS ORDER QTY July 9, 2007, 7:44 pm