Purchase orders (850) to NetSuite sales orders (add)

The sales Manager of an eCommerce manufacturer/supplier wants new purchase orders placed by the retailer to be synced to NetSuite. This is to ensure approval of the orders and pass along approved orders to downstream teams/departments for fulfillment and invoicing. Generates the purchase orders (EDI transaction 850) from the trading partner source to NetSuite as… Continue reading Purchase orders (850) to NetSuite sales orders (add)

How to re-open a Closed Purchase Order?

As long as you can still edit the Purchase Order, to re-open a closed Purchase Order, just edit the Purchase Order and clear the Closed column in the Item lines. You will get the pop-up message “Items on this line have been received and billed. Are you sure you want to modify this item?” if the Purchase Order has related records. Just click Ok to proceed.

To display Sale Price, Amount & GP on Requisition & PO on button click

To display Sale Price, Amount & GP on Requisition & PO on button click define([‘N/record’, ‘N/search’, ‘N/currentRecord’, ‘N/url’], function (record, search, currentRecord, url) {     function pageInit() {     }     /**      * @description Function to check value      * @param {*} parameter      * @returns boolean  … Continue reading To display Sale Price, Amount & GP on Requisition & PO on button click

Linking Purchase Orders to a Vendor Bill using orderline and orderdoc

This approach is to send a vendor bill initialize request that references one or more purchase orders by id. The initializeResponse returns itemList and expenseList data from the referenced purchase order(s). This data includes orderDoc and orderLine field values that together provide a unique identifier for each line item. You can then send a vendor… Continue reading Linking Purchase Orders to a Vendor Bill using orderline and orderdoc

Scheduled integration of Item Receipt (IR) Sync from multiple TrackTraceRX to NetSuite

Scheduled integration of Item Receipt (IR) Sync from multiple TrackTraceRX to NetSuite define([‘N/record’, ‘N/search’, ‘N/format’, ‘N/config’, ‘../../Common Library/jj_tracktracerx_ns_utility.js’, ‘../../Config Module/jj_cm_tracktracerx_api_config.js’],     /**      * @param{record} record      * @param{search} search      * @param{format} format      * @param{config} config      * @param{jjUtil} jjUtil      * @param{TrackTrace} TrackTrace    … Continue reading Scheduled integration of Item Receipt (IR) Sync from multiple TrackTraceRX to NetSuite

Centralized Purchasing and Billing

The Centralized Purchasing and Billing feature enables you to receive orders and fulfill vendor returns across multiple subsidiaries and locations. This simplifies the procurement workflow, makes the item receipt process more flexible, and avoids unnecessary transfer of orders between locations. After you enable the Centralized Purchasing and Billing feature, you are not limited to receive… Continue reading Centralized Purchasing and Billing

Resolving Subsidiary Discrepancies in Item Receipts for Purchase Orders

When processing a Purchase Order (PO) in NetSuite, an issue may arise where the subsidiary on the Item Receipt (IR) does not match the subsidiary specified on the PO. The root of the issue lies in how NetSuite handles the subsidiary information when an Item Receipt is created. Specifically, the IR displays the subsidiary at… Continue reading Resolving Subsidiary Discrepancies in Item Receipts for Purchase Orders

Centralized PO generation

Requirement: The desire is to have the PO under the parent sub and items will be shipped to a designated location in a child subsidiary? Solution: Enable the Centralized Purchasing and Billing feature. Here’s an example, created a Purchase Order for a Vendor under my Parent Subsidiary and added the target subsidiary (child) and location of… Continue reading Centralized PO generation

Create Item Receipt for a Purchase Order from a payload that contains respective item details.

Let the variable requestBody contains the payload. Sample payload. {   “purchaseOrderPONumber”: “65416981”,   “item”: {     “items”: [       {         “itemId”: “114579”,//item internal id         “line”:”1″,         “quantity”: “99”,         “rate”: “1.00”       }    … Continue reading Create Item Receipt for a Purchase Order from a payload that contains respective item details.