cancel
Showing results for 
Search instead for 
Did you mean: 

Currency Translation by Consolidation Document Type

can_erdogan
Explorer
0 Kudos
245

Dear Experts,

We are designing a currency translation logic in Group Reporting and our desire is to run translations only on document type 00 and manual LC adjustment document types. Our expectation is that translations will be running in S4 for all company codes, therefore we don't need run translations on 0F in Group Reporting.

We are trying to control this by using selections, however when we update the selection in CT method with doc type restrictions, we are getting an error message saying "Selection object xxxx contains invalid field DOCTY".

The issue gets resolved when we remove the document type filter from selections, but that will cause translations to run on unwanted document types.

Regular manual adjustment document types have "translate to group currency" flag available, however this does not exist for 0F or 00 doc types.

Any suggestions are much appreciated!

Thank you

0 Kudos

Hi Can,

which product release do you have?

Best regards
Mazen

akhimish
Explorer
0 Kudos

Hi Mazen,

Its version 2020 SP03.

Is it possible to run currency translation only for certain specific document types (00, 01, 02 ) and leave 0F document type as it is and utilize ACDOCA as source for Group currency for 0F.

0 Kudos

Hi Can,

this is only available starting from OP release 2021.

Best regards
Mazen

Accepted Solutions (0)

Answers (3)

Answers (3)

JAnnapureddy
Product and Topic Expert
Product and Topic Expert
0 Kudos

I agree with @mazen Abbas. I personally never tested in our previous versions but the document type filter works from V2021 in the C/T. please open a defect for an official response.

PC and Segment will not support

manish_jain7
Active Participant
0 Kudos

Hi Can,

Did you explore the option of using Group reporting preparation ledger?

Regards,

MJ

can_erdogan
Explorer
0 Kudos

MJ,

I was under the impression that preparation ledger is a v2021 OP concept. Also, how would it address this issue?

can_erdogan
Explorer
0 Kudos

Mazen,

We are on version 2020 SP03.

Thanks