Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Retail POS - Custom Report

Posted on by Microsoft Employee

Dears,

How can i create my own custom report for Retail POS module?  What is the reporting base used by the Retail POS? is it SSRS or Crystal Reports?

is there any sample for me to refer for custom reports?

thanks in advance,

Ammar

Categories:
  • Ayush Jain Profile Picture
    Ayush Jain 120 on at
    RE: Retail POS - Custom Report

    It was SSRS report. I managed to print it via Hardware station.

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,586 on at
    RE: Retail POS - Custom Report

    Hi Ayush, what kind of report do you mean?

  • Ayush Jain Profile Picture
    Ayush Jain 120 on at
    RE: Retail POS - Custom Report

    Hi Oksana,

    I tried to print the report but it only prints XML not the actual format. is there any other way?

  • Mohd irfan mehdi Profile Picture
    Mohd irfan mehdi 956 on at
    RE: Retail POS - Custom Report

    hi code,

    you can simply used the Report builder software or for query base report, base functionality is a good option.

    please once go though Mauro solution.

    this query base report is best and fast.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Retail POS - Custom Report

    Hi AmmarBIZ.

    Can you tell me , how use Crystal report or ssrs report for receipt in pos?

    Thanks a lot.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Retail POS - Custom Report

    Thanks a lot Oksana. I thought its crystal reports.  :)

    I had to go ahead with SSRS reports for me to get a customized invoice.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Retail POS - Custom Report

    Thanks a lot Mauro. Appreciate your reply.

  • Verified answer
    Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,586 on at
    RE: Retail POS - Custom Report

    Hi Ammar,

    POS can use different reporting engines:

    1) For X-report and Z-report POS simply builds text string and sends it to printer;

    2) For 'Advance invoice' report (Polish functionality) it calls AX via RTS to build SSRS report and print received report on Windows printer;

    3) For reports shown on POS screen (like Sales per hour / Sales per worker and etc. ) MS article can be helpful to understand how it works:  technet.microsoft.com/.../dn497829.aspx

    Crystal reports are not used in standard code, but if your POS needs to print documents with complex design, Crystal reports are nice solution.

    Regards,

    Oksana

  • Verified answer
    RE: Retail POS - Custom Report

    Hi,

    I'm assuming you're talking about the "View reports" operations. This isn't SSRS, neither Crystal. It's only a query that runs on top of the store SQL database. You can see the ones deployed by default in AX > Retail > Setup > Channel reports configuration (the last option in the menu). It's a lesser XML with a query definition. Create your own and send to the POS using the proper job.

    Regards, Mauro.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans