-
Cross Charges - is there any way to see the COGS in the buying subsidiary
Hi, i need to create either a saved search or report that could show the Sales Order revenue amount as well as the cost of sales coming from the IC cross charges for that SO. What is the best way to be able to report on that, to see the margin for each order? Thanks!
-
Multiple bills against a single purchase order (expense sublist)
Hi There Is it is possible to create multiple vendor bills against a single purchase order? The scenario: PO124 has 1 line on it totalling $100. The line is entered in the expense sublist. Bill 1A is billed against PO124 for $10. Bill 1B is received for the balance of $90. From what I can see, there is no option to bill…
-
Customer Refund EFT Batch
Hi There I am trying to create an EFT payment batch for all customer refunds. I have selected the approval routing for the payment batches and set this up in the bank account used to make refunds (screenshots from demo account) I have also set up the bank payment information for the customers who will be receiving a refund…
-
General Ledger
We are currently exploring options to identify contra entries for individual ledger rows, particularly in cases where a single voucher contains multiple line items: If we select a debit entry, we want to identify which account was credited against it. Conversely, if we select a credit entry, we want to see which account…
-
NSC | Resolve Error when deleting a Package
Scenario A user attempts to delete a pre-defined package but encounters the following error: “This record cannot be deleted, because it is referred to by other records.” Steps to Reproduce Navigate to Setup > Accounting > Shipping > Packages tab. Select a Package. Click Remove. Click Submit. Actual Result: The system…
-
I'd like to hide cost, EST. COST and total value of an inventory adjustment from certain roles
Hello, I am trying to block certain roles from seeing the value of an item, the total value of an item, the estimate cost, and the estimated value of the inventory adjustment, from certain roles when performing an inventory adjustment. I am in the customization of the transaction forms however I cannot seem to find the…
-
Parent Child Customer records - Guidance / Best practices
I've seen many posts about Parent-Child customer relationships, but none provide a complete definition of what actually happens in the application. Neither the Online Help, LCS nor Suite Answers offers a detailed explanation of how this works when configured—and you need to already know the right questions to ask to find…
-
NetSuite WMS Bin Sequencing: Sequence Number vs WMS Pick Seq No
I’m looking for clarification on the difference between the Bin Sequence Number and WMS Pick Seq No fields in NetSuite. Specifically, I’d like to understand: The functional purpose of each field Which one takes precedence during WMS wave generation and picking How bins are sorted when one of the fields is blank What the…
-
AE:Vendor statement
How to create the vendor statement along with prepayments(without applied prepayments)
-
WMS Mobile App: Add price when searching for inventory?
Hello I am curious if there's a way to display the price of an item on the WMS mobile app when performing an inventory search. We run a retail store and often times we have clients asking about prices of products and our staff has to go all the way to the cashier to ask
-
Updating shipping state and country in invoices by CSV
Hi everyone, I'm needing to update the shipping state and country address in invoices by CSV. Below are the columns in my CSV. The CSV runs successfully, and the two fields are updated except for Canada and Australia. Any ideas why it doesn't work for Canada and Australia and how can I update the invoices shipped to both…
-
landed cost
How to generate a sales report including landed cost in the purchase price?
-
change unrealized matching gain/loss to another account
Hi expert, i noticed there was "unrealized matching gain/loss" amount journal, so that i plan dont want to user that system account, by using ' Foreign Currency Variance Posting Rule" menu I want to have journal amount hitting to Destination Account, Please advice me what kind of "Criteria" that i should fill in ? regards…
-
NSC | G/L impact is not showing in Item Receipt
Scenario In NetSuite, users may encounter Item Receipts that do not display any General Ledger (GL) impacts, even when reviewing the transaction details. This can occur specifically with Non-Inventory Items for Purchase, leading to concerns about missing accruals or incomplete financial postings. Upon investigation, the…
-
Script to add serial numbers into Item Fulfillment inventory detail
Hi, I created a page that we scan the sales order, then the serial number and after that it creates the Item Fulfillment. I created a bodyfield (hidden) that set the serial number that i scanned. Then I created a user event script to grab that info and to inject it into the Inventory detail, but it is not working. The goal…
-
Error on Monthly Depreciation Run
Good day! Proposed assets were generated from Item Receipt records. As we run deprecation journals every month-end, we are receiving an error message, "MAP_Error: The following field(s) are inactive: Location". Locations are no longer in use and should be set to Inactive. We have already updated the Location in FAM records…
-
Enable Item Line Shipping - Fulfillment Has No Items
We have followed all set up for the line by line shipping (different addresses per line) and we see no Fulfillment. Tried the solution in article: https://suiteanswers.custhelp.com/app/answers/detail/a_id/30366/loc/en_US And no joy. This is a test order that we are trying. Our dev turn off all scripts related to shipping,…
-
Printing Pick Tickets in a bulk from Save Search
Hi. We have a save search "Pick Tickets to Print Today" This provide us the list of Sales Orders that need to print the Pick Tickets. Right now the user see the list of Sales Orders, Open each individual order and Prints the Picking ticket. There is a way to select all the Sales Orders on the list and select print all? Or…
-
Help with Shipped date field value on IF Saved Search
I created an IF SS to show the shipments that went out, and I am not able to pull the "Shipped Date" on a SS. that filed name is NOT in the SS drop down list for results, nor can I pull the field value using a formula {shippeddate} which is what the records browser shows the field name is. We do have MRP enabled. I am…
-
Demand Plan when loaded using script doesn't show next year's demand
Demand Plan when loaded using script doesn't show next year's demand, it shows results just for 2025.
-
Saved Search display customers with due invoices
Hello, we have a saved search to determine the due invoices of the customer. We want to show the consolidated details like only the parent customer will show but all the details are consolidated. Because we will associate it to a workflow. The workflow will send the email to the parent customer only.
-
International Tax Report on Non-One World Account
Good day, Community! Is it recommended to install the International Tax Report Bundle in a non-one world account? Will there be errors considering there's only one company? thank you!
-
WIP and Routing GL Impact
For some reason for my WIP and Routing module, when I do a Work Order Completion its pulling my Planned numbers and not using the actuals when I go to look at the GL impact. Can someone help with this issue?
-
Landed Costs included in Cost of Sale
Hi Everyone, I know I can create a landed cost report to detail the landed cost associated with an item receipt (purchase). However, I would also like to know the breakdown of landed costs associated with the item fulfillment (sale). Is there a saved search or report I can create that will help me understand the landed…
-
Is any ISO 20022 payment format available for Germany?
Hi all, as we trying to align the ISO20022 standard for EUR and other currency/multinational payment, seems the standard payment template under Germany localization only provided the SEPA and not a full ISO20022, can anyone help clarify if the pain.001 is not yet supported by NetSuite for other currencies in Germany…
-
Bank feed function is missing one account from account listing
Hello, we are trying to connect with Commerzbank for bank feed in order to perform subsequent reconciliation. however, although our bank portal shows 6 accounts, after we connected Netsuite with the bank under connectivity configuration, the bank record showing under the financial institution, but on the account/ account…
-
NetSuite Newbie in UK
Hey everyone! 👋 Are there any UK-based NetSuite users here? I’d love to hear how you handle VAT submissions to HMRC and what it’s like using NetSuite from a UK standpoint. I’ve mainly used cloud accounting platforms like Xero and Sage before, but this is my first experience with an ERP system, so any advice, tips, or…
-
Uncleared credit card transaction
I have a credit card transaction from a previous year that has never cleared. All reconciliations are up-to-date. I can't reverse the transaction or delete it as it will affect the previous year's financials. What is the best way to clear this transaction?
-
Decimal Quantity in Purchase Order
Can i enter a decimal number on quantity field in Purchase Order for both inventory and noninventory item?
-
Expected Ship Date Set Date Tracking
We have demand planning turned on and we are looking to see if NS can track the "Expected Ship Date" of the sales order line when the Sales Order is created. - It appears you can only see the date value set when you make a change in the Sales order line. Use Case SO line Expected Ship date set to 10/01/2025 on SO…