Tuesday, May 9, 2017

AX Modern POS (MPOS) Retail Channel Reports missing and setup

When in the Dynamics AX Modern POS, you have the capabilities to do reporting based on the local store DB. There are 13 canned reports that come out of the box, but a user can add additional as needed or modify the base reports.

Some may notice when entering the POS Reports screen that there may not be any reports in this screen out of the box. Its just blank. Or they get a POS Permissions error. This is because the Retail POS reports are driven off of POS Permissions and may not have any assigned. POS Permission groups need to be added and pushed down to the store for them to be visible (via the 1110 job in Figure 2).

I had an issue where the Retail Channel Reports Configuration would never actually populate the ‘Permission Group’ field after setting it (Figure 1). Setting it would only create a record in the table in the backend with a 0 RecID field value in the POSPermissions field I just tried to set. 

Initially there were no records in the ‘RetailReportPermissionGroup’ field. And the data was never in the POS store tables (hence no reports visible). Only by adding a value to that field would it create a record in this table. And the POS Permission group would overwrite to zero. So it didn't actually work.

My fix to this was going into the AOT and manually set the fields to the POS Permission Groups (Figure 3). If you go back in the ‘Retail Channel Reports Configuration’ form after all the values are set, the POS Permission value in the backend would override the RecID to 0 again.

UPDATE: I solved the issue of the POS Permission groups disappearing in my post here: http://daxdude.blogspot.com/2017/05/ax-pos-permission-groups-and-leading.html


HELPFUL HINT 1
I would recommend that you copy an existing report and modify it till you are comfortable with how the reports run before creating one from scratch. 

HELPFUL HINT 2
As a recommendation, only make the report reports action button visible to people who can actually access the reports. Otherwise it looks like a system bug. 



Figure 1 - The retail channel reports with the missing Permission Group

Figure 2 - Run the 1110 job to push the POS retail reports to the stores

Figure 3 - The 'RetailReportPermissionGroup' table

26 comments:

  1. Thank full , EPOS he was new Way to help to us to get the business running sucessfull.

    ReplyDelete
  2. Nice post,Thanks for given this wonderful till system information.I appreciate your blogs and look forward for your next blog.

    ReplyDelete
  3. I found some useful information in your blog, thanks for sharing this great topic.
    The leading online coaching supplier offers numerous courses on the various technical platform.

    anegis consulting

    ReplyDelete
  4. Nice post and good quality contents keep it up.Feel free to give me some tips for my blog

    http://daynamicsaxaptatutorials.blogspot.in/

    ReplyDelete
  5. Excellent post! till system I appreciste your work, great stuff to share...

    ReplyDelete
  6. Wow awesome best retail pos blog, Thanks for sharing Fantastic information.

    ReplyDelete
  7. Thanks for this post best pos system for retail it is very intersting and helpful to us.

    ReplyDelete
  8. Thanks for sharing fabulous information. epos It's my pleasure to read it.I have also bookmarked you for checking out new posts.

    ReplyDelete
  9. It was a really awesome post  epos system and I would really like to know more.

    ReplyDelete
  10. Great blog created by you. I read your blog, epos system its best and useful information. You have done a good work.

    ReplyDelete
  11. Thanks for the post. epos systems for small retailers I've been looking for more information good work keep it up

    ReplyDelete
  12. Thanks for giving important information
    Bridge POS

    ReplyDelete
  13. Thanks for great information you write it very clean. epos I am very lucky to get this tips from you.

    ReplyDelete
  14. Good information to know and right to the point. epos software Thanks for this well written post, i'll follow up for more updates if you keep posting them.

    ReplyDelete
  15. Thanks for sharing such unique information epos software which are in actual fact as well as helpful for us.Keep it up.....

    ReplyDelete
  16. Interesting blog. epos software It would be great if you can provide more details about it. Thanks you.

    ReplyDelete
  17. Very Interesting and useful epos system information you have shared and keep sharing the blogs....

    ReplyDelete
  18. Great blog, epos systems Thanks for sharing some valuable information.

    ReplyDelete
  19. I love reading your blog epos system for small business and look forward to all your posts! Keep up the superb work!

    ReplyDelete
  20. So happy to be given a privilege to post. epos system for small business I really enjoyed reading your blog post.

    ReplyDelete
  21. EPOS system and software for takeaway is best solution for all type of business especially takeaway,Restaurants, Bakeries,Shops etc.
    Intelepos is offering POS point of sale software and system that fits to small businesses.
    takeaway epos software
    epos software for takeaway
    INTELEPOS.COM
    POS point of sale syatem for takeaway and other business is more efficient for customers management and order management.
    https://intelepos.com/takeaways

    ReplyDelete
  22. Nice blog.. epos software I would like to thank you for the efforts you have made in writing this interesting and knowledgeable post.

    ReplyDelete
  23. Fantastic post. epos software Lots of useful information here. thank you in your effort!

    ReplyDelete
  24. The POS that will Revolutionize Your Business. Business Pos The perfect tool to help make running your business easier and more profitable.

    ReplyDelete
  25. Really good work there. Informative and helpful. Appreciate it. But might be looking for Retail Store Management Software in New York

    ReplyDelete