on 01-28-2019 6:51 AM
Is there a Report or CDS View that can give details of list of Journal Entries billed as part of specific billing document/invoice
Hi Roshini,
I am not sure if you already found a solution to your problem statement, but, I assume you must have already explored the cube that is based on the Journal Entry Item CDS view- I_JournalEntryItemCube
This view is based on the database table ACDOCA
Further more, we have another view I_ActualPlanJournalEntryItemCube(based on the database table ACDOCA and ACDOCP), which provide access to plan data (FinancialPlanningEntryItem CDS view) in addition to most important business entities, such as G/L account, company code, cost center or profit center. The CDS view also contains all balance carry forward postings.
The CDS view also contains all balance carry forward postings. We also have an app based out of this view, which is called P&L- Plan/ Actuals App
These views certainly hold the attributes that you’re looking for.
Let me know if this make sense to your effort.
Thank you! Amith Nair
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jeroen,
Thank you for the response.
Actually I am looking for a Report/App/CDS View which can give following.
Example: Posted say supplier invoice say for 100 USD . Later did billing of the same. Then I need to basically report out in detail the costs which was billed i.e.
Expense P&L G/L account
Journal Entry Number
Journal Entry Type
Journal Entry Created By
Journal Posting Date
Transaction Reference Number that's fed in Supplier Invoice Header
WBSE
Personnel Number
Amount Billed in Global Currency
Regards
Rohini Pillai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rohini,
In the app 'Manage Journal Entries' the billing document number is available in the field 'Reference'. You can add this field to the filter and find the journal entries for a certain billing document. Only thing is that the field uses leading zeros, so a billing document can be found like '0090000001' .
hope this helps,
Jeroen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.