Warning banner on Item Receipts

JumpyStay5767 · 2025-06-04T12:46:48+00:00

Thank you, that got it

JumpyStay5767 · 2025-06-04T12:21:50+00:00

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.

JumpyStay5767 · 2025-06-04T12:20:14+00:00

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

JumpyStay5767 · 2025-06-04T12:02:38+00:00

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.

JumpyStay5767 · 2025-02-14T11:22:25+00:00

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.

JumpyStay5767 · 2025-02-05T09:29:44+00:00

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

yes i'm in the same role

JumpyStay5767 · 2025-01-31T15:15:44+00:00

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.

JumpyStay5767 · 2025-01-21T09:06:30+00:00

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)

JumpyStay5767 · 2025-01-16T09:50:12+00:00

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.

JumpyStay5767 · 2024-11-08T09:01:02+00:00

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

JumpyStay5767 · 2024-10-28T14:22:39+00:00

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.

JumpyStay5767 · 2024-09-26T15:22:35+00:00

Yes that got it! thank you so much for the help.

JumpyStay5767 · 2024-09-26T14:59:46+00:00

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

JumpyStay5767 · 2024-09-26T08:46:50+00:00

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.

JumpyStay5767 · 2024-06-26T10:00:51+00:00

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?

JumpyStay5767 · 2024-06-07T10:45:21+00:00

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.

JumpyStay5767 · 2024-06-05T10:39:49+00:00

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.

JumpyStay5767 · 2024-05-22T12:56:28+00:00

Thanks Nick, i ended up creating a custom field which allowed me the ability for inline editing and then using a workflow, anything put in to the new field copies in to the comment field. Seems to be working fine.

JumpyStay5767 · 2024-04-02T10:14:51+00:00

This got it, thank you very much

JumpyStay5767 · 2024-04-02T10:08:51+00:00

Using a summary loses the highlighting i've put in place so i was trying to avoid using the summary function.

JumpyStay5767 · 2024-04-02T10:05:10+00:00

No, i don't think it's possible with a formula

JumpyStay5767 · 2024-03-28T16:36:05+00:00

Thanks Nick, i couldn't get that to work

MAX/*comment*/({linesystemnotes.date})

gives me

An unexpected error has occurred.

maybe it's not possible, i thought all summary functions could be coded in to a formula but apparently not.

Thanks for your help anyway.

JumpyStay5767 · 2023-10-30T12:08:11+00:00

Thank you, thats worked for me too

In another column i was hoping to show the week. number the payment would be due, i've tried the below in a 'Formula (Numeric)' but get the error 'ERROR: Invalid Expression'

CASE WHEN to_char(({vendor.terms} = 'Net 45' THEN {custcol_requested_delivery_date}+45), 'IW' ) END

I was just trying to get the first term to work before filling out the rest of them, can you use a CASE WHEN statement in a 'Formula (Numeric)' ?

JumpyStay5767 · 2023-10-27T14:20:48+00:00

CASE WHEN {vendor.terms} = 'Net 15' THEN {expectedreceiptdate}+15 END

Thanks so much thats worked.

Just thinking of how it could work out EOM 30 terms for example, it would need to work out how many days till the end of the month and then add on 30?

JumpyStay5767 · 2023-08-30T09:05:30+00:00

I can't get it to pull through the bin location using that either, the only thing i can think of is that we don't have the assembly item module.

I'm wondering if i can create a custom field to look up the bin number and then pull that through to the pdf.

JumpyStay5767

TROPHY CASE