Multi Currency

[Former Member]

Dear Experts,

I have two questions:

1. I am creating PLD for a customer who does invoice on other currencies as well, on my total i am getting the converted local currency value. How do i go around this to get the right currency despite the change of currency on my total and VAT amount. Please help

2. How do i copy PLD accross two databases in SAP Business One 2005 A PL 11

regards,

Antony

[Former Member · Accepted solution]

2. How do i copy PLD accross two databases in SAP Business One 2005 A PL 11

Please follow these steps to copy PLD from one DB(Test DB) to another DB(Live DB)

1. Login to the Test DB and open the PLD. Click on menu 'Print Layout Designer' and select 'Display Hidden Fields'

2. Goto Edit Menu and select 'Select All'

3. Copy All the fields (select copy from Edit Menu)

4. Click on Administration and select Choose Company and login to the Live DB.

Note: Donot Logoff from the Test DB)

5. Open the PLD in Live DB. Click on menu 'Print Layout Designer' and select 'Display Hidden Fields'

6. Goto Edit Menu and select 'Select All'

7. Delete All the fields

8. Now Paste the fieds which you copied from 'Test DB'.

Note:

Ensure that the Document Properties like Width, Height, Top Margin, LeftMargin etc.., are same before pasting in 'Live DB'

You can also use an Addon called 'Copy Express'

[Former Member]

Hi Antony,

1. For this instead of the variables appearing on the screen, you can use some specific ones displaying the correct currency values always. Here are a few:

AP DOCUMENTS

Row Net Price / Unit 81

Row Price after Discount / Unit 80

Row Net Row Total 299

Footer Gross Document Total 108

Footer Net Document Total 109

AR DOCUMENTS

Row Net Price / Unit 81

Row Net Row Total 299

Footer Discount Amount 105

Footer Total VAT Amount 106

Footer Gross Document Total 108

Footer Net Document Total 109

Footer Applied Amount (Part Payment) 107

Footer Amount Due (Gross-Part Payment) 125

2. Either using Copy Express addon or open the PLD you want to copy, Edit -> Select All (hidden fields too) Edit -> Copy. Log in to the target company from the same instance of SBO, open a PLD for the same transaction, Edit -> Select All (hidden fields too), press Delete to remove all the fields, Edit -> Paste. Here the system asks if you want to use the same field numbers, choose yes so the formulas will work correctly.

Hope it helps.

Regards,

Nat

[Former Member]

thanx, it worked but while doing this using my purchase order i cant view the preview.

please assist

regards

Antony.