Stack Overflow
Stack Overflow

Questions tagged [sapb1]

SAP Business One (B1) is enterprise resource planning (ERP) software designed for small and medium-sized enterprises, manufactured by SAP SE.

SAP Business One (B1) is enterprise resource planning (ERP) software designed for small and medium-sized enterprises, manufactured by SAP SE.

SAP Business One runs on Microsoft SQL-Server or SAP HANA database engines.

Related tags

501 questions
-2
votes
3 answers

How to implement a multiple criteria in Where clause?

I am wanting to see ONLY the documents where 3 criteria's are met but the 3 criteria's have multiple criteria's. Here is my code: SELECT t0.DocNum FROM dbo.OIPF t0 inner join IPF2 t1 ON t0.DocEntry = t1.DocEntry inner join IPF1 t2 on t0.DocEntry…
KTate
  • 57
  • 1
  • 7
-2
votes
1 answer

Test Driven Development with very large Mock

I am working for a consulting company that develops a lot of Add-Ons for SAP Business One using .NET. I want to introduce TDD (or at least some good unit testing practices) to the company to increase code quality. Here's the problem. SAP provides a…
Carlos Rodriguez
  • 2,190
  • 2
  • 18
  • 29
-2
votes
2 answers

Creating a WCF/WebAPI Service for SAP B1 for Multiple Users

We have a self made Sales Tool which is developed to use SAP Business One System through the DI Server. We have like 40 employees which are logged in through remote desktop to the same machine with their own users. All users have a desktop shortcut…
darkdog
  • 3,805
  • 7
  • 37
  • 47
-3
votes
2 answers

trying to add a selection to the following query

I nee to add a user selected date (DocDate) to the following query SELECT DocNum, CardCode, CardName FROM ORDR WHERE DOCENTRY NOT IN( select DISTINCT(T0.DOCENTRY) from ORDR T0 JOIN RDR1 T1 ON T0.DOCENTRY = T1.DOCENTRY LEFT JOIN OITM T2 ON…
Jon Paul Kearns
  • 1
-3
votes
1 answer

I have NULL results for thousands of rows. How do I exclude those from populating when they don't exist?

I have a code to look at a sales employee of mine. He was recently hired to create growth on extinct customers. So over the 1,000+ customers we have in the dbase, he only will effect 100. So there have been a lot of rows generated where his value…
KTate
  • 57
  • 1
  • 7
-5
votes
2 answers

SQL query for subtracting values from columns and add it to same row

As you can see, the Menge column is decreasing its value for every row, subtracting the Reserviert value from the previous row. Can anybody suggest how to write this type of query in SQL Server?
user9273506
1 2 3
…
33
34