How to copy a PLD in one database to another.

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[keith_taylor2]

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.

[Former Member]

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

Mohamed Zubair

[mario_schoenberg]

Hi all,

I am refering to above: "..or using the sql statement in SQL Server directly..."

Please do NOT USE any INSERT, UPDATE or DELETE query directly on SQL Server.

This kind of queries are manual manipulation of SAP Business One DB and will cause loosing support for the affected DB!

Kind regards

Mario Schoenberg

Senior Support Consultant

SAP Business One Forums Team

[Former Member]

Hi,

Noted,

I can copy over a PLD using Copy Express in as faster way

Regards,

Jyoti

[Former Member]

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

[former_member186095]

Hi,

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

Read this link:

Rgds,

[Former Member]

Hi Joyti,

Please check this thread:

Thanks,

Gordon