Skip to Content
Former Member
Jan 27, 2009 at 04:58 PM

Given Invoice#, find original Order#



maybe a simple thing but I can't seem to find any way to do this.

Say I have an OrderId for CartType 'O' that was delivered and invoiced already.

I can find the Delivery document in Webtools by joining on the Shipment/ShipmentDetails table, but I can't find the correspomding Invoice - as it's also just an Order with apparently no link back to even its delivery.

i.e in B1 given a Sales Order, I can find the Delivery Note, from this I can find the Invoice. But there doesn't seem to be any such facilty via Webtools?

Is it possible without having to create and maintain my own lookup table?