Missing Tenders in SAPB1 : Unable to find on SAPB1 Warehouse and General Retail Tender Screen

********Internal to CitiXsys Support Team.***********

Environment : 

iVend 6.6 7989 with SAPB1

Problem statement : 

When user opened the warehouse in SAPb1, it didn't display the Retail Tenders and unable to map it 

Symptoms : 

Retail Tenders were created in iVend but it got synced with SAPB1 but it didn't display the default tenders and iVend Tenders

Workaround :

Step 1 : Execute the query on SAP database

         CREATE SEQUENCE seq START WITH 1;

Step 2 : Replace the T4 with actual whscode in beloew query and execute

DO BEGIN 

 DECLARE RecordCount int;

 DECLARE WhsCode nvarchar(100);

 

 WhsCode:= 'T4';

 

 SELECT COUNT(1) into RecordCount From "@CXS_RETEND" Where "U_CXS_WHCD" = :WhsCode;

 

 IF(:RecordCount <= 0) THEN

 

  DECLARE NewCode int;

  Select IFNULL(MAX(TO_INT("Code")),0) into NewCode From "@CXS_RETEND";

  insert into "@CXS_RETEND"("Code", "Name", "U_CTX_SORT", "U_CXS_RETD", "U_CXS_MPTN", "U_CXS_MPTC", "U_CXS_WHCD","U_CXS_GLAC","U_CXS_GLFC","U_CXS_CUCD")  

  select seq.NEXTVAL + NewCode, seq.NEXTVAL + NewCode, seq.NEXTVAL + NewCode, "U_CXS_RETD", "U_CXS_MPTN", "U_CXS_MPTC", 

  :WhsCode, "U_CXS_GLAC","U_CXS_GLFC","U_CXS_CUCD" 

  from "@CXS_RETEND" 

  where IFNULL("U_CXS_WHCD",'') = '' and "U_CXS_TETP" <> '3'; 

 

 END IF; 

END;

Note : Suggested to map the retail tenders in SAPB1 When it gets integrated with SAPB1.

• Related Articles

• Missing Retail Tender in SAPB1 Warehouse : Generate Mappings

  This KB is for Internal Purpose Only for CitiXsys Environment: iVend 6.6 with SAPB1 9.2 Problem statement: There are some warehouse in SAPB1 where iVend Addon Screen "Retail Tender" doesn't display the available tenders to be mapped. Symptoms : There ...

• General Settings in SAP Business One

  Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

• iVend POS Custom Tender

  What is a Custom Tender in iVend Retail POS? Special tender types can be used by the Retailer as per their business practices, such as Check (Cheque) on Delivery, Cash on Delivery, named Credit Cards, etc. The Custom Tenders type in iVend POS ...

• Store license with General warehouse in iVend unplugged

  Environment: iVend Version 6.6 and 6.5 Update 6 unplugged Problem Statement: New Button on the iVend MC Warehouse screen is not enabled however store license is available to create a new store in iVend Enterprise MC. Symptoms: Not Applicable ...

• Restrict particular users to access warehouse

  Environment : iVend 6.6 with SAPB1 Problem Statement : There is need to restrict particular users to access warehouse & its relevant information in iVend Various Screens. Resolution/Work Around : Whenever you create any warehouse in SAPB1 , it will ...