As part of an RxWork conversion I am loading payment data. The payments are showing up in the Customer|Account view as shown here.

Ther top payment here (-200.00 dated 29/10/12) is a test transaction I made.  The remainder are the loaded payments.  As you can see from the selected one (-70.00 on 7/9/12) the till is correctly set.

However, if I look at the till balance, the only transactions showing up are my test ones (you can see bottom one is the $200 from above), and none of the loaded ones are there.

So I must be doing something wrong in the load. The mappings for the loader step in the transform are shown below.

Lines 15 thru 22 may look peculiar since I am providing links to all 4 sorts of payment items. This saves me from having a different loader step for each payment type and works because the fields for the lines other than those for the current payment type are set to null in the earlier script step. ie if this is a cash payment then oIDchq, oTIchq, oIDeft, oTIeft, oIDccrd, and oITccrd are all null.

Looking at the act.customerAccountPayment archetype, the only possibly relevant thing I have omitted is the allocation, but I don't think this is relevant.

I suspect that I need to (for cash payments), add two lines having the Map To's <actRelationship.tillBalanceItem>source and <actRelationship.tillBalanceItem>target.  The value for the second (the target) is easy -  just like line 15 above.  However what to use for the source is not obvious - at least to me.  It needs to be <act.tillBalance>$value - but what to use for the  $value?

I have the link to the till (see line 14) - but I cannot understand what I need to use to reference the tillBalance for the till I am using.

Regards, Tim