You might be able to export a few items from your live account and use CSV to import them into your sandbox?

Depends on what your updating. For pricing updated. We created temporary "future price" price levels. Then it takes a few days to import all the pricing into the future price. But then when its time to go live we use the swap price levels function and we get the new pricing live quickly.

cost is the posting cost to your balance sheet. Adjusting that is not easy or safe. I use FIFO so that cost is calculated on the Item Receipt of that items that are in stock.

Is each kit a quantity of 8 of a single item or a group of multiple items? Another idea is to use "unit or measure" for a "case" and setup quantity pricing scheduled. I think you have to use the items number not its internal ID.

I have 10 people entering orders at the same time, We use Auto Generated numbers, so we don't get a sales order number until after the order is saved. Never get a duplicate.

2. we have a script the deletes forecast orders that are older then today. 3. I would enter an unapproved PO for the "quote" who's getting the quote from the suppler? the sales man or the purchasing agent? Maybe things can be done with lots of hard work and scripting.

A few ways to do it: Use the discount item on the sales order, There is 2 ways to use a discount item one from the discount dropdown on the sales order. Another way is to add the discount line item, but doing the GL impact is not as clean as it only applies that discount to the one item above it. Its possible to use a…

Option 2 is also not bad, you can do a mass update to update all your customers to "custom" then set it so when new customers are made they are set to custom. Do you have scripts or workflows to make sure your not discounting the items more then you want to? We currently have 21 price levels, plus a few items have quantity…

Can you explain better how this vendor pricing works. Scripting it might be a good way. I have one vendor that has an odd pricing model so I ended up making 3 vendors and selecting the correct vendor on the SO or PO makes the correct price show.

Normally there is Sales order, Item fulfillment and Invoice all linked together. But its possible to go and make an invoice with out those links. or some times the link between the sales order and the invoice get broken if some lines are edited. If the invoice is not linked, it will effect the inventory. But normally its…

Base price needs to have a zero and not be blank for you to get a zero by default.

You can add your own price levels with your own name's. Then set the customer records and define an price level for the customer. Then when entering a sales order, step one should be selecting the customer. Then the items will default to that price level. Now if for some reason the customer is set to "price level F", but…

You are new to netsuite. If the invoice is for services you should be ok, but If an invoice is for an item its more common to create an invoice from a sales order then make an invoice by its self. For a single transactions with items its normal to have sales order, item fulfillment, invoice, payment.

You might also want to look if you have invoices that are standalone. Those invoices will effect your inventory,

Serialized items can't be set to average cost, the only costing method is called "specific" But NetSuite does still have a field for average cost.

are you looking at the fulfillment's GL impact?

I use Item Groups, and I don't print members on the invoice.

You might be able to set some default that might speed up the process.

I make a new customer for every customer. On the sales order screen on the customer field, you can click new. I have slightly customized this "pop-up customer form" to include some of my custom required fields. and hide any field I do not require. I can normally take a new order for a new customer for a single item in…

in NY zip codes dont work 100% From https://www.tax.ny.gov/pdf/publications/sales/pub718.pdf Publication 718 "Reporting codes, rather than ZIP codes, should be used for identifying customer location. (Postal zones usually do not coincide with political boundaries, and the use of ZIP codes for tax collection results in a…

Is the ship to zip code a separate field compared to the ship to address field? I am trying to import orders via web services and having a hard time getting the tax correct.

I am not sure about City, But I know in New York State, the State collect's 4% tax and each county collects its own sales tax.

Tax rates are confusing. Like in NY some clothing is taxed at a lower rate then other items. And then some items are not taxed at all.

Have you fixed this problem? Was shipping a line item or using the shipping field on the transaction?

Item Groups might work better as each member item would be listed on the sales order and create a PO for each item.

try re-selecting the customer.

On the item record does it show the correct average cost? Double check your item receipts, and there impact on the inventory account.

I had a similar question https://usergroup.netsuite.com/users/showthread.php?t=18786

is it rounded on the sales order? is it rounded on the line or just on the total?

most people dont have "cash" in amounts less then a penny. Are you using credit cards? do they allow fractions on the credit cards?