https://blogs.sap.com/2015/05/29/updating-exchange-rates-automatically-in-sap-business-one/

 Using DI API:

 https://blogs.sap.com/2015/05/29/updating-exchange-rates-automatically-in-sap-business-one/

Using B1IF:

https://blogs.sap.com/2015/06/23/how-to-import-exchange-rates-using-b1if/

Using Service Layer and HANAXS:

https://blogs.sap.com/2018/08/27/update-sap-b1-rates-using-hana-xs-and-servicelayer/

How to check automatic exchange rate difference posting in SAP Business One

 https://blogs.sap.com/2017/04/20/automatic-journal-transactions-for-exchange-rate-differences/?preview_id=478064

How does SAP Business One handle Exchange Rate Differences

 

https://blogs.sap.com/2020/07/01/how-does-sap-business-one-handle-exchange-rate-differences/

TEST GIF

 

SAP B1 HANA Crystal Report Connection Setup

 

SAP HANA Crystal Report setup required  ODBC to Setup.

ODBC:

ODBC RDO Connection String

DRIVER={B1CRHPROXY};SERVERNODE=Server IP:30013;DATABASE=SBODEMOAU;databaseName=HDB

SAP Business one G/L Account Determination and Journal Entries [Inventory]

 G/ L account Determination:

https://drive.google.com/file/d/1DCnxZ95_74VAYuMPM31IhImK3iqd3kTr/view?usp=sharing

SAP business one Line Remarks in Journal Entry Remarks

 one of the biggest challenge every SAP  B1 Client ask . the Line Remarks (Description) to updated in

 Journal Entry .  

there is a solution available using SAP POST Transaction Notification  . 

IF @transaction_type IN ('A') AND @object_type = '13'

begin 

 UPDATE JDT1 

 SET JDT1.LineMemo=(Select INV1.Dscription from INV1  

                     inner join OINV ON INV1.DocEntry=OINV.DocEntry

Where INV1.AcctCode=JDT1.Account and INV1.LineNum=JDT1.DocLine and 

OINV.DocEntry=@list_of_cols_val_tab_del)

 FROM JDT1

 INNER JOIN OJDT ON OJDT.TransId=JDT1.TransId

 inner join OINV ON OINV.TransId=OJDT.TransId 

 inner join INV1 ON INV1.DocEntry=OINV.DocEntry

 

 Where OINV.DocEntry=@list_of_cols_val_tab_del

end

after executing the POST Transaction Notification the Journal Entry on each Add will be updated automatically with description from the Invoice .

Journal Entry Preview after Add: 

HANA Administration Administration and Troubleshooting

 

https://docs.google.com/presentation/d/1os2mp_YQ4r4Cl07xfsqa04CGrdNrhDUl/edit?usp=sharing&ouid=110438426383198798957&rtpof=true&sd=true

SUSE Linux Firewall [Status, Enable, Disable] Command

Firewall Status checking

sudo firewall-cmd --stat

Start and Stop Firewall Service

sudo systemctl stop firewalld
sudo systemctl start firewalld







Disable and Enable Firewall Service

sudo systemctl disable firewalld
sudo systemctl enable firewalld

SAP Business one Marketing document Unit Price unable to change

 

Scenario : the user  is fully authorize to create Purchase or any Marketing document but unable to edit the price .

Solution : The issue is due General Authorization .  check the below setting in General Authorization

  1. Change Row Amount

  

1051254 - Firewall or antivirus blocking SAP Business One components

Please find the original document at https://launchpad.support.sap.com/#/notes/ 1051254

 Symptom

One of the following may not work properly:

SAP Business One license service

•SBO Mailer

•DI API

•DI service

•integration framework for small and midsize enterprises (B1i)

Cause

A user´s operating system, firewall, or antivirus program may be blocking the ODBC/COM/UDP or TCP IP communication protocols, causing SAP Business One components that use these protocols to fail.

License Service:

This communication requires an unblocked networking infrastructure because in addition to the well-known and configurable ports, it uses some dynamically assigned TCP IP ports which cannot be changed. These dynamic ports change each time the license service is started. In the advanced network infrastructure, it is difficult to allow some exceptions for randomly assigned TCP IP ports for the license service.

Because the SAP Business One component requires a direct communication with the license service (B1 Client, DI API, DI service, B1i, etc.), no network limitation should be set.

SBO Mailer:

The main policy here is to allow the outgoing communication for the TCP IP port of the SMTP server, which has been defined for the SBO mailer configuration.

Integration Framework:

If B1i does not require any interaction with the B1 license service, then the network can be easily configured because B1i uses static TCP IP ports for communication (for example, 8080, 8443, 8005, 2099, and so on). On the other hand, they are changeable if they can be configured according to the network and user requirements.

Solution

Ensure that your operating system, firewall, or antivirus program is not blocking any of these protocols

https://drive.google.com/file/d/1mDqqZ_FsHj8MtievaAegR42AB5JGf54S/view?usp=sharing

To generate this document, first define the numbering series in the Administration module [SAP Notes Number - 549371]

Symptom

You open a marketing document module and you receive the following error message:

 To generate this document, first define the numbering series in the Administration module

Expected Behavior:

The document is generated successfully.

Actual Behavior:

You receive error message: To generate this document, first define the numbering series in the Administration module

Solution

In Administration -> System Initialization -> Document Numbering, double-click the relevant document type and verify whether one of the following applies:

1. The Default Series is locked.
2. The Default Series has reached the Last Number (The Next Number is higher than the Last Number).

If the error occurs when you are adding the document, please also verify the Journal Entry Series.

Help> Restore File Numbering Series

SAP Notes Number: 549371

https://drive.google.com/file/d/19Vg5wLtDRgArVigqgaALH74CNRN7PJHL/view?usp=sharing

Date Function is SAP HANA

 

Calculate days between two Dates

SELECT DAYS_BETWEEN (TO_DATE ('2009-12-05', 'YYYY-MM-DD'), TO_DATE('2010-01-05', 'YYYY-MM-DD')) "days between" FROM DUMMY;

calculate days between dates and current date

SELECT
ORDR."DocNum",
ORDR."CardCode",
ORDR."CardName",
ORDR."DocDate",
ORDR."DocStatus",
DAYS_BETWEEN (TO_DATE (ORDR."DocDate"), TO_DATE(CURRENT_DATE)) "days between"
 
FROM ORDR
where DAYS_BETWEEN (TO_DATE (ORDR."DocDate"), TO_DATE(CURRENT_DATE))>=180  and ORDR."DocStatus"='O'

Calculate Months between two Dates

SELECT MONTHS_BETWEEN(TO_DATE ('2003-01-01'), TO_DATE('2003-03-14')) "months_between" FROM DUMMY;