Meta tags:
description=Posts about Debugging written by Vaidhy Mohan;

Headings (most frequently used words):

share, if, you, liked, it, gp, debugging, navigation, is, to, error, dynamics, archives, post, extender, window, add, issue, client, for, my, user, learn, discuss, menu, category, msdyngp, view, involving, form, strange, link, reason, web, rendering, some, facts, gp2013, purchase, invoice, inquiry, zoom, bug, change, syexcelreports, table, sql, server, native, 10, thanks, aaron, berquist, quick, tip, visual, studio, tools, developing, refresh, application, support, tool, sdt, where, custom, reminder, reminders, home, page, fixed, assets, depreciate, button, disabled, solution, infamous, sales, distribution, amount, incorrect, access, setup, gps, revokeuseraudit, 58, subscribe, blog, visits, search, categories, victory, directly, proportional, hardwork, vaidhy, mohan, verified, services,

Text of the page (most frequently used words):
window (95), new (76), opens (70), this (64), share (60), the (56), and (52), #dynamics (46), that (42), sql (41), not (41), microsoft (34), 2013 (28), you (27), for (26), user (23), with (22), email (22), was (22), extender (21), posted (21), linkedin (21), debugging (20), pinterest (20), tumblr (20), print (20), facebook (20), but (20), error (18), 2010 (18), troubleshooting (17), link (17), issue (16), like (15), now (15), client (14), support (14), when (14), any (14), continent (14), tools (13), administration (13), sdt (13), 2015 (13), are (13), 2012 (12), script (12), 2011 (12), 2009 (12), april (12), from (12), which (12), loading (11), windows (11), server (11), 2008 (11), native (11), field (11), one (11), vaidhy (11), mohan (11), more (11), message (11), would (11), there (11), your (11), get (10), name (10), mac (10), sales (10), table (10), customer (10), all (10), january (10), february (10), friend (10), liked (10), access (10), below (10), vaidy (10), had (10), web (9), company (9), information (9), 2016 (9), gp2013 (9), dictionary (9), august (9), october (9), may (9), did (9), what (9), form (9), have (8), other (8), picture (8), dexterity (8), december (8), july (8), 2014 (8), time (8), could (8), see (8), fields (8), line (8), shown (8), comments (7), view (7), log (7), update (7), services (7), studio (7), upgrade (7), system (7), tool (7), resource (7), open (7), maintenance (7), november (7), march (7), post (7), checked (7), something (7), about (7), check (7), description (7), found (7), setup (7), users (7), some (7), markdown (7), after (7), item (7), reason (7), just (7), how (7), comment (6), visual (6), stored (6), profiler (6), smartlist (6), management (6), security (6), dsn (6), dex (6), audit (6), september (6), only (6), module (6), since (6), create (6), then (6), whether (6), let (6), above (6), depreciation (6), will (6), menu (6), learn (5), discuss (5), blog (5), team (5), database (5), modifier (5), fixed (5), business (5), trails (5), june (5), select (5), find (5), procedure (5), without (5), solution (5), process (5), using (5), assign (5), number (5), wordpress (4), com (4), report (4), word (4), environment (4), syexcelreports (4), reporting (4), reports (4), programming (4), silverlight (4), profiling (4), document (4), reminders (4), purchase (4), product (4), office (4), odbc (4), nav (4), posts (4), page (4), 2018 (4), sp1 (4), gp2010 (4), google (4), assets (4), eone (4), net (4), list (4), david (4), crm (4), book (4), bit (4), msdyngp (4), 2017 (4), navigation (4), received (4), first (4), available (4), record (4), follows (4), tried (4), didn (4), records (4), distribution (4), invoice (4), got (4), start (4), button (4), here (4), custom (4), reminder (4), following (4), exactly (4), add (4), who (4), going (4), till (4), they (4), than (4), definition (4), started (3), reader (3), subscribe (3), year (3), application (3), conference (3), views (3), test (3), statement (3), queries (3), messages (3), code (3), sop (3), builder (3), sharepoint (3), service (3), based (3), order (3), processing (3), project (3), multi (3), exchange (3), technical (3), utilities (3), home (3), functionality (3), cookbook (3), bug (3), file (3), feature (3), day (3), erp (3), month (3), profile (3), musgrave (3), accounts (3), browsers (3), archives (3), consultant (3), revoke (3), also (3), thought (3), tables (3), opened (3), due (3), out (3), must (3), strange (3), amount (3), simple (3), upon (3), activity (3), where (3), disabled (3), depreciate (3), task (3), why (3), partner (3), isn (3), should (3), those (3), icon (3), sure (3), adding (3), additional (3), step (3), site (2), required (2), content (2), sign (2), subscribed (2), already (2), account (2), close (2), end (2), virtual (2), payroll (2), control (2), rollup (2), top (2), 100 (2), tips (2), technology (2), tech (2), requirements (2), procedures (2), designer (2), packs (2), architecture (2), sdk (2), debugger (2), roadmap (2), resources (2), receivables (2), professional (2), power (2), mavericks (2), operating (2), accounting (2), 365 (2), topic (2), features (2), named (2), modified (2), forms (2), events (2), mb3 (2), high (2), macbook (2), knowledge (2), base (2), jet (2), integration (2), manager (2), implementation (2), sp3 (2), drive (2), general (2), excel (2), solutions (2), dynamicsworld (2), awesome (2), developer (2), days (2), data (2), customizations (2), summary (2), convergence (2), intelligence (2), cloud (2), chunk (2), cashbook (2), bank (2), portal (2), apture (2), apple (2), safari (2), viewer (2), 2020 (2), search (2), rss (2), older (2), upgraded (2), thrown (2), exact (2), sequence (2), removed (2), option (2), wrong (2), second (2), says (2), explain (2), our (2), gps (2), revokeuseraudit (2), decided (2), purpose (2), consider (2), happy (2), reconcile (2), imbalance (2), take (2), backup (2), sop10100 (2), obvious (2), major (2), seriously (2), query (2), header (2), understand (2), ran (2), items (2), minutes (2), thinking (2), realized (2), stranded (2), creating (2), while (2), always (2), good (2), though (2), confirmed (2), into (2), stuck (2), results (2), reported (2), because (2), screenshot (2), highlighted (2), tricky (2), facing (2), has (2), almost (2), disbelief (2), assigned (2), irrelevant (2), wanted (2), opening (2), different (2), 1452 (2), try (2), ideally (2), part (2), very (2), people (2), made (2), possible (2), him (2), his (2), show (2), customers (2), does (2), refresh (2), immediately (2), effected (2), can (2), before (2), created (2), serious (2), contact (2), done (2), tip (2), debug (2), developing (2), leave (2), version (2), further (2), driver (2), stopped (2), aaron (2), berquist (2), use (2), dev (2), overlapping (2), next (2), fully (2), case (2), inquiry (2), zoom (2), icons (2), note (2), rendering (2), look (2), rendered (2), pictures (2), hours (2), addition (2), actual (2), confirm (2), retrieve (2), design, website, write, collapse, bar, manage, subscriptions, privacy, join, subscribers, workflow, wishes, vista, white, paper, wendy, neal, webinar, vss, vpc, visualisation, basic, machine, victoria, yudin, vba, vacation, manuals, interface, union, uncategorized, uae, uac, tfs, adoption, program, foundation, tap, direction, ssrs, ssms, ssas, scripts, operations, source, sod, smartphones, smartconnect, sharepointwendy, sba, sanscript, copy, saas, functions, rtm, reviews, writer, references, receivings, entry, reblogged, rdp, ram, pstl, crescent, library, advantage, releases, powerpivot, pop, poll, philosophy, personal, performance, penny, pdf, payables, parallels, packt, online, premise, ole, off, nokia, symbian, newsgroups, navision, mvp, tenant, currency, msdynamicsworld, mobile, migration, middle, east, specialist, door, airlift, connect, micr, metrics, memory, mekorma, 701, 700, mark, polino, reporter, sierra, macintosh, pro, lync, linux, lightswitch, kubuntu, kpi, express, intercompany, iis, ian, grieve, human, html5, hotfix, guest, grn, metadata, gp2016, gp2015r2, gp2015, sp2, chrome, ftm, frx, frank, hamelly, financials, financial, transfer, level, rate, econnect, dynamic, future, dynamicaccounting, dso, doug, attachment, documentation, assembly, generator, dex_row_id, ini, insights, decisions, dba, outstanding, science, dag, credit, cumulative, ctree, crystal, crossdomainerror, adapter, creator, count, consolidated, concepts, collections, coa, computing, creation, checklinks, charts, chart, certification, cbm, cbi, capslock, canada, budget, boxplot, books, review, blogs, reconciliation, average, pay, highlights, android, analytical, aio, adtp, adobe, addons, receivable, framework, conv12, categories, 2019, 271, 821, visits, full, verified, doting, husband, father, coffee, music, lover, travel, photography, hobbyist, tagged, faced, famous, left, remove, removing, set, contents, alone, itself, selected, installation, covered, under, license, installed, assumption, much, anywhere, licenses, cover, concluded, looking, said, surprise, joy, course, physical, launched, descriptions, intrigued, similar, object, naming, convention, mxcallrevokeuseraudit, rid, community, forum, yesterday, existing, minimum, receiving, each, clear, once, doing, frequently, maximum, months, revoking, working, issues, harmful, again, caused, zero, abnormal, situation, yes, most, baffling, thing, mishap, cleared, sop10200, thru, none, contained, problem, requires, contain, seemed, entered, stop, running, edit, corresponding, seeking, help, clearing, posting, popped, infamous, incorrect, its, brainy, certainly, took, contains, three, index, display, fa40203, last, printing, quite, analysis, temporarily, initiated, retain, complete, able, run, sent, box, red, routines, somebody, same, lost, hair, bring, peace, tested, utter, chance, totally, answer, these, questions, doubt, checking, else, altogether, dic, realise, referring, whose, nothing, inside, production, means, focus, efforts, simply, called, sy10000, around, hour, several, logs, profilers, misleading, interesting, trace, executed, trick, cannot, listed, particular, give, think, basically, trying, vague, appreciate, free, voting, ahead, vote, mere, influential, yet, tremendously, useful, trust, hundreds, such, terrific, ease, life, earn, reputation, smart, reach, download, gem, install, happens, cool, instead, restarting, click, magic, nope, reality, come, earlier, happened, restart, common, retaining, becomes, completely, deserves, launch, instructed, within, late, blogging, saved, kidding, execution, were, retrieved, 10mins, frustrated, remembered, quick, latest, please, fails, crashed, spending, anymore, went, expectedly, pointing, explained, range, upgrading, unexpectedly, crashing, thanks, resize, boy, looks, cute, unintentionally, folks, skipped, denotes, drop, ship, nice, little, sitting, right, millimeters, standard, used, entire, length, characters, request, today, inquire, invoices, myself, she, mentioned, change, implement, aware, lookup, types, render, mistaken, remain, least, apparently, nature, supposed, initially, specific, instance, snapshot, login, everything, works, drilling, down, realised, sounds, doesn, work, back, probably, plugin, facts, deal, having, save, many, ever, noticed, noticing, haven, spend, identify, honestly, idea, whatsoever, default, info, another, two, shouldn, linking, achieve, perfect, third, things, properly, cards, apart, maintain, continents, need, anything, illustrative, requirement, country, firstly, categorise, example, involving, category, vaidymohan, blogroll, skip, victory, directly, proportional, hardwork,

