Layout Designer

[andyhoyland]

Hi there.

Just wanting to ask what will probably turn out to be a very basic question...

I'm wanting to edit the layout of the remittance advice that SAGE sends out for me. I am in the SAGE Report Designer and want to know how to display the external reference into the layout.

At the moment it displays our reference number (called by INV_REF) but I want to display the reference that the supplier has given (something along the lines of EXT_REF?!?!)

Thanks muchly for any suggestions.
Regards
Andy.
PS I'm using Sage Line 50 13.0 something or other...

[brucedenney]

I think the field you want is in the REMITTANCE Table and is called EXTRA_REF

[andyhoyland]

Thanks Bruce.

Sorry it's taken me SO long to reply to this... I tried the EXTRA_REF but that just comes up blank even though I have entered an external reference when I put the invoice into Sage.

Any other clues?!

Thanks again
Andy.
PS Like the new layout! Does that show how long it is since I last logged on?!

[brucedenney]

Tried it out and it works just fine for me!

see attached sample

Note: The extra ref has to be on the item BEFORE you pay it as the Extra Ref field in the remittance table is filled in at the moment of payment. If you add /alter it after the payment it will make no change to the remittance

[andyhoyland]

Hi again Bruce.

I had a look at yours and in the Layout Designer I see the same expression as I was trying to use. However, when I try to run the remittance using the layout you sent over I get an error message "ERROR [42SO2] Table Not Found"

I guess I'm just doing something wrong when saving it... or something equally silly...

But the expression is exactly the same as I was using. And I enter the extra ref when I first raise the invoice (don't know if that is the right term - but it's when I first put in any details about the invoice we have been sent and I am wanting to pay)

Thanks muchly for your help. I'll keep trying!

Andy.

[brucedenney]

Sorry, I made it using V2009 (15)

Here is the same thing in V13, works fine for me!

[andyhoyland]

Thanks for that Bruce.

I can now use that file but it's still not working so I guess I must be doing something wrong before it gets to the Bank Remittance Print stage.

So - I get given an invoice for payment, I click on "Batch Invoice" and enter the information as requested, putting the account, the date, our ref (ref), their ref (Ex Ref) and so on into the spaces as required.

I save that.

Then I go and pay the supplier using the Supplier Payment option. I fill in all available boxes here too.

Then I go to Bank Remittance, select the correct layout and nothing appears where the EXTRA.REF should be showing...

What am I doing wrong?! Am I missing something really basic here? Should the above do what I want?

Cheers
Andy

[brucedenney]

I don't think it is anything you are doing, sounds fine to me.

Have you applied all the patches to V13? Perhaps there was a bug in one of the versions and it is fixed in my fully patched version?

What is the version number (in full eg I am on 13.02.30.0144)

Maybe try it with the demo data.

[elainea13]

I had the problem with the 'blank' ex ref on the remittances a few months ago.

It drove me crazy and I tried all sorts. What worked for me is making sure that in bank defaults the 'list payment receipt by split' is ticked.

When I ensured that this box was ticked the ex ref printed every time. I seem to remember that it only works for new invoices that you post not the old ones.

It is worth a try!

[andyhoyland]

Thanks guys!

Bruce - I tried it with the test data and had the same issue.

Elaine - that worked!

Well - it works on my test install that I made to see if my computer at the office was being funny - I'll try it at work and see!

Thank you for your help!
Andy.