How to add "If" and "Else" conditional formula in PLD at SAP Business One ?

-
It is effective to maintain SAP Business One PLDs for print layout requirements. Sometimes, companies require complex scenarios match to the PLDs and get the printouts.

Limitation in PLD

There is no "If" and "Else" conditional formula in SAP Business One at Print Layout Designer. But, it is an essential conditional statement to display some values in the fields according to the conditions.
Thereby, we would like to introduce a workaround method to apply the "If "condition at PLD by overcoming such limitations.

What is the scenario?

Our scenario is, display the "Ship To" and "Deliver To" in the purchase order PLD according to the vendor type like "Foreign Vendor" and "Local Vendor".
If the PO has been raised for Local Vendor, the "Delivery To" statement has to be mentioned in the layout, else Foreign Vendor, the "Ship To" statement has to be mentioned in the layout.

Solution

We would create for new fields in the PLD as F_227 as a DB field is showing the OCRG's Group Name, F_228 as a Formula field is showing the value through the formula as F_227=='Local Vendor', F_229 as a Formula field is showing the value through the formula as F_227=='Foreign Vendor'. 

The result would be if the PO has been raised for Local Vendor, then F_228 has shown 1 and F_229 has shown 0 if the PO has been raised for Foreign Vendor, then F_228 has shown 0 and F_229 has shown 1.

Thereby, we could use, another field to show "Deliver To" by linking the F_228 field and "Ship To" by linking the F_229 field. 
How to add "If" and "Else" conditional formula in PLD at SAP Business One



Comments

Post a Comment

Popular posts from this blog

How to clearly identify the "Cancellation" document in SAP Business One

-
Image
How to clearly identify the "Cancellation" document in SAP Business One When raising a cancellation document against an AR or AP document, it shows the status as closed with "Cancellation" in the new cancellation document, and the canceled document's status shows as Canceled. But, when you write a query report in SAP Business One how could you significantly identify the canceled document and cancellation document against the right one. Referring one by one in each document is a difficult one and there should be the easiest way to identify the cancellation. What would be the best practice? If you plan to implement an SAP B1 with number series, it is good to configure a separate number series for the Cancellation Document. Unless those cancellation documents will get the exiting number series and it is difficult to find which document would be canceled with the number series. There is an option in the Document Numbering - Setup called "Cancellation" und...
Read more

How to Create the PKCS12 file and including SSL Certificate and Key through OpenSSL

-
Image
When you are requiring to enable a secured connection for your web application or device that you need to have a PKCS12 file in order to encrypt and authenticate the data. Especially, in SAP Business One is required to have a PKCS12 certificate for its services such as SLD, Browser Access and Service Layer, etc. Refer to the below steps to generate .p12 file for SAP Business One installation.  Before moving to dive, let's clear doubts in major areas. What protocols are used to facilitate secured communication? Mainly there are two protocols such as SSL "Secure Sockets Layer" and TLS "Transport Layer Security" that are used to secure the connection and it enables data encryption, integrity, and authentication. How do you identify that data has not been read and has not been changed by someone? To overcome these problems, the SSL/TLS uses data encryption and digital signature to identify the sender and make sure data has not been changed. The encrypted data can...
Read more