Patient Refund .CSV file

 6 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
mil0n023
New Member Send Private Message
Posts: 0
New Member
I have been tasked with providing Vendor= Epic with the field mapping for Patient Refund processing. I believe I need the APCINVOICE, APCDISTRIB, & APCPAYMENT tables - but, am not sure the best route to go for figuring out the proper mappings. They (Epic) did provide me with a Standard Extract guide, but was hoping someone could offer some advice?
mil0n023
New Member Send Private Message
Posts: 0
New Member
Well, I manually went through each field in the table, and compared it to the spec. Very manul effort.

Thanks anyway.
Shaji
New Member Send Private Message
Posts: 3
New Member
Do you have a patient refund interface running? I could use some help.
Bob Canham
Veteran Member Send Private Message
Posts: 217
Veteran Member
We have an interface running for Patient Refunds. Rather than using AP Invoices, we switched to using Cash Paments. This was a feature added in 9.0.1. The forms are CB54 (interface edit), CB55 (manual entry), and CB554 (import load).

This process uses a single vendor number for all refunds and then you enter the specific payee information. It uses the CBPMTLOAD file to do imports. The actual checks are cut through a normal AP150, etc process. There is an option on the AP150 to select CB paments in addition to AP payments to pick these up. It has helped us cut down a lot on one time vendors.
John Henley
Send Private Message
Posts: 3351
[quote]
Posted By Shaji on 07/07/2014 01:42 PM
Do you have a patient refund interface running? I could use some help.
[/quote]
Are you just starting out, or do you have something already set up and looking for help?
Thanks for using the LawsonGuru.com forums!
John
Micheale
New Member Send Private Message
Posts: 1
New Member
Do you know how to get the CB payments to all print at the beginning of the check run? We also do this but our refunds are printing under the R's for refund. The person that used to do these is no longer with the company and they had it set up to print the refunds first. Not sure how to sort them correctly to do this.
Kelly
Basic Member Send Private Message
Posts: 7
Basic Member
We run our refund CB payments separate from our AP payments. I think the sort option R (priority) on the AP150 job pulls from a setting on the vendor. On the AP10 options tab there is a field to set the priority for that vendor. If you set your CB vendor to priority 1 and then run the AP150 with sort option set to R then your refund checks should print first.