Energy and Non-Energy Charges

[Former Member]

Hi Guru's,

I have a requirement like, I am collecting energy charges and Non-energy charges but thing is client is asking to give the separate report for Energy and Non-energy charges. Can you please help me on this how to over come my solution.

Ex: The below items already adding in Invoice with Consumption amount.

Line Item	Rs.
1. Installation Charges	100.00
2. Security Deposit Rs.	1200.00
3. Supervision charge	400.00
4. Cost of service line	100.00
5. Estimation Charges	200.00
6. Application Fee	0.00
7. Meter Rent	0.00
8. Meter Cost	0.00
9. MCB/Cut out Charges	0.00
10. Adv. Energy Charge	0.00
11. Fix Charge	0.00
12	0.00
Meter and Service Removal	0.00
Charges/Any other charge,	0.00
if any	0.00
13. Meter Testing Charges Rs. 0.00	0.00

Thanks,

Abbas

[rahul_paldiwal2]

Hello Abbas,

Are you guys using BI for reporting if yes you can use Statistic Groups to break down the consumption charges... You can find more information about the same under SAP Utilities > Contract Billing > Integration Reporting

Regards,
Rahul

[AmlanBanerjee]

Hi Shaik,

I guess all the indiviual line items that you have mentioned will be having a separate entry in table DBERCHZ1 against the billing document with a particular sub-transaction.

To keep it simple, Can you segregate the energy and the non-energy charges based on the sub-transactions.

Hope it helps...

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks for the reply,

What i feel is if customer make payment in cash desk along with Energy+ Non energy charges how system knows which is Energy and which is Non energy? If it is clearing rule which rule i have to map for this to overcome?

Thanks,

Abbas

[Former Member]

Hi Guru's

Thank you for your reply,

Here The Business is asking to book Energy Payments for 1 Bank GL and  Non-energy payments for other Bank GLs.

Now both Energy and Non-energy Payments being posted in 1 Bank GL, how to map 2 individual Bank accounts in above scenario. Please help me.

Thanks,

Abbas

[ivor_martin]

Hi,

If you are posting to different G/L Account/s per charge type, you could have custom clearing logic in the Clearing function module FKK_SAMPLE_TFK115.

You can introduce logic to first obtain the amounts related to the respective Profit & Loss G/L Account/s from table DFKKKO and then sort the amount/s according to your desired clearing sequence.

Then you can clear the items.

Note: You would have to add your custom function module in your Clearing Variant in screen field  V_TFK115-FUNCC (Field name FUNCC).

I hope this helps.

Regards,

Ivor

[Former Member]

In order to segregate Energy and Non Energy charges you have the following options depending on what you need to do in the subsequent processes (e.g clearing, reporting).

1. You can use different amount statistic groups in the schema. This will tag each charge with a amount statistic group and you can use the amount statistic group in reporting (BW or ABAP)

2. You can use summarization subtransaction (FI-CA posting area R410 - transaction FQC0). In standard all billing subtransactions are posted on the SAME FICA subtransaction (0020 for debit and 0010 for credit). Using Posting area R410 you can actually assign the billing subtransactions (the ones you define in the schema) to different FI-CA subtransactions. In your case you can have a separate set of FI-CA subtransactions call Non-Energy (0030 and 0040 for example). When you post the invoice to FICA you will actually see the 2 BP items for each invoice, one item for all energy charges and one item for all non energy charges. You can then use this in clearing or other subsequent FICA processes (for example you can apply different dunning procedures, interest clearing algos, etc).

Hope this helps.

Daniel

http://sap-isu.net

[Former Member]

Hi Guru's

Thank you for your reply,

Here The Business is asking to book Energy Payments for 1 Bank GL and  Non-energy payments for other Bank GLs.

Now both Energy and Non-energy Payments being posted in 1 Bank GL, how to map 2 individual Bank accounts in above scenario. Please help me.

Thanks,

Abbas

[former_member199650]

Hi,

Please confirm whether you are posting both the Energy and Non-Energy Charges through the same billing document and Invoicing document?

If yes, then their Sub-Transactions must be different (both CST and DST) at schema level.

When the billing document is created, it will contain both the Energy and Non-Energy Charges as line items (tables DBERCHZ1 (BELNR with BELZART (shows the line item type) and BELZEILE (line item no.)) and DBERCHZ3 (BELNR with BELZEILE for NETTOBTR (amt of the particular line item))).

Mentioned table will help you for reporting purpose.

If at the time of payment, when you want to clear the posted invoice amount, it does not get cleared on the basis of line items, instead it gets cleared based on document no. (as per my knowledge).

Thanks and Regards

MP Vashishth

[former_member199199]

Hi Shaik,

You can try this -

In the FQEVENT 110, on top of the existing code of creating clearing entries, you can have a customised code.

At the end of standard code, in the event the GL accounting entries of the clearing document will be populated in the table T_FKKOPK which would be the bank clearing GL that you would provide in the header or that item of the payment lot.

In order to split the amount, refer the incoming structure of FKKOP (cleared item) and determine the split amount. And then assign the split amount in the table T_FKKOPK_NEW.

So, in your case, if you configure bank GL#1 in payment lot configuration, the T_FKKOPK would have

document number | item | Amount | GL

                                0001  300.00   GL#1

And, you will have to create T_FKKOPK with below

document number | item | Amount | GL

                                0001  200.00    GL#1

                                0002  100.00    GL#2

Have a try.

Please do not change T_FKKOPK as the changes is discarded in the calling code of event 110.

Let us know how you go.

Regards,

Bodhisattwa

[Former Member]

Hi Vashishth,

Thanks for your valuable information,

Yes reporting point of view its oky but  my intention is how to segregate Payment in two Bank GL accounts through Standard function? is there any chance to get the solution even Custom also? Please help me.

Thanks,

Abbas

[william_eastman]

I dont see any way to enable this - the payment bank account is known well before the receivable to clear is chosen.  I think that you would need to post them on separate bills with separate bank data given so that the customer remits them separately.