Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Dynamics GP - Smartlist Builder

Posted on 2011-02-15
3
861 Views
Last Modified: 2012-05-11
I am trying to create a calculated field in smartlist builder that will output the number of days between two dates.  Is this possible?
0
Comment
Question by:jnikodym
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 34901147
Yes.  I just set up a test to see if this worked using the Sales Transaction History table.  To get the difference between the GL Posting Date and the Document Date I used a field type of Integer and the following formula:

datediff(day, {Sales Transaction History:GL Posting Date} ,{Sales Transaction History:Document Date})
0
 

Author Comment

by:jnikodym
ID: 34901177
Is there anyway to get this calculated field on a smartlist that is built into GP, instead of doing it through smartlist builder?  Reason i ask, is i would like to add a calculated field to the receivable transactions smartlist.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 34901299
I don't think there is a way to do this without customization (and not a simple one).  What you may be better off doing is using something like my view here: http://victoriayudin.com/2009/04/24/sql-view-with-all-posted-receivables-transactions/ 
and adding your additional calculations and whatever else you need in SQL, then using the view in SmartList Builder.  I find the flexibility of being able to code in SQL a huge benefit in SmartList Builder.
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question