Navigation:  Debtor Functions > Debtors Transfer Settlements >

Results

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Add

When the  button is clicked, the invoice selected in the "Invoices" list box is added to the "Settlement" grid.

hmtoggle_plus1Add All

When the  button is clicked, all the invoices in the "Invoices" list box is added to the "Settlement" grid.

hmtoggle_plus1Apply

The user must have a security profile linked to the function Debtor Transfer Settlements with an access allowed of Change.

 

BUSINESS RULES WHEN ADDING A DEBTOR SETTLEMENT:

 

1.  The debtor line link and bank transaction/credit link must exist.

2.  The sum of all the settlements must not exceed the available bank transaction amount/credit link amount.

 

When adding a debtor settlement a debit journal is created for the debtor account for the settlement amount and a credit journal is created for the bank account for the settlement amount When the "Apply" button is clicked the following updates are performed:

 

1.  The system validates that the amount to apply is not less than zero and the amount to apply does not exceed the available amount.

 

2.  It inserts the invoice number, line, link capture date, bank code, bank transaction date, settlement amount , settle by invoice number, settle by line number, settle by capture date,  into the Debtor Settlement table for each link in the list.

 

3.  The date settled on the Debtor Settlement table is the source timestamp for the settlement journals.

 

4.  After a successful apply, the "Apply" button is disabled, the "Invoices" list box is cleared and the available amount is set equal to the nett amount (available amount - apply amount).

hmtoggle_plus1Available Transaction Amount

This field displays the amount that is available on the selected bank transaction. (Unapplied Amount)

hmtoggle_plus1Apply Amount

It is the total value (settlement amount) of all the lines in the "Settlement" grid, as the lines might have been adjusted per individual line.

hmtoggle_plus1Base Apply

hmtoggle_plus1Base Available

hmtoggle_plus1Display

When the option "Settled Invoices" is selected and "Display" is clicked, all the settled invoices for the selected customer are displayed in the "Invoices" list box.

 

When the option "Unsettled Invoices" is selected and "Display" is clicked, all the unsettled invoices for the selected customer are displayed in the "Invoices" list box.

hmtoggle_plus1Fluctuation Records

hmtoggle_plus1Foreign Apply

hmtoggle_plus1Foreign Available

hmtoggle_plus1Remove

When the  button is clicked, the invoice selected in the "Settlement" grid is removed.

hmtoggle_plus1Remove All

When the  button is clicked, all the invoices in the "Settlement" grid are removed.

hmtoggle_plus1Reverse

The user must have a security profile linked to the function Debtor Transfer Settlements with an access allowed of Delete.

 

When a line(s) is selected and "reversed", a negative debtor settlement record is inserted in the Debtor Settlement table , similar to the previous settlement record.  Negative Settlement journals are processed

and the source timestamp is equal to the date settled on the Debtor Settlement table.

 

The selected rows are removed from the "Settlement" grid, the new totals are calculated and updated, and the "Reverse" button is disabled.

hmtoggle_plus1Settlement Grid

The grid is populated according to the invoices selected in the invoices list box on the left. The grid is populated with the invoice number, line number, total price, , settlement amount, outstanding amount  and type of link from the Debtor Settlement, Debtor Line Link, Column Values and Debtor Invoice tables where:

 

The settlement allocation is only suggested for invoices selected, the column value on the Column Values table is equal to type of link on the Debtor Line Link table, and The status on the Debtor Invoice table is Invoice Printed "I",

 

Specific links need to be selected to be settled. If an invoice needs to be partially settled then the settlement amount can be edited in the grid. When all the links are selected and edited as desired, the settlement can be completed by clicking the apply button.

hmtoggle_plus1Total Base Apply (Inc Fluc.)

hmtoggle_plus1Total Fluctuation Base