Retail POS - Custom Report

(0) Share

Report

Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Mauro Pedro da Silva 552 on at

Like (2)

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.

Was this reply helpful? Yes No
Verified answer

Oksana Kovaliova 3,597 on at

Like (3)

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot Mauro. Appreciate your reply.

Was this reply helpful? Yes No
Community Member on at

Like (0)

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi AmmarBIZ.

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

Thanks a lot.

Was this reply helpful? Yes No
Mohd irfan mehdi 956 on at

Like (0)

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.

Was this reply helpful? Yes No
Ayush Jain 120 on at

Like (0)

Report

Hi Oksana,

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

Was this reply helpful? Yes No
Oksana Kovaliova 3,597 on at

Like (0)

Report

Hi Ayush, what kind of report do you mean?

Was this reply helpful? Yes No
Ayush Jain 120 on at

Like (0)

Report

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

Was this reply helpful? Yes No