1,025
Hi Experts,
Is there any way to fetch records from channel database (POS tables) from X++.
For e.g. A sale is made in POS. Usually we run p-job to sync channel db and AX db so that all POS transactions gets reflected in D365.
But, my requirement is to create a batch (x++ class) which should get POS sale transaction details. Is there any possibility to write sql query from X++ to fetch POS sale transaction details?
Thanks,
N.Sridhar
*This post is locked for comments
Hi Ievgen,
As you said, yes its a strange requirement.
Thanks for your input.
However, is there any possibility to use X++ directly instead of c# or any other existing service to access POS sales tables?
Thanks,
N.Sridhar
It's a very strange requirement because duplicates job functionality, however, you should be able to connect to any data base using standard c sharp classes like SqlConnection www.codeproject.com/.../Beginners-guide-to-accessing-SQL-Server-through-C
However, would you have rights to access it ?
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
