Of course this feature is only to query data and not to update or post new data as you know SAP Business One database cannot be modified via SQL queries and only via the provided APIs (be it DI-API or Service Layer). 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. Try replacing Inner join with Left join like this. This looks like an issue with Join in queries. Full details are available in the document Working with SAP Business One Service Layer “4 SQL Query” chapter.Ĭheck also this great video to see it in action! Query returning no data in SAP Business One using Table Relationship. Let me explain with some samples how you can easily use this feature. This is a great feature that I’m happy to share as I’m sure you will appreciate!!! As of SAP Business One 10.0 FP 2011 you can directly create SQL queries via Service Layer and run them directly without previously requiring the creation of a view.
0 Comments
Leave a Reply. |