What's new in version 23.300.100847.0

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

Enhancements/Modifications

The Drink-IT Contract Management has been rebranded to Aptean Beverage Contract Management, Drink-IT Edition.

Features

PBI No.Description
225991Create loan pay out journal line
226879Rental agreements
228499Rent categories
230780Rent charges in purchase transactions
232799Create rent invoices
235405Loan card factbox to documents
235852Fixed assets (activated Loan in use)
236665Loans - Annuity and interest invoices
236680Loans - initial pay back status loan lines (New or On Hold)
236689Loans - Pay back by depreciation
239027Loans - Source details and salesperson/purchaser
241589include Ext. Doc. No in Loan pay back jnl
239208Include the attachment part to CMG FactBoxes
241606Open Loan pay back journal from loan list
242847Customer loan statement- Continue - 3
242242Add Contract No. to Condition Rule (SPC for CMT)
241920CMG Periodic Settlement - Include Loan in SPC Rule and Settlement (SPC for CMG) - Copy

Create Rent Invoices

PBI 232799 - Create Rent Invoices What Create Rent Invoices. Why As a beverage company, you can have objects (buildings, parts of a building, a kiosk etc.) where you deliver to. Contract-bound and free objects, owned by you or by others. An object can have a renter that is your direct or indirect customer. As a finance manager, you want to be able to create and send invoices for the agreed rent, additional periodic costs and incidental costs for these objects, so you are able to manage the agreements in an efficient way.

Resolves issues

PBI No.Description
236677Loans - Wrong initial Next Pay Back Ending Date
236715Loans - Suppress Bill-to/Pay-to should also work for sales document
238604Bad Loan lines with Pay Back period Year
238608Wrong payment method in loan pay back journal line

PBI 225991 - Contract Management - Create Loan Pay Out Journal line

What

Contract Management - Create Loan Pay Out Journal line

Why

You agreed a loan with a customer and you pay out the loan amount.

As a finance manager, you want to be able to create the pay out journal line from the loan card, and follow up on the entries that are created for that loan, so you can do your work in an efficient way.

How

In the Contract Management Setup, you can define a journal template and a journal batch that the system will use when loan pay out journals are created:

  1. Select the Search icon , enter Contract Management Setup and then choose the related link.
  2. On the Contract Management Setup page, on the Loan FastTab, select a template in the Pay Out Journal Template field and a batch in the Pay Out Journal Batch field.

From the loan page, you can create the payout out journal:

  1. Select the Search icon , enter Loans and then choose the related link.
  2. On the Loans page, select, or create as New, the loan you want to create a pay out journal for.
  3. On the Loan page, choose the Create Loan Payout Journal Lines action.
  4. On the Create Loan Pay Out Journal lines request page, fill in fields as necessary, and choose OK.
  5. Choose the Loan Pay Back Journal action to open the journal and finish the payment.

PBI 226879 - Rental Agreements

What

Rental Agreements

Why

As a beverage company, you can have objects (buildings, parts of a building, a kiosk etc.) where you deliver to. Bound and free objects, owned by you or by others. An object can have a renter that is your direct or indirect customer.

As a finance manager, you want to be able to register the agreed rent, additional periodic costs and incidental costs for these objects, so you are able to manage the agreement in an efficient way.

How

With the Rental Agreement card, you manage information about a rent with a customer or vendor. You can specify the details of the agreement and from here you can also drill down on past and ongoing transactions for the rent.

  1. Select the Search icon , enter Rental Agreements and then choose the related link.
  2. Choose the New action to create a new entry.
  3. On the Rental Agreement page, fill in fields on the General FastTab as necessary. Hover over a field to read a short description.
  4. On the Address & Contact FastTab, you can select a Contract Object that is connected to the rental agreement. It will update the other fields on the FastTab with the information for that object, but you can change them for this rental agreement.
  5. On the Rent Lines FastTab, you can create lines for recurring amounts by selecting Rent Categories and entering the periodic amount to invoice in the Line Amount field. You can adjust fields for the line as necessary. Hover over a field to read a short description.
  6. On the Rent Charge Lines FastTab, you can register one-off charges, like a reparation, that you want to charge to the renter. Select a Rent Category and enter the amount to invoice in the Line Amount field. You can adjust fields for the line as necessary. Hover over a field to read a short description.
  7. On the Purchase Charge Lines FastTab, you can see lines that are created by posting purchase invoices that are charged to this Rental Agreement. You can adjust fields for the line as necessary. Hover over the field to read a short description.

