Tutorial part 5
Begin by.
Antes de Iniciar
Role required: sn_erp_integration.erp_admin
Testing Your First Query
- Navigate to System Definition > Scripts - Background.
- 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); } - Click Run script.
- 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);
}Procedimento
Navigate to .