Share
Reportwhat the Relation between Financial Dimensions and inventtrans table in "add in" Excel ax 2012 ?
You’re offline. This is a read only version of the page.
40
what the Relation between Financial Dimensions and inventtrans table in "add in" Excel ax 2012 ?
its good but not get Financial dimension related to recalculation vouchers
Good morning Mena,
The issue is that there is no financial dimension tracked in the inventtrans table.
If you need this information then you have to check and link the related accounting vouchers via the generaljournalentry and generaljournalaccounting entry table.
Establishing this linkage is not straightforward and I don't think that you can do it in Excel with a simple Vlookup.
What makes things more complex is that inventory transactions are summarized based on their main account - findim usage. In this case you would have to look even into the subledger tables in addition.
Because of those and some other complexities, I think it is necessary to have some kind of development in case you want to analyze your inventory transactions based on some findims.
The only exception that comes to my mind would be using an item as financial dimension. Then you can track things easily in the trial balance and don't even need excel.
Best regards,
Ludwig
Hi Mena Atef,
Were you able to get the relation from the table I provided? Let us know if you need any more information.
Hi Dr. Ludwig,
I want a shared key in a table with financial dimensions and inventtrans table to make VLOOKUP in external Excel sheet
I want to know what the table and what is the key ?
Best regards,
Mena
Hi Mena,
That relationship is not that easy if you want to analyze the financial dimensions that have been used for creating the vouchers in your (general and sub-) ledgers.
Can you explain first for what purpose you need this information?
E.g. do you want to analyze item transactions by a region findim or something alike?
Best regards,
Ludwig
Hi Mena,
The dimensions for InventTransPosting come form table InventTransPosting. Here is a query which should give you the relation between these tables.
All responses (
Answers (
select DefaultDimnension from InventTTransPosting ITP
join InventTrans IT ON ITP.INVENTTRANSORIGIN = IT.INVENTTRANSORIGIN
You should be able to see two records per InventTrans record - one of posting type "Physical" and one for "Financial"
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156