We’ve developed some resources to help you work effectively from
home during COVID-19 Click to learn more
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!
-> Addressformat table check the layout - type 8196 is billing, 8197 is shipping address
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?
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.
Tried quite a few alternatives, but I see no change in the screen;
update crm7.ADDRESSFORMAT set address2_line =1 where addressformat_id=469update crm7.ADDRESSFORMAT set address2_line =1 where addressformat_id=468update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=469update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=468
update crm7.ADDRESSFORMAT set address2_line =4 where addressformat_id=469update crm7.ADDRESSFORMAT set address2_line =4 where addressformat_id=468update crm7.ADDRESSFORMAT set address2_subpos=4 where addressformat_id=469update 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=468update crm7.ADDRESSFORMAT set address2_leadtext=14000 where addressformat_id=469update crm7.ADDRESSFORMAT set address2_length=80 where addressformat_id=468update crm7.ADDRESSFORMAT set address2_length=80 where addressformat_id=469
What am I doing wrong?
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?
I can see now that bug 52974 has been created for this.
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
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;
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.
What about web? They are using web.
This also seems to be present in SO Online
Any idea when this bug will be fixed?
LukkDette nettstedet bruker informasjonskapsler. SuperOffice bruker informasjonskapsler hovedsaklig for å overvåke trafikken på nettstedet, og for å forbedre innholdet. Fortsett å bruke nettstedet hvis du samtykker til at vi bruker informasjonskapsler. Les mer: Personvernerklæring