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…

Hi @User_EKY01, Thanks for your update. This is how it looks like on my end when I checked in on our test account. The Transaction Number and Source Rev Rec Document Number have different values: May I know how it looks like on your end? Can you send a sample screenshot of the fields you added and how the report looks…

Hi @User_V5KBL, I checked this on our test account by doing the following steps: 1. Navigate to setup > Import/Export > Import CSV Records 2. Set Import Type to Transactions Actual Results: Project Charges and Charge Rules are not available in Record Type dropdown list Upon further checking, this is currently a system…

Hi @Liz Madrid, are you trying to generate the profit and loss report? This can be found under Reports > Financial > Profit and Loss Report. The report could sometimes be named as "Income Statement" report as well. 😊

You're welcome, @Liz Madrid! Glad to be of help. ☺️ We would greatly appreciate if you can click "Yes" on “Did this answer your question?” on the previous comment/s you found helpful. This will also help other community members who might have the same concern find the answer easier. Hope you have a great day! 😊

Hi @nag_m, 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 our members, please feel free to share your thoughts as well.

Hi @Liz Madrid, You can do that by changing the Alternate Period Range Type to Relative to report date. If this is selected, the data shown will change in accordance to the As Of Date selected on the report: As you can see here, we set As Of = Dec 2021 and since on the above we selected Last Fiscal Year, the last fiscal…

Hi @Liz Madrid, this is how it looks like when I did the workaround. You could also do the steps below: On the customize page: 1. Click Amount (Debit/Credit). 2. Set the Alternate Period Range Type to Relative to today's date. 3. Uncheck Cumulative Value. 4. Alternate Period Range: Custom or Last Fiscal Year 5. Range…

Hi @Liz Madrid, Upon checking, the ability to present a Trial Balance report by Accounting Period is currently logged under Enhancement 114732: Reports > Financial > Trial Balance: Add the Column Footer (similar to one on Balance Sheet and Income Statement) to Trial Balance. However, there is a workaround provided. Kindly…

Hi @User_K9ZU8, Welcome to NetSuite Support Community! Thank you for creating this thread. 😊 Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, feel free to share your insights or suggestions by commenting on this…

Hi @brocha, Thank you for being with us today and for posting your question here! 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 as well.

Hi @Edwards_05, Thank you for posting here in NS Support Community and for being with us today. Tagging our gurus who have expertise on this: @Ivy Lopez-Oracle / @Joy Noreen Magoling-Oracle / @Elychelle Gulen-Oracle / @Dominica Sevilla-Oracle, any insights? To other users, feel free join in the discussion as well.

Hi @User_VAYT1, 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 @Erez Storch, 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 @Edwards_05, thank you for your prompt response! :) May we know if they shared any investigation they've done to determine if it's on our end? Were you able to check (deploy/undeploy) the scripts deployed on transaction to see which one is causing it to change on the invoice? I think it's best to file a Support Case for…

Hi @Edwards_05, Upon checking on our resources, I found similar cases which have the same concern wherein the sales order and invoice are calculating different tax/values from Avatax. It is possible that difference happens due to some workflows/scripts deployed on the transaction. We noted that the script responsible for…

Hi @Liz Madrid, just checking in if you were able to try the suggested solution in my previous comment? Kindly let us know if you need further assistance with this one. Thank you! 😊

Hi @User_JYDZ8, Welcome to the community! We are glad to have you here with us! Thank you for posting your concern here. For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your…