Patient Refund .CSV file

 6 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran 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?
    M. C. Miller
    Analyst
    Salem, Oregon
    mil0n023
    Veteran Member
    Posts: 63
    Veteran Member
      Well, I manually went through each field in the table, and compared it to the spec. Very manul effort.

      Thanks anyway.
      M. C. Miller
      Analyst
      Salem, Oregon
      Shaji
      New Member
      Posts: 3
      New Member
        Do you have a patient refund interface running? I could use some help.
        Bob Canham
        Veteran Member
        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
          Posts: 3353
            [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
            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
              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.