Reminder campaigns
Use this function to manage reminder campaigns:
- Select non closed open items, then modify and post them.
- Generate letters and send emails using the FUP workflow.
- Create tasks in the CRM module.
All phases of a campaign can be launched in batch mode: select open items, validate the campaign, send letters or emails.
Currencies in reminder letters
The currency used is determined by the Reminder by transaction currency and Balance in transaction currency fields in the Reminder groups function.
French fixed allowance penalty
Reminder letters must include a legal notice and a 40 €* penalty for each overdue open item when the following conditions are met:
- Bill-to or Pay-to business partner is a French legal company, not an individual.
- An early discount or late charge code is present in the invoice header of the reminder open item.
- The reminder is for an invoice, not a credit memo.
- This amount does not change with the reminder level.
Use the FUP- Reminder management report to include the legal notice and fixed allowance penalty in the report.
*Note: 40 € is the minimum required by French law.
Prerequisite
Refer to documentation Implementation
Screen management
Header
Campaign number (field QURNUM) |
Reminder of the campaign number. |
Comment (field CMT) |
Free comment field associated with the current object. |
Creation user (field CREUSR) |
Date created (field CREDAT) |
This field displays the creation (entry) date of the object. |
Change user (field UPDUSR) |
Change date (field UPDDAT) |
This field displays the date of the last modification entered for the object. |
Screen (field ECRAN) |
Enter the screen code used to view the open items. This screen can be modified. |
Validated campaign (field VALIDE) |
A validated campaign can no longer be modified. |
Tab Entry of the main criteria
Company group (field CPY) |
All sites (field ALLFCY) |
Select this check box to include all sites for the selected company. |
Site (field FCY) |
When this field is populated with a site code, the inquiry is filtered in order that only those data concerning the selected site are displayed. |
All control accounts (field ALLSAC) |
If this box is checked, the processing is launched for all control accounts (otherwise, they have to be specified). |
Control group (field GRPSAC) |
Control (field SAC) |
Reminded BP (field BPRFUP) |
All customers (field ALLBPC) |
From customer (field BPCDEB) |
Enter the From license plate number to select the records to be processed. |
To customer (field BPCFIN) |
Enter the To license plate number to select the records to be processed. |
All users (field ALLUSR) |
When this box is checked, all open items are involved, irrespective of the user that created it. |
User (field USR) |
User responsible for the creation of the open items. |
All payment methods (field ALLPAM) |
This field is used to launch the campaign on all the payment methods. |
Payment method (field PAM) |
All reminder groups (field ALLFGP) |
Reminder group (field FGP) |
This field is used to launch a campaign on a group of bill-to-customers managed by the same rules. |
Reference date (field REFDAT) |
From reminder level (field FUPLEVSTR) |
To reminder level (field FUPLEVEND) |
Customer prepayments (field ACCLI) |
Criteria (field CRI) |
Tab Entry of the secondary criteria
All group customers (field ALLBPCGRU) |
Group customer (field BPCGRU) |
Group customer code. |
All risk customers (field ALLBPCRSK) |
From risk customer (field BPCRSKDEB) |
Code of the risk customer, used to refine the reminder campaign regarding a risk BP or a range of risk BPs. |
To risk customer (field BPCRSKFIN) |
All representatives 1 (field ALLREP1) |
field REPDEB1 |
Use this field to launch a reminder campaign on a group of invoiced customers with the same sales representative. |
field REPFIN1 |
All representatives 2 (field ALLREP2) |
field REPDEB2 |
field REPFIN2 |
All classes (field ALLCLS) |
Class (field CLS) |
This field is used to launch a reminder campaign on a group of invoiced customers belonging to the same category. |
All stat groups (field ALLTSCCOD) |
field TSCCOD |
Late charge calculation (field AGIO) |
Select this check box to start the late charge calculation when an open item has an early payment or late charge code. This check box is selected by default. |
Include open items not to remind (field FLGFUP) |
This check box is used to include in the selection the open items whose reminder flag is set to no, but where the customer should be reminded. |
Tab Business partner listing
This screen opens when you click OK. It displays a summary of reminder balances for each BP + Company + Site combination. The information displayed, such as by Bill-to BP or Pay-by BP, depends on your selection criteria.
The content on this screen is display-only and cannot be modified.
The amounts are expressed in company currency.
The FUPSIM report is linked to this screen. It summarizes within a single document the open items to be reminded by BP + Company + Site combination.
Block number 5
Campaign number (field QURNUM) |
Reminder of the campaign number. |
Send
Letters (field NBL) |
This field displays the number of letters or emails to be generated for the current campaign. These calculations take into account the number of copies requested in Reminder groups. |
Mails (field NBM) |
Grid List of BPs for reminding
Select (field SEL) |
This field specifies the number of open items to be reminded.
|
BP (field BPC) |
BP being the object of reminders regarding the current campaign. |
Company name (field BPCNAM) |
Company (field CPY) |
Reminder of the company(ies) involved in the current campaign. |
Site (field FCY) |
Reminder of the site(s) concerned by the current campaign. |
Reminder type (field FUPTYP) |
Reminder type for the customer. |
Comment (field CMT) |
Free entry field linked to the Customer + Company + site combination. |
Balance for reminding (field SOLREL) |
This field displays the total amount for the reminder based on the open items selected for the customer. You can see the list of open items by selecting Customer open items from the Action icon menu on the line. |
Balance not for reminding (field SOLNONREL) |
This field displays the total amount not included in the reminder based on the open items not selected. You can see the list of open items by selecting Customer open items from the Action icon menu on the line. |
Late charges (field AGIOS) |
This field displays the amount calculated based on the early discount/late charge code associated with the open items if the Late charge calculation check box is selected. |
Total for reminding (field TOTFUPLIG) |
This field displays the total of the balance to be reminded and the late charges. |
Total balance arrears (field CLEFUPTOT) |
This field displays all the open items overdue for the customer (balance to be reminded + balance not to be reminded). |
Totals
For reminding (field LIB2) |
field LIB1 |
Open items (field ECH2) |
field ECH1 |
field CUR |
Late charges (field TOTAGIOS) |
This field displays the late charge amount calculated based on the early discounts/late charges associated with the open items. |
Total (field TOTFUP2) |
field TOTFUP1 |
Comment
field CMT2 |
This comment field is limited to 1,022 characters and is linked to the BP + Company + Site combination. It displays as long as the campaign exists. |
Open Items | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Field descriptions
BP
Contact
For reminding
Comment
|
Select Open items to view the list of the selected open items based on the campaign criteria for the BP + Company + Site combination.
Reminder campaigns detail
Only open items with the check box selected in the first column are included in the campaign.
From this screen, you can:
- Enter or modify a comment. This text is linked to the open item and is displayed with the next reminder.
- Modify the due date and the reminder level.
- Modify the charge code and the dispute code.
- Modify the address code for letters and the reminder method to be applied.
Options from the Action icon menu on each line:
- Customer invoice: View the related invoice.
- Open item management: Access the open item detail.
- Select all, Unselect all, or Reverse selection: These actions apply to all lines in the grid.
- Update discounts/charges rates: Update the Charge code column using the current line. If the line does not have a late charge code, the late charge code on the following line is removed.
Click this button to access the customer record.
Click this button to access the Customer situation query to view the balance of pending invoice payments by period.
For validated campaigns, click this button to view related CRM Tasks.
See the Link between reminders and CRM parameter (TRS chapter, FUP group) documentation for more information.
Reports
By default, the following reports are associated with this function :
FUPSIM : BPs for reminding
FUPRC : Reminder management
FUP : Reminder management
This can be changed using a different setup.
FUP – Reminder management: Use this report to generate reminder letters that include late charges and the legal notice including the 40 € penalty per open item for French companies. This is generated automatically if an open item meets the requirements noted above. The report does not include interval management.
- Entry reference
- Open item amount
- Due date
- Document amount in either transaction or company currency depending on the Reminder by transaction currency field setting in the Reminder groups function.
- Due date balance in transaction or company currency depending on the setting above
- Amount in company currency
- Late charges if applicable
- Legal notice: “Any late payment will require that a fixed allowance be paid for the recovery of costs, of 40 EUR” (for French companies) if applicable.
- Running totals per page that include open item amounts, late charges, and the 40 € if applicable
- Totals including open item amounts, late charges, and the 40 € if applicable, with a line for each and then a grand total.
This is the only report that includes the penalty amount and legal notice for French companies.
FUPRC – Reminder management: This report is used to generate reminder letters that include late charges. It also includes interval management when the Reminder frequency type is Interval.
This report does not include the penalty amount and legal notice for French companies.
Reports for BP reminder campaigns
The reports for BPs listed below do not generate reminder letters nor do they include the penalty amount and legal notice for French companies. These reports can only be accessed from the Reminder campaign function. To print these reports for the current campaign, click OK to display the List of the BPs for reminding in the campaign on the Business partner listing screen. From this screen, click the Print icon. The report displays the list of the selected open items to launch in the campaign for each client in the campaign.
FUPSIM – BPs for reminding: This report prints all the open items suggested in the reminder campaign, but does not generate a reminder letter. For each company, the report includes a total including the late charge for each open item and:
- Entry reference
- Bill-to BP
- Pay-by BP
- Due date
- Level – Gravity level according to the Reminder frequency
- Amount in company currency
- Amount in EUR
- Late charge percent and amount
FUPSIML– BPs for reminding (detailed): This report prints the details for each open item, totals, and comments. Data for each BP starts on a new page.
FUPSIMP– BPs for reminding (portrait): This report only prints totals for BPs in the campaign. Totals for each BP start on a new page.
Specific Buttons
Reprint |
Click this button to reprint letters or emails for a validated campaign. |
Return |
Click this button to go back to the previous screen. |
OK |
After selecting or creating a reminder campaign number, click OK to open the Business partner listing screen, which provides a summary of information related to the current campaign. |
Limits
For open items that are not locked: If an open item is modified between the selection and the validation of the campaign (e.g., changing the due date), this modification is not taken into account.
When launching a reminder campaign, only Pay-by/Bill-to BPs whose role is Customer can be included in the campaign. Other BP roles, such as Miscellaneous BP, are not considered.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
"No open item matches the chosen criteria, please verify the criteria""Full grid"The size of the grid (3000 lines upon delivery) is exceeded. The maximum grid size must strictly stay below 32767 lines.