Intergration mapping table problem

Management and Administration
1

bklambdin wrote on Thursday, August 23, 2007:

The original problem was the billing transactions in sql-ledger was not going back into OpenEMR. OpenEMR still showed $0.00 as the money owed.

I have tried to open and save patient demographics that still has not fixed it.
I went into administration, database, intergration mapping and then empty, told it ok to truncate table intergration mapping, and then tried to save patient demographics again, still same thing.

OpenEMR does write the patient name to sql-ledger, but now no billing transactions.
Below is the error I’m getting now.

Entry has not been previously sent to external system or no entry was found for them in the integration mapping, could not send claim. Provider: ‘3’
Billing queue results:
back
Claim 3-200 was marked as billed only.

2

sunsetsystems wrote on Thursday, August 23, 2007:

Note that the error message references a “Provider”, so in this case you need to edit the user and re-save their information.  If you have cleared out the entire integration_mapping table then you’ll need to do this with all patients and all providers.

Rod
www.sunsetsystems.com

3

bklambdin wrote on Thursday, August 23, 2007:

Ah that was it.
Thanks Rod.

Brian