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...
top of page
Search
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>...
ivend-SAP Integration Monitor from SBO to ivend Query
Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As...
iVend Replication - Application Log error
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please...
iVend Cloud Hosted - MC SSO login
Enable Cloud Hosting: C:\Program Files (x86)\CitiXsys\iVend Retail\ManagementConsole\CXSManagementConsole.xml >>...
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...
iVend Replication - Re-trigger the missing to Store DB
Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' +...
Generate PEM File
source: https://sectigo.com/knowledge-base/detail/Creating-a-pem-File-for-SSL-Certificate-Installations/kA03l00000117PV Creating a .pem...
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...
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...
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...
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...
Steps create Layway
Create Location Transfer (from store location to Layway location) iVend MC >> Operation >> Business Transactions >> Location Transfer: -...
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...
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...
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:...
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 *...
iVend - Print receipt from MC
Export TransactionReceipt from Report Manager 2. Create new report name "TransactionDetail"
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...
Blog: Blog2
bottom of page