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

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

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

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. 

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