Importing Patient refunds

"
EPIC system will be interfacing A/P (Pt. refund) data to Lawson. I provided the required specs for APCINVOICE, but noticed that the 2 records provided by EPIC do not have 1) Acct # and 2) the Vendor #

They have said that they do not have the ability to provide the Vendor#, but how can I get this file to include the acct#? (it is always 12110, fyi)
"

The account # should be something your AP dept should determine, and it should be fed from EPIC.

We feed from EPIC into Lawson pt refunds; the A/U, Acct is coded into EPIC and then interfaced with files which are loaded into Lawson.

If your vendors are one-time vendors then you don't need to provide the vendor #. THere is a one-time vendor flag on APCINVOICE (of course you'll need the payee name, addr, etc.)

If they are repeat vendors, then they could be coded on the EPIC side and fed to Lawson.

Roger French
Houston,TX.

Thanks Roger.

Yeah we know which A/U we want to use, but the importdb I am using is for file: APCINVOICE. This table does not have the acct unit. It is on the APCDISTRIB table, CVD-DIS-ACCOUNT.

How can I import (1) csv file for (2) refernced tables? (with the required field for the account?)

?

You use importdb to import the csv files into APCINVOICE, APCDISTRIB.

The account must be coded on the EPIC side for APCDISTRIB.

We don't use EPIC but the following should be the same scenario with your patient refund. Our setup uses mercator, BCI procedure and ScanFileClient to do the job. Our file comes from our legacy system(mainframe) and ScanfileClient kicks in when the file is present in a particular directory. Mercator maps the file into three output files APATTACH, APDISTRIB and APINVOICE. Once these files(csv) are created then the BCI procedure kicks in to do an impexp for each files. The last step is to submit the AP520 job.

We have been doing this since 4 3 years ago and never had any problems at all.

Hope this helps.

Posted By Roger French on 10/12/2006 7:13 AM

?

You use importdb to import the csv files into APCINVOICE, APCDISTRIB.

The account must be coded on the EPIC side for APCDISTRIB.

Ok, so I WOULD need EPIC to provide 2 CSV files? (APCINVOICE, APCDISTRIB)

Yes,
Plus if you want comments to print on the check stub such as a descirption of what the check was for. Example "This is a refund check for x$ for your recent visit to our clinic. Please call xxx-xxx-xxxx if you have any questions." This would go in on the APCATTACH file.