on 01-04-2015 5:57 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello Seshu,
If you have customized datasource, then its better if you calculate the due date at the source level itself.
use the source exit by appending the required field in the extract structure . You can use the Function module DETERMINE_DUE_DATE to fetch the due date using the invoice date and the payment term.
Please check the blog below to understand AR in detail
Regards
Gajesh
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.