Hi @Chad C Thanks for creating this thread! We'll be looking into this one for you and we'll see what we can do. We'll reply to you with the answers as soon as possible. But to our members out there who would like to share their insights -- Don't be shy and comment on the thread! Let's collaborate to help our dear member…

Hello @User_USRCP I believe this one can be done only trough a script. But here is a possible workaround that we could do by creating a custom field with Document field type 1. Navigate to Customization > Lists, Records and Fields > Transaction Body Fields > New 2. In the Label field, enter a label for the field 3. In the…

Hello @Anson F. Thanks for creating this thread! We'll be looking into this one for you and we'll see what we can do. We'll reply to you with the answers as soon as possible. But to our members out there who would like to share their insights -- Don't be shy and comment on the thread! Let's collaborate to help our dear…

Oh no @Erick Dela Rosa-Oracle , you didn't even made the cut. HAHAHA!

Hi @Patrick Fresnosa-Oracle This isn't related to Advanced Accounting but I'm going to ask you anyway! If the zombie apocalypse is coming, who are 3 NetSuite gurus you want on your team? Hello NetSuite gurus. Hahahaha!

Yay! That's awesome!! ?

Hey there! We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would very much appreciate your feedback and any input you can provide. ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hey there! We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would very much appreciate your feedback and any input you can provide. ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hey there! We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would very much appreciate your feedback and any input you can provide. ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hello, @Kathy W ! Thanks for creating this thread! We'll be looking into this one for you and we'll see what we can do. We'll reply to you with the answers as soon as possible. But to our members out there who would like to share their insights -- Don't be shy and comment on the thread! Let's collaborate to help our dear…

Hello @Tracy Heinrich As per checking, using the 5-4-4 weeks as Period Format is still not yet available in NetSuite. However, you may consider setting up accounting periods first by year, quarter, and base period as follows: In a notepad or a separate spreadsheet, plan the periods using 5-4-4 format. (e.g. P1 2022 for 35…

Hi @Wendy_M !! Glad you already found the answer and thanks for sharing it with us!! ?

Hey there @Charles B ! This will be extremely helpful for our other members. Thank you for posting this one! You're awesome!! ?

Hey there! We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would very much appreciate your feedback and any input you can provide. ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hello there, @Kellyann ! Could you kindly check the zip code? I believe the system requires it to be in 5 digits. Tagging my colleagues @Shamaine Chan-Oracle , @Dominica Sevilla-Oracle , and @Katerina Winklerova-Oracle so they can help you out on this one too ? CHEERS!

You can try this one out instead. Try setting the date ranges like this: And then on your dashboard, personalize it and add Custom Search. Set it up and add the Saved Search. Let me further check how we can do it in the KPI dashboard too.

Hello there, @User_2LQKP You can check out this video for the demonstration. Here's the link. You can start at 3:36 ? Hope this helps! Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank…

Hello @Tiru Chembeti As of now, we are not quite sure when this functionality will be available in the UI. For the unreconciled transactions that you would like to export, you can actually create a saved search for that. Here's how --- 1. Navigate to Lists > Search > Saved Searches > New. 2. Choose Transaction. 3.…

Hey there! We would just like to know if the solution worked for you? Or did you find another way to work things around? The community would very much appreciate your feedback and any input you can provide. ? It would also be great if you can mark the comment/s which was/were most helpful for you. Thanks!

Hello @BevS_RIQI I checked and it seems like it is still not possible to link two datasets. The only possible way is through a script. This SuiteAnswer Articles may be helpful: SA 101098 | Linking Datasets SA 100992 | Dataset Linking in SuiteAnalytics Workbook ___________________ Kindly click "Yes" on "Did this answer the…

Hello again @User_NOMCY , As per checking, this is not possible through inline editing. What we can however is to update this field through CSV import. Include the following on your CSV file: Internal ID - vendor Default Expense Account - it is best if you use the internal ID of the account. Navigate to Setup >…

Hello there, @Christophe Tiers , Could you provide us a screenshot of the UI and these subtables so the community can picture out what our discussion is about? Also, don't forget to hide sensitive information. We'll check this one out for you to see what we can do ?

Hello there, @User_NOMCY Kindly provide us the following so we can further check. In case there is sensitive information, kindly blur them for privacy as this can be seen by the whole community. Navigational path. A screenshot of the UI where you were trying to edit. Thanks!

You can try this formula to have the sum of all the transactions for that month. Just change the date range. January formula: case when {trandate} between to_date('1/1/2021', 'mm/dd/yyyy') and to_date('1/31/2021', 'mm/dd/yyyy') then {amount} else 0 end February formula: case when {trandate} between to_date('2/1/2021',…

Hi Jessica! Good to see you again! How are you? Thanks for creating this thread! We'll be looking into this one for you and we'll see what we can do. We'll reply to you with the answers as soon as possible. But to our members out there who would like to share their insights -- Don't be shy and comment on the thread! Let's…

Hello @MichelCA Kindly provide us a screenshot of the criteria and results tab of the saved search so we can further check. If there are confidential information, kindly blur them for security purposes. Thanks!

Hello again! You can click on the Create Calculate Measure button and then make a formula for the two datasets to net the amounts ?

Hi ML! You can try using the Account Register for this one. This will show all transaction types, all the movements, as well as the running balance. You can refer to this SuiteAnswerArticle: Account Register.

Hello @User_Z7YVU As per checking, we won't be able to select a bank account on the Credit Card Transaction page. Here are alternative solutions you can try: Create a journal to record this transaction. Transactions > Financial > Make Journal Entries; or On the Match Bank Data page, on the left side under the Account…

Hello there, @Daniel V Could you elaborate more on what we want to achieve here? I'm tagging my fellow gurus, @Dominica Sevilla-Oracle and @Shamaine Chan-Oracle so they can share their insights too ?