Hi Anthony, I tried many different criteria including only Sales Orders and I was never able to get close to the values calculated by NetSuite. The solution we've opted for is to turn off the auto-calculate for the reorder point and to calculate this manually in Excel and to periodically update by CSV. This represents more…

Hello, Thanks for the response. In my question I mentioned that I have the preference "Use lead time and safety stock per warehouse" checked. Hence, Safety Stock Level appears for each location and there is only one column and it is not mentioned whether it is for units or days. Suite answer with id: 30675, and the section…

I was able to get around the limitation of account always being 'Accounts Receivable' and isolate the Discount Taken amount by using the 'line sequence number'. I found that 'line sequence number' is 1 when 'Applied to Link Amount' is equal to 'Amount Paid' and 2 when it's equal to 'Discount Taken'. Hence, using a formula…

Thanks very much for your response. I have tried your PHP function, yet the issue still remains with the decimal numbers. They are rounded before the PHP function has the chance to do the formatting. However, for the rate field, the function does indeed work and solves the issue I was seeing with the multi-language.

I will add to the suggestion of setting up the Parent - Child relationship, checking SHOW REMOVE LINK, ALLOW CHILD RECORD EDITING and ALLOW DELETE on the Child record to get a functionality similar to line items on a transaction (ie. add, cancel, insert, remove buttons). Creating a custom transaction type may have been…

I see that in 2.0 the equivalent to recalc() "sublistChanged" does indeed trigger when clicking the Add Multiple button. This seems promising however I'm not able to use it as when the trigger occurs it's as if the lines haven't been added yet. It would be nice to know if someone else got this to work.

Hello Max! Thanks for your response. I had worked on a client side 'validateFieldChange' script and noticed it was being triggered at times when I didn't want it to trigger (ie. when the customer is changed). I thought this may block the system from correctly updating the 'Tax Code' and it was also showing the alert…

NetSuite customer support assisted me on this and showed me how to get it to work. The steps are: 1.Check "Display in Web Store" on item records 2.Change the layout of the Published Saved search to "Standard Dense List Layout" 3.If needed customize the layout: Setup > Site Builder > Layouts Thanks to NetSuite for the…

I have found a simple solution. I have created a template Item that has most of the field I need populated. I then use nlapiCopyRecord instead of nlapiCreateRecord. In most cases the vendor information will be correct but if I need to modify it I have found that it's possible with:…

Hi Ilija, Thanks very much for your response and this confirms what I thought about the 'Dropship Expense Account'. Given that we don't use Intercompany Drop Ships and that this feature is not even in our instance, this account will not be used. Cheers! Matt

Hi Ilija, Thanks for your response. These are Non-Inventory Items for Resale given they will be drop shipped. Yes, we need to hit both income and expense accounts with these items. I like the idea of using a 'dummy' item and to have the custom record hold the variations (or item specs in this context). Given that the price…

Does anyone know if it's possible to get the customer name on the statement lines? We need this because we're using consolidated statements and we would like to know what is the child customer on each line. I tried finding the field id by adding it in the Advanced Pdf wysiwyg tool and it's not possible to select line…