smartlist builder view not refreshing after field added

[elavelle]

I'm sure there is a simple answer, but I'm missing it. I just added a field
to an existing view in SQL and I need to add the field to an existing
Smartlist. However, the new field isn't showing in smartlist builder. I
even tried creating a new smartlist and the field isn't showing in the new
smartlist. I've refreshed the smartlist cashe and lists under Smarlist
Builder Maintenance but that doesn't resolve the problem. Any suggestions?

[Raymund Gerard I. Miraflor]

Hello,

If you have not done so, try removing access to the view that you have,
save the settings, then go back and assign security access to the view
again.

Best Regards,
Raymund Gerard I. Miraflor
Microsoft Dynamics GP
Microsoft Online Support

=====================================================
PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.

We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

[elavelle]

do you mean the security to the view in SQL or within GP?

[Raymund Gerard I. Miraflor]

The security to use the sql view within gp

[elavelle]

nope, that didn't do it. I removed the check mark, closed the window, added
the check back and then opened smartlist builder again.

"Raymund Gerard I. Miraflor" wrote:

[Mariano Gomez]

Here are the detailed steps I followed:

1) Create your view, i.e:

IF OBJECT_ID('dbo.querySomething') IS NOT NULL
DROP VIEW dbo.querySomething
GO

CREATE VIEW dbo.querySomething AS
SELECT JRNENTRY, TRXDATE, ACTINDX, DEBITAMT from GL20000
GO

GRANT SELECT ON dbo.querySomething TO DYNGRP
GO

2) Gave SLB security to the new object in GP. MSDGP > Tools > SmartList
Builder > Security > SQL Table Security

3) Created SLB with the new view, marked all columns in the Default list

4) Built Smartlist by going to MSDGP > SmartList. Click on Yes to build
SmartList

5) Went back to SQL Server Management Studio and added a new column to my view

ALTER view [dbo].[sampleGLforSLB] as
select JRNENTRY, TRXDATE, ACTINDX, DEBITAMT, CRDTAMNT from GL20000
GO

NOTE that in this case I added the CRDTAMNT (credit amount) column.

6) Went back to SLB, opened the smart list that I just built and clicked on
the Edit Selected Table button (the button with the clipboard and the pencil
on the Tables pane, next to the minus (-) button).

ALL I DID HERE WAS TO CLICK ON SAVE, NOTHING ELSE. Now my CRDTAMNT column
shows up in the fields list on the right pane. Then clicked the Default check
mark (if so you wish).

7) Click on Save on the SmartList Builder window.

8) Opened SmartList to build my modified view.

I will publish a new blog article with all the steps and pictures.

Hope this helps,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[elavelle]

It seems that going back to the edit button and just clicking save was the
key. The field is now showing. Thank you!

[Kayla Backer]

Hello

Checking in to see if there is anything else we can do for you on this
topic.
Please post again at your convenience and we will be here for you.

Have a great week!

Kayla Backer

Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security

==============================================

PLEASE NOTE: The partner managed newsgroups are provided

to assist with break/fix issues and simple how to questions.

We also love to hear your product feedback!

Let us know what you think by posting

from the web interface: Partner Feedback

from your newsreader: microsoft.private.directaccess.partnerfeedback.

We look forward to hearing from you!

=====================================================

When responding to posts, please "Reply to Group" via your newsreader

[Kayla Backer]

Hi there

Anything else we can do for you here on this query?

Please post back at your convenience and we will be here for you.
Thanks again for using the partner newsgroups!

[SeanM]

I created a smartlist in smartlist builder like I have many times before.
Now, others aren't able to view my most recent report. I did nothing
different than I normally do. Any help would be greatly appreciated.
Thank you,
Sean

[Victoria [MVP]]

Sean,

Is your SmartList based on a SQL View? If so, did you grant access to the
SQL view to DYNGRP? If not, did you grant security access to the new
SmartList?

If that does not help, can you please provide more information? For these
kinds of questions, since there are so many possibilities and options, it
would be really helpful to know the following:

- What version of GP?
- What you have already tried?
- Who can see the SmartList and who cannot?
- Is the SmartList based on a SQL view/table or GP table?
- What do you mean by 'like I have many times before' - this is, of course,
obvious to you, but not to others. :-)

--
Victoria Yudin
Dynamics GP MVP
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com

"SeanM" <Se...@discussions.microsoft.com> wrote in message
news:BCC5849D-F0EF-433F...@microsoft.com...

[Jen Mehrer]

Hello,

We are excited to introduce you to a new and improved Partner Online
Technical Community Experience. Please post this new inquiry to our new
forums-based platform here:

http://social.microsoft.com/Forums/en-US/

To continue to receive support on this issue please repost it on the link
above.
Look forward to working with you there!
Thanks
Jen