ICT61 [PowerShell] SmartBill Port Configuration [Requirements]- For Korean customers implementing E-Tax and VAT module addon, Powershell script setting up port open is beneficial to reduce set up time and eliminate human errors. [OS] Windows 10 [Development Language]PowerShell [IDE]PowerShell ISE [Setting]#Enable firewall settingSet-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass [Code]function Add-FirewallRules { param( [Par.. 2025. 11. 18. [SAP B1] Customer Refund Report Query [Requirements]- Customer requested a query printing out outgoing payment related to customer refund with the given columns as below.S.NO.Run Date/ Payment DateAccountCustomer NameCustomer code Amount Currency Outgoing GLREMARKSBANK NAMEBank Account nameBank codeBANK NO [OS] - [Development Language]HANA DB SQL [IDE]HANA DB Studio/SAP Business One Query Manager [Setting]HANA DB and SAP Business O.. 2025. 11. 6. [Automation] SAP Pending Approval Notification [Requirements]- A customer want to check if there is any pending approval in SAP system and receive a notification** SAP Business One has an email notification funtion but not activated in the customer environment [OS] Windows 10 [Development Language]Python / SQL [IDE]SAP HANA DB / PYCharm [Setting]- Figure out table structure in terms of approval document and create a procedure printing out pe.. 2025. 10. 7. [SQL] Basics of SQL Cursor [Learning Subject]Basics of SQL Cursor [Objectives]- Understadning concepts of SQL cursor- Learning grammar and commands related to SQLcursor- Being able to manipluate SQL cursor [Core knowledge]SQL cursor is similar to C pointer, indicating memory for data processing.Generally SQL restrives data from a query all at once but SQL cursor can visit each record and manipulate data. Key concepts of S.. 2025. 4. 15. 이전 1 2 3 4 ··· 16 다음 반응형