Collection Due Date on Payments Terms

Lynethdeguzman · 2023-12-22T01:08:58+00:00

There was an error rendering this rich post.

Lynethdeguzman

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

Accepted answers

All comments

Dikshant

@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

@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

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

Lynethdeguzman

@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.

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

Regards,

Lyneth

Quick Links

Can you help?

Unanswered questions

Action to copy data from one version to another version only for a specific module
Ideally, I would like to setup an action that can copy data from one version to another only for a specific module. For every new version I create, I import new data into certain modules and then I manually copy data over for a specific module. I am wondering if I can just setup an action to select an origin version,…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…