This discussion is archived
4 Replies Latest reply: Feb 23, 2010 1:37 PM by 653449 RSS

How to get Accounting Date in Reception's Transaction in PO

653449 Newbie
Currently Being Moderated
Hi All,

I'm working with the custom report that needs to show the details of receptions in PO. The point is that a need the field accounting_date.
I can see this field when I'm on the Reception's in PO, when I choose the menu "View accounting". However, I don't know how relate the information in the table rcv_shipment_lines with the field "accounting_date".

When I use the examine option, this table appears XLA_AEL_SL_V, but in toad this table doesn't contain any records.

I have been looking for in these tables, ap_liability_balance or gl_je_lines, but I don't find the same value that I see in the form.

Please, help me!

Regards Mariano.-

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points