on 08-11-2014 9:34 AM
Hi All,
Is there a way I can export the transaction documents such as PO , SO , Inventory Transfer , Production Order and Good Receipt Po from one database to another database? Only the transactions not the database itself.
The situation is we need to rollback the current database to yesterday but we want to keep the transactions for today and import it back once the changes has been done.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not an easy job to transfer all those transactions from one db to another. It might be easier to do it manually.
First, you may run a query as:
SELECT * from JDT1 T0
JOIN OJDT T1 ON T1.TransID=T0.TransID
WHERE DateDiff(dd,T0.CreateDate,Getdate())=0
All those financial related documents should be found first. Then you can deal with Sales Order, PO ets.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI David..
You can use Quick Copy in the following scenarios:
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check with the Link
SAP Business One ...To Go - 10. Data Transfer Workbench - Business One - SCN Wiki
Regards
Kennedy
Hi,
Please refer SAP file for Quick copy which meets your purpose.
http://help.sap.com/saphelp_sbo900/helpdata/EN/45/ffa2efa23004aae10000000a114a6b/content.htm
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.