Foreign currency, VAT amount,Variables, PLD

[Former Member]

Hi guys,

We have SBO2007 version 46.

The system currency is GBP, and we have some purchase orders in EUR, where I am trying to show VAT amount in the right currency in the printouts.

There are two layouts on the system

1) Purchase Order (System) -- There isn't a VAT field above document total.

2) Purchase Order (DIN) (System) -- The VAT amount fields use system Variable 229 and 230, which I cannot copy/use in my own layout.

Error message: printing error: invalid variable number 229 etc.

I also found that variable 116 is for VAT in system currency-GBP and variable 112 is for VAT in BP currency-EUR.

Please anyone can help on the solution that the right VAT amount is displayed in right currency in one PLD.

Thank you very much

Regards,

Yang

[Former Member]

Thank you very much, Gorden and Premraj.

I will try the ideas.

In the meantime, I wonder that there must be a common practice to have VAT in foreign currency (and document total) shown on marketing documents.

How do you guys do it? It would be a pain to revise all types of documents. Is there some setting to change so that the system can deal with it automatically, or a variable becomes available?

NB I have set "all currencies" in the BP master.

Thank you

Yang

[Former Member]

Hi Y,

Actually it is not possible to fetch all variables that is in system PLD as the variables have run time calculated value, there is a default linking for that , as u have variable 116 is for VAT in system currency-GBP and variable 112 is for VAT in BP currency-EUR , so try to fetch those .

if still u are not able to fetch , mke udf 's and do necessary conversion of fileds and feth .

Rgds,

Premraj

Edited by: PremRaj kaushik on Mar 18, 2009 9:44 AM

[Former Member]

This can be solved by conditional formula in PLD. Check this thread to find out more:

Thanks,

Gordon