PBI 228499 - Rent Categories

What

Rent Categories

Why

Rent categories define your different rent types. They specify the details for invoicing and posting. When you create lines in rental agreements, you can select such a category and use it as a template for the line.

How

  1. Select the Search icon , enter Rent Categories and then choose the related link.
  2. On the Rent Categories page, create codes as necessary.
  3. Fill in fields as necessary. hover over a field to read a short description.

In Aptean Beverage Contract Management, there are three types of Rent Categories:

  • Rent: codes with this type are charged periodically, like a monthly rent or quarterly energy advance.
  • Rent Charge: codes with this type are one-off charges, like a reparation that you want to invoice to the renter.
  • Purchase Charge: codes with this type are one-off charges from purchase invoices that you charged to a rental agreement.

PBI 230780 - Rent Charges in Purchase Transactions

What

Rent Charges in Purchase Transactions.

Why

As a beverage company, you help your customers with services. These services can be rental agreements for premises. A part of your service is that you pay invoices, related to rental agreements. But these costs are not always at your expense. The renter should pay them. The full amount, or a percentage of the amount.

As a Finance Manager, you want to be able to register, with a percentage, that a purchase cost has to be charged to a rental agreement, so these costs do not impact our profits and losses and you are assured that they will be included in an invoice to the renter.

How

  1. Select the Search icon , enter Purchase Invoices and then choose the related link.
  2. Create a purchase invoice as normal.
  3. In the Lines FastTab, select a category in Rent Categorie field. Fields that are related to the rent charge will now be shown in the page.
  4. Select the Rental Agreement where you want to charge the purchase cost to in the Rental Agreement No. field.
  5. The Charge to Customer % and Charge to Customer Amount fields are by default filled with the value that was setup in the Rent Category, but you can change both fields as necessary in the purchase line.
  6. Choose the Post action to finish the process:
  7. An accrual is posted to the general ledger for the amount that is charged to the rental agreement. This posting uses the Rent Accrual Account (Debit) and the Rent Accrual Balance Account (Credit) from the Rent Category.
  8. A new line is created in the Purchase Charges Lines FastTab of the rental agreement that you selected in the purchase invoice. With the next rent invoice for that agreement, the amount will be charged to the customer.

PBI 232799 - Create Rent Invoices

What

Create Rent Invoices.

Why

As a beverage company, you can have objects (buildings, parts of a building, a kiosk etc.) where you deliver to. Contract-bound and free objects, owned by you or by others. An object can have a renter that is your direct or indirect customer.

As a finance manager, you want to be able to create and send invoices for the agreed rent, additional periodic costs and incidental costs for these objects, so you are able to manage the agreements in an efficient way.

How

Setup the Number Series for Rent Invoices

Rent invoices have their own numbering. which makes it possible to recognize them as rent invoices in an easy way:

  1. Select the Search icon , enter Contract Management Setup and then choose the related link.
  2. On the Contract Management Setup page, choose number series that you want to use for the unposted and posted invoices in the fields on the Rent FastTab.

Create a Rent Invoice for one Rental Agreement

  1. Select the Search icon , enter Rental Agreements and then choose the related link.
  2. Select the Rental Agreement where you want to create an invoice for.
  3. On the Rental Agreement page, choose the Create Rent Invoices action.
  4. On the Create Rent Invoices request page, fill in fields as necessary and then choose the OK button to create the invoice.
  5. This action will create a sales invoice with lines for:
  6. Rent Lines with the Rental Line Status New or Ready to Invoice and a Next Invoice Starting Date that is before the Invoice to Date on the request page.
  7. Rent Charge Lines where the Rental Line Status is New.
  8. Rent Charge Lines where the Rental Line Status is New.
  9. This action will create one invoice per Customer Posting Group, as set in the rental agreement lines.

