Business Articles - Page 121 of 71

Information Technology Infrastructure Library (ITIL) is the framework that is designed to standardize the planning, selection, and delivery of IT services to a business. The goal of ITIL is to improve efficiency and also achieve predictable goals or targets. An ITIL enables an IT professional to be a business service partner, not just back-end support.ITIL Foundation ExaminationIt is a closed book examination.It consists of 40 questions.Each question has multiple choices.One mark is allotted for the correct answer.The duration of the exam is one hour.One has to score 65% of the marks to pass the examination i.e minimum 26 questions must ... Read More

It would be easy to guess if you have shared the full query. It seems you have not defined #temp_table. You might need to define temp table as global but it could sum up to other issues.

Yes, it is feasible and I have done something similar in one of my previous projects. But you need to be little clear on what you need to export. There are two options regarding the content of export:Raw Data ( it is basically the query)Formatted Data ( it is your report)I will provide you help for both. In case, if you are looking for just exporting the raw data then you can the following call and you should be able to fetch the raw data.http://:6405/biprws/raylight/v1/documents//dataproviders//flows/Also as will require the response in CSV, set the ACCEPT to ‘text/plain’ so that the ... Read More

The thumb rule goes like this, if you instantiate a DI API object, you have to release it. if you don't release it explicitly, it will result in memory leaks.You can use a ReleaseComObject method to release the object memory. In case if you try to release a null object, it will throw an exception.So, it will be better to have a null check before you try to release the object.Sample snippet:if (obj != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

You can make use of SP_TransactionNotification, which is one of the most common way of receiving notification of data-driven events. With the use of SP_TransactionNotification, you can edit error code returned by Transaction notification, and also prevent transaction to committed.This shows how to prevent a purchase order from adding when the base document is not provided. You can make use of SBO_SP_TransactionNotification for Screen Painter forms in SBO to avoid null values.

I would suggest using recordset with DI API −SAPbobsCOM.Recordset rs = ((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset); rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal    FROM OPOR ORDER BY DocDate ASC"); while (!rs.EoF) {    int DocEntry = rs.Fields.Item("DocEntry").Value;    //OR    DocEntry = rs.Fields.Item(0).Value;    rs.MoveNext(); }

The answer lies within the exception message itself. The connection string that you are using to connect to the Business object server is wrongly configured. Check for each parameter, you will find something must be wrong and hence why you are receiving this error message.

In SAP Business One, SBO-Common is only used in functionality handling or following your company database. Normal day to day business functions happens entirely in the company database. You can create a new set of sample database SBO-COMMON by reinstalling SAP B1 server. SBO-Common database holds this information − DB List (DB's which having SAP DB Structures) DB Details like Version, Upgrade Details License Details For more details about SBO-COMMON database, you can refer below link − https://archive.sap.com/discussions/thread/1447063

This looks like an issue with Join in queries. Try replacing Inner join with Left join like this. I ran this query and it is working fine:select T0.DocNum as 'Payment Number', T0.DocDate 'Payment Date', T0.CardCode, T0.CardName 'Customer Name', T1.BankCode 'Bankcode', T3.BankName 'Bank Name', T2.Phone1 , T0.CreditSum, T0.CashSum, T0.TrsfrSum, t0.CheckSum, t1.CheckNum as 'Check Number', t1.DueDate as 'check date', t6.VoucherNum as 'Voucher Number', t0.TrsfrRef as 'Transfer No', t0.TrsfrDate AS 'Transfer Date', ousr.USER_code as 'user code', T5.DocNum, t11.U_P_BuildingName as 'Building Name', CASE when T5.DocNum is null then 'On Account' else 'Paid For Invoice' END AS 'Payment Status', CASE when T5.DocStatus = 'O' then ... Read More

Try deleting all the files under this location - %UserProfile%\AppData\Local\SAP\SAP Business One\Log\DIAPIWhen you delete all files, it will speed up the connection process.