What's new in version 20.202301.0.0

Contract Management for Drink-IT  •  Release Note  •  7/6/2023  • 

Application

PBI No.Description
235596Apply entries should split journal lines by Loan No and Loan Entry Type - Part 2
235625Contract Management Loans - remaining points 2 - batch error log

PBI 235596 - Apply entries should split journal lines by Loan No and Loan Entry Type - Part 2

What

Apply entries in a general journal with split line per Loan.

Why

In Aptean Beverage, the Loan no. and Loan Entry Type are used to specify balances and net changes of a loan. It s important to

  • Apply entries by the same Loan and Loan entry type (capital vs non capital); and as a consequence
    • Report balances and net changes per loan
    • calculate interest over a loan

When applying open entries in a general journal by the Apply entries function, the user can set an ID to entries with different Posting groups, Loans and Loan Entry Types. In that case the journal lines should be split conform, as each journal line should contain the same posting group + Loan + Loan entry Type as the entries it is applied with.

How

Search for Contract Management Setup, FastTab Loan. Check field Apply Per Loan and Loan Entry Type (it will check in Foundation Setup field Apply per Posting group automatically as well when it was not on).

Search for any general journal, like the Cash receipt journal.
Select a customer that has open entries with Loans and Loan Entry Types. Fill in the amount that is paid. Click on the Apply Entries action, set an ID on all entries and close the page with [OK].

The journal line has now been split with a line for each posting group + Loan No. + Loan Entry Type that was selected, each line containing that combination. The document no. has been split as well in a sequential no (eg. BANK001-001, BANK001-002..) and the Applies-to ID in the selected entries has been set to that as well.
Post the journal and open entries will be all applied to the journal line with the conform posting group + Loan No. + Loan Entry Type.

The same for applying vendor entries.

PBI 235625 - Contract Management Loans - remaining points 2 - batch error log

What

Error Notification on running Create Loan Pay Back and Create Loan Interest Invoice batch jobs

Why

When for some reason (like the customer is blocked, the status of the loan does not allow for pay back...) a loan pay back journal line or loan interest invoice could not be created, it would stop on the first found error and not create any line or document.
It should continue for other loans and inform the user afterwards on the loans that caused an error.

How

Search for Loans and on the action bar, select Create Loan Pay Back Journal Lines. Run it for an As per Date, for all loans. When there are loans for which it could not create a journal line, a Notification will show. Click on the Details and see which loans and for what reason. Search for the general journal and see the lines for the other loans.

Search for Loans and on the action bar, select Create Batch Loan Interest Invoices. Run it for an Invoice to Date, for all loans. When there are loans for which it could not create an invoice, a Notification will show. Click on the Details and see which loans and for what reason. Search for sales invoices and see the ones for the other loans.