Hi, I'm not sure how it works exactly, but in my account that checkbox is checked. I suggest testing it out with different settings and test orders to see how it works.

I've never seen that setting, NS will use the vendor price on the item record. But you could script it in many different ways... like you proposed or you might be able to update to the vendor price on the item record via schedule or user event, when a new purchase price is entered on a po.

Try setting your values to the record object. For example instead of nlapiSetFieldValue('entity',3415); use recQuote.setFieldValue('entity',3415);

I think you are asking about sorting a sublist by line numbering? If so, check out this thread https://usergroup.netsuite.com/users/showthread.php?t=27043&highlight=line+numbers&page=2

In our instance, NS uses the receipt date to find the exchange rate. The fx on the PO is an estimate, but never gets used. Try back-dating a test receipt and see if its the same for you. Maybe there is a setup option to change this, not sure.

I had problems like this (see this thread) and it turns out that the user's language settings influence the printed form. Hopefully this helps you.

You can adjust the rate when you receive the order, and this would be a pretty easy script to write to get the fx from the PO and change the receipt fx.

From Sales Orders, you can use fields from fulfillments and invoices: Fulfilling/Receiving Transaction Fields... Billing Transaction Fields... find the month of the transaction using SQL formulas, and then subtract them and if the difference is 1 then it matches. Not a simple search, but doable. One thing to watch for…

I don't know of another way to do it, I don't think there is a lot of flexibility with the due dates. Perhaps on your bank and finance reports you could use the 'Date Created' instead of the 'Date'?

manually change or script the invoice date (forward-date the invoice to the last day of the month) and then use 60 days.

Yes, all SO and payments and a lot of others will be in the main/details tables. There's a good list here: https://system.netsuite.com/help/helpcenter/en_US/Output/Help/SuiteFlex/WebServices/STR_Transactions.html#1007039 I'm not sure about unpaid receivables, if this is stored in a record or calculated from open…

There's a help page with all the tables listed here: https://system.netsuite.com/help/helpcenter/en_US/Output/Help/DashboardsSearchesReports/EnterpriseViews/ViewTables_Tables_of_ODBC_Views.html?NS_VER=2011.2.0 Sales orders will be under 'Transactions' Hope this helps.

You can set up a new 'Ship Item' without tax, and use this for CA. That part is easy. Are these web orders, or are you entering them? Depending on how that, to implement it you could run a scheduled search, write a script, or maybe make a workflow. The scheduled search would be pretty easy to do, just look for shipments to…

One idea: You can use an Assembly Item for Item B, with members Item A and Item C (a non-inventory part for purchase). Then purchase Item C from the vendor, and make an assembly build when it is "received". The assembly build will use up inventory of Item A.

We created a custom field called "Need By Date" for each line item, to help us track this. Then through search/report we can find out what's late.

Pete - I think you should consider scripting it, I sent you a PM.

Yeah that wasn't well worded... I mean a custom record that uses your existing 'Category' list record, and a value for the markup. Then you have to lookup the value in this custom record. Alternatively you could hard code the markup into the formula like this {cost}/(1- CASE WHEN {category} = 'Bulk Cable' THEN 0.4 WHEN…

If you have a table of markups like this Category Markup Bulk Cable .40 Parts .25 Packaging .30 You could create a custom field called 'Minimum Price' in the item record. The field would be a formula something like this {cost}/(1-{markup}) And then you can (I think) have this custom field shown on the Sales Order item list.

I don't think you can remove qty breaks via CSV, if that's what you are after. You would have to set the price to the same amount for each qty, and then maintain two levels (you could make a saved search to find discrepancies). There may be ways with script, mass update, or web services to remove qty breaks. Whenever I get…

I just ran into this on Invoices... we needed to split up lines on Invoices based on Lot Number, so we manually adjusted them. These were invoices created from fulfillments: Qty Item Lot 100 XYZ Lot1(70), Lot2(30) turned into this Qty Item Lot 70 XYZ Lot1 30 XYZ Lot1 But now there are 30 less pieces in inventory. It's hard…

I thought about doing this with quotes too, this is what I mapped out in my head: Every time the quote is opened in 'Edit Mode', the record number is analyzed with a script, parsing for '-'. When the script finds the '-' it adds 1 to the value after. If it doesn't find '-' it adds '-1' the the record number. Creation:…

You'll want to check with the EDI provider. Do you have to select your lot number on the SO, can you do it on the fulfillment?

We automatically enter Lot Numbers on Fulfillments, if only 1 is available (same thing with Bins). It's done through a script that loads a saved search, more details are here: https://usergroup.netsuite.com/users/showthread.php?t=26614&highlight=bins You would have to build a search that will get you what you need, based…

We have a custom record that tracks the customer, item, and has a field called 'customer part nunmber'. It's pretty straightforward and with some scripting you can get it to auto populate on sales orders.

This sounds like a candidate for matrix item. Outside of the scope of NetSuite... I'm wondering why you even bother to stock every 1 mm, why not just stock every 2 mm?

You could do this from a saved transaction search, should work criteria type = so status = all open types qty - qty fulfilled >0 item:back ordered >0 and to get your criteria about "I don't want one if the backorder value goes from 1 to 11 or the like" you could set up a formula: item:back ordered - qty <0 You might have…

I meant use the matrix for the spokes -- but with the length, size, and color as options, it would be too complicated to track inventory in NetSuite. Putting my mfg engineer hat on... can you just have 1 NS inventory item called 'Spoke' and then control the actual inventory thru Kanban? (assuming that spokes are a small…

Sounds like you need a saved search on a scheduled script.

We had the same thought, but it's either all or none in standard NS. The way around it is a user event script for invoices that sends an email. If you're interested here's the code we use. You need to add a check box to the customer record called 'custentityemail_invoice_checkbox_cust' function afterSubmit(request,…

This is pretty simple with a Client SuiteScript. You'll want the script to fire on the changing of the customer (entity) field. Create and save a javascript file in your file cabinet. The script should look something like function fieldchange(type, name) { if (name == 'entity') { customer_id = nlapiGetFieldValue('entity');…