PaulFleetwood Silver Medal

Thanks Robert - I assume WMS is a 'paid for' addition to NetSuite? We don't (currently) need handheld devices or bar code scanners - we just want to carry out an inventory count across multiple bins in bin number order. Why is this so difficult?

I'm not sure what that screen is you are showing, but our bin record looks like this: Is that the 'WMS' module I have heard mentioned - maybe we have not been sold the correct product..... I have now confirmed that one part of the system sorts by the Internal ID of the bin, and the other by bin name It would be annoying if…

I have been fighting with this since we went live. There is no way (either by UI or programmatically) to change the Printed Ticket flag. The only action that will reset the flag is to fulfil the order (and you can then delete the fulfilment afterwards). The whole picking ticket process using NetSuite is grossly inadequate…

Thanks Chris - really helpful (as always!) I have today found out these situations are further complicated by the fact that the supplier send in their invoices on the day of delivery, and so often these issues are discovered after the Bill has been entered on NetSuite (which I think prevents us from editing the receipt). I…

Even with DKIM, we still have problems with this. The strangest one is that customers get the monthly statement by email, but then tell us they didn't receive some (or many) of the invoices sent in the previous month. I have all the DKIM reports sent to me to analyse, and although some show some errors, they seem to say…

Hi I don't suppose you would be able / prepared to share that script? I was thinking of creating something similar......

Thanks Robert - I've added a support case for us to that issue

Do we know if this is limited to 2019.2? We are not updated yet, but I have had 2 reports of these errors here today also? It may just be a coincidence, but then again it may not be..... Is the fix mentioned above only for 2019.2?

No, we are not using rfsmart…. I may need to investigate that if it could improve things

In case anyone else is looking at this in future, I think I now have a working solution for Picking Tickets showing incorrect number of items for partial fulfilments (based on a combination of custom fields, Advanced PDF templates and scripts created by a combination of 3rd party contractors and NetSuite Advanced Solutions…

In case anyone else is looking at this in future, I think I now have a working solution (based on a combination of custom fields, Advanced PDF templates and scripts created by a combination of 3rd party contractors and NetSuite Advanced Solutions team. It's probably too complex to document here, but happy to speak to…

There isn't one - from NetSuite Support: Since the ability to reset the packing slip print flag is not yet possible, I will be filing an enhancement request for you.

Confirmed from NetSuite support: Since the ability to reset the packing slip print flag is not yet possible, I will be filing an enhancement request for you I was hoping to look at another option - maybe 'closing' the fulfilment and then creating a new one using a 'copy' function - but it appears you can't close a…

Thanks Chris Yes we have that option enabled, and I recently increased the list of reasons when I found them (by accident whilst looking for something else) (Out of interest - do you know where the 'memo' field data that you enter on the popup goes? - I can't see that in the deleted items audit log?) Anyway, my current…

Thanks for this - that's a great idea to use a workflow to update the field based on a separate custom field, and make that updateable in the inline edit view.

We've partially worked round this by using scripting to copy the relevant data from the fulfilment record into custom fields in the Sales Order. This still can cause issues though, as the Sales Order may have multiple fulfilments and you only want to print some of them...... I also need to work out where the system flag…

OK Thanks - I guess we'll need to go through the SuiteAnswers articles and videos to understand how we should be processing these variances.

I have been discussing this with our Head of Finance - legally we can only invoice for goods when they are delivered, and the invoice should be dated for the delivery date (as that is the first day that the customer is liable for the goods). How do we make NetSuite do this?

Thanks - I have checked we are not using Billing Schedules. I think the billing date defaults to the date of the Sales Order - I did some testing yesterday and confirmed this (but I couldn't replicate the problem with an invoice pre-dating the order). It is possible this was caused by user error, so I will need to closely…

Thanks Robert - any help Oracle can provide would be appreciated. I am looking at doing the scripting training course, and I also have a contact who has built a script for us already to resolve some of our issues. I'm just amazed that this has been sat as an enhancement for 8 years and not resolved. I am very concerned by…

Thanks - I still got the error using the IF statements above, but I managed to get past it using: <#if item.quantitypicked != ""> However, it would seem that the field is always empty in FreeMarker - even if I display it as a simple field: Picked: ${item.quantitypicked} I get nothing - and I've double checked the XML for…

OK, I am speaking to my IT partner about DMARC Thanks

OK thanks for looking at this - I'll keep looking for solutions

However, I'm not sure if these values are numeric or string? Both of these give an error: <#assign commlesspick=item.quantitycommitted?number - item.quantitypicked?number> Can't convert this string to number: "" The blamed expression: ==> item.quantitycommitted?number [in template "template" at line 238, column 23] ----…

That's a really useful tip for the XML - thanks!!

Yes, you need to use Workflow to lock down individual fields - or alternatively I tend to do the opposite: set all the sensitive fields to disabled in the form, and then use workflow to revert them the normal for certain roles. If you need any specific examples or help just let me know exactly what you're trying to do.....

Thanks - really helpful

Thanks for this - I will look to do some testing on this. Unfortunately the number of pages varies, so I can't hard code the total number. Is it possible to use Numerical BuiltIns on the totalpages variable? If I could divide the number of totalpages by 2 then I think this would be correct??

Thanks - that is a useful document. I think this is the bit I need: But I'm not sure how to format this' I currently have a simple page break: <pbr/> Does anyone have any examples of how to set the pagenumber attribute within this?

I agree - using an external contractor is not a matter of cost, but of timing. I spoke a consultant who replied from this post on Thursday morning to discuss the requirements. By 8pm Thursday evening he had built the script we needed. I will still look to complete the training so that I can manage and support this moving…