Косяк виртуальной компании в Dynamics AX 2009 - Описание

Filed under: Microsoft DynamicsAX 2009, Microsoft Dynamics AX 2012Vals | September 6, 2012 @ 23:01 (Views: 2050)
There is problem with ledger accounts balances – there isn’t any records in balance tables. And this affects several parts of AX functionality – especially several standard financial reports. After investigation I come to conclusion, that this is side effect of virtualization of standard views (LedgerBalances, LedgerBalancesDim, LedgerBalancesDimTransDeltaSum and LedgerBalancesTransDeltaSum). All views handle virtual data area list internally => output records DataAreaId’s are only real company extensions. For example if there is one shared record in LedgerBalancesTransDelta table: Dynamics AX 2009 Virtual companys Then through LedgerBalancesTransDeltaSum view you got 6 records with real companies extensions: AX2009 And if this view (LedgerBalancesTransDeltaSum) is virtualized through table collection (and virtual companies + table collection setup), then you got from view empty result, because virtualization adds one more outside “where” condition DataAreaId = “vrt” For checking this concept I created duplicate view from LedgerAccountView. As this new duplicated view LedgerAccountView2 is not virtualized, it shows all necessary records: Microsoft Dynamics AX 2009 Virtual tables Therefore, please remove all standard views from table collection AMA Common_Tables: Microsoft Dynamics AX 2009 Microsoft Dynamics AX 2009 Virtual tables Возможное решение, надо проверить: https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyxupyzqpouxnxspsyqvtkvtqqzsmtnykx Если кто-то встречал эту проблему или проверял это решение - напишите здесь. Спасибо!

Leave a comment