Best practise to get country name and unit name

Andre Seiss

September 20, 2023 08:08

Hi,

we're currently reworking all our printouts and try to replace LD.QueryData database statements wherever possible. We used it also in the past to get the full country names and unit display names.

Is there any best practise or standard function to get the full names? E.g. Document("DocumentShipToAddress.Country" returns only "DE" but I need "Germany" from OCRY table?

Same for "B1_Data.Document.WeightUnit" it returns only the code as number but not the unit display name like KG, G or similar.

How do you deal with this topic?

Thanks
André

0

• 

  Lothar Hasenkämper

  September 20, 2023 08:28

  Hi Andre,

  it depends a little bit depending on the place.

  If you just need the countrys in Header it could be okay to use LD.QueryData.

  All informations according to Lines make more sense to get by query, while starting the layout. e.g. 100 lines in Doc x 2 (DoublePass) means that 1 query in lines is fired 200 times.

  You can have a look here:

  https://helpdesk.coresystems.ch/hc/en-us/community/posts/8852027260946-ItemCode-an-Layout-Abfrage-%C3%BCbergeben 

  It is similar to your needs

  regards Lothar

   

  0

Please sign in to leave a comment.