Skip to Content
avatar image
Former Member

BPC 10.1 NW (BW 7.5 SP05) : integrating number of days overdue receivables data into BPC

Hello BPC experts,

I would like to integrate the number of days overdue receivables information into BPC. I haven't seen any topic about that, if there is one, please send me the url.

To be more accurate, what data I need to obtain looks like the following :

Not past due

By less than 30 days

By between 30 and 60 days

By between 60 and 90 days

By between 90 and 180 days

By more than 180 days.

These number of days must always be calculated according to the last day of a fiscal year. In this case, that would always be according to calendar, so the 31st December.

I know that BEx does this with 0FIAR_C03_Q0005. However, the customer wants to consolidate these data as well and uses Input form for their non-SAP entities.

Therefore, I would need a new Dimension (we can call it "OVERDUE") with 6 members (referring to the example above : not past due, less than 30 days, etc.).

What can be done to retrieve these data into BPC ?

Thank you in advance for your help,

Dat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 29 at 05:01 PM

    First of all, please explain what BPC are you using: standard or embedded?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 29 at 06:08 PM

    You can import transaction data with dates as integer and then perform calculations in the BPC badi...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your answer.

      I need to wait for some decisions of the higher-ups before...