Create Rent Invoices in batch (under construction)

  1. Select the Search icon , enter Create Rent Invoices and then choose the related link.
  2. On the Create Rent Invoices request page, fill in fields as necessary and then choose OK to create the invoices.
  3. Sale Invoices and Sales Lines are created per Rental Agreement, according to the same criteria as the invoice creation for one agreement:
  4. Rent Lines with the Rental Line Status Ready to Invoice and a Next Invoice Starting Date that is before the Invoice to Date on the request page.
  5. Rent Charge Lines where the Rental Line Status is New.
  6. Rent Charge Lines where the Rental Line Status is New.
    One invoice per combination of Customer and Customer Posting Group.

PBI 235405 - Contract Management - Loan card factbox to documents

What

Contract Management - Loan card factbox to documents.

Why

Users want to be able to find and view all posted and unposted sales documents for a loan, like interest invoices and periodic discount credit memos created for pay back.

How

Select the Search icon , enter Loans and then choose the related link.
Be sure the Bill-to Customer Sales History fact box is enabled in the list page or card page. View the icons showing the number of documents for Invoices, Credit memos, Pst. Invoices and No. of Pst. Credit memos and drill down to view them.

PBI 235852 - Contract Management - Fixed Assets (activated Loan in use)

What

Contract Management - Fixed Assets (activated Loan in use).

Why

Companies facilitate outlets with equipment, with refurbishments that are activated through a fixed asset. It is wanted to link the fixed asset to the outlet and report depreciation and other results of the fixed asset on the outlet.

How

Select the Search icon , enter Fixed Assets and then choose the related link.
On Contract Management FastTab, select

  • a customer in field Customer No.
  • a salesperson code in field Salesperson (defaulted from the customer)
  • an object in field Customer Object No. (filtered by the customer no.)
  • a contract in field Customer Contract No.

Notice default dimensions are updated from the customer and salesperson.

View the linked fixed assets in field No. of Fixed Assets on the Customer card, Salesperson/purchaser card, Contract Object card and Contract card.

PBI 236665 - Contract Management - Loans - Annuity and interest invoices

What

Contract Management - Loans - Annuity and interest invoices.

Why

When you want to charge interests on annuity loans, you can:

  • create journal lines where the interest is based on the scheduled interest amounts in the loan lines.
  • create periodic loan interest invoices, based on actual loan balances.

Both options are now supported in Drink-IT Contract Management.

How

Scheduled interest amounts

  1. Select the Search icon , enter Loans and then choose the related link.
  2. on the Loans page, select a loan or create as new.
  3. On the Loan page, select the Annuity checkbox.
  4. In the Interest Invoice Type field, select None.

The journal lines for the interests will be created with the Create Loan Pay Back Journal Lines action on the Loan page, or when you run the Create Loan Pay Back Journal Lines batch job.

Periodic loan interest invoices

  1. Select the Search icon , enter Loans and then choose the related link.
  2. on the Loans page, select a loan or create as new.
  3. On the Loan page, turn on the Annuity toggle.
  4. In the Interest Invoice Type field, select a period for the periodic loan interest invoice.

The invoices for the interests will be created with the Create Loan Interest Invoices action on the Loan page, or when you run the Create Loan Interest Invoices batch job.

PBI 236680 - Contract Management - Loans - initial pay back status loan lines (New or On Hold)

What

Contract Management - Loans - initial pay back status loan lines (New or On Hold).

Why

Loan lines represent the schedule for the pay out and the pay backs for a loan. When a pay back schedule is in place, then lines with the Pay Back Status New will be included in the creation of Pay Back Journal Lines, as long as they are within the date range for these batch jobs. Lines where you have set the status to On Hold will never be included in these batches.

In some cases, you probably want to create the loan lines directly with the On Hold status, so are sure they will be skipped in the Create Loan Pay Back Journal Lines batch and the Create Loan

PBI 236689 - Contract Management - Loans - Pay back by depreciation

What

Contract Management - Loans - Pay back by depreciation.

Why

