Bill only difference after adjustment reversal with different subtransactio

[former_member645257]

Hi experts,

I'm trying to define a rate that would be used only after adjustment reversal.

The client's requirement is that after doing an special massive adjustment reversal, next bill has to have a line billing a diferent concept for the adjustment, that is why it should have a different subtransaction. This could be a debit or credit operation.

On top of that, if the customer has to pay more for this adjustment (debit), the charge has to be divided into as many periods as the adjustment was.

Any ideas on the best way to approach this?

Thanks in advance,

Daniel

[Former Member]

You can use IF14 variant to see if there is any reversed billing document for the curretly billed period and if there is then write a flag for the next period in the installation facts.

Then test this fact with IF05 and start build your rate!

Hope it was helpful! Other wise provide more details to get more help

Daniel

[former_member645257]

Thanks Daniel, This can help. Now the problem is that I need access to the difference produced after the adjustment reversal. I haven't been able to figure that out.

Once I have this amount its has to be divided by as many periods, as the the adjustment was applied. I'm not sure how to get that either.

The scenario is as follows:

Prices can change with validity on dates already billed and invoiced. For example, bill exist with price A for jan, feb and march, say 10$, 20$ and 30$ respectively. New prices officialized in april are valid from february.

So I could just massively reverse billing for all customers (not sure if this is recomended) and the bill with new price B (new prices can be for energy, demand, rental and global price).

With new prices I have now a billing doc with:

-50$ for billing reversal

+30 feb

+40 mar

The difference is 20$ divided in 2 periods.

So in april and may bills I have to consider 10$ in a different revenue account.

Moreover I have to charge interest to the difference produced in each bill period, from the due date of the bill to the date of publication of the new prices.

Then another interest has to be apllied for every share from price publication date to due date of new bills that consider a share.

I'm considering creating a new FICA document with event R402 due to interest calculation purpouses.

If you thing of anything else that can help on covering this scenario, I would be greatly thankful.

Thanks,

Daniel Valenzuela