Author: Pranav Prakash

Limit allocation of inventory to a determinate period before or after the supply required by date

Allocation of inventory can be restricted by adjusting the respective Order Allocation Strategy. Open the order allocation strategy.  Under Allocation Period fields to limit the allocation of inventory by defining a specific period before or after the Supply Required by Date. To limit inventory allocation to the period after the Supply Required by Date, under Future Inventory Only, check… Continue reading Limit allocation of inventory to a determinate period before or after the supply required by date

Characteristics of “EXPECTED RECEIPT DATE” sublist field in purchase order item line.

When Demand Planning feature is enabled and the Replenishment Method is Time Phased, the Expected Receipt Date is found as one of the columns on the Purchase Order form. The Expected Receipt Date is computed based on the Purchase Lead Time field value on the Item record. It will be computed from the date of the purchase order. Consider the item record… Continue reading Characteristics of “EXPECTED RECEIPT DATE” sublist field in purchase order item line.

Restrict item fulfillment creation including bulk fulfillment action using user event script.

Item fulfillment creation can be restricted using client script in saveRecord entry point. Although item fulfillment can be created using bulk fulfillment. To restrict the item fulfillment creation including bulk fulfillment action, use the user event script below and deploy into item fulfillment.

Set Sales Order’s Supply Required by Date to current date according to account time zone via SuiteScript

var targetTime = new Date(); targetTime.setMinutes(targetTime.getMinutes() + targetTime.getTimezoneOffset()) let soRec = record.load({ type:’salesorder’, id:51451//internal is of sales order }); soRec.setSublistValue({ sublistId: ‘item’, fieldId: ‘requesteddate’, line: 0, value: targetTime }); soRec.save()

Creating a new allocation strategy

Navigate to Setup-> Order Management-> Order Allocation Strategy-> New Give a name for allocation strategy. If user wants future inventory for allocation, check the Future Inventory box given below. For example, inventory that is on order, in transit and not yet received. On hand inventory is always considered for allocation. If user is considering future… Continue reading Creating a new allocation strategy

Characteristics of Create PO and Create WO sublist fields in sales order

Create PO Create PO is a sales order sublist field that create purchase order automatically when user selects Drop Ship/ Special Order from the sublist field. After approving the sales order, the document number hyperlinked to respective purchase order will display there. Create PO will automatically set value as Drop Ship, if Drop Ship Item checkbox… Continue reading Characteristics of Create PO and Create WO sublist fields in sales order

Use Client script to get vendor bill id when vendor payment record is loaded.

Requirement is to get value of vendor bill id when vendor payment record is loaded. /** * @NApiVersion 2.x * @NScriptType ClientScript * @NModuleScope SameAccount */define([‘N/currentRecord’, ‘N/record’, ‘N/url’], /** * @param{currentRecord} currentRecord * @param{record} record * @param{url} url */ function (currentRecord, record, url) { /** * Function to be executed after page is initialized. *… Continue reading Use Client script to get vendor bill id when vendor payment record is loaded.