ShipTo Adresse

Tetiana Dedovych

February 05, 2024 11:04

Good day,

one of our customer wants to implement following: they put all the Adress IDs in SAP B1 with one * at the beginning. F.e.: *Berlin. The ShipToCode appears then as well with the *. 
For the delivery addresses that have other Adress ID, they use normal name, f.e. Firma XYZ.
They have the following wish: if the adress ID has *, then the CardName should be printed in other cases the ShipToCode.

Is it possible to implement? May you advise what formulas I can use here?

Thank you!

Best regards,
Tetiana

0

• 

  Partnermanagement Team

  February 05, 2024 14:48

  Hi dearest Tetiana,
  
  Many thanks for your comment.
  Starting from 2024 we no longer do consulting services and therefore can not work on a implementation with you.
  
  Thank you for your understanding and best of luck.
  
  Kindest regards,
  
  Coresystems

  0
• 

  Daniel Ebi

  February 06, 2024 09:45

  Hello,
  
  try something like that:

  If Left(KopfLinks("ShipToCode"), 1) = "*" Then
   shipToAdr = KopfLinks("CardName")
  Else
   shipToAdr = KopfLinks("ShipToCode")
  End If
  
  Kind regards
  
  Daniel

  0
• 

  S. Dietze

  March 07, 2024 18:14

  Hello. Did you find a solution for your request?

  I would not validate the condition this way, but recommend use some clear and obvious setting. Use an UDF on Document header with valid values: print CardName, print ShipToCode. Make it Required and without default value, so it must be set expicitly per Document.
  Why : Do not assume all users are setting the prefix on the address id correctly always, they do not. They will forget it or do not know or whatever. 
  
  Then evaluate this UDF. Everyone can see and understand in the SAP client why the print shows this or that. That idea using asterisk prefix is prone to user error and it is nowhere recognizable without much effort and will lead into trouble sooner or later. 
  Regards

  0
• 

  Stefan Ressel

  April 09, 2024 07:39

  Hi Tetiana,

  based on years of experience, I cannot recommend this route. I would recommend that the customer always use the "Address2" field for the business partner name.
  
  On the one hand, the “ID” field can be changed and, on the other hand, this character should not be used for master data.

  In addition, the ID should clearly show the user which address they select, e.g. DE-12345 Berlin - Meier AG - Plant 1. The address is then always printed from the data in table RDR12. 
  
  A little tip: Block the entry of the address via the window and only allow entry in the document via the mask.

  Kind regards
  Stefan

  0

Please sign in to leave a comment.