This content has been marked as final. Show 4 replies
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.1 person found this helpful
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!