Hi guru's,
I need some help with a reminder.
We have sales orders that come back year after year. Before the year is over, a new sales order must be created.
Now that will be forgotten and I am looking for a reminder that helps me remember that a sales order was invoiced in January, for example, but must therefore also be recreated a year later and invoiced again.
This is because there are licenses that customers purchase that cost an annual amount.
We have created a subscription record (ABOxx) ourselves in which we record this data and every sales order therefore also has a subscription record. The new sales order will also be added to the subscription.
I've already tried several things including a Date formula and a relative date but I haven't come to the solution yet.
does anyone have an idea how I can be reminded that I have to create a new sales order after +/- a year.
I've also looked into the 'Next Bill Date' of the Sales order but i can't find the perfect solution for this reminder.
Exemple sales order with ABO
Transaction Saved Search:
Criteria:
Results:
Additional information:
On the item record i've created a custom field that gives the period of the base price (Month, Quarter, Year) Field name Item : Period Base Prijs (ID: item.custitem_xxx_periode_basisprijs)
On the ABO record i've created a custom field that displays the last date of the invoice (suitescript) Field name: Abonnement : Laatste factuur datum
Hope someone can help me.
Regards Toanne