cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP CPQ - How to declare the formula about the Item Extended Amount and the total amount

samuelconceicao
Participant
0 Kudos
724

Hi Experts,

I have a lot of custom fields that will be filled or manually inputed in the item (item custom fields) as you can see in the image bellow... (2) and (3) values..

I want to Add item (2) in the list price and decrease the value of the field (3) and calculate the Extended Amount in the item...

Maybe in the future I will need to Add the item's IVA only in the Total Quote (5).

Does anyone know how to control the formula of item (4) and (5) to considere or not a especific field??

Thanks a lot =]

Accepted Solutions (0)

Answers (2)

Answers (2)

MaxGag
Participant

Hello,

You need to create custom calculation and make it run after the OOTB formula. The extended amount field can be found on Quote.MainItems object and the total can be found on Quote.Total.

See documentation:

Custom calculation: https://help.sap.com/viewer/884885f05e6b4c8082254d4d9d63f19b/2103/en-US/522a78ec4fed4a2da279e681fc25...

Cart field administration: https://help.sap.com/viewer/884885f05e6b4c8082254d4d9d63f19b/2103/en-US/2c14a01f258f49d1b6dd61f626e9...

Thanks

samuelconceicao
Participant
0 Kudos

Hi Maxime, thanks for your answer.. I tried it, but I dont find a way to write the formula or declare both fields (header Total amount and field total amount.. How can I get the custom Field in the screen, for example like i said

I Cant get the Custom Field.. For exemple..



Create a DESC1 - But this field need to the the item custom field of the screen.. I dont found how to declare or define the sintaxe to use that field like item custom field, even when the field is in the screen, in the card field calculation it doesnt works when I populated the field manually..

So.. 1. I created a register in "Develop >> Custom Quote Calculations"

How can I get the item custom calculation???

The item custom field: Z_Desc1

This sintax above doest works, and I've tried a lot of different ways and doesnt works too.

By the way I incluthe this new custom calculation in the "Cart Field adminsitration" but nothing happening, I think because the formula I've wrote is wrong...

But how in Cart Field adminsitration Will I declare the field to add in amount or not, or maybe mutiply or not?

Thanks