Tag: subsidiary

SuiteQL query to fetch the item details based on a subsidiary

Since we are unable to directly filter the item data using the subsidiary, we will have to use a modified version of the item query by joining the itemSubsidiaryMap table and subsidiary table to get the required results. SELECT item.itemid,item.id,item.itemtype FROM itemSubsidiaryMap  INNER JOIN item ON  (item.id=itemSubsidiaryMap.item) INNER JOIN subsidiary ON  (subsidiary.ID=itemSubsidiaryMap.subsidiary) WHERE subsidiary.id=${nsSubsidiary}

Unable to Edit Supplier Subsidiary for Vendor

After a transaction has posted for the vendor, you are not able to change the subsidiary selected on the vendor record. If you have NetSuite OneWorld, after you save the vendor record, you cannot change the primary subsidiary. According to NetSuite standards, once a transaction has been posted for a vendor, the subsidiary selected on… Continue reading Unable to Edit Supplier Subsidiary for Vendor

Filter Locations based on subsidiary in Subsidiary record

Set a field to choose a location in the subsidiary record. The list should display the locations of that particular subsidiary only. This can be achieved by creating a virtual field displaying the results of a saved search which provides the location values for that subsidiary only. Then the selected value is stored in the… Continue reading Filter Locations based on subsidiary in Subsidiary record

Print Subsidiary Fields on Transaction Printout on Advanced PDF/HTML Template

To print on any transaction (Sales Order, Purchase Order, Invoice etc.) a value of custom or standard field from Subsidiary record, users may use the ${subsidiary.fieldID] syntax rule for adding those fields on Advanced PDF/HTML Template.   Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF/HTML Template: Click Edit or Customize Upper right corner: Toggle Source Code Add the following syntax example at… Continue reading Print Subsidiary Fields on Transaction Printout on Advanced PDF/HTML Template

Resolve error: “Transaction subsidiary XXX is not valid for item XXX. Please choose a different item.”

User uses Global Inventory Relationship record in their Intercompany Cross-Subsidiary Fulfillment feature in NetSuite OneWorld account to fulfill orders and receive returns across multiple subsidiaries. On the creation of Sales Order, the user encounters an error upon saving a Sales Order supported by a Global Inventory Relationship: “Transaction subsidiary XXX is not valid for item… Continue reading Resolve error: “Transaction subsidiary XXX is not valid for item XXX. Please choose a different item.”

Locked and Closed Date for each Subsidiary

Navigate to Setup > Accounting > Manage Accounting Periods 2. Select the earliest Open Period 3. Click the Period Close Checklist icon 4. Click Lock A/R task icon 5. On the upper right corner, click Search 6. Click Create Saved Search button 7. Click Criteria 8. Click Standard Filter: Select Task Item Type: any of Lock All, Lock A/R, Lock A/p Note: For every required field, use the drop-down menu to select it and… Continue reading Locked and Closed Date for each Subsidiary

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

How to change the subsidiary Hierarchy

For changing the subsidiary hierarchy user should set the ALLOW SUBSIDIARY HIERARCHY TO BE MODIFIED [MAX: 30 DAYS] Got to set up> company> Genaral Preferences After setup a max date for the subsidiary hierarchy to be modified. Edit the subsidiary now the parent-subsidiary field is editable change the parent and click save. Please note the… Continue reading How to change the subsidiary Hierarchy