Meta tags:

Headings (most frequently used words):

2016, to, dynamics, gp, for, monday, posts, not, the, mohammad, daoud, august, 2017, wednesday, june, may, 2015, blog, procedure, insert, column, account, thursday, 24, march, 13, 31, tuesday, 21, 30, 20, related, links, mail, follow, me, total, pageviews, popular, labels, translator, archive, my, list, followers, payment, document, management, link, general, ledger, taanalyticsdistribution, working, users, creation, of, login, failed, unknown, reason, contact, your, sql, server, administrator, assistance, msg, 515, level, 16, state, aagcreateglworkslrealtimepostforapply, line, 82, cannot, value, null, into, glpostdt, table, afdco, dbo, aag10000, does, allow, nulls, fails, inventory, changing, correct, site, all, transactions, notes, arabic, characters, econnect, error, there, is, an, active, purchase, order, approval, workflow, use, enter, this, data,

Text of the page (most frequently used words):
end (420), select (414), begin (368), output (305), and (289), o_ierrorstate (258), oerrstring (247), istatus (183), from (167), where (151), nolock (146), exec (131), o_oerrorstate (131), else (115), taupdatestring (109), the (105), when (80), then (78), dynamics (72), int (63), i_vcostcatid (62), i_vprojnum (62), case (57), ierror (56), numeric (56), i_vponumber (55), round (54), i_vitemnmbr (50), char (50), dbo (48), null (47), smallint (47), itemnmbr (46), i_vqtyshppd (46), i_vpoptype (45), this (44), editdecplcur (44), error (43), i_vautocost (40), isnull (40), i_vvendorid (39), oruntcst (38), vendorid (36), i_vunitcost (35), not (34), i_vnoninven (32), exists (31), actindx (30), i_vinvindx (30), curncyid (29), decplcur (28), pabllngtype (28), i_vuofm (28), acsgfloc (28), ponumber (27), i_vpolnenum (27), i_vextdcost (27), ago (26), i_vqtyinvcd (26), uofm (26), lofsgmnt (26), years (25), projectloaded (25), i_vpoprctnm (25), for (24), i_vcurncyid (24), patu (24), custnmbr (24), vnditnum (24), locncode (23), decplqty (23), pacontnumber (23), that (22), i_vlocncode (22), umqtyinb (22), rtrim (22), microsoft (21), share (21), i_vlanded_cost_group_id (21), pacostcatid (21), pabilrate (21), i_vvnditnum (21), sql (19), i_vrcptlnnm (19), potype (19), mohammad (18), daoud (18), maxseg (18), number (18), purpvidx (17), return (17), paprojnumber (17), accnt_string (17), lofsgmntall (17), break (17), invindx (16), ord (16), 100 (16), noteindx (16), decplcuritem (15), sum (15), paacrev (15), set (15), i_vreceiptdate (15), varchar (15), with (14), you (14), pastat (14), pamarkpercent (14), qtybsuom (14), currnidx (14), rvlpd027 (14), rvlpd011 (14), pop10110 (13), paprojecttype (13), odecplcu (13), paprofittype (13), po_paiv_item_checkbox (13), sy00300 (13), location_segment (13), polneary_3 (13), pabenddate_year (13), uppvidx (12), uomschdl (12), i_vvnditdsc (12), vnditdsc (12), rcptlnnm (12), polnenum (12), none (12), paacctgmethod (12), pacgbwipidx (12), ltrim (12), unitcost (12), jobnumbr (12), capital_item (12), tinyint (12), count (12), numofper (12), remitid (12), your (11), document (11), date (11), i_vitemdesc (11), itemdesc (11), poprctnm (11), qtyonpo (11), paoverhead_amount (11), pacontra_account_idx (11), icustomstate (11), new_accnt_string (11), substring (11), papurchase_tax_options (11), procedure (11), l_base_ctr (11), rvlpd025 (11), checks (10), 2016 (10), email (10), august (10), may (10), was (10), been (10), pricmthd (10), gl00105 (10), qtyovertolerancepercent (10), use_markup_percentage (10), sgmtnumb (10), order (10), pabbegindate_year (10), user (10), rvlpd009 (10), com (9), convert (9), posted (9), seqnumbr (9), mcinstalled (9), pabilling_statusn (9), pa01301 (9), pa00901_patmprofittype (9), tapaauxacctsgetidx (9), i_vpaprojnumber (9), i_vpacostcatid (9), i_vemployid (9), i_vpatu (9), i_vpacosttrxid (9), i_vtype (9), i_vcustnmbr (9), i_vpacontnumber (9), o_iindex (9), po_pacogs_idx (9), po_pricelvl (9), datetime (9), prchsuom (9), polnesta (9), pacloseprojcosts (9), integer (9), pabbegindate_period (9), mvp (8), workflow (8), march (8), june (8), series (8), excel (8), paste (8), amount (8), active (8), itmtrkop (8), iv00101 (8), i_vpurchase_iv_item_taxable (8), i_vpurchase_item_tax_schedu (8), shipmthd (8), useqtyoveragetolerance (8), lofsgmntend (8), paunpostedqty (8), paunpostedtotalcostn (8), i_vcmmttext (8), pabenddate_period (8), gl20000 (8), sequence (8), left (8), outer (8), join (8), blog (7), into (7), server (7), 2017 (7), status (7), checkbook (7), level (7), january (7), february (7), april (7), econnect (7), labels (7), one (7), arabic (7), issue (7), change (7), pinterest (7), facebook (7), blogthis (7), mct (7), mcp (7), mcbmsp (7), mcts (7), mcbmss (7), 962 (7), 999 (7), http (7), www (7), mohdaoud (7), regards (7), hope (7), helps (7), funlcurr (7), vctnmthd (7), stndcost (7), tookacctoffpoorpassed (7), actnumst (7), listprce (7), i_vpurchase_site_tax_schedu (7), landed_cost_group_id (7), po_palineitemseq (7), use_billing_rate (7), paunbilled_ar_idx (7), roundto (7), i_vrequestertrx (7), insert (7), i_vjobnumbr (7), getdate (7), po_patu (7), icustomerrstring (7), landed_cost_id (7), l_fore_ctr (7), pafenddate_period (7), i_startyearupdate (7), i_endyearupdate (7), i_baselinestartyearupdate (7), i_forecaststartyearupdate (7), iv00103 (7), check (7), rvlpd029sorted (7), rvlpd013sorted (7), users (6), view (6), october (6), november (6), december (6), have (6), create (6), posts (6), pop10100 (6), ismctrx (6), revalue_inventory (6), tolerance_percentage (6), po_uomschdl (6), currcost (6), pm00200 (6), i_vinventoryaccount (6), fundecplcur (6), currentqtyshipped (6), patotaloverh (6), paoverheapercentage (6), paviprofittypefrom (6), patmprofittype (6), pa01001_patmprofittype (6), i_vtaxamnt (6), patotalprofit (6), pabaseovhdcost (6), paunbilled_proj_rev_idx (6), po_invindx (6), uomprice (6), update (6), projnum (6), pacostcatnme (6), po_trdisamt (6), paunpostaccrrevn (6), lcids (6), locncodereg (6), igetnextnoteidxerrstate (6), popalwop_2 (6), pasetupkey (6), userdate (6), pafbegindate_period (6), customer (6), name (6), but (6), command (6), cm20600 (6), docnumbr (6), all (5), 2013 (5), application (5), type (5), power (5), july (5), payment (5), general (5), database (5), currency (5), customers (5), following (5), below (5), back (5), after (5), total (5), itemtype (5), sy01100 (5), iv40700 (5), iv00105 (5), top (5), mc40200 (5), passedextcost (5), vadcdpad (5), noacctonitem (5), qtyshppd (5), maxtoleranceamount (5), remainingqtyonpo (5), palineitemseq (5), poptype (5), paincprchtxprjcst (5), pashipmentextcost (5), pa_base_billing_rate (5), po_pacgbwipidx (5), rndgamnt (5), roundhow (5), enablemultibin (5), rcptlinenoteidarray_1 (5), rcptlinenoteidarray_2 (5), rcptlinenoteidarray_3 (5), rcptlinenoteidarray_4 (5), rcptlinenoteidarray_5 (5), rcptlinenoteidarray_6 (5), rcptlinenoteidarray_7 (5), rcptlinenoteidarray_8 (5), while (5), i_vactlship (5), i_vbolpronumber (5), papurordnum (5), paprofitamount (5), pa_variance_accrued_reve (5), pricelvl (5), time1 (5), po_itmtshid (5), po_pachgordno (5), po_curncyid (5), i_vautoassignbin (5), serltqty (5), lclinenumber (5), tapoprcptlineinsert (5), postatus (5), costcatexists (5), painactive (5), po_papurchase_tax_options (5), o_glcalculateglperioderrorstate1 (5), o_glcalculateglperioderrorstate2 (5), pa_create_periodic_budget_recordserrorstate (5), pa_ivcreate_periodic_budget_recordserrorstate (5), upper (5), system (5), purchase (5), they (5), over (5), using (5), accounts (5), account (5), jrnentry (5), reporting (4), management (4), about (4), receiving (4), record (4), september (4), 2015 (4), words (4), what (4), morning (4), journal (4), entry (4), mail (4), comments (4), siteinactive (4), itemsiteinactive (4), pop40100 (4), abs (4), 16384 (4), tx00101 (4), taxschid (4), pabase_unit_cost (4), pabase_qty (4), tax_amount (4), padecplqty (4), uofmbase (4), extdcost (4), costcatid (4), oldcucst (4), ruppvamt (4), acpuridx (4), pacogs_idx (4), paiv_item_checkbox (4), pa_mc_accrued_revenue (4), pa_mc_base_billing_rate (4), pa_mc_billing_rate (4), pa_mc_varianceaccruedrev (4), paoverhead_idx (4), paprofitpercent (4), pa_variance_cost (4), pa_variance_qty_accrued_ (4), po_currnidx (4), lccost (4), landedcosterrstate (4), landedcosterrstring (4), sy03900 (4), date1 (4), scompanyid (4), projectexists (4), l_projnum (4), pabaselineptaxoptions (4), closed (4), icustomglperioderr (4), pafenddate_year (4), pafbegindate_year (4), pabbegindate (4), pabenddate (4), pafbegindate (4), pafenddate (4), are (4), community (4), which (4), having (4), wasn (4), realized (4), message (4), working (4), tried (4), transfer (4), cmrecordnumber (4), row_number (4), partition (4), dex_row_id (4), blogger (3), team (3), free (3), 2010 (3), business (3), internet (3), reason (3), upgrade (3), login (3), unknown (3), administrator (3), accounting (3), ledger (3), setup (3), now (3), exchange (3), rates (3), got (3), statement (3), collation (3), year (3), tafqeet (3), call (3), code (3), article (3), next (3), enter (3), index1 (3), pop10310 (3), pop10500 (3), cast (3), pa01303 (3), pavidn (3), pa01001 (3), papostedbillingsn (3), i_vdoctype (3), gl00100 (3), oremsubt (3), ratetpid (3), xchgrate (3), ratecalc (3), denxrate (3), total_landed_cost_amount (3), itmtshid (3), pachgordno (3), trdisamt (3), icursorerror (3), i_vusrdefnd1 (3), i_vusrdefnd2 (3), i_vusrdefnd3 (3), i_vusrdefnd4 (3), i_vusrdefnd5 (3), 255 (3), transaction (3), mc40000 (3), pa10601 (3), each (3), get (3), installed (3), see (3), going (3), activated (3), 000 (3), there (3), were (3), upon (3), transactions (3), monday (3), comment (3), ran (3), expected (3), changing (3), reported (3), fixed (3), line (3), therefore (3), due (3), taanalyticsdistribution (3), powered (2), show (2), inside (2), crm (2), field (2), visual (2), studio (2), can (2), edge (2), new (2), 2012 (2), solution (2), any (2), list (2), small (2), page (2), interesting (2), sharing (2), matters (2), how (2), 2009 (2), creation (2), failed (2), contact (2), assistance (2), azure (2), development (2), middle (2), east (2), default (2), time (2), description (2), codes (2), administrators (2), 2008 (2), link (2), translator (2), other (2), multilingual (2), analytical (2), found (2), between (2), english (2), version (2), has (2), updated (2), website (2), long (2), feed (2), process (2), wanted (2), last (2), function (2), numbers (2), published (2), script (2), company (2), should (2), add (2), will (2), links (2), wf100002 (2), workflow_status (2), 12013 (2), pmprchix (2), paactindx (2), pa43001 (2), pasfid (2), parecordid (2), paaccttype (2), inactive (2), iv00102 (2), max (2), iv41101 (2), qtyorder (2), qtycance (2), ceiling (2), decimal (2), 100000 (2), pa10702 (2), patmprofitamount (2), patmprofitpercent (2), 2055 (2), prclevel (2), econnectoutverify (2), po_receiving_transaction (2), i_vindex1 (2), i_vindex2 (2), i_vindex3 (2), i_vindex4 (2), i_vindex5 (2), i_vindex6 (2), i_vindex7 (2), i_vindex8 (2), i_vindex9 (2), i_vindex10 (2), i_vindex11 (2), i_vindex12 (2), i_vindex13 (2), i_vindex14 (2), i_vindex15 (2), i_vdelete (2), costcode (2), costtype (2), orextcst (2), product_indicator (2), appytype (2), exgtblid (2), pamccurncyid (2), pa01201 (2), pa01101 (2), pa00501 (2), declare (2), nocount (2), open (2), deallocate (2), fetch (2), fetch_status (2), txtfield (2), 500 (2), 8000 (2), o_iupdcrtitemerrstate (2), o_ipolineinsrerrstate (2), o_ipohdrerrstate (2), o_icommentmsterrstate (2), o_ilineivcinsrterrstate (2), po_uofm (2), unitprce (2), periodid (2), icustomglperiodstate (2), funcridx (2), glcalculateglperiod (2), i_sseries (2), i_corigin (2), receivings (2), trx (2), i_ddate (2), i_duserdate (2), o_speriodid (2), o_tclosed (2), o_syear (2), o_iouterr (2), i_projectnumber (2), i_transactionusage (2), i_costcategory (2), i_contractnumber (2), i_customernumber (2), i_sourcefileid (2), i_basestartdate (2), i_baseenddate (2), i_forestartdate (2), i_foreenddate (2), i_actualstartdate (2), i_actualenddate (2), i_userdate (2), i_deciqty (2), i_functionaldeciglobals (2), i_create (2), i_change_baseline (2), i_change_forecast (2), i_firstdate (2), i_lastdate (2), i_year_start (2), i_year_end (2), i_baseline_period (2), i_forecast_period (2), i_err (2), iv00106 (2), 7320 (2), worked (2), need (2), decrypt (2), checking (2), completed (2), stored (2), doesn (2), 150686 (2), approval (2), use (2), data (2), returned (2), getting (2), wednesday (2), just (2), text (2), whenever (2), notes (2), behind (2), live (2), writer (2), issues (2), few (2), several (2), further (2), turned (2), exist (2), everything (2), correct (2), our (2), inventory (2), site (2), problem (2), value (2), column (2), trace (2), creates (2), creating (2), trigger (2), logins (2), cause (2), trying (2), added (2), under (2), resolved (2), cmxfrnum (2), remitance (2), pmtdocid (2), oricbook (2), descbook (2), trxdate (2), numoftrx (2), functamt (2), functional (2), origamt (2), originating (2), vendor (2), cheknmbr (2), chekbkid (2), docdate (2), duedate (2), docamnt (2), xfr_record_number (2), union (2), orctrnum (2), sourcdoc (2), di_pdc_gl_link (2), post (2), watermark, theme, followers, developing, care, award, program, eone, training, appdev, great, plains, guy, turn, pending, 1099, nightmare, sweet, dreams, net, usage, waqas, butt, armanino, blogs, amllp, consulting, rsitemnotfound, clicking, navigation, sp2, domain, migration, redirection, learn, discuss, connecting, facing, deployment, michaelj2, goodbye, channel, death, considering, gp2themax, dynamicszone, telegram, messenger, groups, professionals, findings, knowledge, mobile, here, why, merit, customised, configuration, condition, abdulrahman, nabil, 365, ignite, life, unposted, victoria, yudin, vat, dynamicsgp, batch, held, posting, busy, marked, locked, edited, setting, confessor, blogspot, surprising, ways, save, quickbooks, energized, notification, dynamicsblogger, pengalaman, ane, pakai, tablet, advan, vandroid, e1c, pro, rose, solutions, attach, origin, land, retail, frx, crystal, reports, designers, days, automate, cloud, flow, telemetry, insights, down, action, blogster, 184, 174, 2011, 2014, archive, translate, web, client, vacancies, reporters, promotions, portals, 106, support, erp, integration, installation, fun, updates, homepage, 163, customizations, portal, bugs, books, good, question, newsgroup, answered, david, musgrave, steps, conversation, format, geo, georgian, hijri, umm, qura, production, released, integrate, pay, online, developed, service, loads, directly, willing, importer, during, subject, dropping, produced, wfdeployclrassemblies, ever, situation, match, tafkeet, 9875, functio, allows, publishe, discussing, kind, innovations, think, specially, deli, popular, pageviews, follow, address, sent, once, الواجهة, العربية, dyamics, complete, profile, related, subscribe, atom, home, older, wf100001, formid, 829, ivivindx, 1250, 9337, 11819, 11820, 446, 4612, 8052, distinct, cm00100, pop40600, 5446, 7993, 2057, 8051, 2061, 2062, 734, 2045, pop10360, 833, 834, 837, pm00300, adrscode, 1400, 1200, 8162, 7321, 7322, 11780, 11781, pafprofitamt, pafprofitpcnt, pa00901, 8184, 8185, 8186, 8187, 8188, 8189, 8190, 8191, 8192, pmapindx, 200, baseuofm, iv40201, iv40202, equivuom, iv00108, fromqty, toqty, iv00107, tapricinggetroundprice, 8182, 1289, iv40100, setupkey, remsubto, 9379, actlship, commntid, noninven, trxsorce, bolpronumber, purchase_iv_item_taxable, purchase_item_tax_schedu, purchase_site_tax_schedu, bsivcttl, taxamnt, ortaxamt, bcktxamt, obtaxamt, remaining_ap_amount, landed_cost_warnings, backouttradedisctax, origbackouttradedisctax, landed_cost, invoice_match, rcptretnum, rcptretlnnum, invretnum, invretlnnum, islineintra, 2075, qtyinvcd, qtyrej, qtymatch, qtyreserved, qtyinvreserve, orcptcost, ostdcost, trxloctn, daterecd, rctseqnm, sprctseq, pchrptct, sprcptct, qtytype, posted_lc_ppv_amount, qtyreplaced, qtyinvadj, 2076, dateval, exchdate, mctrxstt, ortdisam, pabillnoteidx, pacbaddfrmfly, paoriaccrrev, paorigbaseovrhcst, paorigbillrate, paorigovhdamt, paorigprofamt, paorigsec, paorigtotovrhd, paorigtotprof, paorigvarext, papo_line_errors, paud1, paud2, receiptdate, 8175, pa10721, rcptcost, 8176, 10408, 10417, 10418, 10419, pop10340, 9335, tapoprcptmultibin, i_vbin, i_vquantity, i_vcreatebin, 9336, pop10330, 3389, 9339, insensitive, cursor, iv41102, cursor_rows, 9235, tapoprcptlandedcost, i_vlanded_cost_id, i_vlclinenumber, 8050, 8272, 8271, delete, 8273, tapoprcptlineinsertpost, 150, 1290, alter, encryption, isolation, read, uncommitted, tapoprcptlineinsertpre, 149, 2050, 2051, pa41701, pa42201, 8181, pop10300, pop30300, 8053, 594, 5455, 2052, pop10170, 11971, 589, 3810, 9008, 3808, 3809, 6663, 6662, 9344, 9343, 8173, 8174, cmpanyid, sy01500, interid, db_name, tasmgetnextnoteindex, i_scompanyid, i_isqlsessionid, i_noteincrement, o_mnoteindex, 8239, 8095, 8096, 8097, 8098, 8099, 8100, 8101, 8102, 8103, 8193, 8696, paforecastovrhdamtperunt, paforecastovrhdpct, paforecastbaseprofitamt, 8177, 8178, 21042, 21043, 20144, sy40101, year1, pa_ivcreate_periodic_budget_records, 20145, execute, pa_create_periodic_budget_records, 20146, 4605, 1277, 4604, 1779, 7922, 9373, 9374, 4601, last_originating_cost, last_currency_id, 591, 590, 3799, 1276, 4606, 2053, 2054, modified, reflect, like, charm, otherwise, invistigated, whats, equal, dbfrog, decryptor, nothing, available, explaining, place, look, procedures, encrypted, make, sense, used, approved, pmrr000000004316, xxxxx, 2042, xxxx, unit, 240, main, 32768, node, identifier, parameters, integrating, created, addon, fixes, send, package, tool, allowing, write, friendly, textbox, done, copies, original, note, covering, old, comes, realize, paid, leaves, notepad, track, windows, supporting, blogging, seen, worth, away, months, engaged, projects, learning, treand, characters, investigations, missing, financials, normally, occurs, target, also, flipping, https, 157821, wired, warehouse, covered, functionality, explained, deleting, these, went, through, investigation, hours, orphaned, records, gl100001, try, apply, multi, msg, 515, state, aagcreateglworkslrealtimepostforapply, cannot, glpostdt, table, afdco, aag10000, does, allow, nulls, fails, tuesday, digging, deeply, profiler, desired, perfectly, noticed, successfully, queued, looked, ddl, tracks, changes, sends, informing, them, best, practices, real, seems, result, adding, generating, disabling, only, fresh, copy, luck, sure, owner, companies, databases, fellows, challenging, evening, unable, succeed, operation, obvious, could, already, nor, showing, selects, running, removing, don, want, publish, full, might, differences, every, providing, way, environment, decryption, indeed, retuning, anything, misplaced, return_value, i_vdocnmbr, 3464, i_vamount, i_vactnumst, 1100, i_vaatrxdim, department, i_vaatrxdimcode, i_vaasubledgerassignid, i_vupdateifexists, today, normal, query, didn, find, impact, run, always, returning, errorstate, mean, executed, properly, doctype, vendname, vndchknm, rvlpd029, rvlpd026, pmpdc, rmdtypal, custname, stmtname, rvlpd013, rmpdc, purchasing, deferred, object, sales, collections, works, brings, details, both, receivables, payables, who, module, big, reconcile, their, dated, against, almost, requested, thursday,

