Meta tags:
description=Microsoft Dynamics GP Localisation, implementation, support and development.;

Headings (most frequently used words):

gp, dynamics, dynamicsgp, by, smartlist, workflow, missing, 2013, sp2, to, categories, posts, microsoft, ie, global, insights, from, ireland, inventory, quantities, on, hand, lot, number, site, view, for, vat, in, middle, east, 2015, new, features, bad, or, data, was, encountered, while, loading, the, report, management, reporter, due, days, problem, manufacturing, labor, code, radio, buttons, designer, query, truncates, how, long, did, it, take, us, figure, this, one, out, ian, stewart, mvp, techknowledge, most, recent, top, post, tag, cloud, blog, friends, link, blogroll, sites, resources, calendar, email, subscription,

Text of the page (most frequently used words):
the (126), and (63), #dynamics (47), this (26), for (20), vat (19), order (17), workflow (17), microsoft (16), you (16), purchase (16), posted (16), site (15), window (15), error (14), smartlist (13), one (13), from (12), set (12), print (12), with (11), new (11), can (11), middle (11), east (11), out (11), tab (11), hand (10), there (10), 2013 (10), then (10), view (9), users (9), lot (9), number (9), that (9), they (9), user (9), your (8), functionality (8), tags (8), all (8), are (8), email (7), comment (7), query (7), inventory (7), date (7), tips (7), tricks (7), strange (7), messages (7), reviewed (7), was (7), quantities (7), but (7), click (7), radio (7), due (7), qtyrecvd (7), dynamicsgp (6), other (6), else (6), ian (6), stewart (6), localisation (6), european (6), 2015 (6), issue (6), use (6), when (6), 2014 (6), bug (6), through (6), approval (6), quantity (6), itemnmbr (6), comments (5), report (5), log (5), ireland (5), account (5), posts (5), tax (5), reports (5), mssql (5), general (5), what (5), most (5), used (5), uae (5), select (5), missing (5), terminal (5), their (5), will (5), sequence (5), box (5), approvals (5), system (5), approve (5), qtytype (5), item (5), get (4), loading (4), global (4), insights (4), have (4), join (4), which (4), fixed (4), sql (4), server (4), sales (4), post (4), figure (4), time (4), format (4), problem (4), complete (4), don (4), code (4), double (4), need (4), not (4), sharepoint (4), days (4), task (4), same (4), tasks (4), returns (4), qtysold (4), total (4), like (3), wordpress (3), com (3), sign (3), subscribe (3), now (3), blog (3), here (3), resources (3), test (3), link (3), uncategorized (3), categories (3), bad (3), data (3), while (3), management (3), reporter (3), features (3), purchasing (3), has (3), domain (3), these (3), into (3), also (3), access (3), transactions (3), did (3), take (3), truncates (3), designer (3), fields (3), correctly (3), its (3), tables (3), sp2 (3), labor (3), modified (3), original (3), overhead (3), field (3), first (3), correct (3), being (3), may (3), came (3), went (3), font (3), leave (3), should (3), 2017 (3), sop10201 (3), iv00300 (3), iv00101 (3), lotnumbr (3), case (3), end (3), analysed (3), design (2), website (2), required (2), bar (2), subscribed (2), already (2), subscribers (2), create (2), free (2), address (2), nov (2), find (2), customers (2), linked (2), genesys (2), financial (2), accounting (2), rss (2), union (2), service (2), pack (2), payables (2), specification (2), 2010 (2), ledger (2), back (2), cloud (2), see (2), upgrades (2), training (2), tech (2), knowledge (2), encountered (2), top (2), documents (2), update (2), david (2), how (2), long (2), good (2), servers (2), changing (2), any (2), could (2), doesn (2), matter (2), seems (2), range (2), nothing (2), happens (2), bit (2), opens (2), january (2), haven (2), bothered (2), characters (2), because (2), just (2), limit (2), built (2), two (2), them (2), included (2), look (2), february (2), button (2), once (2), layout (2), return (2), security (2), few (2), right (2), modifier (2), start (2), hit (2), until (2), gets (2), highlighted (2), red (2), above (2), group (2), issues (2), manufacturing (2), module (2), buttons (2), had (2), hold (2), breath (2), becomes (2), running (2), interface (2), created (2), goes (2), skip (2), progressed (2), approves (2), assigns (2), based (2), across (2), client (2), around (2), houses (2), resolve (2), everything (2), found (2), add (2), install (2), needed (2), journals (2), october (2), suit (2), requirements (2), daybook (2), reporting (2), locncode (2), unitcost (2), itemdesc (2), itmshnam (2), itmclscd (2), itmgedsc (2), expndate (2), left (2), reconcile (2), master (2), is_invonhand_lotno (2), showing (2), implementation (2), support (2), development (2), started, name, write, collapse, manage, subscriptions, reader, content, privacy, enter, receive, notifications, subscription, august, 2026, calendar, independent, news, views, world, resource, centre, answe, anywhere, forum, download, product, demos, sites, video, sums, drive, microsoftdynamics, partners, partnersource, customersource, gold, certified, partner, systems, investment, risk, software, blogroll, 134, 609, vists, friends, vies, day, book, upgrade, schedule, detail, strategy, sop, restore, recovery, reconciliation, processing, minimum, intrastat, ini, hardware, gp2010, germany, frx, france, forms, series, excel, europe, etafi, eft, eec, disaster, dex, business, portal, belgium, bank, backup, accon, tag, category, recent, techknowledge, grab, badge, mvp, older, dont, musgrave, reasons, why, describes, similar, guess, took, competition, discovered, babu, worked, were, both, settings, solution, connected, alignment, form, his, entry, individual, comes, printing, weird, selects, clicks, dialogue, per, normal, screen, printer, file, orders, masse, scenario, removing, sufficient, selection, eventually, count, max, allowed, couldn, know, won, run, maybe, truncated, length, more, mark, output, bottom, certain, nice, addition, wee, labour, setting, sequences, again, save, close, grant, might, attempts, tied, knots, delete, reinsert, scratch, key, tabbing, interrupt, straight, selected, tip, corner, option, second, variable, repeat, groups, temporarily, patch, open, tools, customise, modify, current, fun, begins, maintenance, selecting, overheads, amounts, percentages, standard, caused, share, point, rider, related, instances, where, multiple, levels, matrix, honest, fully, define, recreate, clean, environment, welcome, upcoming, irrelevant, whole, redesigned, dropped, equation, hence, currently, step, creating, submitting, routed, level, approver, notifying, awaiting, choice, direct, reset, submission, stranded, document, cannot, does, mean, who, example, diagnosis, approving, setup, configuration, behaviour, submitted, recently, difficult, track, down, weeks, upshot, updated, well, april, yesterday, absolutely, useless, message, trying, adding, windows, reinstall, think, pure, chance, type, call, anything, called, mine, away, successfully, menu, separate, installs, added, solved, only, thing, tried, bingo, july, way, organisational, verification, credentials, web, office, 365, applications, assignments, quick, hot, topic, include, batches, clearing, budget, receivables, vendor, gst, gcc, examples, pre, configured, countries, local, edited, utilise, ssrs, however, generated, instead, using, basis, paper, online, some, procedures, details, schedules, assigning, vendors, items, configuring, etc, following, analysis, completed, recording, seamless, short, answer, record, latest, version, core, engine, suffices, transact, daybooks, extends, allow, additional, importantly, auditing, 2018, come, stream, been, quastions, asked, about, readiness, community, forums, lately, serltnum, description, expiry_date, qty_on_hand, qty_in, qty_out, qty_type, qty_received, qty_sold, qty_returned, shortname, generic_desc, class_id, results, delivered, serial, work, history, dbo, ___________________________________________________________________________________________, customer, monthly, stock, takes, hope, someone, november,

