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
It was SSRS report. I managed to print it via Hardware station.
Hi Ayush, what kind of report do you mean?
Hi Oksana,
I tried to print the report but it only prints XML not the actual format. is there any other way?
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.
Hi AmmarBIZ.
Can you tell me , how use Crystal report or ssrs report for receipt in pos?
Thanks a lot.
Thanks a lot Oksana. I thought its crystal reports. :)
I had to go ahead with SSRS reports for me to get a customized invoice.
Thanks a lot Mauro. Appreciate your reply.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (