Use Excel VBCS to query invoice listing based on Invoice Line and Distribution values
Summary: We are using the /fscmRestApi/resources/11.13.18.05/invoices/describe end point and able to use query filter on Invoice level (and are pulling in Invoice Lines and Invoice Distributions). We are wanting to use the Invoice Lines and Distribution fields in the parameters on the main query. For example, Only show invoices where invoice Distribution.IncomeTaxRegion <> Blank. The size of this result would be massively less than running wide open. How to best use the child / related objects in the main query using Excel VBCS ?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):