top of page
Search
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...
ABS
Apr 23, 20243 min read
1 view
0 comments

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>...
ABS
Jan 15, 20241 min read
2 views
0 comments
ivend-SAP Integration Monitor from SBO to ivend Query
Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As...
ABS
Jan 15, 20241 min read
2 views
0 comments

iVend Replication - Application Log error
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please...
ABS
Jan 13, 20241 min read
2 views
0 comments
iVend Cloud Hosted - MC SSO login
Enable Cloud Hosting: C:\Program Files (x86)\CitiXsys\iVend Retail\ManagementConsole\CXSManagementConsole.xml >>...
ABS
Jan 11, 20241 min read
11 views
0 comments
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...
ABS
Jan 4, 20246 min read
3 views
0 comments
iVend Replication - Re-trigger the missing to Store DB
Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' +...
ABS
Nov 2, 20231 min read
7 views
0 comments
Generate PEM File
source: https://sectigo.com/knowledge-base/detail/Creating-a-pem-File-for-SSL-Certificate-Installations/kA03l00000117PV Creating a .pem...
ABS
Jun 20, 20222 min read
7 views
0 comments
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...
ABS
Feb 22, 20221 min read
15 views
0 comments

ABS
Jan 13, 20220 min read
13 views
0 comments

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...
ABS
Dec 31, 20211 min read
13 views
0 comments

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...
ABS
Dec 29, 20213 min read
10 views
0 comments


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...
ABS
Dec 29, 20211 min read
2 views
0 comments

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

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...
ABS
Dec 24, 20211 min read
7 views
0 comments

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...
ABS
Dec 17, 20213 min read
29 views
0 comments

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:...
ABS
Dec 13, 20211 min read
23 views
0 comments
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 *...
ABS
Dec 9, 20211 min read
10 views
0 comments
iVend - Print receipt from MC
Export TransactionReceipt from Report Manager 2. Create new report name "TransactionDetail"
ABS
Dec 7, 20211 min read
15 views
0 comments

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...
ABS
Dec 6, 20211 min read
4 views
0 comments
Blog: Blog2
bottom of page