Best Of

Hello @Jeremy Guimaras -Oracle thank you so much for the quick updates and follow up, very appreciated, it is helpful, with that reference, we tried with different ways, finally got the output as expected, please check on the below screenshots for reference,

Using below criteria we get the invoices with 30 days past due,

Using below criteria we get the invoices with 60 days past due,

Using below criteria we get the invoices with 90 days past due,

Using below criteria we get the invoices with 120 days past due,

In the results tab pulling below information,

Hope it will be helpful for the ones who are looking for past 30, 60, 90 and 120 days invoices with the past due,

Actually this was queried by one of my friend, I shared him the ideas to achieve the solution with your reference, now he is fully happy with it and got what he expected, once again thank you @Jeremy Guimaras -Oracle , thanks to my friend as well who given me the screenshot to post it here so that it is helpful to others in our group,

You are welcome, @Nayeem Rahman Shaik 🙂

I'm glad that you were able to tweak the saved search according to your business need. Thank you for sharing it as well so our members who might need the same can easily see.

Have a great day ahead!

Thanks @Patrick Fresnosa-Oracle

After reading your response, I tried grouping to summarize then found [Transaction Demension: Period Name] which is the name of month for us.

So I was able to get the view I wanted!

Now I will try to find a way to order the system to only generate at the summary level instead of generating a report and then group them to make the report faster.

If you have any insight on this please share as well.

Thanks again!

Hi @ImeldaSanchez,

You should see this under Billing Information.

John

Sounds like a plan! Will check out Chrome extension.

Yes! It worked! Thank you so much @Able Wilson !

lcrumling_42244 I logged support Case # 5671098 Defect#766318 Fixed Asset List > Default View > Show No Records with my example.

So that they have another example, would you also create a case and include reference to my case # 5671098 Defect#766318 Fixed Asset List > Default View > Show No Records

Their response to me is below:
Support Case #: 5671098 Defect#766318 Fixed Asset List > Default View > Show No Records

Hello ,

According to our engineers, there seems to be an issue with paginated searching and custom IDs that have lowercase letters (such as sc00643).

Though this issue is not caused by FAM itself, rather with the search module from SuiteScript. 

Please try renaming one Asset to uppercase, such as "sc00643" to “SC00643” and then check if this will appear in the results.

I tested and this did not resolve the issue. I provided my test results and they are continuing to investigate.

If they had your example as well, they may be able to pinpoint & resolve the issue.

Best.

Hey @Rob van der Leij,

You can create a custom Billing Schedule for each Sales Order line and define when and for how much you want the invoices generated.

Once defined, each time you click "Next Bill", NetSuite will generate the appropriate invoice based on the defined Billing Schedule.

If you don't have any Billing Schedules on Sales Order lines, the "Next Bill" will generate one Invoice for the full Sales Order amount.

Thank you Richard and Angela for the help. I was able to connect Skyvia to Netsuite by using OAUTH.

Ken