Report Designer - Remittance Advice

[aylingmj]

I am trying to get Extra.Ref variable to print on remittances not Ref to show the invoice number. I have inserted the variable but the value is not printing even though there is something in this field on the supplier's information.

Please help!

[brucedenney]

I just did it in V17 and it works fine.

Note that the extra ref is the extra ref at the time you made the payment, if you edit it after the event it will not change.

[Jen]

Hi,
I am trying to get the Ex Ref field to print out on the supplier remittance in order to show the individual supplier invoice numbers which are included in the payment. I know this has been raised before and it was suggested ticking the the 'list payment receipt by split' in bank defaults would do the trick, however I am still struggling to make it work? Obviously doing something wrong and it is driving me insane! can anyone help?

(I am using SAGE 50 Accounts Professional 2008 Version14.0.12.153)

[brucedenney]

I just did it in V14 and it works fine.

Note: the extra ref is the extra ref at the time you made the payment, if you edit it after the event it will not change.

[angmc]

Hi

I was just wondering if this issue ever got resolved as I'm having the same problem. The Extra Ref just won't show up on the remittance. I can insert the variable in report designer and it all looks ok but it doesn't show up on the remittance. As a test I added various other fields on the remittance and they show up fine, it's just the Extra Ref that doesn't.

[brucedenney]

As far as I know, there never was a problem.

If you want to upload your layout, I will take a look at it.

[aslaction]

Hi. I am having this same problem! On v2011. I am using the standard Sage layout (REMITA4.layout) but just need to show the EXTRA_REF instead of the INV_REF. I can add the field onto the layout but it doesn't show on the preview.

[brucedenney]

If you want to upload your layout, I will take a look at it.

Extra ref is on the Audit Split so, in theory, you could have 2 splits being paid by one remittance so there would be potentially 2 different extra refs.

how had you planned to deal with that?

[aslaction]

Hi

All purchase invoices are batch entered as one line per invoice so we never have more than one reference. If we did, then we would use the same reference on each line for that invoice.

Your help is very much appreciated.

[brucedenney]

Whether you do or do not have different values is not the issue.

The point is that you have to link the remittance advice line to the Audit Trail header and then to the splits.

This will give you multiple repeating lines for each remittance, each line showing the split with it's extra ref.

You need to structure the report to have a footer for each remittance advice and put everything in the footer, the extra reference will be the one form the last split (I guess you could do this as a header in which case it would be the first split)