1. Home
  2. Point-Of-Sale Software
  3. purchase order table Inquiry 'HELP'

purchase order table Inquiry 'HELP'

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
Reply to
Trinidave
Loading thread data ...

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.

Reply to
Ryan

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.