2015 Feb 19 11:24 AM
Hello Experts,
I have a requirement, it is FI interface where need to calculate CR ,Dr Amount.
Let say i have total 10 line items fora invoices... based on total amount i need to calculate if it is +ve amount it would be DR or if total amount is -ve than it would be credit... after calculating the amount i am generating an output file in XML format. in XML file if tolal amount i-ve it should not show the -ve amount.
Can anybody help me here... where to clear this filed.
Regards
Hello Experts,
I have a requirement, it is FI interface where need to calculate CR ,Dr Amount.
Let say i have total 10 line items fora invoices... based on total amount i need to calculate if it is +ve amount it would be DR or if total amount is -ve than it would be credit... after calculating the amount i am generating an output file in XML format. in XML file if tolal amount i-ve it should not show the -ve amount.
Can anybody help me here... where to clear this filed.
Regards
2015 Feb 19 12:58 PM
Did not understand your query. Could you please reframe it.
Thanks,
MAAUS.
2015 Feb 19 2:19 PM
Hi Aziz,
My requirement is let say in one invoice there are 10 line items, for every line item there is amount filed... it can be +ve amount in Debit case or -ve in credit case... i need to calculate the total amount of a invoice... if the total amount it -ve... than in the output file...which is in XML format... -ve amount should not be seen...
Let me know if some more details are required.
Regards.
2015 Feb 19 3:38 PM
Hi Anjana
If i get you right you must have an internal table with you line items(the +ve and -ve records).
You must then be looping at that table and summing the values. Once summed you check that value against the value you should have in your XML file...so i would suggest clearing the value of the invoice after you check it against the file value.
loop at lt_invoices assinging <lt_invoices>.
at end of <lt_invoices>-belnr.
*...check total value against XML
*...clear your variable here
endat.
lv_tot = lv_tot + <lt_invoices>-amount.
endloop.
regards
Prince Isaac
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |