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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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