Text of the page (random words):
vprojnum none and i_vprojnum begin if i_vcostcatid none begin select l_projnum isnull paprojnumber pastat isnull pastat 0 pabllngtype isnull pabllngtype 0 paoverhead_amount isnull paforecastovrhdamtperunt 0 paoverheapercentage isnull paforecastovrhdpct 0 pabilrate isnull paforecastbaseprofitamt 0 paprofittype isnull paprofittype 0 pabaselineptaxoptions isnull pabaselineptaxoptions 0 po_curncyid pamccurncyid from pa01301 nolock where paprojnumber i_vprojnum and pacostcatid i_vcostcatid and patu patu select po_currnidx currnidx from dynamics mc40200 nolock where curncyid po_curncyid if l_projnum begin select o_ierrorstate 8177 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end else begin if pastat in 2 3 4 5 begin select o_ierrorstate 8178 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end end end end select fundecplcur decplcur 1 from mc40000 a nolock dynamics mc40200 b nolock where a funcridx b currnidx and a funlcurr b curncyid if projectloaded 1 begin if i_vponumber and i_vprojnum and i_vcostcatid and i_vvnditnum begin if i_vpolnenum begin select po_uomschdl uomschdl po_patu patu po_papurchase_tax_options papurchase_tax_options po_itmtshid itmtshid po_trdisamt trdisamt po_paiv_item_checkbox paiv_item_checkbox po_palineitemseq palineitemseq po_pricelvl pricelvl po_pachgordno pachgordno from pa10601 nolock where papurordnum i_vponumber and ord i_vpolnenum end else begin select po_uomschdl uomschdl po_patu patu po_papurchase_tax_options papurchase_tax_options po_itmtshid itmtshid po_trdisamt trdisamt po_paiv_item_checkbox paiv_item_checkbox po_palineitemseq palineitemseq po_pricelvl pricelvl po_pachgordno pachgordno from pa10601 nolock where papurordnum i_vponumber and paprojnumber i_vprojnum and vnditnum i_vvnditnum and pacostcatid i_vcostcatid end if papurchase_tax_options 0 begin select papurchase_tax_options po_papurchase_tax_options end select top 1 po_pricelvl pricelvl from pa01303 nolock where paprojnumber i_vprojnum and pacostcatid i_vcostcatid and itemnmbr i_vitemnmbr end else begin select po_paiv_item_checkbox isnull paiv_item_checkbox 0 from pa01301 nolock where paprojnumber i_vprojnum and pacostcatid i_vcostcatid and patu po_patu select top 1 po_pricelvl isnull pricelvl po_palineitemseq isnull palineitemseq 0 from pa01303 nolock where paprojnumber i_vprojnum and pacostcatid i_vcostcatid and itemnmbr i_vitemnmbr end if i_vreceiptdate begin select o_ierrorstate 21042 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end exec istatus glcalculateglperiod i_sseries 7 i_corigin pa receivings trx entry i_ddate i_vreceiptdate i_duserdate userdate o_speriodid pabbegindate_period output o_tclosed closed output o_syear pabbegindate_year output o_iouterr icustomglperioderr output o_ierrorstate o_glcalculateglperioderrorstate1 output select ierror error if istatus 0 or o_glcalculateglperioderrorstate1 0 or ierror 0 begin select oerrstring rtrim oerrstring ltrim rtrim o_glcalculateglperioderrorstate1 select o_ierrorstate 21043 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output return o_ierrorstate end exec istatus glcalculateglperiod i_sseries 7 i_corigin pa receivings trx entry i_ddate i_vreceiptdate i_duserdate userdate o_speriodid pabenddate_period output o_tclosed closed output o_syear pabenddate_year output o_iouterr icustomglperioderr output o_ierrorstate o_glcalculateglperioderrorstate2 output select ierror error if istatus 0 or o_glcalculateglperioderrorstate2 0 or ierror 0 begin select oerrstring rtrim oerrstring ltrim rtrim o_glcalculateglperioderrorstate2 select o_ierrorstate 20144 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output return o_ierrorstate end select pafbegindate_period pabbegindate_period pafbegindate_year pabbegindate_year pafenddate_period pabenddate_period pafenddate_year pabenddate_year i_startyearupdate pabbegindate_year i_endyearupdate pabenddate_year i_baselinestartyearupdate pabenddate_year i_forecaststartyearupdate pabenddate_year select numofper numofper from sy40101 nolock where year1 pabenddate_year if pabenddate_year pabbegindate_year 1 begin set l_base_ctr numofper pabbegindate_period pabenddate_period 1 end else if pabenddate_year pabbegindate_year begin set l_base_ctr pabenddate_period pabbegindate_period 1 end else begin set l_base_ctr pabenddate_year pabbegindate_year numofper numofper pabbegindate_period numofper pabbegindate_period end if pabenddate_year pabbegindate_year begin set l_fore_ctr numofper pafbegindate_period pafenddate_period 1 end else if pabenddate_year pabbegindate_year begin set l_fore_ctr pafenddate_period pafbegindate_period 1 end else begin set l_fore_ctr pafenddate_year pafbegindate_year 1 numofper numofper pafbegindate_period numofper pabbegindate_period end if costcatexists 1 and custnmbr begin if po_paiv_item_checkbox 1 begin exec istatus pa_ivcreate_periodic_budget_records i_projectnumber i_vprojnum i_transactionusage patu i_costcategory i_vcostcatid i_contractnumber pacontnumber i_customernumber custnmbr i_sourcefileid 0 i_basestartdate pabbegindate i_baseenddate pabenddate i_forestartdate pafbegindate i_foreenddate pafenddate i_actualstartdate i_vreceiptdate i_actualenddate i_userdate userdate i_deciqty decplqty i_functionaldeciglobals fundecplcur i_create 0 i_change_baseline 1 i_change_forecast 1 i_firstdate i_lastdate i_year_start 0 i_year_end 0 i_startyearupdate i_startyearupdate i_endyearupdate i_endyearupdate i_baselinestartyearupdate i_baselinestartyearupdate i_baseline_period pabenddate_period i_forecaststartyearupdate i_forecaststartyearupdate i_forecast_period pafenddate_period l_base_ctr l_base_ctr l_fore_ctr l_base_ctr i_err pa_ivcreate_periodic_budget_recordserrorstate output select ierror error if istatus 0 or pa_ivcreate_periodic_budget_recordserrorstate 0 or ierror 0 begin select oerrstring rtrim oerrstring ltrim rtrim pa_ivcreate_periodic_budget_recordserrorstate select o_ierrorstate 20145 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output return o_ierrorstate end end else begin execute istatus pa_create_periodic_budget_records i_projectnumber i_vprojnum i_transactionusage patu i_costcategory i_vcostcatid i_contractnumber pacontnumber i_customernumber custnmbr i_sourcefileid 0 i_basestartdate pabbegindate i_baseenddate pabenddate i_forestartdate pafbegindate i_foreenddate pafenddate i_actualstartdate i_vreceiptdate i_actualenddate i_userdate userdate i_deciqty decplqty i_functionaldeciglobals fundecplcur i_create 0 i_change_baseline 1 i_change_forecast 1 i_firstdate i_lastdate i_year_start 0 i_year_end 0 i_startyearupdate i_startyearupdate i_endyearupdate i_endyearupdate i_baselinestartyearupdate i_baselinestartyearupdate i_baseline_period pabenddate_period i_forecaststartyearupdate i_forecaststartyearupdate i_forecast_period pafenddate_period l_base_ctr l_base_ctr l_fore_ctr l_base_ctr i_err pa_create_periodic_budget_recordserrorstate output select ierror error if istatus 0 or pa_create_periodic_budget_recordserrorstate 0 or ierror 0 begin select oerrstring rtrim oerrstring ltrim rtrim pa_create_periodic_budget_recordserrorstate select o_ierrorstate 20146 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output return o_ierrorstate end end end end select top 1 locncodereg locncode from iv40700 nolock where locncode if locncodereg and i_vlocncode begin select o_ierrorstate 4605 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if locncodereg and i_vlocncode begin if i_vponumber and not exists select 1 from iv40700 nolock where locncode i_vlocncode begin select o_ierrorstate 1277 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vnoninven 0 and not exists select 1 from iv00102 nolock where itemnmbr i_vitemnmbr and locncode i_vlocncode begin select o_ierrorstate 4604 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end if i_vnoninven 0 begin if i_vponumber begin if not exists select 1 from iv00103 nolock where itemnmbr i_vitemnmbr and vnditnum i_vvnditnum and vendorid i_vvendorid begin select o_ierrorstate 1779 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end else begin if i_vpolnenum 0 and not exists select 1 from pop10110 nolock where itemnmbr i_vitemnmbr and vnditnum i_vvnditnum and vendorid i_vvendorid and ponumber i_vponumber and ord i_vpolnenum begin select o_ierrorstate 7922 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end end if i_vponumber begin if i_vnoninven 0 begin select decplcur decplcur 1 7 odecplcu decplcur 1 decplqty decplqty 1 1 from iv00101 nolock where itemnmbr i_vitemnmbr if i_vuofm begin if not exists select 1 from iv00106 nolock where itemnmbr i_vitemnmbr and uofm i_vuofm begin select o_ierrorstate 9373 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end select uofm i_vuofm end else begin select prchsuom prchsuom from iv00103 nolock where vendorid i_vvendorid and itemnmbr i_vitemnmbr and vnditnum i_vvnditnum if prchsuom begin select prchsuom prchsuom from iv00101 nolock where itemnmbr i_vitemnmbr end if prchsuom begin select o_ierrorstate 9374 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end select uofm prchsuom end select umqtyinb qtybsuom from iv00106 nolock where itemnmbr i_vitemnmbr and uofm uofm if i_vvnditdsc begin select i_vvnditdsc vnditdsc from iv00103 nolock where vendorid i_vvendorid and itemnmbr i_vitemnmbr end end else begin select decplqty decplqty decplcur decplcur 1 7 odecplcu decplcur 1 from pop40100 nolock where index1 1 select uofm i_vuofm end if i_vcurncyid begin select i_vcurncyid isnull curncyid from pm00200 nolock where vendorid i_vvendorid end if i_vcurncyid begin select currnidx isnull currnidx 0 from dynamics mc40200 nolock where curncyid i_vcurncyid end else begin select i_vcurncyid isnull funlcurr currnidx isnull funcridx 0 from mc40000 nolock end if i_vlocncode and locncodereg begin select o_ierrorstate 4601 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vautocost 1 begin select oruntcst last_originating_cost from iv00103 nolock where vendorid i_vvendorid and itemnmbr i_vitemnmbr and last_currency_id i_vcurncyid end end if polnesta in 4 5 6 begin select o_ierrorstate 591 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if potype 2 begin select o_ierrorstate 590 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if vendorid i_vvendorid and i_vponumber begin select o_ierrorstate 3799 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vjobnumbr begin select i_vjobnumbr jobnumbr end if i_vuofm begin select i_vuofm uofm end if i_vpolnenum 0 begin select i_vpolnenum polnenum end if i_vlocncode begin select i_vlocncode locncode end else begin if i_vlocncode locncode and i_vponumber begin if popalwop_2 0 begin select o_ierrorstate 1276 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end end if i_vponumber and i_vuofm begin if i_vuofm uofm begin select o_ierrorstate 4606 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end if vnditnum or vnditnum is null and i_vponumber begin select o_ierrorstate 2053 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vnoninven 0 and not exists select 1 from iv00101 nolock where itemnmbr i_vitemnmbr begin select o_ierrorstate 2054 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vponumber begin select curncyid isnull curncyid 0 from pop10100 nolock where ponumber i_vponumber select currnidx isnull currnidx 0 from dynamics mc40200 nolock where curncyid curncyid if i_vcurncyid and i_vcurncyid curncyid begin select o_ierrorstate 7320 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end if i_vcurncyid begin select i_vcurncyid curncyid end end if exists select 1 from wf100001 where formid 829 and exists select 1 from wf100002 where wf100002 active 1 begin if exists select 1 from pop10100 where workflow_status 6 and ponumber i_vponumber begin select o_ierrorstate 12013 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end end if i_vcurncyid and i_vcurncyid funlcurr begin select ismctrx 1 end if i_vnoninven 0 begin select i_vitemdesc case when i_vitemdesc is null then itemdesc else i_vitemdesc end itmtrkop itmtrkop itemtype itemtype vctnmthd vctnmthd invindx ivivindx stndcost stndcost purpvidx purpvidx uppvidx uppvidx revalue_inventory revalue_inventory tolerance_percentage tolerance_percentage po_uomschdl uomschdl pricmthd pricmthd uomschdl uomschdl currcost currcost from iv00101 nolock where itemnmbr i_vitemnmbr if vctnmthd not in 4 5 begin select uppvidx 0 end else begin if uppvidx 0 begin select uppvidx actindx from sy01100 nolock where series 5 and seqnumbr 1250 end end if i_vvnditdsc begin select i_vvnditdsc vnditdsc end if i_vinvindx 0 begin if i_vinvindx 0 begin select i_vinvindx invindx from pop10110 nolock where ponumber i_vponumber and ord i_vpolnenum if i_vinvindx 0 begin select tookacctoffpoorpassed 1 end end if i_vinvindx 0 begin select i_vinvindx invindx end if i_vinvindx 0 begin select i_vinvindx actindx from sy01100 nolock where series 5 and seqnumbr 100 end end end else begin if i_vitemdesc is null begin select i_vitemdesc itemdesc end if i_vitemdesc begin select i_vitemdesc i_vvnditdsc end if i_vvnditdsc begin select i_vvnditdsc vnditdsc end if i_vinvindx 0 begin select i_vinvindx invindx if i_vinvindx 0 and i_vcostcatid begin select i_vinvindx pmprchix from pm00200 nolock where vendorid i_vvendorid end else begin if projectloaded 1 begin if i_vpolnenum begin select i_vinvindx invindx from pop10110 nolock where ponumber i_vponumber and ord i_vpolnenum end else begin if paprojecttype 3 begin select i_vinvindx paactindx from pa43001 nolock where pasfid 26 and parecordid i_vcostcatid and paaccttype 30 end else begin select i_vinvindx paactindx from pa43001 nolock where pasfid 26 and parecordid i_vcostcatid and paaccttype 1 end end end end end end if itemtype 3 begin select o_ierrorstate 9337 exec istatus taupdatestring o_ierrorstate oerrstring oerrstring output o_oerrorstate output end select siteinactive inactive from iv40700 nolock where locncode i_vlocncode select itemsiteinactive inactive from iv00102 nolock where itemnmbr i_vitemnmbr and locncode i_vloc...