Custom Billing Schedules

Question

Hi,

My client will be using custom billing schedules at Sales Order line level leading to millions of these records sitting in the system over time. Could that cause any performance issues?

Seems like they cannot be deleted (unless the link at SO line level is removed) as well later when not required anymore, can only be marked as inactive. Does marking them Inactive help get rid of performance related issues is any?

Thanks!

Aly Magpantay-Oracle · Accepted Answer

Hi @Pallavi1903, Thank you for posting here in the NetSuite Support Community!

Hello everyone! One of our fellow members could use a hand. Please feel free to join this thread and share your knowledge, ideas, or tips. Your contributions are always valued and truly appreciated!

Tigran Shahnazaryan · Accepted Answer

Hey @Pallavi1903,

NetSuite expects that the number of records will gradually increase, and in most cases, those records aren't being deleted.

In some cases, customers are advised to move to a higher-performance tier when their database size becomes too large.

Billing Schedules are lightweight and don't have a noticeable impact on performance.

GauravAgrawal · Accepted Answer

HI Pallavi1903,

Maintaining multiple Billing Schedule wont impact system performance. Issue majorly would be if you are running any report with those field or client wants to generated invoice using them or tagging them manually through UI.