Thursday, April 9, 2015

#391 BAM 12c --> Calculated Fields. Creation /Use of, in Business Queries

Very simple example here, based on the BAM example from post #389

Here I add a calculated field to the NCTestProcess DO -

Here is the expression -

I now go into Designer mode and create a new Business Query based on this DO -

Create a view based on the query -

Validate the results by doing a simple test -

Here I have an order for an iWay, whatever that is.
It's initial price is 1900. The discount of 10% will be applied.
That makes an end price of 1710.
Now VAT at 19% is applied to that, which gives us 324.9


No comments: