Hi @User_JQO26, Can you provide more details about the scenario, including the record type, the expected and actual result? Screenshots are also appreciated, but please don't forget to redact any confidential information such as email addresses, account ids, personal info. Thank you!

Hi @User_Q1DPO - were you able to check on this?

Hi @Divya Unnikrishnan, Unfortunately, you need to create a USD subsidiary to be able to run a report both in USD and INR. The workaround for this is currently logged under an enhancement mentioned previously. To our other members, feel free to share your ideas and suggestions on this. 🤗 We appreciate your understanding on…

Hi @Elina Kourouzidou, I'm sorry if my words came across as sarcastic. That was not my intention, and I apologize for any hurt or misunderstanding caused. Disregarding the screenshots, you mentioned that "The client created Advance Intercompany Journal Entries to Apply them as the payments of the above Bill and Invoice.…

Hi @Elina Kourouzidou, Greetings! As per mentioned by Angela, you need to keep the AP or AR transactions open to be able to match them in your netting workbench. By creating an AICJE, to pay-off the bill and the invoice the system treated this transactions as closed. You can test this in your Sandbox environment, by…

Hi @User_Q1DPO, Thank you for your response! Yes, there will be a difference with the standard general ledger report and the report from your saved search, but the total amount for same category and criteria should be the same.

Hi @Divya Unnikrishnan, Hope you're having an awesome day! I wanted to follow up on my previous post and I wanted to check if the information was helpful and whether you had the opportunity to review it. Please feel free to reach out if you have any questions or require further clarification.

Hi @User_Q1DPO , Thank you for your feedback! Can you please confirm the process that you tried that didn't work?

We greatly appreciate your input @Tigran Shahnazaryan! Hi @Divya Unnikrishnan, Good day! Yes, as per mentioned by Tigran you can create a USD Reporting Parent subsidiary to facilitate the consolidating report for USD and INR. As for the ability to run and print Financial Reports in currencies other than Base Currency, it…

Hi @Yee Yie, Good day! Just checking-in if you were able to read our previous post! Let us know your thoughts. ☺️

Hi @Elina Kourouzidou, Good day! Just checking-in if you were able to read our previous post. Let us know if you need further information!

Hi @Yee Yie, Appreciate your response! Depending on the revenue recognition report you're running and the scope of the report, the items marked as "Is Recognized" will be included in that report. You can run a customized report, you can also refer to SAID 36677 | Enhancing Deferred Revenue Reports. Hope this helps!

Hi @Elina Kourouzidou , Appreciate your response! Can you please provide us further with your step to reproduce in young netting workbench process? For now, you may want to refer to below articles for reference regarding Netting Workbench: 94878 | Intercompany Netting 94927 | Intercompany Netting Limitations 95049 | Best…

Hi @User_Q1DPO, Great! Please let us know once you've tried this! As for your column for Opening an ending balance, you may also want to refer to this SuiteAnswer article: 23641 | Saved Search for Journal Entries posted for Account Opening Balance. 66898 | Expose the Beginning Monthly Balance and Ending Balance of Accounts…

Hi @User_BFLDA, Hope you're having an awesome day! I wanted to follow up on my previous post and I wanted to check if the information was helpful and whether you had the opportunity to review it. Please feel free to reach out if you have any questions or require further clarification.

Hi @User_Q1DPO, Apologies for the late revert. As for the general ledger, depending on your account set-up there is a section for your opening balance. The suggestion to create a saved search using the instruction from previous post should be able to have a spilt column for your debit and credit for your foreign currency.

Hi @Elina Kourouzidou, Hope you're having an awesome day! I wanted to follow up on my previous post and I wanted to check if the information was helpful and whether you had the opportunity to review it. Please feel free to reach out if you have any questions or require further clarification.

Hi @User_BFLDA, Thank you for your response! As per suggested by Tigran, you can use the following formula as a reference and update accordingly on your saved search! CASE WHEN MONTHS_BETWEEN(LAST_DAY({today}), LAST_DAY({trandate})) = 0 THEN NVL({amount},0) ELSE 0 END

Hi @Tigran Shahnazaryank, we greatly appreciate your input on this! Hi @Yee Yie, Good day! Upon further research, the ability to to cancel a revenue recognition is still an enhancement and filled under Enhancement: 450606 ARM: Revenue Arrangement > Have a functionality to Cancel a Revenue Arrangement and the revenue plans…

Hi @Elina Kourouzidou, Good day! To apply an Advance Intercompany Journal Entry as Payment to both an Intercompany Bill and Invoice which are paired, you must first ensure that the cross charging process for the posting period is complete. This is well documented in SuiteAnswer 1014836 | Best Practices for Paying…

Thank you guys @Tigran Shahnazaryan and @MJ Fernandez Erro-Oracle. Greatly appreciate the input! 🤗 Hi @User_BFLDA, Can you provide more details about the scenario, including the transaction type, the expected and actual result? Screenshots are also appreciated, but please don't forget to redact any confidential information…

Hi @User_FL4CK, Hope you're having an awesome day! I wanted to follow up on my previous post and I wanted to check if the information was helpful and whether you had the opportunity to review it. Please feel free to reach out if you have any questions or require further clarification.☺️

Hi @User_J3JDX , Appreciate the detailed examples! Yes, I was able to find an enhancement case to create a journal entry in the background. This is is filled under Enhancement: 193421 OneWorld: Transactions > Financial > Create Intercompany Allocation Schedule > have the preference to automatically create Journal Entry…

Hi @Mark Schurmann, Appreciate your detailed response! For the Netting Workbench, it lets you select the nettable transactions on the accounts payables and accounts receivables that will be applied to create a netting statement. There are two ways to use the Netting Workbench: By manually selecting the nettable…

HI @AmitCohen, Good day! I wanted to follow up on my previous post and I wanted to check if the information was helpful and whether you had the opportunity to review it. Please feel free to reach out if you have any questions or require further clarification.

Hi @Yee Yie, Glad you were able to resolve your issue! We are always here to assist you. Don't hesitate to contact us whenever you require our support in the future 🤗.

Thank you for your valuable contribution @Tigran Shahnazaryan!!! Your insights are greatly appreciated and have been very helpful! 🤗 Hi @User_FL4CK, The source amortization start and end date can be presented on the journal record by entering the dates in the Start Date and End Date fields on the Journal Entry form. These…

Hi @User_Q1DPO, Good day! To split the amount in foreign currency into debit and credit columns, you can create a Transaction Saved Search with columns for debit and credit in foreign currency. To create this saved search: ( 41777 | Create Journal Entry Saved Search that Shows Debit and Credit Column of Foreign Currency…

Hi @User_RXH68, Good day! Can you provide more details about the scenario, including the steps to reproduce your Intercompany netting process, the expected and actual result? Screenshots are also appreciated, but please don't forget to redact any confidential information such as email addresses, account ids, personal info.…

Hi @AmitCohen, Hope you're having a good day! As mentioned above, you can create a saved search for your accounting book transactions. You can go to List > Search > Saved Searches > New > Accounting Book. Please let us know if you need further assistance!