Month: November 2022

Change Values in the Revenue Recognition Plan when values changed in the Subscription Line

User will create subscription records in NS for Service items for Sale. Eg: Dakota Studio. In these Service item’s records, Hold Revenue Recognition checkbox will be checked. After creating a subscription record, User will run the bulk processing page- Update Revenue Arrangements and Revenue Plans to create Revenue arrangement and Revenue plan records. In the… Continue reading Change Values in the Revenue Recognition Plan when values changed in the Subscription Line

Convert Array to CSV

/** * Converts a value to a string appropriate for entry into a CSV table. E.g., a string value will be surrounded by quotes. * @param {string|number|object} theValue * @param {string} sDelimiter The string delimiter. Defaults to a double quote (“) if omitted. */function toCsvValue(theValue, sDelimiter) { try { var t = typeof (theValue), output;… Continue reading Convert Array to CSV

Divide Array to Chunks

/** * Dividing into array of arrays. * @param array Array to be divided * @param size length of trimmed array * */ function chunkArray(array, size) { try { let result = [] for (let i = 0; i < array.length; i += size) { let chunk = array.slice(i, i + size) result.push(chunk) } log.debug(‘result’,… Continue reading Divide Array to Chunks

Item search for getting available Bins for an item

/** *@description Available bin search – This function will return object of bin name and their quantity * @param itemName Name of the item * @return {Object} */function availableBinSearch(itemName) { try { var itemSearchObj = search.create({ type: “item”, filters: [ [“name”, “is”, itemName.toString()], “AND”, [“inventorydetail.binnumber”, “noneof”, “@NONE@”], “AND”, [“binonhand.quantityavailable”, “greaterthan”, “0”] ], columns: [ search.createColumn({… Continue reading Item search for getting available Bins for an item

Transfer Order partial fulfillment

/** * Transform TO to IF (partial and fully) * @param toInternalId * @param inventoryDetail * @return {Object} */ function transformTransferOrder(toInternalId,inventoryDetail) { var functionReturnObj = {} try { var errMsg; var itemFulfilment; try { var itemFulfilmentObj = record.transform({ fromType: record.Type.TRANSFER_ORDER, fromId: toInternalId, toType: record.Type.ITEM_FULFILLMENT, }); itemFulfilmentObj.setValue({ fieldId: ‘shipstatus’, value: ‘C’, ignoreFieldChange: true }); let itemCount=itemFulfilmentObj.getLineCount({sublistId:’item’})… Continue reading Transfer Order partial fulfillment

FIXED ASSET MANAGEMENT – ASSET TRANSFER

The Fixed Assets Management SuiteApp enables you to transfer simple and compound assets across asset types, subsidiaries, classes, departments, or locations.    You will not be able to transfer the Asset Type at the same time as the Subsidiary, Department, Class, or Location. The Subsidiary, Department, Class, Location, and Asset Type fields on the Asset Record… Continue reading FIXED ASSET MANAGEMENT – ASSET TRANSFER

Automated Cash Application

The Automated Cash Application feature enables you to automatically generate a batch of customer payments in NetSuite and apply them to open invoices. The generated customer payments are then automatically matched and cleared in the system. The Automated Cash Application feature automatically generates customer payments in NetSuite from imported bank lines, and then applies those… Continue reading Automated Cash Application

Item Location Configuration search

// search for item location configuration using itemid and get the supplytype of the location function itemLocConfigSearch(itemId){ try { let supplytypeItemobj = {}; let itemSearch = search.create({ type: record.Type.ITEM_LOCATION_CONFIGURATION, filters: [ [‘item’, ‘is’, itemId] ], columns: [ search.createColumn({name: “supplytype”, label: “Supply Type”}) ] }); let searchResultCount = itemSearch.runPaged(); searchResultCount.pageRanges.forEach(function (pageRange) { let myPage = searchResultCount.fetch({… Continue reading Item Location Configuration search