How to Change Subtotal Calculation In Freight Costs Form With Forms Personalization
Last updated on DECEMBER 23, 2017
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
How can the subtotal calculation in the Freight Costs form with a forms personalization to achieve the following:
-Want to take the Amount column and the FlexField column which is used for absorbed costs and sum the value of those into the Subtotal field.
-With the current functionality, the Subtotal field only sums the Amount column. The Subtotal field is in the freight_costs_control block in the field subtotal_freight_cost.
-The following query shows the desired output.
SELECT SUM (UNIT_AMOUNT) + SUM (ATTRIBUTE1) "Subtotal"
WHERE TRIP_ID = XXXXXX;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms