Odd behavior with VBAFE and draftPurchaseOrders API
Using a 24A instance and noticing something odd with the draftPurchaseOrders API in VBAFE. I don't know if it did this before or not, because I hadn't tried to do this before.
I need to query all incomplete change orders and resubmit them, due to a hiccup with the retroactive price update that left some change orders in incomplete status.
First odd thing, even though I'm using the header level resource only, don't even have the line level layouts in my workbook, the worksheet is bringing back multiple lines for the same PO and change order number.
Worse, it will frequently fail to find any results at all. For example, I query on change order status starts with incomplete, PO starts with prefix used by client, supplier name equals XYZ, and find nothing, 0 results. I know from looking in UI and database that I have records with this combo; and if I remove the "change order status" field and query, I find results. If I add the value for change order status back in--after a successful query round--then I get results again. IE, the exact same query that found 0 results, finds results again only after