Skip to main content

Configure and run flows in the SAP Ariba Network – NetSuite integration template for Buyers

Stephen Brandt
  • Updated
Follow

Contents

Additional record mapping is required to integrate the template’s exports and imports with your SAP Ariba Network and NetSuite apps.

SAP Ariba Network invoice and credit memo to NetSuite vendor bill and vendor bill credit

The flow syncs invoices and credit memos from SAP Ariba Network as vendor bills and bill credits in NetSuite.

Flow details

  • Export source: SAP Ariba Network
  • Import destination: NetSuite

Before you begin

  1. Sync NetSuite purchase orders with SAP Ariba Network purchase orders.
  2. Verify that OrderId in SAP Ariba Network and PO # in NetSuite are the same.
  3. Verify that currency symbols in NetSuite and currency value in SAP Ariba Network are the same.

Setup instructions

  1. Configure dynamic lookup for Vendor (InternalId) in all NetSuite vendor bills and bill credits imports.
  2. Add subsidiary mapping in all NetSuite vendor bills and bill credits imports.
  3. Configure static lookup for item[*].taxcode in Import NetSuite vendor bills (with taxes for a single line item) and Import NetSuite vendor bills (with taxes); configure static lookup for expense[*].taxcode in Import NetSuite bill credits (with taxes); and select Integer for the data type for each tax code.
  4. Configure mapping for Account (InternalId) in all NetSuite imports.
  5. Configure mapping for Expenses: Account (InternalId) in Import NetSuite bill credits (with taxes) and Import NetSuite bill credits (without taxes).
  6. Configure static lookup for Currency (InternalId) in all NetSuite vendor bills and bill credits imports.
nsvendorbills.pngField mappings: Import NetSuite vendor bills (with taxes for a single line item)
nsVendBillswithTax.pngField mappings: Import NetSuite vendor bills (with taxes)
nsVenderBillCreds.pngField mappings: Import NetSuite bill credits (with taxes)
nsBillCredsWitoutTax.pngField mappings: Import NetSuite bill credits (without taxes)

Configure endpoint in SAP Ariba Network Buyer for webhook (for invoice creation)

  1. Click Manage profile in the right under the username.
  2. Click Business endpoints (cXML and OData setup).
  3. Click Create.
  4. Enter the endpoint name and add the custom URL token generated from the webhook in the Shared secret field.
  5. Enter the public URL of the webhook in the POST URL field and click the checkbox below.
  6. Save the endpoint and set the default to yes.
  7. Select the endpoint for document type under Configure document routing and click Save.

SAP Ariba Network purchase order confirmation to NetSuite purchase order confirmation

This flow syncs SAP Ariba Network purchase order confirmations with NetSuite purchase order confirmations.

Flow details

  • Export source: SAP Ariba Network
  • Import destination: NetSuite
  • Built-in export: Get SAP Ariba Network order confirmations – get all purchase order confirmations from SAP Ariba Network
  • Built-in import: Import NetSuite purchase order confirmations – update purchase orders with status as Approved/Rejected into NetSuite with PO # as the lookup identifier
  • Functional use cases for NetSuite purchase order confirmations import:
    • Approval Status (InternalId)
    • SAP Ariba Network Shipment Date
    • SAP Ariba Network PO Delivery Date

Before you begin

  1. Sync NetSuite purchase orders with SAP Ariba Network purchase orders.
  2. Verify that OrderId in SAP Ariba Network and PO # in NetSuite are the same.
  3. Verify that the script is present for Data Normalization (Convert into Array) in Get SAP Ariba Network order confirmations. (Removing this script will cause an error in the flow.)

Setup instructions

Configure mapping for Approval Status (InternalId) and Payment Method (InternalId) in Import NetSuite purchase order confirmations.

NSpurchaseorderconf.pngField mappings: Import NetSuite purchase order confirmations

