Check OrderItems with missing Voce Fatturabile and Configure them

PHOTO EMBED

Fri May 12 2023 07:48:56 GMT+0000 (Coordinated Universal Time)

Saved by @atsigkas

PS. IF you change a product's structure in PROD, don't forget to do it also in Davinci cause in a future migration/deploy via IDX, it will be overriden again.

________________________________________________A_________________________________________________
select id,product2.Name, vlocity_cmt__OneTimeCharge__c, order.Offer_Name_CPQ__c from orderitem where vlocity_cmt__OneTimeCharge__c !=0 and vlocity_cmt__OneTimeCharge__c != null and Cod_Voce_Fatturabile__c ='' and CreatedDate = TODAY

________________________________________________B_________________________________________________
select Product2.Name,Product2.ProductCode,Id, Codice_Robinson__c, Bene_Servizio__c, Cluster_Commissioning__c, Codice_Prodotto_Neta__c, Cod_Voce_Fatturabile__c, Costo_di_acquisto__c, Gross_margin__c
from OrderItem 
where ID in 
(
'8027U000009DskAQAS'
)
order by Product2.Name	
limit 1000

________________________________________________C_________________________________________________
select Name,ProductCode
from product2
________________________________________________D_________________________________________________
select id,Product__r.name,Product__r.ProductCode, Product__r.Tipo__c, Product__r.Costo_di_acquisto__c, Product__r.Gross_margin__c, Service_Component__r.Codice_Prodotto_Robinson__c, Service_Component__r.Voce_Fatturabile_Net__c 
from Associazione_Product_Service_component__c 
where Product__r.name like 'Impianto Fotovoltaico'
________________________________________________E_________________________________________________

select id,name,vlocity_cmt__PicklistId__r.Name from vlocity_cmt__PicklistValue__c 
content_copyCOPY

A. Run the query and check the miss-aligned OrderItems B. Paste the ID of OI from (A) and check all the important fields C. Check based on the ProductCode the Name of the Product2 D. Search based on the name if there are any existing Associazione_Product_Service_component__c E. Then you can open the OrderItem-> Go to Order -> Go to Quote -> Find the QLI and finally check the Attribute Selected Values JSON F. Finally, open the Enrichment Matrix and check if the Product is configured correctly G. Probably will need to change the override of attributes from : Product2->Structure H. LAST but not least Update OrderItems from Data Import