Needing HL7 integration specs for Allergy Shot Module. Anything currently available? Has anyone done this?
In OpenEMR, when a user selects the “Payment Date” or “Invoice Date” option—especially in reports, billing, or EOB/ERA processing screens—the system uses specific database fields. Let’s break down the typical behavior and how these dates are mapped:
Shape
1. “Payment Date” Option – Which Date Is Used?
When you select “Payment Date” in reports or billing filters:
Likely Field Used:
From EOB/ERA:
→ deposit_date (from the ar_session table or manual_batch in case of manual entry)
From Payments (Patient/Insurance):
→ Could also be referencing check_date or post_to_date, depending on module and report.
Most common behavior in OpenEMR:
ERA/EOB payments: → Uses deposit_date (i.e., the day funds were deposited/recorded in the system).
Manual payments: → Sometimes post_to_date is used if explicitly entered during payment posting.
Shape
2. “Invoice Date” Option – Which Date Is Used?
When you select “Invoice Date”, it’s often meant to filter or tag the billing date associated with services rendered.
Likely Field Used:
date from the form_encounter or billing table. → This represents the Date of Service (DOS) or the date the charge was created.
Important Notes:
OpenEMR does not always use the term “Invoice Date” internally — this might be used interchangeably in custom reports or third-party billing modules.
If you’re running a report from Fees → Billing or Reports → Financial, and select “Invoice Date,” it’s usually tied to the encounter date (form_encounter.date) or billing.date (procedure date).
Shape
Summary
Option
Common Field(s) Used
Table
Notes
Payment Date
deposit_date, post_to_date
ar_session, manual_batch, insurance_data
For EOB/ERA, it’s usually deposit_date
Invoice Date
date (encounter/procedure date)
form_encounter, billing
Typically DOS or charge entry date
Shape
If you’re customizing or debugging, you can check the SQL queries inside:
interface/billing/billing_report.php
library/parse_era.php
interface/reports/collections_report.php
Let me know where exactly you’re seeing these options, and I can give you the exact query/field used in that module or form!
If you face any problem, You can access our experts