Microsoft Dynamics GP

RM Aging Report in Smartlist Builder

Home » Microsoft Dynamics GP » Microsoft Dynamics GP Forum » RM Aging Report in Smartlist Builder
Related Search Results

Dynamics GP : Reporting (FRx, Management Reporter, Business Alerts, Crystal, Report Writer, Smartlist, Builder and SSRS)

by Anonymous
on 10 Aug 2010
  • 0 comments

Date functions in Smartlist Builder

by
on 25 Feb 2013
  • Not Answered

Month, Quarter, and Year Selection for SmartLists in Microsoft Dynamics GP

by
on 29 Apr 2013
  • 0 comments

RM Aging Report in Smartlist Builder

This question is not answered
Anton Stoffaneller
Posted by
on 25 Feb 2013 4:33 PM

How can I get an Aging Report for all invoices per calendar month based on the invoice date?
All Replies
  • Bill Campbell
    Posted by
    on 25 Feb 2013 6:26 PM

    I had to build a Smartlist of this nature, and I think that it was a matter of the filters that we used.  Month and Year filters and Invoice only filters.

    It was able to get all the invoices listed, summarized and presented on the desktop of the users who needed the data.

    If I can help, let me know.

    Bill Campbell
    Director, Operations
    M.I.S. Management Information Solutions Ltd.
    Skype: billc.edmonton
    Cell: +1 780 994 2455
    Off : +1 780 481 5564                              
  • thetrev68
    Posted by
    on 26 Feb 2013 9:06 AM

    Have you been to Victoria Yudin's site?  She's got some views that would be a great starting point for this.

    victoriayudin.com/.../receivables-sql-views

    -Trevor
  • L Vail
    Posted by
    on 26 Feb 2013 9:42 AM

    I have done one of these reports based on invoice date that will tell you how old the document is. If you will e-mail me at leslievail@earthlink.net I can send you the export file so that you may import it.

    Kind regards,

    leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net