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
Tag: item receipt
Restock Drop Ship Sales Returns using RMA
Scenario User would like to know how an Item marked as Drop Ship can become part of Inventory once a customer returns that Item Solution On the Sales Order page, click the Authorize Return button. In the Return Authorization page, users have the option to set it to either Pending Receipt or Pending Approval. The Drop Shipment Column will automatically be checked when users click the Authorize Return on the Sales Order page. If… Continue reading Restock Drop Ship Sales Returns using RMA
Map/Reduce Script to Update Landed Cost In IR record using CSV Custom Import
The client needs to update the landed cost template at line level in IR record using a CSV file. We have created a map/reduce script to update the values.
Get receipt and bill internal ids of purchase order using Suitescript.
Disable Item line fields in Item Receipt record based on a particular role.
Enable the RECEIPTS item line field in vendor Bill record.
There is an item line level field in respective purchase order named MATCH BILL TO RECEIPT. Check the checkbox and the RECEIPTS line level field will be enabled.
No GL Impact for Item Receipt
Issue – For the Item Receipt there is no GL impact showing. The corresponding purchase order has a rate specified. Solution – Check the inventory valuation report. If the Item Receipt shows zero value in both GL Impact and Inventory Valuation Report is that the Purchase Order Item Rate field was originally populated with zero… Continue reading No GL Impact for Item Receipt
SuiteScript to check whether the purchase order is fully received.
Here if purchase order is fully received true will be returned. Else, false will be returned.
Reverse Shipped Sales Order and Received Purchase Order
Requirement: Reversing sales orders that have been shipped but not invoiced, as well as those that have been shipped and invoiced. We will also explore the scenario of reversing a purchase order that has related transactions. Solution: In NetSuite, there is no standard functionality for reversing sales orders that have already been shipped. As an… Continue reading Reverse Shipped Sales Order and Received Purchase Order
Cost of Sale adjustments
Cost of Sale adjustments