|
Recent Choice |
Description | |
|---|---|---|
| Recently Viewed | The last 10 or 25 records you viewed, with the most recently viewed item listed first. This list is derived from your recent items and includes records owned by you and other users. | |
| Recently Created |
The last 10 or 25 records you created, with the most recently created item listed first. This list only includes records owned by you. |
|
| Recently Modified | The last 10 or 25 records you updated, with the most recently updated item listed first. This list only includes records owned by you. |
In FinancialForce Billing Central, a soft date enables you to calculate recurring dates based on a unit of time such as a week, month, quarter, or year. Soft dates can consist of:
You can enter a reference, adjustment, or both using the format Reference+Adjustment. You can specify the unit of time in upper or lower case, for example, we+3d, MB-1D.
Soft dates determine the frequency and duration of plans and the billing period of billing schedules. For example, the billing term on contract lines with a recurring billing type such as Recurring Fixed or Recurring Variable is a soft date. When you activate the contract, billing schedules are created for the contract lines based on the start date, the billing term, and the number of billing terms.
The dates that a soft date generates are adjusted based on the calendar. This means that the resulting dates can vary depending on the interval chosen and the day from which the soft date is generated. For example, if the date is January 31, 2019 and the soft date is +1M, the next date is February 28, 2019 followed by March 31 then April 30. If the date is on a leap year such as 2020, the dates would be January 31, February 29, March 31, and April 30.
The reference consists of two letters in upper or lower case. The first letter indicates whether the date recurs on a weekly, monthly, quarterly, or yearly basis. The second letter indicates whether the date recurs at the beginning or end of the week, month, quarter, or year. For example:
|
Reference |
Description |
|---|---|
|
WB |
Sets the date to the first day of the week based on the start date. |
|
WE |
Sets the date to the last day of the week based on the start date. |
|
MB |
Sets the date to the first day of the month based on the start date. |
|
ME |
Sets the date to the last day of the month based on the start date. |
| QB |
Sets the date to the first day of the quarter based on the start date. |
| QE | Sets the date to the last day of the quarter based on the start date. |
|
YB |
Sets the date to the first day of the year based on the start date. |
|
YE |
Sets the date to the last day of the year based on the start date. |
The adjustment consists of an operator followed by a whole number of one to three digits, which indicates whether to add or subtract from the date. This is followed by another letter that indicates whether to add or subtract days or months.
Key: xxx – Whole number consisting of one to three digits.
|
Adjustment |
Description |
|---|---|
|
+xxxD |
Adds a number of days. |
|
-xxxD |
Subtracts a number of days. |
|
+xxxM |
Adds a number of months. |
|
-xxxM |
Subtracts a number of months. |
Here are some examples of soft date definitions:
|
Example Definition |
Description |
|---|---|
|
+60d |
Returns a date that is 60 days after the start date. |
| +1m | Returns a date that is one month after the start date. |
| +3m | Returns a date that is three months after the start date. |
|
WB+1d |
Returns the second day of the week. |
|
ME-12d |
Returns a date that is 12 days before the end of the month. The next date returned depends on the input date. For example:
|
|
QB+7d |
Returns a date that is the 8th day of the quarter. |
| QE-2d | Returns a date that is two days before the end of the quarter. |
|
YB |
Returns the first day of the year. |
Here are some valid combinations of Reference+Adjustment:
| Sample Soft Dates | ||||||||
|---|---|---|---|---|---|---|---|---|
|
WB WB+0d WB+1d WB+999d WB+0M WB+1M WB+999M WB-0d WB-1d WB-999d WB-0M WB-1M WB-999M |
MB MB+0d MB+1d MB+999d MB+0M MB+1M MB+999M MB-0d MB-1d MB-999d MB-0M MB-1M MB-999M |
QB QB+0d QB+1d QB+999d QB+0M QB+1M QB+999M QB-0d QB-1d QB-999d QB-0M QB-1M QB-999M |
YB YB+0d YB+1d YB+999d YB+0M YB+1M YB+999M YB-0d YB-1d YB-999d YB-0M YB-1M YB-999M |
WE WE+0d WE+1d WE+999d WE+0M WE+1M WE+999M WE-0d WE-1d WE-999d WE-0M WE-1M WE-999M |
ME ME+0d ME+1d ME+999d ME+0M ME+1M ME+999M ME-0d ME-1d ME-999d ME-0M ME-1M ME-999M |
QE QE+0d QE+1d QE+999d QE+0M QE+1M QE+999M QE-0d QE-1d QE-999d QE-0M QE-1M QE-999M |
YE YE+0d YE+1d YE+999d YE+0M YE+1M YE+999M YE-0d YE-1d YE-999d YE-0M YE-1M YE-999M
|
+1d +1M +3M -1d -1M -3M |
View Tutorial