Synchronous Update of Multiple Documents using B1if – For Each B1ic

          Insertion/Cancellation of SAP documents using SAP B1ic is an easier one as it involves only one document at a time. Whereas updating multiple SAP documents details is bit complex one as it involves looping the documents inside the processing flow of B1ic.

 

          Let us see it by an example scenario. Here we are going to update A/R Credit Memo’s document’s UDF using “Synchronous Update” method identifier.

 

         The Steps are as follows:

 

 

a. Get the list of Credit Memo documents to be updated by an SQL Call or Synchronous Retrieval

 

/wp-content/uploads/2014/12/1_614257.png

b. Result Set in an XForm

 

 

 

/wp-content/uploads/2014/12/b_614468.png

 

c. Assign the result set of the SQL Call or Synchronous Retrieval to a  customized XML tag in an XForm

 

/wp-content/uploads/2014/12/c_614469.jpg
d. In For Loop mention the XPath of the above XForm’s customized tag

 

/wp-content/uploads/2014/12/d_614470.jpg

 

e. Add an B1 Object atom, mention the B1 Object Identifier as “Synchronous Update”

 

/wp-content/uploads/2014/12/e_614412.jpg

 

f. In the XForm of the B1 Object, place the B1 Schema for the updating the B1 Object.

/wp-content/uploads/2014/12/f_614413.jpg

 

 

g. After the “Join” atom , add an XForm, click “Generate”, select “Correct after branch” and “Save” the atom to get consolidated results.

 

/wp-content/uploads/2014/12/g_614480.jpg

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jay Cheah

    Dear Venka, Is it necessary to xform the SQL result? Can the for-each not pick up repeated nodes that have further deeper nodes?

    (0) 

Leave a Reply