*** If you solve your issue please share the solution to assist others! ***Ĥ. Ha Erbach, be careful what you ask for :-)įollow me on Twitter: - *** Help Us, Help You.provide enough info so that we don't have to ask for more:) *** I knew some of these but couldn't find a comprehensive listing (or close to it). Subject: WINTYPE column in DYNAMICS.SY00800 table Here is a laundry list though for sure it is NOT COMPLETE and who knows to which WINTYPE third parties code their locks if they aren't still using dex_lock. Monitor your data with GP Home Page and a SmartList Use your GP Home Page and a SmartList to help you monitor your data. POP Returns Batch open coded to 2 correct PA Timesheets in Open window with Batch are coded to 1 and dex_lock but should be 1 and 100Ĥ. The IV Transfer Trx window w Batch is coded 1 and 100 correct.ģ. An IV Transaction Open window w Batch is coded to 1 and 1 when it should be 1 and 100.Ģ. This new design for locks was not implemented consistently however the design for the SY00800 was as follows:ġ: A Batch Lock on an Open Transaction recordġ00: A Transaction Lock on and Open Transaction record with or without a Batch NumberĢ: A batch Lock on and Open Batch ( not in a transaction window)īut then programmers went to work and added inconsistencies.ġ. With the release of GP10 around 2003 they added two new lock tables in the DYNAMICS database. "Sparkly" Steve Erbach - Business Analyst & MS Dynamics Platform Administratorįor the folks that have been around a while, GP used to do all the locks in the tempdb database dex_lock table. Is there a DYNAMICS lookup table that contains a description of each WINTYPE? but all it found was the SY00800 table itself. I used Redgate SQL Search to look for the WINTYPE field. What I'm looking for is a description of what those WINTYPEs are. That column can contain several different values: 1, 2, 100 mainly. However, the table contains a WINTYPE column. ![]() ![]() On my GP Admin Excel Dashboard, there's a table that lists the open batches in the DYNAMICS.SY00800 table. Otherwise, review the setup in Named Printer for the Bank Rec process you just described. I suppose you're only using a local printer and Named printer is not configured. Yet another esoteric "Sparkly" Steve question. You can verify any processes in queue via Microsoft Dynamics GP> Process Monitor, if this is clear, then print button in the report viewer is enabled.
0 Comments
Leave a Reply. |