SBO-CMDLine is a handy tool to connect to Sap Business One and run commands via cmd-line. It makes it easier to run batch commands for SBO administrator and developers.
Latest build: https://github.com/mshams/SBO-CMDLine/releases
Command:
SBO-CMDLine.exe /h
Output:
SBO Command Line Helper v1.0.0.0
By M.Shams 2021
Options:
-fn=VALUE Connection filename for DI connection mode.
VALUE: <FILEPATH>
-cm=VALUE Connection mode.
VALUE: UI, DI
-ci Company information tools.
-um Working with UI menus.
-uf Working with UI forms.
-rm Report management tools.
-h, -? show help
In UI mode, there should be an open SBO application with admin permission (Ex: manager user) to be used by connection string and running commands. In DI mode you can prepare a xml file with propper credentials to be used for connection.
Command:
SBO-CMDLine.exe -cm=UI -ci --verbose --list
Output:
SBODemoTR
Name: OEC Bilgisayarları
Version: 930210
Localization: Turkey
SBODemoUS
Name: OEC Computers
Version: 930210
Localization: United States Of America/Puerto Rico
Command:
SBO-CMDLine.exe -cm=UI -um --verbose --list=43520
Output:
[+]UID: 43520 Name: &Modules
[+]UID: 3328 Name: &Administration
[+]UID: 1536 Name: &Financials
[+]UID: 43679 Name: &CRM
[+]UID: 2560 Name: &Opportunities
[+]UID: 2048 Name: &Sales - A/R
[+]UID: 2304 Name: &Purchasing - A/P
[+]UID: 43535 Name: &Business Partners
[+]UID: 43537 Name: Ba&nking
[+]UID: 3072 Name: &Inventory
[+]UID: 13312 Name: &Resources
[+]UID: 4352 Name: Pro&duction
[+]UID: 43543 Name: &MRP
[+]UID: 3584 Name: S&ervice
[+]UID: 43544 Name: &Human Resources
[+]UID: 48896 Name: Pro&ject Management
[+]UID: 43545 Name: Repor&ts
Command:
SBO-CMDLine.exe -cm=UI -um --verbose --find=name:"Financial Reports"
Output:
UID: 43531 Name: Financia&l Reports
Command:
SBO-CMDLine.exe -cm=UI -um --verbose --find=id:43550
Output:
UID: 43550 Name: &Financial
Command:
SBO-CMDLine.exe -cm=UI -um --verbose --find=name:"Query"
Output:
UID: 45111 Name: BP Bank Accounts Query
UID: 45113 Name: House Bank Accounts Query
UID: 45110 Name: BP Bank Accounts Query
UID: 45112 Name: House Bank Accounts Query
UID: 4865 Name: &Query Manager...
UID: 4102 Name: Q&uery Generator
UID: 4103 Name: Qu&ery Wizard
UID: 4868 Name: Que&ry Print Layout...
UID: 5121 Name: BP Bank Accounts Query
UID: 5130 Name: House Bank Accounts Query
Command:
SBO-CMDLine.exe -cm=UI -rm
Output:
Install/Uninstall reports.
Options:
--file[=VALUE] Report file to do action on.
VALUE: <FILEPATH>
--report[=VALUE] Report name to install.
VALUE: <NAME>
--type[=VALUE] Type name to install.
VALUE: <NAME>
--code[=VALUE] Type code to install.
VALUE: <NAME>
--form[=VALUE] Form name to install.
VALUE: <NAME>
--addon[=VALUE] Addon name to install.
VALUE: <NAME>
--menu[=VALUE] Menu ID to install report.
VALUE: <NAME>
--install Install report.
--uninstall Uninstall report.
--list List installed reports.
--find=VALUE Find report by type or name.
VALUE: type:<TYPECODE>, name:<SUBSTRING>
Command:
SBO-CMDLine.exe -cm=UI -rm --file="AdvancedTrialBalance-v1.rpt" --report="Advanced Trial Balance" --install --menu=9728
Command:
SBO-CMDLine.exe -cm=UI -rm --code=A005 --uninstall
SBO-CMDLine.exe -cm=UI -rm --type=A007 --uninstall
Command:
SBO-CMDLine.exe -cm=UI -rm --find=type:RCRI
Output:
Type: RCRI Code: RCRI0005 Category: rlcCrystal Name: Annual Sales Analysis (by Quarter)
Type: RCRI Code: RCRI0002 Category: rlcCrystal Name: Bank Reconciliation Report
Type: RCRI Code: RCRI0006 Category: rlcCrystal Name: Business Assessment Report
Type: RCRI Code: RCRI0007 Category: rlcCrystal Name: Customer Open Document List
Type: RCRI Code: RCRI0008 Category: rlcCrystal Name: Customer Open Document List_HANA
Type: RCRI Code: RCRI0009 Category: rlcCrystal Name: Inventory Turnover Analysis
Type: RCRI Code: RCRI0010 Category: rlcCrystal Name: Inventory Turnover Analysis_HANA
Type: RCRI Code: RCRI0001 Category: rlcCrystal Name: Inventory Valuation Method Report
Type: RCRI Code: RCRI0011 Category: rlcCrystal Name: Monthly Customer Status Report
Type: RCRI Code: RCRI0012 Category: rlcCrystal Name: Monthly Customer Status Report - HANA
Type: RCRI Code: RCRI0003 Category: rlcCrystal Name: Payment Orders Report by Business Partner
Type: RCRI Code: RCRI0004 Category: rlcCrystal Name: Payment Orders Report by Payment Run
Command:
SBO-CMDLine.exe -cm=UI -rm --find=name:Payroll
Output:
Type: A001 Code: A0010001 Category: rlcCrystal Name: Payroll Document
Type: A004 Code: A0040001 Category: rlcCrystal Name: Payroll Documents