Collection Due Date on Payments Terms

Options
Lynethdeguzman
Lynethdeguzman
edited December 2023 in Modeling

Hi All,

I need help on calculating the due date on payment terms, below is the given example:

Input Data:

Amount: xx

Time Dimension: Quarterly

Due Date (Line Item): Week 6 FY24 (Format: Week)

Report:

Amount: xx

Time Dimension: Week 6 FY23

Can you please help me on this?

Thank you,

Lyneth

Answers

  • Dikshant
    Dikshant
    edited December 2023
    Options

    @Lynethdeguzman,

    The only difference in the two modules is the time scale. Input Module is at the quarter level, and Report Module is at the week level.

    Use SUM function in Report Module to get the numbers from Input Module.

    Try it out and let me know if you need more details.

  • Lynethdeguzman
    Lynethdeguzman
    Options

    @dikshant,

    Thank you for the quick response.

    LOOKUP formula did not work on my part. But I already figured it out, I used the POST function.

    Regards,

    Lyneth

  • Dikshant
    Dikshant
    Options

    @Lynethdeguzman, Can you also share your solution and make it an answer for others to look at in the future?

  • Lynethdeguzman
    Lynethdeguzman
    Options

    @Dikshant

    I can gladly share the solution here.

    Firstly, the LOOKUP function cannot capture the data I want because the system was looking only on the same time dimension and at the same time it cannot lookup on line items(format: time period).

    To further explain, below are the blueprint view I made to fix the problem:

    1.) Created the "Amount" to avoid the spread of amount within the quarter of the week and fix it on the "First week of the Year?

    2.) Calculated the date difference between the weekly line item on the Quarter module and converted it to Week number

    3.) Then I connected the formula on POST function as shown below.

    image.png

    I hope it was clear, you can leave a comment if you have any questions.

    Regards,

    Lyneth

Categories