Skip to Content
0
Former Member
Dec 14, 2012 at 12:00 PM

ORDR and OINV

3036 Views

Hi All Experts,

At our client side it is not mandatory that they make Sales order then Delivery and then A/R Invoice.

At some case they do that and at some case they Don't.

Now My Problem is that I want to write Query where I want

  • DocNum of A/R Invoice
  • DocNum of Sales Order(if sales order is made for particular A/r invoice)

I am not understanding how to link ORDR and OINV to get my Requirement.

(I want query to be written in MS SQL Server management)

Please help me for this

Best Regards,

Gayatri Shukla.