Search found 27 matches

by speeples
Thu Oct 05, 2023 12:16 pm
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3760

Re: Query question

So I figured it out Tom! If you're still curious......it will only pull up those codes that were treatment plannED, not ACTIVE treatment. So on Monday when I want to look for my codes for the people that are scheduled this week, my codes won't show since the days haven't happened yet. And the Treatm...
by speeples
Wed Oct 04, 2023 12:17 pm
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3760

Re: Query question

AND pc.ProcCode IN('N1114') /* NOTE: put as many procedurecodes as you like, in single quotes separated by commas*/ )A; There is the last little bit of that query. A patient that is scheduled tomorrow has that N1114 code in their treatment plan. Then I changed the dates to reflect this week. I teste...
by speeples
Wed Oct 04, 2023 4:39 am
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3760

Re: Query question

That's what I was doing but it apparently only does codes that start with D. Do you know of another query for treatment planned codes that I can enter AND do a date range?
by speeples
Tue Oct 03, 2023 1:18 pm
Forum: Main Forum
Topic: Query question
Replies: 6
Views: 3760

Query question

I'm looking for a report for a date range and specific codes. I found this query: /*508 Active patients who have a specific code in treatment plan, with addresses like 304 with date range*/ /*Query code written/modified: 08/26/2016*/ SET @FromDate='2010-01-01'; SET @ToDate='2010-06-01'; SET @pos=0; ...
by speeples
Fri Jan 27, 2023 8:10 am
Forum: Main Forum
Topic: Insurance payments and writeoff reports
Replies: 0
Views: 4754

Insurance payments and writeoff reports

I have ran several reports and the math is not adding up. I need a report for the total amount of Cigna Payments (if it has the total of our billed amount that would be a bonus) and a report for the total amount of Cigna write offs.
Thank you :)
by speeples
Fri Oct 15, 2021 9:50 am
Forum: Main Forum
Topic: Query #287
Replies: 2
Views: 3510

Re: Query #287

Great I will try that! Thank you
by speeples
Wed Oct 13, 2021 1:42 pm
Forum: Main Forum
Topic: Query #287
Replies: 2
Views: 3510

Query #287

I posted on the FB page about 2 weeks ago and have not gotten a response.....is there anyway to change it to Date of LAST Appointment?
Thank you!
by speeples
Tue May 12, 2020 11:47 am
Forum: Main Forum
Topic: Edit Treatment Plan HELP
Replies: 2
Views: 4371

Re: Edit Treatment Plan HELP

Thank you
by speeples
Thu May 07, 2020 11:03 am
Forum: Main Forum
Topic: Edit Treatment Plan HELP
Replies: 2
Views: 4371

Edit Treatment Plan HELP

I'm trying to figure out why I don't have the option to leave a note when putting in estimates. Let me guide you: In the treatment plan, I double click on a procedure, which brings up the "Procedure Info". When I double click in the "Insurance Estimates and Payments" it brings up "Edit Claim Procedu...
by speeples
Wed Feb 26, 2020 10:56 am
Forum: Main Forum
Topic: Report for Unscheduled Tx
Replies: 2
Views: 6072

Re: Report for Unscheduled Tx

I will try that, thank you!
by speeples
Fri Feb 21, 2020 10:39 am
Forum: Main Forum
Topic: Report for Unscheduled Tx
Replies: 2
Views: 6072

Report for Unscheduled Tx

In Queries, is #50 (Treatment planned procedures, that are not in a scheduled apt ) a good report to get a date range of pt's that have unscheduled tx? Or is there a better one?
Thank you! :)
by speeples
Tue Dec 17, 2019 1:27 pm
Forum: Main Forum
Topic: Table of Contents
Replies: 4
Views: 7084

Re: Table of Contents

I don't remember specific boxes. I know it was working and now anytime I click that '?' it just takes me to the full table of contacts...I hope I'm making sense...I guess I can call LoL
by speeples
Thu Dec 12, 2019 1:07 pm
Forum: Main Forum
Topic: Online payments
Replies: 1
Views: 5481

Re: Online payments

We use Payconnect via Dentalxchange
by speeples
Thu Dec 12, 2019 1:05 pm
Forum: Main Forum
Topic: Request - Add "Pat Resp" to INS payment window & Edit Claim
Replies: 1
Views: 5274

Re: Request - Add "Pat Resp" to INS payment window & Edit Claim

