You can click a pushbutton on the invoice and create the RxMini file on your PC.
If you want to automate your side's Rebates, a program must be written to read this RxMini file
from your PC and adapt it into your Financials system. You can write such a program internally,
or we can write it for you (for an additional fee, and when our resources become available).
We have already helped customers build such adapter programs into various
Financials systems.
It is in our best interest that you succeed, so please, do not hesitate to contact us and
see if we can help! We will be glad to answer any questions.
Requirement: Write a program that reads the RxMini file and imports the data into your A/P system.
Suggestion: Reduce user training by reducing the number of keystrokes that the user will have to do in order to invoke the
program. The current record is 7 keystrokes. If you invoke the program with fewer keystrokes, please let us know, so we can update this website.
Note #1 - Looking up the Payee Code
Create a lookup table that matches our incoming 10-digit payee code to your internal system’s reference number for the payee.
You could even use a text file as such a lookup table, right on the user’s PC! Have your program use this lookup table to match
our incoming 10-digit payee code to your internal system’s reference number for the payee.
If/when we send a business partner code that is not in your system, have your program generate a message asking the user to update this lookup table,
preferably with some instructions suited for a non-technical user.
Note #2 - Will you summarize?
Ask your management for guidance: Do they want to see the line item detail for NDCs in the invoice as well?
Your company is already getting monthly reports that show all that detail anyway, so you may not need the detail.
In this case you might do well to aggregate the amounts from the N-records of the RxMini file.
Note #3 - Looking up the Product Code
If you answered Note #2 above as "yes, you will summarize", then you do not need to look up the product code. The information below, then,
applies only if you are going to show the line item detail.
If your system's internal reference for a product is not the 13-digit NDC,
or your system does not default the appropriate Unit of Measure for prescription units (TABs, MLs),
then you probably need one more lookup table: One that matches NDC to (a) your internal reference for a
product, if needed, and (b) to the Unit of Measure as listed in your system, if needed.
Just like with the Business Partner lookup table, you may want to have your program check
if each incoming NDC is listed in the lookup
table, and show the user some instructions on how to update the lookup table if necessary.
Recommendation: Rename or delete the RxMini file once used, so accidental repetition will not result in a duplication of the invoice.
