We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Quote - is it possible to add lines in delivery address?

Hi!

8.0 SR4/8.0 SR5

Is it possible to add new fields (eg. address line 2) into delivery address?

If yes - any tips on how? Thanks!

Anne Lene

RE: Quote - is it possible to add lines in delivery address?

-> Addressformat table check the layout - type 8196 is billing, 8197 is shipping address 

Av: Margrethe Romnes 5. jul 2017

RE: Quote - is it possible to add lines in delivery address?

Hi!

Thanks. Looked into the table but I do not get where to set the right format to be used in the screen.

Country is set to Norway and country format used is German. But where do I set what format to be used in the Quote screen?

Thanks :-)

Av: Anne Lene Solheim Lilleberg 5. jul 2017

RE: Quote - is it possible to add lines in delivery address?

select * from crm7.addressformat where name like 'german' and atype_idx in (8196, 8197)

 

Notice it says Address1_line = 1, zip_line = 2 subpos =1, city_line = 2 but subpos = 2 and so on. It's telling the client where to paint the field, all fields with 0 are ignored.

Av: Margrethe Romnes 5. jul 2017

RE: Quote - is it possible to add lines in delivery address?

Hi!

Tried quite a few alternatives, but I see no change in the screen;

update crm7.ADDRESSFORMAT set address2_line =1 where addressformat_id=469
update crm7.ADDRESSFORMAT set address2_line =1 where addressformat_id=468
update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=469
update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=468


update crm7.ADDRESSFORMAT set address2_line =4 where addressformat_id=469
update crm7.ADDRESSFORMAT set address2_line =4 where addressformat_id=468
update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=469
update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=468

Updated these also to see if that did anything;
update crm7.ADDRESSFORMAT set address2_leadtext=14001 where addressformat_id=468
update crm7.ADDRESSFORMAT set address2_leadtext=14000 where addressformat_id=469
update crm7.ADDRESSFORMAT set address2_length=80 where addressformat_id=468
update crm7.ADDRESSFORMAT set address2_length=80 where addressformat_id=469

What am I doing wrong?

Thanks :-)

Av: Anne Lene Solheim Lilleberg 6. jul 2017

RE: Quote - is it possible to add lines in delivery address?

Hi!

Tried to change settings in the table to the same as for a country using "other" addressformat, but no change is visible. Also tried to set 0 for the "other" country settings, but no change is visible.

Is it really possible to change the setting?

Thanks!

Av: Anne Lene Solheim Lilleberg 8. aug 2017

RE: Quote - is it possible to add lines in delivery address?

I can see now that bug 52974 has been created for this.

Av: Thomas Bergmann 17. aug 2017

RE: Quote - is it possible to add lines in delivery address?

Quote.. it's been a while...

Not sure I understand this. Looking at our code, we seem to have bend over backwards to tweak our AddressView to show a single address field only for the Quote system's Billing & Shipment addresses...
/conrad

Av: Conrad Weyns 17. aug 2017

RE: Quote - is it possible to add lines in delivery address?

Hi Conrad!


Tried to hide and add fields, but no changes is done. There is a bug related to this; https://community.superoffice.com/en/bugs-wishes/Product-Issue/?bid=52974

I looked at another address format and there you may see other lines;

Av: Anne Lene Solheim Lilleberg 18. aug 2017

RE: Quote - is it possible to add lines in delivery address?

This does work for the Windows client, but after making the changes in the Addressformat table, you need to delete the Address cache.

To do this, navigate to the SuperOffice SOCache folder.
It should recide here: '%localappdata%\SuperOffice\SOCache'. In this folder, delete the file addressformat.bin.

Restart the Windows client, and the changes should be visible.

Per-Arne

Av: Per-Arne Lauritzen 18. aug 2017

RE: Quote - is it possible to add lines in delivery address?

What about web? They are using web.

 

Anne Lene

Av: Anne Lene Solheim Lilleberg 18. aug 2017

RE: Quote - is it possible to add lines in delivery address?

This also seems to be present in SO Online

Any idea when this bug will be fixed?

Av: Dennis Aagaard Mortensgaard 1. nov 2018