My Stuff
Comments
-
How about attaching a saved search as a sublist on the Item Record? Mark.
-
Have you checked the 'Show Totals' in the Results tab?
-
Transaction Search Criteria; Type = Item Fulfilment Results; Tracking Numbers
-
Set it as: Field = Formula (text) That should help.
-
Excellent - now using "to_char( {trandate}, 'IW' )" and it works just great. If I'm only using it on the results page of a Saved Search, I assume I don't need to worry about the security workaround? Mark.
-
Thanks for this, I have managed to get this far - I also limit the criteria to the Inventory Asset GL to exclude Tax amounts. However, also obtaining total sales with which to compare this figure within the same results is proving to be a problem. Thanks. Mark.
-
Thanks, this works great. Never used 'decode' before - I can pretty much figure out what it's doing, but what's the purpose of the zero at the end? Thanks again for your help with this.
-
OK, I understand it now. Nice powerful formula. Thanks very much for your help.
-
There is a Setup permission called "Override Period Restrictions" - this will allow you to post into closed periods. Full Access and Administrator have this built-in.
-
The NS hierarchy connects the Item Fulfilments to the Sales Order, and then the Sales Order to the Invoice. To get the serial number back onto the Sales Order, and then carried through onto the Invoice once the SO is Billed, you're going to need a script to update the SO line once the goods have shipped - the only…
-
Thanks, that looks really useful. I'm currently trying to do something very similar by using the Send Email action in the same workflow. Just struggling right now to get the Task ID to share between actions. Set up a custom field to store it in, but this seems to be storing the Task title rather than a number/ID.
-
This is only for Item Receipts and Item Fulfillments. The value of the field is then pulled from the Sales Order or Purchase Order - and becomes a view only field. You won't be able to select it unless the pairing transaction type is also selected.
-
You should also be able to bring them into a Workflow with an Action Script too.
-
Well, that's reassuring! Well to be perfectly honest - we always found that not knowing exactly what would appear where on the page - depending whether the field had any content of not, was never really working for us. Although setting up dedicated elements for each field took some time, the end result was much more…
-
Have you tried just using {type}?
-
What's the view on actually hosing the form? As we no longer use the NS Website, we don't have the web module active - and so can't host this on a regular page. So - we've been looking at using a Online Form, which appears still to be available for us to use. Are there going to be any issues we need to watch our for…
-
I had exactly the same issue, and the only reliable way I was able to fix is, was to stop using the <body> element, and create custom elements for each field I wanted to display - this then assures fixed positioning regardless of content.
-
Can this now be done in a Workflow action?
-
Should have guessed! Thanks for confirming my worst suspicions! Mark.
-
One possible work-around is to use the Address LABEL field. You could add a prefix or sufix of [OH] meaning "On Hold". Then filter your searches for Customer addresses where "Label Does Not Contain '[OH]'. Hope this helps. Perfect! Excellent suggestion. Now to see if we can do this by CSV :)
-
That's the point I've been busy trying to figure out. The custom record won't let me select anything in the Parent Records tab. Is there somewhere else I should be selecting this? Thanks! Mark
-
Ah, that's the missing step! Thanks very much. I really must write this down ready for next time! Mark.
-
When you went back to move all the fields, did you use custom subtabs? My custom fields are on custom subtabs and they do not appear in the drop down on the move items between subtabs screen. I had the same issue, nothing was appearing in the setup for these custom tabs - but after a few hours, they magically appeared! :(
-
Netsuite isnt flexible enough Good to see an honest reply from a Netsuite Employee :)
-
This could probably be easily managed with a Custom WorkFlow. Depends how complex your rules for apply are.
-
Many thanks, much appreciate the time you've all spent on this. This works great now. Mark.
-
I'm using to_char because I'm dealing with a date variable. The error is "ERROR: Field Not Found" The "customer.custentityuk_premuim_shipping_expiry" on it's own works fine, so I know that field's being found. However, neither {dcreated} or {datecreated} on their own work.
-
Following on from this, I'm currently using the above concepts to create a Custom Field which will allow a Sales Order transaction to be selected from within a case. The field is pretty much set up as above (but just set to apply to cases) However, rather than just listing the relevant customer's Sales Orders, it's listing…
-
These give me the following results (within a Saved Search) Formula (numeric) -> {customer.custentityuk_premuim_shipping_expiry} - {datecreated} 364.672453703703703703703703703703703704 Formula (numeric) -> {customer.custentityuk_premuim_shipping_expiry} ERROR: Invalid Expression Formula (numeric) -> {datecreated} ERROR:…
-
Perfect! Thanks very much. If I want to then move this one stage forwards, and allow a RA to be created from the case - is this possible? Mark.