To fetch vendor credit number from IF using workbook

• Go to Analytics tab
• Select dataset and create a ‘transaction detail’ dataset
• Provide required criteria
• Then to fetch the vendor credit number from Item fulfillment, select the field ‘Transaction Line’ under the ‘Transaction’ field
• Then from the drop down of ‘Transaction Line’, select the field ‘Created From’ .
• From the drop down, select ‘Related Transactions – Next’, then select type as ‘Transaction’
• Then we will get the vendor credit number from Item fulfillment.

To get only the bill credits:

• Select the field ‘Transaction Line’ under the ‘Transaction’ field
• Then from the drop down of ‘Transaction Line’, select the field ‘Created From’ .
• From the drop down, select ‘Related Transactions – Next’, then select type as ‘Link Type’
• And select the link type as ‘Order Bill/Invoice.