To handle inventory at a customer's site, I would setup a remote inventory location in NS for the customer that has your inventory (Setup - Company - Locations - New). Using an inventory transfer order, you will be able to ship (and return, if necessary) product to/from the customer's inventory location. When the customer…

Consignment Business from the Consignee's Perspective (Answer ID: 4441) provides a best practice document on how to handle consignment inventory. Your other requirements might require additional filtering. We currently have inventory in our warehouse consigned to us by several vendors. The best practice work okay; however,…

I understand each serial number has a value assigned to it. Does anyone have a way to add this assigned value to the customized view above OR any other method to get a report showing: Number - Location - On Hand - Inventory Number>Item - Inventory Value? [Number = serial number in this customized view]

I am an accountant so I am not sure I can help; but, I will give a couple of ideas. Is the creator (assuming you mean person) not in the field called "Created By"? I don't have subsidiaries; however, the system probably created an account in the GL called something similar to "Intercompany ....".

The above does not provide the same balances as when I run each month separately. This could be due to out of period dates. Still trying to cleanup old data and will try solution above when more data is cleaned up.

Yes - I can't type either - it is 23931. Balance Sheet to an accountant is the summary (total) of all activity from day 1 to end of accounting period selected. The problem with the report is it does not include transactions prior to the months you are wanting to print. I think you answered my question when you stated "a…

The above customize Valuation report gives the information requested, almost; however, the serial numbers print on one line. The serial numbers for the quantity on hand when the report is run and the maximum characters is 3,968, when downloaded. This limitation does not allow the download to include all serial numbers. Can…

Attached are the criteria and results screens. The field on the results page "Sales Order" is blank on the report. Any help would be appreciated. [ATTACH]n417549[/ATTACH]

Torin, thanks for your suggestions. I had tried everything that I thought would give the sales order number but nothing gives me the number. I tried the Sales Order of Deposit field "Document Number" again to make sure I had not missed something; but, the output shows "none". I did have to use Summary Type "Group" to get…

I have created a saved search based on Answer Id: 22423 and it provides what I need except I would like to see the sales order number associated with the deposit. The Document Number provides me with deposit number. How do I get the sales order number? Also, for Amount | Summary Type it states to use Average; however, the…

Update - My problem was considered a bug and was fixed by NetSuite by deleting the currency revaluation transactions.

I have a similar problem involving AR. Customer's AR balance in foreign currency (Canadian) is zero. Customer AR balance in USD is 20.00. Attempted to apply payment (write off) but since account is being displayed in Canadian dollars, the item is not shown. Can I use a journal, as outlined above, to resolve the issue? If…

Oliver - Thanks for your comments - I have reported my problem to NS now and they are working on it (Case# 2390565) if anyone has a similar problem, which is AR transactions in USD does not equal zero; but, transactions in Canadian currency equal zero. Could be something a user did but as of now NS has not indicated that…

Anything ever develop on this user group?