Your loans with customers can be paid back in different ways. You can for instance collect installments with a direct debit, or by periodic bonuses that you agreed with the customer. But you can also have loans that are not paid back at all. In that case, you might want to post periodic depreciations to the loan, like with a fixed asset. Would the contract be ended before the contract end date, the remaining loan balance can become due at once.

As a finance manager, you want to be able to include loans where depreciations to these loans are included in periodic batches, so you can do your work in a correct and efficient way.

How

On the Loan Categories page, you can specify the G/L Account you want the system to post the loan depreciation to:

  1. Select the Search icon , enter Loan Categories and then choose the related link.
  2. On the Loan Categories page, select the G/L Account in the Loan Depreciation Account field.

On the loan card, you can setup a loan for scheduled depreciation:

  1. Select the Search icon , enter Loans and then choose the related link.
  2. On the Loans page, select, or create as New, the loan you want to setup for scheduled depreciation.
  3. On the Loan page, in the Pay Back section of the Loan Details FastTab, select Scheduled Depreciation in the Scheduled Pay Back Type field.

From the loan card and loan list, you can create the pay back journal lines.

  • Choose the Create Loan Pay Out Journal Lines action from the Loan Card page to create journal lines for a specific loan.
  • Choose the Create Loan Pay Out Journal Lines action from the Loans list page to create journal lines for multiple loans.

PBI 239027 - Contract Management - Loans - Source details and Salesperson/purchaser

What

Contract Management - Loans - Source details and Salesperson/purchaser.

Why

With the Loan Card you manage information about a loan with a customer or vendor. With this release, we added additional information to the card:

  • Customer details
  • Bill-to Customer details
  • Salesperson
  • External Document No.

How

  1. Select the Search icon , enter Loans and then choose the related link.
  2. on the Loans page, select the loan for which you want to see the details and then choose the View or Edit action.

PBI 241589 - Contract Management - include Ext. Doc. No in Loan Pay Back jnl

What

Contract Management - include Ext. Doc. No in Loan Pay Back jnl.

Why

On the loan card, you already could register an External Document, a reference to your customer's registering system. This reference is now included in pay back journal lines that you create for the loan. This is useful information, for instance when you collect the pay back with a direct debit.

How

  1. Select the Search icon , enter Loans and then choose the related link.
  2. On the Loan Card page, register the reference in the External Document on the General FastTab.
  3. Choose the Create Loan Pay Back Journal action and fill in fields as necessary on the Create Loan Pay Back Journal lines request page.
  4. Verify the reference in the External Document No. field in the journal lines that are created. The field is by default not visible, but you can add it with Personalize your page.

PBI 239208 - Include the Attachment part to CMG FactBoxes

What

Include Attachments to Contract Management FactBoxes.

Why

As a contract responsible, you want to be able to attach documents and files to agreements that are part of contracts, so you can access all relevant information from one point.

How

In Microsoft Dynamics 365 Business Central you can manage attachments, links, and notes on cards and documents. In Drink-IT Contract Management, this functionality is also available. And when documents are attached to a loan, rental agreement or contract object, you can choose to flow that document to the customer contract where it is connected to.

  1. Select the Search icon , enter Loans, Rental Agreements or Contract Objects and then choose the related link.
  2. On the relevant list or card page, choose the open details for documents action in the Attachments section of the FactBox.
  3. On the Attached Document page, select a file as necessary. Select the Flow to Contract field to make the attachment visible on the connected customer contract.
  4. Choose the Search icon , enter Customer Contracts and then choose the related link.
  5. Select the contract where your attachment is flowed to. In the Attachments section of the FactBox, you can see the number of documents that are attached to the contract by origin (loan, rental agreement, object or the contract itself). Choose the open details for documents action to view the attachments.

PBI 241606 - Contract Management - open Loan Pay Back journal from Loan list

What

Open the Loan Pay Back Journal from the Loan List and Loan Card.

Why

As a finance manager, you want to be able to open a loan back journal for pay back that you just create from a loan card page, so you can do your work in an efficient way.