Configure endpoint in SAP Ariba Network Buyer for webhook (for OrderConfirmation creation)

  1. Click Manage profile available at the right under the username.
  2. Click Business endpoints (cXML and OData setup).
  3. Click Create.
  4. Enter the endpoint name and add the custom URL token generated from the webhook in the Shared secret field.
  5. Enter the public URL of the webhook under POST URL and click the checkbox below.
  6. Save the endpoint and set the default to yes.
  7. Under Configure document routing, select the endpoint for document type and save it.

SAP Ariba Network ship notice to NetSuite ship notice

This flow syncs SAP Ariba Network ship notices with NetSuite ship notices.

Flow details

  • Export source: SAP Ariba Network
  • Import destination: NetSuite
  • Built-in export: SAP Ariba Network ship notices – get all ship notices from SAP Ariba Network
  • Built-in import: Import NetSuite ship notices – update purchase order shipment status as Shipped into NetSuite with PO# as the lookup identifier
  • Functional use cases for NetSuite ship notices import:
    • SAP Ariba Network Shipment Date
    • SAP Ariba Network PO Delivery Date
    • Shipping Method (InternalId)
    • Ariba Tracking Number
    • Shipment Status (InternalId)
  • Dependency trackers: N/A

Before you begin

  1. Sync NetSuite purchase orders with SAP Ariba Network purchase orders.
  2. Verify that OrderId in SAP Ariba Network and PO # in NetSuite are the same.

Setup instructions

Configure mapping for Shipment Status (InternalId) in Import NetSuite ship notices.

NSShipNotices.pngField mappings: Import NetSuite ship notices

Configure endpoint in SAP Ariba Network Buyer for webhook (for shipNotice creation)

  1. Click Manage profile available at the right under the username.
  2. Click Business endpoints (cXML and OData setup).
  3. Click Create.
  4. Enter the endpoint name and add the custom URL token generated from the webhook in the Shared secret field.
  5. Add the public URL of the webhook in the POST URL field, and click the checkbox underneath.
  6. Save the endpoint and set the default to yes.
  7. Under the Configure document routing, select the endpoint for document type and save it.

NetSuite items receipt to SAP Ariba Network goods receipt

This flow syncs NetSuite items receipts to SAP Ariba Network goods receipts.

Flow details

  • Export source: NetSuite
  • Import destination: SAP Ariba Network
  • Built-in export: Get NetSuite items receipts – get all items receipts from NetSuite that are modified since the last flow run time
  • Built-in import: Import SAP Ariba Network goods receipts – add goods receipts into SAP Ariba Network
  • Built-in import: Import NetSuite items receipts – update items receipts into NetSuite with internal ID as the lookup identifier
  • Dependency trackers: N/A

Before you begin

Sync NetSuite purchase orders with SAP Ariba Network purchase orders.

Setup instructions

Configure the mapping for Sent To Ariba (custom field) in Import NetSuite items receipts.