Text of the page (random words):
dynamicsgp ie global insights from ireland microsoft dynamics gp localisation implementation support and development dynamicsgp ie global insights from ireland microsoft dynamics gp localisation implementation support and development ian stewart posted by is november 21 2017 inventory quantities on hand by lot number by site view for smartlist a customer needed a new smartlist showing their inventory quantities on hand analysed by lot number and site in order to complete monthly stock takes this is the view i came up with hope its of use to someone else the total quantity on hand should reconcile to the out of the box item quantities smartlist in gp ___________________________________________________________________________________________ create view dbo is_invonhand_lotno as view is_invonhand_lotno created on nov 21 2017 by ian stewart inventory quantities on hand analysed by lot number and site showing the quantity on hand the total quantity in the total quantity out analysed by sales and returns tables used a iv00300 item lot number master b sop10201 sales serial lot work and history c iv00101 item master the results of this view should reconcile to the total on hand quantity from the item quantities smartlist delivered out of the box with gp select a itemnmbr as item c itemdesc as description a locncode as site a lotnumbr a expndate as expiry_date a qtyrecvd case when a qtytype 1 then a qtysold else a qtyrecvd end as qty_on_hand a qtyrecvd as qty_in case when a qtytype 1 then a qtysold else a qtyrecvd end as qty_out a unitcost a qtytype as qty_type a qtyrecvd as qty_received a qtysold as qty_sold case when a qtytype 2 then a qtyrecvd else 0 end as qty_returned c itmshnam as shortname c itmgedsc as generic_desc c itmclscd as class_id from iv00300 a left join sop10201 b on b itemnmbr a itemnmbr and b serltnum a lotnumbr left join iv00101 c on c itemnmbr a itemnmbr group by a itemnmbr a qtyrecvd a qtysold a lotnumbr a locncode a qtytype a unitcost c itemdesc c itmshnam c itmclscd c itmgedsc a expndate go leave a comment posted in mssql tips and tricks tags dynamics gp inventory iv00101 iv00300 lot number microsoft mssql quantity on hand site sop10201 view posted by is october 2 2017 vat in middle east on 1 january 2018 vat will come on stream in the middle east there have been a lot of quastions asked about this and dynamics gp readiness in the community forums lately the short answer is that dynamics gp has everything you need to record and account for vat for the middle east already built in and not just in the latest version the core dynamics gp tax engine suffices to set up and transact with vat for the middle east the vat daybooks module extends this functionality to allow for additional reporting and most importantly auditing of your vat returns you do need to complete some set up procedures vat details and schedules assigning to customers vendors items and configuring vat daybook reports to suit etc following an analysis of your requirements but once completed vat recording and reporting should be seamless one issue is the out of the box vat return reports there are examples pre configured for european countries these may or may not suit your local middle east uae requirements but they can be edited or you can utilise ssrs however most users don t use these system generated returns instead using the vat daybook reports or a smartlist as the basis of their paper based or online returns leave a comment posted in middle east uae vat uncategorized tags gcc gst middle east uae vat posted by is october 16 2014 dynamics gp 2015 new workflow features quick one but its a hot topic with users dynamics gp 2015 workflow 2 will include out of the box approvals for general ledger batches general journals clearing journals and budget transactions payables and receivables transactions and vendor account approval are all included by the way the new organisational account user verification with dynamics gp 2015 can be used with workflow so the same user credentials you use to access the web client office 365 and other cloud applications can be used with workflow tasks and approvals assignments leave a comment posted in functionality reviewed tags 2015 approvals dynamics gp workflow posted by is july 10 2014 bad or missing data was encountered while loading the report management reporter came across this one yesterday absolutely useless error message went around the houses trying to resolve re adding users changing their windows security reinstall everything i could think of what i found by pure chance is that if you add a new font format type to your install of mr call it anything i called mine test the error goes away and you can successfully print reports click format on the mr menu bar i found it because we had two separate installs with the same issue one also needed a new font added which i did and then i went back to the resolve the original error and it was solved only thing i did was add a font format tried it on the other install and bingo go figure that one out 8 comments posted in strange error messages tips and tricks tags bad or missing data error loading management reporter report posted by is april 21 2014 dynamics gp workflow 2013 sp2 due days problem came across this issue on a client site recently difficult to track down and we went around the houses for a few weeks the upshot is that the due days on tasks do not update correctly if the task is progressed through sharepoint if the task is updated through the dynamics gp 2013 interface all is well bug diagnosis when a user approves a purchase order in dynamics gp the system assigns a due date for the approving tasks based on the time limit set in the approval workflow setup on the workflow configuration site the correct behaviour but if a user approves a purchase order through the workflow tasks site the system assigns the same due date as the date the purchase order was submitted so what does this mean for dynamics gp 2013 users who are running for example a purchase order approvals workflow the first step is creating the purchase order in dynamics gp and submitting it for approval all good a sharepoint task gets created with the correct due days and is routed to the first approval level an email goes out to the approver notifying them that there is a purchase order awaiting their approval they have a choice skip to the workflow site direct from the email and approve the purchase order or log into dynamics gp and approve the purchase order there if they skip out to the workflow site and approve the purchase order it will error out and reset the due date to be the same as the original submission date the task then becomes stranded and the document cannot be progressed if they log into dynamics gp and approve the purchase order there there are no issues this is a bug and don t hold your breath for it to be fixed with the upcoming new workflow system in dynamics gp 2013 r2 this bug becomes irrelevant as the whole system is being redesigned and sharepoint is being dropped from the equation hence don t hold your breath if you are currently running workflow then you have a problem you need to approve purchase order s through the dynamics gp interface rider this may be related to instances where there are multiple levels to the approval matrix but to be honest we haven t had the time to fully define the issue and recreate it in a clean test environment i d welcome all and any comments 1 comment posted in functionality reviewed strange error messages tips and tricks tags approvals bug due days dynamics dynamics gp 2013 error gp purchase order share point sharepoint workflow posted by is february 11 2014 gp 2013 sp2 manufacturing labor code radio buttons missing in microsoft dynamics gp 2013 service pack 2 there is a bug in the manufacturing module labor code maintenance window the radio buttons for selecting if overheads are amounts or percentages are missing on the standard window this is caused by the tab sequence on this window not being set correctly to correct this issue temporarily while microsoft issues a patch open the window in modifier tools customise modify current window and select layout set tab sequence now the fun begins hit the tab key to start tabbing through the fields tab until the fixed overhead field gets highlighted now is the time to interrupt the tab sequence and set it straight double click the fixed overhead field highlighted in red above until the radio group is selected tip double click the top right hand corner of the red box above then hit tab double click the first radio option tab and double click the second radio button then tab through to the variable overhead field and repeat you will need to do this for the 4 radio groups on this window once complete click layout set tab sequence again save and close the modified window and return to dynamics gp then go to gp 2013 security and grant the user access to this new modified window it might take a few attempts to get it right if you get tied up in knots delete the modified window from modifier and reinsert the original to start from scratch also take a look at david s post on setting tab sequences 1 comment posted in functionality reviewed strange error messages tags 2013 labor code labour code microsoft dynamics gp radio button sp2 tab sequence posted by is february 7 2014 smartlist designer query truncates smartlist designer for dynamics gp a nice addition has a wee bit of a problem there seems to be a limit on the length of the query that can be built when you link one or more tables so if you select two tables link them mark all fields to be included in the output and then look at the sql query at the bottom of the window the sql query truncates at a certain number of characters by removing sufficient fields from the selection you will eventually get a complete query i haven t bothered to count the max number of characters allowed because i just couldn t be bothered and i don t know if this is a bug or by design but if your new smartlist won t run correctly maybe its truncated 1 comment posted in functionality reviewed strange error messages tips and tricks tags dynamics gp query smartlist smartlist designer truncates posted by is january 15 2014 how long did it take us to figure this one out the scenario gp 2013 2 terminal servers that all users use to access gp they use the transactions purchasing print purchasing documents window to print their purchase orders en masse the problem user opens this window selects a range of po s and clicks print the print dialogue window opens as per normal and they select screen printer file it doesn t matter which they click ok to print and nothing happens the weird bit one domain user on one terminal server can print no one else can it doesn t matter what gp user id they use to log into gp it seems to be connected to the domain user account go figure also all users can print the alignment form from his window or can go to the po entry window and print an individual po there but when it comes to printing a range of po s nothing happens the solution discovered by babu on the good terminal server that users date and time format was set to us this is the one that worked on the other terminal server it was set to uk all other domain users were set to uk on both terminal servers changing any one of these to us settings and they could print the po s the competition guess how long it took us to figure this one out update david musgrave has a post which describes a similar issue and the reasons why 2 comments posted in european localisation functionality reviewed strange error messages tips and tricks tags dynamics gp print purchase order purchasing documents dont print older posts categories european localisation functionality reviewed general middle east uae vat most used tech knowledge mssql strange error messages tips and tricks training uncategorized upgrades what we d like to see in gp ian stewart mvp grab this badge here techknowledge most recent posts inventory quantities on hand by lot number by site view for smartlist vat in middle east dynamics gp 2015 new workflow features top posts inventory quantities on hand by lot number by site view for smartlist vat in middle east dynamics gp 2015 new workflow features bad or missing data was encountered while loading the report management reporter post categories post categories select category european localisation functionality reviewed general middle east uae vat most used tech knowledge mssql strange error messages tips and tricks training uncategorized upgrades what we d like to see in gp tag cloud 2010 accon accounting back backup bank belgium business portal date dex disaster dynamics dynamics set dynamics gp eec eft error etafi eu europe european european union excel financial series forms france frx general ledger genesys germany gl gp gp2010 gp 2010 hardware specification ian stewart ini intrastat inventory ireland localisation microsoft microsoft dynamics gp microsoft dynamics gp 10 minimum specification mssql payables purchase order purchase order processing query reconciliation recovery report reports restore sales order sales tax service pack set site smartlist sop sql sql server strategy tax tax detail tax schedule union up upgrade users vat vat day book vies blog friends 134 609 vists link to dynamicsgp rss posts rss comments blogroll fixed investment risk free dynamics gp accounting software dynamicsgp ie 0 genesys financial systems microsoft dynamics gp gold certified partner 0 ian stewart on linked in ian stewart on linked in 0 dynamics gp microsoft customersource resources for microsoft dynamics gp customers 9 partnersource resources for microsoft dynamics gp partners 0 test drive microsoftdynamics gp 9 video which sums up dynamics gp 0 dynamics gp microsoft sites microsoft dynamics gp product demos 0 dynamics gp resources dynamics gp 10 sp 4 download here 0 dynamics gp forum if you can t find the answe anywhere else you ll find it here 9 ms dynamics world gp resource centre independent news and views on microsoft dynamics gp 0 calendar august 2026 m t w t f s s 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 nov email subscription enter your email address to subscribe to this blog and receive notifications of new posts by email email address sign me up join 41 other subscribers create a free website or blog at wordpress com subscribe subscribed dynamicsgp ie global insights from ireland join 41 other subscribers sign me up already have a wordpress com account log in now privacy dynamicsgp ie global insights from ireland subscribe subscribed sign up log in report this content view site in reader manage subscriptions collapse this bar loading comments write a comment email required name required website design a site like this with wordpress com get started