How

  1. Select the Search icon , enter Loans and then choose the related link.
  2. On the Loan List page, select the loan where you created a loan pay back journal for, or open the Loan Card page for that entry and then choose the Loan Pay Back Journal action.

PBI 242847 - Customer Loan Statement- Continue - 3

What

Customer Loan Statement.

Why

As a contract manager, you want to send loan statements to customers, stating the opening balance, the net changes and the end balance of the capitalized loan entries. For loans with an interest invoice, this document already serves as a statement. But when you also have loans without periodic interest invoices (annuity, loans without interest, loans paid back by periodic discounts...), you want to be able to send a statement to the customer.

How

  1. Select the Search icon , enter Loan Statements and then choose the related link.
  2. On the Loan Statement request page, fill in fields as necessary and then choose the Print or Send to... action.
  3. Alternatively, you can choose the Loan Statement action from the loan list or loan card to create a statement for a specific loan.

PBI 242242 - CMG Contract Management - Add Contract No. to Condition Rule (SPC for CMT)

What

Sales and Purchase Conditions relation with Contract Management Contracts.

Why

As a beverage company, you have agreements with your customers. This agreement can be registered in a Drink-IT Contract Management Contract.

Part of such contracts are the sales conditions. They are mentioned in the contract document. As a sales manager, you want to be able to trace the condition rule to the contract.

How

  1. Select the Search icon , enter Sales and Purchase Condition Rules and then choose the related link.
  2. On the Sales and Purchase Condition Rules list page, edit, or create as new, the rule you want to connect to a contract.
  3. On the Sales and Purchase Condition Rule Card page, on the Contract Management FastTab, select the contract in the Contract No. field. You can only select a contract for rules with the Source Type Customer or Vendor.

Once the contract number is selected on the rule:

  • New and existing Condition Ledger Entries (Sales and Purchase) will show this value in the Contract No. field.
  • The Condition Periodic Settlement Journals will show this value in the Contract No. field.

PBI 241920 - CMG Periodic Settlement - Include Loan in SPC Rule and Settlement (SPC for CMG) - Copy

What

Sales and Purchase Conditions relation with Contract Management Loans.

Why

As a beverage company, you have agreements with your customers. Part of this agreement can be a loan that you registered in a Drink-IT Contract Management Loan.

A possible pay back method for such a loan is pay pack by periodic discounts. As a sales manager, you want to be able to connect a periodic discount rule to a loan, so the settlements for that rule will be applied to the loan amount that was given to the customer.

How

  1. Select the Search icon , enter Sales and Purchase Condition Rules and then choose the related link.
  2. On the Sales and Purchase Condition Rules list page, edit, or create as new, the rule you want to connect to a loan.
  3. On the Sales and Purchase Condition Rule Card page, on the Contract Management FastTab, select the loan in the Loan No. field. You can only select a loan for rules with the Source Type Customer or Vendor.

PBI 236677 - Contract Management Loans - Wrong initial Next Pay Back Ending Date

What

Contract Management Loans - Wrong initial Next Pay Back Ending Date.

Why

When Pay Pack journal lines were posted for a period, the Next Pay Back Ending Date on the Loan Card was not updated correctly. This is solved.

PBI 236715 - Contract Management Loans - Suppress Bill-to/Pay-to should also work for sales document

What

Contract Management Loans - Suppress Bill-to/Pay-to should also work for sales document.

Why

When the Bill-to/Pay-to on a Loan is different from the Source No. on that loan, the warning "customer has another Bill-to customer" or "vendor has another Pay-to vendor" should not be shown when the "Suppress warning" field is selected on the customer or vendor card.

PBI 238604 - Contract Management - Bad Loan lines with Pay Back period Year

What

Contract Management - Bad Loan lines with Pay Back period Year.

Why

When your loan was setup with Pay Back Period Type Year, then the lines that were created by the Create Loan Lines action were not correct. This is solved.

PBI 238608 - Contract Management - wrong payment method in loan pay back journal line

What

Contract Management - wrong payment method in loan pay back journal line.

Why

When general journal lines were created by the Create Loan Pay Back Journal Lines action, the Payment Method in the lines were filled with the value from the customer instead of the one from the loan. This is solved.