0% found this document useful (0 votes)
48 views3 pages

SAP B1 and SQL Credentials Guide

Uploaded by

Chithra Vinod
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
48 views3 pages

SAP B1 and SQL Credentials Guide

Uploaded by

Chithra Vinod
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

Stan Weinstein --

Mark minervini
William Oneil --
Richard viov
817618327313 -- Vinod
339005744380
1Y Forword EPS Growth
1Y Forword EBITDA Growth
1Y Forword Revenue Growth

IOB
RTNINDIA
TV18BRDCST
RITES
BALMLAWRIE
CASTROLIND

PE Sector PE
PB Sector PB

b1s_sqltable.conf
HDFC Health Ins 1 Yr - 31380, 3 Yr - 85700
stoploss - buy point -3,-5,-7
Contact Points BREAKOUT_HH_NEAR.afl

{
"error" : {
"code" : "-5002",
"message" : "10000100 - Document total value must be zero or greater than
zero"
}
}
----------------------
https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part1-
protocol.html#sec_SystemQueryOptionfilter

C:\Users\HGD\Desktop\Greenmot\GreenmotProd\bin\Release
if component of one vector in the direction of another vector is zero, then those
two vectors
SAP_Business_One_Service_Layer D:\ITS\Dev\ComelitTest
JIO CC NO - 1800-896-9999 / device issues - 1800-890-9999 ITS-BLKA0001 Gypsum
Plastering
pip install pywhatkit
import pywhatkit
pywhatkit.sendwhatmsg('9840938232','Test msg')
80451
SAP01 / vV%7DB&r
SAP03 / SuvDbpG4d%
SAPADMIN / Nu4A#o&d
044-26557447
SAP B1 Manager sapsimab / support spirit
MSSQL sysadimn sa SIMABSAP
AFFPC2240E - chithra dayalan
U-K002063897
477375380367 - chithra
280838538126 - dayalan
IIT JEE & NEET Prep App
JEE Mains PYQ Questions
<A HREF="https://comelitsapb1:40000/ExtensionManager/" TYPE="0"
COLOR="purple">Manage Extensions for Lightweight Deployment</A>
user-B1SiteUser
PSW-SIMABSAP
it-spirit.com
z
Acces to JARS
---------------
From its server 178.33.233.120
Connect to JARS with teamviewer v.thanigai-arasu@it-spirit.com / Tirips44
Client ID: 1059192923 / Tirips44
Windoss login : SRV-SAP\DevIts / Tirips44!
Windoss login : SRV-SAP\DevIts / Tirips44
COMELIT\administrateur 209Comelit@!
user-B1SiteUser
PSW-Sapsbo69

SQL: sa / Sapsbo6944
B1: manager/orga

--------------------------------
Sapsbo6944 - microsoft sql
Sapsbo69 - hana (Agl0nly01 for Azergo)
DevIts - Tirips44 (JARS Server login)
SAP - :4f59tUJUX (CBR VPN login)
B1Admin -Sapsbo69 ( CBR HANA)
https://192.168.6.41:50000/Service%20Layer%20API%20Reference.html
---------------------
"C:\Program Files\Produmex\Produmex Tools\Produmex.Sbo.Logex.Tools.Robot.exe"
/t:csscript /a1:"C:\Program Files\Produmex\Produmex Tools\CsScript\ChangeQS.cs"
/cs:EH_MASTER

powershell.exe -WindowStyle Hidden C:\ITS\QualityStatusChange.ps1


C:\ITS\QualityStatusChangeShortcut.lnk

ehusa-blanketbooking
https://ehusa.vision33cloud.com/RDWeb
EMILEHENRY\Nicolas.Bravin
B3MQJ2E22PZSvtv
dans SAP B1 : lberp - EHUSA1850
hana studion V33REPORTS A9Jg80Yg (edited)
hana studion V33ADMIN1 1O+BWD*f'Te8h

CALL "ITS_GetQualityStatus"(4,1250000100);
CALL "ITS_GetQualityStatus"(1200071522,17);
Start-Process -NoNewWindow -FilePath "C:\Program Files\Produmex\Produmex Tools\
Produmex.Sbo.Logex.Tools.Robot.exe" -ArgumentList '/t:csscript /a1:"C:\Program
Files\Produmex\Produmex Tools\CsScript\ChangeQS.cs" /cs:EH_MASTER' -Wait
$cred = Get-Credential
Start-Process -Credential $cred -NoNewWindow -FilePath "C:\Program Files\Produmex\
Produmex Tools\Produmex.Sbo.Logex.Tools.Robot.exe" -ArgumentList '/t:csscript
/a1:"C:\Program Files\Produmex\Produmex Tools\CsScript\ChangeQS.cs" /cs:EH_MASTER'
-Wait
---------------------
POLAAR vpn login:
itsnantes
LA,!2a6e5
POLAAR RDS login:
POLAAR\its.adm
K2u8ZFCXV6GR!YW8f@QfVx*s
SQL “sa” : Sapsbo6944
---------------------
ALDM-10T0-M42-P05-001
CLGE-D24-06X36G-ATE-1BSN-CSOE
SalesPersonCode 7604911561
Azergo Accès

1- Need to connect through RDS to ITS server 178.33.233.120


Credentials VND / iHORSE!2022
2- From Desktop 178.33.233.120 launch openvpn in systemtray icons
Credentials are memorized in open VPN
3- Once VPN is connected connect to Azergo serveur through RDS 172.17.111.111
Shortcut on the desktop.
Credentials AZERG\devitspirit Azergo2022

SU to CH
SAP B1 Support spirit
C:\Program Files (x86)\SAP\SAP Business One SDK\Tools\ExtensionPackage
E:\ITS\dnSpy-net472
C:\Temp\ITS\dnSpy-net-win32
----------------------------------

1.in line 118

Add last import date = current date (YYYY-MM-DD HH:MM:SS)


Add Import Referance = values[0]

2.in line

oDpm.UserFields.Fields.Item("U_SIM_ImpRef").Value = values[0] + values[1]

3.Declimal issue need to fix

4.while any error we need to continue the loop and skip the error one
log the error in the error log.
------------
--update t0 set "U_AZE_NbManut" = 1 from opkl as t0 where t0."Status" = 'C'
--update t0 set "U_AZE_NbCol" = 1,"U_AZE_NbManut" = null from opkl as t0 where
t0."Status" = 'C'
--select * from opkl where "AbsEntry" = 47556
--update t0 set "U_AZE_PackNum" = 4, "U_AZE_NbManut" = 1 from OPKL t0 where
"AbsEntry" in (80450,78304)
--update t0 set "U_AZE_PackNum" = 4 from OWTR t0 where "DocNum" in (36718,35668)
--call ITS_GetPackingData (80464)

You might also like