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!
XLA_AEL_SL_V is a view from XLA which provides View Accounting support for different Subledgers like AP, AR etc.,
So identify the Vase Tables associated to XLA_AEL_SL_V and find the corresponding column.
The problem is that when I open the script that links with this view appear many fields and in the "from clause" says "FROM DUAL WHERE 1 = 2 /* Always Fail */". A partner have told me that the "accounting_date" is the same like "transaction date" in transaction reception.
But I don't know if it's true.
You can use the rcv_transactions.transaction_date for this purpose. Every receiving process contains two steps: 'receive' and 'deliver'. Whilst Receive represents the supplier to staging transaction, Deliver does the staging to main inventory process. You can select the transaction_date value of either of these records, based on your requirement.
Let me know, if this works or not.
You are partial right. Because what you told me is correct. However, there are many cases apart of that in which you need to see the accounting_date in "view accounting" option in the Journal account. This is when you have an expense of the products that are not stockeable.
I found that accounting_date is in rcv_receiving_sub_ledger table, but I have a problem with a performance query. But I will find the solution on my own.
Thanks for all!