Question

IFSAPP.PURCHASE_REQ_LINE_PART_API.NEW__

  • 13 November 2020
  • 1 reply
  • 89 views

Badge

On the HELLO purchase request page, I created a purchase requisition. I realized these in IFS interface environment. My aim is to design a page via visual studio and open a demand no material request line when the button is clicked.

 

 

 

I want to add a new record when I click the button in the form I designed in the place shown in the picture

 

 string data= "'REQUISITION_NO'-'961841'-'CONTRACT'-'ROT'-'COMPANY'-'NSKOTO'-'PART_NO'-'BAG ELM 039'-'DESCRIPTION'-'1381988 BAGLANTI ELEMANI'-'ORIGINAL_QTY'-'1'-'UNIT_MEAS'-'ad'-'WANTED_RECEIPT_DATE'-'2020-11-12-00.00.00'-'LATEST_ORDER_DATE'-''-'VENDOR_NO'-''-'USE_PRICE_INCL_TAX_DB'-'FALSE'-'CONVERSION_FAC'-'1'-'BUY_UNIT_MEAS'-'ad'-'REQUEST_TYPE'-'Satınalma Talebi'-'PRICE_CONFIRMED_DB'-'FALSE'-'PART_OWNERSHIP'-''-'OWNING_CUSTOMER_NO'-''-'CORE_DEPOSIT_CURR'-''-'CORE_DEPOSIT_BASE'-''-'PROCESS_TYPE'-''-'SUPPLIER_SPLIT_DB'-'NO_SPLIT'-'DEMAND_CODE'-''-'CREATE_FA_OBJ_DB'-'FALSE'-'FA_OBJ_PER_UNIT_DB'-'FALSE'-'WANTED_DELIVERY_DATE'-''-'DEMAND_CODE_DB'-'IO'-'AUTHORIZATION_REJECTED_DB'-'FALSE'-'RENTAL_DB'-'FALSE'  ";
           // string data2= "REQUISITION_NO961841CONTRACTROTCOMPANYNSKOTOPART_NOBAG ELM 039DESCRIPTION1381988 BAĞLANTI ELEMANIORIGINAL_QTY1UNIT_MEASadWANTED_RECEIPT_DATE2020 - 11 - 13 - 00.00.00LATEST_ORDER_DATEVENDOR_NOUSE_PRICE_INCL_TAX_DBFALSECONVERSION_FAC1BUY_UNIT_MEASadREQUEST_TYPESatınalma TalebiPRICE_CONFIRMED_DBFALSEPART_OWNERSHIPOWNING_CUSTOMER_NOCORE_DEPOSIT_CURRCORE_DEPOSIT_BASEPROCESS_TYPESUPPLIER_SPLIT_DBNO_SPLITDEMAND_CODECREATE_FA_OBJ_DBFALSEFA_OBJ_PER_UNIT_DBFALSEWANTED_DELIVERY_DATEDEMAND_CODE_DBIOAUTHORIZATION_REJECTED_DBFALSERENTAL_DBFALSELINE_NO1RELEASE_NO4WANTED_DELIVERY_DATE2020 - 11 - 13 - 00.00.00DEMAND_CODEEnvanter SiparişiLATEST_ORDER_DATE2020 - 11 - 13 - 00.00.00BUYER_CODE*PRE_ACCOUNTING_ID15668975NOTE_ID16693067ORIGINAL_QTY1";
            OracleCommand cmd = new OracleCommand("IFSAPP.PURCHASE_REQ_LINE_PART_API.NEW__", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            OracleParameter info = new OracleParameter("info_", OracleType.VarChar,32000);
            info.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(info).Value="";

            OracleParameter objid = new OracleParameter("objid_", OracleType.VarChar,32000);
            objid.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(objid).Value = "";

            OracleParameter objversion = new OracleParameter("objversion_", OracleType.VarChar,32000);
            objid.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(objversion).Value = "";

            OracleParameter arttr = new OracleParameter("arttr_", OracleType.VarChar,32000);
            arttr.Direction = ParameterDirection.InputOutput;
            cmd.Parameters.Add(arttr).Value =data; 
            OracleParameter action = new OracleParameter("action_", OracleType.VarChar,32000);
            action.Direction = ParameterDirection.Input;
            cmd.Parameters.Add(action).Value="DO";

            cmd.ExecuteNonQuery();
            conn.Close();

 

 

My lines of code I tried a few methods like the one above but I did not solve it, I would be glad if you could help.

 

 

 


1 reply

Userlevel 5
Badge +11

h.eser,

Maybe it helps if you step over to use an migration job or even better a service like CreatePurchRequisition.svc via ODATA.

I know that is not what you want (your question is about Visual Studio) but others in the community are able to help you better as the knowledge on ODATA and services is rising within the community.

Regards,

Steve

Reply