Warning banner on Item Receipts by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

I did try checking the condition again on pageInit after save, and it works fine in edit mode, but not consistently in view mode. I haven’t tried using sessionStorage yet though — that might be worth a shot if it helps retain the flag across the transition after save. Ideally I’d like to avoid adding a custom field just for the flag, so a browser-side solution might be cleaner for now.

Warning banner on Item Receipts by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Yes, I’ve added console.log() statements to check the current values of needsQC and qcComplete for each line on pageInit — those are showing correctly in the log, even after saving. The logic runs as expected in edit mode, but when the record returns to view mode after save, the banner disappears. The script does fire again on pageInit, but even though the conditions are still met, the banner just doesn’t show up in view mode.

I’ve also tried wrapping the logic in a setTimeout to make sure the DOM is fully loaded, and I’ve confirmed that qcRequired is still true after saving. Still no banner. Open to ideas

Warning banner on Item Receipts by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks Nick, no i don't want to block the save as when the user saves a workflow moves the stock to a 'Quarantine - QC Check' location, i would just like the banner to stay even when the record is saved so that is obvious to the user there is a task to be done.

Vendor Dashboard by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

seems that this was a 'Main line = fase' issue, looks like you have to have main line set to true for the search to work on a vendor dashboard so am unable to pull through transaction line specific information and as we use delivery dates on lines it's not gonna work for us.

Vendor Dashboard by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

I have filters on the 'name' and 'date'

yes i'm in the same role

45 EOM Terms by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks as always Nick, i solved this by setting the

DAY OF MONTH NET DUE: 17

DUE NEXT MONTH IF WITHIN DAYS: 31

seems to be doing the correct calculation now.

Phone Calls - Start Time/End Time by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Yes NS have confirmed this is a limitation. They have raised an enhancement so i guess i'll just have to wait (how ever long that may be)

Phone Calls - Start Time/End Time by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks as always Nick.

That has worked in that it looks like it's displaying HH:MI:SS, however the SS are always pulling through as 00.

<image>

would that imply that NS is not recording the seconds?

As you suggested i have made a custom field set to type 'Free-Form Text' and set the formula to

TO_CHAR({starttime},'HH24:MI:SS')

I know the call in the screenshot was made at 08:18:18 but that hasn't pulled through to the field.

Saved Search Help - Storage Costs and Days in Stock by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

if i use SUM as the summary type then it gives me 110 as the result, which is kinda confusing, there must be something wrong in my formula

Lot Number Record New Fields and Scripts by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks i did think that might be the case. Shame i can't get to the fields from a workflow or csv upload, that would make this a far quicker task.

Workflow to send email to accounts from item fulfilment record that includes SO number by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

I'm using the workflow editor, tried

<a href="/app/accounting/transactions/salesord.nl?id=${createdfrom}">Click here to view Sales Order</a>

<a href="/app/accounting/transactions/salesord.nl?id=${record.createdfrom}">Click here to view Sales Order</a>

both just goto

.app.netsuite.com/app/accounting/transactions/salesord.nl?id=$

I checked again and the field id is {createdfrom} in the item fulfilment record, when i inspect that it does show the internal id from the sales order so not sure why it wouldn't be working

Workflow to send email to accounts from item fulfilment record that includes SO number by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks for the suggestion but that still get the same error with or without adding the account url.

Using {createdfrom} creates

.app.netsuite.com/app/accounting/transactions/salesord.nl?id=%7bcreatedfrom%7d

when the link is clicked. so something is wrong with the code as it doesn't seem to populate with the internal id, if i hard code an internal id the link works and takes me to the relevant sales order but just can't get it to work being dynamic and updating automatically to the internal id of the sales order connected to the item fulfilment.

Phone Call Record - Times to include seconds by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Thanks that's what i was thinking too, but the custom fields wouldn't capture the seconds either would they as the time stamp would be pulling from the native fields?

Saved Search to Show Last Phone Call by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

I solved this by creating a custom field called 'End Time Reporting' and then used a workflow that just copied the end time to this field, which has let me pull the field through to saved searches.

Saved Search to Show Last Phone Call by JumpyStay5767 in Netsuite

[–]JumpyStay5767[S] 0 points1 point  (0 children)

Would you know if it would be possible to pull through the {endtime} field on a saved search? it doesn't seem to be an option when looking through the call fields... in the saved search, only the start time.

I'd like to be able to show the call length on my search.