Prime Overdue Explanations

Owned by Leon Kontny (Unlicensed)
Last updated: Nov 25, 2021 by Nino Ryschawy

Workflow

  1. Upload CSV or bank transaction file in last Settlementrun dependent on configured option → see Debt management options
  2. Show all debts in Menu → Overdue debts → Debt list
  3. Clear a debt manually or upload new bank transaction file



Clear a debt manually

  1. Go to the Contract via Debt list → Debt → Contract in Breadcrumbs → Billing or directly via Contract → Billing
  2. Click on 'Create debt' and chose the debt that shall be cleared in the first field
  3. Enter the amount the customer has paid with negative sign
  4. click on save



Debt management options

You can configure your NMSPrime instance to manage overdue debts / outstanding customer payments by one of the following 2 ways by editing /etc/nmsprime/env/overduedebts.env in your NMSPrime VM.

Note: If you already use your financial accounting software to create dunning letters and you import the bank transaction file to that software you would have the same work of assigning transactions with bad transfer reason to your customers. In this case option 2 does better suit for you.


Bank transaction file (MT940)

Configuration

/etc/nmsprime/env/overduedebts.env
DEBT_MGMT_TYPE=sta

Description

This way the settlement run will create a debt for every customer. It automatically closes the created debt by another debt if the customer has a valid SEPA mandate.

On uploading the bank transaction file of the format MT940/Swift NMSPrime tries to clear open debts or creates new ones if the direct debit failed. A logging tab shows all infos, errors and warnings of the assigned or not assigned transactions - e.g. if the reason of transfer didn't contain the invoice number.

NOTE: all manually done customer transactions need to have the invoice number in its reason of transfer.

(Refer to the internal page Dunning Design Decisions for the reasons of this design decision)

CSV

Upload resulting debt list as CSV from financial accounting software

Configuration

/etc/nmsprime/env/overduedebts.env
DEBT_MGMT_TYPE=csv

Description

Only the imported debts will be shown in NMSPrime

CSV Format

The CSV to upload must contain the infos in the following format:

column nr0123456789101112
general headline/datacustomer nr


voucher nrdate
amount
missing amountdescriptiondunning date

dunning indicator

EuroFiBuKundennummer(Kürzel)(Anrede)(Name)BelegnummerBelegdatum(Skontodatum)Betrag(Skonto)AusstandTextMahndatumMahnkennung
DATEV exportKontonummer(Kurzbezeichnung)(Anrede)(Name)Rechnungs-NrRechnungsdatum(Fälligkeit)Betrag Soll(Skonto in Prozent)SaldoBuchungstextMahndatumMahnstufe
Color meanings
column must contain data
column can be empty - data could be used in future