PM Tables | Victoria Yudin

PM00203 – Vendor Accounts PM00204 – 1099 Period Detail (only in GP 10.0 and higher) PM00300 – Vendor Address Master PM00400 – PM Keys Master VictoriaYudin RamblingsandmusingsofaDynamicsGPMVP Home Resources GP Reports GPTables AboutMe Resources AllResources DynamicsGPBuilds DynamicsGPResources GPResources(builds18.x) GP2018Resources GP2016Resources GP2015Resources GP2013Resources GP2010Resources GP10.0Resources GP9.0&OlderVersions SQLServerResources MR&FRxResources GP Reports AllReports/Code CrystalReportsTips GeneralLedgerSQLCode InventorySQLViews PayablesSQLViews ReceivablesSQLCode SOPSQLViews SQLServerCodingTips System/SetupSQLCode GPTables BankRec Tables Company/System Tables FixedAssets Tables GL Tables Inventory Tables Payroll Tables PM Tables POP Tables RM Tables SOP Tables AboutMe FunStuff Posts PM Tables CommonlyUsedTables:PM00100–VendorClassesPM00200–VendorMasterPM00201–VendorMasterSummaryPM00202– VendorPeriodSummaryPM00203–VendorAccountsPM00204–1099PeriodDetail(onlyinGP10.0andhigher)PM00300–VendorAddressMasterPM00400–PMKeysMasterPM10000 – Work/UnpostedTransactionsPM10100–GLDistributionsforWorkandOpenTransactionsPM10200–ApplyToWork/OpenPM10300–Work/UnpostedPaymentsPM10400–Work/UnpostedManualPaymentsPM20000–Open/PostedTransactionsPM30200–Historical/PaidTransactionsPM30300–ApplyToHistoryPM30600–GLDistributionsforHistoricalTransactionsMC020103–MulticurrencyPayablesTransactionsSY06000–VendorEFTInformation ExplanationofDocumentStatus:Work–unpostedOpen–postedbutnotfullyapplied/paidHistory–postedandfullyapplied/paid DOCTYPE (DocumentType):1–Invoice2–FinanceCharge3–MiscCharge4–Return5–CreditMemo6–Payment7–ScheduledPayment(thankstoDennisSisnarineforthis) DISTTYPE(PMDistributionType):1–Cash2–Payable3–DiscountAvailable4–DiscountTaken5–FinanceCharge6–Purchase7–TradeDisc.8–Misc.Charge9–Freight10–Taxes11–Writeoffs12–Other13–GSTDisc14–PPSAmount16–Round17–RealizedGain18–RelaizedLoss19–DueTo20–DueFrom PMAGEBY:0–DueDate1–DocumentDate TEN99TYPE(1099Type):1–Nota1099Vendor2–Dividend3–Interest4–Miscellaneous5–Withholding PSTGSTUS(PostingStatus)inPM10000:10 – transactionbeingenteredforthefirsttimebeforeithasbeensavedbytheuser20 – savedandunpostedtransaction30 –transactionthatiscurrentlyposting(realtime)40 – postedtransaction50 – transactionthathasencounteredanerrorduringposting60– transactionthathasbeensavedpreviouslyandhadastatusof20andisnowbeingeditedby auser70 – transactionthathasbeenpostedpreviouslyinarecurringbatchthatstillcontainsunpostedtransactionsisnowbeingeditedbytheuser PSTGSTUS(PostingStatus)inPM10100:0–Unposted1–Posted3–Unposted [usedforComputerChecks,notintheSDK] CNTRLTYP(ControlType):0–Vouchertypes1–Paymenttypes2–Printedalignmentforms DCSTATUS(DocumentStatus):0–Reserved1–Work2–Open3–History VENDSTTS(VendorStatus):1–Active2–Inactive3–Temporary CREDTLMT (CreditLimit)inPM00200:[ThankstoBudCool,afrequentcontributortotheMicrosoftGPNewsgroup,forthisinformation!]0–NoCredit1–Unlimited2–Amount  [Note:IfCREDTLMT=2thenCRLMTDLRcontainstheamountofthecreditlimit,otherwiseCRLMTDLRiszero] HISTTYPE (HistoryType):0–Calendar1–Fiscal PYENTTYP(PaymentType):0–Check1–Cash2–CreditCard3–EFT Writeoff:0–NotAllowed1–Unlimited2–MaximumAmount FreeOnBoard:1–None2–Origin3– Destination—LastUpdated:October16,2021 Sharethis:EmailPrintTweetLikethis:LikeLoading... 465Responsesto“PM Tables” DennisSisnarine Reply October15,2021at1:56pm YoucanaddunderDOCTYPE(DocumentType):7–SchedulePayment IhavenoticedthatthisshowsuponthePMtablePM20000forSchedulePayments LikeLike VictoriaYudin Reply October16,2021at6:43am ThankyouDennis,Iappreciatetheinfoandhaveaddedittothelist. -Victoria LikeLike StevenBlanc Reply June30,2020at8:06am HiVictoria, Wearelookingatdoingsomecustomerflowanalysisatourretailstoresandwouldliketoknowthetimethatinvoicesweregenerated/posted.IhavelookedattheTIME1fieldbutitdoesn’tactuallyseemtostoretimedata. Isthereanytablethatwecouldpulltransactiontimesoffoforisthereasettingwecanchangetoenabletimelogging? LikeLike VictoriaYudin Reply June30,2020at9:22am HiSteven, Asyou’veseen,GPdoesnotstoretimeformostthings,onlydates.Andevendatesandusersarenotalwaysstoredforeverythingyouwant.Ifthisisimportanttotrackandyou’reonlytalkingaboutafewthings,youcouldcreatesomeSQLtriggersforitwithacustomtablestoringtheevents.Youhavetobeverycarefulwhendoingthistonotimpactnormalprocessingandotherintegratingapplications/processes.Butit’sdoable.Ifyou’relookingtotrackalitofdifferentthings,itmightbeworthwhiletolookintoanISVproductforthis,somethinglikeRockton’sAuditororFastPath’sAuditTrail. -Victoria LikeLike StevenBlanc Reply June30,2020at10:39am ThanksVictoria, ReallywewerejustlookingatInvoices;however,thatwillstillbeasubstantialnumberoftransactions.Iwilltalktoourdeveloperstoseeiftheycanbuildthisinforus. Cheers, Steven LikeLike kj2004 Reply May13,2020at4:18am HiVictoria! Iwouldliketoknow,isitpossibletohavetransactionswithdisttypeofRecvbutwithapayableGLaccount(andviceversawithpayabledisttype)?Oristhisarecordingerror?Thankyou! LikeLike VictoriaYudin Reply May13,2020at4:21am HiKJ, DynamicsGPdoesnotcheckorenforceaccountnumbers.Soaslongasthedistributiontypesarecorrectforthetransactiontypeanddetails,theaccountnumberscanbeanythingyouwant. -Victoria LikeLike kj2004 Reply May13,2020at4:33am Thatreplywasfast,wow.Thankyou. LikeLike kj2004 Reply May13,2020at4:42am HiVictoria! MayIaskafollow-upquestion?I’mnewtoGPsoI’vebeenfollowingyourblog(bighelp,btw).MayIask,whodecidesthedisttype?Isitautomaticallydoneifyou(let’ssay)recordtransactioninReceivablesmodule? Anddoyouhaveanyrecommendedreadings(otherthanthisawesomeblog)fornewbieslikemetounderstandGP? Thanksalot! LikeLike VictoriaYudin Reply May13,2020at4:51am HiKJ, Whenyouenteratransactiononthemainwindow,GPdeterminesthedistributiontypesbasedonthat.Whileyoucanaddtothisandyoucanchangetheaccounts,thetotalsforeachdistributiontypemustmatchthetransactiondetails.Itsoundslikeyou’retryingtodosomethingveryspecifichereandIwouldrecommendthatyoudiscussthedetailswithyourGPPartner.Justbecausesomethingwillworktechnicallydoesnotmeanitwillnotcauseissuesinotherareasofthesystem.Forexample,youmightbecompletelyunderminingtheAPandARreconciliationstotheGeneralLedgerbychangingthe“controlaccounts”forARandAPtransactions. AsfarasreadingforGP,thereisahugeamountofinformationavailable,mostonlineandfree.Therearealsoseveralbooksforsale,manyareonspecifictopics.It’sreallyhardtorecommendanythingwithoutknowingthespecificsofwhatyouwanttolearnandwhatyou’redoing. -Victoria LikeLike JunaydSuliman Reply January31,2020at9:39am Hi–WhichtablewillbebesttolookatthelastdateaVendorwaspaid.IsitcorrecttousethePOSTEDDT? USeRICOSelectVENDORID, DOCNUMBR, DOCAMNT, POSTEDDTFromPM30200 WhereVENDORIDin(‘TRU001-01’, LikeLike VictoriaYudin Reply February1,2020at8:10am HiJunyad, ThePOSTEDDTfieldholdsthedateatransactionwasposted(meaningwhensomeoneclickedthePostbutton),whichisnotnecessarilyhelpfuliftransactionsarenotalwayspostedrightaway.Thequerybelowwillshowyouthelastpaymentdateforeachvendor: selectVENDORID,max(DOCDATE)Last_Payment fromPM00400 whereDOCTYPE=6 groupbyVENDORID -Victoria LikeLike Lynne Reply October21,2019at3:38pm HiVictoria,Thankssomuchforyourblog.Iuseitoften. HaveyouwrittenanyblogsabouttheDynamicsGPworkflowtables?Iask,becauseweareusingeconnecttocreatePayablesManagementbatches.ThisworkedwonderfullyuntilweturnedonworkflowsforPMBatches.Thebatchesappearnormaluntilwesubmit,andthenit’sclearwe’vemissedsomething. I’vebeencomparingdifferently-createdbatches,andIcannotfindadifferenceinPMtables,andIcan’treallyfindwhichworkflowtablesmightbeinvolved. Doyouhaveanythoughts,ordoyouknowwhichWFtablemightshedsomelight? Thankyou,Lynne LikeLike VictoriaYudin Reply October22,2019at9:14am HiLynne, Sorry,Idon’tworkmuchwithworkflow,soIdon’thaveanythingonthetablesforit.😦 -Victoria LikeLike BeatBucher Reply October24,2019at11:01am Lynne, YoumightwanttogetintouchwithIanGrieveoveratAzureCurve,co.uk HewroteabookaboutWorkFlow2.0forGPandmightknowsomeofthedetailsabouthowitworks.HealsohasareferencepageforGPtablesthatyoucanusetolocatethedatainGP:https://gptables.azurecurve.co.uk/ LikeLikedby1person Lynne Reply October24,2019at4:19pm Great!Thankyou,Beat. -Lynne LikeLike purnellsookhai Reply September6,2019at10:35pm HiVictoria, WehaveuserswhochangethedefaultPAYaccountonthePayablesTransactionEntryDistributionwindowconstantlyandcausesissueseventhoughweinstructthemtoleavethedefaultaccount.IsthereanywaytorestrictchangesthePAYtypelinealoneinthewindow?Inotheraccountingprograms,thisisnormallythecontrolaccountisnormallygrayedoutsotheuserscan’tchangeit. ThanksinAdvance LikeLike VictoriaYudin Reply September7,2019at7:07am HiPurnellsookhai, ThereisnowaytodothisinGPwithoutacustomization.Forwhatit’sworth,mypersonalstanceonthisisthatifusershavebeeninstructednottodosomethingandarestilldoingit,theproblemisnottheaccountingsoftware. -Victoria LikeLike MarshallCampbell Reply August27,2019at11:57am IfanyoneisneedingaveragedaystopayIcreatedthisqueryforourPowerBIDashboard.ThefirsthalfofthequerycanbeusedtolookatADTPbyvendorifyou’reinterestedinthataswell.Feelfreetooffersuggestionsforimprovement.Pleasenotethislooksatpaidoffinvoicedatesoanyshortpaysorpartialpaymentswon’tbefactoredin. Select VENDORID, DOCDATE, DINVPDOF, DOCAMNT, DATEDIFF(day,DINVPDOF,DOCDATE)*-1ASDTP INTO#DTPTABLE Fromdbo.DimGPCEXPL_PaidTrans–PM30200 WHEREDOCTYPE=‘1’ ANDDOCDATE>=DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) OrderBYDTPDESC Select YEAR(DOCDATE)AS[Year] ,MONTH(DOCDATE)AS[Month] ,DATENAME(MONTH,DOCDATE)AS[MonthName] ,AVG(DTP)ASDTP FROM#DTPTABLE WHEREYEAR(DOCDATE)=YEAR(getdate()) ANDDOCDATE!>getdate() GROUPBYYEAR(DOCDATE),MONTH(DOCDATE),DATENAME(MONTH,DOCDATE) OrderBY1,2 DROPTABLE#DTPTABLE LikeLike LynnKeleher Reply August22,2019at1:07pm I’mgettinga“Asaveoperationontable‘POP_POLine’(45)”errormessageandhavebeenforaboutaweek.Anyideasastowhatiscausingthis?I’vegoogledbutcan’tfindananswer.Thankyou, Lynn LikeLike VictoriaYudin Reply August22,2019at1:28pm Lynn, Thaterrorcouldbealmostanythingunfortunately.Whatspecificallyareyoudoingwhenyou’regettingtheerror?DoesithappenoneonePOorallPO’s?Foryouuserorallusers? -Victoria LikeLike Lynn Reply October11,2019at8:06am HiVictoria! WearegettingthiserrorwhentryingtodeleteaPO.Anyuserthattriestodeleteisgettingthesameerror.ItisnotforallPO’s…justsome.Ican’tfigureoutwhyitisonlyforsomePO’s. -Lynn LikeLike VictoriaYudin Reply October11,2019at1:25pm HiLynn, Whatistheactualerroryou’regetting? -Victoria LikeLike Lynn Reply October11,2019at1:50pm Hi!Theerroris“Asaveoperationontable‘POP_POLine”(45)”. -Lynn LikeLike VictoriaYudin Reply October12,2019at3:44am HiLynn, Unfortunately,thatisjustagenericerrorthatdoesnotgiveusmuch.Butiftherewassomebusinesslogicpreventingwhatyou’redoingitwouldgiveyouadifferenterror.SomyguessistheremaybeadataissueofsomesortwiththisparticularPO.HaveyoutriedreconcilingthisPO?gotoMicrosoftDynamicsGP|Tools|Utilities|Purchasing|ReconcilePurchasingDocuments–enterthePOnumberintheFromandToandselectReconcileandPrintReportonthebottom,thenclickProcess.Doesthatgiveyouanyresults? -Victoria LikeLike Lynn Reply October17,2019at8:49am Hiagain! Thereconciledididentifyandfixataxissue,however,whenItrytocancelitinEditPurchaseOrderIgetthesameerrormessage. -Lynn LikeLike VictoriaYudin Reply October17,2019at8:55am HiLynn, IwouldrecommendaskingforhelpeitherfromyourGPPartnerorMicrosoftSupportonthis.Theywilllikelyneedtolookatthedatadirectlyandseewhatisgoingon. -Victoria LikeLike Lynn Reply October17,2019at8:59am Thankyousomuchforcheckingintothisforme! -Lynn LikeLike Lynn Reply October11,2019at8:24am HiVictoria! WearetryingtocancelaPOthatisinaReleasedstatus(forallusers).WecancancelotherPO’sbutIhavenotcheckedtheirstatus. -Lynn LikeLike BlairChristensen Reply August19,2019at6:05pm IsthereanywayinSQLtolinkapayableinPM30200backtotheoriginalinvoiceinSOP30200?IfyoulookupthePayablesTransactionEntrywindowithasaDescriptionfield,butcometofindoutitisn’tthetextthatgetsputintotheTRXDSCRNfieldinPM30200…I’mtryingtoworkonanACHprocesswithourbankandoneparticularvendor(acreditcardcompany)ismandatingthatweincludethisinformation… LikeLike VictoriaYudin Reply August21,2019at8:29am HiBlair, ThereisnodirectlinkfromPM30200toSOP30200.SometimesyouareabletodothiswithlinkingthePMdatatothePOPdatatotheSOPdata,butnotalwaysanditreallydependsonthedetailsofhowallyourtransactionsareenteredintoGP. Separately,theDescriptiononthePayablesTransactionentrywindowDOESgointotheTRXDSCRNcolumn,butforinvoices.Ifyou’reenteringapaymentofaninvoicewithacreditcard,whichcreatesanewinvoiceunderthecreditcardvendor,thatinvoicewillnothavethesameTRXDSCRNastheoriginalinvoice.Easyenoughtolinkwithareportusingtheapplytables.Takealookatmyvariousapplyscriptsheretoseeifanywillhelp:https://victoriayudin.com/gp-reports/payables-sql-views/ -Victoria LikeLike MarshallCampbell-Controller Reply August12,2019at3:15pm All, Inanefforttoreducewasteinouroperationwearemakinganefforttoreducepapercheckpayments.Ihavecreatedthebelowquerytoanalyzecheckpaymentusage.Feelfreetoadjustasnecessaryforyourneeds.Lovethesite,thanksforalltheinformation. SELECT [VCHRNMBR] ,[VENDORID] ,[DOCDATE] ,[DOCNUMBR] ,[DOCAMNT] ,[BACHNUMB] ,[TRXSORCE] ,[BCHSOURC] FROMPM30200 WherePYENTTYP=‘0’ ANDVOIDED=‘0’ ANDBCHSOURC=‘XPM_Cchecks’ ANDDOCDATEBETWEEN‘startdateAND‘enddate’ LikeLike Grant Reply July17,2019at1:14pm HiVictoria, Doyouknowwhichtablehousesthedeferralmoduleforpurchasing?Weusethistoenterininvoicesthatareprepaidandthenthesystemamortizesthembasedonthestartdateandenddate. LikeLike TabithaBarna Reply July16,2019at4:19pm Doyouknowwhattablelinksthepayabletransactionvouchernumberandthefinancialtransactionjournalentrynumber? LikeLike VictoriaYudin Reply July17,2019at6:12am Tabitha, ThiswouldbeintheGeneralLedgertransactiontables–GL20000,GL30000,GL10001.NotethatyouwillonlyseevouchernumbersinthesetablesifyouarepostingtotheGeneralLedgerindetail. -Victoria LikeLike PhilippaWalker Reply July10,2019at10:47am Victoria, Iranascript,Select*fromSY01200toseetheemailaddressthatisattachedtotheVendors.Ihaveover1000vendorsinthevendormaster,butonly600showuponmyselectStatement.Ithoughtmaybeit’sonlyshowingthevendorsthathaveanemailattached,buttherearemanythatdon’thaveanemailandtheyareshowingup.SoWhyaren’tallthevendorsintheSY01200table. Thanks Philippa LikeLike VictoriaYudin Reply July10,2019at10:57am HiPhilippa, TheSY01200tablestoresthedataontheInternetInformationwindowforVendors,Customers,ItemsandEmployees.It’snotspecifictoemailaddresses.ItcouldalsoshowmultiplelinespervendorbecausetheinternetinformationisspecifictoavendoraddressID,notjustvendorID.Hopethathelps. -Victoria LikeLike Grant Reply June27,2019at7:26pm HiVictoria, WeuseGP2015. Isthereawaytoseethedocumentdateforavendorinvoiceorcreditmemoregardlessofwhetheritwaspaid?WeunderstandthatPM20000hasopentrxwhilePM30200haspaid/historicaltransactions.Butisthereatablethathasacompletepopulationofalldocumentswiththeirrespectivedocumentdate? Cheers, Grant LikeLike VictoriaYudin Reply June28,2019at6:35am HiGrant, PM00400hasallthedocumentdates,butnotmuchmoredata.CanIaskwhatyouaretryingtodoandwhyyoucan’tuse2tables(PM20000andPM30200)? -Victoria LikeLike Grant Reply June28,2019at8:13am Excellent!Thankyou!Ididnotknowaboutthatone.(AndIseeyouhaveitlistedabove,shameonmefornotcheckingthatone,Ipresumedthattablewasassociated/similartoPM00200.) I’mjoiningthedocumentdate,whichweuseasthevendor’sinvoicedate,totheGLtoseethelag,indays,betweenthedateaninvoicepoststoourGLandtheactualinvoicedate.(Thisgivesusanideaofhowmuch$$hitsourGLeachmonththatrelatestopriorperiodservices/goods).(We’retryingtonaildown/improveouraccruals),sothisisreallyhelpful. Lovethissite.Bigfan!Cheers LikeLike GRANTNELSON Reply June27,2019at4:49pm HiVictoria, Greatsite!Bigfan. Question:IsthereasingletablethathastheDocumentDateforinvoicesregardlessofwhetherithasbeenpaid?PM20000isforopendocumentsandPM30200isforpaiddocuments. AskingbecauseI’mtryingtomeasurethe$ofinvoicesthathitourGLeachmonththatarefromthepriormonth.WhenIqueryfromPM30200,I’mgettingblankrecordsforinvoicesthatareopen/unpaid. DECLARE@EndDateDATETIME DECLARE@StartDateDATETIME SELECT@StartDate=‘5/1/2019’ SELECT@EndDate=‘5/31/2019’ SELECT JRNENTRYAS[JENumber] ,USWHPSTDAS[User] ,GL105.ACTNUMBR_1AS[CoID] ,GL105.ACTNUMBR_2AS[Dept] ,GL105.ACTNUMBR_3AS[GL] ,GL105.ACTNUMBR_4AS[PC] ,GL105.ACTNUMSTAS[AccountNumber] ,CASEGL100.PSTNGTYP WHEN‘0’THEN‘BS’ WHEN‘1’THEN‘P&L’ ENDAS[AccountType] ,TRXDATEAS[GLDocDate] ,PM.DOCDATEAS[APDoc.Date] ,(ORPSTDDT–PM.DOCDATE)AS[APPostLag] ,ORMSTRIDAS[VendorID] ,ORMSTRNMAS[VendorName] ,SOURCDOCAS[SourceDocument] ,REFRENCEAS[Reference] ,DSCRIPTNAS[TransactionDesc.] ,ACTDESCRAS[AccountDesc.] ,ORDOCNUMAS[DocumentNumber] ,DEBITAMTAS[DebitAmount] ,CRDTAMNTAS[CreditAmount] ,(DEBITAMT–CRDTAMNT)AS[NetAmount] FROMRV_GP.dbo.GL20000(nolock) JOINRV_GP.dbo.GL00105GL105ONGL20000.ACTINDX=GL105.ACTINDX JOINRV_GP.dbo.GL00100GL100ONGL105.ACTNUMBR_3=GL100.MNACSGMTANDGL105.ACTINDX=GL100.ACTINDX LEFTJOINRV_GP.dbo.PM30200PMONGL20000.ORDOCNUM=PM.DOCNUMBRANDGL20000.ORMSTRID=PM.VENDORID WHERETRXDATEBETWEEN@StartDateAND@EndDate ANDGL105.ACTNUMBR_3=‘2000’ Keepupthegreatwork! LikeLike VictoriaYudin Reply June28,2019at7:02am HiGrant, Ididn’tseethisbeforereplyingtothepreviousmessage–trythis,IchangedyourcodearoundabitandmySQLeditormakesallthespecialwordslowercase.NotethatifyouareusingthePOPmodulethiswillstillreturnnullsforthedatesfrominvoicespostedinPOPandnotPM. declare@StartDatedatetime=‘2019-05-01’ declare@EndDatedatetime=‘2019-05-31’ select g.JRNENTRYas[JENumber] ,g.USWHPSTDas[User] ,g105.ACTNUMBR_1as[CoID] ,g105.ACTNUMBR_2as[Dept] ,g105.ACTNUMBR_3as[GL] ,g105.ACTNUMBR_4as[PC] ,g105.ACTNUMSTas[AccountNumber] ,caseg100.PSTNGTYP when0then‘BS’ when1then‘P&L’ endas[AccountType] ,g.TRXDATEas[GLDocDate] ,coalesce(ph.DOCDATE,p.DOCDATE) as[APDoc.Date] ,datediff(dd,coalesce(ph.DOCDATE,p.DOCDATE) ,g.ORPSTDDT)as[APPostLag] ,g.ORMSTRIDas[VendorID] ,g.ORMSTRNMas[VendorName] ,g.SOURCDOCas[SourceDocument] ,g.REFRENCEas[Reference] ,g.DSCRIPTNas[TransactionDesc.] ,g100.ACTDESCRas[AccountDesc.] ,g.ORDOCNUMas[DocumentNumber] ,g.DEBITAMTas[DebitAmount] ,g.CRDTAMNTas[CreditAmount] ,g.DEBITAMT–g.CRDTAMNTas[NetAmount] fromGL20000g innerjoinGL00105g105 ong.ACTINDX=g105.ACTINDX andg105.ACTNUMBR_3=‘2000’ innerjoinGL00100g100 ong.ACTINDX=g100.ACTINDX leftouterjoinPM30200ph–PMhistory ong.SERIES=4 andleft(g.SOURCDOC,2)=‘PM’ andg.ORTRXTYP=ph.DOCTYPE andg.ORCTRNUM=ph.VCHRNMBR leftouterjoinPM20000p–PMopen ong.SERIES=4 andleft(g.SOURCDOC,2)=‘PM’ andg.ORTRXTYP=p.DOCTYPE andg.ORCTRNUM=p.VCHRNMBR whereg.TRXDATEbetween @StartDateand@EndDate Hopethathelps, -Victoria LikeLike VictoriaYudin Reply June28,2019at7:06am PS–youmightneedtoreformatsomeofthisalittlewhenyoupasteitbackintoSQL.Forsomereasonsomeofthethingslikesinglequotesanddoubledashesgetformattedwackyintheblogeditor.Sorryaboutthat. LikeLike Grant Reply June28,2019at8:22am Perfect!Yes,thisworksaftertweakingafewquotesandtheminussign.Ilikehowyouincorporatedthecoalescefunction.(neverseenitused).Thisproperlyfetchedthefirstnon-nullvalue.Thankyousomuch! LikeLike VictoriaYudin Reply June28,2019at8:29am Gladthatworkedforyou! CoalesceisoneofmyfavoritethingstouseinSQL.Thebeautyofitisthatyoucanputanynumberoffields/valuesinalist,itwillusethefirstnon-nullitfindsintheorderyouspecify.ItseemsmoreintuitivetomethanusingISNULLandmorefunctional. Sinceyou’renotreallypullingmuchofanythingelsefromthePMtablesyoucouldhaveprobablyusedPM00400here,butIwantedtoshowyouhowtodoitwithmultipletablesandacoalesce,asthatcomesupoftenwithGPdata. -Victoria LikeLike CoryWolin Reply June5,2019at4:02pm IfoundsomethingoddinGPandIamcuriousifitisstandardorwehaveaglitch.IinputseveralAPtransactionsinaforeigncurrency.WhenIlookatthemintheentrywindow,Iseetheoriginalamountentered.WhenIrunaneditlistforthebatch,Iseetheamountbasedontheexchangerate.Thisisveryconfusingtousers,sowhentheygotoconfirmtheamounttheyareposting,thetotalsintheeditlistdonotmatchwhattheyseeonline.Isthatnormal? LikeLike VictoriaYudin Reply June9,2019at7:30am HiCory, ItsoundslikeyoumaywanttoswitchtotheMulticurrencyversionoftheeditlistreport.Todothat–gotoMicrosoftDynamicsGP|Tools|Setup|Posting|Posting,selectPurchasingfortheseriesandPayablesTrxEntryfortheOrigin(Ibelievethatisthetransactiontypeyou’reaskingabout).OncetheSeriesandOriginareselected–checktheboxoverontheleftfor“IncludeMulticurrencyInfo”andclickSave.Nowwhenyourusersprintthereporttheywillseeboththeoriginatingandthefunctionalcurrency. Notall,butmanyofthepostingreportsareavailableinmulticurrencyversions;theyarenotselectedbydefaultbecausemanycompaniesusingGPdonotuseMulticurrencyor–eveniftheydo–theydonotcaretoseetheMCinfoonthere. Hopethathelps. -Victoria LikeLike CoryWolin Reply June10,2019at10:17am Thatisagreathelp.Thanksverymuch LikeLikedby1person SamuelPhung Reply January11,2019at5:12pm I’mnewtoGP. WhichtablecontainsVendor‘spayment-termsanddiscount-percentage? Sam LikeLike VictoriaYudin Reply January11,2019at5:22pm Samuel, ShouldbePM00200. -Victoria LikeLike SherryWhitten Reply September28,2018at5:24pm UnderwhatcircumstanceswouldarecordbeinPM30300withPosted=0?I’mdrawingablank.I’vetestedacoupleofscenarioswithcreditmemos,butnothingIdogeneratesarecordinPM30300withPosted=0.Thanksinadvance LikeLike VictoriaYudin Reply September28,2018at6:01pm HiSherry, IhavejustcheckedanumberofdifferentdatasetsIhaveandnotoneofthemhasanyrecordsinPM30300withPOSTED=0.Doyouhavealotofthese? -Victoria LikeLike SherryWhitten Reply October2,2018at4:18pm Idonot.IjustranacrossacustomprocessbeingusedtopullinformationaboutPMpaymentsfromGPtosendtoanothersystem,andithasawhereclasswherepm30300.posted=1.Justwonderingwhy.Iambuildingasimilarprocess,andIneedtoknowifIneedthatrestriction.Thanks!!! LikeLike EricCoulthard Reply May16,2018at1:52pm HiYudin, CantheamountofapaymentinPM20000changeafterithasbeeninsertedintothattable? Iwouldliketoknowhowtotellwhentheamountofapaymentissetinstone. Thanks, LikeLike VictoriaYudin Reply May17,2018at6:46am HiEric, No,notthroughtheuserinterface.TransactionsinPM20000are‘posted’,meaningtheycannotbechanged.And,ofcourse,itwouldbeaverybadideatodothisdirectlyinSQL,asitcouldeasilycausedataissuesandinconsistenciesinrelatedtables. -Victoria LikeLike Mass Reply January11,2018at1:19pm HiVictoria-IamnewtoGPAPmodulebutveryfamiliarwiththeSQLqueries.Iamtaskedwithcreatingasmartlistwhichhasvendordetails(especiallytheTaxdetailsfor1099vendors),invoicedetailsandpaymentdetails.DoyouhappentohaveaSQLquerytoaddressthis? Thankssomuch. LikeLike VictoriaYudin Reply January16,2018at4:56am HiMass, Ihavealotofdifferentcodethatmighthelp,pleasetakealookatthispage:https://victoriayudin.com/gp-reports/payables-sql-views/. -Victoria LikeLike Carol Reply January4,2018at9:04am GoodMorningVictoria, IamtryingtolocatetheactualVendorDiscountAmount(i.e.2%,10%,etc).IlookedunderPM00200butdidnotfindit.Ifoundinsteadthediscountid. Thankyou. LikeLike VictoriaYudin Reply January4,2018at11:28am HiCarol, Thevendordiscountamountiscalculatedforeachtransaction–ifyouarelookingforthat,youwouldneedtolookatthetransactiontables. -Victoria LikeLike JH Reply November27,2017at1:34pm HiVictoria, couldyoutellmewhattablesareusedtointerfacewithStrattonWarrenI/Psystem?ineedAPvoucher,GLjournalheaderanddetail,PMlineitemfilemapping LikeLike VictoriaYudin Reply November27,2017at1:38pm Joyce, Sorry,Ihavenotheardof“StrattonWarrenI/Psystem”.Iamguessingit’seithera3rdpartyaddonoracustomizationcreatedforyou.Ineithercase,youwouldhavetoaskthecompanythatcreateditforthosedetails. -Victoria LikeLike Steve Reply October19,2017at4:25pm HiVictoria, IneedtoqueryPMpaymentsthathavebeenvoidedsinceagivendate.Forinstance,Ineedtoquerypaymentsvoidedinthelasttwodays,e.g.paymentsvoidedsince10/17/2017. IsVOIDPDATEareliablefieldtouseforthat?OrwouldMODIFDTorDEX_ROW_TSbeabetterdatefieldforthisscenario? Steve LikeLike VictoriaYudin Reply October19,2017at4:30pm HiSteve, IthinkDEX_ROW_TSisthemostreliablefieldtouseforthis,youwouldneedtodosometestingtomakesure.TheVOIDPDATEisenteredbytheuser–sothatcanbeanything.TheMODIFDTcouldbeupdatedbysomethingelsepossibly(Ithink,againmightneedsometesting). -Victoria LikeLike Carol Reply August16,2017at11:32am IamdoingareportusingPM30200whenDOCTYPE=1whichIbelieveareInvoices.IwouldliketoincludeGLPOSTDTinthereport,butitisnotinthattable.WhatisthebesttableIcanusetopickupthatadditionalfieldandwhatfield(s)couldIusetojointhetwotables?Thanks! LikeLike VictoriaYudin Reply August16,2017at11:36am HiCarol, TheGLPostingdateisinfieldPSTGDATEinthePM30200table. -Victoria LikeLike PrakashMishra Reply June23,2017at9:15am HelloVictoria, IhavefewtransactionsforvendorAthathavePO,Invoice,Paymentsfordropshipitems.Someofthepaymentsareopenandsomeareposted.Now,mysupervisorhasaskedmetochangefromvendorAtoBforthosetransactions.Isthereanyutilityavailabletodothisoranysqlscript?Pleasesuggesthowtoproceed. Thanks&Regards, PrakashMishra LikeLike DebbieW Reply June20,2017at9:18am HeyVictoria!WehavemultiplecompanydatabasesandveryhighvolumeofAPtransactions.Wehavehadvendorspaidtwiceforthesameinvoicebecausetheinvoicewasenteredinerroreitherinthewrongcompanydatabaseorinthecorrectdatabasebutunderadifferentvendorid.IamlookingforawayeitherinSmartlistorExcelReportsthattheAPSupervisorcanlookbeforecheckrunstoseeifthereareduplicatesinthesystem.DocumentDateandAmountshouldalwaysmatchwhereVendorIDwouldmatchonlysomeofthetime.Thoughtsonthebestwaytoachievethis?Thanks!! LikeLike VictoriaYudin Reply June20,2017at3:22pm HiDebbie, Idon’tseewhyyoucouldn’tcreateacustomSmartList(oranothertypeofreport)thatwouldpullthisdatafromallyourcompaniesandhelpwiththisverification.Ifyoudon’thavesomeonethatcancodethisforyou,itissomethingthatwecancreateforyouasaconsultingproject.Letmeknowifyou’reinterestedindiscussingthisinmoredetail. -Victoria LikeLike DebbieW Reply June20,2017at3:30pm IhaveasmartlistthatpullsallofthedatafromallcompaniesbutIcan’tseemtogetmymindtowraparoundhowtocomparetherowstolookforpossibleduplicates. LikeLike VictoriaYudin Reply June20,2017at4:04pm Debbie, Idon’tthinkyoucandothisinSmartListdirectly.Ifitwereme,IwouldwritesomeSQLcodethatwouldlookattheunpostedpaymentsinthesystemandthenfindanythingthatlookedsimilarbasedonsomepredefinedcriteria. -Victoria LikeLike Fab Reply January17,2017at3:31pm HiVictoria, I’mcreatingaSQLviewforPaymentBatchReview(prettymuchtakingtheinfofromtheeditlistandputtingitinasmartlist)IneedtojoinPM10300andPM20000andIwanttoincludethepaymentbatchinformationaswellastheinvoicesandcreditnotesassociatedwiththatpaymentbatch.TheonlywayIcanseetojoingthemisbyVendorIDbutwhenIdothatIgetallopeninvoices/creditnotesforthevendorIselected(notjusttheinvoices/CRintheactualbatchbutIgetallthedocumentforthevendorsinmybatchnomatteriftheyareselectedtobepaidornot) IfyoucanhelpmejoinPM10300andPM20000orPM10200toonlyincludethedocumentsforaspecificvendorselectedIwouldreallyappreciateit. Thanks! LikeLike VictoriaYudin Reply January31,2017at5:40am HiFab, YoushouldbeabletogettheapplyinformationforanypaymentinPM10300byusingthePM10201table. Hopethathelps, -Victoria LikeLike Bill Reply March17,2016at9:53am Victoria,thankyouagainforyourvaluablehelp! Iwaswonderingifyouhaveaviewwherethetop10(or20)percentofvendorsandpaymentscanbereturned,foradaterange.thesewouldbeeitherpaymentsorinvoicedamounts.Thanks! LikeLike VictoriaYudin Reply March17,2016at3:45pm HiBill, Thanksforyourkindwords.IthinkIhavedonesomethingsimilartothisinthepast.LetmelookaroundforitandIwillpostitonceIfindit. -Victoria LikeLike VictoriaYudin Reply March21,2016at10:32am HiBill, Takealookatmylatestblogpostforanexampleofhowyoucandothis:https://victoriayudin.com/2016/03/21/sql-code-to-show-top-x-percent-of-vendor-data/ -Victoria LikeLike Debbie Reply March2,2016at5:23pm HiVictoria, Ihave2recurringbatches,whentheyweresetuptheyweresetupasnota1099vendors.Theyarea1099vendor,we’veupdatedtheVCbutwhenweprintourlistingsfor1099vendorstheystillshowupasnota1099vendor.Dowehavetoissuenewbatches? LikeLike VictoriaYudin Reply March3,2016at7:50am HiDebbie, Youcantrygoingintoeachtransactionandenteringtheamountsintothe1099Amountfield,butitmightbebettertodeleteandrecreatethetransactionssothatallthenewsettingsforthevendorsareapplied. -Victoria LikeLike Jacob Reply February9,2016at4:17pm HiVictoria, Ihaveanunpostedbatchthathas36transactionsbutthePayablesBatchEntryscreenshowsonly24transactions.WhenIlookatthePM10000tableIsee36rowsandIseeall36transactionswhenIprintthetransactions.Thebatchtotaldoesnotmatchthesumofthetransactionseither.AnyideasonwhereIcouldbegintolooktotrackdownthedifference?Thanksforeverythingyouputouthere! LikeLike VictoriaYudin Reply February9,2016at4:56pm HiJacob, Batchtotalsgetoutofwhackonceinawhile.Doesn’thappenoften,butthereareanumberofthingsthatcancausethemtonotupdateproperly,forexamplesomeonehavingthebatchwindowopenwhiletransactionsarebeingentered. Thegoodnewsisthatwhenyoupostthebatch,thosebatchtotalsarenotusedforanything.Theyarethereforyourinformationonly.(Andtheoccasionalpeoplethatusethemforpostingcontrols,butthat’sveryrare.)Whenyoupost,thesystemwillrecalculatethetotalsasneeded,sameaswhatyou’reseeingonthereportyou’reprinting. Ifyoufeelthatyouabsolutelyhavetofixthetotals,youcantryrunningreconcile–MicrosoftDynamicsGP|Tools|Utilities|Purchasing|Reconcile|Batches.Butagain,noneed,justgoaheadandpostthebatchif/whenyou’reready. -Victoria LikeLike Kat Reply January21,2016at11:31pm Needtofindthedetailsthatwereprintedonthecheckremittancedetail.I’veusedseveraloftheviewsyouhavepostedbutnoneofthemshowallitems.InmyexampleIhaveacheckwith75creditmemosandinvoicestowhichitwasapplied.Theuserwouldliketobeabletoretrievethesedetailson-demand.RunningGP2010 LikeLike VictoriaYudin Reply January22,2016at4:21am Kat, ThisisnotpossibleinGP2010,asGPdoesnotstorethedetailsofwhatcreditmemoswereprintedontheremittance.IbelievethisispossibleinGP2015,butyouwouldneedtodosometestingtoconfirmyoucangeteverythingyouneed. -Victoria LikeLike Sean Reply December29,2015at7:32pm IhaveaninvoicethatisinthePM30200,butwithnoapplyinformationinthePM30300.WhenIrunanHATBitshowsup,butwhenIrunjustaregularaging,itdoesnotappear.ItalsoappearsthatapaymentwasvoidedthathasthatsameVCHnumber.So,whichiscorrecthere,theHATBortheregularaging?IftheHATBiscorrectthenhowdoIgetridoftheinvoiceinhistorywithnoapplyinformation?Icannotvoidtheinvoice.Didthevoidofthepaymentsomehowgetinterruptedandcorruptedtheapplyontheinvoice?Also,thisisonourcreditcardvendorusingyourcreditcardmethod.Idon’tknowifthatmakesadifference. LikeLike VictoriaYudin Reply December30,2015at5:46am HiSean, Unfortunately,withoutseeingtheactualdata,it’sverydifficulttosuggestafixandcouldeasilycausemoreharmthangood.IwouldrecommendworkingwitheitheryourGPPartnerorMicrosoftDynamicsGPsupporttohelpyouclearthisup. -Victoria LikeLike PatiP Reply December3,2015at7:21pm HiVictoria,Iamcuriousaboutthefield“ParentVendorID”PARVENIDinPM00200.ThisfielddoesnotappearonanydataentryscreenIcanfind.Isitalegacyitemthatnolongerfunctions,orcouldIaskmyconsultanttoaddittothevendormaintenanceandvendorinquiryscreen?TheproblemwearetryingtosolveforismultiplevendorID’sforcloselyrelatedorduplicatevendors.Weoftenhaveoperationalreasonstomaintaintwoseparatevendors,butthenneedtodoconsolidatedreporting,andcurrentlydon’thaveawaytorelatetwovendorstooneanother. LikeLike VictoriaYudin Reply December4,2015at5:16am HiPati, Myeducatedguessisthatthisfieldwasaddedwithaplantouseitinthefuture.IhavenotseenthatusedanywhereinDynamicsGPuptonow.ThedangerofusingitwouldbethatinafutureversionofGPitmightstartbeingused,whichwouldcauseanissuewithallyourexistingdatainthere.Inaddition,youneedamodifiedwindowtobeabletousethefield. AnotheroptionmightbetouseExtenderandstoreyourparentIDthere,thenyoucanbeconfidenttherewillnotbeanyconflictsinthefuture. -Victoria LikeLike PatiP Reply December22,2015at6:57pm thankyouVictoria.WewilllookintoExtenderasanoption. LikeLike KimberleyStevens Reply January4,2016at5:11pm ItendtoagreewithVictoria.IwouldguessthatGPisplanningtomirrortheNationalAccountsfunctionalityonthereceivablesside. Thisiscommonlyrequestedfunctionality,andiscurrentlyavailablefromanumberofISV’s.Ifthisisabigenoughproblemforyou,youmightconsiderpurchasingoneoftheseadd-onproductsinthemeantime.Google“DynamicsGPNationalAccounts”. OtherwaystogrouplikevendorsforreportingpurposeswouldbetouseClassID’sand/ortoaddaprefixtoyour“like”vendors. LikeLike Amber Reply October1,2015at4:55pm HiVictoria, Iamreceivingthebelowerrormessagewhenexportinginvoices,doyouhaveanideawhatthismayberelatedto? errormessage: Asaveoperationontable‘VSync_SOP_HDR_DOC_WORK_HIST;(45) LikeLike VictoriaYudin Reply October2,2015at5:52am Amber, DoyouhavesomethingfromVsync?Itwouldprobablybebesttoaskthem,asitseemstobetheirSQLobjectgivingyouanerror. -Victoria LikeLike GraysonPippin Reply July30,2015at4:23pm Victoria, I’mtryingtoaddtheAccountnumberthatwasusedfortheinvoice.Sincetheiraremultipleaccountnumbersforeachvendor,Ican’tusethevendor’sdefaultaccountnumber.IsthereanothertableIcantietoPM30200toallowmetopullaccountingnumberbyinvoice? thanks! LikeLike VictoriaYudin Reply July31,2015at7:25am HiGrayson, Ihaveaviewthatmayhelpwiththis:GLDistributionsforAPTransactions. -Victoria LikeLike TPhilpott Reply April6,2015at8:23am DuplicatepaymentsareshowingupinPM30300.Wesuspectthisisbecausetherewasanerrorwhenwefirstsetupthecompany,andithassincebeenfixed.Thisisthrowingoffthe2014HistoricalTrialAgedBalance.CanIdeletetheghostduplicatepaymentsfromthistableinorderfortheHTABreporttoshowwhatwasactuallypaid?Wewouldlikeforthemtojustberemovedandfortherenottobeanyadditionalvoid/journalentriesneedingtobedone. LikeLike VictoriaYudin Reply April6,2015at9:20am IwouldnevereverrecommenddeletinganydatafromtransactionaltableswithoutfirsthavingsomeonethatreallyunderstandstheDynamicsGPtablestructureandtransactionflowwelltakingalookatit. -Victoria LikeLike TPhilpott Reply April6,2015at9:53am Doyourecommendanybooks?Itriedsome,buttheywoundupbeingmorefocusedonusingDynamicsinsteadoftheflowofdataacrosstables.Thankyouforallofthehelpfulinformationthatyouhaveposted! LikeLike VictoriaYudin Reply April6,2015at12:49pm Sorry,Iamnotawareofanybooksthatwouldhelpyouwithenoughinformationtobeabledothisyourself.Youneedtoworkwithsomeonethatcanhelpyoudothis. -Victoria LikeLike Larry Reply April6,2015at1:07pm Iusethissite:https://www.gptablereference.com/fortablereferences.Itdoesn’tdoagoodjobLikethissiteexplainingflow,butitdoescontainthefulltableschematicswhichcanbeveryuseful.Notsurethiswillhelp,butitisagoodtablereferenceforGPandeasytosearch. LikeLike Brian Reply March26,2015at3:16pm Victoria, WherecanIfindthedefaultaccountsenteredonvcardinSQL?Iamspecificallylookingforthepurchasingaccounts. Thanks, Brian LikeLike VictoriaYudin Reply March26,2015at4:20pm HiBrian, What’sa‘vcard’? -Victoria LikeLike Brian Reply March27,2015at1:53pm Victoria, Sorry,vcardisvendorcard.IwasabletofindtheaccountIaddedunderpurchasinginthePM00200table.ThereisafieldcalledPMPRCHIXwhichreferencestheaccountintheGL00100table.TheonlyissueIamfacingnowisthatinGPwhensettingupthedefaultpurchasingaccountyouhavetheoptiontoaddadditionalaccountsclickingthebuttonontherightwiththreelittledots.IamunabletofindoutwherethisinformationisstoredinSQL.Anyideas? Thanks, Brian LikeLike VictoriaYudin Reply March27,2015at2:48pm Brian, Gotcha.ThoseaccountsareinthePM00203table–Ijustaddedittothispage.🙂 -Victoria LikeLike Andrew Reply June23,2015at1:20pm Brian, IhaveavendorlistingviewthatI’mtryingtopullinthePMdefaultaccountaswell,butIdon’tknowhowtolinkthetwotablestogetthePMPRCHIXtoshowastheaccountnumberinsteadoftheaccountindexnumberfromGL00100.Doyouhaveaviewthatyouused?Thanksforyourhelp! LikeLike VictoriaYudin Reply June23,2015at2:33pm Andrew, YoucanjoinGL00105whichholdstheconcatenatedaccountnumber–linkfromPM00203.PMPRCHIXtoGL00105.ACTINDX. -Victoria LikeLike JeremyMichaelBright Reply March24,2015at11:33am Isthereawaytotellwhoappliedpaymenttoaninvoice?Ididn’tseethisinfoinPM30300. Thanks LikeLike VictoriaYudin Reply March24,2015at11:42am Jeremy, GPdoesnotstorethis,sounlessyouhadsomethingsetupaheadoftime,you’renotgoingtobeabletotellthis.😦 -Victoria LikeLike Luke Reply February6,2015at4:24pm Victoria, Thoughit’salmostclicheatthispoint,I’dberemissnottomentionwhataninvaluableresourceyouaretomeandeveryonehere. I’mhavingaverystrangeproblemandI’malloutofideasforsolvingit. Thereisapayablestransaction(Invoice,DOCTYPE=1)thathasfounditswayintothePM30200table.Onthefront-end,wecannotselectittobepaid,despitethefactthatithasnotbeenpaidandstillshowsupasapartofoutstandingA/P.Thetransactionshowsanunappliedamountof0,whichtellsmethatsomethingmustbeappliedtoit.ThereisnomatchingtransactiononthePM30300table. ItfeelsliketheidealsolutionwouldbeforthistransactiontomigratebackovertoPM20000,whereitbelongsandforittostoppretendingthatit’spaid. I’vetriedchecklinksandreconcilesandnothingseemstodothetrick.Also,wecan’tevenvoidit.AnysuggestionsonhowImightreasonwiththislittleguy? Thanks! -Luke LikeLike VictoriaYudin Reply February7,2015at4:53am HiLuke, That’sdefinitelyastrangeone,andasmanystrangethingsasIhaveseen,notoneIhaverunintobefore.Partoftheproblemwithsimply‘moving’therecordfromPM30200toPM20000isthattherearealotofrelatedtables,likedistributions,summaries,PMkeys,etc.thatalsoneedtobeconsideredandprobablyupdated. Youmighthavealreadydonethis,buttheonlyotherthoughtIhadwastoseeif(a)thereareanyothertransactionslikethisand(b)seeifthereareanypaymentssittinginthePM30200orPM20000tableswithtransactionamount<>currentamountalsowithoutapplyrecords?If(a)istrue,youmighthaveasystematicissueandif(b)istrue,youmightsimplybemissingsomeapplyrecords,whichmightbeeasiertofix. IwonderifthismightbeworthacalltoMicrosoftDynamicsGPSupporttoseeiftheycanhelpwithfixingit?😦 Sorrynottobeabletooffermorehelponthis, -Victoria LikeLike Larry Reply October28,2014at10:54am HiVictoria, WearehavingaveryhardtimeauditingtransactionsinGP.IntheGL2000tablewhichisthemaintableforalltransactionsthathavebeenpostedandistheprimarytableweuseeachdaytoseealistofallworkthathasbeenPosted.Itisaveryimportanttableasallfinancialinfoisderivedfromthistableforthecurrentopenyears. WeusetheORCTRNUMfieldinGL2000torelatebacktotheWorktablesthathavebeenaudited. ForExample,thePM1000andthePM10300areauditedandeachtimeatransactionisenteredasummaryofthattransactionisinsertedintoanAudittable. TheVCHNUMWKandPMNTNMBRofthosetablesarewhatshouldenableusetorelatebacktotheGL2000tablesORCTRNUM HoweverwhatwearefindingisthattherearemanyduplicatesinourGL2000ORCTRNUMwhichseemsoddaswouldn’ttheORCTRNUMbeuniquethroughouttheGL2000? HowcanwepreventduplicatesinourGL2000ORCTRNUMfield? LikeLike VictoriaYudin Reply October28,2014at11:03am HiLarry, Iamguessingyou’rereferringtoGL20000(notGL2000)?IfyouhaveatablecalledGL2000,thenthat’snotaGPtableandnotsomethingIcanspeakto.Ifyou’relookingatGL20000,thistablewillhavearowforeachindividuallineonaGLtransaction.Forregular(posting)GLaccounts,thatisaminimumof2linesperGLentry–adebitandacredit.Inreality,manyGLentrieswillhavemorethan2lines.Soyoushouldalwaysexpecttoseeatleast2rowsinGL20000withthesameORCTRNUM.Howyourelatethesetotheoriginaltransactionswillvarygreatlydependingonthetransactionsthemselvesandyourcompany’saccountingpractices,notsomethingeasytoanswergenerically.Hopethathelps. -Victoria LikeLike Larry Reply October28,2014at11:19am ThanksVictoria,yesImeanttheGL20000table.Itshardtoseehereinthepastedtransaction,butbelow,00118874istheORCTRNUMinourGLfortwoseparateunrelatedtransactions.Onewasactuallyin2013andonewasin2014.Itlookslikeonewasatransactionentryandonewasapayment?WouldtheORCTRNUMbethesameforapaymentandapayablesentry? IstheresomethingweshouldchangeinGPtoensurethatNotransactionwouldeverusethesameORCTRNUM? 37396rongl12014-08-0500:00:00.0001900-01-0111:57:01.00011XPM_Cchecks-08012014TWD-00118874 21339ClarenceW02013-12-1200:00:00.0001900-01-0111:01:37.84731121213CW-PM_Trxent-00118874 LikeLike VictoriaYudin Reply October28,2014at12:06pm Larry, Asyou’rejustdiscoveredtheControlNumber(vouchernumber)inPayablesisnotunique.TogetherwitheithertheControlTypeortheDocTypeitwillbeunique.WhileyoucanprobablychangeyourPayablessetuptohavecreditdocsanddebitdocsuseadifferentnumberingscheme,it’snotnecessary,anditwouldnothelpwithhistoricaltransactions.Instead,youcanlinktothePMtablesusingboththeORCTRNUMandtheORTRXTYP–thiswilllinktotheDOCTYPEinPMtables. -Victoria LikeLike Larry Reply October28,2014at12:08pm ThankYou!!!!I’llgivethatatry. LikeLike Tony Reply September24,2014at8:49pm HiVictoria I’mtryingtorepairsomedifferencesinsomepayablespostingssometimeago.ItappearssomeoneknewsomethingwaswrongbecausetheyhavepostedcorrectionsasGLjournals.I’mtryingtogettheheadersbackin,and(workinginacopyofthecompanyatpresent!)I’vegeneratedsomerecordstoinsertintoPM30200generatedfrommissingreferencesfromPM30300.VCHRNMBR. WhatI’mnowtryingtodoishavethe“ReconciletoGL”reportforthatperiodshowthepayablesheaderstooffsetagainsttheGLjournals.Thiskindofworks–butsomedocumentsforMay2011havePM30300.ApplyToGLPostDateinMarchandApril2011,whichkindofmessesupthereportifthedaterangestartswithMay2011–thosedocumentsdon’tappear. Morewidely,I’mnotsureIunderstandwhatthismeansexactly–doyouhaveanyidea? Thanks, Tony LikeLike VictoriaYudin Reply September25,2014at5:08am Tony, IwouldbeEXTREMELYcarefulaboutinsertingtransactionalrecordsdirectlyintothetables,thiscanveryeasilygoverywrong,andyoucouldbeleftwithabigmessinyourGPdata.Ialsodon’trecommendgettingadviceonthisonline.Youwantsomeonethatknowsthisstuffverywelltolookatyourdataandhelpyouwithwhateverneedstobedone.Youalsowantthatpartytoberesponsiblefortheadvicetheyaregivingyou,inthesensethattheywillsupportyouiffutureissuesarisefromfollowingtheiradvice.YoumightactuallybebetteroffworkingwithMicrosoftSupportonthis. Ihopethismakessense. -Victoria LikeLike Tony Reply September25,2014at5:46am ThanksVictoria–noted.Ithinkwhatwemightdoisjustgetthingsstraightenedupinthetestcompanysowecanproducenumbersforthatyear,makesuretheongoingbalancesmatch,andnotdotheequivalentinsertsinthelivecompany. Whateverwentwrongaroundthattimethoughhasleftuswithabitofamessanyway,andatleastthisprocessishelpingusunderstandit.TheoccurrenceofthiscorruptionhasledseniormanagementtosuggestthatweshouldditchGPandmoveimmediatelytosomethingelse,whichisobviouslysomethingIwouldseektoavoid(notsuretheyhaveanyconceptionhowmuchworkisinvolved!) –Tony LikeLike ZafarHaiderKhan Reply September18,2014at11:11am HiVictoria,Ifduringthemiddleofthefiscalyearwechangetheclasscodeforcertainitemtomakethemwarehouse(distributor)itemsinsteadofdrop-ship(agent)items,thenshouldweassignanewvendoridtothoseitemswithvendorclassasdistributororshouldwejustchangethevendorclassfromagenttodistributor.PleasenotethatinoursystemAgentvendorhavedifferentaccountsanddistributorvendorshavedifferentaccounts LikeLike VictoriaYudin Reply September18,2014at12:16pm Zafar, Ingeneralthereisnoissuewithchangingavendorclassanytimeyouwant.Thatsaid,yourquestionsareveryspecifictohowyouareusingGPandyourbusinessworkflow.IwouldbedoingyouadisserviceifIsimplyansweredthemwithoutalotmoreinformationabouthowyouareusingvendorsanditemsandwhatreportingyouaredoing.ItwouldbebesttoaskyourGPpartneroraconsultantthatisfamiliarwithexactlyhowyou’reusingGPtohelpyouwiththis. -Victoria LikeLike ZafarHaiderKhan Reply September18,2014at10:56am HiVictoria,canwechangeavendorclassfromagenttodistributorduringthemiddleofthefiscalyear. LikeLike Carol Reply July9,2014at8:06pm HiVictoria, I’monDynamics2010.TryingtocreateaSQLtableonexcel.Wehavetwocompanies,andtheyeachhavedifferentTAXSCHID,Onecompany’svendorIDstartswithCC.AndtheaccountnumberforthetaxaccountdependsontheTAXSCHID.However,werealisedsomeareenteredincorrectly(TAXSCHID),andthereforetheGLaccountsareincorrect.SoIwanttorunalistwithVendorID,Taxschid,taxamount,andtheGLaccountcode.NotethatItriedtogetthisfromsmartlist,however,thetaxaccountcodewasonlytakenfromthemasterfile,notfromtheactualtransaction.Canthisbefixed? WithSQL,IrealisethatIwillneedPM10100,PM30800,PM20000.AndthatIalsoneedGL00105orGL00100.HowevertheGLtablesdonotlinktothePMtables.Andthatdatafromthereportarenot100%correct.Supervisorsaiditisbecausethetablesarenotlinking. Pleasehelp. Carol LikeLike VictoriaYudin Reply July13,2014at5:45am Carol, IwouldstartwithmyGLdistributionsforAPtransactionsviewandthenaddtheTaxScheduleIDtoit. -Victoria LikeLike JohnJuno Reply July24,2014at8:05am thankyouVictoriaforallyourpostsandinformationyouprovide.WeatBCBSofNebraskaareconstantlysaying“goaskVictoria”. LikeLike VictoriaYudin Reply July24,2014at8:08am ThanksJohn,Ireallyappreciatethat!🙂 -Victoria LikeLike JudyVanDenBroek Reply May31,2014at4:24pm HiVictoria,Thanksfortheallthehelpfulinformationyou’veposted.IamwonderingifthereissomekindofremittanceorotherprintedreportforManualPaymententriesinGP2010?Wearelookingtopayvendorsusingtheonlinebillpaymentfunctioninourbankingwebsite.WhentheseareenteredinPM,whichIthinkwouldbestbedonethroughManualPaymententry,we’dlikesomekindofremittancetoprint,somethinglikethedetailonachequestub,showingtheinvoicesappliedtothepaymentandthepaymentnumber/checknumberweassignwhenenteringinManualPaymententryscreen.Ican’tseemtofindanythingthesuggestshowthismightbedonesinceitdoesn’tseemtobebuiltinaspartoftheentry&postingroutine.Doyouhaveanysuggestions,please? Thankyou Judy LikeLike VictoriaYudin Reply June1,2014at2:38am HiJudy, Iamnotawareofanyexistingreporttodothis,youwouldneedtocreateacustomreport. -Victoria LikeLike Kimberley Reply June2,2014at11:23am WhynotuseComputerChequesinsteadofManualPaymententriesinGP?Thenyou’dhavetheoptiontoprinttheremittances.Youcanuseadifferentnumberingsequencetorepresentyouronlinepayments. LikeLike JudyVanDenBroek Reply June2,2014at12:11pm HiKimberley,Hhmmm,thatsoundslikeagreatpossibility.Howwoulditwork?Becausewedon’twantchequestoprint,withthepaymentsalreadyhavingbeenmade,butifweentertheinvoicesinGP,wouldn’titprintchequesautomaticallywhenweSelectChecksanddotherestofthechequeroutine? LikeLike FabianMunoz Reply May22,2014at10:53am Hello IamattemptingtousesmartlistbuildertocreateasmartlistthatwilldisplayPayments,ApplyToinvoicesandtheexpense(purchase)portionofthedistributionfromtheinvoice. ItriedselectingPMDistributionHistoryFileandPMPaidTransactionHistoryFile.ThisgivesallofthedatabutitdoesnottellmewhatInvoicesareappliedtoaspecificpayment.NotsureifusingSQLserverTableisanoptionsinceIcannotfindacommonfieldtogettheresultsIamlookingfor. Anylightthatyoucanshedonthiswouldbegreatlyappreciated. Thankyou Fabian LikeLike VictoriaYudin Reply May22,2014at11:39am Fabian, IamnotsurethisispossibledirectlyinSmartListBuilderbecauseyouneedtoaddanumberoftableunions.However,thegoodnewsisthatIalreadyhaveaSQLviewpublishedwiththisexactinformation:https://victoriayudin.com/2010/09/23/sql-view-for-payables-apply-detail-and-gl-distributions-in-dynamics-gp/.YoucanjustusethiscodetocreateaSQLview,andthencreateaSmartListpointingtothatview. -Victoria LikeLike Sreedhar Reply May14,2014at12:24pm Victoria, QuestionregardingPM00201.Icanseethelastcheckamt,checknoinPM00201.ButsomevendorsarepaidthroughwireorEFTandIdon’tseeeitherthelastwiredamountorEFTamountinPM00201. IsthereanyothertableIshouldlookatforwireandEFTpayments. Thanks Sreedhar. LikeLike VictoriaYudin Reply May14,2014at12:30pm Sreedhar, PostedandfullyappliedpaymentswillbeinPM30200.PostedandnotfullyappliedpaymentswillbeinPM20000. -Victoria LikeLike Sreedhar Reply May14,2014at12:32pm SoEFTandWirepaymentswontshowupinPM00201? LikeLike VictoriaYudin Reply May15,2014at3:27am Sreedhar, InthiscasethefieldnamesinthePM00201tablecanbetakenliterally.ThistableonlystorestheLastCheckNumber,LastCheckDateandLastCheckAmount.Nootherpaymenttypesareconsidered. -Victoria LikeLike Sreedhar Reply May15,2014at7:55am Ok.Igotit.Thankalotforalltheinformation. LikeLike Chan Reply March12,2014at10:28am HiVictoria, Isthereanywaytomanuallychangeacheck#withintheManualPaymentEntry?IknowifIselectaCheckbookID,itwillusethenextavailablechecknumberthatisset.However,IhavesomesituationswhereIneedtooverridethatchecknumbertosomethingcompletelydifferent.IfIchangethedocumentnumber,wouldthatnumberbeprintedonthecheckasthecheck#?Ordoyouknowanyotherwayofchangingthischecknumberwithouttheusualsequence? Thanksinadvance! LikeLike VictoriaYudin Reply March12,2014at1:11pm HiChan, Ifyouneedtobeabletooverridethechecknumberatthetimeofenteringamanualpayment,thatcanbeenabledwithasettingontheCheckbookMaintenancewindow.(ThereisacheckboxtowardsthebottomofthewindowforOverrideCheckNumber.) Ifyou’reusingmanualpaymententry,nocheckisprinted,soIamnotquitesurewhattherestofyourquestionis–canyoupleaseclarify? -Victoria LikeLike Chan Reply March12,2014at2:38pm Soessentially,IamtryingtodevelopanintegrationtocreateapaymentinPMandspecifythatchecknumberduringcreation.Isthereanywayofdoingthat? LikeLike VictoriaYudin Reply March13,2014at3:04am Chan, Whattoolareyouusingtocreateyourintegration? -Victoria LikeLike Dave Reply January24,2014at1:15pm HiVictoria, WehaveamanualpaymentinGP2013thatappearstobehungup.Thedetailsofthetransactionareasfollows(writtenbytheuserasit’llprobablymakemoresensethanifItrytoexplainit). “GointotheManualPymtscreen..enterpymntnumber(Iusevendornameandinvoice#),pickthecheckbookIwanttouse(creditcard)thenchoosewhichcardfromthedropdown,fillindoc#andcopyittocomment,fillinamounttoapply,clickondistributiontabandcopythedoc#infointothosetwolinesafterverifyingcodenumbersarecorrect,gobacktofirstpageandclickontheapplytab,chooseopeninvoicetoapplythepaymentto,gobacktofirstpage,verifyallinformationiscorrectantclickonpost.” Whenshetrystoapplyittoapayabledocumentittellsherthatit’salreadyfullyapplied.Howeveritdoesnotshowupwhenshegoestopaythecreditcard.ThepostedstatusinPM10200is0andDCStatusinPM00400is2.Basicallyweneedtoknowhowtoeitherdeletethewholethingorforceittoapplytothecreditcardintheinitialstep.IapologizeifthismakeslittlesenseasIdon’treallyuseGPnoramIafinancialperson.Sometimeswejusthavetosupportitasbestwecan.Thanksinadvanceforanyhelp! LikeLike VictoriaYudin Reply January24,2014at4:49pm HiDave, ThefirstthingIwouldtryittorunchecklinksagainstthePurchasingseries.Oncethatcomesbackwithnoerrors(youmighthavetorunitmorethanonceforthat)thenrunReconcile.Thismightclearuptheissue.Ifnot,you’regoingtohavetofixthedataintheSQLtablesdirectly,whichisnotsomethingIwouldwanttogiveadviceonwithoutactuallylookingatthedata. -Victoria LikeLike AdilRaja Reply October9,2015at3:45pm HeyDave,doyourecallhowdidyoufixthisissue,i’mhavingthesameexactissue,andi’mnotsurewhattodo.idohavegreatknowledgeofsqlbutunsurewhichtablestoalter,ifneedsbethatis. LikeLike CarrieJohn Reply January14,2014at11:46am HiVictoria, Iamwonderingifthereisanywaytochangethedocumentdateonapostedinvoice.WearecurrentlyusingGP10,sowedon’thavethedocdateverifytoolyet.AnAPrephasenteredabunchofinvoiceswithanincorrectdocdateandI’mnotsureifthisissomethingthatcansafelybemodifiedthroughSQL.Thankyouforyourhelp! LikeLike VictoriaYudin Reply January14,2014at1:19pm Carrie, IwouldnotrecommendmodifyingthesedirectlyinSQL.Thereanymanytablesinvolvedanditwouldbeveryeasytocauseanevenbiggerissue.Ifthesearenotpaidyet,youcanvoidthemwiththesamedocandGLdatesthattheywereenteredwith,thenre-enterthemwiththecorrectdates. Also,DocDateVerifyisavailableforGP10.0.🙂 -Victoria LikeLike Amanda Reply December26,2013at10:18pm HiVictoria, Inpreparingforyearend,we’vefoundavendorcheckwithlessthanapennyremainingintheCURTRXAM($.0028).Weonlyuse2decimalpointssoIcan’tfigureoutwhyithasmoreorhowgettheAPdocumenttomovefromPM20000toPM30200withoutchangingoursystemdefaults.Anyideas? LikeLike VictoriaYudin Reply December27,2013at7:52am HiAmanda, Ihaveseenthishappenwhendataisimportedwithmorethan2decimalplaces.GPwillacceptupto5decimalplaces,butwillonlyshowyouwhatyourcurrencyissetupfor.IamnotawareofanymethodtocleanthisupwithoutfixingitintheSQLtables.Sincetherecouldbemanytablesaffected,youwillmostlikelyneedtoworkwithyourGPPartnerorMicrosoftDynamicsGPSupportsotheycanlookatyourdataandhelpyoufixthis. -Victoria LikeLike kristopercanico Reply December17,2013at5:50am Hivictoria: DoyouhappentoknowhowPM10300tablegetspopulated?I’vedonethefollowingscenariosinGPtocheckifthetablegetspopulated 1.CreateanInvoicetheninstantlyassociatewithpaymentbyprovidingvalueonCashfield. Result:PaymentisassociatedtoinvoiceontablePM10000notonPm10300 2.CreateaPaymentusingManualpayment Result:PaymentissavedonPM10400 3.CreateapaymentthenapplyonOpenInvoice Result:PaymentissavedonPM10400 AllthisscenariodoesnotpopulatePM10300.CanyouspecifyscenariowhereinPM10300getspopulated? Thanks!andgreatworkbytheway. Kristoper LikeLike VictoriaYudin Reply December17,2013at6:45am HiKristopher, ThePM10300tablegetspopulatedwhenyoucreateabatchofcomputerchecks. -Victoria LikeLike MikeBresnan Reply November5,2013at4:06pm Heyvictoria,we’rehavingastrangeissuewithourEFTpayments.WeuseMICR,andeveryonceinawhile,ourEFTbatchgoesstraighttoposting(noscreentoprintremittancereports,etc),anditprocesseswithblankchecknumbersforeachEFTtransaction.weenduphavingtoturnonduplicatechecknumbers,processthebatchfrombatchrecovery,voidalltheEFTpayments,andthenprocessthebatchagain.Anyideawhatmaybehappening? I’vesatwiththepersonwhoprocessesthepayments,andnothingappearstobedifferentfromasuccessfulEFTbatch,untilthepasswordisenteredanditgoestoprocess,andskipstheremittancescreen. LikeLike VictoriaYudin Reply November6,2013at5:30am HiMike, Sorry,Ihavenotrunintothisbefore.Whenyousayyou’reusingMICR,doyoumeanMekorma’sMICRproduct?Ifso,Iwouldsuggestaskingthemiftheyhaveseenthisbefore.Otherwise,youmightneedtoturnonsomeloggingbeforeeveryEFTbatchruntoseeifyoucantrapthisinalogandexamineinmoredetail. -Victoria LikeLike Robert Reply October10,2013at6:28pm Victoria, Isthereatablethatholdsremittoaddressthatwasprintedonacheck? LikeLike VictoriaYudin Reply October11,2013at3:52am HiRobert, Unfortunately,no.Thecheckwillusetheremittoaddressontheinvoice(s)itwasappliedto.YoucanseethisaddressIDintheVADCDTROfieldinPM30200.ThiscanlinktothePM00300tablefortheactualaddress.However,iftheaddresswaschangedafterprintingthecheck,thereisnorecordofitkept.😦 -Victoria LikeLike Robert Reply October11,2013at7:10am ThankyouVictoria LikeLike uma Reply October9,2013at4:45pm HiVictoria, ImtryingtofigureoutthechecknumbersformyPurchasingPaymenthistorytransactions.IfoundprettymucheverythingthatineedinPM30200tablehoweverthecheckno/checkbookidisblankforallthetransactionsinthetable.Isthereanyitherwayicouldfindthechecknumber.Iappreciateyourtimeandhelp. Thanks, Uma. LikeLike VictoriaYudin Reply October9,2013at4:52pm HiUma, ThechecknumbershouldbetheDOCNUMBRforpaymentsinthePM30200table. -Victoria LikeLike uma Reply October9,2013at4:55pm HiVictoria, Ithoughtdocnumberistheinvoicenumber.IfDocNumberisthechecknumberwhatwouldbetheinvoicenumber?😦 LikeLike VictoriaYudin Reply October9,2013at4:58pm Uma, InPM30200youhaveonerecordforeachtransaction.Aninvoiceisonetransaction(DOCTYPE=1)apaymentisanothertransaction(DOCTYPE=6).Evenifyouenterthematthesametime,GPwillcreate2separatetransactions.Foraninvoice,theDOCNUMBRfieldwillholdtheinvoicenumber.Forapaymentwithacheck,theDOCNUMBRfieldwillholdthechecknumber. -Victoria LikeLike uma Reply October9,2013at5:09pm Oh!okSogetcheckfortheinvoicedoihavetojoinPM30200toPM20000onVouchernumber? LikeLike VictoriaYudin Reply October9,2013at5:17pm Uma, WhynotjustusemyApplyInformationview? -Victoria LikeLike ZalmyC Reply April6,2016at3:31am HiVictoria, IfoundafewrecordsinourPM30200wheretheDOCTYPEis6buttheDOCNUMBRisnotnumeric(e.g.12345Aor12345.).Istherenotyperestrictiononthechecknumberfield?Thanks! LikeLike VictoriaYudin Reply April6,2016at5:50am HiZalmy, ChecknumbersinGParestrings,justlikeallotherdocumentnumbers. -Victoria LikeLike chev Reply September10,2013at12:24pm HiVictoria, IsthereanyothertablethanPM30200whereIcanfindPLPaymentHistoryinformation.Thanksforyourtime. Thanks, Chev. LikeLike VictoriaYudin Reply September10,2013at1:01pm Chev, Canyoupleaseexplainwhatyoumeanby“PLPaymentHistory”?It’snotatermthatIrecognize. -Victoria LikeLike chev Reply September10,2013at1:52pm hIVictoria, sorryimusthavebeenmorespecific.ImtryingtofindpaymenthistoryforvendorswithdetailslikeInvoicenumber,Checknumber,Paymentdate,Paymentamount,Clearedstatus,Accountingyear,periodetc. Thanks, Chev. LikeLike VictoriaYudin Reply September10,2013at1:55pm Chev, NotsureifIhaveaviewwitheverythingyouarelookingfor,butpleasetakealookatthelistofpayablesviewsIhavepostedhereandseeifoneofthemwillgetclose. -Victoria LikeLike Joel Reply September4,2013at7:14pm HiVictoria, WherewouldIfindoutifavendoristaxexemptornot?-Thanks, LikeLike VictoriaYudin Reply September5,2013at8:24am Joel, YoushouldbeabletousetheTEN99TYPEtypefieldinthePM00200table.Herearethevalues: 1–Nota1099Vendor 2–Divident 3–Interest 4–Miscellaneous 5–Withholding -Victoria LikeLike Joel Reply September5,2013at3:59pm Thankssomuch. LikeLike Noah Reply December30,2014at1:23pm Arethese1099Typevalues/descriptionsstoredinaSQLtable?Ifso,whichone? LikeLike VictoriaYudin Reply December30,2014at3:41pm Noah, AreyoureferringtothevaluesfortheTEN99TYPEfield?Ifso,Idonotbelievetheyarestoredinatableanywhere. -Victoria LikeLike Michelle Reply July31,2013at11:50pm HiVictoria, Ihavefoundyourresourcesofgreatuse.Thanks. IamnewtoGPandinvolvedwithadatamigrationfromGP10.0.Iamattemptingtoidentifythetable/swheretheaccountbalancepervendorisrecorded–historicalifavailableorifnotavailablecurrentbalancewouldbesufficient.Areyouabletoprovideanyassistancewithtablenames/SQLtoobtainthis? Thanks Michelle LikeLike VictoriaYudin Reply August1,2013at8:18am HiMichelle, GPdoesnotstorehistoricalvendorbalances.ForthecurrentbalanceyoucanlookattablePM00201. -Victoria LikeLike Michelle Reply August1,2013at7:11pm Greatthanks. LikeLike FrankG Reply July24,2013at6:14pm Thankssomuchfortheresourcesyouprovide. Isthereanywaytoretrievetheoriginalinvoicepaidfromavoidedcheck?ItappearsoncethecheckisvoicedandinvoiceisunappliedtherecordisnolongerinPM30300. Ineedtobeabletoreportonwhattheoriginalinvoicewasatthetimeofthevoid. Thanks Frank LikeLike VictoriaYudin Reply July25,2013at3:59am Frank, ThisinformationisnotstoredanywhereinGP.Sounlessyoucreatesomethingcustomtotrackit,thereisnowaytoreportonit. -Victoria LikeLike RussCobbe Reply June14,2013at2:49pm IhaveanewaccountingpersonusingSBFandsheispointingoutsomeshortcomingsthatIhopeIcangetaroundonewayoranother.Usinganolderversion9.00.0115 Whenpayingavendoryoucanselecttheinvoicestopaybutinsteadofshowingthevendorinvoice#isshowsthevoucher#.Wellthatisn’thelpfulinanyway.Canitbechangedtoshowthevendorinvoice#?Myagedpayableslistsareincorrectaswell.Iselectdaterangesanditgivesjustoddresults.Idoseeinthepm20000tablethatalotofvalidinvoiceshaveacurtrxamvalueof0.Somedoandsomedon’tbutasfarasIcantellnoneofthemshouldhaveavalueof0andmaybewhytheyarenotshowingonreports.Anyideawhythismightbehappening? ShouldIupdatetothelatestinthe9.xseriestofixsomeodditiesweareseeing? LikeLike VictoriaYudin Reply June16,2013at4:30am Russ, ThevouchershowinginsteadofthevendorinvoicenumberissomethingIrememberfromoneofourSBFcustomersthatweconvertedtoDynamicsGP.Idonotthinkaservicepackwilladdressthis.AndIamnotawareofeasywayto“change”this.IamnotsureifanyoneisofferingcustomizationsforSBFanymore,sinceitwasdiscontinuedalongtimeago.ThisisdefinitelynotthecaseinDynamicsGP,thereyoucanselectinvoicesusingtheinvoicenumbers. Astoyourotherquestion,theremaybedatathatdidn’tgetpostedproperly,difficulttodaywithoutlookingatitinalotmoredetail.Again,Iwouldnotexpectaservicepacktofixit,thisismoreofadataissue.It’sbeenyearssinceIlookedatSBF,Idon’thaveitinstalledanywhereorhaveanycustomersusingitanymore,soIcannotcheck,butifthereisachecklinksoptioninthere,Iwouldtrythattoseeifitfixesanything(makesuretomakeabackupfirst).Also,considerrunningthe‘historicalagedtrialbalance’instead,thatmayhavebetterresults. -Victoria LikeLike RolanHinayon Reply June13,2013at9:20pm HiVictoria, Gooddaytoyou,Wereceivedanerror“Unhandleddatabaseexception: Asaveoperationontable‘PM_Distribution_HIST’hascreatedaduplicatekey” AfterwetriggerBacthRecoveryprocess. Thankstoyoursiteifoundideaonhowtotraceit,butthistimeithasdifferentoutcome asisearchthetablePM_Distribution_HIST(PM30600)notransactionfound.Amiinthe righttrack?Anysuggestionsfromyouwouldbehighlyappreciated… ThanksandGodbless RolanVH LikeLike VictoriaYudin Reply June14,2013at5:29am HiRolan, Thiskindoferrormayindicatethatyouhaveatransactionthatisinmultipletablesatthesametime.ThisarticlebyDavidMusgravemighthelp. -Victoria LikeLike RolanVh Reply June14,2013at3:14pm HiVictoria –somuchthanksforquickresponseandlinks,Godbless. -RolanVH LikeLike RyanDasalla Reply May6,2013at12:52pm Victoria,I’mtryingtoprintoutareportfordifferenttypesofpayments(i.e.ACH,Wire,Checkandcreditcard)foreachperid,likefromApril1,2013toApril30,2013.IsthereawaytodothisinGP2010? RyanD. LikeLike VictoriaYudin Reply May6,2013at1:03pm Ryan, IbelieveyoucanuseSmartListforthis–underPurchasing>PayablesTransactionsaddacolumncalledPaymentEntryType. -Victoria LikeLike RyanDasalla Reply May6,2013at2:08pm Isee!ThankyouVictoria!Butthisonlywouldworkifeachpaymententryarecodedcorrectlyright?Forexample:0=Cash,1=Check,2=CreditCard&3=EFT.Otherwisethesmartlistswillnotseparateit. Ryan LikeLike VictoriaYudin Reply May6,2013at3:19pm Ryan, Whywouldthedatabeincorrect?Areyoupushingitdirectlyintothetables?Orenteringitincorrectly? -Victoria LikeLike RyanDasalla Reply May6,2013at3:26pm Victoria, Whoeverisdoingthecashapplicationisnotcodingitorsimplyusingauto-cash/autopayment,that’swhyIcan’tdifferentiatewhetherthepaymentthatwaspostediseithercash,check,EFTorcreditcards.What’syoursuggestion(s)sothatthisreportcanbemade? Ryan LikeLike VictoriaYudin Reply May6,2013at3:32pm Ryan, Ifthedataisnotenteredanywhere,howcanyoureportonit? -Victoria LikeLike TomVoss Reply April26,2013at10:04am Victoria–Anychanceyoucantellmewhatfield/tabletheactuallyentrydateforapayablestransactionwouldbestoredin?Ineedthedatethatitwasphysicallyenteredandnotthedocumentdateortransactiondate.Anyhelpyoucangivewouldbemuchappreciated,we’vebeensearchingeverywhereforthis.Thanks! LikeLike VictoriaYudin Reply April26,2013at10:14am HiTom, Itsoundslikeyouarelookingforsomethinglike‘createddate’whichisnotstoredinGP.😦Theclosestyoucangetmaybethemodifieddate(lastdatesomeonemadeachange),whichisMODIFDTinbothPM20000andPM30200.Inmostcompaniesthiswillbethesameasthecreateddate,butIcanthinkofsituationswheretheywouldbedifferent. -Victoria LikeLike Aaron Reply April17,2013at2:19pm hiVictoria, iamtryingtocreateareportandicouldnotfindfollowingfields.couldyoupleaseletmeknowwhattableandname? vendorcheck#,checkdate vendorinvoice#,anddate thanks, aaronnguyen LikeLike VictoriaYudin Reply April17,2013at2:23pm Aaron, Thosefieldsarestoredinmanydifferenttables.YoumightwanttotakealookatmypagewithPayablesSQLviews,Ithinkyouwillprobablyfindsomethinghelpfulthere.Ifnot,canyougivemeabetterideaofwhatyouaretryingtoshowonyourreportandIwilltrytohelp. -Victoria LikeLike Aaron Reply April17,2013at2:38pm Victoria, iamtryingtogetdataforsalestaxauditingpurposes.fieldsiamlookingforincludevendorname,vendorid,voucher#,vendorinvoice,batchnumb,PO#,frtamnt,taxamnt.ifoundsomeoftheminPM00200andPM30200. selecttop500a.VendName,a.VendorID,a.Address1,a.Address2,a.Address3,a.City,a.State,a.ZipCode, ”[Check#], ”[CheckDate], b.VCHRNMBR[Voucher#], ”[VendorInvoice#], ”VendorInvoiceDate, b.BACHNUMB[Batch#], b.DOCDATEBatchDate, b.PORDNMBRPoNumber, b.FRTAMNTFreightAmnt, b.TAXAMNTTaxAmntPaidtoVendor, b.DOCAMNTTotalInvoiceAmnt, ”GLDistibution–actdescr fromPM00200a(nolock)innerjoinPM30200b(nolock)ona.VENDORID=b.VENDORID thosefieldswithblankvalueareoneineedyourhelp. thanks, aaron LikeLike VictoriaYudin Reply April17,2013at3:09pm Aaron, Areyoulookingtoshowthecheckandtheinvoicethatitpaidonthesameline?Ifso,thenyouwanttostartwithmySQLviewforPayablespaymentapplydetailinGP.Thecheck#willbeinthePayment_Document_Numbercolumn,checkdateisPayment_Date,invoice#isApply_To_Doc_NumberandinvoicedateisApply_To_Doc_Date.Youmayneedtoaddsomeoftheotherfields,butthoseshouldbeeasierthanrecreatingtheapplyinformationquery. -Victoria LikeLike Tom Reply March22,2013at12:17pm Myusershave2218vendorstheywanttodelete.doingitmanually,evenusingtheMassDeletefeature,willbeverypainful.TheycametomeinITtoseeifIcanhelp.DoesanyoneouttherehaveascripttodeleteVendors? LikeLike Vic Reply February7,2013at11:50am HiVictoria Ihavegotaquestion,IhaveaclientwhowantstoshowtheremittoaddressonthePMTransactionPostingJournal.Inthepreviousversionsaddingthevendoraddressworked,butnowthereisatablethatholdstheselectedinformation.However,thattable,PM10300PaymentWorkisnotassociatedwiththedefaultreport. IknowthereisawaytolinkthetablebutIcan’tseemtofigureitout. Thanks Vic LikeLike VictoriaYudin Reply February7,2013at11:56am HiVic, Sorry,IamnotagoodsourceforhelpwithReportWriter,asImuchprefertoworkwithCrystalandSQLforreportingandthatiswheremyexpertiseis.IwouldrecommendpostingquestionsaboutReportWriterontheGPCommunityForum. -Victoria LikeLike Todd Reply January17,2013at12:47pm Victoria, WehavebeengettingpayablestransactionsthatuserssaywereneverpaidbutareinthehistorytablePM30200withzeroCURTRXAMandnopaymentappliedtothem.ThisseemstobehappeningmorenowbutIcan’tseemtofindoutwhy.WeareonGP2010v11.00.2044(SP3).Anyideasastowhatcouldbehappening?ThereisonlytheonerecordinPM30200,noothertables.Weendupremovingandtheyre-enter. Thanksinadvance Todd LikeLike VictoriaYudin Reply January18,2013at4:53am HiTodd, IdonotbelievethisisaknownissueandIhavenotheardofsomethinglikethishappeningbefore.Haveyouconfirmedthatthesetransactionsarenotvoidedandarenotenteredfor0dollars?Doyouhaveanycustomizationsor3rdpartyproducts?Arethesetransactionsimportedorenteredmanually? -Victoria LikeLike Todd Reply January18,2013at9:49am Ithinkwemayhavefoundwhybutnothow.Weseemtobehavingsomestrangenetworkissueswherewearelosingconnectionforabrieftimeandthenreconnecting.itseemstocasuesomereallyweirdissues.Iwillletyouknowexactlywhatwefindwhenwefinishourinvestigation. Thanksforthepromptreply. LikeLike RonMcVicar Reply January4,2013at10:53am WantingtodosomeanalysisofVendorsandRemitToAddressesandpayments.IsitpossibletoobtaintheRemit-ToIDforapayment?IstheRemit-ToIDstoredinpayablestransactiontables?Ifsowhatwouldbethetableandfieldname? LikeLike VictoriaYudin Reply January7,2013at4:54am HiRon, GPdoesnotstoretheremittoaddresswiththepayment,soyouwouldneedtoexaminetheinvoicesandtheirremittoaddresses.YoucouldprobablystartwithmySQLviewforPayablespaymentapplydetailinGPandaddtheinvoiceremittoaddresstothat. -Victoria LikeLike PamelaStreet Reply December18,2012at5:43pm Theamountsinthetablesarenotmatchingeachother.WeareoncalendaryearsoIusehisttype=‘0’InPurchasingwhenIgotoCards/SummaryandgotoYearly,theAmountssincelastcloseandthecalendaryeardonotmatchforabout50vendors… LikeLike VictoriaYudin Reply December19,2012at8:52am Pamela, Unfortunately,‘AmountsSinceLastClose’arenotnecessarilygoingtomatchthecalendaryearandthatisexpectedbehavior.IreallywishMSwouldjusttakethoseoptionsout,alltheydoisconfusepeople.Takealookatmyyearendcloseblogpostandthediscussions(aswellasthecomments)thereabouttheAPandARsubledgeryear-endclose.TheAPandARsubledgeryear-endcloseisoptionalandcanbedoneatanytime,andabouttheonlythingitdoesisupdatethe‘amountssincelastclose’,‘yeartodate’and‘lastyeartodate’statistics. So,forexample,ifyourantheAPyear-endcloseprocessandhadnotpostedallofyour2011payablestransactionsyet,the‘amountssincelastclose’willincludewhatever2011transactionswerepostedaftertheclose,justasthelabelsuggests.ItypicallyadviseuserstoonlyusetheCalendarYearorFiscalYearoptionswhenlookingatthesummaries,thosewillactuallycalculatethevaluesshown. Hopethathelps. -Victoria LikeLike JohnBorn Reply November15,2012at1:29am HowaretheDOCAMNTandCURTRXAMfieldsusedinthePM20000table?IamseeingtheCURTRXAMfieldzerosometimesandothertimesitequalstheDOCAMNTorisavaluelessthantheDOCAMNT.Iassumeitislessifapaymenthasbeenpartiallyapplied.TheonlyreasonIsawthattheyweredifferentisb/cIamtryingtouseadownloadedAPagingforSmartlistanditonlysumsPM20000transacctionswhereCURTRXAMis0.Thanks, LikeLike VictoriaYudin Reply November15,2012at4:54am John, DOCAMNTistheoriginalamountofthetransaction,CURTRXAMistheamountstillunappliedonit.YoushouldnothaveanyrecordsinPM20000wheretheCURTRXAMis0,asGPshouldautomaticallymovethosetoPM30200.Ifyoudohavethese,thensomethinghasmostlikelygonewrongandyouneedtodosomecleanuponyourdata. -Victoria LikeLike JohnBorn Reply November15,2012at3:55pm ThereasonthePM20000tablehadtransactionswithaCURTRXAMamountof0isb/ccheckbatchesweresettinginRemittanceProcessingstillwaitingtobeposted.thankforthefeedback. LikeLike BillieDee Reply November12,2012at6:48pm Hiagain,Victoria– Ihaveanotherstuckpaymentbatch.IcanseewhatIassumearetheinvoicesinPM10201andIcanseethepaymentsinpm10301.ButIcannotfigureouthowto“unmark”thebatchsothatmycheckprocessorcanprintthesechecks.Anysuggest/recommendationwouldbeappreciated.Yes–therewasasystemglitchwhileshewasposting/printing. LikeLike VictoriaYudin Reply November13,2012at4:52am HiBillieDee, Lasttimeyousaidyou‘reset’thebatchinSY00500.Mostlikelythefixisthesamethistime.Checkbatchesareverytrickysometimesandthefixoftendependsonwhenitgotstuck(whatstepoftheprocess).Ifthesekindsof‘systemglitches’arehappeningoften,Iwouldstronglyrecommendtryingtoaddresswhateveriscausingthem,sothatyoucanavoidhavingtofixstuckbatchesaswellasotherpotentialdataissues. -Victoria LikeLike BillieDee Reply November13,2012at12:21pm Thankyou,again,Victoria.We’retryingthatout.Abouttheongoingproblem….Iknow.We’reworkingonthat,too.There’sno“quick”solutionavailableatthistimesoIhavedodealwiththefiresastheyoccur. LikeLike JimG Reply October15,2012at7:44pm Victoria,Ihopeyoucanhelpme.I’mdevelopingsomeintegrationthatrequiresthatIinsertanewrecordinPM10100,aswellasanumberofothertables.ThetroubleI’mhavingisthatIcannotfindaspecificationonthedefinitionof,orvalueneededforCURRNIDX.I’vesearchedanddugforarelationshipthatthismighthavewithanothertablethatdefinesthevaluesandtypes,buttonoavail. Anyguidanceyoucanprovidewillbedeeplyappreciated. Thanks Jim LikeLike VictoriaYudin Reply October16,2012at4:18am Jim, CURRNIDXisthecurrencyindex,whichyoucanfindforeverycurrencyyouhavesetupinGPintheMC40200tableofthesystem(DYNAMICS)database.IfyouarenotusingMulticurrency,youcanjustcheckwhatyourotherrecordsinthattablehaveandhardcodethat.IfyouareusingMulticurrency,thenyouwillneedtopassintherightcurrencyindex. -Victoria LikeLike JimG Reply October16,2012at12:44pm Thankyouverymuchforyourexplanation.ItpointedtoexactlywhereIneededtobe.AsimplelookupcallandIhaveallIneed…..forthatcolumn.😉 Unfortunately,Iranacrossoneothercolumninthissametablethatisbafflingmeandnoinformationismakingitselfvisibletome.TheDistributionSequenceNumber,DSTSQNUMcolumnoffersplentyofinformationanddocumentationaboutthefactthatitisthesequencenumberforagivendistribution,butthereisnothingIcanfindthattellsmewhatvaluetoassignanewrecord.Ihaveafeelingthisoneisgoingtobemoreinvolved. Thankyouagain.Youhavebeenalifesaver. Jim LikeLike VictoriaYudin Reply October16,2012at2:08pm Jim, Thatissimplyasequencenumberthatistypicallypartofwhatmakesthelineunique.Itisalsosometimesusedforsorting.Beforeyouaretemptedtosimplyuse1,2,3,etc.forthese,youmightwanttoreadthisblogpost:http://dynamicsgpblogster.blogspot.com/2008/07/scrolling-windows-and-line-sequence.html. -Victoria LikeLike JimG Reply October17,2012at2:09pm Victoria, EverythingisnowgoldenandI’mwrappingupmyproject.Thankyouagainforyourirreplaceableassistance.Andthankyouforthissitewhichwasanamazingresourceforamonthpriortodirectlyaskingquestions. Ifyou’reeverinPhoenix,lunchisonme! Jim LikeLike MyrnaCabanilla Reply October11,2012at3:58am HiVictoria, It’smeagainMyrna,IhaveaproblemagainbutthistimeinPayablesTransactionModulewhereinIneedtovoidtransactionwhichwaspartiallyapplied?Isitpossible? ThankyouandBestRegards. Myrna LikeLike VictoriaYudin Reply October11,2012at8:17am Myrna, Doesthisblogposthelp?https://victoriayudin.com/2012/10/11/voiding-a-partially-applied-payables-transaction-in-dynamics-gp/ -Victoria LikeLike billiedeej Reply October5,2012at11:42am Hi,Victoria– Thankyouforbeingthe#1resourceonGP.ThoughI’venotpostedbefore–Ihaveusedyouradviceandsuggestionsquiteoften.Thankyou. Today:Ihavealostcheckbatch.Ihavebeenresearchingthefollowingtables: PM10000–doesn’texistinthetable PM20000–itemsdoexistinthetable PM10100–yes PM10200–no PM10300–thebatchdoesexisthere WhentheuserranPrintPayablesChecksshereceived:Unhandleddatabaseexception:Asaveoperationontable‘PM_Payment_WORK’causedasharingerror. WhenwetrytoselectthebatchinPayablesBatchEntryIgetthemessage:Thisbatchcannotbeedited.PleaseverifythebatchstatususingtheBatchIDswindow. I’mcurrentlyataloss.Canyousuggestanextplanofaction? LikeLike BillieDee Reply October5,2012at3:30pm Imanagedtogetitsolved.IhadtoresettherecordinSY00500anditworked. LikeLike VictoriaYudin Reply October8,2012at9:30am BillieDee, Thanksfortheupdate,gladyougotitresolved. -Victoria LikeLike DaveOxtoby Reply September21,2012at1:30pm Victoria,notsureifthisisinthecorrectthreadbutIwaswonderingifthere’sawaytochangeaninvoicenumberinGP10aftertheinvoicehasbeenposted.Iconsideredchangingallinstancesofthenumberviaaquery(itseemstoshowupmostlyinPMtablesinthecompanyDB)butifthere’sacleanerwaytodoitI’dpreferthatmethod.Thanks, LikeLike VictoriaYudin Reply October1,2012at6:06am Dave, ThereisnowaytochangeaninvoicenumberintheDynamicsGPuserinterface.DoingthisdirectlyinSQLisnotsomethingIwouldrecommendbecausetherecouldbedozensoftablesinvolved,allwithdifferentnamesforthecolumnwiththeinvoicenumber.Ifyoumissjustone,you’reputtingyourdataintegrityasrisk.Itmaybeeasiertovoidtheinvoiceandre-enteritwiththepropernumber. -Victoria LikeLike Erica Reply September19,2012at1:52pm HiVictoria Ireceivedthefollowingerrormessage: Asaveoperationontablepm_transaction_openhascreatedaduplicatekey SoIlookedupthiserrormessageandfoundthatIhaveatransactioninboththePM10000table(work/unpostedtranactions)andthePM20000table(open/postedtransactions) IknowIshouldhavethesametransactioninbothtables.ThetransactionshouldbeinPM20000tableonly.HowshouldIgoaboutgettingridofthetransactioninthePM10000table? LikeLike VictoriaYudin Reply September21,2012at8:30am HiErica, FirststepIwouldrecommendwouldbetorunchecklinks,althoughitmaynotfixthis.WhenIhaveseenthishappeninthepast,Ihavehadtogointothedatabasedirectlytofixthis.Unfortunately,withoutlookingatthedataandtherelatedtransactionsinothertables,itisimpossibletosaywhatexactlythefixshouldbe.Ifyouare100%certainthateverythinginthePM20000tableandrelatedtablesisfine,youcandeletetheentryfromthePM10000tableandrunchecklinkstoremovealltherelatedrecordsforthatunpostedentry.Ifyouarenot100%comfortablewiththis,IwouldrecommendgettingsomehelpfromyourGPPartnerorGPSupport.IamnotabigfanorrecommendingfixeslikethisdirectlyinSQLwithoutlookingatitmyself. -Victoria LikeLike PapillonErreca Reply August30,2012at6:24pm Ihaveaninvoicethatdoesnotshowupunderthecustomertransactioninquiry.Buttheinventoryisshowingallocated.Ihaveaprintedcopyoftheinvoice,butcan’tfinditinthesystem.Ihaverunchecklinks,butandreconcilebutcan’tseemtofindthismissinginvoice. Anyhelpwouldbegreat. LikeLike VictoriaYudin Reply August31,2012at6:07am Papillon, Soundslikemaybetheinvoicedidn’tpostyet.YoupostedthisquestionunderPM(payables)tables,butthissoundslikeaSalesOrderProcessinginvoice?IfIammisunderstanding,pleaseletmeknow. FirstthingIwouldstartwithislookingforthisinvoiceinSmartList.UnderSmartList|Sales|SalesTransactionsaddacolumncalledDocumentStatusandthendoasearchforyourinvoicenumber.(ThesearchshouldbeSOPNumberisequaltoYourInvoiceNumber.)Doesitcomeup?WhatistheDocumentStatus? -Victoria LikeLike PapillonErreca Reply August31,2012at8:16am Victoria, SorryforpostinginthewrongforumIamnotsurewhetherIshouldswitch,butIthoughtIwouldreplytoyourthread. Theinvoicedoesappearinmysmartlistreport.Thedocumentstatusisshowing“New”,butwhenyoutrytoopenit,itstatesithasalreadybeenposted. LikeLike VictoriaYudin Reply August31,2012at8:50am Papillon, DocumentStatusshouldonlyhavevaluesofPostedorUnposted.IfyouareseeingNew,youaremostlikelylookingatSalesDocumentStatus,whichisadifferentcolumn.CanyouconfirmWhattheDocumentStatussaysforthisinvoice?Also,howmanytimesdoesthisinvoiceshowupinthelistontheSalesTransactionsSmartList? -Victoria LikeLike PapillonErreca Reply August31,2012at9:42am Victoria, Itshowsunposted,butdoesnotappearinabatchavailabletopost. LikeLike VictoriaYudin Reply August31,2012at9:56am Doesitonlyshowuponce?Whereareyoulookingtoseethatit’snotinabatchavailabletopost? It’spossiblethatanotheruserhasthetransactionlocked.Unfortunately,withoutlookingatit,it’sdifficulttohelpfurtherandyoumightneedtogetyourGPPartnerorGPSupporttohelpyouwiththis. Ifyouwanttotryitonyourown,youcouldtrythefollowing: MakesureallusersareoutofGP,makeabackup,thenrunthefollowinginSQL: deletefromDYNAMICS..ACTIVITY deletefromDYNAMICS..SY00800 deletefromDYNAMICS..SY00801 deletefromtempdb..DEX_LOCK deletefromtempdb..DEX_SESSION Oncethatisdone,runCheckLinksontheSalesSeries. -Victoria LikeLike PapillonErreca Reply August31,2012at10:47am Nootheruserhasitopen.Itonlyshowsuponce,itisinonebatch,howeverwhenyouruntheEditListforthebatchisdoesnotappear.Andwhenyoutryandselectitfromthesmartlistyoucan’tevenopenit,itjustcomesupandsaysithasalreadybeenposted. Itisalmostasifitpartiallyposted,butitisnotinastuckbatch. Iwilltryrunningyourscript. Thankyouforyourhelp. LikeLike MichaelBender Reply August27,2012at1:16pm WearemovingfromGP10toGP2010andInoticedtheAPsectionhaschangedabitespeciallywhenitcametoEFTisthereanydocumentationonthis? LikeLike VictoriaYudin Reply August27,2012at2:36pm HiMichael, IbelievethereisasectiononEFTtables/transactionflowsintheGP2010SDK.LookforitunderElectronicBanking.Thatsaid,IdonotbelievetoomuchhaschangedbetweenGP10andGP2010forEFT.Wastheresomethingspecificthatyounoticedachangein? -Victoria LikeLike MichaelBender Reply August27,2012at4:06pm Iwilllookintothedocument.Ihavenothingspecificyetwearestillintestingphase.Ijustsawafewthingsweredifferentoraddedespeciallyincheckprocessing. LikeLike ZafarHaiderKhan Reply August3,2012at9:59am HiVictoria,thankyouverymuchformaintainingsuchahelpfullwebsite. AnyideawhichtablecontainsthedataforAdditionalInformationfieldofInternetInformationformwhichwegetwhenclickiicononVendorAddressMaintenanceform. Regards. LikeLike VictoriaYudin Reply August3,2012at10:15am HiZafar, ThatisintheSY01200table.ThefieldisINETINFO. -Victoria LikeLike ZafarHaiderKhan Reply August3,2012at11:38am HiVictoria, Thankyousomuch.Youarethebest. LikeLike BillRyan Reply July20,2012at11:13am HelloVictoria, RecentlyIwroteaCashRequirementsSQLreportusingthePM20000table,everythingonitwasgooduntilmyaccountingdeptnoticedanissuewithavailablediscounts.IhadwrittenthereporttousetheDISCAMNTwhentheduedatewaslessthanthecurrentdatewhichworkedfine. Here’swhattheproblemis: SomeofourvendorsdonotsticktotheirdiscounttermsandchangeitperinvoiceormaysetaspecificduedatebasedonwhentheinvoicewasshippedsoinsteadofusingtheDISCAMNTortheDISCDATE(whichisbasedofthevendordiscountterms)theywanttohavethetermsonthedocumentinstead.Whattableandwhatfieldwouldthatbein?I’vebeenlookingfortwodayswithoutfindinganything…Thanks! LikeLike VictoriaYudin Reply July20,2012at11:17am HiBill, Iftheusersareenteringthiswiththeinvoicesusingthepaymentterms,thenIbelievethediscountdatewillbestoredinthePM20000tableintheDISCDATEfield.Forthepercentageofthediscountyouwillmostlikelyneedtogotothepaymenttermstable–SY03300.Hopethathelps. -Victoria LikeLike BillRyan Reply July20,2012at1:13pm ThanksforthatVictoria,isthereanywaytoshowthetextoftheTermsfield?I’mtoldwehaveseveralvendorsthatwemanuallychangetheamountforandthedateisn’treallywhatthey’relookingforonthereport.SomeofourvendorsacceptdiscountedpricingevenafterthetermtheyspecifysowereallywantittojustshowtheTermsfield.SomeofthetermswehavealsohaveasetdateortwosetdatesinamonththatitgetspaidonandthismessesuptheDISCDATEfieldsoitshows(forexampleonethathasatermof“1%10thor25th”meansdependingonwhenitcomesinthediscountof1%it’seitheronthe10thofthemonthorthe25thofthemonthdependingonthedateitcamein)itautomaticallygives1%forthe10dayperiodaftertheDOCDATEandnotactuallyonthe10th. It’sreallyconfusingandultimatelyiftheycanhavethetermsfieldshowthey’lljustdothedeterminationontheirown.Isthereanywayofjustshowingthattext? LikeLike VictoriaYudin Reply July21,2012at5:12am Bill, ThatisalsointhePM20000tableinthePYMTRMIDfield.Isthatwhatyou’relookingfor? -Victoria LikeLike BillRyan Reply July24,2012at9:12am Idobelievethisisit!Thanksabunch! LikeLike BenH Reply June22,2012at7:04am HiVictoria,Aseveryoursiteissuperuseful,alwaysuseitforreference! IhaveaquestionwhichIhopeyoucanhelpwith–WehaveacoupleofhundredPMtransactionsonasinglecreditorwhichhavebeenfullyapplied(i.e.currenttrxamountiszero)butthedocumentstatusisstillOPEN–I’vetriedreconcilingthecreditoraccount,andalsorunningchecklinksforpurchasing,butnothingismovingthesetransactionsintohistory. IhavesomeSQLknowledge,soIcouldmanuallychangethemtohistory,butnotcertainoftheimplications… Manythanks Ben LikeLike VictoriaYudin Reply June22,2012at8:03am HiBen, Thanksforthekindwords! Idon’ttypicallyrecommendmovingthesetohistorymanually,thatwouldbethelastresort.CanyouseeifyouhaveduplicateapplyrecordsfortheseinthePM10200andPM30300tables?Ifthesetransactionsareinvoices,you’relookingfortheAPTODCNMtobetheinvoicenumberandAPTODCTYtobe1.Ifyoufindthesamerecordinbothtables,thenIwouldtestdeletingtherecordfromPM10200,thenrunningReconcileforthevendortoseeifthatmovestheinvoicetohistory. -Victoria LikeLike JoePellerin Reply June6,2012at2:48pm Victoria–thankyousomuchforthisexcellentsite!Iappreciateboththeinformation,andyoursuperhelpfulandpositiveattitude! Idohaveaquestion,though,relatingtotheDOCTYPEfieldinthePM30200table–inALLofthedocumentationthatIamabletofind(which,ofcourse,mustnotbeeverything)Icanonlyfindthevaluesfor1-6.However,IamshowingDOCTYPEsof7(afairlysmallnumber,though–60outof160k).WhatdoesthisDOCTYPEtranslateto? LikeLike VictoriaYudin Reply June6,2012at2:57pm HiJoe, Thanksforthekindwords! IhavenotseenaDOCTYPEof7inanyofthedataIhaveworkedwith.Soitiseithersomethingprettyuncommon,orsomethingcustom.CanyoutakealookatthetransactionsforthisdoctypeintheGPuserinterfaceandseeifyounoticeapattern? -Victoria LikeLike JoePellerin Reply June6,2012at3:07pm Well–it’sodd,butnothingseemsoddaboutthese.Theyhavedescriptionslike“MONTHLYRENT”,“parkingincrease”,and“REFILLPOSTAGEMACHINE11PAYM”. Thisisversion10.00.1061. IguessI’lljusthavetopulloutacoupleandhavetheclientinvestigate. Thanksforrespondingsoquickly,Victoria!🙂 Joe LikeLike BillBreitenbach Reply September25,2012at3:51pm DOCTYPE7isapayablesscheduledpayment.(Transactions…Payables…ScheduledPayments) Bill LikeLike Rhon Reply May30,2012at6:11am HiVictoria, IjustwanttoaskaboutthePhysicalTablenameofPayablesTransactionEntryDistribution? I’mtryintofinditonthePMtables.butIcan’tseemysampledata. Thankyousomuch. -Rhon LikeLike VictoriaYudin Reply May30,2012at8:24am Rhon, PM30600holdsdistributionsforhistoricaltransactions.PM10100holdsdistributionsforworkandopentransactions. -Victoria LikeLike Rhon Reply May30,2012at9:47pm thankyousomuchvictoria. LikeLike BillRyan Reply May23,2012at3:23pm YoursitehasbeenimmenselyhelpfulformeandIwantedtothankyouforthat.I’vealsojustpurchasedyourbook! LikeLike VictoriaYudin Reply May24,2012at3:54pm HiBill, Thankyousomuch! -Victoria LikeLike DonaldWisch Reply March16,2012at10:06am Victoria, Thankyousomuch.Thiscompletelymakessense.now. Cheers~Don LikeLike DonaldWisch Reply March15,2012at2:47pm Victoria, Whatagreatsiteyouhavebuilt.Lotsofgreatinformation.Idoappreciateit.Ihaveaquestionforyou.HaveyoueverrunintoasituationwhereanAPcheckisvoidedbutthevoidedcheckhasnodistributions? Thanksinadvance. Don LikeLike VictoriaYudin Reply March16,2012at6:44am HiDon, Thanks!Yes,thishappenswhenacheckisvoidedpriortobeingposted.Forexample:Iamprintingchecks,IclickPrintonthePrintCheckswindowandsomethinggoeswrongwiththeprinting…or,likeIjustdidyesterday,Ihadmyprintersettoduplexandmychecksprintedonbothsidesofthecheckstock.So,rightaway,IchosetoReprintthechecks–thisautomaticallyvoidsthefirstsetofchecksandreprintsanewsetofthem.Theoriginalsetofchecks,theonethatwasautomaticallyvoided,hasnoGLdistributions.Hopethishelps. -Victoria LikeLike Ben Reply March7,2012at5:45pm HeyVictoria, DoyouhappentoknowhowtorunaSQLquerythatmimicsthePMHATBDetailReport?I’dliketoaddafewcolumnsbydoingajoinstatementthatwouldincludethingsliketheGLAccount#,whichIcouldusetheVoucher#toconnectto,butIcan’tfigureoutwheretheDuePeriodfieldsarefound(i.e.Current,1-30Days,31-60Days).AlsonotsurehowtorunthatquerytolookatthedatabaseAsOfacertaindate.I’velookedalloverforanswersbutcan’tseemtofindanything.Anythoughtswouldbehelpful,thanks. LikeLike VictoriaYudin Reply March9,2012at3:23pm HiBen, SivaVenkataramanhasanumberofHATBscriptspostedonhisblog,hereisoneforthePayablesHATB. -Victoria LikeLike Ben Reply March9,2012at6:35pm QuitepossiblythebestnewsI’vereceivedallweek.THANKYOU,Victoria! LikeLike ASH Reply February23,2012at1:30pm HelloVictoria, Awesomework,Ican’tbelieveIhadn’tdiscoveredyoubefore! Pleaseyourkindhelpwiththis: Forsomereason,accountingstoppedusingthe“ApplyTo”procedureinPayablessince2008!TheypassedpaymenttransactionsdirectlytotheaccountthroughtheGLTransactionsentryform.NowwehavethousandsofopenPayablesTransactionssincethen(theydidentertheinvoicesinthePayablesTransactionform).OfcourseVendorbalances&agingistotallywrong. Whatwouldbeyouradviceforustodoherekeepinginmindthatstarting1/1/2012Itrainedourpeopletousethe“ApplyTo”procedureproperly.Butalltransactionbefore1/1/2012arestillopen. Myideas: –Deletealltheoldopen/historicalpayabletransactionsfromwithintheDBusingSQL(don’treallyknowhowtodothatbutwillingtolearn) –Foreachvendorcreateachequethatwillbe“AppliedTo”alltheoldopentransactionstoclosethemandthenvoidthecheque(don’tknowhowthisaffectstheGLandwhetheritwillmessanythingup) WearestillonGP7.0by-the-way. MuchobligedandGodblessyou! LikeLike VictoriaYudin Reply February23,2012at6:41pm ASH, IwouldrecommendenteringaCreditMemo(notapayment)forthetotalamountyouwanttoclearoutforeachvendor.Applythecreditmemostoalltheoldopentransactionstowipethemout.Ifyoudon’twantthesecreditmemostochangetheGL(becauseitisalreadycorrect),youcanusethesameaccountforthedebitandcreditsideofthecreditmemos. -Victoria LikeLike ASH Reply February24,2012at8:50am OK,thatsoundsgood.ButwehavesomanyVendorsitwouldbeverytimeconsumingtodothis. Howaboutdeletingtheopen/historicaltransactionsfromwithintheDB?I’vebeenresearchingthedifferenttablesinvolvedtodothis(PM10100,PM30200,PM30300,PM30600,etc..)..wouldyoubeabletopointmetowhereIcandisectthisissue(fromwhichtablestodelete)andknowhowremovingtheserecordswouldaffectothertables,totals,etc.. Withmanythanksagain! LikeLike VictoriaYudin Reply February24,2012at8:54am Ash, Iwouldstronglydiscourageyoufromdeletinganythingdirectlyinthedatabaseandwouldfranklynotfeelcomfortablegivingsomeonedirectionsonthis.Bestcasescenario,youwillnothavedatathatyouneedlater.Worstcasescenario,itwillbreakotherthings.Haveeachofyourusersenter10adayofthese.Itwilltakesometime,butitwillallgetdone. -Victoria LikeLike ASH Reply February24,2012at11:48am Wiseadvice,Ithankyouforyoursupport.Wewilldoasyouindicated. LikeLike ASH Reply February24,2012at12:27pm Sorrytore-openthesubjectbutIwanttofurtherask: Whatifwedon’tcareaboutthepurchasingtransactionscanwerun“File>Maintenance>ClearData”toclearthePurchasingtransactionsandthenentervendoropeningbalancesfortheyearandstartfromscratch.WouldthatprocessproducethisresultorwoulditdestroysomeotherdataintheDB? Thanks! LikeLike VictoriaYudin Reply February24,2012at3:23pm Ash, Unfortunately,youwouldloseeverythingyouhavealreadyentered(correctly)sinceJan1,asthereisnowayto‘selectively’cleardata.It’sprettymuchallornothing.Again,thisisnotanapproachIwouldrecommend. -Victoria LikeLike ASH Reply February25,2012at5:02am Muchobliged.. LikeLike AlecM Reply February10,2012at5:20pm HelloVictoria, FirstoffthankyoufortheawesomeGPresource! Sorryifyou’vecoveredthisbeforebutI’mlookingforawaytolink“DateInvoicePaidOff”inthePM30300tabletoSOPNUMBEinSOP30200.IsawyourPayablesApplyDetailviewbuttheapplytoandapplyfromdocnumbersdon’tseemtocorrespondtoanyoftheSOPnumbersIcouldfind. LookingforthislinkagesothatIcanfilteralistofSOPNUMBEsbasedondatewhenthey’vebeenpaid. Thanksagain. LikeLike AlecM Reply February10,2012at5:24pm Sorry“DateInvoicePaidOff”(DINVPDOF)isinPM30200notPM30300. LikeLike VictoriaYudin Reply February11,2012at10:32am HiAlec, ThereistechnicallynoSOP(SalesOrderProcessing)toPM(PayablesManagement)linkinGP,however,dependingyourbusinessandtransactionflowitmaybepossibletolinkthesewithafewstepsin-between(includinginventoryandPOP). Canyougivemesomebackgroundonhowyouneedtousethis?Foryourbusiness,whatisthebusinesslogiclinkinginvoicessenttocustomers(SOP)withpayablesinvoicespaidtovendors(PM)? -Victoria LikeLike AlecM Reply February12,2012at1:01am Sure.I’mtryingtobuildaSQLviewthatwillbeusedtocalculatecommissionsforoursalesrepsincrystal.IhavetheviewselectandfilteralltheSOPlineitemsthatcommissionwillbecalculatedfor,thelastfilterneededistoselectonlyinvoicelineitemsthatwerepaidoffonthepreviousmonth. Wehavesmartliststhatgivethisinformation,unfortunatelyIhavenoideahowthesystemislinkingbehindthescenes. I’mnotwellversedinfinancialstuff(learningslowly)butfromwhatIgatherpostedinvoicessituntilwereceivepayment,thenonceamonththecreditmanagerwriteschecksouttobalanceaccountsandatthatpointtheVPoffinancecan“see”whichinvoicesare“paidoff”inoursystemandcalculatecommissions. SorryI’mnotsureifthatwasanyhelp.IfIneedtoaskmoredetailedquestionsfromourfinancedepartmentpleaseletmeknow. Thankyouverymuchforlookingatthisforme! LikeLike VictoriaYudin Reply February12,2012at5:31am HiAlec, Thanks,yes,thatdoeshelp.Forwhatyouhavedescribed,youshouldbelookinginRM20101andRM30101fortheDatethe“DateInvoicePaidOff”field–thosearethereceivablestables.(Receivablestableshavecustomertransactions,Payables,whereyouwerelooking,arevendortransactions.)IhaveaseparatepagewithRM(ReceivablesManagement)tablesandalsoapagewithSQLviewsforReceivablesthatmightbehelpful.ForlinkingtoSOPtables,SOPNUMBElinkstoDOCNUMBRandSOPTYPE3=RMDTYPAL1forinvoices.Ifyou’realsoincludingreturnsinyourreportingthenSOPTYPE4=RMDTYPAL8. Hopethathelps, -Victoria LikeLike AlecM Reply February14,2012at2:15pm Wownice!Thatworkedperfectlyforme. MuchappreciatedVictoria. LikeLike VictoriaYudin Reply February14,2012at2:19pm Alec, Excellent–thanksforthefollowup.Andsorryformisspellingyournamebefore,Ishouldknowbetterthantotypebeforefinishingmyfirstcupofcoffee.🙂 -Victoria LikeLike Mike Reply January30,2012at5:46pm Hivictoria,yoursiteisveryhelpful! Irecentlyranintoastrangeissueduringbankreconciliation.WearerunningGP10,andreconciledon1/9,theOutstandingTransactionsReportgivesadifferent(higher)totalthantheoutstandinglineontheReconciliationPostingJournal.Iwentthroughthelist,anditseemsthatallthetransactionsthatmakeupthediscrepancywereclearedon1/3.Asfarasiknow,thesereportsareautomaticallyprintedwhenyoureconcile,sotherecouldn’thavebeenadateissue.inthepastthesehavetiedtothepenny.Everheardofthishappening,whatthecausecouldbe?Werunonacalendaryear,buttheyearendprocesseswerenotrunbeforethesetrxwerecleared. thanksforyourhelp! LikeLike VictoriaYudin Reply February1,2012at4:47am HiMike, ThisdoesnotsoundlikesomethingIhaverunintointhethepast,butit’sreallydifficulttotellwithoutactuallyseeingit.😦HaveyouaskedyourGPpartnertolookatthisforyouandseeiftheycanprovidesomeguidance? -Victoria LikeLike Khona Reply January27,2012at4:27am HiVictoria, InwhichtablecanIfindcreditore-mailaddressesinGP10? LikeLike VictoriaYudin Reply January27,2012at11:52am Khona, IfyouareenteringthisontheInternetInformationwindow,itisstoredintheSY01200table. -Victoria LikeLike JoeSpitler Reply January24,2012at12:52pm Victoria, I’maSQLDBAwithminimalaccountingskillsbutstrongSQLskills.MycontrollernoticedthatintheAPSmartListshowingvendorinformationthat1099boxnumberisnotidentified.IamtryingtofigureouthowtodoaSQLquerytoshowitbutIamgreatlyconfusedwiththerelationshipbetweentablesPM00200andPM40104.Therearemultipleperiodsin40104forexamplebutwhenIlookataparticular1099venderinGPthereissimplyaboxnumberintheoptionssectionofthevendormaster.Canyoushedsomelightonthisforme?DoyouhaveoneofyourspiffyviewsthatIcanuseforacustomSmartList?Thanks–Joe LikeLike VictoriaYudin Reply January24,2012at1:02pm HiJoe, PM40104issimplythesetupoftheminimumsforeach1099type/boxcombination.Areyoulookingtoshowthe1099boxsetupforeachvendor?Ifso,thatisstoredinthevendormastertable(PM00200)intheTEN99BOXNUMBERfield.Ifthat’snotwhatyoumeant,pleasegivemesomemoredetails. -Victoria LikeLike JoeSpitler Reply January24,2012at1:07pm Wow,Okay,Ioverlookedthat.HowcanIgetthedescriptionofthebox? LikeLike VictoriaYudin Reply January24,2012at1:17pm Joe, Thisisaweirdone.FromwhatIcansee,theinitialdescriptionsarehard-coded…atleastIdon’tseewheretheywouldbeinatable.Sotheonlyplaceyoucanseethemisonthe1099Setupwindow(GP|Tools|Setup|Purchasing|Payables|click1099Setupbutton).However,assoonasyouchangeoneofthose,theywillshowupinthePM40104table.Isupposeifyoureallywantedtohavetheminatable,youcouldgothrougheachbox,addanxorsomethingtoeachdescription,save,thengobackandtakethex’soutandyouwillhavepopulatedthePM40104withthedescriptionsthatyoucannowlinktoinSQL. -Victoria LikeLike JoeSpitler Reply January24,2012at3:34pm Thatisweird.Butyoursuggestiondoesindeedwork.Thanks. LikeLike JoeSpitler Reply January24,2012at3:39pm ActuallythereisstillsomethingIdon’tunderstand.AparticularvendorinPM00200hasTEN99TYPE=4andTEN99BOXNUMBER=7.HowevertherearenorowsinPM40104withTEN99TYPE=4.Infactbasedonthedescriptionitlookslikeitsaboxnumberwithtype=3.Whatdoyouthinkaboutthis? LikeLike VictoriaYudin Reply January24,2012at4:10pm Joe, Iamnotseeinganythingaboutthisinthedocumentation,butbasedonthedatainourGP,Iamguessingthatyouneedtosubtract1fromtheTEN99TYPEwhenyouarelinkingfromPM00200toPM40104.Inotherwords,PM00200.TEN99TYPE-1=PM40104.TEN99TYPE Lookslikethiswasalittlecodingsnafuwhenthenew1099stuffwasaddedacoupleofversionsago.;-( -Victoria LikeLike JoeSpitler Reply January24,2012at4:21pm Well,thatwillcertainlywork.ItwillbeinterestingtoseeifmySmartListbreaksonedayifthisgetsfixedinaupdate.Thankssomuchforyourhelp. LikeLike VictoriaYudin Reply January24,2012at5:19pm Joe, Gladthatisworkingforyou.Inmyexperienceitisveryunlikelythatvalueslikethiswilleverchange,andIhavenotseenGPdothisinthepast.This1099functionalitywasaddedinGP10.0,whichcameoutover4yearsago.Sothishasbeeninthecodeforsomethinglike5+yearsifyouconsiderthedevelopmentandbetatestingtimeframe.Thereisamisspellinginoneoftheinventorytables,whereafieldnamesays‘ATY’insteadof‘QTY’andit’sbeenthereaslongasIremember.Ithinkit’sjusteasierforallconcernedtoleavethesethingsastheyare.🙂 -Victoria LikeLike David Reply December31,2011at12:56am HiVictoria, I’vegotabitofamessonmyhandsthatI’mhopingyoucanhelpmewith.Therearetwoseparatebutsimilarissues. 1.Apayablesbatchwascreated.Therewere36checksinthebatch.Uponcompletingthebatchitwasrealizedthatthewrongcheckdatewasused.Theentirecheckbatchwasvoided.TheproblemisthatthebatchgotpostedtotheGLviaFinancialSeriesPost.Butthevoidtransactionsweredeletedinthefinancialbatches.Theuserdidn’tthinkthattheinitialtransactionshadpostedtotheGLsowasattemptingtopreventallofthechecktransactionsfromhittingtheGL.Buttheresultisthatthetransactionsshowasvoided,butonlythecheckbatchprocesshittheGL.Anyideas? IwanttobesurethattheAPAgingdoesn’tgetmessedupandoutofalignmentwiththeBalancesheetintheprocessofallthis.. 2.Similartothefirstissue,butthistimeitwasaninvoicethatwasvoidedratherthanacheck. WhenweenterinvoicesitistypicallyDr2191(AccruedPurchasesClearing)&CR(AcctsPayable).Asaresultofvoidingtheinvoiceinthepurchasingmodule,theinvoiceshowsvoided.ButthecorrespondingentriesweredeletedoutoffinancialbatchesandneverpostedtotheGL.IcouldmakeaentrytotheGL,butwouldthatthrowofftheAPaging? Sorryforthelongpost.Anyhelpwouldbegreat! LikeLike VictoriaYudin Reply January1,2012at12:08pm David, Ingeneral,IwouldrecommenddisallowingdeletingtransactionsintheGL.Thatwillonlygetyouintomoretrouble–sincethereisnorecordofwhatwasdeletedyounowhaveamuchmoredifficultjobwhenlookingtofixthis.Exceptforsomeexceptionalcircumstances,itistypicallybettertoleteverythingpost,thencreateadjustments.AnditsoundslikeyoualreadyknowthatPurchasinginvoicesshouldnotbevoidedinPayables.Theuservoidingthisshouldhavegottenawarninglettingthemknowthisisnotadvised.Ifthisisanotanisolatedincident,considerlimitingaccesstotheVoidwindow(s)forusersthatmaynotfullyunderstandtheimplications. Allofthatisforthefuture,though.Specificallyfortheseissues,Iamhesitanttoofferadvicewithoutlookingatthedatainyoursystem.Therearejusttoomanymovingpartsandwiththingshavingbeendeleted,IwouldnotbecomfortablethatIhavethefullpicturewithoutcheckingitmyself.Forexample–withthecheckbatchtherearealsoBankRecimplications.Forthevoidedinvoice,theremayalsobeInventorytobeconsidered.Andwithpartialinformation,anyfixessuggestedmayonlymakemattersworse.IwouldrecommendworkingwithyourGPpartnerorGPSupporttoworkthroughthese. -Victoria LikeLike Kevin Reply December29,2011at6:17pm HiVictoria, Ihopealliswell.I’veencounteredaroadblock.I’venoticedthatthere’sapayabletransactioninvoiceinOPENstatuswithanonzerobalance.Whentheuserprintedthechecksshenoticeda0.53centbalance.Shevoidedthe0.53centandnowit’sinOPENstatuswithabalanceof0.53cent.HowcanwemovethistoHIST?CanweleavetheinvoiceinOPENstatuswhenexecutingouryearend?ThanksVictoria. LikeLike VictoriaYudin Reply December30,2011at9:12am HiKevin, IamnotawareofanywayinGPtovoidaninvoicepartially,soIsuspectitwasnot$0.53leftunpaidontheinvoicethatwasvoided.Maybeacheckwascreatedforthe$0.53centsandthatcheckwasvoided?IfyougotoInquiry|Purchasing|TransactionbyVendor,bringuptheinvoiceanddinsthatinvoice–whatdoesistheUnappliedAmountforit? Whileitiscertainlybesttocleanthingsuppriortoperformingmonthendoryearendtasks,havinganopenbalanceonatransaction(whetherrightornot)shouldnotpreventyoufromperformingtheyearendclose.Norwouldhavingatransactionwithanopenstatusinsteadofhistorycauseanyproblemsfortheyear-endroutineinpayables.Althoughmy2centsisthatthepayablesyear-endcloseisnotneededformostcompaniesanyway,andcansimplybeskipped.Italkmoreaboutthathere. -Victoria LikeLike LaTeesha Reply December13,2011at1:08pm HelloVictoria, I’mtryingtocorrectapayalbestransactionthathasthewrongpostingdate,butwhenIgoinTools,Transaction,Financial,General,IselectedCorrect,backoutajournalentry.Igetthiserrormessage“ThistransactonwasenteredinPayblesManagementandcannotbecorrectedinGeneralLedger,UsePayablesManagementtocorrectthetransaction”.IsthereanythingthatIcando? LikeLike VictoriaYudin Reply December16,2011at6:54am LaTeesha, IfyoucorrectthisintheGLyouwillnotfixtheissueinPayables.That’swhatthemessageistryingtotellyou.Ifyou’reokwithsimplyfixingitintheGL,youdon’tneedtousethe‘Correct’option,youcansimplyenteraGLtransaction.However,ifyouwanttofixitinbothPayablesandGL,youmayneedtovoidthetransactioninPayables,thenre-enteritwiththeproperdates. -Victoria LikeLike Mike Reply November4,2011at4:49pm Hi, Wearehavingproblemswithshipmentmethodsdisappearingfromvendorrecords.Onceortwiceaweekanywherebetween1and10vendorslosethissetting.Thereare3vendorsthisoccurstoregularlybuttheyarenottheonlyonesithappenstoo.Haveyouheardofthishappeningbefore?orknowwhatmightbecausingit?WeareusingGP10.Thanksforyourhelp. Mike LikeLike VictoriaYudin Reply November7,2011at7:02am HiMike, Ihavenotseenthishappenbyitselfinout-of-the-boxGP.AndIcannotimagineascenariowherethiswouldhappenwithouteitheruserinterventionintheUIorsomecustomprocessupdatingrecordsinthedatabase.Notsurehowmuchinvestigationyouhavedonesofarintothis,butherearesomequestionsthatmayhelptrackthisdown: Isitpossiblethatauserismakingchangestovendorclassesandrollingdownthechanges? Isispossiblethatauserischangingthisduringdataentryforsomereason?Noonewillprobablyadmittothis,butit’sworthasking… Shippingmethodsforvendorsareaddressspecific.Isitpossiblesomeoneischangingthedefaultaddressthatisshowingonthemainvendorcard?OraretheshippingmethodsdisappearingfromtheVendorAddressMaintenancewindowaswell? DoyouhaveanyimportsofdataintoGPgoingon?Doanyofthemupdatevendorinformation? DoyouhaveanySQLtriggersonthePM00200andPM00300tables?Outofthebox,Ibelievethereisonlyonetriggerenabledforeach:zDT_PM00200UandzDT_PM00300U.(IamlookinginGP2010,butIbelieveitshouldbethesameinGP10.0.) TakealookatthetimestampintheDEX_ROW_TScolumninboththePM00200andPM00300tables.(RememberthisisUCT,soyouwillneedtoconverttoyourtimezone.)Thiswillnottellyouwhochangedthedata,butwilltellyouwhenitwaschangedandmightgiveyouanideaastothecause.Forexample,ifallofthemarechangedatthesametime,thenit’snotauserchangingtheseoneatatimeandifyouknowyouhavesomethingelsescheduledatthesametime,thatmaygiveyousomeideas. DoyouhaveanythinginplacethatmaybesynchronizingdatabetweenGPandanothersystem?WetypicallyseethiswithCRMandcustomers,buttheconceptisthesame. Ifnoneofthishelps,youmightconsidercreatingatriggeronanychangestothePM00200andPM00300tablessothatyoucantrackdownwhatiscausingthis. -Victoria LikeLike Mike Reply November7,2011at11:52am HiVictoria, Thanksforyourhelp.Itlookslikesomeonewasmakingchangestovendoraddressesandthatwasclearingtheshipmentmethod. Mike LikeLike AubreyO.Mokgadi Reply October25,2011at6:08am HelloVic, MySummaryandDetailedInquiryarenotthesame,pleasehelp?,Itriedutilitiesreconcileinallmodules.Evenchecklinks,stilltheproblempersists. LikeLike VictoriaYudin Reply October25,2011at6:36am Aubrey, IfReconcileandCheckLinksdidnotfixit,youwillneedtoinvestigateyourdatatofindoutwhatiscausingthedifferenceandbasedonthatworkonfixingit.Ifyoudonothaveexperiencewiththis,IwouldrecommendgettinghelpfroyourpartnerorGPSupportforsomethinglikethis. -Victoria LikeLike DivyanshuBansal Reply October5,2011at2:59am HiVictoria, Ihaveascenariowhereineedtounapplysomeofthepaymentsfrominvoicesafterthepaymentiscreatedbyselectchecks.IhaveastoredprocedurethatrunsafterthebatchiscreatedwhichremovestheappliedpaymentsfromtheinvoicesanddeletesthepaymentnumberifalltheinvoicesaredeletedforthatVendor.Everythingworksfineifthedistributionaccountsaredefaultwhentheinvoicewascreated(onedebitaccountandonecreditaccount). Iamhavingproblemwhendistributionininvoiceisdividedintomultipleaccounts.Inthiscaseiamnotsurehowthecashaccountsarepickedwhenthepaymentiscreated.IfIneedtounapplypaymentfromoneoftheinvoiceshowdoiknwfromwhichaccountsineedtoremovetheinvoiceamounts. ForexampleIhaveaninvoicewhichhastwopurchaccountsandtwopayaccounts. Onthepaymentthepayaccountsremainsamebutthepurchaccountsarereplacedbytwocashaccounts?HowdoesGPselectthosecashaccountsforthepayment? Thanks -Divyanshu LikeLike VictoriaYudin Reply October5,2011at3:13am Divyanshu, ApaymentcreatedbyGPshouldhaveonecashaccountandoneormorePayablesaccounts,nottheotherwayaround,soit’spossiblethereisanissuewithsetupinyourGP,whereinsteadofapayablesaccountsomethingissetupwithacashaccount.However,mybiggerquestioniswhyareyoudoingthis?IamalsonotclearonwhyyouneedtodoanythingwithGLaccountsifallyou’redoingisdeletingapplyrecords? Asageneralrule,manipulatingdatalikethisoutsideoftheGPuserinterfaceissomethingIwouldadviseagainst,asyouareputtingtheintegrityofyourdataasrisk.Attheveryleast,ifyouhavedecidedthatitisworththeriskandyouabsolutelyhavetodothis,youneedtoworkwithsomeonethatknowsthetransactionflowandtablesinGPverywelltohelpyoucreateandtestthis. -Victoria LikeLike Depar Reply September27,2011at6:03pm HiVictoria, I’mhopingthatyoucanhelpme.Hereisthescenario: PurchaseOrderisraisedinWorkplaceforaninventoryitem. ThepurchaseorderisthenreceiptedthroughGreatPlains. ThenitisinvoicedthroughGreatPlains. Whenit’sinvoiced,theinvoicingbatchgetsfrozennotallowingusertocontinuteposting–thebatchgetsmarkedwiththestatusof1.WheninquiringonthisinvoicethroughEnquiry–>PurchasingbyCreditor,theinvoicecomesupblank–i.e.onlytheheaderexists.ThedetailsoftheinvoicecanbeseenthroughthePOPmodule. Couldyoupleasehelpfigureoutwhat’shappening? Muchappreciated, Depar LikeLike VictoriaYudin Reply September28,2011at4:25am HiDepar, Iwouldstartwithrunningchecklinksonthepurchasingseriestoclearthisup.Ifthatdoesnothelp,youmayneedtogetsomehelpfromyourGPPartnerorGPSupportonthis,sinceitwillmostlikelyinvolveclearingthisupdirectlyinthetables. -Victoria LikeLike Depar Reply September28,2011at5:12pm ok–thankyousomuchVictoria.🙂 LikeLike Jay Reply August30,2011at3:18pm greetings.Greatsite,hasbeenveryhelpful.IhaveajobwhereI‘piecetogether’tablesfromvariousAPsystems.I’mveryfamiliarwiththepm30200andpm30300tables.Iknowthatthingsthatarevoidedinthehistoricaltransdonotjoinbacktothe‘applyto’table,yetI’dliketobeabletoputtogetherthefulldetailforthesevoidedchecksandinvoices(eg.toseewhatinvoiceswentwiththevoidedchecksandviceversa). Isthispossible?Doyouknowwhatothertablesareneededinordertodothis?thnxmuch,J LikeLike VictoriaYudin Reply August30,2011at4:09pm Jay, TomyknowledgeGPdoesnotkeeptrackofthehistoricalapplyinformationforvoids.Onceatransactionisvoided,alltheapplyrecordsaredeleted.Unlessyoucreateyourownadditionaltrackingforthis,Iamnotsurehowyoucanreportonthis. -Victoria LikeLike Jay Reply August30,2011at4:24pm Thanksforthequickreply.Noneofitreallyhindersus,butit’stheonlysystemweworkwiththatbehaveslikethis.It’salsotheonlysystemwhere‘credits’areameansofpayingoffaninvoice,whereasintheothersystemsthecreditsarenegativeinvoicesassociatedwithacheck.ButtheGPdatamodelisalllogicalandrational.NowSAPotoh… LikeLike NijuDavid Reply July31,2011at3:50am HiVictoria, Couldyoupleaseadvisehowitispossibletogetthesupplierbalanceasofanydatebyexportingthedatabasetoexceloraccess. Thankingyouinadvance Regards NijuDavid LikeLike VictoriaYudin Reply July31,2011at4:40am Niju, Itsoundslikeyoumaybelookingfora‘historicalbalance’–thisisnotpossiblewithoutwritingsomeprettycomplicatedcode.DailybalancesarenotstoredanywhereintheGPdatabase.Ifyouarelookingforacurrentbalance,youcangetthatfromtheCURRBLNCfieldinthePM00201table. -Victoria LikeLike Kevin Reply June20,2011at10:25am HiVictoria, Ihopealliswell.TheAPcrewhasanissuewithconfirmingsomechecks. 1)TheuserprintedaVendorChequeRegisterReportand2checksweremissing.Itbasicallywentfrom02115to02118.MIssingcheckswere02116and02117.Isthereawaytopullalistofallthecheck#’s? 2)Thisisanintercorelationship.TheVendorChequeRegisterReportindicatesapaymentforvendorAbutthepaymentdoesnotexistintheintercocompany.Iranthesmartlistforbothandcouldn’tfindthatpaymentanywhere. Anyhelpwouldbegreatlyappreciated.Thankyou. LikeLike VictoriaYudin Reply June24,2011at6:23am Kevin, Iamnotsureiftherearedifferencesifyou’renotusingtheUSBankRecmodule…buthaveyoutriedlookingintheCheckbookRegister(thisisdifferentfromtheVendorCheckRegister,whichonlylooksatchecksenteredinpayables)?OnmyinstallitisunderInquiry|Financial|CheckbookRegister.Or,inSmartList,IwouldlookinBankTransactions(asopposedtoPayablestransactions). -Victoria LikeLike FAC Reply June10,2011at5:36pm HiVictoria Pleasecouldyouhelpmewiththisproblem I’mtryingtovoidaReturnpostedfromPM,becausetheuserputanamountinthecashfieldbymistake,sothatreturnwenttoHistorical,andwegotthismessage: “Thereisareturn(No:XXX)withapaymentmarkedforvoiding.ThepaymentonthisreturnwillnotupdatetheCBMwhenvoidedandwouldcauseanimbalanceintheGeneralLedger.Pleasemanuallyentercontraentriesforthereturnandpayment.”Whatwouldthecontraentriesforthereturnandpaymentbe? Thanksalot LikeLike VictoriaYudin Reply June11,2011at6:07am HiFAC, IhavenotworkedwithCBM,soIamnot100%surewhatentrythevoidwillcreate.Youwillneedtolookatthetransaction(s)createdbythevoidanddeterminewhatismissing.Isuspect,sincetherewasacashincreaseenteredwiththereturn,youwillneedtoenteracashdecreasetofixit. -Victoria LikeLike AndrewDavies Reply June6,2011at3:11pm HelloVictoria,Ihaveanissuewithachecksthatwereappliedtoinvoices,andthenthecheckswerevoided.Usuallythiswouldreleasedtheinvoicessowecanapplynon-voidedcheckstothem,butitdidn’thappen.IhaveinvestigatedPM30200,PM30300,andPM20100,buttheyonlyhadonelineinPM30200andwhenIremoveditinTest,itdidn’treleasetheInvoice.Canyouhelp? LikeLike VictoriaYudin Reply June7,2011at6:28am Andrew,haveyoutriedrunningreconcileandchecklinks? -Victoria LikeLike AndrewDavies Reply June7,2011at8:11am Itriedthatfirstanditdidn’thelp.IranReconcileonSales,PurchasingandInventory,andcheckedlinksonthesamemodules. LikeLike VictoriaYudin Reply June9,2011at2:11pm Andrew, Sincenoneofthestandardprocesseshelped,mostlikelyyouneedtohavesomeonethatknowsthetableswelltakealooktoseewhathasgonewrong.ThiswillprobablybeeitheryourGPpartnerorGPsupport. -Victoria LikeLike FAC Reply May27,2011at1:03pm HiVictoria pleaseIgotaproblemintheInquiry/Finantial/Checkbookregister IgotaPMmanualpaymentthatwasvoidedinVoidHistoricalTransactions,butinCheckbookregisterinquiryisnotVoided IcheckPM30200andVOIDED=1butinCM20200VOIDED=0 AmImissingsomeprocess?AsfarasirememberwhenIvoidedinPMitwasalsovoidedinCM ThanksalotVictoria LikeLike VictoriaYudin Reply May30,2011at11:07am HiFAC, IhaveseenthishappenwhenyouvoidapaymentinPayablesthathasalreadybeenreconciledinBankRec.Sinceitisreconciled,theoriginaltransactioncannotbechangedandinsteadanew‘reversing’transactioniscreated–itlooksjustliketheoriginalpaymentinCM20200,withthesameCMTrxNumandCMTrxType,butthereisanewCMRECNUMandtheamountisnegative.Hopethishelps. -Victoria LikeLike ZafarKhan Reply May27,2011at8:37am HiVictoria, Thankyousomuch. LikeLike ZafarKhan Reply May26,2011at2:38pm HiVictoria, WeareplanningtostartelectronicpaymentsthroughourbanktoourvendorsbyusingEFT80bytefiles.DoweneedtoregisterEFTpayablemodule?Ifyes,thenhowshouldweproceedandhowcanwehaveanestimateforthecostinvolvedinpurchasingandimplementingthemodule? LikeLike VictoriaYudin Reply May27,2011at8:34am HiZafar, Yes,youwouldneedtoownandhaveregisteredtheEFTforPayablesmodule,howeverthedetailsofwhatyouwouldneedspecificallywoulddependonyourGPlicensingmodeandwhereyouarelocated.YourDynamicsGPpartnerwouldbeinamuchbetterpositiontoanswerquestionsaboutpurchasingandimplementing,astheywillhavemoreknowledgeaboutyourlicensingaswellasyourenvironment. -Victoria LikeLike CharlesSiele Reply May16,2011at4:11am Vic, RE:VOIDEDTRX Kindlyhelpoutonthis.Whenyouprintcreditorsstatements(Tool>Routines>Sales>Statements) itdoesprintwithVOIDEDtransactions,howcanprintthesamestatementswithoutthesevoidedtransactions.Howevertheyarenotusedforcalculating.Yourinputwillbgreatlyappreciated. Regards, Charles LikeLike VictoriaYudin Reply May17,2011at4:35am Charles, Ifyoumoveyourpaidtransactionstohistory(Tools|Routines|Sales|PaidTransactionRemoval),Ibelievethevoidswillcomeoffthestatement.Otherwise,youcouldpossiblymodifythestatementreporttoexcludevoids.OryoucoulddowhatIdoanduseacustomCrystalreportforcustomerstatementswhereyoucanaddanylogicyouwanteasily.🙂 -Victoria LikeLike JoeSpitler Reply April29,2011at1:06pm HelloVictoria, IwanttowriteaneMailnotificationprocedurethatnotifiesemployeeswhenweprocessanexpensereimbursement.IseethatIcanfindthetransactionsinPM030200justfine.WhatI’dliketoprovideadditionallyarethedocumentsthatthepaymentappliedto.IthoughtthatwouldPM030300joininglikethis: from PM30200a innerjoinPM30300b ona.VCHRNMBR=b.APTVCHNM HowevertherearerowsinPM30200notinPM30300.Iamconfused.Canyouhelp? Thanks. LikeLike VictoriaYudin Reply April29,2011at1:09pm Joe, APtransactionsareinPM20000andPM30200.ApplyinformationisinPM10200andPM30300.MyApplyInformationviewshouldhelp–maybeyoucanjusttakeoutthecolumnsyoudon’tneedanduseit. -Victoria LikeLike JoeSpitler Reply April29,2011at1:14pm Sweet.I’llgiveitawhirl.Thanksforthequickresponse. LikeLike FAC Reply April25,2011at5:09pm HiVictoria PleasedoyouknowwhatarethesefieldsinPM30300? Settled_Gain_DebitCurrTr,Settled_Loss_DebitCurrTr IwasusingRLGANLOSfieldinareporttotakethegainorlossammountinanapplyfromdifferentcurrenciestransactionsbutitwasnotthecorrectcurrentammountGPwasgivingforavendor. IrealizedthatitwasusingtheammountinSettled_Loss_DebitCurrTranditisdifferentfromRLGANLOS. Iamkindofconfused,doesthishappenswhentheapplydateisdifferentfromthepaymentdocumentdate? ihaveanothertransactionswhereiuseRLGANLOSanditfitstheammountinGP. Ihopeyoucanunderstandme. ThanksalotVictoria LikeLike VictoriaYudin Reply April26,2011at4:09am HiFAC, IdonotworkwithMulticurrencytransactionsenoughtoeasilyanswerthiswithoutadditionaltestingandresearch.IwouldrecommendcheckingonthiswithGPsupportsotheycangiveyouthebestadviceonwhatyouarelookingtodo. -Victoria LikeLike colinsarawan Reply April20,2011at4:35am HiVictoria IhaveaPMbatchthathasdistributionerrorswhichIneedtocorrect…….I’vemovedthesetransactionfromonebatchtoanothertoenablemetopostthetransactionthathadnoerrors.NowIcannotaccesstheseerrorrecordsbecauseofthefollowingerrormessage ”Thisvouchernumberalreadyexists.Pleaseenteranewvouchernumber”………..ThesetransactionsarecurrentlyinWORK. HowdoIresolvethisissue…. KindRegards LikeLike VictoriaYudin Reply April21,2011at11:31am HiColin, Howexactlydidyoumovethesetransactionsintoanotherbatch?InGP,orinthetables?Howareyoutryingtoaccessthem?IfyoulookthemupinthePayablesTransactionsSmartList,doeseachtransactionappearonceortwice?WhatistheDocumentStatusforthem? -Victoria LikeLike Kimberley Reply March17,2011at9:42pm HiVictoria, Iloveyoursiteandallofthegreatinformationthatyouprovide.I’mhopingthatI’mpostingthisquestion/commentintherightplace.Ihaveaclientwhohasaverystrangeproblem,andIcanseewhathappenedbutIcan’treallyfigureoutwhy.Ithoughtyoumightbeabletoshedsomelightonitsowecanavoidhavingithappenagain.Theuserwhokeyedthesechequesdoesn’tkeyveryoften,andIsuspectthatshedidsomethingwrongbutIhavenoideawhat. AchequewaswrittenforVendorA,andasecondchequewaswrittenforVendorB(datedamonthlater).Therewerenocommonalitiesbetweenthevendors,thedocumentnumbers(beingpaid),theamounts,orthechequenumbersthatIcanfind.However,thesecondchequewasassignedthesamePaymentNumberasthefirst.Asaresult,thedistributionforthesecondchequegotaddedtothefirstcheque.Thenthefirstchequegotvoided,sotheybothautomaticallygotvoided(distributionultimatelyhad8lines).NeitherthesecondchequenorthevoidshoweduponVendorB’saccountatall,sotheclientre-enteredthem,whichcausedthebanktobeoutofbalancebecausetheyhadhittheGLinthefirstplace.WhenIlookedupthedocumentbydocumentnumber,itcameupwithVendorB’sID,butanyotherwayIdrilleddowntoit,italwaysassociatedthetransactionwithVendorA.Theclienttriedtofixtheproblemontheirownandcreateddozensofchequesandvoids,makingitevenmoredifficulttofollow.TheVendoraccountsallappeartobecorrectultimately.IhadtomakemanualentriestoreversetheVendorBchequethatdidn’tshowupinthevendoraccount,andtherelatedvoid.Theywouldhavecancelledeachotherout,exceptthattheyhappenedindifferentperiods. Asforthetables,it’shardtoevenarticulatehowthishitthem.Itdoesn’tshowupinthePM10XXXorPM20XXXtables.AllofthelinesappeartobeassociatedwithVendorAandthecorrectamountoftheoriginalVendorAchequeinthePM30XXXtables.However,theControlNumberinPM00400showedthedatafortheVendorBchequeandnorecordoftheVendorAcheque.I’mnotseeingtheextradistributionlinesinPManywhere,althoughtheyshowupinthedrill-down.TheyappeartohaveonlyimpactedtheGL. IdidrunCheckLinks,anditmadeasmalladjustmentwhichwastochangetheVendorIDtoVendorA’sIDinPM00400,whichwasn’tcorrecteither,becausenowVendorAwasassociatedwiththeDocument#,etcthatactuallybelongedtoVendorB! IalsotriedtoreconcileeachofthevendorsinquestionusingUtilities>Purchasing>Reconcile,anditshowstheseamountsascurrentbalancesbeforethereconciliation,andzerobalancesafterthereconciliationalthoughthereisnoobviouschangefromthefrontendastheyappearedtohavezerobalancesevenbeforeIrantheutility. Thishappenedfortwodifferentvendorcombosatroughlythesametime(onlydifferentbatches).VendorBwasthesameinbothcases(butdifferentcheques),buttheyattachedtodifferentVendorA’s.PMCHQ#wasthreedigitsapartinthefirstscenario,andrightnexttoeachotherinthesecond.Secondscenariowasninedigitsafterthefirstifthismakesanysense. So,nowtheVendorbalancesappeartobecorrectandtheGLbalancesappeartobecorrect(finalreconciliationisstilloutstanding),buttheinformationinthedistributionsandthedrill-downsforthevariousdocumentsarewrong.ShouldIbeworriedaboutthiscomingbacktohauntme?Isthereanythingwecandotoavoidthishappeninginthefuture? Thanksforyourhelp.Haveagreatday! Kimberley LikeLike VictoriaYudin Reply March18,2011at4:53am HiKimberley, Fromwhatyou’redescribing,itsoundslikesomethingwentwrongwiththeentryoftheoriginalchecktoVendorB.Andby‘something’Imeantherewassomekindofanissuebetweentheclientandtheserver,whichallowedGPtodosomethingthatbreaksabusiness/coderule.It’shardtosayifitwillcomebacktohauntyou,ifrunningchecklinksagainchangesthedataagain,thatmightbeaproblemandmaybesomethingyouwanttotalktoGPsupportabouttoseeiftheyhaveawaytofixthismorepermanently. TheonlywayIcanseethishappeningagainisifthatsamesituationoccurred.Sinceit’snotsomethingthatissupposedtobeallowedtohappenandsincewedon’tknowexactlywhatcausedit(andmostlikelyneverwill),Iamnotsurehowyoucanactivelypreventitinthefuture.Doyouknowifthisclienthasahistoryofnetworkconnectivitytypeerrors?Oranycustomizationsaroundpayables? -Victoria LikeLike Kimberley Reply March18,2011at10:16am HiVictoria, Thanksforyourpromptresponse. Ididtryrunningchecklinksasecondtime,anditdidnotresultinanyerrors,soIthinkwe’reokaythere. Thisisafairlynewinstallationusingterminalserver.Therearenocustomizations,andtheyhaven’thadanyconnectivityissuesthatI’mawareof.SinceNovember,therehasbeenonehungbatch. Ithinkweshouldjustleaveitandhopeforthebest!🙂 Kimberley LikeLike Sheila Reply April20,2011at3:18am Ichangedthecompanyaddressestodisplayonmypurchaseordersrecently.AfterIchangedthem,Igetanerror:“ErrorRegisteringtablePM_Address_MSTR”Idon’tknowhowtoevenbegintofixthis.PleaseHelp. LikeLike Sheila Reply April20,2011at3:22am HiVictoria, Couldyouhelpmewiththefollowingplease?Ichangedthecompanyaddressrecentlythatgetsdisplayedintheshiptoaddressonmypurchaseorderprintout,IdidnotchangeanyIDsjustthedetail,butnowIgetanerror:“ErrorregisteringtablePM_Address_MSTR”Pleasehelp!I’mfarelynewtoGPandI’mnotsurewheretobegin. LikeLike VictoriaYudin Reply April21,2011at11:37am Sheila, TypicallythiserrorindicatesastuckrecordintheGPSQLServer,althoughitcouldbesomethingelseIhavenotseenbefore,also.IfexitingGPandloggingbackindoesnotresolvethis,itisnotsomethingyouwillbeabletofixwithoutknowledgeandaccesstotheSQLServerandIwouldrecommendaskingyourGPadministratororGPpartnerforhelpwiththis. -Victoria LikeLike SeanHunter Reply February21,2012at11:49am Victoria, Ihaveexperiencedasimilarsituationwithacustomerofours.WhenthecustomeraccessesPurchasingtheyreceiveanerrortitled“ErrorregisteringtablePOP_PO_Tax”.TheerrordisplayswhentryingtoaddalineitemtothePurchaseOrderandthenerasestheline.IalsoreceiveerrorsregisteringtablesonManufacturingOrderEntrywindowtitled“errorregisteringtablesyEmailReportSetup”. Thingswereworkingfineendofdaythepreviousday.Whatwouldcausethiserror?ThecustomerisrunningSQLserver2008R2ononeserverandthentheusersaccessaremoteappfromtheirdesktopswhichistiedtoaterminalserverseperatefromtheSQLServer.TheSQLServerGPinstallationworkedfineanddidnotexperienceanyerrorsonpurchasingormanufacturing.TheTerminalServerwastheonlymachineexperiencingtheissue. OurremedytothesituationwastorestarttheTerminalServerwhichseemstohavefixedtheissue.Justwonderingifyou,oranyoneelsehaveexperiencedasimilarsituationandknowofaconcretereasonwhyithappens. TheonlyvisiblechangethatIcouldattributetothesituationwasthattheSQLServermachinehadrestartedfrominstallingsomewindowsupdatesthenightbefore.CouldtheupdateandrestarthavecausedtheTermServerfromcommunicatingappropriatelywiththeSQLserver? ThankYouforyourtime Sean LikeLike VictoriaYudin Reply February21,2012at5:22pm HiSean, Ihavenotrunintothisbefore.Reallyimpossibletotellexactlywhythishappenedwithoutalotmoreinvestigationandpossiblywithoutbeingabletoreproduceit.Gladyouwereabletoresolveitbyrestarting.🙂 -Victoria LikeLike colinsarawan Reply April24,2011at12:26am HiVictoria……. PublicholidayshereinSA………thereforelatereply. 1TranxmovedinGP 2TryingtoaccessTransactions>Purchasing>Payablestransactions 3Documentsappearonce 4StatusinthePM10000is20andinthe PM00400itis1 Hopethatyoucanassist. KindRegards Colin LikeLike VictoriaYudin Reply April25,2011at8:13am Colin, IfyoubringtheseupinSmartListagain,thendoubleclickononeofthem,thatshouldopenthePayableTransactionEntrywindowandallowyoutoeditthetransaction.Doesthatwork?Ordoesitalsogiveyouthatsameerror? -Victoria LikeLike colinsarawan Reply April25,2011at11:03am hiVictoria sameerror……….ThePayablesTransactionEntrywindowopensbutcannotedittherecord. Thanks Colin LikeLike VictoriaYudin Reply April26,2011at4:14am HiColin, HaveyourunCheckLinksonthePurchasingseries?Ifthatdoesn’thelp,you’reprobablygoingtoneedsomeonetotakealookatyourtables,whichisreallyimpossibleinthistypeofforum.IwouldrecommendtalkingtoyourGPpartnerorGPSupport. -Victoria LikeLike Ben Reply March10,2011at10:07am HeyVictoria, Quickquestion,wehadaPMbatchthatgotstuckinbatchrecoveryandhadtobeupdatedviaSQLcommandsandthenprocessedduringaCheckLinksrun.EverythinglookstobepostedsuccessfullytotheGL.TheonlybizarreissuenowisthatnoneoftheDocumentNumbersshowupforthisbatchwhendoingaTransactionbyDocumentInquiry.However,ifyoudoaTransactionbyVendorInquiryandopenthePayablesPaymentsZoomonthattransaction,theDocumentNumberispresent.DoyouknowwhattabletheTransactionbyDocumentInquirypointsto? LikeLike VictoriaYudin Reply March10,2011at10:37am HiBen, ThatshouldbepointingtothesameexactsetoftablesasthePayablesTransactionInquiry–Vendorwindow.Canyoureproducethisbehavioronadifferentcomputer?(OrbetteryetontheSQLServerifyouhavetheGPapplicationinstalledthere?) -Victoria LikeLike Ben Reply March10,2011at11:15am Victoria, Yes,IwasabletoreproducetheissueontheSQLserverwithGP10aswell.Weareasmallshopwith80GPusers,soweonlyuseoneterminalserverforalluserstoremoteinto(30concurrent).Bothserversareexperiencingthesesymptoms. LikeLike VictoriaYudin Reply March11,2011at5:27am Ben, Sorry,notsurewhattotellyou,asIhavenotrunintothisbefore.IfIwastroubleshootingthis,Iwouldstartbylookinginthetablestoseewhat’sthere…andproceeddependingonwhatIfound.Butwithoutseeingthis,it’sprettydifficulttotroubleshoot.HaveyoutriedgettinghelpfromyourGPPartnerorGPSupport? -Victoria LikeLike Ben Reply March11,2011at11:25am Victoria, Ihaven’tgonetomypartnerorGPsupportyet,thoughtIwouldtrythecheaperandmoreintelligentroutefirst.Thanksfortheassistance,andalwayshelpfulsiteofyours.I’llseewhatGPsupporthastosay. LikeLike VictoriaYudin Reply March14,2011at4:59am Ben, Thanksforthecompliment.🙂Pleaseletmeknowhowitturnsout,Iamcurioustofindoutwhattheissuewas. -Victoria LikeLike FAC Reply March1,2011at4:30pm HiVictoria isthereanywaytoknowwhichusercreatedavendororcustomer? Thanksalot LikeLike VictoriaYudin Reply March2,2011at4:38am FAC, AsfarasIcansee,GPdoesnotstorethisinformation. -Victoria LikeLike Eric Reply October11,2011at11:58am IbelieveVictoriaiscorrect–GPdoesn’tstorethisinfonatively.Howeveritispossibletostoreitifnecessary.Mypreferredmethodistouseadatabasetrigger.Forexample,ifyouwanttocapturetheuserwhocreatesacustomerrecord,youcanhaveyourDBAcreateatriggeronthecustomermastertable(rm00101)thatwillinsertthenewcustomernumberandcreatinguserintoacustomtablethatstoresthecustomernumberandcreatinguser. WhiletherearewaystostorethatinformationinGP,allthatIknowofrequirethattheuserentermoredata.Thetriggermethodiscompletelytransparenttotheuser,andrequiresnoextradataentry. LikeLike gaganiaro Reply February2,2011at3:49am howisREMSUBTOorOREMSUBTcomputedintablePOP10100? LikeLike VictoriaYudin Reply February2,2011at6:51am Gaganiaro, AccordingtotheGP2010SDK: RemainingSubtotal(REMSUBTO)is“thesumoftheoriginatingremaininglineitemamountsintherelatedPOP_POLinerecordsconvertedtofunctional.Originatingremaininglineitemamountsarecalculatedasfollows:QuantityRemainingtoInvoice*OriginatingUnitCost.QuantityRemainingtoInvoice=QuantityOrdered–QuantityCanceled–PostedtoDateInvoiced–UnpostedInvoiced+PostedQuantityReplaced–QuantityInvoiceAdjustment” AndOriginatingRemainingSubtotal(OREMSUBT)is“thesumoftheremaininglineitemamountsintherelatedPOP_POLinerecords.Remaininglineitemamountsarecalculatedasfollows:QuantityRemainingtoInvoice*OriginatingUnitCost.QuantityRemainingtoInvoice=QuantityOrdered–QuantityCanceled–PostedtoDateInvoiced–UnpostedInvoiced+PostedQuantityReplaced–QuantityInvoiceAdjustment.” -Victoria LikeLike gaganiaro Reply February2,2011at9:31pm thanksbutihaveafollowupquestion.intablePOP10110,thereisafieldcalledOPOSTSUBwhichisithinkthedifferenceofREMSUBTOandSUBTOTALintablePOP10100.howisOPOSTSUBcomputed? bytheway,wheredidyougetthatGPSDK? alotofthanks,Victoria! LikeLike VictoriaYudin Reply February3,2011at5:56am Gaganiaro, TheSDKcanbeinstalledfromtheGPmedia,butitisaseparateinstallation.TypicallyitisundertheToolsfolder. OriginatingPostedSubtotal(OPOSTSUB)isdefinedas“amountpostedtothislinefromreceivings”. -Victoria LikeLike gaganiaro Reply February8,2011at1:58am inPM20000,thereisacolumncalledCURTRXAMwhichibelieveistheremainingamount(unpaid).howisthiscomputed?Also,isitenoughtobethebasisifIwasinstructedtogetallthePObalances?Thanksalot! LikeLike VictoriaYudin Reply February8,2011at4:26am Gaganiaro, Everytimeatransactionisenteredthatwouldchangetheamountstilldueonapayablestransaction,theCurrentTransactionAmount(CURTRXAM)ischanged.Iwouldstartbyaskingforsomebetterspecifications.Icanthinkofafewdifferentdefinitionsfora‘PObalance’,butwhyguess? -Victoria LikeLike Charles Reply November19,2010at8:08am HiVic, Howcanyouactivatetheprintoptionwhenyouaredoingcashpayments.Themomentyouselectpaymentmethod(Cash),theprintbuttonisgreyedout,inactivated.Howcanitbeactivatedandprintpaymentvouchers. Trx>Fin>BnkMnget>Batches…..paymententry. Yourinputwillbhighlyappreciated. Charles LikeLike VictoriaYudin Reply November19,2010at8:44am HiCharles, Itsoundslikeyoumaybeusinganon-USversionofGPwhichallowsforbankbatches?Idon’thaveexperiencewiththis,astheUSversionofGPdoesnotallowbatchingofbanktransactions.IwouldrecommendpostingyourquestionontheGPforum(https://community.dynamics.com/forums/32.aspx),whereyoucanhaveaccesstoamuchbroaderaudience. -Victoria LikeLike MatthewThomas Reply October27,2010at1:46pm Victoria, I’vebeenusingyourblogasareferenceforoverayearnowandI’msogratefulthatyoutakethetimetohelpsomanypeople. IamcurrentlyatourMexicooperationand,forgovernmentcompliance,Ineedtopullalistofchecksthatwerecashedinagiventimeperiodalongwiththethetaxesassociatedwiththem.We’vebeendiggingthroughthedataandhavedeterminedthefollowing: –WeareabletoassociatetheappropriatePMtablestofindthoseinvoices,returns,andcreditmemosthatareinterrelated.WeareusingtablesPM30200andPM30300.Thisbringswithitthetaxinformationaswellasdocumenttotals. –WeknowthatwewanttojointotheBankReconciliationsystemtodeterminewhetherthecheckhasbeencashed.ThetablewiththemostpromiseisCM20200. Nowforourproblem.Wecan’treliablyassociateinformationinCM20200withPM30300orPM30200.WethoughtthatCMLinkIDlinkedwithVENDORIDandCMTrxNumlinkedwithAPFRDCNM,butwefindthatthisdoesn’talwayswork.CanyougiveusarecommendationonhowtocorrectlylinkcorrectlyfromtheCMtoPMmodules? LikeLike VictoriaYudin Reply October29,2010at8:43am HiMatthew, YoushouldbeabletolinkPM30200toCM20200usingsomethinglikethis: SELECTPM30200.*,CM20200.* FROMPM30200 INNERJOINCM20200ON PM30200.CHEKBKID=CM20200.CHEKBKID ANDPM30200.DOCNUMBR=CM20200.CMTrxNum ANDPM30200.DOCTYPE=6--payments ANDPM30200.PYENTTYP=0--checks ANDCM20200.CMTrxType=3--checks Youmayneedtoaddadditionalexclusionsforvoids,alignmentformsanddateranges,buthopefullythisgetsyouclose. Oneotherconsideration–CM20200storesthedatethatthebankreconciliationdateasthe‘cleared’orcasheddate.Thismaybeverydifferentfromwhenthecheckwasactuallycashedbyyourbank.UnlessyouarerecordingactualcleareddatesinGP(whichisunusual),orareperformingadailybankrec,youmaynothavethisdatatoreporton. -Victoria LikeLike yassir Reply September4,2010at5:33am HiVic, Wehaveaprobleminvendorbalance(GP10–SP3).. ThebalancefrominsideGPlooksincorrectasitappearsinsmartlistandHATBlessthantheactualamountthatappearfromoutsideGPlike(VendorStatement)usingcrystalreport. Thisdifferenceappearsinonlyonevendorbalancewhileallothervendorbalancesarecorrectinthebothsides! e.g:Wehavetenvendors(A,B,…..,J) Allvendorbalanceappearcorrectanywhereyoutrytoinquiry..butvendorCBalanceappearsincorrectfrominsideGP-correctfromcrystalreport..wediscoveredthatbymanualcalcuationsforvendortrx. Notethat: –thedif.amountistypicalyequaltodocumentamountofsomemanualpaymentstrxforthevendor. –allthosemanualpaymentarepostedandfullyapplied –checklinks,reconcile…alreadydoneforAPtrxandvendors. Whatdoyouthinkitcausesthisproblem?helpplz! LikeLike VictoriaYudin Reply September4,2010at5:52am HiYassir, IftheHATBisalsoreportinganincorrectbalanceandthedifferenceistheamountofamanualpayment,then,withoutactuallylookingatit,IwouldguessthatmanualpaymentisinthesystemtwicesomewhereordidnotupdatetheGPtablesproperlywhenitwasbeingposted.YousaidyouranCheckLinksandReconcileanditdidnothelp,soatthispoint,thefixwouldneedtobeperformeddirectlyintheSQLtables.ThisisnotsomethingIwouldeveradvisedoingwithouttheproperknowledgeandexperience,soIwouldrecommendgettinghelponthisfromyourGPPartnerorGPSupport. Astothequestionofwhatcancausethis,unfortunately,it’svirtuallyimpossibletoanswerthisquestionunlessyoucanreproducetheproblemagain.ItcouldhavebeenaconnectivityissuebetweenausercomputerandtheSQLServer,itcouldhavebeenamanualchangeorimportintotheSQLdatabase,etc.IhaveseensimilarissuesoccurwhenausercrashesoutofGPinthemiddleofenteringatransaction. -Victoria LikeLike Wasay Reply June27,2010at4:25am HiVictoria, Wehaveused‘VoidOpenPayablesTransactions’tovoidatransactionpostedfromInventoryReceiving’sTransactionEntry.icannotseetheimpactofthevoidedtransactionontheStockoftheInventoryItem(s). Canyoutellmehowandwherecanthestockoftheitembereverted. Wasay LikeLike VictoriaYudin Reply June28,2010at6:41am HiWasay, GPisbehavingcorrectlyandasexpected.UnfortunatelyvoidingthePayablesinvoiceisnottherightwaytocorrectatransactionthatoriginatedasareceiptofinventory.ChristinaPhillipsatDynamicsGPLandhasagreatpostaboutthiscalledDanceWithTheOneWhoBrung‘Ya–CorrectingTransactionsinDynamicsGP. Atthispoint,thewaytocorrectyourinventoryistoenteraninventorytransaction. -Victoria LikeLike NevBrowitt Reply June21,2010at11:35am Hiagain, IhaveapaymentvouchernumberprintedontheEFTPaymentRegisterreport….Ineedtolinkthisbacktotheoriginalinvoice…howcanIdothis? Thanks NevBrowitt LikeLike VictoriaYudin Reply June22,2010at8:54am Nev, Justtoclarify–everypayablestransactioninGPhasa‘voucher’number.Areyoulookingtolinkthepayment‘voucher’numbertothepaymentitself?Ortotheinvoicethispaymentwasappliedto?Itsoundslikeyou’relookingforthelatter.Ifso,myPaymentApplyDetailcodeshouldhelp.Ifthatisnotyourquestioncanyoupleaseprovidemoredetail? -Victoria LikeLike Stu Reply June17,2010at9:13am Hiall–GP9SQL2005 Isthereawaytoretroactivelyreportontheactualaddresslinedetailusedonacheque(notbyreferencetothemasterrecordasthismayhavechanged)?WehavesomeissuesinternallyandIhavebeenaskedtoshowaddressesusedonpreviouscheques. Thanksforanyandallcontributions Stu LikeLike VictoriaYudin Reply June17,2010at9:17am Stu, Unfortunately,IdonotbelievethisinformationisstoredinGP.Thisisoneofthereasonsitisnotrecommendedtochangeexistingaddresses,buttoinsteadaddnewones.Iknowthisdoesnothelpyouforhistoricalreportingpurposes,butmaybeyoucanteachuserstodothiscorrectlyforthefuture. -Victoria LikeLike waseem Reply June15,2010at10:11am HiVictoria, WhenIpostaShipment/InvoicefromReceivingsTransactionentrywindow.TheXCHGRATE,RATETPID,EXGTBLIDcolumnsinMC020103arenotupdated.Ihaveperformedthechecklinksmaintenanceandalsochekedtheratetypesinwhichonlyoneratetypeisselected.FYIwhenImakeatransactionfromPayableTransactionEntryeverythingworksfine.Canyoupleasehelpmetoovecomethisproblem? LikeLike VictoriaYudin Reply June15,2010at10:14am SorryWaseem,thisisnotsomethingIhavecomeacrossbefore.IwouldrecommendpostingthisquestionontheDynamicsGPcustomerforumortalkingtoGPSupportifyouneedananswerrightaway. -Victoria LikeLike Eric Reply June1,2010at1:12pm HiVictoria, Yoursiteismynewfavoritegpresource! IfyouhaveanythoughtsonthisIwouldreallyappreciateit! Wearetryingtodefaultthecheckbox“TakeNon-QualifyingDisounts”inTrans/Purchasing/SelectCheckswindowwithouthavingtouseExtender. Doyouknowofanywhytoaccomplishthisinthesetup/tables? Thanks, Eric LikeLike VictoriaYudin Reply June2,2010at4:21am HiEric, Thanksforyourkindwords! IamnotsurehowyouwoulddefaultthatcheckboxwithExtender,didyoumeanModifier?TheotheroptionIcanthinkofisaDexteritycustomization.Thereisnowaytocontrolthischeckboxinsetupordirectlyinthetables. -Victoria LikeLike NevBrowitt Reply May21,2010at9:33am HiVictoria, WhattabledoIneedtolookintoseewhichaccountmyPMDistributionshavegoneto?….IhavetheDistributionstablePM10101nowIwanttodoaquerythatlinksthedistributionstothererespectivedistributionaccounts. Thanksinadvance Nev LikeLike VictoriaYudin Reply May23,2010at9:00am Nev, GLdistributionsforworkandopenpayablestransactionsareinthePM10100table.YoumightfindthisSQLviewIpostedhelpful:GLDistributionforAPTransactions. -Victoria LikeLike FAC Reply May19,2010at7:00pm HiVictoria pleasecouldyouhelpmewiththis,ihopeuunderstandme,(myGPisinspanish) I’vegotaPMTransactionanditwasfullyappliedwithapaymentbutintheapplytoDocumentwindowtheyenteraquantityinthewriteofffield(weusethatfortaxpurposes) that’sallokthepmtransactionwasfullyapplied,thepaymentwasfullyappliedeither. ThentheyneedtoVoiddePMtransaction,sotheyhavetoVoidthepaymentfirst,theyvoidedthepaymentbutwhenyoulookatthePMtransactionthereisstillacurrentamountpending(theamountthattheyenteredinthewriteoffamountwhenapplyinginthefirsttime) Soidon’tknowiftherewasaproblemvoidingthePaymentandthatswhythecurrentamountdoesnotmatchtheDocAmountorwehavetodosomethingelsesothepmtransactionsisfree IdidchecklinksandreconcilebutiseePM20000tableandthatPMtransactionsstillhasthewriteoffamountintheWROFAMNTfield whatshouldido,anupdateinthedb? Thanksalotforallyourhelpandpleasepardonmyenglish LikeLike VictoriaYudin Reply May20,2010at3:55am FAC, Thewriteoffonthetransactionshouldhavebeen‘reversed’whenthetransactionwasvoided,soitsoundslikesomethingmayhavegonewronghere.NormallyIwouldrecommendReconcileandCheckLinks,butyouhavealreadytriedthat.Idonotfeelcomfortablerecommendingchangingsomethingdirectlyinthedatabasewithoutseeingthedatamyself.IwouldrecommendtalkingtoGPsupportoryourGPPartnertoseeiftheycanhelpfixthis. -Victoria LikeLike Sruthi Reply April28,2010at1:26am Hivictoria, Iwouldliketoknowhowtocalculatecashinbankreport,inwhichwewouldliketoknowtheclearedandunclearedbalances. Regards, Sruthi LikeLike VictoriaYudin Reply April28,2010at5:40am Sruthi, Isthisrelatedtoyourvendoragingreportquestion?Ifnot,pleasetakealookatmyBankRectablespage:https://victoriayudin.com/gp-reports/bank-rec-tables/. -Victoria LikeLike Sruthi Reply April27,2010at9:28am HiVictoria, Canyoupleasetellmethequeryforvendoragingreport. Thanks Sruthi LikeLike VictoriaYudin Reply April27,2010at9:34am HiSruthi, Canyoupleasebealittlemorespecific?Therearealotofdifferentagingreports.IhavesomepayablescodepostedonmyGPReportspagethatmayhelp:https://victoriayudin.com/gp-reports/. -Victoria LikeLike VC Reply April19,2010at2:12pm TrialBalanceReport: Wehaveafewtransactionsthatareshowingonourtrialbalancereportthatarepostedin2001.Thesearepaymentsshowingup,butwhyareweseeingtheseiftheywerealreadypostedbackin2001?HowcanIfixittowheretheydon’tshowuponthetrialbalancereport?Anyhelpwouldbeappreciated.Thankyou LikeLike VictoriaYudin Reply April20,2010at7:43am VC, Therearenumeroustrialbalancereportsandeachhasmultipleparameters.Withoutknowingwhatreportyou’retalkingaboutandwhatparametersyouarechoosing,it’sverydifficulttocomment.Also,sincethesearesucholdtransactions,Iamwonderingwhythisiscomingupnow?Wasthissamereportfinebefore,butisnotnow?Werethesetransactionsimportedinorenteredmanually? -Victoria LikeLike May Reply April15,2010at4:13am Hi, IwaslookingatPOPDIstributionfileaswellasPMDistributionfile. Ifindthattherearedistributiontypeswhicharenotshownintherespectivedistribtiontypeinyoursite.Examplearelike: PayablesManagement–IcanseeDISTTYPElike16,17and18(fromPM30600) PurchaseOrderProcessing–IcanseeDISTYPElike201and209(fromPOP30390) Doyouknowwhatthesedistributiontypesrepresents? Also,Ialwaysfind0.01amountgeneratedinGLbatchesfurthertopostingForeignCurrencyPurchasingInvoicebatches.Ithinkthismaybecausedbyroundingbetweenthedetaillineandpayablesamount.AsIdidnotsetupanyaccountinthePostingAccount,thebatchisstrandedinGL.IwanttoknowwhichsetupIneedtoenter–RoundingDifferenceorRoundingWriteoff.IsthistherightplaceformetoputintheaccountsothatthesystemwillautomaticallyusethisaccountandposttheGLbatch? Anyadviceisgreatlyappreciated. May LikeLike VictoriaYudin Reply April15,2010at4:26am May, IdonotshowthesedistributiontypenumbersinanyofthedocumentationIhave,norinanytestdataIhavelookedat.Unfortunately,Ihavefoundthatsometimesnoteverythingisdocumented,sotheinformationIhavepostedonthisblogisacombinationofwhatIhavefoundinthedocumentationplusdataIhavediscoveredthroughmyownexperience. Ifyouaremanuallyenteringtheretransactionsandtherearenocustomizationsinplace,thesemustbegeneratedbyGP–ifyouneedtofindoutwhattheyare,youcansubmitasupportrequesttoMicrosoftortryaskingononeoftheGPforums. Foryourroundingdifferencesandwriteoffs–ifthisismulticurrency,youcansetuptheaccountstobeusedforalltransactionswithinacompanybygoingtoGP>Tools>Setup>Posting>PostingAccountandselectingFinancialfortheSeries.YoualsohavetheoptionofsettingupdifferentaccountsforeachcurrencyandratetypebygoingtoGP>Tools>Setup>Financial>RateTypes>Accountsbutton. -Victoria LikeLike nish Reply March28,2010at8:04am hivictoria, Infewcasesthegoodsrecievedaregreaterthanpurchaseditems.AreyouawarewheretoblocksuchrecieptsinGP? Regards, Nisha. LikeLike VictoriaYudin Reply March28,2010at9:18am Nisha, Areyousayingthatyouwouldliketopreventusersfrombeingabletoover-receiveinthePOPmodule?Ifso,Idonotbelievethisispossibleout-of-the-boxinGP. -Victoria LikeLike nisha Reply March28,2010at10:49am YesVictoria.ArethereanyexistingGPreportswhichprintstheoverrecieveditems? Regards, Nisha LikeLike VictoriaYudin Reply March29,2010at2:51am Nisha, Idon’tthinkthereisastockreport.Ifyou’recreatingoneyourself,youwouldneedtogetthePOinformationfromaunionofPOP10110(PurchaseOrderLineWork)andPOP30110(PurchaseOrderLineHistory)andthencompareittothereceipts(IthinkthePOP10500tableisthebestforthis). -Victoria LikeLike Sri Reply March25,2010at4:28am HiVictoria, CanyoupleasegivemeanexampleofhowtodothecodingtodrilldowntoGPfromexcelorssrs. Regards, Sri. LikeLike VictoriaYudin Reply March25,2010at4:50am Sri, Iamnotadeveloper,soIdonotdothiskindofworkmyself. -Victoria LikeLike Sri Reply March24,2010at1:26am HiVictoria, Iwanttocreateareporttopublishinsharepointbypassingtheparameters.AndtheuserwantstodrilldowntotheGPscreen. Shouldwecreatethereportsinexcelandpublishinsharepointorusessrs.ButwouldliketoknowhowtodrilldowntoGP Regards, Sri LikeLike VictoriaYudin Reply March25,2010at4:17am HiSri, BothExcelandSSRSareviableoptionsforyourreport,howeverdrillingdowntoGPwouldrequirecustomcoding. -Victoria LikeLike BrentKeilin Reply March5,2010at11:04am HiVictoria, AreyoufamiliarwithRTVCredits?Inmytesting,itappearsthatifyoucreateaRTVCreditandpostitintheRTVShippingWindow,anassociatedPayable(CreditVoucher)iscreatedandlinkedtotheRTV.IhaveanRTVwithoutanassociatedCreditVoucheranditappearstoberelatedtotheItem. Anythoughtsorsuggestionwouldbegreatlyappareciated. Thanks. Brent LikeLike VictoriaYudin Reply March5,2010at11:07am SorryBrent, NotoneofthemodulesIworkwithallthetime,soIthinkyoumightbebetteroffpostingthisquestionononeoftheGPnewsgroupswhereyou’dhaveawideraudience. -Victoria LikeLike nish Reply March4,2010at12:57am hi, iwanttomodifymanualpaymentspostingjournalreport.Imodifieditbutnotabletoseethechangesintheprint. cansomeonetellmehowtogoaboutthis? Thanks. LikeLike VictoriaYudin Reply March4,2010at4:30am HiNish, Youwillneedtograntusers(includingyourself)accesstothenewlymodifiedreport.PleasereviewthesetupmanualforyourversionofDynamicsGPtodeterminehowtodothis. -Victoria LikeLike nish Reply March4,2010at8:21am hivictoria, Ihavegivenaccesstotheusersandmyselftoviewthemodifiedreports..imusinggp10. ISittodowithmodifyingreportsafterpostingandbeforeprinting? Didyouevertrytomodifypostingjournalreports? Thanks. LikeLike VictoriaYudin Reply March4,2010at5:48pm Nish, Notsurewhatyoumeanby“modifyingreportsafterpostingandbeforeprinting”?Therearetypically2verysimilarreports–aneditlistandapostingjournal.Perhapsyouarenotmodifyingtheoneyoumeanto?Orneedtomodifyboth? Onceyou’vemodifiedareportinGP10,gotoGP>Tools>Setup>System>Alternate/ModifiedFormsandReportsandchangeeithertheDEFAULTUSERprofileorwhateverprofileyourusersareassignedtosothattheyarepointingtothemodifiedversionofthereport. -Victoria LikeLike Tin Reply January26,2010at4:12am HiVictoria, Ihopeyoucanhelpmeonthis.Imhavingtroubleonvoidingopenpayabletransaction.AsfarasIknowthiswouldonlycausewhenIpartiallyapplypaymenttotheinvoiceoritsonhold.ButIalreadycheckitandimsurethatthereisnopaymentappliedonitoritsnotevenonhold.Ialsoprocessthechecklinksforthisbutstillsameerror.Imnotsureifthere’sahangtableaffectedbythis. Hopingforyourresponse.Thanksinadvance Tin LikeLike VictoriaYudin Reply January27,2010at4:47am Tin, Areyougettinganerrormessagewhentryingtovoid?Ifso,canyoupleaseposttheexactwordingoftheerrormessage? -Victoria LikeLike Tin Reply January28,2010at4:04am HiVictoria, Thanksforthereply.Yes,theerrorsays:thisdocumentcannotbemarkedforvoiding.ithasbeeneitherpartiallyappliedorisonhold.ButaswhatIsaidbeforeneitherthevouchernumberwasinholdofhadapartialpayment. Thanks. Tin LikeLike VictoriaYudin Reply January29,2010at4:40am Tin, Iftherereallyisnothingappliedtothisdocument,youcantryrunningaReconcileonthepayablestransactions(Tools>Utilities>Purchasing>Reconcile)toseeifthatclearsuptheissue.Ifitdoesnot,youmayneedtogetsomehelpcorrectingthedatadirectlyinthetables.Thisisnotsomethingthatshouldbedonewithoutagoodunderstandingofthetablesinvolvedandtheimplications. -Victoria LikeLike TinBolo Reply March22,2010at9:54pm HiVictoria, Ididaswhatyoutold,runningaReconcile,buttheerrorisstillthesame.Ondocumentinquiry,underUnappliedAmountthisfieldisalready0(zero),butwhenizoomonappliedpaymentstherewerenodetailsonit.Hopeyoucanstillextendyourhelponths.ManyThanks! Tin LikeLike VictoriaYudin Reply March23,2010at5:37am HiTin, Atthispoint,IwouldrecommendgettingsomehelpeitherfromyourGPPartnerorDynamicsGPSupport.Thisisprobablynotgoingtobesomethingthatcanbefixed‘generically’–someonewillhavetolookattheactualdatainyourtablestodeterminewhatwentwrongandrecommendthebestfix. -Victoria LikeLike LuisCevallos Reply October8,2010at1:15pm HiimynameisLuisCevallosIamfromGuayaquil-EcuadorIhavetroubleswhenIopenthewindowAlternate/ModifiedFormsandReportsandselectwhateveruseramessagesaying“ThisIDisbeingeditedbyanotheruser.”IneverseethewindowsImodifiedinmodifierpleaseItrymanythingslikerestoredatabase,deleteusersfromDynamicsGPseethelogandexecutestepbystepdestoredprocedurespleasehelpme. Thanks Haveaniceday. LikeLike VictoriaYudin Reply October10,2010at11:07am Luis, IwouldrecommendgettingallusersoutofGPandrunningthefollowinginSQLServerManagementStudio: DeleteDYNAMICS..SY00800 DeleteDYNAMICS..SY00801 DeleteDYNAMICS..ACTIVITY DeleteTEMPDB..DEX_LOCK DeleteTEMPDB..DEX_SESSION -Victoria LikeLike FAC Reply January10,2010at10:35am HiVictoria Igotapurchaseinvoicein2009andithas2payments50%in2009andtheother50%in2010,theyneedtonowthependingamountof2009(likethePMbalancehistoricalreport),ifIcheckPM30200theCURTRXAMfieldis0.Isthereawaytonowthecurrenttransactionamountbutjustfor2009?isthereatablewherestoresthatkindofdata(currentamountafterechapayment)orwouldIhavetocalculateitbythepaymentsdatesandamountsinPM30300? Ihopeuunderstandme(englishisnotmynative😦) Thanksalotyouarethebest! LikeLike VictoriaYudin Reply January10,2010at10:43am FAC, Youwillnotfindthevaluesyouarelookingstoredinanytable.ThisiswhattheHistoricalAgedTrialBalancereportinGPaccomplishesandwhyitissodifficulttoduplicateitonyourown.Tobeabletocalculatethebalanceasofaparticulardate,youwouldhavetolookatalltransactionsandtheirdatesandcomeupwithlogictotakeintoaccountpartialpayments,voids,documentsthatmaybeappliedondifferentdates,etc. -Victoria LikeLike FAC Reply January13,2010at1:20pm HiVictoria IdontknowifucouldhelpmecheckthisbuticompareseveraltransactionsandtheyarejustlikeGP WhatIdois:createatablewhereijointhetransactionsfromPM20000andPM30200 VENDORID,VCHRNMBR,DOCTYPE,DOCDATE,DOCAMNTandaCURTRXAMfieldequaltoDOCAMNT thenacursorofpaymentsofthedesiredrangeofdatesfromPM30300updatetheCURTRXAMoftheabovetableminusAPPLDAMTofPM30300 checkingGPtheCURTRXAMdidntmatch CheckingthetablePM30300Igottwofieldswhereihavesomedata,WROFAMNTandRLGANLOS. Checkingthetransactionsirealizedthatihavetodothis: CURTRXAM=CURTRXAM–APPLDAMT–WROFAMNTinthepurchaseinvoice and CURTRXAM=CURTRXAM–APPLDAMT+RLGANLOSinthepayment andwiththatthatmatcheswithGP butijustcantfigureitouthowthosetwofieldswork Thanksalot LikeLike VictoriaYudin Reply January14,2010at4:10am FAC, Whatexactlyareyoutryingtoachievewithallthis?Itmayhelptostartfromthatdirection,becauseIamnotquitesurewhyyouarelookingatthedatayouarelookingat.Forexample–PM30200onlyholdshistoricaltransactions,meaningtheyarefullypaid.Ifyou’relookingforopenamountsontransactions,thattableshouldnotbeneeded.Also,forapplyinformation,don’tforgetthePM10200tablewhichholdworkandopenapplyinformation. -Victoria LikeLike FAC Reply January26,2010at8:20pm HiVictoriaThanksagainforreplyingsofast welltheyaskedmetodoareportofallcurrentamountofPMtransactionsinyear2009 justlikeHistoricalAgedTrialBalancereportbutinexcel thatswhyiwastryingtodoallthatinmypreviouspost ThanksalotVictoria LikeLike VictoriaYudin Reply January27,2010at4:26am FAC, IftheHistoricalAgedTrialBalanceiswhatyou’reafter,thatisatremendousamountofwork,andnotsomethingIhavecodetopublish. OneoptionmaybetomodifytheHistoricalAgedTrialBalanceinReportWritersothatitiseasiertoexportintoExcel. -Victoria LikeLike Doug Reply November12,2009at7:12pm HiVictoria, WhattableinPMliststhe“VoidGLPostingDate”?What’sthefieldname?IsthereasqlviewthathasbeencreatedtoconvertPMamountstonegativeorpositvevaluessothatapersoncantiethetransactiontotheGL.Iamhavingaproblemwiththevoidedtransactionsandtheperiodstheywerevoidedin.ForexampleifIqueryallpayablestransactionforafiscalperiodusingthepostingdate,theresultwillnotgivemethetransactonsthatwerepostedinpriorperiodsthathavebeenvoided(voidGLpostingdate)inthefiscalperiodthatIamqueryingfor. You’requeriesrock. Thanksinadvanceforanyhelp. Doug LikeLike VictoriaYudin Reply November13,2009at5:24am HiDoug, Thanksforthekindwords! TheVoidGLPostingDatewillbeintheVOIDPDATEcolumninPM30200.Oneimportantthingtonote–ifyouvoidapayablescheckbeforeitisposted,thiscolumnwillhaveadateof1/1/1900,sinceitwasneverpostedtobeginwithandnothinggetspostedtotheGLduetothevoid.Ifyou’relookingfortheVoidDocumentDate,thatwillbepopulatedintotheDINVPDOFcolumnforvoidedtransactions. YoucanusesomethinglikethisasastarttomatchingyourpayablestotheGL: SQLviewforallpostedPayablestransactionsinDynamicsGP -Victoria LikeLike Doug Reply November13,2009at12:35pm Thankyouforyourpromptresponse.Igreatlyappreciateyourhelp. LikeLike Aaron Reply November11,2009at10:15am HiVictoria, wherecanifindthevendorbankwireinformation?Thanksforyouhelp. Aaron LikeLike VictoriaYudin Reply November11,2009at10:37am Aaron, Areyouaskingwheretofinditinthetables?GPdoesnotreallyhaveaplaceforvendorbankwireinformation.IfyouhavetheEFTforpayablesmodule,thenyoumaybestoringitthere.Ifnot,youwouldneedtofindoutfromyourusershowandwheretheyareenteringthisinformation. -Victoria LikeLike Aaron Reply November11,2009at10:46am Victoria, Thanksforyourquickreply.IamnewtoGPandIdon’tknowifwehaveEFTforpayablesmodule. Thanksagainforyourhelpandyourwebsite. -Aaron LikeLike JerriDegner Reply November4,2009at11:42am WhileinDynamicsGP,IfIgotoPurchasing\Inquiry\TransactionByVendor,selectaVendorIDofavendorI’veimportedtransactionsfor,therearenotransactionsdisplayed. However,ifIgotoPurchasing\Inquiry\TransactionByDocument,changethedocumenttolookupbyVendorID,selectthesamevendorI’veimportedtransactionsfor,thetransactionsappearinthelist. IalsohaveanissuewiththesesametransactionsnotbeingabletobeopenedviaSmartList\Purchasing\PayablesTransactions.Ireceivetheerror:Aget/changeoperationontable‘Batch_Headers’couldnotfindarecord IsthisnormalbehaviorforDynamics?Anyhelpisgreatlyappreciated! LikeLike VictoriaYudin Reply November4,2009at5:39pm Jerri, NoneofwhatyouaredescribingisnormalbehaviorinGP.ThefirstquestionIwouldhaveishowexactlyyouareimportingyourtransactions.Also,whatversionofGPareyouon? -Victoria LikeLike JerriDegner Reply November5,2009at9:22am ThanksforreplyingVictoria!Ididn’tthinkthatwasnormal🙂Ikeptreviewingthedataandfoundthatifthebatchsourcedoesn’tmatchacrossalltheSQLentries,Iwouldgeterrors.OnceImadethemallthesame,everythingisworkingfine. Again,thanksforallofyourhelpandyourwebsite,it’sbeenahugetimesaverforme! Jerri LikeLike VictoriaYudin Reply November5,2009at9:28am Jerri, Gladyouwereabletofigureitout!Andthanksforthekindwords.🙂 -Victoria LikeLike Jerri Reply October16,2009at8:04am I’minsertingdistributionsintothePM10100tableviathestoredprocedurezDP_PM10100SI.However,whenIpullthattransactionup,andgototheDistributionswindow,noneofthedistributionsarelisted.IsthereanothertableIneedtoinsertdataintoformydistributionstoshowinthiswindow? LikeLike VictoriaYudin Reply October16,2009at8:11am Jerri, Itypicallydonotrecommendinsertingtransactionaldatadirectlyintotables.Togetsupportforthistypeofproject,thebestcourseofactionistoeithercontactMicrosoftGPdevelopersupportorpostaquestionontheGPdevelopernewsgroup. -Victoria LikeLike Jerri Reply October16,2009at9:33am I’mwritingatoolusingVisualStudiothatiscallingthesestoredprocedures,IthinkIfoundwhatIneeded,zDP_PM00400SI. ThanksVictoriaIloveyoursiteandallofyourhelpfulinformation! LikeLike VictoriaYudin Reply October16,2009at9:35am Jerri, Thanksfortheupdate–gladyoufoundwhatyouneeded!Andthankyouverymuchforyourkindwords. -Victoria LikeLike FernandoAndrade Reply October1,2009at2:37pm HiVictoria thanksforallofyourreplies Youareveryhelpfull InthecompanyIworkthereisapolicythattheystartcalculatingtheduedateofapurchasewhenthevendorbringstheirpurchaseinvoicenotthedateinthatinvoice. imeanapurchaseismadeinSeptemberthefirstduedateofpaymentSeptemberthe30th,butthevendorbringtheirpurchaseinvoiceonSeptemberthe15thsomycompanywantsthattheduedatestartscountingonthatdate(September15th)sothenewduedatewouldbeOctober15th. IsthereawaytoupdatedeDueDatefieldinPM20000todothisoryouhavetoupdateanothertablesaswell. IhopeImademyselfclear,pardonmyenglish Thanksinadvance LikeLike VictoriaYudin Reply October2,2009at1:55pm Fernando, Inmyexperiencemostbusinesseswillnotenteraninvoiceuntilthegoodshavebeenreceived.Areyousayingyouareenteringaninvoicefirst,thenreceivingthegoods,thenwanttogoandchangetheduedateoftheinvoice?Ifso,youcanchangetheduedatebygoingtoTransactions>Purchasing>EditTransactionInformation.Bringuptheinvoicethereandchangetheduedate.YoucouldalsochangetheduedatedirectlyinPM20000,ifyouprefer.Ipersonallyprefernottomakeongoingchangestothedatabaseifthereisanotheroption. -Victoria LikeLike enricoinoz Reply September16,2009at7:31pm HiVictoria, Goodmorning. WhileonthePM00200canyouaddthefollowingtothelist: selectMINPYTYP,MINPYPCT,MINPYDLR,*frompm00200 —0=NoMinimunradiobutton —1=Percentradiobutton.PercentvalueisintheMINPYPCT —2=Amountradiobutton.AmountvalueisintheMINPYDLR selectMXIAFVND,MAXINDLR,*frompm00200 —0=NoMaximumradiobutton —1=Amountradiobutton.AmountvalueisintheMAXINDLR selectWRITEOFF,MXWOFAMT,*frompm00200 —0=NoWriteoffradiobutton —1=Unlimitedradiobutton —2=Maximumradiobutton.AmountvalueisintheMXWOFAMT Cheers. Regards, Eric LikeLike enricoinoz Reply September16,2009at7:35pm HiVictoria, Myapologiesfornotclarifyingtheabovescripts.AsIclickedsubmitalittletooearly.🙂 AllthescriptsabovearefromtheCreditor/VendorMaintenanceOptionswindow(Cards>>Purchasing>>Creditor/Vendor>>Optionsbutton) ThefirstoneisfortheMinimumPaymentline. ThesecondisfortheMaximumInvoiceAmtline. AndthethridfortheWriteoffsline. Thanks. Regards, Eric ThefirstoneisfortheMinimumPaymentsec LikeLike VictoriaYudin Reply September18,2009at7:50am Eric, Thankyouverymuch! -Victoria LikeLike Shabnam Reply August5,2009at11:56pm HiVictoria, InmycompanywewouldliketointegratepurchasereturnstransactionviaeConnect. ButIcannotfindanynodeforpurchase(POP)returnstransaction,nodesforthisisavailable,ifyeswhatisthenameofit. Thanksinadvance. Shabnam LikeLike VictoriaYudin Reply August6,2009at5:03am Shabnam, Idon’tbelievethereisanexistingoneforPOPreturns.Youwouldneedtocreateyourown. -Victoria LikeLike VicBerggren Reply August5,2009at9:31pm ReallyniceresourcelistVictoria,thanksforposting… LikeLike Lily Reply May28,2009at10:22am ThanksVictoria, Youarealwayshelpful! LikeLike Lily Reply May27,2009at2:10pm Hi,Victoria, MyAPGLtrialBalancedoesnottietomyAPagingbalance.Whattypeofentriescouldresulttheproblem?Howtosolveitingeneral? Thanksinadvance. LikeLike VictoriaYudin Reply May28,2009at4:34am Lily, Thefullanswertothiswouldprobablyrequireaquitelengthypost,astherearemanydifferentscenariosandpossiblereasonsthatcouldcausethis.Hereareafewlinksthatmighthelpyou: ReconciletoGLEasilyontheRoseBusinessSolutionsblog HowtoreconcileGLtoPayablesmodule?onMSGPNewsgroup A/PsubledgerdoesnottietotheG/LonMSGPNewsgroup -Victoria LikeLike JoAnnCass Reply April24,2009at2:45pm HiVictoria, Ihaveancreditamountof$149.31from2005thatIneedtoclearfrommyagingreport.ThiscreditistheresultofaCMintheamountof628.30appliedtotwoinvoicesfor243.30and235.69.The628.30CMand243.30invoiceshowasopenitemswhilethe235.69invoiceispostedtohistory.WhenItrytocorrecttheopenitems,Igetthemessagethattheitemsarepartiallyapplied.ItriedtogenerateadummyinvoicebutreceivedthemessagethatIcouldn’tapplythatinvoiceuntiltheothershadbeenposted.Ihavenooutstandingbatchestopost.HowdoIgetthiscorrectednow? Thanks, JoAnn LikeLike VictoriaYudin Reply April25,2009at10:23am JoAnn, Haveyoutriedenteringandpostinganinvoicefor$149.31,thengoingtoApplyPayablesDocumentsandapplyingtheremainingamountofthecreditmemotothisnewinvoice?Iamnotquitesurewhatspecificallyyoutriedwhenyousayyou‘trytocorrecttheopenitems’,doyoumeanyoutriedtovoidthem? -Victoria LikeLike JoAnnCass Reply April27,2009at4:57pm Ididtryenteringaninvoiceforthe$149.31andreceivedamessagethatIcouldnotapplythisinvoiceuntiltheotheropeninvoicewasposted.Theopeninvoicecouldnotbepostedbecausetherewasnothingtopostitagainst. Yes,bycorrectingIdidmeanItriedtovoidthem. JoAnn LikeLike VictoriaYudin Reply April28,2009at7:04am JoAnn, Notbeingabletovoidiscorrect–youcannotvoidpartiallyappliedtransactionsinPayables. Therestofthisdoesn’tsoundsrighttome,though,andIamwonderingifyouareusingthewords‘post’and‘apply’interchangeably,whileIamtakingthemtomeanverydifferentactionsinGP.Canyoupleasegivememoredetail?WhatisthenameofthescreenthatyouareoninGP,whatspecificallyareyoudoing/clickingandwhatistheexacttextoftheerrormessage? -Victoria LikeLike Lily Reply April23,2009at10:07am ThankyouverymuchVictoriaforyourpromptresponse!That’sverydetailedandhelpful! LikeLike Lily Reply April22,2009at12:30pm Hello,Victoria, IamtryingtolinkGL30000withPM30600andPM30200butcouldnotfindrelatedfield.Thankyouverymuchforyourinput. Lily LikeLike VictoriaYudin Reply April22,2009at5:12pm HiLily, PM30200andPM30600willlinkonPM30200.DOCTYPE=PM30600.DOCTYPEANDPM30200.VCHRNMBR=PM30600.VCHRNMBR.That’sprettystraightforward. ForGL30000,youcouldtrylinkingonPM30600.DOCTYPE=GL30000.ORTRXTYPANDPM30600.VCHRNMBR=GL30000.ORCTRNUMANDPM30600.DSTSQNUM=GL30000.OrigSeqNum.However,Iamnotsurethiswillbeeverythingyouwant.Forexample,theremightverywellbeentriesinPM30600thatareinGL20000,notinGL30000.Also,dependingonhowyou’repostingtotheGL,youmightnotbeabletolinkfromPMtoGLindetailandmayneedtodoitinsummary,byGL30000.ORTRXSRC=PM30600.TRXSORCE. -Victoria LikeLike Jim Reply April14,2009at10:09am Victoria, Ihaveonereceivablebatchwithover600trxbutcannotpostb/cIamgettingerrormessage‘Thisbatchisbeingeditedbyotheruser’Nooneisinit. canyoupleasehelp? Thankyou, -Jim LikeLike VictoriaYudin Reply April14,2009at2:21pm Jim, Thereshouldbeanautomatedsolutionforthis,takealookatMarianoGomez’sblogpostaboutautomatedsolutions. -Victoria LikeLike Kyle Reply April7,2009at5:07pm Hello, Iamtryingtomakeacustomagedpayablesreport–howarethetransactionsinPM20000relatedtotheaccountslistedinGL00100? Thanksforanyhelp, Kyle LikeLike VictoriaYudin Reply April8,2009at3:20am Kyle, PM10100holdstheGLdistributionsforopenpayablestransactions(thoseinPM20000).TheDSTINDXinPM10100willlinktotheACTINDXinGL00100. -Victoria LikeLike Sherry Reply April3,2009at11:51pm Victoria, DoyouknowthetablewheretheGLtransactionswouldbe?IlookedatPM30600butitdoesn’ttellmetheGLcode.Isthereasimilartableforunpostedtrans? Thanks! LikeLike VictoriaYudin Reply April4,2009at6:53am Sherry, Thereare2tablesthatholdtheGLdistributionsforpayablestransactions: PM10100–GLDistributionsforWork(unposted)andOpen(postedbutnotpaid)Transactions PM30600–GLDistributionsforHistorical(postedandpaid)Transactions ThesetablesdonotstoretheGLaccountnumbers,onlytheaccountindex(DSTINDX).Togetthefullaccountnumber,ItypicallylinktotheGL00105table,sincethatholdstheconcatenatedaccountnumber. -Victoria LikeLike Jim Reply March24,2009at10:23am Victoria, Thankyouverymuch……. 🙂 -Jim LikeLike Jim Reply March23,2009at11:24am HiVictoria, Ihavequestion.IhaveonesalesbatchthatisbeeneditedbysomeonebutnotoneislogintothesysteminSOPTable.SOP10100 IamtryingtopostthebatchbutIamgettingerrorlike‘ThebatchisbeenEditedbysomeotheruser’Howdoigetridofthebatch…. CanIstillpostthisbatch?Ifnot,howdoIdeletethebatchfromSOPSOP10100? Thankyou, -Jim LikeLike VictoriaYudin Reply March23,2009at12:25pm Jim, Mypersonal2cents:ifyouarenot100%sure,don’tdeleteanythingfromtables.Thatsaid,hereisapostbyDougPitcherthatmayhelpforyourquestion:http://rbsgp.blogspot.com/2009/01/stuck-batches-in-dynamics-gp.html. -Victoria LikeLike Jim Reply March18,2009at5:37pm Thankyouverymuch….. -Jim LikeLike Jim Reply March14,2009at9:45pm Victoria, Thankyouverymuchforyouinput….Iwasjustwonderinghowaboutpm40101becausethathasallthebucketsandwhenIgotoGPFrontendviaInq—Purchasing—VendorCredititgiveustheagingthatiswhatIamlookingtofind. IwillreallyappriciateifthereissomethinglikethatIcanfindfrombackent. Again, Thankyou, -Jim LikeLike VictoriaYudin Reply March15,2009at6:43am Jim, PM40101simplyholdsthe‘setup’ofwhatyourpayablesagingbucketsare.Ifyouneedthisforreportingyouwouldneedtocreateyourownvieworstoredprocedurethatcalculatesthetotalsineachagingbucketforeachvendor. -Victoria LikeLike jim Reply March13,2009at5:49pm Hello, cansomeonetellmepleasehowdoIfindtheagingtableinpayablelikewehaverm00103forReceivable? Thankyou, -Jim LikeLike VictoriaYudin Reply March14,2009at5:57am Jim, ThereisnoequivalenttotheRM00103tableforPayables.ThereisalsonoAgingroutineforPayables,whichiswhatupdatestheRM00103tableinReceivables. -Victoria LikeLike Jeganeedhi Reply March5,2009at4:26am Victoria, InitiallyIalsosearchedinSDK,butIdidn’tgetanyinformationaboutPMApplyTables(WhyPMApplyTablesarenotincludedinSDK?). ThenonlyIapproachedyou.. Thankyouforyourresponse………….. LikeLike VictoriaYudin Reply March5,2009at7:04am Jegan, Unfortunately,theSDKismissinglargechunksofinformation…sometimesawholemodule,or,asyouhavefound,asectionoftables,willjustnotbeinthere.Ihavealsofoundthatsomeoftheinformationisnotexactlyuptodate.AnythingthatIfind,whetherthroughmyownresearchorthroughthehelpofothers,Iplantopostuponthisblogsothatwecanallbenefitfromit. -Victoria LikeLike Jeganeedhi Reply March4,2009at9:35am Hi, IneedsomeinformationaboutthefieldOAPYTORNDAMT(OriginatingApplyToRoundAmount)oftablePM10200&PM20100. Ithinkthatit’svalueisdependsupontheMuticurrencyapplyprocess. Whatarethecalculationsinvolvedinthisfieldvalue. Thanks Jegan LikeLike VictoriaYudin Reply March4,2009at10:35am Jegan, Unfortunately,IdonotseeanydetailsonthisfieldintheSDK.Inthesesituations,IwouldgotoGPSupportandaskthemforwhateverinformationIamlookingfor.Sorrynottobeofmorehelp. -Victoria LikeLike VictoriaYudin Reply February2,2009at9:19am Bab, ThePM30200tableholdtheactualhistoricaltransactions.ThePM30300tableholdsapplyinformationabouthistoricaltransactions.Hopethathelpstoclarify. -Victoria LikeLike Bab Reply February2,2009at9:16am Iamsorry,ImeanPM30300. LikeLike Bab Reply February2,2009at9:15am whatisthedifferentbetweenthesetwotables? PM30200–Historical/PaidTransactions PM30300–ApplyToHistory IthoughtPM30200tableholdsPaidtransactionsaswell.AmIwrong? LikeLike TauqirAbbas Reply December6,2008at6:08pm ThiswillhelpfulfortechnicaldevelopersofGreatPlains Thankyouverymuch!!!!!!!!! LikeLike PamelaStreet Reply December18,2012at2:53pm Victoria,whatisthedifferenceinthePM00201andthePM00202tables?Ihaveseveralentriesthatarenotmatching…Thanks LikeLike VictoriaYudin Reply December18,2012at5:40pm Pamela, Onetableisasummary–onelinepervendor,andtheotherisdetail–onelinepervendor,peryear,perperiod,perperiodtype(fiscalvs.calendar).Whatexactlyareyoucomparingthat’snotmatchingup? -Victoria LikeLike Trackbacks/Pingbacks InterestingFindings&KnowledgeSharing»KeyTableInformationinMicrosoftDynamicsGP- January2,2009 […]PMTables–ClickHere[…] LikeLike LeaveaReplyCancelreply Enteryourcommenthere... Fillinyourdetailsbeloworclickanicontologin: Email(required)(Addressnevermadepublic) Name(required) Website YouarecommentingusingyourWordPress.comaccount. ( Log Out /  Change ) YouarecommentingusingyourTwitteraccount. ( Log Out /  Change ) YouarecommentingusingyourFacebookaccount. ( Log Out /  Change ) Cancel Connectingto%s Notifymeofnewcommentsviaemail.Notifymeofnewpostsviaemail. Δ Searchthisblog: Searchfor: MyLastBookDynamicsGP2013ImplementationMyPreviousBookDynamicsGP2010ImplementationEmailSubscription Enteryouremailaddresstosubscribetothisblogandreceivenotificationsofnewpostsbyemail. Join3,109otherfollowers EmailAddress: Signmeup! GPReportsViewerNewsletter SignupfortheGPReportsViewerNewslettertogetreportingtipsviaemail RSSFeeds RSS-Posts RSS-Comments Tags PopularLatestComments articles awards BankReconciliation book CrystalReports DynamicsGP Excelreports Extender featured FixedAssets FRx GeneralLedger GP8.0 GP9.0 GP10.0 GP2010 GP2013 GP2015 GPReportscode GPReportsViewer GPSQLstoredprocedure GPSQLview GPtableinformation IntegrationManager Inventory ManagementReporter Microsoft MicrosoftMVP Miscellaneous MSDynamicsWorld Payables PurchaseOrderProcessing Receivables SalesOrderProcessing security servicepack SmartListBuilder SQLcode SQLServer SupportDebuggingTool supportlifecycle version Vista Windows7 yearendclose UsingcreditcardstopayvendorsinDynamics GP January4,2009 SQLviewforPayablesGLdistributionsinDynamics GP November28,2008 SQLviewforallpostedGLtransactionsinDynamics GP August11,2009 SalesTransactionEntryGLdistributionsinDynamics GP December8,2008 SQLviewforPayablespaymentapplydetailin GP October22,2009 YearendcloseinDynamics GP November14,2008 SQLviewtoshowAPapplyinformationin GP October22,2008 SQLviewwithARapply detail February15,2010 GrantingaccesstoanewSmartListinDynamics GP October8,2008 SQLviewwithallSOPline itemsinDynamics GP May17,2009 SQLviewforunpostedchecksinDynamics GP August29,2017 SQLviewforrolling12monthsofsalesbyitembysiteinDynamics GP April20,2017 DynamicsGPsalesamountsandquantitiesforrolling12 months March14,2017 UpdatingDynamicsGPdatadirectlyin SQL January17,2017 DidyouknowyoucanchangeVoiddatesonPayables transactions? September20,2016 RefreshableExcelreportformonthlyactualsvs.budgetsinDynamics GP May25,2016 SQLcodetoshowtopXpercentofvendor data March21,2016 DiscountfromPackt Publishing September15,2015 RefreshableExcelreportforhistoricalGLtrialbalanceinDynamics GP August13,2015 RefreshableExcelreportformonthlyGLbudgetinDynamics GP April28,2015 VictoriaYudin:HiMerri, Iwillemailyoudirectlyaboutthis. ... MerriGorrell:Thatmakessense!I'llhavetocheckwiththedec... VictoriaYudin:HiMerri, Thatcodetookmeanincrediblylongti... MerriGorrell:HiVictoria; YoumentionyouhavecodeforanARa... VictoriaYudin:HiCasey, Myunderstandingisthatanydocattach... Casey:ThanksVictoriaforallofyourblogs/postabout... Ren:HiAlbert,ItoohaverunintoasituationwhereI... VictoriaYudin:HiArslan, Idon'thaveanythingthatcombinesve... ArslanKhalid:HiVictoria,Reallyappreciatetheworkyouhaved... VictoriaYudin:Chris, Theaccountnumbercanbedifferentforea... Links DynamicsGPCommunity DynamicsKnowledgeBase FlexibleSolutions,Inc. GPReportsViewer GPWindow–searchforanythingGP MSDynamicsWorld Forums AsktheGPCommunity DynamicsUserGroup–GP MicrosoftPartnerForums TekTips–GP Blogroll AaronBerquist AmberBell BeatBucher ConstanceQuigley DavidMusgrave DevelopingforDynamicsGP DevonSouthall DwightSpecht DynamicsGPEngineeringTeam DynamicsGPLand DynamicsGPSupportandServicesBlog DynamicsCare eOneDynamicsGPandCRMBlog ERPSoftwareBlog FrankHamelly GloriaBraunschweig GSLBlog IanGrieve IanStewart JanHarrigan–FRxandMR JanakiramM.P. JenKuntz JimHummer JivteshSingh JohnLowther JonathanPCox LesWright LeslieVail MarianoGomez MarkPolino MichaelD.JohnsonII MicrosoftMVPBlog MicrosoftTeamBlogs MohammadR.Daoud MSDynamicsPartnerBlog OfficialDynamicsGPBlog RonWilson RoseBusinessSolutions ShawnDorward–GPLifeHacks SivakumarVenkataraman SteveEndow TimWappat VaidyMohan Pages GP2016Resources GPResources(builds 18.x) Resources GP2015Resources GP2018Resources DynamicsGPResources GP2013Resources GP2010Resources GP10.0Resources GP9.0&Older Versions SQLServerResources MR&FRx Resources GP Reports CrystalReportsTips GeneralLedgerSQL Code InventorySQLViews PayablesSQLViews SOPSQLViews SQLServerCoding Tips System/SetupSQLCode ReceivablesSQLCode GPTables BankRec Tables Company/System Tables FixedAssets Tables GL Tables Inventory Tables Payroll Tables PM Tables POP Tables RM Tables SOP Tables AboutMe FunStuff MostClickedLinksvictoriayudin.wordpress.c…mbs.microsoft.com/Files/c…gptables.prospr.bizgplifehacks.com/2017/12/1…packtpub.com/microsoft-dy…docs.microsoft.com/en-us/…mbs.microsoft.com/custome…mbs.microsoft.com/custome…flex-solutions.com/gprepo…gpreportsviewer.com/gprep…RecentBlogComments VictoriaYudinonReceivablesSQLCodeMerriGorrellonReceivablesSQLCodeVictoriaYudinonReceivablesSQLCodeMerriGorrellonReceivablesSQLCodeVictoriaYudinonCompany/System Tables CategoriesCategories SelectCategory CrystalReports  (17) DynamicsGP  (166)    Extender  (3)    GP10.0  (19)    GP2010  (22)    GP2013  (8)    GP2015  (3)    GP8.0  (9)    GP9.0  (11)    GPSQLscripts  (74)    SmartListBuilder  (5) Events  (6) FRx  (5) GPReportscode  (100)    BankRecSQLcode  (2)    CrystaltipsforGP  (11)    Excelreports  (4)    FixedAssetsSQLcode  (3)    GLSQLcode  (14)    InventorySQLcode  (9)    PayablesSQLcode  (20)    POPSQLcode  (2)    ReceivablesSQLcode  (12)    SOPSQLcode  (22)    SQLcoding  (8)    System/SetupSQLcode  (7) GPReportsViewer  (14) ManagementReporter  (2) Microsoft  (21) Miscellaneous  (14) SQLServer  (18) SSRS  (1) Uncategorized  (3) Hitssince9.17.2008 6,829,935 Archives Archives SelectMonth August2017 (1) April2017 (1) March2017 (1) January2017 (1) September2016 (1) May2016 (1) March2016 (1) September2015 (1) August2015 (1) April2015 (1) March2015 (1) January2015 (2) November2014 (2) September2014 (2) July2014 (2) April2014 (2) March2014 (1) January2014 (4) November2013 (1) October2013 (1) September2013 (1) July2013 (1) June2013 (2) May2013 (2) April2013 (1) March2013 (1) February2013 (1) January2013 (2) November2012 (1) October2012 (2) September2012 (1) August2012 (2) July2012 (1) June2012 (1) May2012 (3) March2012 (1) February2012 (2) January2012 (5) December2011 (2) November2011 (1) October2011 (3) September2011 (2) August2011 (2) July2011 (1) June2011 (1) May2011 (3) April2011 (1) March2011 (3) February2011 (5) January2011 (5) December2010 (2) November2010 (4) October2010 (2) September2010 (4) August2010 (3) July2010 (4) June2010 (3) May2010 (7) April2010 (2) March2010 (4) February2010 (3) January2010 (2) December2009 (1) November2009 (1) October2009 (3) September2009 (4) August2009 (3) July2009 (3) June2009 (3) May2009 (3) April2009 (3) March2009 (5) February2009 (4) January2009 (8) December2008 (6) November2008 (8) October2008 (21) September2008 (7) VictoriaYudin. BlogatWordPress.com. Follow Following VictoriaYudin Join3,109otherfollowers Signmeup AlreadyhaveaWordPress.comaccount?Loginnow. VictoriaYudin Customize Follow Following Signup Login Copyshortlink Reportthiscontent ViewpostinReader Managesubscriptions Collapsethisbar SendtoEmailAddress YourName YourEmailAddress Cancel Postwasnotsent-checkyouremailaddresses! Emailcheckfailed,pleasetryagain Sorry,yourblogcannotsharepostsbyemail. %dbloggerslikethis: