04-06-2009 7:07 AM
Hi Guys,
I need to calculate percentage discount to be rebated for each prepayment customer.
For this I need pre-invoicing amount balance for each prepayment customer.
I found function module:
'ISU_SIMULATION_PERIOD_BILL', to which I can pass contract, FROM date , TO date and billing run number (i.e. 01).
And I think below field should return pre-invoice balance (if not please suggest right field):
Y_BILL_DOC - IERCHZ - NETTOBTR (include - ERCHZ_I3).
But, because of some reason I am not able to test this function module.
Also I am not sure whether my approach is correct or not.
Please guide for the same, any other solution regarding pre-invoicing balance will be really helpful.
-
Kind Regards,
Nikhil J.
04-06-2009 7:55 AM
You can use this fm to get the net amount and you can use the field NETTOBTR.
Just now i have tested the same and it's working fine.
Regards,
Siva
04-06-2009 7:55 AM
You can use this fm to get the net amount and you can use the field NETTOBTR.
Just now i have tested the same and it's working fine.
Regards,
Siva
04-15-2009 9:33 AM
Hi Nikhil,
You can try the FM "ISU_GET_PREV_BILL_CONTRACT_BAL" This Function will only work with a sorting key that calculates SUBT - line items on the contract level. Otherwise the previous Balance amount will be calculated w/o taxes.
With Regards,
Sunil