Service charges are applied to overdue invoices, debit memos, etc. Service charges are applied per customer per accounting period. It is possible to create service charges to multiple account periods by running the process for each accounting period. Existing service charges are excluded from future service charges.
Overview
Service charges are applied to overdue invoices, debit memos, etc. Service charges are applied per customer per accounting period. It is possible to create service charges to multiple account periods by running the process for each accounting period. Existing service charges are excluded from future service charges.
Prerequisites
- The System Settings for service charges needed to be setup.
Go to Master > Administration > System Settings > Receivables tab > Set the following fields.
. Default Assess Days - The number of grace days after the due date.
. Default Interest Rate - The interest rate to apply to the balance.
. Misc. Charge Code - This miscellaneous charge code to use when creating the service charge, a debit memo. - The user requires security permissions for "Service Charges" to run service charges.
Go to Master > Security > User Profile > Select User > Module Permission > Receivables tab > Utilities > Check the Service Charges checkbox. - Enable each customer to participate in Service Charges functionality.
. Apply Service Charges - Enable service charges for the customer.
. Interest Rate - The interest rate to apply to the balance.
If this value is not set, the system will default to the value set in System Settings.
. Assess Days - The number of grace days after the due date, overriding the system settings configuration.
If this value is not set, the system will default to the value set in System Settings.
Generate Service Charges
Invoices and debit memos are created as part of the ERP processes. Service charges are applied to the over due (due date plus grace period) invoices and debit memos based on a configured interested rate.
The service charges form is accessible from the menu Receivables->Utilities→Service Charges.
Service Charges Main form's actions and layout:
- Execute - Apply the service charges to the customers as shown.
- Close - Close the form
- Retrieve - Retrieve the service charges available to apply
- Reset Filters Button - Reset the filters
- Update Layout - Apply the current UI layout
- Reset Layout - Reset the UI layout to the default
Filters -
- Division - The division to use for service charges
- As Of Date - The date to use, affecting the cutoff dates for invoices, debit memo, etc. Service charges created will also be based on this date
Service Charges Headers -
- Include - Check the checkbox to include customer in Service Charges in the process.
- Processed - Indicate if the customer has been processed or not.
- Division Code - Division
- Customer Name - Customer Tittle
- Customer Short Name - Customer Short Name
- Debit - The total debit amount
- Credit - The total credit amount
- Balance - The difference between debit and credit. Service charges are applied to this balance amount.
- Charge - The charge amount based on the balance and the interest rate.
- Rate - The interest rate used
- Misc. Charge Code - The miscellaneous charge code used when creating the service charges.
Service Charges Transaction Details -
- Invoice/Payment Number - Invoice number or Payment number
- Type - Type of transaction
- Debit - The debit amount
- Credit - The credit amount
- Due Date - The due date for the debit
- Assess Days - The due date plus the number of grace days
Notes
- Service charges are applied per customer per accounting period
- Will only pickup invoices and debit/credit memos that are registered
- Using the as of date on a non-open accounting period will return zero result
- All fields are read-only fields except for the Include field
Proofing
The end results of running the service charges are debit memos created for the accounting period.
To proof the work, one can run the Customer Statement report and/or the Invoice Proof report.
Notes and Limitations
- No support for customers that have super and child relationship.
- No way to excluded disputed invoices
- The debit memos are not "Invoice Update" and "Invoice Registered"
- The un-applied and on-account has a cutoff based on the as of date
- The cutoff is based on the as-of date (not period end, etc).
- No records are found if the targeted period is not open or doesn't exist.