Hi @User_IJB6M, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @Anne Dolce, Glad to have you with us today! Thanks for posting your concern here. Our guru/s will look into your concern and reply to this thread for any updates. To our members, please feel free to share your thoughts as well.

Hi @Martha Hakes, thank you for your response. I tried incorporating your formulas on our test accounts but I keep on getting an unexpected error. With this, I tried creating my own formula to get the last year and this year's (2023 vs 2022) total income that will match the Income Statement Report and here's what I did:…

Hi @manuelsaomartinho, I investigated this on our test account and was able to reproduce the same behavior: Dec 2022 (Dec 1,2022 to Dec 31, 2022) = Closed Adjustment Period (Dec. 31, 2022) = Open Using an Administrator role, I created a Journal Entry: Date = 12/31/2022 Period = Adj 2022 Status = Pending Approval This is…

Hi @Martha Hakes, Hope you are well. I would just like to follow up on this concern. Let us know if you need further assistance. 😊

Hi @User_HQRSY, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @tech work, thank you for that information. I tried replicating your concern on our test account with the following steps but unable to reproduce the behavior: 1. Advanced Taxes under Enable Features page is marked: 2. This is how the Set Up Taxes page for United States looks like: 3. I created a sample Sales Order with…

Hi @Martha Hakes, based on your criteria, are you trying to pull all the account types or just the income/sales amounts on the search? Can you specify which one of the formula's not working and provide a sample screenshot on how it looks like when previewed? Hope to hear from you. Thanks!

Hi @User_4HDGW, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @User_HQRSY, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @tech work, do you still need assistance with this inquiry? If so, we would appreciate you providing the additional information we were requesting in the previous post. Looking forward for your response. Thank you! 😊

Hi @FazeprooF, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @phbryan, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @Steven O, Thank you for posting a new thread! Tagging our gurus who have expertise on this: @Kristoffer Viray-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any insights? To our members, please feel free to share your thoughts on the thread.

Hi @Entartes, We're glad to have you here. Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To other members, feel free to share your insights on this too should you have any 😊

You're welcome, @brocha! 😊

Hi @tech work, may I know what type of transaction is this? Is this created via UI? Does CM refer to credit memo? May I also know if you are using Advanced Taxes/Suitetax or if you are using any third party engine for tax calculation i.e. Avalara? Per my understanding, you have a transaction with a discount line item and…

Hi @User_EKY01, Thank you for the screenshot. Apologies for the confusion. The one where I selected the Transaction Number was from the Account Balance folder on the Deferred Revenue by Customer report. Even though the values were different it still did not pull the source document of the Arrangement. I customized the…

Hi @Intelligere, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @User_EKY01, thank you so much for providing additional information. I investigated and tested your concern on our test accounts by creating sales order and invoices via UI but was not able to reproduce the behavior. The transactions are correctly pulling the exchange rates for the date specified. However, I would like…

Hi @brocha, thank you so much for the clarification and screenshots provided. The memo field I previously mentioned was the one from Transaction's Main Line and not on the item line. I did further checking and as per SAID 24350: Add Transaction Line Item Memo Field as Column in a Report: To add transaction line Item Memo…

Hi @User_EKY01, just checking in if you were able to check my previous comment? Kindly let us know if you need further assistance with this one. Thank you! 😊

Hi @User_EKY01, On the affected Sales Order under the System Information tab, can you provide a screenshot and check for the Subsidiary, Currency and Exchange Rate fields if there were any changes? Thank you!

Hi @User_M8RDQ, Glad to have you with us today! Thanks for posting your concern here. Our guru/s will look into your concern and reply to this thread for any updates. To our members, please feel free to share your thoughts as well.

Hi @User_EKY01, Can you also provide screenshots of the system notes of both the invoice and sales order just to verify/check if there were no changes made? Kindly cover any confidential information. Thank you! :)

HI @User_EKY01, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @brocha, This is what is stated under the help field. Transactions > Memo :)

Hi @brocha, I tried checking this on our test accounts. I went to the Trial Balance report and drilled down on a sample account for account detail and then customized it. I noted that we found a memo field on our end: May I know what the available fields are on your end? Looking forward for your reply. Thank you! 😊

Hi @Chad C, Thank you for posting a new thread! Please allow some time for the members/gurus to check on your concern and get back with more information. To our members, please feel free to share your thoughts on the thread.

Hi @Erez Storch, we understand your frustration but unfortunately, the only way you can check balances on different accounting books on the trial balance is to display them one by one by changing the footer filter "Accounting book" to your preferred choice then export the reports and combine it via excel. We apologize for…