Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 712
  • Last Modified:

Question on Microsoft Dynamics Smartlist Tables for GP9 and GP10

We received a small list of tables for Smartlist section (version 11).  We typed it in our SQL and it seems not to exist.

What are these tables used for? And are they the same for version 9 and 10?
0
rayluvs
Asked:
rayluvs
  • 13
  • 9
  • 2
4 Solutions
 
rayluvsAuthor Commented:
the list


PhysicalName  DisplayName                TechnicalName            Series
ASILOC05      ASI_PM_Transaction_WORK    ASI_PM_Transaction_WORK  SMARTLISTforPURCHASING  version 11
ASILOC06      ASI_PM_Transaction_OPEN    ASI_PM_Transaction_OPEN  SMARTLISTforPURCHASING  version 11
ASILOC09      ASI_GL_Account_MSTR        ASI_GL_Account_MSTR      SMARTLISTforFINANCIALS  version 11

Open in new window

0
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Those tables do not exist in SQL in my out-of-the-box installation of GP 2010, GP 10.0 or GP 9.0.  However, I do see them in the resource descriptions inside GP, so my guess based on this is that maybe they are temporary tables used by SmartList?  What are you trying to accomplish with these tables?
0
 
rayluvsAuthor Commented:
Thanx.  No really accomplishment, just wanted to view them, see how they work or what are they for, etc.  Also seen the same for Smartlist Builder.

It says ' Physical Name' and also 'Table' in the excel we were sent, so we figure they were tables.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
I checked both views and tables in the DYNAMICS and company databases and do not see these anywhere in SQL.
0
 
rayluvsAuthor Commented:
So why are these tables referred in resources?

Strange, there must be a reason.
0
 
Abdulmalek_HamshoCommented:
These are for lookup favorites.
0
 
rayluvsAuthor Commented:
Understood, but when in SQL query analyzer, the table names it says it doesn't exist.  

Why there is a table name (Physical Name),  Display Name, Technical Name?
0
 
Abdulmalek_HamshoCommented:
Technical Name is used in Dexterity
Display Name is the user-friendly name
Physical Name is the SQL Table name

Try adding Favorites Smartlist lookups and then check the tables.
0
 
rayluvsAuthor Commented:
Prior placing the question we did, for example created a smartlist favorite for GL accounts and to "SELECT * FROM ASILOC09" and the following error appear:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'ASILOC09'.

We thought that too.
0
 
Abdulmalek_HamshoCommented:
Have you used Tools -> Setup -> COmpany -> Advanced Lookups to add the lookup?
0
 
rayluvsAuthor Commented:
Yes we did and created GL Account just tp make sure and still same error message.
0
 
Abdulmalek_HamshoCommented:
Are you running the SQL statement against Company DB?
0
 
rayluvsAuthor Commented:
yes we did, "SELECT * FROM ASILOC09"
0
 
Abdulmalek_HamshoCommented:
Against Company DB not DYNAMICS, right?

If you don't get anything in ASILOC09 after customizing Advanced Lookup, there must be something wrong. Something like the customized lookup was not saved correctly.
0
 
rayluvsAuthor Commented:
It is saved, I see it in the windows.  

Question, the Advance Lookup is related to Smartlist tables show above?
0
 
Abdulmalek_HamshoCommented:
You are right, I was referring to ASILOC90 and 50 rather than ASILOC09 and 05. I've check in Dexterity and found that ASILOC0X tables are added to the lookup forms but not used at all. Most probably, these tables are be obsolete.
0
 
rayluvsAuthor Commented:
Don't think so, I was sent the excel and it reads version 11.

0
 
Abdulmalek_HamshoCommented:
No, you didn't get me. I mean, these tables were existed in earlier GP versions, and kept there for compatibility only.
0
 
rayluvsAuthor Commented:
ok.

So basically there no use for these Smartlist excel I received?
0
 
Abdulmalek_HamshoCommented:
Smartlist excel?
0
 
rayluvsAuthor Commented:
sorry... in my question i stated  We received a small list of tables for Smartlist section (version 11).  That list came in an excel workbook. That's what I meant.

So basically there no use for this smartlist we have?
0
 
Abdulmalek_HamshoCommented:
I said "Most probably, there's no use for the tables you're asking about, and they are still existed in the documentation for backward compatibility purpose only."
0
 
rayluvsAuthor Commented:
Understood.
0
 
rayluvsAuthor Commented:
Thanx!  I awarded because the info provided was very useful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 13
  • 9
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now