Need to pull the posting periods on all layers of transactions off of drop ship sales orders. I can get them all except the vendor bill. Is there a smarter way to get around NetSuite's limitation on joins performed too many layers deep? I can pull the VB document number and amount from Apply Transaction : Billing Transaction and Applying Transaction : Billing Transaction Amount.

Have you considered using analytics instead?

They're looking for a scheduled alert, so I don't think that'd fit the bill. I think we're going to go a different direction, though.