We also seem to be having issues in the UK since this maintenance was done. Performance generally seems worse than it was, portlets take a while to load, forms with scripts slow. One of our scripts has a a wait error, sometimes fails with undefined error, sometimes doesnt. NetSuite have logged a defect fix that doesn't…

Thanks Jack that does the job perfectly as we wanted, we were not far off, I think somehow we messed the join up, but its functioning now in our sandbox. Thanks,

Hi, In the end support recommended a slightly different formula which seems to work for me: Posted for reference: CASE WHEN {transaction.location} = 'Warehouse : Name' AND {transaction.type} = 'Sales Order' THEN {transaction.Quantity} ELSE 0 END Thanks for all the assistance

Hi Ivy, I ran the report above and I am now getting 65145 lines returned for the last month fulfilled from that location, which is more along the lines of what I would expect. I dont understand why these will not show on our report? I will have to split these down into 2 reports I think to get the data. I wonder if support…

Hi Ivy, Thanks again for this. Not sure if I have something wrong somewhere but I am still only seeing the values for the 1st location. The values for the 2nd location are all zero and I know there must have been some sales orders in this period from that location. Will I need to separate the reports? Details here: See…

Hi Ivy, I noticed today this doesn't seem to be showing any data for the other location even for items I know must have sold during that period. I am not sure if I have my locations correctly specified, is it possible to do it via location id to avoid errors in the formatting of the location? For example my location is a…

Hi Ivy, thus appears to be perfect, just the job. I will do some testing a feedback shortly. Thanks so much :)

Yes the same result occurs, not data for the second location, and incorrect data if the formula is removed from the criteria. I do not know if its possible to somehow include this in the formulas to filter the correct sales orders, and whether it is possible to also do returns? Thanks so much :)

The criteria below~: the only difference was the item checkbox to only show items stocked in that warehouse.

Hi Ivy, For example line 1 is the following: This is without the criteria set This is with the criteria set The version with the criteria set has the correct sales order figures for the item, however no data is showing for the second location. The second location is shown on the 1st capture but the data is incorrect. The…

Hi Ivy, Apologies I meant if I try to show 2 locations on the same report. If I have the criteria: Formula (Numeric): CASE WHEN {inventorylocation} = {transaction.location} THEN 1 ELSE 0 END set I can only see one location stock level. If I remove this I can see all data but the sales orders figure are incorrect. See…

Hi Ivy, Thank you for this. I did try to add this which works great for just one location but when I add to locations it doesn't seem to work as the stock quantity in the second location is showing zero. If I remove the criteria: Formula (Numeric): CASE WHEN {inventorylocation} = {transaction.location} THEN 1 ELSE 0 END It…

Hi, Thanks Mikko, in the end I was not able to get this to work as a workflow. I ended up getting a script developed for the purpose. Thanks,

HI Workflow setup as follows: By fulfill, I would like to create an item fulfillment and set it to shipped. The system will automatically bill after shipping. Record Type Transaction (Sales Order) Description - Inactive No Release Status Testing Initiation Scheduled Saved Search Filter EB Website Outstanding Collectors…

A new Netsuite Admin moved into Netsuite from another ERP system. Based in the UK Love a real ale and the Football (Soccer)

Hi @"Erick Dela Rosa-Oracle" I have now removed those items, it was from a comment section I must have forgot to clear up. I can now upload the script, however, when I try to run it nothing appears to happen? Thanks, Myren

Hi @"Erick Dela Rosa-Oracle" I have take a screenshot of the contents of the script file, please see attached.

Hi @"Erick Dela Rosa-Oracle" I did not managed to upload the script, when I try to upload it I get the following Error The records are set as follows: Not too sure what is happening, I did wonder if I was missing some entry point or something as I have not fully got my head around these yet.

@"Pauline Joy Cac-Oracle" and @"Erick Dela Rosa-Oracle" I tried to put the following script together, as mentioned Suitescript is not my strongest! function eb_skusource() { var currCust = nlapiGetFieldValue('custrecord_eb_pack_itm_cus'); var currItem = nlapiGetFieldValue('custrecord_packitem_item'); if (currCust != '' &&…

Hi Erick, Thanks for this information, I am not certain on the syntax that I would need to achieve this in practice as Suitescript is not my strong point. My name is Myren, Thank you for your assistance on this matter.

Hi Pauline, I did give this a try, however I do not seem to be able to get it to work as expected. Should the record A be sourced automatically? Currently I have to manually chose it from the list, then it populates the customer code. Thanks,

Thank you Pauline I will give this a try and see if it will work in our situation. Thanks,

Hi Pauline I wondered if there is any progress on this? I tried to use sourcing, I tried to write a case statement but not sure if I have the correct syntax to reference the custom records and custom fields within, or even whether this is possible? It returns a field not found error. I used the syntax…

Hi Pauline, I wondered if there was any progress on any possibilities for this at all? Thanks

Hi Erick, I finally got a chance to look at this and try to implement in our Sandbox. I made the following JS file which as far as I can tell is similar to the example. Can you advise on where I maybe going wrong: /** * @NApiVersion 2.0 * @NScriptType ClientScript * @NModuleScope SameAccount */ define(['N/url'],…

@"Erick Dela Rosa-Oracle" Thanks so much, that is fantastically helpful to gain an understanding of how this fits together.

Hi Erick, Thanks for your reply. Are you able to point me in the direction of any example on how this might be achieved? Thanks,

Hi Paul, I think that when using the Email templates they need to be related to fields on the transaction in question. I am not certain there is a join between, the fields you mention. One option if the fields are not on the IF record is to create a new custom field which can replicate the values you require from elsewhere…

Hi John, I think there maybe a Netsuite issue. We are having strange behaviour with Bin Transfers since this morning. I have logged this with Netsuite and they attached it to a defect. Thanks

In the end I created a saved search and set this to email out to the representatives each day. It could also be added to a dashboard. It works to help track these emails despite being far from ideal.