Question

Customer Order / Invoice - VAT Calculation in SQL for Order Amount Summary

Userlevel 2

+2

Does anyone know what the SQL is that is being used to build the “Order Amounts” Totals Section on the “Customer Order” page, please?

I’ve looked at the Entity that from the Debug Window but it is CUSTOMER_ORDER and this SQL:

SELECT * FROM IFSAPP.CUSTOMER_ORDER

doesn’t show any summaries.

I assume it’s done in a view but that view doesn’t seem to be identified in the Debug Window as a separate View.

Thanks,

Craig.

Userlevel 3

+6

Hi Craig,

you could use the functions (e.g. Get_Ord_Gross_Amount, Get_Ord_Total_Tax_Amount, etc.) from the package CUSTOMER_ORDER_API.

They take in the order_no as parameter and give you the amount back.

BR

Golo

Sign up