×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Micros Checks are not Syncing to the Simphony server

Micros Checks are not Syncing to the Simphony server

Micros Checks are not Syncing to the Simphony server

(OP)
Hello,

I'm facing a synchronizing issue with some of my POS from certain branches to my Simphony 18.2 server.
A few checks are not showing or missing in the My-Micros reports.
I assume this causes the difference between My-Micros reports and local POS reports.
Has anyone faced this issue, and if so, have you been able to resolve this?
please help.

RE: Micros Checks are not Syncing to the Simphony server

you should check the Mrequest in caps database , and the connection between caps and server database , is it on premise or cloud?

if you want you can reach me on cherifbj@gmail.com i can maybe help you out

RE: Micros Checks are not Syncing to the Simphony server

(OP)
It on-premise. I have found the tables [MREQUESTS] , [MREQUEST_DATA] in CAPS Db . Could please explain how I can investigate this problem using these or compare them with Simphony server tables

RE: Micros Checks are not Syncing to the Simphony server

if they have 3 as value in MREQUESTS it mean it failed to post to the server

RE: Micros Checks are not Syncing to the Simphony server

(OP)

Yes, I can see many records with [ReqState]=3 and a few records with 0. How we can resync with the server?
I have attached the screenshot for your reference could you tell me [RecordType],[ServiceID] and [OfflinePosting] indicating what and also tell me [ReqState]=0 what it means

https://files.engineering.com/getfile.aspx?folder=...

RE: Micros Checks are not Syncing to the Simphony server

reqstate 3 mean that checks are not being posted , try on caps , replay checks , and see what error do you have

RE: Micros Checks are not Syncing to the Simphony server

(OP)
Thanks a lot for sharing this knowledge. If you can tell me How can I find which check number has reqstate 3. This information will help me to track and find the missing checks and start to reconcile. And also tell me what you mean by Replay checks.

RE: Micros Checks are not Syncing to the Simphony server

try to run this sql scripts on caps server to find the checks not posting to myMicros:


select
TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss') Datetime,
case when MREQUESTS.ReqState='0' then 'Pending to Post'
when MREQUESTS.ReqState='1' then 'Posted'
when MREQUESTS.ReqState='2' then 'Failed Retry Later'
when MREQUESTS.ReqState='3' then 'Failed Rejected'
end as Enterprise_Posting_Status,
ReqState,count (reqstate) as Mrequest_Count from MREQUESTS
where TO_CHAR(Reqtime,'YYYY-MM-DD')>='2022-12-25'
group by MREQUESTS.ReqState,TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss')
order by TO_CHAR(Reqtime,'YYYY-MM-DD hh24:mi:ss') desc ,ReqState ;



If you can send me the egateway logs and mm logs ,I can help to fix you issue or you can try to restart the caps server & IIS.



RE: Micros Checks are not Syncing to the Simphony server

(OP)
Thank you very much for the query it is giving me the output Pending to Post and Failed Rejected. But could you tell me how can I find out which checks numbers are these

RE: Micros Checks are not Syncing to the Simphony server

You can use select mrequest_data.id,mrequest_data.checkid from mrequest_data.id to find the check id which not posting to LOC. + where Mrequest_Data.id = Mreqeust.id
And use the checkid to find the checknum in Guest_check.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close