Modifying Billing Line Items at Invoicing

[Former Member]

Hi,

I am working at a project and currently we have a requirement where we want to waive off a charge that is being calculated by billing at invoicing based on a certain criteria. We are trying to use exit R405 but we are unable to change the amount to zero or make the line item non-posting relevant.

Does anyone know a clean way to do this such that based on a condition, the billing line item is either updated to have 0 amount or to be non posting relevant?

[william_eastman]

Hesham:

You cannot modify the billing lines as they have already been created and stored in the billing document. You can process this exception using rate configuration, or you can post offsetting document within event R402.

regards,

bill.

[Former Member]

Thanks Bill.

Can you please explain what you mean by rate configuration? Basically, what we have is a Climate Charge Levy which gets applied depending on a condition on ALL installations/contracts under Contract Account. We are currently using exit R405 where we check on the condition and if it is satisifed, we are trying to remove the posting relevant flag for the billing item that was calculated in billing or change its amount to zero.

Can you explain the concept of offsetting document with R402? An example will be very much appreciated.

[Former Member]

Can you not do it during billing? Is this condition verifiable only after all the contracts/installations have been billed?

[Former Member]

The condition is based on the Daily Average Consumption which is calculated acorss all contracts under Contract Account and hence the need to assess at Invoicing. In brief, I am looking for a way to either set the line for the surcharge to either zero or to be non-posting relevant and hence it does not change the total at invoice and get posed to FICA.

[former_member600295]

I tried to do something similar, but never got it to work. we developed a manual process that runs after the invoice is simulated. the process creates manual doc's with the appropriate amounts.

but being a manual process we decided rater than using the current information, post the charges/credits as an adjustment to the previous month's consumption if the charges are applicable.

if you can use one period previous you can addit tot he billing schema, and it will become automated, but will show as an adjustment to the previous month.

[rajesh_popat3]

Hi,

As mentioned earlier, you can create a New line item using EVENT R402 offseting the blling line item that you want to make it as non-relevant.

A new FICA document would get created that would be posted along with the invoice document.

For details, please have a look at the description details for event R402. (You need to include the details for deep structure T_VKK_DOC_ID for ID N).

Hope this helps!!

Regards,

Rajesh Popat

[Former Member]

Hi,

The description details on event R402 are not very clear. Can you give some guidance how this works and what values need to pass?

Thanks .

Regards,

Hesham

[rajesh_popat3]

Hi,

As it would be creating a new contract account document, you need to decide on the main/sub and GL details under which you want your new charge to appear as.

For details, just look at the details for sample FM "ISU_SAMPLE_R402" and its documentation.

You need to pass the entries to structure N_FKKOP and N_FKKOPK using the form UPDATE_VKK_DOC_ID and it would take the values from the two structure and update the table T_VKK_DOC_ID with ID as N and new consecutive no.

Pass on the values to the two structures and call the form routine to update the T_VKK_DOC_ID.

Hope this helps!!

Regards,

Rajesh Popat

[Former Member]

Did you look at FQEVENT R970? This will allow you to delete certain items based on your criteria. There is no documentation but the sample function module is self-explanatory.