This would be great. I just always type the pt portion in the remarks box "pt pays $x.xx"
by speeples
Thu Dec 12, 2019 12:55 pm
Forum: Main Forum
Topic: Table of Contents
Replies: 4
Views: 7084

Re: Table of Contents

It's the question marks on the UR corners next to the X to close the window.
by speeples
Thu Dec 12, 2019 11:50 am
Forum: Main Forum
Topic: Table of Contents
Replies: 4
Views: 7084

Table of Contents

Any idea why the little question marks in OD aren't working anymore....it used to bring up the exact how-to's of the location you're in, now it brings up the whole table of contents and it just refreshes when you finally find what you're looking for.
Thanks
by speeples
Thu Nov 07, 2019 9:08 am
Forum: Main Forum
Topic: EOD Report
Replies: 3
Views: 6533

Re: EOD Report

In the standard reports in the Production and Income box....I use the More Options to print my EOD. I've got that red tab, all that is correct...but the pt paid for it and it should be on the EOD report as the daily income. I like the fact that it can be "hidden" that way someone else doesn't alloca...
by speeples
Thu Nov 07, 2019 5:15 am
Forum: Main Forum
Topic: EOD Report
Replies: 3
Views: 6533

EOD Report

Good morning. I just started utilizing the allocation of prepayments to future tx after we did the update. My question is, on my EOD report, it's not showing the pt's full payment. For example, yesterday the pt paid her $30 for fluoride and wanted to pay $42.60 for her filling next week, so $72.60 w...
by speeples
Wed Jun 19, 2019 7:14 am
Forum: Main Forum
Topic: Insurance reversed payment 6 months after the procedures
Replies: 2
Views: 4808

Re: Insurance reversed payment 6 months after the procedures

I have had to do this and I called OD. They were great walking me through it....twice ;) It would be so much better to talk to someone than me try to type it out LoL
by speeples
Thu Jun 13, 2019 5:13 am
Forum: Main Forum
Topic: Help finding report
Replies: 2
Views: 3766

Re: Help finding report

Thank you :)
by speeples
Wed Jun 12, 2019 8:31 am
Forum: Main Forum
Topic: Help finding report
Replies: 2
Views: 3766

Help finding report

Hello,

I was wondering if someone could point me in the right direction to a report....I need a list of all subscribers that have Metlife dental insurance. I need an easy way to get their email and address so I can send them a letter.

Thanks :)
by speeples
Fri Apr 26, 2019 5:56 am
Forum: Main Forum
Topic: Multiple Cell numbers
Replies: 1
Views: 3669

Multiple Cell numbers

Can you put multiple cell numbers for a pt separated by a comma.....and will they get the texts? If it matters, we use Yapi (should I call them to make sure?) We have a mother that would like texts for her young adult son to make sure he comes to his appointments.
Thanks :)
by speeples
Tue Mar 26, 2019 2:36 pm
Forum: Main Forum
Topic: Block Scheduling
Replies: 1
Views: 3484

Block Scheduling

I didn't know if anyone does block scheduling and if you have a template?? And is there an easy way to do it?
We'd like to make sure we are blocking space, along with the appropriate time, for doc side and hygiene. We don't seem to have enough time for SRP's and recall for PM.
Thanks :)
by speeples
Mon Mar 25, 2019 9:24 am
Forum: Main Forum
Topic: Inactive Pt Report
Replies: 2
Views: 3705

Re: Inactive Pt Report

Thanks! I'll try it.
by speeples
Wed Mar 20, 2019 1:04 pm
Forum: Main Forum
Topic: Inactive Pt Report
Replies: 2
Views: 3705

Inactive Pt Report

Hello,

I'm looking for a report that gives all our Inactive/Non-pts. I want to make sure we don't have insurances attached to them. We are trying to figure out how many pts we have for each insurance carrier.
Thank you :)
by speeples
Fri Feb 15, 2019 6:20 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 4722

Re: Edit Ins Window

Thank you.
Also, anything about having the subscribers DOB next to their info?
by speeples
Wed Feb 13, 2019 6:28 am
Forum: Main Forum
Topic: Edit Ins Window
Replies: 3
Views: 4722

Edit Ins Window

Good Morning,
I hope this is the correct place to ask this question (first time here :wink: )
How do you all enter the frequencies for, example, exams and prophy's that are 2 per 12 months?! I'm just doing every 6 months, but I wasn't sure if there was a better way.

Thanks
Sam :)