3941977

The saga goes on. I have got GP calculations going when a salesperson enters a sales order, however I am now running foul of the processing points - I had thought I'd get away with this one. I read somewhere that you can do unlilmited searching client side so I decided to do all my GP calcs client side. While it appears…

You can get the total value and quantity on hand using a client-side or server-side script. This allows you to calc average cost. In the case of Kits and BOMs total value is not available. Instead, you use the custom field OR you can store a list of member items and source in the total value and qoh of these. However, I…

It gets worse - I've tried running the script for all items. When I save or edit a kit with members rec.getLineItemCount('item') returns -1. :( I know the record has been loaded because I can see fields at the body level. Any ideas what I can do to see these lines anyone? Mark

Has the Gross Margin issue been resolved yet? I manage a services company, where revenue is generated from two transactions: <snip> I wouldn't say resolved, however I can now work out the GP on items (including Kits and BOMs) that are on Estimates and Sales Orders using a combination of an ugly hack and an unsupported (and…

Hey Mark, There is no join for members of a kit/BOM. Would be a great enhancement. In the meantime, add a script to the item record that records the members of the kit in a hash-delimited text field and use this to locate all of the items. That is the best that I can think of. Mark Which field tells you what item type you…

I am working on this problem at the moment by using a server side script to add up all the costs of the line items then populate a custom costs field. My current problem is how does one find all the members of a BOM or Kit? I need to do this with nlapiSearchRecord otherwise I will run out of processing points. I see that…

I'm about to go down this route (perhaps unwisely given the previous posts) as we really need to know the Gross Profit of a Sales Order before we can authorise it. Before I get into it I'd like to ask those who have been down this path a few questions about entering/editing a sales order: [LIST] [*]Are the member item…

Ewwwwww! :eek: That is soooo ugly! (No insult to you Mark - you gotta do what you gotta do) Netsuite guys - surely there is a better way? How about giving us a function nlapiSQLselect() for when people get desperate... After all you do let people use ODBC. I can't believe that no one at NetSuite has considered this level…

Hi, Under the Reports Tab and Saved Searches the drop down is still showing old searches which no longer exist. How can I purge this list to show recent searches only? Anything that forces a refresh of the cache will do this for you. One way is: Click on another tab (eg Home), flush your cache (in IE: Tools -> Internet…

When you sign up it must be the same address, however I have since changed my NS address and want to change my forum address. I can't which is very frustrating. I also haven't had any replies from private messages sent to the forum admins.

If it does he or she isn't very active... We could get away with anything... ;)

This will probably do! :D Skyytek White Papers Also, like Jim Underwood, I have never used skyytek services, nor am I associated with them in any way. Just in case anyone was wondering... Mark

Ray After reading this thread I have looked at your whitepapers and rate them! Would you consider copying (or linking) them into the user group? I realise that there may be some IP considerations, however if you don't ask you don't get! Cheers Mark