I have gone through the open dental solution to find the patient ledger and patient aging logic, below are the things which I have found.
1. Patient Ledger - Created the custom queries for tables below to get the patient or patient's family account records.
- ClaimSnapshot
- Claim
- Procedurelog
- Patient
- Paysplit
- Adjustment
- Claimproc
- Payplan
- Payplancharge
- Payment
- Statement
- Preference
- Definitions and other tables
2. Patient Aging - Getting the details from the Patient & Famaging table columns.
- Bal_0_30
- Bal_31_60
- Bal_61_90
- BalOver90
- InsEst
- BalTotal
Can we have Patient Ledger + Aging new API so that we can get the details for the patient and the patient's family details through that API?
Thank you