Text of the page (random words):
l be the case only if you use gp s standard po number sequence or used entire po length of 17 characters when i checked it on modifier i found a nice little icon sitting right next to po number field but overlapping it by some millimeters this icon denotes whether the po line item is drop ship or not and boy isn t that icon looks cute but unintentionally it is overlapping on po number field not sure how folks at gp dev team skipped this solution to this issue modifier use modifier to resize the field till we get this fixed by gp dev team vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in debugging gp 2013 gp administration gp bug gp2013 microsoft dynamics gp microsoft dynamics gp 2013 modified forms modifier support troubleshooting 1 comment syexcelreports table sql server native client 10 0 thanks aaron berquist posted on august 2 2013 by vaidhy mohan while upgrading our gp from gp2010 sp3 to gp2013 sp1 dynamics database upgrade stopped unexpectedly with gp crashing without any information for me to debug but it stopped exactly at table syexcelreports and crashed without spending anymore time i just went and checked my odbc dsn setup as explained by aaron berquist on his blog high dynamics range expectedly the odbc dsn driver was not pointing to sql server native client 10 0 for some reason gp fails to process upgrade further if your dsn driver is not native client 10 0 or above those who upgrade your gp to latest version please check dsn before you start database upgrade using gp utilities vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in debugging dsn gp gp 2013 gp administration gp utilities gp2013 implementation microsoft dynamics gp microsoft dynamics gp 2013 odbc sql sql native client sql server syexcelreports troubleshooting upgrade leave a comment quick tip debugging visual studio tools developing for dynamics gp posted on july 30 2013 by vaidhy mohan awesome tip up there on developing for dynamics gp blog on how to debug vs tools for dynamics gp i am late in blogging about this post but now is the time as this post just saved my 1 2 day seriously not kidding i was stuck with one sql query execution there were records to be retrieved but my code didn t after 5 10mins of frustrated troubleshooting i remembered this post i should have done that immediately then but i didn t i setup my vs tools project to launch gp as instructed on this post and within 2 minutes i could find the issue this one deserves to be there on microsoft dynamics gp cookbook technical vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in customizations debugging gp administration sql sql profiler support tools troubleshooting visual studio tools vs tools 1 comment refresh application navigation support debugging tool sdt posted on april 18 2013 by vaidhy mohan are you serious about your dynamics gp as erp and are you serious about retaining it till gp becomes completely irrelevant to your business requirements contact your partner now and get support debugging tool sdt let me come to the topic now earlier before sdt happened to all of us when i created a menu item using extender i had to restart gp to get this new menu item effected what s there in that it s something common in gp isn t it how about creating a menu item using extender but instead of restarting gp just click on an option to get this new menu item immediately effected magic nope it s a reality now with support debugging tool sdt you can open security profiler of sdt and select the menu item refresh application navigation as shown in below screenshot this does exactly what happens when you log on to a company cool isn t it now reach out to your partner if you are a customer or download this gem from above sdt portal link if you are a developer consultant partner and install it on your customers gp environment this post is to show you a very simple yet tremendously useful feature of sdt trust me there are hundreds of such terrific features available in sdt which will ease your life and earn you reputation as smart consultant find time to appreciate the people who made this sdt possible and made it a free tool for all david musgrave team there is a voting going on dynamicsworld to select top 100 influential microsoft dynamics people and david s on page 4 go ahead and vote for him without him and his team dynamics gp would be just a mere erp product like any other vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in david musgrave debugging sdt support support debugging tool 2 comments where is my custom reminder window to add reminders to my gp home page posted on april 17 2013 by vaidhy mohan i was reported with a very vague issue user could not create a custom reminder from a smartlist he received an error message as follows basically below is the window which user is trying to open ideally you would think that this window is a part of microsoft dynamics gp dictionary but it is not it is a part of smartlist dictionary but trick here is you cannot see this window listed on when you try to assign this window a particular security task using security task setup window then how how would i give access to this window after around an hour or so with several script logs and profilers misleading me i found one interesting statement on sql profiler trace that was executed when the user tried opening that window exactly after this sql statement the above error message was thrown at the user which means i must focus my troubleshooting efforts on this table dynamics sy10000 this table is simply called user security when user tried to open custom reminder window system checked this table and see whether this user has got access to a window whose resource id is 1452 in dictionary 0 which is nothing but product microsoft dynamics gp inside company id 1 which is my production gp company i was always thinking about something in smartlist which is without any doubt but system was checking something else in a different dictionary altogether i wanted to see the window in microsoft dynamics gp dictionary which is of resource id 1452 opened the dynamics dic on dexterity and checked it only to realise with disbelief that it was referring to following window i did not understand first why would it check something totally irrelevant from what user wanted to open why would it check access to this window when opening a window in different dictionary i have no answer to these questions but i just thought i would take a chance i checked this user s security task setup and found that reminders window was not assigned i assigned that window for this user as shown below tested whether he could open custom reminder to my utter disbelief it did so if somebody is facing same issue and has already lost almost all your hair here you have a solution that would bring upon peace vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in debugging dex troubleshooting gp gp administration gp functionality gp home page microsoft dynamics gp reminders resource information resources script debugger script log script profiling sql sql profiler troubleshooting 4 comments fixed assets depreciate button disabled for user solution posted on february 7 2013 by vaidhy mohan this issue was a bit tricky but not that tricky though one of the users reported to me that he was not able to run depreciation because when he opened the depreciation process information window microsoft dynamics gp tools routines fixed assets depreciate the depreciate button was disabled below was the screenshot that he sent to me disabled button is highlighted in red box reason after quite a bit of analysis dex script log sql profiling using sdt i found that there is a table where fa module temporarily records the depreciation activity initiated by any user and will retain that record the process is complete user confirmed to me that last time when he ran the depreciation process it got stuck at the time of printing the results solution the table which records the activity is fa40203 display name book setup for depreciation the table contains three fields user id fa book index fa book id i took a backup of this table a simple t sql select into and removed that stranded activity record for that user user confirmed that he could then start depreciation process its always good to start a day with some brainy troubleshooting but not certainly good for users to start with an issue though vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in debugging dex troubleshooting dexterity script profile fa fixed assets gp administration maintenance script log script profiling sdt sql profiler support support debugging tool t sql troubleshooting 2 comments infamous sales distribution amount is incorrect error posted on december 31 2012 by vaidhy mohan i received an email from one of my users seeking my help in clearing this issue while posting an invoice this error message popped up upon running the edit list for this invoice i realized that it was due to an imbalance in markdown amount and corresponding distribution line below was the error report that i got there seemed to be markdown entered on one or more line item s but there was no distribution line for that amount but the issue was not that simple and didn t stop there when i ran thru all line items none contained a markdown now that s the problem after some minutes of thinking i realized something must be stranded on header record s markdown field for which gp requires a markdown distribution line but since line items do not contain any markdown it s not creating one strange i decided to query the records from sop10100 sop header and sop10200 sop line to understand the issue below is what i found seriously but yes that was the issue and most baffling thing is when i tried to reconcile this sales document this major mishap didn t get cleared at all obvious solution for this abnormal situation is as follows 1 take backup of this sop10100 record 2 update markdown fields with zero 3 reconcile this sales document again to see if the above update had caused any imbalance happy new year and happy troubleshooting vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new window email share on tumblr opens in new window tumblr share on pinterest opens in new window pinterest like loading posted in database db debugging gp gp administration kb knowledge base microsoft dynamics gp sales sales order processing sql sql queries tips troubleshooting 1 comment user access setup error gps error revokeuseraudit 58 posted on october 11 2011 by vaidhy mohan i faced this error message from the time i upgraded to gp2010 r2 the error message is thrown when we revoke access to a user on a company below is the exact sequence of error messages that i received since i had not doing this frequently it s maximum 3 users in 6 months and also the purpose of revoking access was working without any issues i did not consider this as a harmful message yesterday i had to revoke access to users for an existing company due to some maintenance minimum of 10 users and i started receiving this error message each time i select a user and revoke access it s then i decided to check this out and clear it once for all i could get only one link with exact error message which i found on our community forum user access setup error gps error revokeuseraudit 58 let me explain what i did to get rid of this 1 check the second error message it says it did not find the stored procedure mxcallrevokeuseraudit 2 i checked whether this stored procedure is available on any other company that i had on my gp environment i could not find one on any company 3 i was intrigued by the name of this stored procedure since it s not similar to any microsoft dynamics gp sql object naming convention 4 i then launched gp and opened tables resource description microsoft dynamics gp tools resource descriptions tables 5 since the message said something about audit i thought i would first check with audit trails module to my surprise and joy of course physical name of all tables started with mx 6 i then concluded that the sql stored procedure what i am looking at is also of audit trails module now i could not do much with that since i could not find that stored procedure anywhere i checked my gp licenses and it did not cover audit trails module at all when i upgraded to microsoft dynamics gp2010 r2 i had selected this module also for installation since this module is not covered under my license it installed the dictionary but it did not create the sql procedures that s my assumption and i may be wrong the only option that was left to remove this product from my environment by removing dynamics set file contents alone and not the dictionary itself this removed that now in famous error message vaidy share if you liked it share on x opens in new window x share on linkedin opens in new window linkedin share on facebook opens in new window facebook more print opens in new window print email a link to a friend opens in new win...