Updating Account Balance Crystal layout, to Work with Vendors B1UP (2019.04 or higher)

if you have an old out of the box Print and delivery crystal layout from before you can either update to our newest crystal layout
or change your existing Crystal Layout following the steps below, after which it will work with vendors.

1. Update the business patner SQL to include the CardType field

   SELECT 
   T0.CardCode,
   T0.CardName,
   T0.Address,
   T0.ZipCode,
   T0.City,
   T0.Country,
   T0.LangCode,
   T0.Currency,
   T0.CardType
   FROM OCRD T0 
   WHERE T0.CardCode = '{?CardCode}'

2.   Update the formula @Title_CustomerNo so the correct text is shown if a vendor is shown
   

   Switch(
   {BusinessPartner.CardType}='C',
   switch(
    {@X_Language} = 'DK', 'Kunde nr............................................................',
    {@X_Language} = 'NO', 'Kunde nr............................................................',
    {@X_Language} = 'DE', 'Kundennummer...........................................................',
    {@X_Language} = 'ES', 'Número de cuenta...........................................................',
    {@X_Language} = 'FI', 'Asiakasnro...........................................................',
    {@X_Language} = 'NL', 'Klantnr............................................................',
    {@X_Language} = 'FR', 'Numéro de client...........................................................',
    True, 'Customer No............................................................' //Default English
   ),
   {BusinessPartner.CardType}='S',
   switch(
    {@X_Language} = 'DK', 'Leverandør nr............................................................',
    {@X_Language} = 'NO', 'Leverandør nr............................................................',
    {@X_Language} = 'DE', 'Verkäufer Nr...........................................................',
    {@X_Language} = 'ES', 'Vendedor no...........................................................',
    {@X_Language} = 'FI', 'Myyjä nro...........................................................',
    {@X_Language} = 'NL', 'Leverancier Nr............................................................',
    {@X_Language} = 'FR', 'No vendeur...........................................................',
    True, 'Vendor No............................................................' //Default English
   )
   )

3. Suppress the fields @Title_PaymentDatails and @PaymentDetails if CardType is a supplier 
   

 {BusinessPartner.CardType}='S'