[jessie Contributions: 0Level 1☆]

Business Goal – Scheduled saved search that will find any return authorization where the Drop Ship checkbox is not set to true.

Challenge: The Drop ship (isdropship) field is not displayed in either the Criteria or Results tabs of the saved search.

Would anyone know how to build a saved search to find RA’s with drop ship <> true?
This is a cached copy. Click here to see the original post.

[KCSF Bud Contributions: 0Level 1☆]

I don’t know for sure if you mean Vendor RAs or customer RAs, but I can think of no clean way to do this for Customer RAs. Vendor RA probably is more reasonable, could just use criteria that the Custom Form for the Created From record is the drop ship PO form.

For customer RAs, if you are OK with custom fields then I would recommend making a Drop Ship checkbox on your sales orders. Then set that field whenever a drop ship PO is created (simple script, can help if you need). That, of course, would assume that SO to PO is a 1 to 1 ratio (no items on the SO that are not drop shipped) or at the very least would mean that the SO has at least 1 drop ship PO attached to it. Once you get that field set, use that as created from criteria on the RA search. Would also have to go find all existing SO drop ships (saved search) and mass update.

Might be some other creative way to get there using the Applying Link Type/Applying Transaction joins, but it seems like a multi-level join is probably needed (not an option).

Hope that helps in some way.

[jessie Contributions: 0Level 1☆]

KCSF Bud

​The is a customer Return Authorization (RA). The challenge is while the Vendor Return Authorization VRA automatically picks up the PO is a drop ship, the RA does not. If you forget to check that little box on the RA, then the item goes back inventory. 🙁

Thanks for the confirmation that it is not each to resolve. I think your idea about custom field on the sales order is the best solution as it is as close to 1 to 1 as you get. The drop ship check box would have to traverse from the sales order to the cash sale or invoice.

Thank you!

[KCSF Bud Contributions: 0Level 1☆]

Jessie,

I am curious, so it is forcing a manual check of the Drop Shipment box on item receipts? Our experience would show that Netsuite recognizes, at a line level, which items on that RA are drop shipped. Testing one just now, that box is actually read-only for us. I searched for any Item Receipts created from drop-ship-RAs w/GL impact, and do not find any. Not sure what the difference may be. I do seem to recall that it was important that those RAs are created from the Sales Order (as opposed to the Invoice).

Also, let me add that you can get to the field value on that RA via scripting as well – nlapiGetLineItemValue(‘item’,’isdropshipment’,1). Can’t see any way to show that in a search.

[jessie Contributions: 0Level 1☆]

We create RA’s from cash sales and invoices for two reasons. First is the cash sale properly pushes the credit card p/ref information and second because while unlikely it is possible the cash sale/invoice could have a different amount than the sales order.

I think your idea about the custom field may work.

[Author]

Posts