Posts

Showing posts from May, 2020

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

Image
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 n...

What if the reverse transaction couldn't be posted in the relevant month and required to be posted next month in SAP Business One?

Image
Sometimes users don't post the entries on time in the ERP system and they need to post it later. As a result, there may be an inconvenience situation with system configuration because the system has been designed to run on the standardized process. When does it experience in SAP Business One ?  When you have posted a reverse journal entry by using the reverse transaction option for the previous month, and you forgot to reverse it on the relevant month. Now, you won't post this revers entry on a current month, because your due date in the posting period is less than the current date.  What caused? The due date must be greater than the current date unless the system doesn't allow to post the reverse entry for the current month or next month. The SAP Business One system gives an error as "Date deviates from the permissible range [Journal Entry - Due Date] [Message 173 - 11]" You are now on 13/05/2020 and you posted an entry for 31/03/2020 and is required to be rever...

How to maintain your psychological well-being during the #coronavirus crisis

Image
We planned to add an important thing to share during this difficult time, most of the system users and businesses suffer from challenges because of the COVID-19 pandemic all over the world. What feels at this time? What should you do? These days, you have faced some challenges and difficulties due to the unprecedented coronavirus crisis. Some of them had to change their usual life because of social isolation, quarantine, and social distancing. This might affect you and your family's psychological well-being and it is not a familiar situation. As per the situation, you may feel stress and anxiety when you are doing the office works via online media. Your children may feel stress and anxiety when they are staying home and doing studies via distance learning methods.  How to reduce your stress and anxiety by using simple steps? Refer and get reliable information from reliable sources, don't waste your time browsing many gossips sites. It is important to minimize the time spent con...

How to take a backdated BP aging report in SAP Business One

Image
BP aging reports play a major role in most ERP systems. Thereby some instances, it requires getting the backdated BP aging reports such as Customer Aging and Supplier Aging. In SAP Business One , users get challenges to get the right report. Real-time requirement  When you are dealing with the annual accounts preparation process, you may take a backdated BP aging report for the previous accounting period. You must correctly select the selection criteria because the report must tally with the trial balance.  Solution You can choose this path to generate the report; Financials>Financial Reports>Accounting>Aging You must select the following options; Display Vendors with zero balance Display Reconciled Transactions Unless you won't have the right report because some of the BPs have been already reconciled and no balance on the current date. 

Popular posts from this blog

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

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

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