top of page
Search
ABS
Apr 23, 20243 min read
SAP B1/iVend- Query Inventory In SAP
Check inventory audit in SAP select  a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then  'Sale...
1 view
0 comments

ABS
Jan 15, 20241 min read
iVend Integration Configuration Error: Object reference not set to an instance of an object
Edit: C:\Program Files (x86)\CitiXsys\iVend Retail\Integration\ConfigurationTemplate.xml Add: <SBODomainName></SBODomainName>...
2 views
0 comments
ABS
Jan 15, 20241 min read
ivend-SAP Integration Monitor from SBO to ivend Query
Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As...
2 views
0 comments

ABS
Jan 13, 20241 min read
iVend Replication - Application Log error
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please...
2 views
0 comments
ABS
Jan 11, 20241 min read
iVend Cloud Hosted - MC SSO login
Enable Cloud Hosting: C:\Program Files (x86)\CitiXsys\iVend Retail\ManagementConsole\CXSManagementConsole.xml >>...
11 views
0 comments
ABS
Jan 4, 20246 min read
SAP B1: Table description, Primary Key, Object Type
OACT G/L Accounts AcctCode 1 OCRD Business Partner CardCode 2 ODSC Bank Codes AbsEntry 3 OITM Items ItemCode 4 OVTG Tax Definition Code 5...
3 views
0 comments
ABS
Nov 2, 20231 min read
iVend Replication - Re-trigger the missing to Store DB
Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' +...
7 views
0 comments
ABS
Jun 20, 20222 min read
Generate PEM File
source: https://sectigo.com/knowledge-base/detail/Creating-a-pem-File-for-SSL-Certificate-Installations/kA03l00000117PV Creating a .pem...
7 views
0 comments
ABS
Feb 22, 20221 min read
iVend - Business Date different Actual Date
iVend show Business Date different with Actual Date, but incorrect Actual date compare with system date Update in DB: update...
15 views
0 comments


ABS
Dec 31, 20211 min read
SAP B1 V10 - iVend error: B1_53424F5F4956454E44_RW
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The server principal "B1_53424F5F4956454E44_RW" is not able to access the database...
13 views
0 comments

ABS
Dec 29, 20213 min read
iVend Retail- Transaction Roll-up
iVend Retail – Transaction Rollup The Transaction Rollup feature is used to reduce the volume of transactions integrated into an ERP. It...
10 views
0 comments


ABS
Dec 29, 20211 min read
iVend - SQL Collation issue
iVend requires sql collation is SQL latin1 CP1 CI AS, that’s why there will be error. do you need to change SQL collation. This is...
2 views
0 comments

ABS
Dec 24, 20211 min read
Steps create Layway
Create Location Transfer (from store location to Layway location) iVend MC >> Operation >> Business Transactions >> Location Transfer: -...
12 views
0 comments

ABS
Dec 24, 20211 min read
Steps to setup new iVend store with SAP B1 integration
Create retail warehouse in SAP B1 - Start iVend Addon - Prepare Cash customer code, price list, Cash account for new store Create new...
7 views
0 comments

ABS
Dec 17, 20213 min read
iVend - Discount setup
I. Selling Price: There’s resolution defined by ivend to pick one of price by this Hierarchy (top to bottom list here is from low...
29 views
0 comments

ABS
Dec 13, 20211 min read
Create customer with iVend API
Reference all iVend API: http:/localhost/iVendAPI/iVendAPI.svc/WebAPI/help Add new Employee: Add new API User: Configure API setting:...
23 views
0 comments
ABS
Dec 9, 20211 min read
SQL Slow Performance
Check heavy query: SELECT TOP 10 s.session_id, r.status, r.cpu_time, r.logical_reads, r.reads, r.writes, r.total_elapsed_time / (1000 *...
10 views
0 comments
ABS
Dec 7, 20211 min read
iVend - Print receipt from MC
Export TransactionReceipt from Report Manager 2. Create new report name "TransactionDetail"
15 views
0 comments

ABS
Dec 6, 20211 min read
iVend - Import Product - UPC cannot be more than 16 characters
select * from CfgValidationRule where ObjectId='Product' and PropertyName='UPC' update CfgValidationRule set MaxLength=100 where...
4 views
0 comments
Blog: Blog2
bottom of page