Supply Chain Snapshot

The internal ID for this record is supplychainsnapshot.

The Supply Chain Snapshot record is available only when the following features are enabled:

• Multi-Location Inventory

• Advanced Inventory Management

• Demand Planning

• Supply Chain Control Tower

Use the Supply Chain Control Tower feature in your NetSuite OneWorld account to simulate inventory supply and demand across your supply chain. These simulations, or Snapshots, are used to analyze whether inventory levels are in line with demand or planned levels. This feature can help you to juggle how to match customer requests with supply availability.

For help working with this record in the UI, see Supply Chain Control Tower.

See the SuiteScript Records Browser for all internal IDs associated with this record.

See Supply Chain Snapshot Record Actions for actions associated with this record. For more information about actions and macros, see Overview of Record Action and Macro APIs.

Supported Script Types

The Supply Chain Snapshot record is scriptable in both client and server SuiteScript.

Supported Operations

The Supply Chain Snapshot record can be created, read, edited, deleted, and searched using SuiteScript. It cannot be copied.

Usage Notes

Supply Chain Snapshot details are based on a saved search. The record is scriptable in the same way that saved searches are scriptable. Because it is a snapshot of transactional data, you can refresh this view or run the snapshot details search as needed.

There are two types of saved searches that are associated with Supply Chain Snapshots:

• Supply chain snapshot details search – This is the line-by-line information as displayed by the snapshot record.

• Supply chain snapshot search – This is header-level information such as replenishment method, future horizon date, and past horizon date.

Field values on the record header can be set using scripts. Some fields are read-only or have special behaviors. Please see the table below for details.

The following are applicable elements of the Supply Chain Snapshot record:

Fields

Additional Notes

• You can use the SuiteScript saved search API (the N/search module in SuiteScript 2.x) to script supply chain snapshots.

• Type is 'supplychainsnapshot' for searching general snapshot record info (header-level fields).

• Type is 'supplychainsnapshotdetails' for searching line-level snapshot data.

• Search can be customized. Searches of 'supplychainsnapshot' correspond to header fields, as shown in the table above. Searches of 'supplychainsnapshotdetails' access the transactional data in the details table, such as the following:

  • item, subsidiary, location, date, sourcetype (Source), docnum (transaction), status, invbalance (Inventory Balance), demandqty, supplyqty, purchaseorderqty, salesorderqty, transferorderqty, workorderqty, otherdemandqty, othersupplyqty

  • This above list includes labels in parentheses for potentially confusing column identifiers.

• Scripts can be scheduled. Additional logic in these scripts is flexible. For example, it is possible to automatically analyze the inventory balance for an item to see if it is expected to be underwater, and then complete specific actions like creating purchase orders.

• You can use an automated script for refreshing your supply chain snapshots. For example, every Sunday you could run a script to refresh all snapshots.

• It is your responsibility to build, maintain, and export snapshot data to match your needs.

Code Samples

The following sample shows how to create an item and set the future horizon to 10 days.

          var item = record.create({
    type: record.Type.INVENTORY_ITEM
}); 
item.setValue({
    fieldId: 'itemid',
    value: 'SS item test'
}); 
item.setValue({
    fieldId: 'taxschedule',
    value: '1'
}) 
item.setValue({
    fieldId: 'futurehorizon',
    value: '10'
}); 
var itemId = item.save(); 

        

The following sample shows how to generate snapshot for that item with past horizon of 14 days.

          var snap = record.create({
    type: record.Type.SUPPLY_CHAIN_SNAPSHOT
});
snap.setValue({
    fieldId: 'item',
    value: '7'
}); 
snap.setValue({
    fieldId: 'pasthorizon',
    value: '14'
}); 
var snapId = snap.save(); 

        

The following sample shows how to refresh the snapshot for an item with a past horizon of 7 days.

          var loadSnap = record.load({
    type: record.Type.SUPPLY_CHAIN_SNAPSHOT,
    id: snapId,
    defaultValues: true
});
loadSnap.setValue({
    fieldId: 'refresh',
    value: 'T'
}); 
loadSnap.setValue({
    fieldId: 'pasthorizon',
    value: '7'
}); 
loadSnap.setValue({
    fieldId: 'memo',
    value: 'updated ss memo'
}); 
var recID = loadSnap.save(); 

        

The following sample shows how to create a saved search for a snapshot record.

          var mySearch = search.create({
    type: search.Type.SUPPLY_CHAIN_SNAPSHOT,
    title: 'Snapshot header search for test item2',
    id: 'customsearch_scct',
    columns: [{
        name: 'item'
    }, {
        name: 'memo'
    }, {
        name: 'daterun'
    }],
    filters: [{
        name: 'item',
        operator: search.Operator.IS,
        values: itemId
    }]
});
var customsearch_scctId = mySearch.save(); 

        

The following sample shows how to create a saved search for snapshot details.

          var mySearch = search.create({
    type: 'supplychainsnapshotdetails',
    title: 'Snapshot details search for test item2',
    id: 'customsearch_scct_details',
    columns: [{
        name: 'docnum'
    }, {
        name: 'location'
    }, {
        name: 'invbalance'
    }],
    filters: [{
        name: 'item',
        operator: search.Operator.IS,
        values: itemId
    }]
});
var customsearch_scct_detailsId = mySearch.save(); 

        

The following sample shows how to load a search for snapshot record.

          var loadSearch= search.load({
    type: search.Type.SUPPLY_CHAIN_SNAPSHOT,
    id: 'customsearch_scct'
}); 

        

The following sample shows how to load search for snapshot details.

          var loadSearchDetails= search.load({
    type: 'supplychainsnapshotdetails',
    id: 'customsearch_scct_details'
}); 

        

General Notices