You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!