SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Pre-Invoicing Balance

former_member221838
Participant
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

View solution in original post

2 REPLIES 2

Former Member
0 Kudos

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

0 Kudos

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