wojciech_domanski
Participant
Member since ‎05-06-2015

User Statistics

  • 61 Posts
  • 2 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hi experts When open on landed cost relationship map you can see (attachment): Invoice (Goods), Landed cost and Invoice (Transport). Can anyone help me to build simple query please: T0.[DocNum] (Invoice transport), T1.[DocNum] (landed cos...
Hi, How can I link in sql query landed cost with AP Invoice (Service) – see attachment. AP Invoice (Items) I can do this way but it doesn’t work with service invoice SELECT T0.[DocNum], T0.[CardName], T0.[DocDate], T1.[DocNum] FROM OPCH T0 INN...
Hi, I have setup failover system for SAP Buissnes One 9.2. The system is in cloud so the hardware key for licence is not permanent. I have access to SAP license key portal. What key should I generate for failover system? Is there any dedicated for...
Hi, I would like to ask. How to write a query (SAP B1) to get the same result as below and avoid using “UNION ALL”. The reason is that yellow arrow link does not work properly when the query contains “UNION ALL”:SELECT T0.[DocNum], T0.[DocDate], T0.[...
Hello, Finally with great difficulty I added my first stored procedure to SAPB1. I used MSSQL Management Sudio and by expanding DB\ Stored Procedures I located SBO_SP_TransactionNotification SP. Right Mouse Click then Modify and in pop-up window I co...