x Want to participate? Join the group to interact
  • State Suggested Answer
  • +6 person also asked this people also asked this
  • Replies 15 replies
  • Answers 3 answers
  • Subscribers 146 subscribers
  • Views 7082 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
HNS

Calendar gadget

SUGGESTED
Posted By

Has anyone created a Calendar gadget?  I am trying to create a calendar that shows the PO Receipts for each day.  I created a query like this with a group on receipt date.

When I create the gadget on the landing page, the calendar shows up but there is no data populated.  If I click the refresh button for the gadget, it populates but in a grid view, not the calendar view.  Thoughts?  Thanks!

Parents
  • 0
    SUGGESTED

    Hi,

    First you have to create a requester, and note the date columns and their descriptions.


    Then you create the dashboard view (from Setup > Interactive dashboard). For my CRM calendar, I have these parameters (and same code as requester):

    - Data source: REQ (and point it to your request)

    - Visual Component: FCA (Calendar Flash)

    - FRQ: 1

    - INITLEVEL: 1

    - FCCTYPE: "XMONTH" (it could be "XDAY" | "XWEEK" )

    - FCSEL: 2 (yes)

    - FCDATEDEB | FCHEURDEB | FCHEURFIN | FCTITRE depend on the columns on your requester

    - FCTEXTE: "6,7,8,10,11..." (depends on your requester columns as well).

    And then you define the menu item pointing to your dashboard view. Link type should be "Calendar" and request level 99 (same in requester).

    Also, you can have a look to this:

    http://online-help.sageerpx3.com/erp/12/staticpost/calendar-widget/?highlight=portview

    Hope it helps!

    Alex

  • 0 in reply to Alex Lamarca

    Hello Alex,

    After I did all the configutarion, and I know the query is executed because it shows the total of results on the dashboard:

    But the calendar remains empty?!

    Which parameters do you use for Menu Item?

  • 0 in reply to Alexandre Fernandes

    Hi Alexandre,

    These are the parameters showing in my menu item:

    In this case "CRM098" is for the query.

    Cheers,

    Alex

  • 0 in reply to Alex Lamarca

    Hi again Alex,

    Thanks for answer, I tried like your suggestion but still not working.

    For Menu Item, I've got these:

    I tried on "portview" parameter "ENCCOM01" which is my query name, but the dashboard is continously searching, then I add the prefix "R" (Request), and it works, "RENCCOM01".

    For Dashboard View, I've got this:

    And the result is this:

    • Yellow - query results, we conclude the query is working
    • The second field date is the one used for FCDATEDEB parameter.
    • Looking at calendar, on 6th of April we should see something?!
  • 0 in reply to Alexandre Fernandes
    SUGGESTED

    Hello, Alexandre.

    After remote access with Sage Support, we reached the conclusion that it's likely an issue caused by the folder being migrated from an earlier version, since this particular issue was solved in PU9.

    I had this issue on a migrated folder, but not on a more recent folder generated from the reference folder already in V12.

    Also, if I refreshed the calendar widget, the graphic design of the calendar would disappear and it would show a grid.

    Kind regards,

    Pedro Rodrigues.

Reply
  • 0 in reply to Alexandre Fernandes
    SUGGESTED

    Hello, Alexandre.

    After remote access with Sage Support, we reached the conclusion that it's likely an issue caused by the folder being migrated from an earlier version, since this particular issue was solved in PU9.

    I had this issue on a migrated folder, but not on a more recent folder generated from the reference folder already in V12.

    Also, if I refreshed the calendar widget, the graphic design of the calendar would disappear and it would show a grid.

    Kind regards,

    Pedro Rodrigues.

Children

*Community Hub is the new name for Sage City