How can I display Item Average Cost, Purchase Price and Last Purchase price in base Unit

AI generated answer (using internal Slack threads):

To display Item Average Cost, Purchase Price, and Last Purchase Price in base Unit, you can use the SuiteScript API to get these values from the item record. Here is a sample code snippet that demonstrates how to do this:

javascript
var itemRecord = record.load({
    type: record.Type.INVENTORY_ITEM, 
    id: 'your_item_id'
});

var avgCost = itemRecord.getValue({
    fieldId: 'averagecost'
});

var purchasePrice = itemRecord.getValue({
    fieldId: 'cost'
});

var lastPurchasePrice = itemRecord.getValue({
    fieldId: 'lastpurchaseprice'
});

log.debug({
    title: "Item Details",
    details: "Average Cost: " + avgCost + ", Purchase Price: " + purchasePrice + ", Last Purchase Price: " + lastPurchasePrice
});

This script loads the item record, then retrieves the values of the 'averagecost', 'cost', and 'lastpurchaseprice' fields. The values are then logged for debugging purposes. Please note that the 'averagecost' field is in stock units, while 'cost' and 'lastpurchaseprice' are in purchase units. If your item uses units of measure, you will need to convert these values accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******