![]() ![]() ![]() *** A wider discussion here would be why Dynamics GP doesn’t update all the SQL tables (transaction table and summary table) using one SQL transaction which would negate this issue however that is beyond of the scope of this article. This can cause problems and prompt awkward conversations with clients as they (understandably) ask “why” this is the case, and (even worse) how they can prevent this in the future. ![]() if you were to manually sum the transaction data it wouldn’t match the summary data. Unfortunately if there is an issue when posting a transaction “sometimes” the summary values aren’t updated and therefore they become “out of sync” with the actual transaction data i.e. you could 10 million rows of transactional data for this GL code but its all nicely summarised into a handful of rows in the summary table.Īs I mentioned this provides fantastic performance however anyone who has worked with Dynamics GP for any length of time will realise the one issue that comes with storing data in this way. What’s great is as this window is accessing a summary table rather than summing and sub totalling the main transaction table the performance is great, so you have access to summary data very quickly. For example below is a GL enquiry window showing the GL period balances for a cash account. This means you can quickly access the summary values in an enquiry window. For example the GL open years transactional data is stored in one table (GL20000) and its summarised in a summary balance table (GL10110). Now this is one area of the system that I really like about Dynamics NAV and Dynamics 365 Business Central so I thought I’d write this up.ĭynamics GP stores summary values in a variety of different summary tables. Much like myself the person asking the question came from a Dynamics GP background and was wondering where in the database Dynamics 365 Business Central stored summary values i.e. There was an interesting conversation on twitter over the weekend with regards summary values and Dynamics 365 Business Central. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |