I wanted to make an update to this thread. We were finally able to get the dollar amounts coming from AP and PA to reflect properly when you are using a secondary Fixed Assets book (defined as a tax book) that is in a different currency. I also want to note you can accomplish the same functionality WITHOUT using a secondary FA book (tied to a secondary GL ledger) by simply adding a reporting ledger to your primary GL Ledger.<o:p></o:p>
What is important however, is the order of operations. It doesn't matter whether you go with just your primary GL ledger with a reporting ledger in another currency (defined with subledger detail between the two) or if you go with primary GL ledger, secondary GL ledger, reporting ledger and a CORP book and secondary (tax) book.<o:p></o:p>
A reporting ledger is REQUIRED IN BOTH scenarios above. Furthermore, ALL GL objects....primary GL ledger, secondary GL ledger, reporting GL ledger (in another currency), MUST MUST MUST all be defined BEFORE you define your FA Books (regardless of whether you're going single FA book and just gl primary and reporting OR primary and secondary GL and reporting...along with corp FA book and secondary FA (tax class/tied to secondary GL ledger).<o:p></o:p>
Nowhere can I find where this is explicitly stated. We had created primary and secondary GL ledgers, then defined FA Corp and FA Tax (secondary currency books. After that we added the reporting ledger in GL. This will not work. All GL configuation must be complete before any FA book is defined. This is because there are attributes on the FA books that are set at creation. If no reporting ledger is tied to your primary gl ledger at FA book creation, those attributes won't be set correctly in the FA books and never will be.<o:p></o:p>
The Oracle Applications & Technology Users Group (OATUG), formerly the Oracle Applications Users Group (OAUG), is the world’s largest education, networking and advocacy forum for Oracle Applications & Technology users.
firstname.lastname@example.org Oracle Applications & Technology Users Group 3525 Piedmont Rd NE Bldg 5, Ste 300 Atlanta, GA 30305-1509 USA (404) 240-0897
Copyright 2020 Oracle Applications & Technology Users Group. | All Rights Reserved. | OATUG PoliciesAll material, files, logos, and trademarks within this site are properties of their respective organizations.