How to fetch amount delivered on PO through SQL Query
We have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetched from table po_distributions_all. However, amount delivered column is having no value or zero, even when quantity delivered is more than one.
Can someone help with fetching the correct column for amount_delivered of a PO when quantity delivered is more than 1?
0