NSItemsReceipts.pngField mappings: Import NetSuite items receipts
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.2.042/Fulfill.dtd">
{{#each data}}
<cXML payloadID="IN.{{DocumentNumber}}.{{dateFormat 'x'}}" timestamp="{{dateFormat 'YYYY-MM-DDTHH:mm:ssZ'}}" version="1.2.042" xml:lang="en-US">
{{/each}}
  <Header>
    <From>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
      </Credential>
    </From>
    <To>
      <Credential domain="NetworkId">
        <Identity>{{connection.http.unencrypted.Supplier_NetworkId}}</Identity>
      </Credential>
    </To>
    <Sender>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
        <SharedSecret>{{connection.http.encrypted.Buyer_SharedSecret}}</SharedSecret>
      </Credential>
      <UserAgent>Celigo Integration</UserAgent>
    </Sender>
  </Header>
  <Request>
 {{#each data}}
    <ReceiptRequest>
      <ReceiptRequestHeader receiptID="{{DocumentNumber}}" receiptDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" operation="new"/>
      <ReceiptOrder closeForReceiving="yes">
        <ReceiptOrderInfo>
          <OrderReference orderID="{{POrderID}}">
          <DocumentReference payloadID="IN.{{DocumentNumber}}.{{dateFormat 'x'}}"/>
          </OrderReference>
        </ReceiptOrderInfo>
        {{#each Item as |a|}}
        <ReceiptItem receiptLineNumber="{{LineID}}" quantity="{{Qty}}" type="received">
          <ReceiptItemReference lineNumber="{{LineID}}">
            <ItemID>
              <SupplierPartID>{{ItemID}}</SupplierPartID>
            </ItemID>
            <Description xml:lang="en">{{Description}}</Description>
            <ManufacturerPartID>{{Manufacturer}}</ManufacturerPartID>
            <ManufacturerName>{{Manufacturer}}</ManufacturerName>
          </ReceiptItemReference>
          <UnitRate>
            <Money currency="USD">{{UnitPrice}}</Money>
            <UnitOfMeasure>{{UnitType}}</UnitOfMeasure>
          </UnitRate>
          <ReceivedAmount>
            <Money currency="USD">{{Amount}}</Money>
          </ReceivedAmount>
        </ReceiptItem>
        {{/each}}   
    </ReceiptOrder>
      <Total>
        <Money currency="USD">{{Amount}}</Money>
      </Total>
    </ReceiptRequest>
      {{/each}}
  </Request>
</cXML>
      <OrderRequestHeader orderDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" orderID="{{DocumentNumber}}" orderType="regular" orderVersion="{{SAP_Ariba_orderVersion}}" type="new">
        <Total>
           <Money currency="USD">{{subtract (subtract TotalAmount ShippingCost) TotalTaxAmount}}</Money>
        </Total>
        <ShipTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <DeliverTo>{{FirstName}}{{LastName}}</DeliverTo>
              <Street>{{ShippingAddress1}}</Street>
              <City>{{ShippingCity}}</City>
              <State>{{ShippingState}}</State>
              <PostalCode>{{ShippingZip}}</PostalCode>
              <Country isoCountryCode="{{ShippingCountryCode}}">{{ShippingCountry}}</Country>
            </PostalAddress>
            <Email name="default" preferredLang="en-US">{{Email}}</Email>
          </Address>
        </ShipTo>
        <BillTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <Street>{{BillingAddress1}}</Street>
              <City>{{BillingCity}}</City>
              <State>{{BillingState}}</State>
              <PostalCode>{{BillingZip}}</PostalCode>
              <Country isoCountryCode="{{BillingCountryCode}}">{{BillingCountry}}</Country>
            </PostalAddress>
          </Address>
        </BillTo>
        <Shipping>
          <Money currency="USD">{{ShippingCost}}</Money>
          <Description xml:lang="en-US">{{ShipVia}}</Description>
        </Shipping>
      </OrderRequestHeader>
      {{#each Item as |a|}}
      <ItemOut quantity="{{Qty}}" lineNumber="{{LineID}}">
        <ItemID>
          <SupplierPartID>{{Item}}</SupplierPartID>
        </ItemID>
        <ItemDetail>
          <UnitPrice>
            <Money currency="USD">{{UnitPrice}}</Money>
          </UnitPrice>
          <Description xml:lang="en">{{Description}}</Description>
          <UnitOfMeasure>{{UnitType}}</UnitOfMeasure>
          <Classification domain="{{ClassificationDomain}}">{{ClassificationCode}}</Classification>
        </ItemDetail>
        <Tax>
          <Money currency="USD">{{divide (multiply (multiply UnitPrice Qty) (substring TaxRate 0 4)) 100}}</Money>
          <Description xml:lang="en">{{TaxCode}}</Description>
        </Tax>
      </ItemOut>
      {{/each}}
    </OrderRequest>
     {{/compare}}
    {{/each}}	
  </Request>
</cXML>

NetSuite purchase order to SAP Ariba Network purchase order

This flow syncs NetSuite purchase orders to SAP Ariba Network orders (add or update).

Flow details

  • Export source: NetSuite
  • Import destination: SAP Ariba Network
  • Built-in export: Get NetSuite purchase orders – get all purchase orders from NetSuite that are modified since the last flow run time
  • Built-in import: Import SAP Ariba Network purchase orders – add or update purchase orders into SAP Ariba Network by order ID
  • Built-in import: Import NetSuite purchase orders – update purchase orders into NetSuite with internal ID as the lookup identifier
  • Dependency trackers: N/A

Before you begin

  1. Classification Code and Classification Domain fields (custom fields) on Items record type in NetSuite should have some value.
  2. Sent to SAP Ariba Network of type checkbox field (custom field) on the purchase order record type in NetSuite must be checked while creating a purchase order; when a customer is modifying the order, it should be unchecked.
  3. SAP ARIBA ORDERVERSION of type Free-form text field (custom field) on purchase order record type in NetSuite will be used to store the order version of SAP Ariba Network orders. When creating orders in NetSuite, it must have a value of 1.
  4. The UnitType in NetSuite inventory items should have some value.

Setup instructions

Configure mapping for Sent to SAP Ariba Network (custom field) in Import NetSuite purchase orders. 

NSPurchOrd.pngField mappings: Import NetSuite purchase orders
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.2.042/cXML.dtd">
{{#each data}}
<cXML payloadID="IN.{{DocumentNumber}}.{{dateFormat 'x'}}" timestamp="{{dateFormat 'YYYY-MM-DDTHH:mm:ssZ'}}" version="1.2.042" xml:lang="en-US">
{{/each}}
  <Header>
    <From>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
      </Credential>
    </From>
    <To>
      <Credential domain="NetworkId">
        <Identity>{{connection.http.unencrypted.Supplier_NetworkId}}</Identity>
      </Credential>
    </To>
    <Sender>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
        <SharedSecret>{{connection.http.encrypted.Buyer_SharedSecret}}</SharedSecret>
      </Credential>
      <UserAgent>Celigo Integration</UserAgent>
    </Sender>
  </Header>
  <Request>
    {{#each data}}
         {{#compare [Sent to SAP Ariba]  '==' 'F'}}  
    <OrderRequest>
      <OrderRequestHeader orderDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" orderID="{{DocumentNumber}}" orderType="regular" orderVersion="{{SAP_Ariba_orderVersion}}" type="update">
        <Total>
          <Money currency="USD">{{add (subtract TotalAmount ShippingCost) TotalTaxAmount}}</Money>
        </Total>
        <ShipTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <DeliverTo>{{FirstName}}{{LastName}}</DeliverTo>
              <DeliverTo>{{CompanyName}}</DeliverTo>
              <Street>{{ShippingAddress1}}</Street>
              <City>{{ShippingCity}}</City>
              <State>{{ShippingState}}</State>
              <PostalCode>{{ShippingZip}}</PostalCode>
              <Country isoCountryCode="{{ShippingCountryCode}}">{{ShippingCountry}}</Country>
            </PostalAddress>
            <Email name="default" preferredLang="en-US">{{Email}}</Email>
          </Address>
        </ShipTo>
        <BillTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <Street>{{BillingAddress1}}</Street>
              <City>{{BillingCity}}</City>
              <State>{{BillingState}}</State>
              <PostalCode>{{BillingZip}}</PostalCode>
              <Country isoCountryCode="{{BillingCountryCode}}">{{BillingCountry}}</Country>
            </PostalAddress>
          </Address>
        </BillTo> 
        <Shipping>
          <Money currency="USD">{{ShippingCost}}</Money>
          <Description xml:lang="en-US">{{ShipVia}}</Description>
        </Shipping>
      </OrderRequestHeader>
      {{#each Item as |a|}}
      <ItemOut quantity="{{Qty}}" lineNumber="{{LineID}}">
        <ItemID>
          <SupplierPartID>{{Item}}</SupplierPartID>
        </ItemID>
        <ItemDetail>
          <UnitPrice>
            <Money currency="USD">{{UnitPrice}}</Money>
          </UnitPrice>
          <Description xml:lang="en">{{Description}}</Description>
          <UnitOfMeasure>{{UnitType}}</UnitOfMeasure>
          <Classification domain="{{ClassificationDomain}}">{{ClassificationCode}}</Classification>
        </ItemDetail>
        <Tax>
          <Money currency="USD">{{divide (multiply (multiply UnitPrice Qty) (substring TaxRate 0 4)) 100}}</Money>
          <Description xml:lang="en">{{TaxCode}}</Description>
        </Tax>
      </ItemOut>
      {{/each}}
    </OrderRequest>
            {{else}}
    <OrderRequest>
      <OrderRequestHeader orderDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" orderID="{{DocumentNumber}}" orderType="regular" orderVersion="{{SAP_Ariba_orderVersion}}" type="new">
        <Total>
           <Money currency="USD">{{add (subtract TotalAmount ShippingCost) TotalTaxAmount}}</Money>
        </Total>
        <ShipTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <DeliverTo>{{FirstName}}{{LastName}}</DeliverTo>
              <Street>{{ShippingAddress1}}</Street>
              <City>{{ShippingCity}}</City>
              <State>{{ShippingState}}</State>
              <PostalCode>{{ShippingZip}}</PostalCode>
              <Country isoCountryCode="{{ShippingCountryCode}}">{{ShippingCountry}}</Country>
            </PostalAddress>
            <Email name="default" preferredLang="en-US">{{Email}}</Email>
          </Address>
        </ShipTo>
        <BillTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <Street>{{BillingAddress1}}</Street>
              <City>{{BillingCity}}</City>
              <State>{{BillingState}}</State>
              <PostalCode>{{BillingZip}}</PostalCode>
              <Country isoCountryCode="{{BillingCountryCode}}">{{BillingCountry}}</Country>
            </PostalAddress>
          </Address>
        </BillTo>
        <Shipping>
          <Money currency="USD">{{ShippingCost}}</Money>
          <Description xml:lang="en-US">{{ShipVia}}</Description>
        </Shipping>
      </OrderRequestHeader>
      {{#each Item as |a|}}
      <ItemOut quantity="{{Qty}}" lineNumber="{{LineID}}">
        <ItemID>
          <SupplierPartID>{{Item}}</SupplierPartID>
        </ItemID>
        <ItemDetail>
          <UnitPrice>
            <Money currency="USD">{{UnitPrice}}</Money>
          </UnitPrice>
          <Description xml:lang="en">{{Description}}</Description>
          <UnitOfMeasure>{{UnitType}}</UnitOfMeasure>
          <Classification domain="{{ClassificationDomain}}">{{ClassificationCode}}</Classification>
        </ItemDetail>
        <Tax>
          <Money currency="USD">{{divide (multiply (multiply UnitPrice Qty) (substring TaxRate 0 4)) 100}}</Money>
          <Description xml:lang="en">{{TaxCode}}</Description>
        </Tax>
      </ItemOut>
      {{/each}}
    </OrderRequest>
      {{/compare}}
    {{/each}}
  </Request>
</cXML>

NetSuite purchase order cancellation to SAP Ariba Network purchase order cancellation

This flow syncs NetSuite purchase order cancellations to SAP Ariba Network purchase order cancellations.

Flow details

  • Export source: NetSuite
  • Import destination: SAP Ariba Network
  • Built-in export: Get NetSuite purchase order cancellations – get all purchase orders with status as closed from NetSuite that are modified since the last flow run time
  • Built-in import: Import SAP Ariba Network purchase order cancellations – add purchase orders cancellations into SAP Ariba Network by orderID
  • Built-in import: Import NetSuite purchase order cancellations – update purchase order cancellations into NetSuite with internalId as the lookup identifier
  • Dependency trackers: N/A

Before you begin

  1. Sync purchase orders in NetSuite with purchase orders in SAP Ariba Network.
  2. OrderId in SAP Ariba Network and Order # in NetSuite should be the same.
  3. The orderVersion of SAP Ariba Network purchase orders should be stored in the SAP ARIBA ORDERVERSION field (custom field) in NetSuite purchase orders.

Setup instructions

Configure mapping for PO CANCELLED IN SAP ARIBA (custom field) in Import NetSuite purchase order cancellations.

NSPurchOrdCanc.pngField mappings: Import NetSuite purchase order cancellations
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.2.042/cXML.dtd">
{{#each data}}
<cXML payloadID="IN.{{DocumentNumber}}.{{dateFormat 'x'}}" timestamp="{{dateFormat 'YYYY-MM-DDTHH:mm:ssZ'}}" version="1.2.042" xml:lang="en-US">
{{/each}}
  <Header>
    <From>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
      </Credential>
    </From>
    <To>
      <Credential domain="NetworkId">
        <Identity>{{connection.http.unencrypted.Supplier_NetworkId}}</Identity>
      </Credential>
    </To>
    <Sender>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
        <SharedSecret>{{connection.http.encrypted.Buyer_SharedSecret}}</SharedSecret>
      </Credential>
      <UserAgent>Celigo Integration</UserAgent>
    </Sender>
  </Header>
  <Request>
    {{#each data}}
    <OrderRequest>
      <OrderRequestHeader orderDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" orderID="{{DocumentNumber}}" orderType="regular" orderVersion="{{subtract SAP_Ariba_orderVersion 1}}" type="delete">
         <Total>
          <Money currency="USD">{{add (subtract TotalAmount ShippingCost) TotalTaxAmount}}</Money>
        </Total>
        <ShipTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <DeliverTo>{{FirstName}}{{LastName}}</DeliverTo>
              <DeliverTo>{{CompanyName}}</DeliverTo>
              <Street>{{ShippingAddress1}}</Street>
              <City>{{ShippingCity}}</City>
              <State>{{ShippingState}}</State>
              <PostalCode>{{ShippingZip}}</PostalCode>
              <Country isoCountryCode="{{ShippingCountryCode}}">{{ShippingCountry}}</Country>
            </PostalAddress>
            <Email name="default" preferredLang="en-US">{{Email}}</Email>
          </Address>
        </ShipTo>
        <BillTo>
          <Address>
            <Name xml:lang="en">{{FirstName}}{{LastName}}</Name>
            <PostalAddress name="default">
              <Street>{{BillingAddress1}}</Street>
              <City>{{BillingCity}}</City>
              <State>{{BillingState}}</State>
              <PostalCode>{{BillingZip}}</PostalCode>
              <Country isoCountryCode="{{BillingCountryCode}}">{{BillingCountry}}</Country>
            </PostalAddress>
          </Address>
        </BillTo>
        <Shipping>
          <Money currency="USD">{{ShippingCost}}</Money>
          <Description xml:lang="en-US">{{ShipVia}}</Description>
        </Shipping>
      </OrderRequestHeader>
      {{#each Item as |a|}}      
      <ItemOut quantity="{{Qty}}" lineNumber="{{LineID}}">
        <ItemID>
          <SupplierPartID>{{Item}}</SupplierPartID>
        </ItemID>
        <ItemDetail>
          <UnitPrice>
            <Money currency="USD">{{UnitPrice}}</Money>
          </UnitPrice>
          <Description xml:lang="en">{{Description}}</Description>
          <UnitOfMeasure>{{UnitType}}</UnitOfMeasure>
          <Classification domain="{{ClassificationDomain}}">{{ClassificationCode}}</Classification>
        </ItemDetail>
         <Tax>
          <Money currency="USD">{{divide (multiply (multiply UnitPrice Qty) (substring TaxRate 0 4)) 100}}</Money>
          <Description xml:lang="en">{{TaxCode}}</Description>
        </Tax>
      </ItemOut>
      {{/each}}
    </OrderRequest>
    {{/each}}
  </Request>
</cXML>

NetSuite vendor bill payment to SAP Ariba Network payment remittance

This flow syncs NetSuite bill payments to SAP Ariba Network payment remittances.

Flow details

  • Export source: NetSuite
  • Import destination: SAP Ariba Network
  • Built-in export: Get NetSuite bill payments – get all bill payments from NetSuite that are modified since the last flow run time
  • Built-in import: Import SAP Ariba Network payment remittances – add payment remittances into SAP Ariba Network with invoice ID
  • Built-in import: Import NetSuite bill payments – update bill payments into NetSuite with internal ID as the lookup identifier
  • Dependency trackers: N/A

Before you begin

  1. Sync NetSuite vendor bills with SAP Ariba Network invoices.
  2. Verify that reference numbers in NetSuite are the same as the invoiceID in SAP Ariba Network.
  3. The payment method in NetSuite bill payments and the payment method in SAP Ariba Network payment remittances should be the same.

Setup instructions

Configure mapping for Sent as Remittance to SAP Ariba Network (custom field) in Import NetSuite bill payments.

NSVendBillPayRemitt.pngField mappings: Import NetSuite bill payments
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.2.042/PaymentRemittance.dtd">
<cXML payloadID="IN.{{[Document Number]}}.{{dateFormat 'x'}}" timestamp="{{dateFormat 'YYYY-MM-DDTHH:mm:ssZ'}}" version="1.2.042" xml:lang="en-US">
  <Header>
    <From>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
      </Credential>
    </From>
    <To>
      <Credential domain="NetworkId">
        <Identity>{{connection.http.unencrypted.Supplier_NetworkId}}</Identity>
      </Credential>
    </To>
    <Sender>
      <Credential domain="AribaNetworkUserID">
        <Identity>{{connection.http.unencrypted.Buyer_AribaNetworkUserID}}</Identity>
        <SharedSecret>{{connection.http.encrypted.Buyer_SharedSecret}}</SharedSecret>
      </Credential>
      <UserAgent>Celigo Integration</UserAgent>
    </Sender>
  </Header>
  <Request>
    <PaymentRemittanceRequest>
      <PaymentRemittanceRequestHeader paymentDate="{{dateFormat MM/DD/YYYY  Date YYYY-MM-DDTHH:mm:ssZ timezone}}" paymentReferenceNumber="{{[Transaction Number]}}" paymentRemittanceID="{{id}}" status="new">
        <PaymentMethod type="{{[Payment Method]}}"></PaymentMethod>
        <PaymentPartner>
          <Contact role="payer">
            <Name xml:lang="en">{{Name}}</Name>
            <PostalAddress>
              <Street>{{[Billing Address 1]}}</Street>
              <City>{{[Billing City]}}</City>
              <State>{{[Billing State/Province]}}</State>
              <PostalCode>{{[Billing Zip]}}</PostalCode>
              <Country isoCountryCode="{{[Billing Country Code]}}">{{[Billing Country]}}</Country>
            </PostalAddress>
            <Email name="default">{{Email}}</Email>
          </Contact>
        </PaymentPartner>
        <PaymentPartner>
          <Contact role="payee">
            <Name xml:lang="en"></Name>
          </Contact>
          <IdReference domain="accountReceivableID" identifier="{{Number}}"></IdReference>
          <IdReference domain="accountType" identifier="{{[Account Type]}}"></IdReference>
        </PaymentPartner>
      </PaymentRemittanceRequestHeader>
      <PaymentRemittanceSummary>
        <NetAmount>
          <Money currency="USD">{{[Amount (Net)]}}</Money>
        </NetAmount>
        <GrossAmount>
          <Money currency="USD">{{[Amount (Gross)]}}</Money>
        </GrossAmount>
        <DiscountAmount>
          <Money currency="USD">{{[Amount Discount]}}</Money>
        </DiscountAmount>
      </PaymentRemittanceSummary>
      <RemittanceDetail lineNumber="{{[Line ID]}}">
        <PayableInfo>
          <PayableInvoiceInfo>
            <InvoiceIDInfo invoiceID="{{VendorBillID}}"></InvoiceIDInfo>
          </PayableInvoiceInfo>
        </PayableInfo>
        <NetAmount>
          <Money currency="USD">{{VendorBillAmountNet}}</Money>
        </NetAmount>
        <GrossAmount>
          <Money currency="USD">{{VendorBillGrossAmount}}</Money>
        </GrossAmount>
        <DiscountAmount>
          <Money currency="USD">{{VendorBillAmountDiscount}}</Money>
        </DiscountAmount>
      </RemittanceDetail>
    </PaymentRemittanceRequest>
  </Request>
</cXML>

 

Related articles

Comments

0 comments

Please sign in to leave a comment.