Tutorial part 5

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer
  • Begin by.

    Vorbereitungen

    Role required: sn_erp_integration.erp_admin

    Testing Your First Query

    1. Navigate to System Definition > Scripts - Background.
    2. Paste this test script:
      // Test script to query SAP Purchase Orders
       var gr =
              new GlideRecord('sn_erp_cp_procurement_purchase_order');
       gr.setLimit(5);
       gr.query();
      
       var errorMsg = gr.getLastErrorMessage();
       if (errorMsg) {
          gs.error('Query failed: ' + errorMsg);
       }
              else {
          gs.info('Query successful!');
          var count = 0;
          while (gr.next()) {
              count++;
              gs.info('PO: ' +
              gr.getValue('po_number') + 
                      ' - ' + gr.getValue('vendor_name'));
          }
          gs.info('Total: ' + count);
      
            }
    3. Click Run script.
    4. Check output - you should see PO data from SAP.

    Testing a Specific PO Number

    Now search for a specific PO (replace with your actual PO number):
    // Search for specific PO
     var poNumber =
            '4500123456'; // Replace with your PO
    
     var gr = new GlideRecord('sn_erp_cp_procurement_purchase_order');
    
            gr.addQuery('po_number', poNumber);
     gr.query();
    
     var errorMsg = gr.getLastErrorMessage();
     if (errorMsg) {
        gs.error('Query failed: ' + errorMsg);
     }
            else if (gr.next()) {
        gs.info('Found PO: ' + gr.getValue('po_number'));
        gs.info('Vendor: ' + gr.getValue('vendor_name'));
        gs.info('Amount: $' + gr.getValue('total_amount'));
        gs.info('Status: ' +
            gr.getValue('status'));
     } else {
        gs.warn('PO not found: ' + poNumber);
    
            }

    Prozedur

    Navigate to All > > .