Skip to Content
avatar image
Former Member

How to copy a PLD in one database to another.

Hi,

How can we copy a PLD in one database to the other without using Copy Express.

I tried openin up the PLD in the Test DB and copying it over to the Live DB, using Edit copy and Paste, but it doesn't work....

Is there any other way it can be done?

Regards,

Jyoti

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 05, 2008 at 06:28 AM

    Hi jyoti,

    you can copy PLD from one database to another from following method.

    1st you open PLD & click blank area, then open document property window, you can find there a document Id.

    then open SQl

    write query :- "select * from Ritm where doccode = 'doc.id'

    Select * from Rdoc where doccode = 'doc id'

    then copy all rows in, then paste in excel sheet,

    & then you open database where you want copy PLD.

    then open Ritm, & Rdoc table & paste all rows respectively.

    Rdoc(only 1 row)

    ritm (many rows)

    Pls paste Carefully

    Its working 100% .

    I also use it.

    Thanks

    Payal.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Payal,

      I tried your query.....but not successful.

      My aim is to copy only one PLD to another Database.

      I opened the Source Database from SAP B1 and noted the Doc ID to be "RDR20007".

      I would like to copy the above PLD to another DB.So i opened the RDOC Table of my target DB and tried to paste it.But not successful.

      Am i going wrong in any step.Pls help.

      Deepak

  • avatar image
    Former Member
    Sep 04, 2008 at 03:37 AM

    Hi Joyti,

    Please check this thread:

    how-to-copy-pld-from-system

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 04:02 AM

    Hi,

    It won't work using the steps you described. I suggest to use copy express.

    Read this link:

    Copy Express distorting data

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 04:58 AM

    hi,

    you can copy print layout design using add-on Copy Express available with in SAP B1 add-on package.

    or using the sql statement in SQL Server directly

    QUERY FOR Copying PLD From one DB to another DB

    INSERT INTO [TARGET].[DBO].[RDOC]

    SELECT [SOURCE].[DBO].[RDOC].* FROM [SOURCE].[DBO].[RDOC]

    WHERE [SOURCE].[DBO].[RDOC].DOCCODE = 'CHO*****'

    INSERT INTO [TARGET].[DBO].[RITM]

    SELECT [SOURCE].[DBO].[RITM].*

    FROM [SOURCE].[DBO].[RITM]

    WHERE [SOURCE].[DBO].[RITM].DOCCODE = 'CHO*****' AND [SOURCE].[DBO].[RITM].DOCCODE

    IN (SELECT DOCCODE FROM [TARGET].[DBO].[RDOC])

    Replace the TARGET field by Target DB name and SOURCE field by Base DB name

    DOCCODE is taken from Target DBu2019s PLDu2019s Document Properties.

    -


    SELECT DOCCODE FROM [SBODemo_India].[DBO].[RDOC] where docname = 'NEW_AP'

    -


    If you know SQL Queries...it is very easy to transfer PLD from one DB to DB by using the above query

    or else if you donot kow sql then you can go for Copy express add-on, it is very much simple using that.

    hope this will solve your problem

    regards

    sandip

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:01 AM

    Try to use copy express, we did with query some times the database gets corrupted so try to use copy express

    Mohamed Zubair

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 03:58 PM

    Copy express is a solution for this. Another option is the Boyum IT add on for Business One which allows you to export 1 or all PLD as well as a bunch of other enhancements for Business One.

    Add comment
    10|10000 characters needed characters exceeded