Add Pricing Information Fields to Desktop Orders
Show the pricing fields from the Penny Perfect Pricing (PPP) engine on desktop orders by adding the pricing fields to your order pages. To do this, use order UI extensibility.
Required Editions
Available in: Lightning Experience Available in: Enterprise and Unlimited Editions where Consumer Goods Cloud is enabled |
Keep these consideration in mind while adding pricing information fields to the desktop order UI.
- The pricing information fields are saved to the database automatically with the PPP calculation, even if you don't add the pricing information fields to the desktop order UI.
- There's no change to the default JSON configuration for UI extensibility.
To extend the desktop order UI with pricing information fields:
Modify the Custom JSON for order header and order items in Order Template, see Edit JSON in an Order Template.
Example
Here's an example of a custom JSON structure for an order header, including pricing information fields. You can use them as-is or modify the pricing fields as needed.
{"orderpageheader":[{"fieldApiName":"Order_Account__c","objectApiName":"Order__c"},{"fieldApiName":"Name","objectApiName":"Order__c"},
{"fieldApiName":"Gross_Total_Value_Receipt__c","objectApiName":"Order__c"},{"fieldApiName":"Gross_Total_Value__c","objectApiName":"Order__c"},{"fieldApiName":"Merchandise_Value_Receipt__c","objectApiName":"Order__c"},{"fieldApiName":"Value__c","objectApiName":"Order__c"},{"fieldApiName":"Total_Value__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_1__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_2__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_3__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_4__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_5__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_6__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_7__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_8__c","objectApiName":"Order__c"},{"fieldApiName":"Pricing_Info_9__c","objectApiName":"Order__c"},
{"fieldApiName":"Pricing_Info_10__c","objectApiName":"Order__c"},{"fieldApiName":"Order_Template__c","objectApiName":"Order__c"},
{"fieldApiName":"Phase__c","objectApiName":"Order__c"},{"fieldApiName":"CreatedById","fieldLabel":"INITIATOR","objectApiName":"Order__c"},{"fieldApiName":"Gross_Total_Value__c","isCurrency":true,"objectApiName":"Order__c"},{"fieldApiName":"Value__c","isCurrency":true,"objectApiName":"Order__c"}]}
Here's an example of a custom JSON structure for an order items, including pricing information fields. You can use them as-is or modify the pricing fields as needed.
{"orderItems":{"columnsConfiguration":[{"active":true,"ascending":true,"editable":false,"fieldApiName":"Product__r.Description_1__c","fieldType":"text","objectApiName":"Order_Item__c","order":1,"required":false,"sortable":true,"typeAttributes":{"maxLength":1300,"maximumFractionDigits":null},"visible":true,"width":"18%","maxWidth":"18%","minWidth":"18%"},{"active":false,"ascending":false,"editable":true,"fieldApiName":"Quantity__c","fieldType":"number","objectApiName":"Order_Item__c","order":2,"required":false,"sortable":true,"typeAttributes":{"maxLength":null,"maximumFractionDigits":0},"visible":true,"width":"6.5%","maxWidth":"6.5%","minWidth":"6.5%","textAlign":"right"},{"active":true,"ascending":true,"editable":false,"fieldApiName":"Product__r.Category__c","fieldType":"text","objectApiName":"Order_Item__c","order":3,"required":false,"sortable":true,"typeAttributes":{"maxLength":1300,"maximumFractionDigits":null},"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%","isFilter":true,"isPickList":true},
{"active":true,"editable":false,"fieldApiName":"Price__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Price_Receipt__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Value_Receipt__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Base_Price_Receipt__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Special_Price__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},{"active":true,"editable":false,"fieldApiName":"Pricing_Info_1__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},{"active":true,"editable":false,"fieldApiName":"Pricing_Info_2__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},{"active":true,"editable":false,"fieldApiName":"Pricing_Info_3__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_4__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_5__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_6__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_7__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_8__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_9__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},
{"active":true,"editable":false,"fieldApiName":"Pricing_Info_10__c","fieldType":"number","objectApiName":"Order_Item__c","order":3,"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},{"active":true,"ascending":true,"editable":false,"fieldApiName":"Product__r.Criterion_3_Product__r.Name","fieldType":"text","objectApiName":"Order_Item__c","order":4,"required":false,"sortable":true,"typeAttributes":{"maxLength":1300,"maximumFractionDigits":null},"visible":true,"width":20,"maxWidth":154,"minWidth":122,"isFilter":true},{"active":true,"ascending":true,"editable":false,"fieldApiName":"Product__r.Consumer_Goods_Product_Code__c","fieldType":"text","objectApiName":"Order_Item__c","order":6,"required":false,"sortable":true,"typeAttributes":{"maxLength":1300,"maximumFractionDigits":null},"visible":true,"width":"10%","maxWidth":"10%","minWidth":"10%"},{"editable":false,"fieldApiName":"Product__r.GTIN__c","fieldType":"text","objectApiName":"Order_Item__c","order":7,"required":false,"sortable":true,"typeAttributes":{"maxLength":80,"maximumFractionDigits":null},"visible":true,"width":"10%","maxWidth":"10%","minWidth":"10%"},{"editable":false,"fieldApiName":"UoM__c","fieldType":"text","objectApiName":"Order_Item__c","order":8,"required":false,"sortable":true,"typeAttributes":{"maxLength":50,"maximumFractionDigits":null},"visible":true,"width":"10%","maxWidth":"10%","minWidth":"10%"},{"active":false,"ascending":false,"editable":false,"fieldApiName":"Order_Item_Template__r.Name","fieldType":"text","objectApiName":"Order_Item__c","order":9,"required":false,"sortable":true,"typeAttributes":{"maxLength":50,"maximumFractionDigits":null},"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%","isFilter":true},{"editable":true,"fieldApiName":"Discount__c","fieldType":"number","objectApiName":"Order_Item__c","order":10,"required":false,"sortable":true,"typeAttributes":{"maxLength":null,"maximumFractionDigits":2},"visible":true,"width":"6.5%","maxWidth":"6.5%","minWidth":"6.5%","textAlign":"right"},{"editable":true,"fieldApiName":"Special_Price_Receipt__c","fieldType":"number","objectApiName":"Order_Item__c","order":11,"required":false,"sortable":true,"typeAttributes":{"maxLength":null,"maximumFractionDigits":2},"visible":true,"width":"6.5%","maxWidth":"6.5%","minWidth":"6.5%","textAlign":"right"},{"editable":false,"fieldApiName":"Base_Price__c","fieldType":"number","objectApiName":"Order_Item__c","order":12,"required":false,"sortable":true,"typeAttributes":{"maxLength":null,"maximumFractionDigits":2},"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"},{"editable":false,"fieldApiName":"Value__c","fieldType":"number","objectApiName":"Order_Item__c","order":13,"required":false,"sortable":true,"typeAttributes":{"maxLength":null,"maximumFractionDigits":2},"visible":true,"width":"8%","maxWidth":"8%","minWidth":"8%"}],"fixedColumns":2,"maxNumberUpdates":1000,"defaultTab":"AllItems","hierarchicalSearch": false}}Did this article solve your issue?
Let us know so we can improve!
