Prob with Incorporating the Security deposit in Energy bill

[Former Member]

Hi Exports,

Requirement  is

As per business requirement CSD (Cash Security Deposit) need to be incorporate in our company,s Monthly energy bill.

Current assessment year outstanding CSD amount should be shown in end of the energy bill, only for demand cases as “Outstanding amount of CSD as on bill date Rs................/”. And this outstanding amount should be added to total bill amount.

Once we received the amount from consumer against energy bill, need to clear the SD document 1^st and remaining amount should clear with the Invoice document.

Logic from FICA:

From DFKKOP table we can get all CSD open items for the current year based on below logic.

Pass the BP number in to DFKKOP table and check the document type is SD or not. If document type is SD then check the clearing status is Blank (Open item) / 09(Cleared Item) or not. If document type is SD and clearing status is Blank then check the posting is between current finical year or not.

If it satisfied above condition then fetch the amount form table and incorporate the value in energy bill form.

Logic from Billing:

Maintained Main and Sub transactions (0020/0020) in Item selection in invoicing (Sub items) through SPRO settings for showing the CSD open item in energy bill total.

Now problem is when we generate the invoice through T.code EASIBI One AM document is generating with combination of invoicing document, which should not be happen.

Please find the attached screen shorts for better understanding.

Note: I do not understand why that AM document is updating at the time of invoicing.

Please help me….

Regards,

Sri

[Former Member · Accepted solution]

Dear Friends,

got the solution... now problem is solved..................

...

Thanks,

Sri