Query Error plz help

[Former Member]

Hi Frds,

I am running a bfod Query .I am getting the result

For example my Kf is Dr/Cr

the output shud be 1.41 usd

but it is coming as 1.41 error

[Former Member]

Hi,

Go to RSD1 and check the unit which is assigned to the corresponding Dr or Cr keyfig.

[edwin_harpino]

hi Patnaik,

perhaps it's different currency for Dr and Cr,

try to use NODIM - in query designer data function - unit without dimension

right click keyfigures in query designer and 'new formula'

NODIM ('Dr' )

hope this helps.

[Former Member]

Hi,

your currency field is either bringing different currencies or are currencies are not maintained....I think it is beacuse of different currencies...to get in the same currency uou will have to do a currency conversion at the query level.

Error comes in the case when there are different currencies and it is not able to show up one currency.

Thanks

[Former Member]

Hi,

Make sure that there is mapiing for the unit field in the update rules and transfer rules.

With rgds,

Anil Kumar Sharma .P