X12 Biling SQL Syntax Error

Support
,
1

Situation
We recently upgraded to 7.0.1 and now

Billing staff unable to generate x12 files. Error message attached below.

Going to “Fees”, “Billing Manager” and deleting the “Today” constraint and selecting “Update List”

Check boxes on the right to select a few claims, then generate an x12 file from the dropdown menu.

OpenEMR Version
I’m using OpenEMR version 7.0.1

Browser:
I’m using: Firefox and Chrome

Operating System
I’m using: Kubuntu 20.04 and 22.04

Search
Did you search the forum for similar questions? yes

Logs
Did you check the logs?
Was there anything pertinent in them?

Error

1 Like
2

thanks for the report, will get this fix in the 1st patch

3

Thanks. I applied that to our server and it fixed the issue.