Jim, Unfortunately to capture your shipping that you pay you need to enter a line item on your bill to record it. It would be fantastic if there was a shipping charge on each vendor bill line item so it can be associated with the item being purchased/drop shipped or the equivalent of what is done on a sales order.

Rich, I just submitted a defect that may be similar. When I run my KPI for Inventory I get one value but when I click that value the Inventory Valuation Summary displays a different value. My results for same date last year is off by almost 60% and my current is off by a few percent. Problem is worse because our CEO just…

We do almost exactly as @khultquist states when we send raw bar rail tubing to be powder coated. 1) We purchase the raw tubing and have it shipped to our powder coating vendor. We use multi-location inventory so we see how much unfinished tubing exists at vendor 2) We have a non-inventory item that we purchase that…

Mike, If I recall the average cost comes from Item Receipts and Inventory Adjustments. Also if you do a cash refund (with a quantity greater than zero) without doing the authorize return it implies that a return happened and (I believe) it uses the refunded amount as the cost to go back to stock. If at any time the…

Oh, and for the point it went to zero, start figuring your average cost from the last time it was at zero. No sense going any further back than that.

And you can limit which PDF by the transaction form. Create PO Form for each location and point that to the users by role or name. At top header of form customization you select the PDF layout to use. Select the one with the proper hours layout.

actually I have done it before many times. I assume you know the Item List trick, filtered to the same item type, clicking an inline editable field, scrolling to the end and holding you shift key down to highlight all. Then select delete from left? This also assumes there are NO transactions against any of the items. You…

Yes, via script I am assuming originally you were doing all records? Narrowing to just the child records would hopefully help. Just sent you a PM.

I actually removed all the online price level entries with csv and it worked perfectly. Just not on base price. I am waiting till after 2011-2 tonight to see if there are changes.

Marty, In a heartbeat. Steve's service is extremely reliable, the dashboard gives all the information we need. Only time we have had an issue in last 3 years was caused by amazon. Besides being very efficient, it is also VERY inexpensive compared to the competition. You will also find a large following of users here who…

Interesting thought. We automatically bring the orders into NetSuite via FarApp and they come into the system pending fulfillment and are automatically billed. We have a pre-processing script that verifies a set of rules like $ amount, number line items, are there drop ships, international, etc. If it meets our rule base…

We use FarApp to import all of our storefront orders from Amazon into NetSuite. Highly recommend them! We did know the percentages ahead of time and not all of our items are candidates for FBA because of oversize fees and competition. My problem is how to track the fees back to the sales order/cash sale. Drop me a private…

His problem may be in calculating the total charges. The per item and per order should be OK. It is the weight that may be an issue and the fact that we don't know actual charges until we get our statement.

Marci, I posted this same questions over in the Best Practices section 3 weeks ago and got no response. I am going to link to you here just in case. https://usergroup.netsuite.com/users/showthread.php?t=27669 Considering NetSuite started life as an accounting system, there has got to be a way to include a services fee when…

Update: Running through the Inventory Item Mass Update did fix my problem. We had over 10,000 child records from 3,000+ parents and doing individually would have been painful.

Sorry about that. We are an e-commerce business and rarely create invoices. Thought the value worked there also. I went in to Print Packing Slips and got same result as you. There must be something in General or Accounting Defaults...

Set Preferences General TAB Number of Rows in List Segments Change to something higher From the help: When you look at a long list in NetSuite, the list is divided into segments. Enter the maximum number of records you want in each segment. For example, if you have 200 customers and you would like to see them in groups of…

What Scott said... We make sure that the non-inventory item is set to hit a revenue account the represents restocking charges.

What error are you getting? I just entered a po with an item at zero cost and did not receive an error when saving.

Yes, our way to do this without scripting is to create the KIT items that consume our normal item number. We have not tried using groups for anything yet.

This may be WAY overkill but we have 10 customers with the same requirement. 1) First we created a custom field on the item record that represents the SKU# which for normal everyday items we sell to everyone else contains the normal item number we sell the part as 2) When a customer requires their item number we create a…

This is an example I posted in another thread about oracle SQL and my hopes to use in criteria the rank of a record to limit what is returned. <quote http://www.orafaq.com/faq/how_does_o...s_from_a_table Actual excerpt: From Oracle 9i onwards, the RANK() and DENSE_RANK() functions can be used to determine the TOP N rows.…

Corey, Send the data as excel or CSV and the row number limits still apply. I have to do the same. I started a thread under reporting to see if NetSuite can use either Rank or Dense_Rank on criteria to no avail so we were force to use Excel files in some cases.

Unfortunately the Item Fulfillment hits COGS account and not the Samples Expense..

Thanks. Yes, currently have only a few locations. Our inventory that we have in on consignment should be easier but we also have our consigned inventory out at our customers that we need to also track. will be fun...

I am curious if either of you have found a solution to track consigned inventory

I just posted a bug request (again) for this. By specifying zero quantity we cannot track exactly what we are refunding for. Maybe we shipped a dozen bottles of bitters and 1 broke. I don't want it back yet I want to document on the refund that I am giving credit for one. Maybe 2 of an item were received dented and I want…

Well, If you are creating a stand alone Cash Sale (not starting with a Sales Order), there will be NO fulfillment. When you create a cash sale, add the shipping cost on the now visible shipping tab. Save it and display the GL impact under actions.

It's would not have a GL impact in a custom field. Is the amount FedEx sending you what the customer actually paid? The use the Shipping Cost field. Are you starting with a Sales Order (and doing a fulfillment) or just recording in a CashSale/Invoice?

options/thoughts... I am betting the Shipping Tab is hidden on your cash sale. Customize the form and go to the TABS subtab. There is a Shipping Cost field there that will actually hit GL impact.