Skip to Content
avatar image
Former Member

How to calculate due date from invoice date and payment terms

Hi,

I Have a requirement of creating FIAR Ageing Report, in that i want to calculate Due date and based on that due date we can populate value un ages

For doing that first i need to calculate Due date based on invoice date and payment terms.

customer         Invoice date   Payment Terms   Due date      

  0001               01.12.2014        R007                01.01.2015    assume here payment term for customer is 1 month

0002                10.12.2014        R003                25.12.2014    assume payment term is 15 days

like that i need to get due date based on payment terms and invoice date for customer.

Pls let me know how to calculate due date based on these whether to calculate at transformation or at r/3 side or at query level.

pls do in favour to rectify this issue and if there is any code pls let me know.

Thanks in advance.

Seshu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 04, 2015 at 06:30 AM

    Hello Sesha,

    Its going to be a tough one if you want to calculate due date based on invoice date and payment term. Instead I wud recommend you another work around. 0fi_ar data source automatically calculates net due date at the extractor level itself for all the accounting documents. Do a look up in your reporting cube to bring in the net due date of the corresponding invoice document for all the AR document.

    Let me know your feedback

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Seshu

      You need to enhance a field net due date in your extract structure  (if you do not have such field ) and write a code in the exit EXIT_SAPLRSAP_001.I cant help you with the exact code.

      Regards

      Gajesh