SageForum for UK versions of Sage 50- Help and support.

Sage Line 50 V2007 with Windows XP

Invoices & Sales Orders have been set up with the address format as
Name
Fields 1 to 5 using C_Address
Country Name

However we have a large number of customers overseas, who only use Fields 1 & 2, or Fields 1,2 & 3. so the unused lines are blank therefore i need to move the country name up

The problem is when field 3 is blank on one address, I can get the country name to appear , but the next company may use field 3 for part of the address, so the country name also prints on field 3.

I have tried
Invoice_C.Address_3 =""? Country_Code.Name or
Ditto ( : ) Ditto or
Ditto ( Then ) Ditto

have also placed place the Country_Code.Name field on top, with conditional formatting formula of Invoice.C.Address_3 = " " and suppress the printing This does not work,

Am i missing something
Any chance someone can help

I have not tried this but...

Try creating two field for each line of the address

the first line is just the caddress3 field the second is the country name field set it to have printing suppressed, put a filter on the country name to un-suppress printing if caddress3 is empty
next
caddress4 and country name, set it to have printing suppressed, put a filter on the country name to un-suppress printing if caddress4 is empty and caddress3 is not empty (so to print caddress3 must have something in it and caddress4 must not)

do the same sort of thing for the rest of the address