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: