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

-

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" under that selection box, you can put a tick. Then it will be used to assign that particular number series for the "Cancellation" document.

How to set a number series for Cancellation SAP Business One

Now you can use this number series to uniquely identify the cancellation documents in the SAP Business One reports.

How do you identify the Cancellation document in the Query or DB Tables?

When referring to the Document Table e.g OINV, you can see the field "CANCELED", if it is a cancellation document, the letter in this field is "C". If it is a based document used to cancel, then the letter in this field is "Y" and if the document is not canceled then the letter in this field is "N".

By referring to this letter convention, you can easily identify which document would be canceled and what would be the base cancellation document.

Caceled document in SAP Business One

The important point is to use the best practice when you implement the SAP Business One ERP system because it is quite helpful when developing the reports and layouts.

Comments

Post a Comment

Popular posts from this blog

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