I would appreciate if we can contact a Guru for this. Thanks again

Thanks @Clarisa De Torres-Oracle Yes. The SOs are created in NS via SOAP Web Service (Integration) from another source system. This is a one off case where Exchange Rate on SO is incorrect. We don't have any other scenarios apart from the ones where it coincides at the date change of the server TZ while getting the…

It shows the same values. PFA the screenshot .

Here you go..

Thanks @Clarisa De Torres-Oracle The Audit Trail is quite a few pages long. If you could tell me a specific field you are looking for, I can filter the "System Information" by that and provide you the screenshot. Just FYI: No Currency, FX rate, Tax information was updated manually. And the FX rates are not overriden by…

Thanks@Clarisa De Torres-Oracle SOURCE REV. REC. DOCUMENT NUMBER shows the same value as "Transaction Dimension: Transaction Number". Is there any other field I can use to get Source TX#?

Thanks @Clarisa De Torres-Oracle It helped. But the Transaction Dimension -> Entity -> Name (Customer Name) doesn't populate in case where source document type is Journal. Do you know why? the Entity (Line) -> Name (Project Name) is populated correctly! Could you also help find the field which can show me the source…

Thanks

Thanks! It worked

Hi, Sorry for the delay in my response! I tried the way mentioned in the solution provided but not sure it is correct as I am not able to test. I don't see the Execute button on my WF. Please help me checking if I did something wrong. PFA the screenshots of the workflow and WF Action Thanks again!

Thanks @Joahnna Given Uy-Oracle I am sorry if I was not clear on my question before. My requirement is : Based on a custom field value coming from source system on a Sales order (in this case the Checkbox, Is GSA) , create a $0 Sales order Line for that Sales Order for a specific Item/SKU. For example: If Is GSA = True,…

Thanks for your response! It is a Checkbox whose value (True/False) is sent from source system during Sales order creation. If the value of this field is True (custbody_is_gsa_deal = 'TRUE') then add a $0 Sales order line with a specific item and dates

Thanks for checking! Can we please log an enhancement for this request?

Thanks @Gaurav_NS Doesn't SDF allow only package/deploy configuration? I thought since Item Revenue Categories and Fair Value Formulas are data records they cannot be packaged via SDF. 

Thanks for your responses @Elychelle Gulen-Oracle

Hi, The Billing schedule and Invoice amount exactly matches. The screenshot of the Related records is the converted amount in functional Currency (GBP) and the billing schedule is for EUR amount. The exchange rate used is 0.861965. I am sorry. I forgot to mention this in earlier thread! Update: We have updated our Saved…

Thanks for your response @Elychelle Gulen-Oracle Could you please mention in detail what do you mean by the standard NS unbilled field is not pulling the Invoice amount from actual Invoice but what it is supposed to be. What does Supposed to be here? It is a system generated Invoice based on the Billing schedule created…

Here is the screenshot of the Invoices with billed amount

Hi @Elychelle Gulen-Oracle PFA the requested screenshots

Hi @User_T04PO No. We had a different error message while running reclassification JE for which we created a NS Supp case and it is now resolved. This was the error message: "The exchange rate must be zero for this RA****" Hi @Patrick Fresnosa-Oracle We don't have any script related to reclass JEs posting. Sorry. I have…

Hi @User_T04PO Yes. It was a NS Bug (Case #4610064: Defect 648314) that was fixed by NS. Below was the error: "The exchange rate must be greater than 0" best of luck resolving your issue!

Thanks @Patrick Fresnosa-Oracle But I am not able to view changes made by other employees/users in this saved search with Administrator login as well. Is that expected?

Thanks @Patrick Fresnosa-Oracle Its a bummer but I can try to create two separate Saved Searches/Datasets (One for Revenue Elements and other one for system notes with Record Type "Revenue Element" and link them through Revenue Element Number in Suite Analytics. But could you please help answer this question: 1) When I…

Yes. They are matching. The CM has Sales TAX of $15,982.12 while RA doesn't but that doesn't not matter. PFA the screenshot for reference.

Thanks @Patrick Fresnosa-Oracle PFA the screenshot o f allocation tab. I don't have Revenue Plans generated yet for this Element as it is Usage based and as not started yet!

PFA the screenshots. Hope it helps!

Thank you!

Thanks @Katerina Winklerova-Oracle This is very helpful!! A follow up question: Would it impact AR JEs/Rev Rec JEs in any way as the Invoice is fully paid?

Hi @Kristoffer Viray-Oracle Thanks for providing your answer! I will try the recommended solution in Sandbox and let you know. Currently, we are busy with Month End Close but I will update you soon. Thanks again!

Thanks Katerina! This is really helpful. However, I have a followup question on the Note provided. Previously, (before May 2022) when we used to create CM from an open Invoice, it used to appear in Invoice Related records but when we created a CM from the fully paid Invoice, it is not appearing in the Related records of…