This is my error - I am just not sure how to correct it.  As you can see in the snippet below, after conversion of the RxWorks data, I am getting the same item shown as both medication and a customer invoice item. As you can see the 14/5/2013 visit has the duplication problem. The 18/7 visit was one I created with a consult, and as you can see just the medication record shows - though if you go look at the Charges tab, the Prednil is there as a charged item.

The kettle steps are shown below - note that there is some non-pertinent stuff shown because I am running a lot of the transform steps in parallel to reduce the total conversion time.

First the lot:

The crudely circled steps are expanded below:

First the 'load txns' job which does the invoices etc & the visits

Here there are 4 lots running in parallel - the top lot creates the visits, row 2 the adjustments and payments, and rows 3 & 4 the invoices etc - 3 & 4 do the same thing - just on different aged transactions [done in parallel to improve the performance]

Now the medication:

Again, ignore the top two rows, this is just stuff being done in parallel.  As you can see the bottom row is the medication related stuff.

So what am I doing wrong?

Am I creating the links in such a way that OPV is not recognising that the medication and charge items are the same (and thus should be only displayed once)?

Or is something else wrong?

Regards, Tim G