Merative Ideas Portal

Shape the future of Merative!

We invite you to shape the future of Merative, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the Merative team to refine your idea

Help Merative prioritize your ideas and requests

The Merative team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at Merative works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at Merative, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Merative External Privacy Statement: https://www.merative.com/privacy

Add a new idea Subscribe
Status Future consideration
Categories Social Program Management Platform
Created by Guest
Created on Apr 21, 2020

RELATED IDEAS

Financials - next processing date calculation for payment instruments

Problem:

For a case with a Financial Component with due date as 27th December 2020, the next processing date is getting set as 23rd December (which is due date - offset. Offset is set as 4) even though December 25 and 26 are marked as exclusion dates under Financial Calendar (EFT).




Requirement/Expectation:

In the given scenario the next processing date should be set as 18 December 2020 as there are two bank holidays in between which will impact the payment process. 18 December '20 is obtained by calculating Due date - (offset+number of bank holidays/weekend days in between, inclusive of due date).

The requirement can be summarised as next processing date cannot be on a holiday or on a weekend day. Also there should be 4 (offset) working days from next processing date to due date.

While analysing further it was observed that 'Generate Instruction Line Items' batch does perform a preprocessing based on the Financial calendar exclusion date only if the next processing date is falling on an exclusion date. This feature is not sufficient to cover the above mentioned requirement.

Customer Name Scottish Government
  • Attach files
  • Guest
    Reply
    |     Jul 24, 2020

    Hi Avinash,

    We have reviewed your enhancement suggestion. Based on the information provided, our understanding of your request is as follows:
    In order for a payment to be processed on the payment due date, when calculating the next processing date to be set on a financial component, the offset from due date needs to consider non-working dates and therefore offset using working dates only.

    The theme is aligned with our current multi-year strategy for our product and has been accepted as a consideration for a future release. We will in the future look at how we can either deliver this requirement or support you in achieving this requirement.

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.
    Regards,
    Shane McFadden, IBM SPM Offering Management team

  • Guest
    Reply
    |     Jul 6, 2020

    Hi Shane,

    The requirement is offset for payments should be working days and not calendar days. The due date is the date by which the amount should be credited in the target bank account. The offset day count is set for this project considering the time taken to process the payment instruction by other systems to which SPM system sends the payment instruction details. Those systems are responsible for crediting the amount to the target bank account. Since SPM is considering offset as calendar days , the other systems that process the payments will not be able to credit the amount by due date if there are public holidays between the next processing date and the due date.


    Thanks
    Avinash K Nair

  • Guest
    Reply
    |     May 26, 2020

    Hi Avinash,

    We notice that you are mixing up the different features available, so in order to evaluate your request, we require that you provide more detail so that we can fully understand your requirements.

    There are two different concepts being referenced in this enhancement request:

    1. Financial Calendar exclusion dates
    The exclusion dates in the financial calendar are to indicate dates on which the batch payment processing can’t be executed and therefore any payments that fall due on these dates need to be picked up and incorporated into the current execution of the payment processing. Note that we do not assume payment processing cannot run on a weekend as depending on what is used at the customer site, they may have scheduling tooling that can automate to schedule the payment batch processing over the weekend without the need to have someone present. Therefore if payment processing cannot operate on weekends, these would need to be entered and specified as exclusion dates also.

    2. Payment Offset Periods
    This is a mechanism to incorporate additional processing time ahead of a payments due date, if there is time required to complete a business process for issuance of payments. The reason for this offset is not something that we have clear requirements on and therefore whether there needs to be personnel present to progress the payment processing. Perhaps it is automated to take the output from SPM Financial processing and interface to another separate system that issues the payment. There is an assumption in this enhancement request that there is manual involvement in here and therefore the offset must be working days.
    Can we get more insight into what is required in this offset period?

    Note that these two are completely separate. The offset period does not use the payment exclusion calendar at all and was not intended to, as described above these have separate purpose. We want to just make sure we are completely clear on the requirement and therefore we can evaluate if/how best we can support it.

    Is the requirement to ensure that the offset period applied when calculating the payment next processing date considers working dates only?


    Thank you,
    Shane McFadden, Cúram SPM Product Management team

  • Guest
    Reply
    |     Apr 21, 2020

    Hi Avinash,

    Thank you for your enhancement request.
    We require some further analysis to determine whether or not this enhancement can be considered in a future release.
    I will provide another response when our investigation is complete.

    Thank you,
    Shane McFadden, Cúram SPM Product Management team